<b>Warning</b>: mysql_query(): Unable to save result set in <b>/var/www/www-root/data/www/diamebel-opt.ru/system/database/mysql.php</b> on line <b>23</b><b>Notice</b>: Error: Disk full (/tmp/#sql_4281_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br />Error No: 1021<br />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 <b>/var/www/www-root/data/www/diamebel-opt.ru/system/database/mysql.php</b> on line <b>63</b>