^ "select `kyoushitsu`.`id`, `kyoushitsu`.`code`, `kyoushitsu`.`is_open`, `kyoushitsu`.`plan`, `kyoushitsu`.`name`, `kyoushitsu`.`kana`, `kyoushitsu`.`online`, `kyoushitsu`.`tel`, `kyoushitsu`.`tel_time`, `kyoushitsu`.`zip`, `kyoushitsu`.`pref_id`, `kyoushitsu`.`city_id`, `kyoushitsu`.`address`, `kyoushitsu`.`lat`, `kyoushitsu`.`long`, `kyoushitsu`.`access`, `kyoushitsu`.`instagram`, `kyoushitsu`.`facebook`, `kyoushitsu`.`twitter`, `kyoushitsu`.`line`, `kyoushitsu`.`contact_types`, `kyoushitsu`.`feature_1`, `kyoushitsu`.`feature_2`, `kyoushitsu`.`feature_3`, `kyoushitsu`.`image_sub`, `kyoushitsu`.`movie`, `kyoushitsu`.`detail`, `kyoushitsu`.`news`, `kyoushitsu`.`news_start`, `kyoushitsu`.`news_end`, `kyoushitsu`.`email`, `kyoushitsu`.`user_login`, `kyoushitsu`.`is_valid`, `kyoushitsu`.`is_parent`, `kyoushitsu`.`has_own_pages`, `kyoushitsu`.`is_child`, `kyoushitsu`.`order_news`, `kyoushitsu`.`order_course`, `kyoushitsu`.`order_taiken`, `kyoushitsu`.`order_teacher`, `kyoushitsu`.`order_faq`, `kyoushitsu`.`order_blog`, `kyoushitsu`.`alliance_id`, `kyoushitsu`.`alliance_code`, `kyoushitsu`.`alliance_manager`, `kyoushitsu`.`contact_link`, `kyoushitsu`.`completeness` from `kyoushitsu` inner join (select * from `kyoushitsu_station` where `mst_station_id` in (?)) as `stations` on `kyoushitsu`.`id` = `stations`.`kyoushitsu_id` where `is_open` = ? and (`is_parent` != ? or (`is_parent` = ? and `has_own_pages` = ?)) and `kyoushitsu`.`deleted_at` is null group by `kyoushitsu`.`id` order by `plan` asc, `completeness` desc, `contents_created_at` desc, `random_order` asc, `id` desc limit 20"

^ array:5 [
  0 => "9952503"
  1 => 1
  2 => 1
  3 => 1
  4 => 1
]

^ 0