Mysql failure:
-----------------------------
query: SELECT * FROM ( SELECT a.id AS album_id, album, ar.id AS artiest_id, sArtiest, artiest, COUNT( * ) as AK, a.jaar as jaar FROM lijsten AS l, lijstenB AS lb, album AS a LEFT JOIN artiest AS ar ON ar.id = a.artiest_id WHERE album_id = a.id AND lb.canon = 1 AND l.lijst_id = lb.id GROUP BY l.album_id HAVING COUNT( * ) >= 2 ORDER BY AK DESC ) AS maintable ORDER BY AK DESC, sArtiest ASC
Error: Table 'muzieklijstjes.lijstenB' doesn't exist
Muziekcanon (titels die in twee of meer geselecteerde lijsten genoemd worden)

Nr Pos AK ^ Artiest ^ Album^ Jaar ^