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
GROUP BY c.mb_id
ORDER BY cnt DESC
LIMIT 0 , 50
- EnjoyKpop 6p
- actsmo 5p
- James 3p
- weloveyena 2p