Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/u1293/public_html/system/database/mysql.php on line 21Notice: Error: Query execution was interrupted
Error No: 1317
SELECT p.product_id AS product_id , (ABS(p.price-920)) AS new_price , (SELECT COUNT(*) AS total FROM order_product op WHERE op.product_id = p.product_id) AS orders , p.viewed AS viewed , (SELECT ROUND(IFNULL(AVG(r1.rating), 0)) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1') AS rating , (SELECT COUNT(r2.review_id) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1') AS reviews , (p.manufacturer_id=0) AS manufacture , p.date_added AS date_added FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p2c.product_id = p.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.quantity > 0 AND p2s.store_id = '0' AND p2c.category_id = '105' ORDER BY new_price ASC, orders DESC, viewed DESC, rating DESC, reviews DESC, manufacture DESC, date_added DESC LIMIT 20 in /home/u1293/public_html/system/database/mysql.php on line 49