Error reported on page /product_info.php

MySQL error: 5 - Out of memory (Needed 4192272 bytes)

SELECT DISTINCT p.products_id, p.products_image_med, pd.products_name FROM (products p LEFT JOIN specials s using(products_id) ), products_description pd, products_to_categories p2c, categories c WHERE p.products_status = '1' and p.products_ordered > 0 and IF(s.status=1,s.specials_new_products_price,p.products_price) >= '10.00' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '4' in (c.categories_id, c.parent_id) ORDER BY p.products_ordered desc, pd.products_name limit 10

[TEP STOP]

Saturday, February 04, 2012 12:34