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 a.aanbieding <> '0.00' AND a.statusOnline = 'ja' ORDER BY a.merk ASC' at line 1<br />SELECT a.merk FROM art INNER JOIN artikelen AS a ON art.artikelen = a.id WHERE art.subsubgroep IN ()  AND a.aanbieding <> '0.00' AND a.statusOnline = 'ja' ORDER BY a.merk ASC;