Notice: Error: Out of resources when opening file '/var/tmp/#sql_63c1_0.MAI' (Errcode: 24)
Error No: 23
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, p.price, p.image, UNIX_TIMESTAMP(r.date_added) as date_added FROM review r LEFT JOIN product p ON (r.product_id = p.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN category_path cp ON (cp.category_id = p2c.category_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p2s.store_id = '0' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND cp.path_id=166 Group By r.review_id ORDER BY r.date_added desc LIMIT 6 in /home/woollen-wear/public_html/system/database/mysqliz.php on line 53