Mysql failure:
-----------------------------
Query: SELECT p.id as id, p.titel as titel, beschrijving, prijs, aanbieding, levertijd, p.actief AS actief, ean, systeemeisen, voorraad, releasedatum, AVG(score) as score, CEILING(communityScore) as communityScore, communityVotes, image_id, thumbLocation, thumbWidth, thumbHeight, g.id as game_id, multiplayer, minimumLeeftijd, score, v.game_id as voted, userScore, platformen.id as platform_id, platformen.titel as platform_titel, platformen.afk, platformen.logo as platform_logo, u.id as uitgever_id, u.titel as uitgever_titel, o.id as ontwikkelaar_id, o.titel as ontwikkelaar_titel, h.id as hardware_id, pl.titel AS platform2_titel, pl.id AS platform2_id, pl.logo AS platform2_logo, c.id as categorie_id, c.titel as categorie_titel FROM producten AS p LEFT OUTER JOIN games AS g ON ISNULL(p.game_id) = 0 AND p.game_id = g.id LEFT OUTER JOIN gameVotes AS v ON v.game_id = g.id LEFT OUTER JOIN platformen ON platformen.id = g.platform_id LEFT OUTER JOIN uitgevers AS u ON u.id = g.uitgever_id LEFT OUTER JOIN ontwikkelaars AS o ON o.id = g.ontwikkelaar_id LEFT OUTER JOIN reviews AS r ON r.game_id = g.id LEFT OUTER JOIN hardware AS h ON ISNULL(hardware_id) = 0 AND hardware_id = h.id LEFT OUTER JOIN platformen AS pl ON h.platform2_id = pl.id LEFT OUTER JOIN categorieen AS c ON c.id = h.categorie_id LEFT OUTER JOIN images AS i ON image_id = i.id WHERE p.id = AND p.actief = 1 GROUP BY p.id, g.id
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 p.actief = 1 GROUP BY p.id, g.id' at line 29