4
件の検索結果




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-20 00:06:45' and `type_auction` = 1 and `current_step` in (5, 9, 11, 12) and exists (select * from `m_prefectures` where `t_estates`.`location_prefecture_id` = `m_prefectures`.`id` and exists (select * from `m_areas` where `m_prefectures`.`area_id` = `m_areas`.`id` and `id` = '4')) and `t_estates`.`deleted_at` is null order by `public_at` desc