SELECT *, (SELECT count(cm_idx) FROM comment WHERE comment.bd_idx = board.bd_idx) AS cm_cnt, (SELECT count(l_idx) FROM blike WHERE blike.bd_idx = board.bd_idx) AS bl_cnt, (SELECT s_idx FROM spot WHERE spot.s_id = board.bd_spot) AS s_idx FROM board WHERE 1 = 1 AND bd_depth = '5' AND bd_spot = 'jaradabanpo' ORDER BY wrt_date DESC