^ "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:43 [
  0 => 13201
  1 => 13202
  2 => 13203
  3 => 13204
  4 => 13205
  5 => 13206
  6 => 13207
  7 => 13208
  8 => 13209
  9 => 13210
  10 => 13211
  11 => 13212
  12 => 13213
  13 => 13214
  14 => 13215
  15 => 13218
  16 => 13219
  17 => 13220
  18 => 13221
  19 => 13222
  20 => 13223
  21 => 13224
  22 => 13225
  23 => 13227
  24 => 13228
  25 => 13229
  26 => 13303
  27 => 13305
  28 => 13307
  29 => 13308
  30 => 13361
  31 => 13362
  32 => 13363
  33 => 13364
  34 => 13381
  35 => 13382
  36 => 13401
  37 => 13402
  38 => 13421
  39 => 1
  40 => 1
  41 => 1
  42 => 1
]

^ 5166