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