SELECT
DISTINCT
`c`.`title` AS title,
`c`.`id`,
`c`.`alias`,
`c`.`catid`,
`c`.`images`
FROM
`su4_content` c, `su4_custom_properties_values` cpv, `su4_custom_properties` cp , `su4_custom_properties` lokalizacja_projekty, `su4_custom_properties` typ_projektu, `su4_custom_properties` dyscyplina_projektu
WHERE
(`c`.`catid` = 610 OR `c`.`catid` = 96 OR `c`.`catid` = 42)
AND `lokalizacja_projekty`.`content_id` = `c`.`id`
AND `lokalizacja_projekty`.`field_id` = 10027
AND (`lokalizacja_projekty`.`value_id` = 10513)
AND `typ_projektu`.`content_id` = `c`.`id`
AND `typ_projektu`.`field_id` = 10023
AND (`typ_projektu`.`value_id` = 10329)
AND `dyscyplina_projektu`.`content_id` = `c`.`id`
AND `dyscyplina_projektu`.`field_id` = 3
AND (`dyscyplina_projektu`.`value_id` = 10367)
AND `cpv`.`field_id` = 4
AND `cpv`.`id` = `cp`.`value_id`
AND `cp`.`content_id` = `c`.`id`
AND `c`.`access` = 1
AND `c`.`state` = 1
AND (`c`.`publish_up`='0000-00-00 00:00:00' OR `c`.`publish_up`<='2024-07-16 09:00:31')
AND (`c`.`publish_down`='0000-00-00 00:00:00' OR `c`.`publish_down`>='2024-07-16 09:00:31')
ORDER BY title COLLATE utf8mb4_polish_ci
