select * from issn_book where 1 and (issn_status_1='01' or issn_status_1='02' or issn_status_1='03') and (issn_status_2='01' or issn_status_2='02' or issn_status_2='03' or issn_status_2='04' or issn_status_2='05' or issn_status_2='06' or issn_status_2='07' or issn_status_2='08' or issn_status_2='10' or issn_status_2='11' or issn_status_2='12') and price_year>0 and p_on_off='on' and data_gubun_2!='20' and selling_mem like '%c_14%' and data_gubun_2 != '25' GROUP BY issn order by (LENGTH(selling_mem)-LENGTH(REPLACE(selling_mem,'c_14','')))/LENGTH('c_14') desc, selling desc, nationality asc, reg_date desc, book_name desc limit 0,10
병원 잡지 베스트셀러
