SELECT jlog_ranking.name, jlog_ranking.desc, jlog_ranking.sql, jlog_ranking.unit , count(ranking) as count FROM jlog_ranking, jlog_userrank WHERE jlog_ranking.id = jlog_userrank.ranking and jlog_ranking.id = 0 and server = 0 and date <= now() and date >= date_sub(now(), interval 1 day) GROUP BY id
Das [Irren] Haus Forum 2.0 • Ranking