상담후기 73 페이지
뒤로가기
상담후기
-
-
전체보기로 눌렀을 때 나오는 쿼리 : SELECT COUNT(DISTINCT gwc.wr_parent) AS cnt
FROM g5_write_review AS gwc
LEFT JOIN g5_member AS m ON gwc.mb_id = m.mb_id
WHERE gwc.wr_is_comment = 0 select gwc.*, m.*, (select count(*) from g5_write_review r where r.wr_1 = gwc.mb_id) as afcnt from g5_write_review as gwc
left join g5_member as m on gwc.mb_id = m.mb_id where gwc.wr_is_comment = 0 order by wr_datetime desc limit 1080, 15
