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