Fatal error: Uncaught exception Exception with message Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND EXISTS (SELECT t.id FROM cat_kurstyp t
INNER JOIN cat_kursar' at line 15 (SELECT
c.name as country_name,
LOWER(c.code) as country_code,
p.name as place_name,
p.id as place_id,
COUNT(s.id) as school_count
FROM cat_place p
INNER JOIN cat_country c on c.id = p.country
INNER JOIN cat_school s on s.place = p.id
INNER JOIN cat_language l on l.id = s.language
WHERE
AND EXISTS (SELECT t.id FROM cat_kurstyp t
INNER JOIN cat_kursart a ON a.id = t.kursart
WHERE FIND_IN_SET(t.id, s.kurstypen)
AND LOWER(a.code) = 'zwischenjahr'
)
GROUP BY p.name) thrown in /var/www/html/system/libraries/Database.php on line 686
#0 /var/www/html/system/libraries/Database.php(633): Database_Statement->query()
#1 /var/www/html/system/modules/linguaservice/map_controller.php(220): Database_Statement->execute(Array)
#2 /var/www/html/system/modules/linguaservice/map_controller.php(85): map_controller->loadPlacesBy('', 'zwischenjahr', 0, Array)
#3 /var/www/html/templates/catalog_list_map_country.html5(5): map_controller->loadCountryMap()
#4 /var/www/html/templates/catalog_list_map.html5(5): include_once('/var/www/html/t...')
#5 /var/www/html/system/libraries/Template.php(245): include('/var/www/html/t...')
#6 /var/www/html/system/modules/frontend/FrontendTemplate.php(49): Template->parse()
#7 /var/www/html/system/modules/catalog/ModuleCatalog.php(2257): FrontendTemplate->parse()
#8 /var/www/html/system/modules/catalog/ModuleCatalogList.php(218): ModuleCatalog->parseCatalog(Object(DB_Mysql_Result), true, 'catalog_list_ma...', Array)
#9 /var/www/html/system/modules/frontend/Module.php(140): ModuleCatalogList->compile()
#10 /var/www/html/system/modules/catalog/ModuleCatalog.php(143): Module->generate()
#11 /var/www/html/system/modules/catalog/ModuleCatalogList.php(79): ModuleCatalog->generate()
#12 /var/www/html/system/libraries/Controller.php(357): ModuleCatalogList->generate()
#13 /var/www/html/system/modules/frontend/PageRegular.php(100): Controller->getFrontendModule('6', 'main')
#14 /var/www/html/index.php(266): PageRegular->generate(Object(DB_Mysql_Result))
#15 /var/www/html/index.php(401): Index->run()
#16 {main}