[
"sql" => "SELECT c0_.id AS id_0, c0_.logistic AS logistic_1, c0_.frequency AS frequency_2, c0_.status AS status_3, c0_.created_at AS created_at_4, c0_.token AS token_5, c0_.country_code AS country_code_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.hide_club_info AS hide_club_info_9, c0_.hide_coach_info AS hide_coach_info_10, c0_.step_saved AS step_saved_11, c0_.sended_alert AS sended_alert_12, c0_.cover AS cover_13, c0_.visible_to_club AS visible_to_club_14, c0_.visible_to_coach AS visible_to_coach_15, c0_.visible_to_operator AS visible_to_operator_16, c0_.published_at AS published_at_17, c0_.updated_at AS updated_at_18, c0_.club_id AS club_id_19, c0_.address_id AS address_id_20, c0_.owner_id AS owner_id_21, c0_.operator_id AS operator_id_22 FROM course c0_ INNER JOIN user u1_ ON c0_.owner_id = u1_.id LEFT JOIN coach c2_ ON u1_.id = c2_.id LEFT JOIN club c3_ ON u1_.id = c3_.id LEFT JOIN operator o4_ ON u1_.id = o4_.id LEFT JOIN trainee t5_ ON u1_.id = t5_.id LEFT JOIN admin a6_ ON u1_.id = a6_.id INNER JOIN pro_info p7_ ON u1_.pro_info_id = p7_.id WHERE c0_.status = ? AND u1_.status = ? AND p7_.have_subscription = ? AND p7_.is_hidden = ? ORDER BY c0_.created_at DESC"
"params" => [
1 => "active"
2 => "online"
3 => 1
4 => 0
]
"types" => [
1 => 2
2 => 2
3 => 5
4 => 5
]
]