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