Notice: Error: Lost connection to MySQL server during query
Error No: 2013
(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 comm.parent_id = '0' AND rec.status = '1' AND comm.status = '1' AND c.blog_id IN (3) AND c.customer_group_id = '1' GROUP BY commentid) ORDER BY commentid DESC LIMIT 0,5 in /var/www/sporte/system/database/mysql.php on line 27