WHERE item_disp_date <= '2024-05-23 03:00:00' AND `item_name` != 1 AND `item_name` NOT LIKE '%入力用%' AND `item_name` NOT LIKE '%お仕立%' AND `item_disp_flg` = 1 AND `item_kind` = 0 AND (`item_soldout_date` >= '2024-05-20 00:00:00' OR `item_soldout_date` IS NULL OR `item_soldout_date` = '0000-00-00 00:00:00') AND `item_kaigai_flg` = 1 AND (`item_price_b` < 100000 && `item_price_b` >= 50000) AND `item_target_b` = 1 AND `item_price_b` > 0 AND `v_item_jp`.`category_code` = 10100