[ 'sql' => [ 1 => 'SELECT t0_.c_id AS c_id_0, t0_.c_code AS c_code_1, t0_.c_art_name AS c_art_name_2, t0_.c_art_description AS c_art_description_3, t0_.c_lastname AS c_lastname_4, t0_.c_firstname AS c_firstname_5, t0_.c_age AS c_age_6, t0_.c_gender AS c_gender_7, t0_.c_age_group AS c_age_group_8, t0_.c_birth_date AS c_birth_date_9, t0_.c_guardian_lastname AS c_guardian_lastname_10, t0_.c_guardian_firstname AS c_guardian_firstname_11, t0_.c_guardian_phone AS c_guardian_phone_12, t0_.c_guardian_relation AS c_guardian_relation_13, t0_.c_postal_address AS c_postal_address_14, t0_.c_address_country AS c_address_country_15, t0_.c_address_city AS c_address_city_16, t0_.c_address_detail AS c_address_detail_17, t0_.c_contact_email AS c_contact_email_18, t0_.c_contact_phone AS c_contact_phone_19, t0_.c_school_name AS c_school_name_20, t0_.c_received_channel AS c_received_channel_21, t0_.c_agreed AS c_agreed_22, t0_.c_signature AS c_signature_23, t0_.c_image_url AS c_image_url_24, t0_.c_video_url AS c_video_url_25, t0_.c_created_at AS c_created_at_26, t0_.c_updated_at AS c_updated_at_27 FROM t_contest_request t0_ WHERE t0_.c_code IS NOT NULL AND t0_.c_code <> \'\' ORDER BY t0_.c_id DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'p' => 'App\\Entity\\ContestRequest', ], ], 'fieldMappings' => [ 2 => [ 'c_id_0' => 'id', 'c_code_1' => 'code', 'c_art_name_2' => 'artName', 'c_art_description_3' => 'artDescription', 'c_lastname_4' => 'lastname', 'c_firstname_5' => 'firstname', 'c_age_6' => 'age', 'c_gender_7' => 'gender', 'c_age_group_8' => 'ageGroup', 'c_birth_date_9' => 'birthDate', 'c_guardian_lastname_10' => 'guardianLastname', 'c_guardian_firstname_11' => 'guardianFirstname', 'c_guardian_phone_12' => 'guardianPhone', 'c_guardian_relation_13' => 'guardianRelation', 'c_postal_address_14' => 'postalAddress', 'c_address_country_15' => 'addressCountry', 'c_address_city_16' => 'addressCity', 'c_address_detail_17' => 'addressDetail', 'c_contact_email_18' => 'contactEmail', 'c_contact_phone_19' => 'contactPhone', 'c_school_name_20' => 'schoolName', 'c_received_channel_21' => 'receivedChannel', 'c_agreed_22' => 'agreed', 'c_signature_23' => 'signature', 'c_image_url_24' => 'imageUrl', 'c_video_url_25' => 'videoUrl', 'c_created_at_26' => 'createdAt', 'c_updated_at_27' => 'updatedAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\ContestRequest' => [ 'p' => [ 'id' => 'c_id_0', 'code' => 'c_code_1', 'artName' => 'c_art_name_2', 'artDescription' => 'c_art_description_3', 'lastname' => 'c_lastname_4', 'firstname' => 'c_firstname_5', 'age' => 'c_age_6', 'gender' => 'c_gender_7', 'ageGroup' => 'c_age_group_8', 'birthDate' => 'c_birth_date_9', 'guardianLastname' => 'c_guardian_lastname_10', 'guardianFirstname' => 'c_guardian_firstname_11', 'guardianPhone' => 'c_guardian_phone_12', 'guardianRelation' => 'c_guardian_relation_13', 'postalAddress' => 'c_postal_address_14', 'addressCountry' => 'c_address_country_15', 'addressCity' => 'c_address_city_16', 'addressDetail' => 'c_address_detail_17', 'contactEmail' => 'c_contact_email_18', 'contactPhone' => 'c_contact_phone_19', 'schoolName' => 'c_school_name_20', 'receivedChannel' => 'c_received_channel_21', 'agreed' => 'c_agreed_22', 'signature' => 'c_signature_23', 'imageUrl' => 'c_image_url_24', 'videoUrl' => 'c_video_url_25', 'createdAt' => 'c_created_at_26', 'updatedAt' => 'c_updated_at_27', ], ], ], ], 'entityMappings' => [ 2 => [ 'p' => null, ], ], 'columnOwnerMap' => [ 2 => [ 'c_id_0' => 'p', 'c_code_1' => 'p', 'c_art_name_2' => 'p', 'c_art_description_3' => 'p', 'c_lastname_4' => 'p', 'c_firstname_5' => 'p', 'c_age_6' => 'p', 'c_gender_7' => 'p', 'c_age_group_8' => 'p', 'c_birth_date_9' => 'p', 'c_guardian_lastname_10' => 'p', 'c_guardian_firstname_11' => 'p', 'c_guardian_phone_12' => 'p', 'c_guardian_relation_13' => 'p', 'c_postal_address_14' => 'p', 'c_address_country_15' => 'p', 'c_address_city_16' => 'p', 'c_address_detail_17' => 'p', 'c_contact_email_18' => 'p', 'c_contact_phone_19' => 'p', 'c_school_name_20' => 'p', 'c_received_channel_21' => 'p', 'c_agreed_22' => 'p', 'c_signature_23' => 'p', 'c_image_url_24' => 'p', 'c_video_url_25' => 'p', 'c_created_at_26' => 'p', 'c_updated_at_27' => 'p', ], ], 'declaringClasses' => [ 2 => [ 'c_id_0' => 'App\\Entity\\ContestRequest', 'c_code_1' => 'App\\Entity\\ContestRequest', 'c_art_name_2' => 'App\\Entity\\ContestRequest', 'c_art_description_3' => 'App\\Entity\\ContestRequest', 'c_lastname_4' => 'App\\Entity\\ContestRequest', 'c_firstname_5' => 'App\\Entity\\ContestRequest', 'c_age_6' => 'App\\Entity\\ContestRequest', 'c_gender_7' => 'App\\Entity\\ContestRequest', 'c_age_group_8' => 'App\\Entity\\ContestRequest', 'c_birth_date_9' => 'App\\Entity\\ContestRequest', 'c_guardian_lastname_10' => 'App\\Entity\\ContestRequest', 'c_guardian_firstname_11' => 'App\\Entity\\ContestRequest', 'c_guardian_phone_12' => 'App\\Entity\\ContestRequest', 'c_guardian_relation_13' => 'App\\Entity\\ContestRequest', 'c_postal_address_14' => 'App\\Entity\\ContestRequest', 'c_address_country_15' => 'App\\Entity\\ContestRequest', 'c_address_city_16' => 'App\\Entity\\ContestRequest', 'c_address_detail_17' => 'App\\Entity\\ContestRequest', 'c_contact_email_18' => 'App\\Entity\\ContestRequest', 'c_contact_phone_19' => 'App\\Entity\\ContestRequest', 'c_school_name_20' => 'App\\Entity\\ContestRequest', 'c_received_channel_21' => 'App\\Entity\\ContestRequest', 'c_agreed_22' => 'App\\Entity\\ContestRequest', 'c_signature_23' => 'App\\Entity\\ContestRequest', 'c_image_url_24' => 'App\\Entity\\ContestRequest', 'c_video_url_25' => 'App\\Entity\\ContestRequest', 'c_created_at_26' => 'App\\Entity\\ContestRequest', 'c_updated_at_27' => 'App\\Entity\\ContestRequest', ], ], ], ], $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' => [], ], ] ); }];