게시판 별 활동 유저 순위 뽑기

-- 글작성 1~3순위

SELECT m.mb_nick, SUM(w.wr_is_comment = 0) cnt
FROM 게시판테이블 w INNER JOIN 회원테이블 m ON m.mb_id = w.mb_id 
WHERE w.wr_datetime BETWEEN CONCAT(CURDATE(), ' 00:00:00') AND CONCAT(CURDATE(), ' 23:59:59')
GROUP BY w.mb_id 
ORDER BY cnt DESC
LIMIT 3 OFFSET 0
;

 

-- 댓글 1~3순위

SELECT m.mb_nick, SUM(w.wr_is_comment = 1) cnt
FROM 게시판테이블 w INNER JOIN 회원테이블 m ON m.mb_id = w.mb_id 
WHERE w.wr_datetime BETWEEN CONCAT(CURDATE(), ' 00:00:00') AND CONCAT(CURDATE(), ' 23:59:59')
GROUP BY w.mb_id 
ORDER BY cnt DESC
LIMIT 3 OFFSET 0
;