Warning: Division by zero in /home/vhosting/s/vhost0034046/domains/archiprix.org/htdocs/www/2019/project_viewer_large.php on line 24 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 '' at line 1 SELECT p.id, p.STR_USERNAME as username, p.FKY_UNIVERSITY as university_id, p.IMG_PASSPHOTO as passphoto_src, p.MOV_MOVIE as movie_src, p.TXT_MEDIA as media_embed, IF (t.STR_TITLE<>'',t.STR_TITLE,p.STR_TITLE) as title, IF (t.STR_LOGLINE<>'',t.STR_LOGLINE,p.STR_LOGLINE) as logline2, IF (t.STR_LOGLINE<>'',t.STR_LOGLINE,p.STR_LOGLINE) as logline, IF (t.TXT_TEXT<>'',t.TXT_TEXT,p.TXT_TEXT) as text, p.STR_PROJECT_COUNTRY as project_country, p.STR_PROJECT_CITY as project_city, p.STR_PROJECT_ADDRESS as project_adsress, p.DEC_LATITUDE as latitude, p.DEC_LONGITUDE as longitude, p.TXT_TUTORS as tutors, p.DAT_YEAR as year, CONCAT_WS(' ',e.STR_EDITION,e.DAT_YEAR) as edition, p.STR_DISCIPLINE as disciplines, p.STR_CATEGORIES as categories, p.STR_SIZE as size, CONCAT_WS('' , 'http://www.archiprix.org/projects/' , p.DAT_YEAR , '/' , p.STR_USERNAME , '/') as path, p.INT_AWARD as award, p.INT_VOTES as votes, p.BLN_FAVOURITE as favourite, p.DAT_MODIFIED as modified, p.IMG_PASSPHOTO as passphoto, u.STR_CITY as city, u.STR_UNIVERSITY as university, u.STR_FACULTY as faculty, c.STR_COUNTRY as country, w.STR_CONTINENT as continent, c.STR_COUNTRY as flag, u.POS_X as pos_x, u.POS_Y as pos_y FROM project as p LEFT JOIN edition as e ON (e.DAT_YEAR=p.DAT_YEAR) 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.FKY_CONTINENT=w.id) LEFT JOIN project_translation as t ON (p.id=t.FKY_PROJECT AND t.PKL_LANGUAGE='xx') WHERE p.id=