Ismeretlen hiba történt...
Got error 28 from storage engine
SELECT
`advertisements`.*,
CASE WHEN `image`.`cropped_filename`!='' THEN `image`.`cropped_filename` ELSE `image`.`filename` END as `pc_image`,
CASE WHEN `image_mobile`.`cropped_filename`!='' THEN `image_mobile`.`cropped_filename` ELSE `image_mobile`.`filename` END as `mobile_image`
FROM
`advertisements`
LEFT JOIN
`attachments` as `image` ON `image`.`item_id`=`advertisements`.`id` AND `image`.`module`='advertisement_slider'
LEFT JOIN
`attachments` as `image_mobile` ON `image_mobile`.`item_id`=`advertisements`.`id` AND `image_mobile`.`module`='advertisement_mobilslider'
WHERE
`advertisements`.`type`='slider' AND
`advertisements`.`active`=1 AND
`image`.`id` is not null AND
/*`image`.`cropped_filename` != '' AND*/
(CURRENT_TIMESTAMP BETWEEN
`advertisements`.`valid_from`
AND `advertisements`.`valid_to`) AND
`advertisements`.`page_urls` LIKE '%"/indextop"%'
ORDER BY RAND()