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, `#__custom_properties` dyscyplina_projektu
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 `dyscyplina_projektu`.`content_id` = `c`.`id`
AND `dyscyplina_projektu`.`field_id` = 3
AND (`dyscyplina_projektu`.`value_id` = 356)
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-05-09 09:49:10')
AND (`c`.`publish_down`='0000-00-00 00:00:00' OR `c`.`publish_down`>='2024-05-09 09:49:10')
ORDER BY title COLLATE utf8mb4_polish_ci
Principal Investigator / Project Leader: Wójcik Małgorzata
Project status: ongoing
Bullying and Parenting
Discipline: psychology
Principal Investigator / Project Leader: Cieślak Roman
Project status: finished
DESMOPSI System
Discipline: psychology
Principal Investigator / Project Leader: Wójcik Małgorzata
Project status: ongoing
Friends On / Bullying Off
Discipline: psychology
Principal Investigator / Project Leader: Białaszek Wojciech
Project status: finished
Future is Uncertain
Discipline: psychology
Principal Investigator / Project Leader: Maj Konrad
Project status: ongoing
HumanTech Meetings
Discipline: psychology
Principal Investigator / Project Leader: Cisłak-Wójcik Aleksandra
Project status: finished
In Charge or in Control?
Discipline: psychology
Principal Investigator / Project Leader: Łuszczyńska Aleksandra
Project status: ongoing
LIKE A PRO
Discipline: psychology