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_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/hdmap.megamag.by/system/database/mysql.php on line 50