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_3f7_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_to_blog r2b ON (p.record_id = r2b.record_id)
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) WHERE
pd.language_id = '2' AND r2b.blog_id='1' AND p.status = '1'
AND NOW() BETWEEN p.date_available AND p.date_end
AND p2s.store_id = '0' GROUP BY p.record_id ORDER BY p.date_available DESC LIMIT 0,5 in /var/www/www-root/data/www/diamebel-opt.ru/system/database/mysql.php on line 63