Notice: Error: Disk full (/var/tmp/#sql_5197_0); waiting for someone to free some space...
Error No: 1021
SELECT p.*, (SELECT COUNT(*) AS total FROM 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 comment r1 WHERE r1.record_id = p.record_id AND r1.status = '1' GROUP BY r1.record_id) AS rating FROM record p LEFT JOIN record_description pd ON (p.record_id = pd.record_id) LEFT JOIN record_to_store p2s ON (p.record_id = p2s.record_id) LEFT JOIN 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 = '1' GROUP BY p.record_id ORDER BY p.date_available DESC in /home/admin/web/bug-spy.ru/public_html/system/database/mysql.php on line 50