Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') LEFT JOIN university as u ON (u.id=p.FKY_UNIVERSITY) LEFT JOIN count' at line 1 SELECT p.id as id, IF (t.STR_TITLE<>'',t.STR_TITLE,p.STR_TITLE) as title, IF (t.STR_LOGLINE<>'',t.STR_LOGLINE,p.STR_LOGLINE) as logline, IF (t.TXT_INTRO<>'',t.TXT_INTRO,p.TXT_INTRO) as intro, IF (t.TXT_TEXT<>'',SUBSTRING(t.TXT_TEXT,1,200),SUBSTRING(p.TXT_TEXT,1,200)) as text, p.DAT_YEAR as year, p.STR_PROJECT_IMAGE as project_image, p.STR_DISCIPLINE as disciplines, p.FKY_UNIVERSITY as university_id, p.INT_AWARD as award, p.BLN_FAVOURITE as favourite, p.STR_USERNAME as username, REPLACE(p.IMG_PASSPHOTO,'.jpg','_thumb.jpg') as passphoto_thumb, u.STR_CITY as city, u.STR_UNIVERSITY as university, GROUP_CONCAT(DISTINCT CONCAT_WS(' ',n.STR_FIRSTNAME,n.STR_PREFIX,n.STR_SURNAME) SEPARATOR ', ') as participants, GROUP_CONCAT(DISTINCT i.IMG_FILENAME ORDER BY i.INT_NR) as images FROM project as p JOIN domain_link as d ON (d.item_id=p.id AND d.ftable='project' AND d.domain_id=) LEFT JOIN university as u ON (u.id=p.FKY_UNIVERSITY) LEFT JOIN country as c ON (c.STR_COUNTRY=u.STR_COUNTRY) LEFT JOIN continent as w ON (c.STR_CONTINENT=w.STR_CONTINENT) LEFT JOIN project_translation as t ON (p.id=t.FKY_PROJECT AND t.PKL_LANGUAGE='') LEFT JOIN image as i ON (i.FKY_PROJECT = p.id) LEFT JOIN participant as n ON (n.FKY_PROJECT = p.id) WHERE p.BLN_ACTIEF=1 AND ( p.DAT_YEAR = '2023' ) GROUP BY p.id ORDER BY p.DAT_YEAR DESC,p.STR_TITLE,c.STR_COUNTRY,u.STR_CITY,i.INT_NR