Warning: mysql_query(): Unable to save result set in /home/soccerplusnew/public_html/system/database/mysql.php on line 22Notice: Error: MySQL client ran out of memory
Error No: 2008
SELECT p.product_id,(SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.price AS price 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_special ps ON (p.product_id = ps.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id in /home/soccerplusnew/public_html/system/database/mysql.php on line 50
Fatal error: Out of memory (allocated 4980736) (tried to allocate 37662650 bytes) in /home/soccerplusnew/public_html/vqmod/vqmod.php on line 389