|
|
|
select * from issn_book where 1 and p_on_off ='ON' and price_year > 0 and price_year!='' 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') and nationality!='01' and nationality!='02' and data_gubun_2 != '10' and data_gubun_2 != '05' and (simple = 'c30' or simple = 'c40' or simple = 'c50') order by selling desc , reg_date desc, idx desc limit 42,21
|
