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`<='2024-10-12 11:47:11')
AND (`c`.`publish_down`='0000-00-00 00:00:00' OR `c`.`publish_down`>='2024-10-12 11:47:11')
ORDER BY title COLLATE utf8mb4_polish_ci
Principal Investigator / Project Leader: Bachmann Klaus
Project status: finished
A History of Rwanda
Discipline: history
Principal Investigator / Project Leader: Wójcik Małgorzata
Project status: ongoing
Bullying and Parenting
Discipline: psychology
Principal Investigator / Project Leader: Murlak Karol
Project status: ongoing
CoDesign4Transitions
Discipline: art studies, social sciences
Principal Investigator / Project Leader: Cieślak Roman
Project status: finished
DESMOPSI System
Discipline: psychology
Principal Investigator / Project Leader: Stanley Ben
Project status: finished
DIASPOlitic
Discipline: political science and administration, social sciences
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: Świątek Włodzimierz
Project status: ongoing
Leadership LAB Project
Discipline: management and quality studies
Principal Investigator / Project Leader: Łuszczyńska Aleksandra
Project status: ongoing
LIKE A PRO
Discipline: psychology
Principal Investigator / Project Leader: Stanczewski Radosław
Project status: ongoing
Mobility in Higher Education
Discipline: not applicable
Principal Investigator / Project Leader: Piotrowski Konrad
Project status: finished
Parenthood Regret Scale
Discipline: psychology
Principal Investigator / Project Leader: Grabowska Izabela
Project status: finished
Peer Groups and Migration
Discipline: sociology
Principal Investigator / Project Leader: Cześnik Mikołaj
Project status: finished
Political Knowledge in Poland
Discipline: political science and administration
Principal Investigator / Project Leader: Tyburska Julia
Project status: ongoing
Program Erasmus+ KA131
Discipline: not applicable
Principal Investigator / Project Leader: Tyburska Julia
Project status: ongoing
Program Erasmus+ KA171
Discipline: not applicable
Principal Investigator / Project Leader: Kajta Justyna
Project status: ongoing
RaM-CLASS
Discipline: sociology
Principal Investigator / Project Leader: Bojarska Katarzyna
Project status: finished
The Wives of Lot
Discipline: cultural and religious studies, art studies, literary studies