Notice: Error: Got error 28 from storage engine
Error No: 1030
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_to_blog r2b ON (p.record_id = r2b.record_id AND p.status = 1) LEFT JOIN record_description pd ON (p.record_id = pd.record_id) LEFT JOIN record_date redata ON (p.record_id = redata.record_id) LEFT JOIN record_to_store p2s ON (p.record_id = p2s.record_id) WHERE pd.language_id = '1' AND p.customer_group_id = '1' AND p.status = '1' AND NOW() BETWEEN p.date_available AND p.date_end AND p2s.store_id = '0' AND p.article_view!='3' AND p.article_view='1' GROUP BY p.record_id ORDER BY p.sort_order DESC LIMIT 0,3 in /var/www/telemed.vot.by/system/database/mysql.php on line 50