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 r.actief='ja' ORDER BY regionaam' at line 4
SELECT DISTINCT r.regionaam_n as regionaam,r.regiooms_n as roms, r.regionr as thisRgnr, r.soort, r.jquerylink as jq, r.regionaam_n as map
FROM regio r
LEFT JOIN regioverhuurdertype rvt ON (r.regionr = rvt.regionr)
WHERE rvt.verhnr IN () AND r.actief='ja' ORDER BY regionaam
