Warning: mysql_query(): Unable to save result set in /var/www/www-root/data/www/diamebel-opt.ru/system/database/mysql.php on line 23Notice: Error: Disk full (/tmp/#sql_4281_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Error No: 1021
SELECT p.*,
(SELECT COUNT(*) AS total FROM oc_comment rc
WHERE rc.record_id = p.record_id AND rc.status = '1' GROUP BY rc.record_id) AS comments,
(SELECT AVG(rating) AS total FROM oc_comment r1
WHERE r1.record_id = p.record_id AND r1.status = '1' GROUP BY r1.record_id) AS rating
FROM oc_record p
LEFT JOIN oc_record_description pd ON (p.record_id = pd.record_id)
LEFT JOIN oc_record_to_store p2s ON (p.record_id = p2s.record_id) LEFT JOIN oc_record_to_blog p2c ON (p.record_id = p2c.record_id) WHERE pd.language_id = '2'
AND p.status = '1'
AND p.customer_group_id = '1'
AND NOW() BETWEEN p.date_available AND p.date_end
AND p2s.store_id = '0' AND p2c.blog_id = '3' GROUP BY p.record_id ORDER BY p.sort_order ASC LIMIT 0,100 in /var/www/www-root/data/www/diamebel-opt.ru/system/database/mysql.php on line 63