|
|
|
병원 잡지 베스트셀러
|
| |
|
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_24_01%' and data_gubun_2 != '25' GROUP BY issn order by (LENGTH(selling_mem)-LENGTH(REPLACE(selling_mem,'c_24_01','')))/LENGTH('c_24_01') desc, selling desc, nationality asc, reg_date desc, book_name desc limit 40,10
|
|
|
|
