WHERE `item_disp_flg` = 1 AND `item_kind` = 0 AND (`item_soldout_date` >= '2021-01-21 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 ceil(`item_price_c` / 95 ) >= (50 - 20) AND ceil(`item_price_c` / 95 ) < (100 - 20) AND `item_target_c` = 1 AND `item_price_c` > 0 AND (`item_brand` LIKE '%d_310e%')