SELECT t4.*,COUNT(0) AS today_num FROM (
SELECT * FROM (
SELECT t1.* FROM `tbl_syrk_capture_compare_30w` t1
WHERE fcmp_time >= 1513367070 AND fcmp_time <= 1513369570
ORDER BY t1.`fcmp_socre` DESC,t1.fcap_time DESC
) t3 GROUP BY t3.person_id ORDER BY t3.`fcmp_socre` DESC,t3.fcap_time DESC
) t4 GROUP BY t4.id_numb ORDER BY UUID
0 个回复