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