^ "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` where `city_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `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 offset 0"

^ array:22 [
  0 => 14101
  1 => 14102
  2 => 14103
  3 => 14104
  4 => 14105
  5 => 14106
  6 => 14107
  7 => 14108
  8 => 14109
  9 => 14110
  10 => 14111
  11 => 14112
  12 => 14113
  13 => 14114
  14 => 14115
  15 => 14116
  16 => 14117
  17 => 14118
  18 => 1
  19 => 1
  20 => 1
  21 => 1
]

^ 4475