RANKING
-
SELECT COUNT(*) as cnt , c.* , (SELECT mb_name FROM g5_member WHERE mb_id = c.mb_id) as mb_name
FROM g5_write_cover as c
WHERE c.wr_is_comment = 0 AND c.wr_datetime BETWEEN '2024-11-04 00:00:00' AND '2024-10-27 23:59:59'
GROUP BY c.mb_id
ORDER BY cnt DESC
LIMIT 0 , 50