500
Ismeretlen hiba történt...
Got error 28 from storage engine
SELECT
`business_profiles`.*,
`attachments`.`cropped_filename` as `thumbnail`,
`attachments`.`filename` as `poster`
FROM
`business_profiles`
LEFT JOIN
`profile_premises` ON `business_profiles`.`id`=`profile_premises`.`profile_id`
LEFT JOIN
`attachments`
ON `attachments`.`module`='profile_index' AND `attachments`.`item_id`=`business_profiles`.`id`
WHERE
`business_profiles`.`deleted`=0 AND `business_profiles`.`active`=1
GROUP BY `business_profiles`.`id` ORDER BY randorder ASC LIMIT 0,12