500
Ismeretlen hiba történt...
Got error 28 from storage engine
SELECT
`advertisements`.*,
`image`.`filename` as `pc_image`
FROM
`advertisements`
LEFT JOIN
`attachments` as `image` ON `image`.`item_id`=`advertisements`.`id` AND `image`.`module`='advertisement_banner'
WHERE
`advertisements`.`type`='banner' AND
`advertisements`.`active`=1 AND
`image`.`id` is not null AND
`image`.`filename` != '' AND
(CURRENT_TIMESTAMP BETWEEN
`advertisements`.`valid_from`
AND `advertisements`.`valid_to`) AND
`advertisements`.`page_urls` LIKE '%"/business_profiles/profile"%'
ORDER BY RAND() LIMIT 9