Fehler !
SELECT ranking_benutzerid, count(ranking_id) as anzahl, modul_referenzen.*
FROM modul_ranking, modul_referenzen
WHERE ranking_benutzerid = referenzen_id
AND referenzen_anzeigen = 1 GROUP BY ranking_benutzerid
ORDER BY anzahl DESC, ranking_benutzerid DESC
LIMIT 100, -2