[ 'sql' => [ 1 => 'SELECT p0_.first_name AS first_name_0, p0_.last_name AS last_name_1, p0_.nationality AS nationality_2, p0_.occupation AS occupation_3, p0_.gender AS gender_4, p0_.date_of_birth AS date_of_birth_5, p0_.social_id AS social_id_6, p0_.marital_status AS marital_status_7, p0_.email AS email_8, p0_.mobile AS mobile_9, p0_.phone AS phone_10, p0_.iban AS iban_11, p0_.bic AS bic_12, p0_.is_beneficiary AS is_beneficiary_13, p0_.relation AS relation_14, p0_.relation_first_name AS relation_first_name_15, p0_.relation_last_name AS relation_last_name_16, p0_.relation_email AS relation_email_17, p0_.relation_phone AS relation_phone_18, p0_.address1 AS address1_19, p0_.address2 AS address2_20, p0_.street_number AS street_number_21, p0_.box AS box_22, p0_.zip AS zip_23, p0_.city AS city_24, p0_.country AS country_25, p0_.is_quick AS is_quick_26, p0_.source_id AS source_id_27, p0_.last_action AS last_action_28, p0_.last_action_at AS last_action_at_29, p0_.created_at AS created_at_30, p0_.updated_at AS updated_at_31, p0_.created_by AS created_by_32, p0_.updated_by AS updated_by_33, p0_.deleted_at AS deleted_at_34, p0_.id AS id_35, p0_.uuid AS uuid_36, p0_.burncenter_id AS burncenter_id_37 FROM patient p0_ LEFT JOIN patient_case p1_ ON p0_.id = p1_.patient_id AND ((p1_.deleted_at IS NULL OR p1_.deleted_at > CURRENT_TIMESTAMP)) WHERE (0 = 0 AND p0_.burncenter_id = ?) AND ((p0_.deleted_at IS NULL OR p0_.deleted_at > CURRENT_TIMESTAMP)) ORDER BY p0_.id DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 't' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', ], ], 'fieldMappings' => [ 2 => [ 'first_name_0' => 'firstName', 'last_name_1' => 'lastName', 'nationality_2' => 'nationality', 'occupation_3' => 'occupation', 'gender_4' => 'gender', 'date_of_birth_5' => 'dateOfBirth', 'social_id_6' => 'socialId', 'marital_status_7' => 'maritalStatus', 'email_8' => 'email', 'mobile_9' => 'mobile', 'phone_10' => 'phone', 'iban_11' => 'iban', 'bic_12' => 'bic', 'is_beneficiary_13' => 'isBeneficiary', 'relation_14' => 'relation', 'relation_first_name_15' => 'relationFirstName', 'relation_last_name_16' => 'relationLastName', 'relation_email_17' => 'relationEmail', 'relation_phone_18' => 'relationPhone', 'address1_19' => 'address1', 'address2_20' => 'address2', 'street_number_21' => 'streetNumber', 'box_22' => 'box', 'zip_23' => 'zip', 'city_24' => 'city', 'country_25' => 'country', 'is_quick_26' => 'isQuick', 'source_id_27' => 'sourceId', 'last_action_28' => 'lastAction', 'last_action_at_29' => 'lastActionAt', 'created_at_30' => 'createdAt', 'updated_at_31' => 'updatedAt', 'created_by_32' => 'createdBy', 'updated_by_33' => 'updatedBy', 'deleted_at_34' => 'deletedAt', 'id_35' => 'id', 'uuid_36' => 'uuid', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\RegBurns\\Domain\\Model\\Patient\\Patient' => [ 't' => [ 'firstName' => 'first_name_0', 'lastName' => 'last_name_1', 'nationality' => 'nationality_2', 'occupation' => 'occupation_3', 'gender' => 'gender_4', 'dateOfBirth' => 'date_of_birth_5', 'socialId' => 'social_id_6', 'maritalStatus' => 'marital_status_7', 'email' => 'email_8', 'mobile' => 'mobile_9', 'phone' => 'phone_10', 'iban' => 'iban_11', 'bic' => 'bic_12', 'isBeneficiary' => 'is_beneficiary_13', 'relation' => 'relation_14', 'relationFirstName' => 'relation_first_name_15', 'relationLastName' => 'relation_last_name_16', 'relationEmail' => 'relation_email_17', 'relationPhone' => 'relation_phone_18', 'address1' => 'address1_19', 'address2' => 'address2_20', 'streetNumber' => 'street_number_21', 'box' => 'box_22', 'zip' => 'zip_23', 'city' => 'city_24', 'country' => 'country_25', 'isQuick' => 'is_quick_26', 'sourceId' => 'source_id_27', 'lastAction' => 'last_action_28', 'lastActionAt' => 'last_action_at_29', 'createdAt' => 'created_at_30', 'updatedAt' => 'updated_at_31', 'createdBy' => 'created_by_32', 'updatedBy' => 'updated_by_33', 'deletedAt' => 'deleted_at_34', 'id' => 'id_35', 'uuid' => 'uuid_36', ], ], ], ], 'typeMappings' => [ 2 => [ 'burncenter_id_37' => 'integer', ], ], 'entityMappings' => [ 2 => [ 't' => null, ], ], 'metaMappings' => [ 2 => [ 'burncenter_id_37' => 'burncenter_id', ], ], 'columnOwnerMap' => [ 2 => [ 'first_name_0' => 't', 'last_name_1' => 't', 'nationality_2' => 't', 'occupation_3' => 't', 'gender_4' => 't', 'date_of_birth_5' => 't', 'social_id_6' => 't', 'marital_status_7' => 't', 'email_8' => 't', 'mobile_9' => 't', 'phone_10' => 't', 'iban_11' => 't', 'bic_12' => 't', 'is_beneficiary_13' => 't', 'relation_14' => 't', 'relation_first_name_15' => 't', 'relation_last_name_16' => 't', 'relation_email_17' => 't', 'relation_phone_18' => 't', 'address1_19' => 't', 'address2_20' => 't', 'street_number_21' => 't', 'box_22' => 't', 'zip_23' => 't', 'city_24' => 't', 'country_25' => 't', 'is_quick_26' => 't', 'source_id_27' => 't', 'last_action_28' => 't', 'last_action_at_29' => 't', 'created_at_30' => 't', 'updated_at_31' => 't', 'created_by_32' => 't', 'updated_by_33' => 't', 'deleted_at_34' => 't', 'id_35' => 't', 'uuid_36' => 't', 'burncenter_id_37' => 't', ], ], 'declaringClasses' => [ 2 => [ 'first_name_0' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'last_name_1' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'nationality_2' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'occupation_3' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'gender_4' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'date_of_birth_5' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'social_id_6' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'marital_status_7' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'email_8' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'mobile_9' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'phone_10' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'iban_11' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'bic_12' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'is_beneficiary_13' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'relation_14' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'relation_first_name_15' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'relation_last_name_16' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'relation_email_17' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'relation_phone_18' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'address1_19' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'address2_20' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'street_number_21' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'box_22' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'zip_23' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'city_24' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'country_25' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'is_quick_26' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'source_id_27' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'last_action_28' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'last_action_at_29' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'created_at_30' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'updated_at_31' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'created_by_32' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'updated_by_33' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'deleted_at_34' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'id_35' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', 'uuid_36' => 'App\\RegBurns\\Domain\\Model\\Patient\\Patient', ], ], ], ], $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' => [ 'burncenterId' => [ 0, ], ], ], ] ); } }];