FERTIG
SELECT b.Titel, a.Titel, a.Platz, b.Platz AS VWP
FROM top1002 AS a
LEFT JOIN top1002 AS b ON a.KW = b.KW -1 AND a.Titel = b.Titel
WHERE a.KW =10 AND a.Jahr =2004 AND b.Interpret IS NULL LIMIT 0 , 30
nicht angemeldet nicht angemeldetFERTIG
SELECT b.Titel, a.Titel, a.Platz, b.Platz AS VWP
FROM top1002 AS a
LEFT JOIN top1002 AS b ON a.KW = b.KW -1 AND a.Titel = b.Titel
WHERE a.KW =10 AND a.Jahr =2004 AND b.Interpret IS NULL LIMIT 0 , 30