<b>Notice</b>: Error: Disk full (/tmp/#sql_3fd_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br />Error No: 1021<br />
(SELECT DISTINCT  SQL_CALC_FOUND_ROWS
			cd.name as blog_name, rd.name as record_name,

			comm.comment_id as comment_id,
			comm.record_id as record_id,

			comm.parent_id as parent_id,
			comm.customer_id as customer_id,
			comm.author as author,
			comm.text as text,
			comm.rating as rating,
			comm.rating_mark as rating_mark,
			comm.status as status,
			comm.date_added as date_added,
			comm.date_modified as date_modified,

			comm.text as text, comm.author as author,
			comm.date_added as date_available,
			comm.comment_id as commentid,
			rec.viewed as record_viewed, comm.rating as rating, c.blog_id, rec.image,
			(SELECT AVG(rating) AS total FROM comment r1
				WHERE
				r1.record_id = rec.record_id
				AND
				r1.status = '1'
				AND
				r1.rating_mark = '0'
				GROUP BY r1.record_id) AS rating_avg,
			(SELECT COUNT(*) AS total FROM comment r2
				WHERE
				r2.record_id = rec.record_id
				AND
				r2.status = '1'
				GROUP BY r2.record_id
				) AS record_comments,
				'blogs' as type
			FROM blog c
			LEFT JOIN blog_description cd ON (c.blog_id = cd.blog_id)
			LEFT JOIN blog_to_store c2s ON (c.blog_id = c2s.blog_id)
			LEFT JOIN record_to_blog r2b ON (c.blog_id = r2b.blog_id)
			LEFT JOIN record rec ON (rec.record_id = r2b.record_id)
			LEFT JOIN record_to_store r2s ON (r2s.record_id = rec.record_id)
			LEFT JOIN record_description rd ON (rec.record_id = rd.record_id)
			LEFT JOIN comment comm ON (rec.record_id = comm.record_id)

            WHERE
			cd.language_id = '1'
			AND rd.language_id = '1'
			AND c2s.store_id = '0'
			AND r2s.store_id = '0'
			AND c.status = '1'
			AND rec.status = '1'
			AND comm.status = '1'
			AND	c.blog_id IN (5)  AND c.customer_group_id = '1'	GROUP BY commentid)  UNION 
			(SELECT DISTINCT 
			cd.name as blog_name, rd.name as record_name,

			comm.review_id as review_id,
			comm.product_id as product_id,

			comm.parent_id as parent_id,
			comm.customer_id as customer_id,
			comm.author as author,
			comm.text as text,
			comm.rating as rating,
			comm.rating_mark as rating_mark,
			comm.status as status,
			comm.date_added as date_added,
			comm.date_modified as date_modified,


			comm.text as text, comm.author as author,
			comm.date_added as date_available,
			comm.review_id as commentid,
			rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
			(SELECT AVG(rating) AS total FROM review r1
				WHERE
				r1.product_id = rec.product_id
				AND
				r1.status = '1'
				AND
				r1.rating_mark = '0'
				GROUP BY r1.product_id) AS rating_avg,

			(SELECT COUNT(*) AS total FROM review r2
				WHERE
				r2.product_id = rec.product_id
				AND
				r2.status = '1'
				GROUP BY r2.product_id
				) AS record_comments,

				'categories' as type
			FROM category c
			LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
			LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
			LEFT JOIN product_to_category r2b ON (c.category_id = r2b.category_id)
			LEFT JOIN product rec ON (rec.product_id = r2b.product_id)
			LEFT JOIN product_to_store r2s ON (r2s.product_id = rec.product_id)
			LEFT JOIN product_description rd ON (rec.product_id = rd.product_id)
			LEFT JOIN review comm ON (rec.product_id = comm.product_id)

			WHERE
			cd.language_id = '1'
			AND rd.language_id = '1'
			AND c2s.store_id = '0'
			AND r2s.store_id = '0'
			AND c.status = '1'
			AND rec.status = '1'
			AND comm.status = '1'
			AND c.category_id IN (5 , 1 , 22 , 19 , 28 , 27 , 3 , 6 , 33 , 26 , 4 , 2 , 24 , 10 , 34 , 31 , 12 , 9 , 11 , 25 , 15 , 13 , 16 , 30 , 35 , 7 , 14 , 8 , 21 , 23 , 29 , 17 , 18 , 20 , 32 )
			 GROUP BY commentid
			) ORDER BY date_available DESC LIMIT 0,3  in <b>/var/www/like/system/database/mysql.php</b> on line <b>50</b>