
select count(*) as total from (select no, re_deep, secret, hit, name, sub_name, comp, subject, main_title, sub_title, position, ext_link, date_format(wdate,'%y.%m.%d') as wdate, date_format(mdate,'%y.%m.%d') as mdate, date_format(date_add(now(), interval -1 day),'%y.%m.%d') as new_date, content, etc_str1, etc_str2, etc_str6 from board_list as li where board_grp = 11 order by re_grp desc, re_seq asc) as tbl_cnt