0
件の検索結果
select `t_estates`.*, (select count(*) from `t_estate_applications` where `t_estates`.`id` = `t_estate_applications`.`estate_id` and `canceled_at` is null) as `estate_applicants_count` from `t_estates` where `is_draft` = and `public_at` <= '2025-07-04 22:24:56' and `type_auction` = 1 and `current_step` in (5, 9, 11, 12) and `location_prefecture_id` = '4' and `t_estates`.`deleted_at` is null order by `public_at` desc