WHERE `item_disp_flg` = 1 AND `item_kind` = 0 AND (`item_soldout_date` >= '2021-01-13 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_target_c` = 1 AND `item_price_c` > 0 AND `v_item_jp`.`category_code` != 10100