[ '_sqlExecutor' => [ $o[1], ], '_resultSetMapping' => [ $o[2], ], '_parameterMappings' => [ [ 'active' => [ 0, ], 'isEu' => [ 1, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\AbstractSqlExecutor' => [ '_sqlStatements' => [ 1 => 'SELECT IF(w0_.limited_to IS NULL, 1, 0) AS sclr_0, w0_.id AS id_1, w0_.first_name AS first_name_2, w0_.last_name AS last_name_3, w0_.salutation AS salutation_4, w0_.position AS position_5, w0_.first_aid AS first_aid_6, w0_.first_aid_limited_to AS first_aid_limited_to_7, w0_.postcode AS postcode_8, w0_.city AS city_9, w0_.address AS address_10, w0_.birthday AS birthday_11, w0_.birthday_city AS birthday_city_12, w0_.social_security_number AS social_security_number_13, w0_.pensioner AS pensioner_14, w0_.pension_type AS pension_type_15, w0_.number AS number_16, w0_.team AS team_17, w0_.first_day AS first_day_18, w0_.last_day AS last_day_19, w0_.term_contract_amount AS term_contract_amount_20, w0_.phone AS phone_21, w0_.email AS email_22, w0_.is_active AS is_active_23, w0_.pin AS pin_24, w0_.limited_to AS limited_to_25, w0_.activated_at AS activated_at_26, c1_.id AS id_27, c1_.name AS name_28, c1_.name_de AS name_de_29, c1_.code AS code_30, c1_.currency_code AS currency_code_31, c1_.currency_name AS currency_name_32, c1_.is_eu AS is_eu_33, c1_.is_without_postcode AS is_without_postcode_34, w0_.country_id AS country_id_35 FROM worker w0_ INNER JOIN country c1_ ON w0_.country_id = c1_.id WHERE w0_.is_active = ? AND c1_.is_eu = ? ORDER BY sclr_0 ASC, w0_.limited_to ASC, w0_.number ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'w' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'c' => 'Emgmbh\\UserBundle\\Entity\\Country', ], ], 'relationMap' => [ 2 => [ 'c' => 'country', ], ], 'parentAliasMap' => [ 2 => [ 'c' => 'w', ], ], 'fieldMappings' => [ 2 => [ 'id_1' => 'id', 'first_name_2' => 'firstName', 'last_name_3' => 'lastName', 'salutation_4' => 'salutation', 'position_5' => 'position', 'first_aid_6' => 'firstAid', 'first_aid_limited_to_7' => 'firstAidLimitedTo', 'postcode_8' => 'postcode', 'city_9' => 'city', 'address_10' => 'address', 'birthday_11' => 'birthday', 'birthday_city_12' => 'birthdayCity', 'social_security_number_13' => 'socialSecurityNumber', 'pensioner_14' => 'pensioner', 'pension_type_15' => 'pensionType', 'number_16' => 'number', 'team_17' => 'team', 'first_day_18' => 'firstDay', 'last_day_19' => 'lastDay', 'term_contract_amount_20' => 'termContractAmount', 'phone_21' => 'phone', 'email_22' => 'email', 'is_active_23' => 'isActive', 'pin_24' => 'pin', 'limited_to_25' => 'limitedTo', 'activated_at_26' => 'activatedAt', 'id_27' => 'id', 'name_28' => 'name', 'name_de_29' => 'nameDe', 'code_30' => 'code', 'currency_code_31' => 'currencyCode', 'currency_name_32' => 'currencyName', 'is_eu_33' => 'isEu', 'is_without_postcode_34' => 'isWithoutPostcode', ], ], 'typeMappings' => [ 2 => [ 'country_id_35' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'w' => null, ], ], 'metaMappings' => [ 2 => [ 'country_id_35' => 'country_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_1' => 'w', 'first_name_2' => 'w', 'last_name_3' => 'w', 'salutation_4' => 'w', 'position_5' => 'w', 'first_aid_6' => 'w', 'first_aid_limited_to_7' => 'w', 'postcode_8' => 'w', 'city_9' => 'w', 'address_10' => 'w', 'birthday_11' => 'w', 'birthday_city_12' => 'w', 'social_security_number_13' => 'w', 'pensioner_14' => 'w', 'pension_type_15' => 'w', 'number_16' => 'w', 'team_17' => 'w', 'first_day_18' => 'w', 'last_day_19' => 'w', 'term_contract_amount_20' => 'w', 'phone_21' => 'w', 'email_22' => 'w', 'is_active_23' => 'w', 'pin_24' => 'w', 'limited_to_25' => 'w', 'activated_at_26' => 'w', 'id_27' => 'c', 'name_28' => 'c', 'name_de_29' => 'c', 'code_30' => 'c', 'currency_code_31' => 'c', 'currency_name_32' => 'c', 'is_eu_33' => 'c', 'is_without_postcode_34' => 'c', 'country_id_35' => 'w', ], ], 'declaringClasses' => [ 2 => [ 'id_1' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_name_2' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'last_name_3' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'salutation_4' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'position_5' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_aid_6' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_aid_limited_to_7' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'postcode_8' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'city_9' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'address_10' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'birthday_11' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'birthday_city_12' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'social_security_number_13' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'pensioner_14' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'pension_type_15' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'number_16' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'team_17' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'first_day_18' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'last_day_19' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'term_contract_amount_20' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'phone_21' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'email_22' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'is_active_23' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'pin_24' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'limited_to_25' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'activated_at_26' => 'Emgmbh\\UserBundle\\Entity\\Worker', 'id_27' => 'Emgmbh\\UserBundle\\Entity\\Country', 'name_28' => 'Emgmbh\\UserBundle\\Entity\\Country', 'name_de_29' => 'Emgmbh\\UserBundle\\Entity\\Country', 'code_30' => 'Emgmbh\\UserBundle\\Entity\\Country', 'currency_code_31' => 'Emgmbh\\UserBundle\\Entity\\Country', 'currency_name_32' => 'Emgmbh\\UserBundle\\Entity\\Country', 'is_eu_33' => 'Emgmbh\\UserBundle\\Entity\\Country', 'is_without_postcode_34' => 'Emgmbh\\UserBundle\\Entity\\Country', ], ], ], ], $o[0], [] ); }];