|
|
|
기업/회사 Best
|
| |
|
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_06%' and data_gubun_2 != '25' GROUP BY issn order by (LENGTH(selling_mem)-LENGTH(REPLACE(selling_mem,'c_06','')))/LENGTH('c_06') desc, selling desc, nationality asc, reg_date desc, book_name desc limit 0,10
|
