SELECT "cms_banery".*, "cbmt"."slug" AS "baner_type_slug", "m"."id" AS "id_banery_miejsca", "m"."allow_fixed" AS "allow_fixed", (SELECT CONCAT(pls.sciezka,'_SIZE_','news_nazwa-', pls.id_pliku,'.',pls.rozszerzenie) as x FROM pliki pls WHERE pls.id_pliku = cms_banery.id_pliku LIMIT 1) AS "photo", (SELECT CONCAT(pls.sciezka,'_SIZE_','news_nazwa-', pls.id_pliku,'.',pls.rozszerzenie) as x FROM pliki pls WHERE pls.id_pliku = cms_banery.id_pliku_2 LIMIT 1) AS "photo2", (SELECT GROUP_CONCAT(cbc.id_category) as x FROM cms_banery_category cbc WHERE cbc.id_cms_banery = cms_banery.id) AS "categories" FROM "cms_banery" LEFT JOIN "cms_banery_typy" AS "cbmt" ON "cbmt"."id" = "cms_banery"."id_baner_type" LEFT JOIN "cms_banery_miejsca" AS "m" ON "m"."id" = "cms_banery"."id_banery_miejsca" WHERE cms_banery.publication_date_from <= '2024-04-25 00:00:00' AND cms_banery.publication_date_to >= '2024-04-25 00:00:00' AND "cms_banery"."is_active" = '1' ORDER BY "position" ASC