검색 상세검색

HOME > ߰ > Ͽ ߰ > LP >
select ceil(page_cnt / 20) from ( select sum(1) as page_cnt from it_product where is_active = 'Y' and price > 0 and product_cd like 'U%' and mf_series like '%AS002%' and genre_cd1 like '010102%'and stock_status_code in ('ST001', 'ST002') and media_info like '%LP%' )