[
"sql" => "SELECT i0_.id AS id_0, i0_.slug AS slug_1, i0_.name AS name_2, i0_.description AS description_3, i0_.surface AS surface_4, i0_.latitude AS latitude_5, i0_.longitude AS longitude_6, i0_.status AS status_7, i0_.created_at AS created_at_8, i0_.updated_at AS updated_at_9, s1_.id AS id_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.address AS address_13, s1_.postcode AS postcode_14, s1_.city AS city_15, s1_.phone AS phone_16, s1_.created_at AS created_at_17, s1_.updated_at AS updated_at_18, m2_.id AS id_19, m2_.original_filename AS original_filename_20, m2_.stored_filename AS stored_filename_21, m2_.mime_type AS mime_type_22, m2_.size AS size_23, m2_.context AS context_24, m2_.status AS status_25, m2_.created_at AS created_at_26, m2_.is_hero AS is_hero_27, i0_.school_id AS school_id_28, m2_.island_id AS island_id_29, m2_.uploaded_by_id AS uploaded_by_id_30, m2_.camera_trap_id AS camera_trap_id_31 FROM island i0_ LEFT JOIN school s1_ ON i0_.school_id = s1_.id LEFT JOIN media m2_ ON i0_.id = m2_.island_id WHERE i0_.status IN (?, ?) AND i0_.latitude IS NOT NULL AND i0_.longitude IS NOT NULL ORDER BY i0_.name ASC"
"params" => [
1 => "active"
2 => "creation"
]
"types" => [
1 => Doctrine\DBAL\ParameterType {#976
+name: "STRING"
}
2 => Doctrine\DBAL\ParameterType {#976}
]
]