Query failed rank109 SELECT id,COUNT(*) AS pt FROM artbright_yomi_rank WHERE time BETWEEN 1222978926 AND 1224188526 GROUP BY id ORDER BY pt DESC