viwoCDM Error: Got error 28 from storage engine
SELECT t1.id,t1.category_id,t1.location_id,t1.type,t1.location,t1.zip,t1.city,t1.street,t1.house_number,t1.hideaddress,t1.lat,t1.lng,t1.marker,IFNULL(t7.datefrom,t1.datefrom) as datefrom,t7.dateto,t1.preferred,t6.title,t6.lead,t6.description,t6.subtitle,t4.id as imageId, t4.dir as imageDir,t4.filename as imageFile,t4.width as imageWidth,t4.height as imageHeight FROM `app_menu` as t2 INNER JOIN `app_data_menu` as appdmenu ON t2.`id` = appdmenu.`category_id` AND t2.desktop = '1' AND t2.public = '1' AND ( t2.sub_menu = '13' OR t2.sub_menu REGEXP '^13$|^13_' ) INNER JOIN `app_data` as t1 ON t1.`id` = appdmenu.`data_id` INNER JOIN `app_data_lang` as t6 ON t1.id = t6.data_id AND t6.lang = 'hu' INNER JOIN ( SELECT data_id,MIN(datefrom) as datefrom,MIN(dateto) as dateto,COUNT(data_id) as dateCount FROM `app_data_datetime` WHERE (`datefrom` >= NOW() OR (`datefrom` <= NOW() AND `dateto` >= NOW())) GROUP by data_id ORDER by `datefrom` ASC ) as t7 ON t7.data_id = t1.id LEFT JOIN `app_data_res` as t3 ON t1.id = t3.data_id AND t3.type = 'image' AND t3.leader = '1' LEFT JOIN `app_res` as t4 ON t4.id = t3.res_id LEFT JOIN `app_res_lang` as t5 ON t5.id = t3.res_id AND t5.lang = 'hu' WHERE t1.public = '1' AND FIND_IN_SET('hu',t1.lang) > 0 AND t1.type IN ('location', 'data','special-event-details','special-program-full') AND t1.deleted = '0' AND (t1.datefrom <= NOW() AND t1.dateto >= NOW() OR t1.datefrom >= NOW()) GROUP BY t1.`id` ORDER by t1.preferred DESC,t7.datefrom ASC LIMIT 4