WHERE item_disp_date <= '2021-08-01 00: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` >= '2021-07-29 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_42e%')