[ 'sql' => [ 1 => 'SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.sex AS sex_2, f0_.birthday AS birthday_3, f0_.birthday_bis AS birthday_bis_4, f0_.type AS type_5, f0_.just_month AS just_month_6, f0_.just_year AS just_year_7, f0_.number AS number_8, f0_.father_name AS father_name_9, f0_.mother_name AS mother_name_10, f0_.infos_zims AS infos_zims_11, f0_.arrival_at AS arrival_at_12, f0_.info_arrival AS info_arrival_13, f0_.departure_at AS departure_at_14, f0_.info_departure AS info_departure_15, f0_.departure_status AS departure_status_16, f0_.sterilized AS sterilized_17, f0_.pending AS pending_18, f0_.death_after_departure AS death_after_departure_19, f0_.documentary AS documentary_20, f0_.infos AS infos_21, f0_.created_at AS created_at_22, f0_.updated_at AS updated_at_23, f0_.identification AS identification_24, f0_.date_of_pending AS date_of_pending_25, f0_.subspecies AS subspecies_26, f0_.infos_sterilized AS infos_sterilized_27, s1_.id AS id_28, s1_.name AS name_29, s1_.scientific_name AS scientific_name_30, s1_.bis_name AS bis_name_31, s1_.ordre AS ordre_32, s1_.family AS family_33, s1_.studbook AS studbook_34, s1_.arrival AS arrival_35, s1_.departure AS departure_36, s1_.afrique AS afrique_37, s1_.asie AS asie_38, s1_.oceanie AS oceanie_39, s1_.am_nord AS am_nord_40, s1_.am_centrale AS am_centrale_41, s1_.am_sud AS am_sud_42, s1_.europe AS europe_43, s1_.observation AS observation_44, s1_.nbr_eaza AS nbr_eaza_45, s1_.nbr_fr AS nbr_fr_46, s1_.link_ztl AS link_ztl_47, s1_.link_wiki AS link_wiki_48, s1_.link_uicn AS link_uicn_49, s1_.link_diverse AS link_diverse_50, s1_.image AS image_51, s1_.updated_at AS updated_at_52, s1_.habitat AS habitat_53, s1_.longevity AS longevity_54, s1_.weight AS weight_55, s1_.diet AS diet_56, s1_.size AS size_57, s1_.wingspan AS wingspan_58, s1_.social AS social_59, s1_.reproduction AS reproduction_60, s1_.gestation AS gestation_61, s1_.nbr_child AS nbr_child_62, s1_.dimorphism AS dimorphism_63, s1_.plural_name AS plural_name_64, s1_.gender AS gender_65, s1_.genus AS genus_66, s1_.note AS note_67, l2_.id AS id_68, l2_.name AS name_69, l2_.description AS description_70, l2_.cost AS cost_71, l2_.creation AS creation_72, l2_.renovation AS renovation_73, l2_.destruction AS destruction_74, l2_.plan AS plan_75, l2_.updated_at AS updated_at_76, e3_.id AS id_77, e3_.name AS name_78, e3_.description AS description_79, e3_.creation AS creation_80, e3_.renovation AS renovation_81, e3_.destruction AS destruction_82, e3_.plan AS plan_83, e3_.updated_at AS updated_at_84, z4_.id AS id_85, z4_.name AS name_86, z5_.id AS id_87, z5_.name AS name_88, z6_.id AS id_89, z6_.name AS name_90, f0_.species_id AS species_id_91, f0_.birthplace_id AS birthplace_id_92, f0_.father_id AS father_id_93, f0_.mother_id AS mother_id_94, f0_.provenance_id AS provenance_id_95, f0_.destination_id AS destination_id_96, f0_.location_id AS location_id_97, f0_.enclosure_id AS enclosure_id_98, s1_.class_id AS class_id_99, s1_.status_id AS status_id_100, l2_.zone_id AS zone_id_101, e3_.location_id AS location_id_102 FROM fellow f0_ LEFT JOIN species s1_ ON f0_.species_id = s1_.id LEFT JOIN location l2_ ON f0_.location_id = l2_.id LEFT JOIN enclosure e3_ ON f0_.enclosure_id = e3_.id LEFT JOIN zoo z4_ ON f0_.birthplace_id = z4_.id LEFT JOIN zoo z5_ ON f0_.provenance_id = z5_.id LEFT JOIN zoo z6_ ON f0_.destination_id = z6_.id WHERE f0_.type = ? AND f0_.species_id = ? AND f0_.departure_status IS NULL ORDER BY f0_.arrival_at DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'f' => 'App\\Entity\\Fellow', 's' => 'App\\Entity\\Species', 'l' => 'App\\Entity\\Location', 'e' => 'App\\Entity\\Enclosure', 'bp' => 'App\\Entity\\Zoo', 'pr' => 'App\\Entity\\Zoo', 'dt' => 'App\\Entity\\Zoo', ], ], 'relationMap' => [ 2 => [ 's' => 'species', 'l' => 'location', 'e' => 'enclosure', 'bp' => 'birthplace', 'pr' => 'provenance', 'dt' => 'destination', ], ], 'parentAliasMap' => [ 2 => [ 's' => 'f', 'l' => 'f', 'e' => 'f', 'bp' => 'f', 'pr' => 'f', 'dt' => 'f', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'name_1' => 'name', 'sex_2' => 'sex', 'birthday_3' => 'birthday', 'birthday_bis_4' => 'birthdayBis', 'type_5' => 'type', 'just_month_6' => 'justMonth', 'just_year_7' => 'justYear', 'number_8' => 'number', 'father_name_9' => 'fatherName', 'mother_name_10' => 'motherName', 'infos_zims_11' => 'infosZims', 'arrival_at_12' => 'arrivalAt', 'info_arrival_13' => 'infoArrival', 'departure_at_14' => 'departureAt', 'info_departure_15' => 'infoDeparture', 'departure_status_16' => 'departureStatus', 'sterilized_17' => 'sterilized', 'pending_18' => 'pending', 'death_after_departure_19' => 'deathAfterDeparture', 'documentary_20' => 'documentary', 'infos_21' => 'infos', 'created_at_22' => 'createdAt', 'updated_at_23' => 'updatedAt', 'identification_24' => 'identification', 'date_of_pending_25' => 'dateOfPending', 'subspecies_26' => 'subspecies', 'infos_sterilized_27' => 'infosSterilized', 'id_28' => 'id', 'name_29' => 'name', 'scientific_name_30' => 'scientificName', 'bis_name_31' => 'bisName', 'ordre_32' => 'ordre', 'family_33' => 'family', 'studbook_34' => 'studbook', 'arrival_35' => 'arrival', 'departure_36' => 'departure', 'afrique_37' => 'afrique', 'asie_38' => 'asie', 'oceanie_39' => 'oceanie', 'am_nord_40' => 'amNord', 'am_centrale_41' => 'amCentrale', 'am_sud_42' => 'amSud', 'europe_43' => 'europe', 'observation_44' => 'observation', 'nbr_eaza_45' => 'nbrEaza', 'nbr_fr_46' => 'nbrFr', 'link_ztl_47' => 'linkZtl', 'link_wiki_48' => 'linkWiki', 'link_uicn_49' => 'linkUicn', 'link_diverse_50' => 'linkDiverse', 'image_51' => 'image', 'updated_at_52' => 'updatedAt', 'habitat_53' => 'habitat', 'longevity_54' => 'longevity', 'weight_55' => 'weight', 'diet_56' => 'diet', 'size_57' => 'size', 'wingspan_58' => 'wingspan', 'social_59' => 'social', 'reproduction_60' => 'reproduction', 'gestation_61' => 'gestation', 'nbr_child_62' => 'nbrChild', 'dimorphism_63' => 'dimorphism', 'plural_name_64' => 'pluralName', 'gender_65' => 'gender', 'genus_66' => 'genus', 'note_67' => 'note', 'id_68' => 'id', 'name_69' => 'name', 'description_70' => 'description', 'cost_71' => 'cost', 'creation_72' => 'creation', 'renovation_73' => 'renovation', 'destruction_74' => 'destruction', 'plan_75' => 'plan', 'updated_at_76' => 'updatedAt', 'id_77' => 'id', 'name_78' => 'name', 'description_79' => 'description', 'creation_80' => 'creation', 'renovation_81' => 'renovation', 'destruction_82' => 'destruction', 'plan_83' => 'plan', 'updated_at_84' => 'updatedAt', 'id_85' => 'id', 'name_86' => 'name', 'id_87' => 'id', 'name_88' => 'name', 'id_89' => 'id', 'name_90' => 'name', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Fellow' => [ 'f' => [ 'id' => 'id_0', 'name' => 'name_1', 'sex' => 'sex_2', 'birthday' => 'birthday_3', 'birthdayBis' => 'birthday_bis_4', 'type' => 'type_5', 'justMonth' => 'just_month_6', 'justYear' => 'just_year_7', 'number' => 'number_8', 'fatherName' => 'father_name_9', 'motherName' => 'mother_name_10', 'infosZims' => 'infos_zims_11', 'arrivalAt' => 'arrival_at_12', 'infoArrival' => 'info_arrival_13', 'departureAt' => 'departure_at_14', 'infoDeparture' => 'info_departure_15', 'departureStatus' => 'departure_status_16', 'sterilized' => 'sterilized_17', 'pending' => 'pending_18', 'deathAfterDeparture' => 'death_after_departure_19', 'documentary' => 'documentary_20', 'infos' => 'infos_21', 'createdAt' => 'created_at_22', 'updatedAt' => 'updated_at_23', 'identification' => 'identification_24', 'dateOfPending' => 'date_of_pending_25', 'subspecies' => 'subspecies_26', 'infosSterilized' => 'infos_sterilized_27', ], ], 'App\\Entity\\Species' => [ 's' => [ 'id' => 'id_28', 'name' => 'name_29', 'scientificName' => 'scientific_name_30', 'bisName' => 'bis_name_31', 'ordre' => 'ordre_32', 'family' => 'family_33', 'studbook' => 'studbook_34', 'arrival' => 'arrival_35', 'departure' => 'departure_36', 'afrique' => 'afrique_37', 'asie' => 'asie_38', 'oceanie' => 'oceanie_39', 'amNord' => 'am_nord_40', 'amCentrale' => 'am_centrale_41', 'amSud' => 'am_sud_42', 'europe' => 'europe_43', 'observation' => 'observation_44', 'nbrEaza' => 'nbr_eaza_45', 'nbrFr' => 'nbr_fr_46', 'linkZtl' => 'link_ztl_47', 'linkWiki' => 'link_wiki_48', 'linkUicn' => 'link_uicn_49', 'linkDiverse' => 'link_diverse_50', 'image' => 'image_51', 'updatedAt' => 'updated_at_52', 'habitat' => 'habitat_53', 'longevity' => 'longevity_54', 'weight' => 'weight_55', 'diet' => 'diet_56', 'size' => 'size_57', 'wingspan' => 'wingspan_58', 'social' => 'social_59', 'reproduction' => 'reproduction_60', 'gestation' => 'gestation_61', 'nbrChild' => 'nbr_child_62', 'dimorphism' => 'dimorphism_63', 'pluralName' => 'plural_name_64', 'gender' => 'gender_65', 'genus' => 'genus_66', 'note' => 'note_67', ], ], 'App\\Entity\\Location' => [ 'l' => [ 'id' => 'id_68', 'name' => 'name_69', 'description' => 'description_70', 'cost' => 'cost_71', 'creation' => 'creation_72', 'renovation' => 'renovation_73', 'destruction' => 'destruction_74', 'plan' => 'plan_75', 'updatedAt' => 'updated_at_76', ], ], 'App\\Entity\\Enclosure' => [ 'e' => [ 'id' => 'id_77', 'name' => 'name_78', 'description' => 'description_79', 'creation' => 'creation_80', 'renovation' => 'renovation_81', 'destruction' => 'destruction_82', 'plan' => 'plan_83', 'updatedAt' => 'updated_at_84', ], ], 'App\\Entity\\Zoo' => [ 'bp' => [ 'id' => 'id_85', 'name' => 'name_86', ], 'pr' => [ 'id' => 'id_87', 'name' => 'name_88', ], 'dt' => [ 'id' => 'id_89', 'name' => 'name_90', ], ], ], ], 'enumMappings' => [ 2 => [ 'observation_44' => 'App\\Enum\\SpeciesObservationEnum', ], ], 'typeMappings' => [ 2 => [ 'species_id_91' => 'integer', 'birthplace_id_92' => 'integer', 'father_id_93' => 'integer', 'mother_id_94' => 'integer', 'provenance_id_95' => 'integer', 'destination_id_96' => 'integer', 'location_id_97' => 'integer', 'enclosure_id_98' => 'integer', 'class_id_99' => 'integer', 'status_id_100' => 'integer', 'zone_id_101' => 'integer', 'location_id_102' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'f' => null, ], ], 'metaMappings' => [ 2 => [ 'species_id_91' => 'species_id', 'birthplace_id_92' => 'birthplace_id', 'father_id_93' => 'father_id', 'mother_id_94' => 'mother_id', 'provenance_id_95' => 'provenance_id', 'destination_id_96' => 'destination_id', 'location_id_97' => 'location_id', 'enclosure_id_98' => 'enclosure_id', 'class_id_99' => 'class_id', 'status_id_100' => 'status_id', 'zone_id_101' => 'zone_id', 'location_id_102' => 'location_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'f', 'name_1' => 'f', 'sex_2' => 'f', 'birthday_3' => 'f', 'birthday_bis_4' => 'f', 'type_5' => 'f', 'just_month_6' => 'f', 'just_year_7' => 'f', 'number_8' => 'f', 'father_name_9' => 'f', 'mother_name_10' => 'f', 'infos_zims_11' => 'f', 'arrival_at_12' => 'f', 'info_arrival_13' => 'f', 'departure_at_14' => 'f', 'info_departure_15' => 'f', 'departure_status_16' => 'f', 'sterilized_17' => 'f', 'pending_18' => 'f', 'death_after_departure_19' => 'f', 'documentary_20' => 'f', 'infos_21' => 'f', 'created_at_22' => 'f', 'updated_at_23' => 'f', 'identification_24' => 'f', 'date_of_pending_25' => 'f', 'subspecies_26' => 'f', 'infos_sterilized_27' => 'f', 'id_28' => 's', 'name_29' => 's', 'scientific_name_30' => 's', 'bis_name_31' => 's', 'ordre_32' => 's', 'family_33' => 's', 'studbook_34' => 's', 'arrival_35' => 's', 'departure_36' => 's', 'afrique_37' => 's', 'asie_38' => 's', 'oceanie_39' => 's', 'am_nord_40' => 's', 'am_centrale_41' => 's', 'am_sud_42' => 's', 'europe_43' => 's', 'observation_44' => 's', 'nbr_eaza_45' => 's', 'nbr_fr_46' => 's', 'link_ztl_47' => 's', 'link_wiki_48' => 's', 'link_uicn_49' => 's', 'link_diverse_50' => 's', 'image_51' => 's', 'updated_at_52' => 's', 'habitat_53' => 's', 'longevity_54' => 's', 'weight_55' => 's', 'diet_56' => 's', 'size_57' => 's', 'wingspan_58' => 's', 'social_59' => 's', 'reproduction_60' => 's', 'gestation_61' => 's', 'nbr_child_62' => 's', 'dimorphism_63' => 's', 'plural_name_64' => 's', 'gender_65' => 's', 'genus_66' => 's', 'note_67' => 's', 'id_68' => 'l', 'name_69' => 'l', 'description_70' => 'l', 'cost_71' => 'l', 'creation_72' => 'l', 'renovation_73' => 'l', 'destruction_74' => 'l', 'plan_75' => 'l', 'updated_at_76' => 'l', 'id_77' => 'e', 'name_78' => 'e', 'description_79' => 'e', 'creation_80' => 'e', 'renovation_81' => 'e', 'destruction_82' => 'e', 'plan_83' => 'e', 'updated_at_84' => 'e', 'id_85' => 'bp', 'name_86' => 'bp', 'id_87' => 'pr', 'name_88' => 'pr', 'id_89' => 'dt', 'name_90' => 'dt', 'species_id_91' => 'f', 'birthplace_id_92' => 'f', 'father_id_93' => 'f', 'mother_id_94' => 'f', 'provenance_id_95' => 'f', 'destination_id_96' => 'f', 'location_id_97' => 'f', 'enclosure_id_98' => 'f', 'class_id_99' => 's', 'status_id_100' => 's', 'zone_id_101' => 'l', 'location_id_102' => 'e', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Fellow', 'name_1' => 'App\\Entity\\Fellow', 'sex_2' => 'App\\Entity\\Fellow', 'birthday_3' => 'App\\Entity\\Fellow', 'birthday_bis_4' => 'App\\Entity\\Fellow', 'type_5' => 'App\\Entity\\Fellow', 'just_month_6' => 'App\\Entity\\Fellow', 'just_year_7' => 'App\\Entity\\Fellow', 'number_8' => 'App\\Entity\\Fellow', 'father_name_9' => 'App\\Entity\\Fellow', 'mother_name_10' => 'App\\Entity\\Fellow', 'infos_zims_11' => 'App\\Entity\\Fellow', 'arrival_at_12' => 'App\\Entity\\Fellow', 'info_arrival_13' => 'App\\Entity\\Fellow', 'departure_at_14' => 'App\\Entity\\Fellow', 'info_departure_15' => 'App\\Entity\\Fellow', 'departure_status_16' => 'App\\Entity\\Fellow', 'sterilized_17' => 'App\\Entity\\Fellow', 'pending_18' => 'App\\Entity\\Fellow', 'death_after_departure_19' => 'App\\Entity\\Fellow', 'documentary_20' => 'App\\Entity\\Fellow', 'infos_21' => 'App\\Entity\\Fellow', 'created_at_22' => 'App\\Entity\\Fellow', 'updated_at_23' => 'App\\Entity\\Fellow', 'identification_24' => 'App\\Entity\\Fellow', 'date_of_pending_25' => 'App\\Entity\\Fellow', 'subspecies_26' => 'App\\Entity\\Fellow', 'infos_sterilized_27' => 'App\\Entity\\Fellow', 'id_28' => 'App\\Entity\\Species', 'name_29' => 'App\\Entity\\Species', 'scientific_name_30' => 'App\\Entity\\Species', 'bis_name_31' => 'App\\Entity\\Species', 'ordre_32' => 'App\\Entity\\Species', 'family_33' => 'App\\Entity\\Species', 'studbook_34' => 'App\\Entity\\Species', 'arrival_35' => 'App\\Entity\\Species', 'departure_36' => 'App\\Entity\\Species', 'afrique_37' => 'App\\Entity\\Species', 'asie_38' => 'App\\Entity\\Species', 'oceanie_39' => 'App\\Entity\\Species', 'am_nord_40' => 'App\\Entity\\Species', 'am_centrale_41' => 'App\\Entity\\Species', 'am_sud_42' => 'App\\Entity\\Species', 'europe_43' => 'App\\Entity\\Species', 'observation_44' => 'App\\Entity\\Species', 'nbr_eaza_45' => 'App\\Entity\\Species', 'nbr_fr_46' => 'App\\Entity\\Species', 'link_ztl_47' => 'App\\Entity\\Species', 'link_wiki_48' => 'App\\Entity\\Species', 'link_uicn_49' => 'App\\Entity\\Species', 'link_diverse_50' => 'App\\Entity\\Species', 'image_51' => 'App\\Entity\\Species', 'updated_at_52' => 'App\\Entity\\Species', 'habitat_53' => 'App\\Entity\\Species', 'longevity_54' => 'App\\Entity\\Species', 'weight_55' => 'App\\Entity\\Species', 'diet_56' => 'App\\Entity\\Species', 'size_57' => 'App\\Entity\\Species', 'wingspan_58' => 'App\\Entity\\Species', 'social_59' => 'App\\Entity\\Species', 'reproduction_60' => 'App\\Entity\\Species', 'gestation_61' => 'App\\Entity\\Species', 'nbr_child_62' => 'App\\Entity\\Species', 'dimorphism_63' => 'App\\Entity\\Species', 'plural_name_64' => 'App\\Entity\\Species', 'gender_65' => 'App\\Entity\\Species', 'genus_66' => 'App\\Entity\\Species', 'note_67' => 'App\\Entity\\Species', 'id_68' => 'App\\Entity\\Location', 'name_69' => 'App\\Entity\\Location', 'description_70' => 'App\\Entity\\Location', 'cost_71' => 'App\\Entity\\Location', 'creation_72' => 'App\\Entity\\Location', 'renovation_73' => 'App\\Entity\\Location', 'destruction_74' => 'App\\Entity\\Location', 'plan_75' => 'App\\Entity\\Location', 'updated_at_76' => 'App\\Entity\\Location', 'id_77' => 'App\\Entity\\Enclosure', 'name_78' => 'App\\Entity\\Enclosure', 'description_79' => 'App\\Entity\\Enclosure', 'creation_80' => 'App\\Entity\\Enclosure', 'renovation_81' => 'App\\Entity\\Enclosure', 'destruction_82' => 'App\\Entity\\Enclosure', 'plan_83' => 'App\\Entity\\Enclosure', 'updated_at_84' => 'App\\Entity\\Enclosure', 'id_85' => 'App\\Entity\\Zoo', 'name_86' => 'App\\Entity\\Zoo', 'id_87' => 'App\\Entity\\Zoo', 'name_88' => 'App\\Entity\\Zoo', 'id_89' => 'App\\Entity\\Zoo', 'name_90' => 'App\\Entity\\Zoo', ], ], ], ], $o[0], [ [ "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlExecutor' => null, "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'sqlFinalizer' => $o[1], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'resultSetMapping' => $o[2], "\0".'Doctrine\\ORM\\Query\\ParserResult'."\0".'parameterMappings' => [ 'type' => [ 0, ], 'species' => [ 1, ], ], ], ] ); } }];