SELECT
DISTINCT
`c`.`title` AS title,
`c`.`id`,
`c`.`alias`,
`c`.`catid`,
`c`.`images`
FROM
`#__content` c, `#__custom_properties_values` cpv, `#__custom_properties` cp , `#__custom_properties` lokalizacja_projekty
WHERE
/*(`c`.`catid` = 610 OR `c`.`catid` = 96 OR `c`.`catid` = 42)*/
`c`.`catid` = 42
AND `lokalizacja_projekty`.`content_id` = `c`.`id`
AND `lokalizacja_projekty`.`field_id` = 14
AND (`lokalizacja_projekty`.`value_id` = 283 OR `lokalizacja_projekty`.`value_id` = 284 OR `lokalizacja_projekty`.`value_id` = 288 OR `lokalizacja_projekty`.`value_id` = 285 OR `lokalizacja_projekty`.`value_id` = 286 OR `lokalizacja_projekty`.`value_id` = 287)
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`<='2023-03-29 21:57:19')
AND (`c`.`publish_down`='0000-00-00 00:00:00' OR `c`.`publish_down`>='2023-03-29 21:57:19')
ORDER BY title COLLATE utf8mb4_polish_ci
Principal Investigator: Bachmann Klaus
Project status: finished
A History of Rwanda
Discipline: history
Principal Investigator: Wójcik Małgorzata
Project status: ongoing
Bullying and Parenting
Discipline: psychology
Principal Investigator: Cieślak Roman
Project status: finished
DESMOPSI System
Discipline: psychology
Principal Investigator: Białaszek Wojciech
Project status: finished
Future is Uncertain
Discipline: psychology
Principal Investigator: Maj Konrad
Project status: ongoing
HumanTech Meetings
Discipline: psychology
Principal Investigator: Cisłak-Wójcik Aleksandra
Project status: finished
In Charge or in Control?
Discipline: psychology
Principal Investigator: Cześnik Mikołaj
Project status: finished
Political Knowledge in Poland
Discipline: political science and public administration