WHERE `item_disp_flg` = 1 AND `item_kind` = 0 AND (`item_soldout_date` >= '2020-07-04 00:00:00' OR `item_soldout_date` IS NULL OR `item_soldout_date` = '0000-00-00 00:00:00') AND `item_target_c` = 1 AND `item_price_c` > 0 AND (`item_brand` LIKE '%d_237e%')