Ismeretlen hiba történt...
Got error 28 from storage engine
SELECT
`profile_offers`.*,
`attachments`.`cropped_filename` as `thumbnail`,
CONCAT('/', `business_profiles`.`url`, '/', 'ajanlatok/', `profile_offers`.`url`) as `url`,
business_profiles.`title` as `profiletitle`
FROM
`profile_offers`
LEFT JOIN
`attachments`
ON `attachments`.`module`='picture_offer_thumb' AND `attachments`.`item_id`=`profile_offers`.`id` AND `attachments`.`cropped_filename`!='' AND `attachments`.`cropped_filename` is not null
LEFT JOIN
`business_profiles`
ON `business_profiles`.`id`=`profile_offers`.`profile_id`
WHERE
`profile_offers`.`active`=1 AND `profile_offers`.`created` > (NOW() - INTERVAL 1 MONTH)
AND `attachments`.`id` is not null AND `business_profiles`.`deleted`=0 AND `business_profiles`.`active`=1
ORDER BY
RAND() ASC LIMIT 20