雛人形 商品一覧

select p.item_code as item_code, p.item_name as item_name, p.stock_num as stock_num, p.stock_qsuantity as stock_qsuantity, p.price1 as price1, p.price2 as price2, p.new_icon as new_icon, p.sellstop as sellstop from product as p inner join product_category as pc on p.sub_num = pc.sub_num where pc.cat_num = 1 and p.delete_flg = 0 and p.display = 0 order by p.disp_num limit :start,:end