[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'match' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT t0_.id AS id_0, t0_.placed_at AS placed_at_1, j1_.id AS id_2, j1_.code AS code_3, j1_.name AS name_4, j1_.title AS title_5, j1_.tag AS tag_6, j1_.description AS description_7, j1_.technical_explanation AS technical_explanation_8, j1_.image AS image_9, j1_.active AS active_10, j1_.sort_order AS sort_order_11, j1_.live_story_templates AS live_story_templates_12, t2_.id AS id_13, t2_.name AS name_14, t2_.logo AS logo_15, t2_.slogan AS slogan_16, t2_.vendee AS vendee_17, t2_.created_at AS created_at_18, t2_.interview_published_at AS interview_published_at_19, t2_.interview_enabled AS interview_enabled_20, t2_.interview_enabled_at AS interview_enabled_at_21, t3_.id AS id_22, t3_.name AS name_23, t3_.logo AS logo_24, t3_.slogan AS slogan_25, t3_.vendee AS vendee_26, t3_.created_at AS created_at_27, t3_.interview_published_at AS interview_published_at_28, t3_.interview_enabled AS interview_enabled_29, t3_.interview_enabled_at AS interview_enabled_at_30, t0_.team_id AS team_id_31, t0_.joker_id AS joker_id_32, t0_.match_id AS match_id_33, t0_.target_team_id AS target_team_id_34, t2_.favorite_country_id AS favorite_country_id_35, t2_.interview_published_by_id AS interview_published_by_id_36, t3_.favorite_country_id AS favorite_country_id_37, t3_.interview_published_by_id AS interview_published_by_id_38 FROM team_joker_usage t0_ INNER JOIN joker j1_ ON t0_.joker_id = j1_.id INNER JOIN team t2_ ON t0_.team_id = t2_.id LEFT JOIN team t3_ ON t0_.target_team_id = t3_.id WHERE t0_.match_id = ?', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'u' => 'App\\Entity\\TeamJokerUsage', 'j' => 'App\\Entity\\Joker', 't' => 'App\\Entity\\Team', 'tt' => 'App\\Entity\\Team', ], ], 'relationMap' => [ 2 => [ 'j' => 'joker', 't' => 'team', 'tt' => 'targetTeam', ], ], 'parentAliasMap' => [ 2 => [ 'j' => 'u', 't' => 'u', 'tt' => 'u', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'placed_at_1' => 'placedAt', 'id_2' => 'id', 'code_3' => 'code', 'name_4' => 'name', 'title_5' => 'title', 'tag_6' => 'tag', 'description_7' => 'description', 'technical_explanation_8' => 'technicalExplanation', 'image_9' => 'image', 'active_10' => 'active', 'sort_order_11' => 'sortOrder', 'live_story_templates_12' => 'liveStoryTemplates', 'id_13' => 'id', 'name_14' => 'name', 'logo_15' => 'logo', 'slogan_16' => 'slogan', 'vendee_17' => 'vendee', 'created_at_18' => 'createdAt', 'interview_published_at_19' => 'interviewPublishedAt', 'interview_enabled_20' => 'interviewEnabled', 'interview_enabled_at_21' => 'interviewEnabledAt', 'id_22' => 'id', 'name_23' => 'name', 'logo_24' => 'logo', 'slogan_25' => 'slogan', 'vendee_26' => 'vendee', 'created_at_27' => 'createdAt', 'interview_published_at_28' => 'interviewPublishedAt', 'interview_enabled_29' => 'interviewEnabled', 'interview_enabled_at_30' => 'interviewEnabledAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\TeamJokerUsage' => [ 'u' => [ 'id' => 'id_0', 'placedAt' => 'placed_at_1', ], ], 'App\\Entity\\Joker' => [ 'j' => [ 'id' => 'id_2', 'code' => 'code_3', 'name' => 'name_4', 'title' => 'title_5', 'tag' => 'tag_6', 'description' => 'description_7', 'technicalExplanation' => 'technical_explanation_8', 'image' => 'image_9', 'active' => 'active_10', 'sortOrder' => 'sort_order_11', 'liveStoryTemplates' => 'live_story_templates_12', ], ], 'App\\Entity\\Team' => [ 't' => [ 'id' => 'id_13', 'name' => 'name_14', 'logo' => 'logo_15', 'slogan' => 'slogan_16', 'vendee' => 'vendee_17', 'createdAt' => 'created_at_18', 'interviewPublishedAt' => 'interview_published_at_19', 'interviewEnabled' => 'interview_enabled_20', 'interviewEnabledAt' => 'interview_enabled_at_21', ], 'tt' => [ 'id' => 'id_22', 'name' => 'name_23', 'logo' => 'logo_24', 'slogan' => 'slogan_25', 'vendee' => 'vendee_26', 'createdAt' => 'created_at_27', 'interviewPublishedAt' => 'interview_published_at_28', 'interviewEnabled' => 'interview_enabled_29', 'interviewEnabledAt' => 'interview_enabled_at_30', ], ], ], ], 'typeMappings' => [ 2 => [ 'team_id_31' => 'integer', 'joker_id_32' => 'integer', 'match_id_33' => 'integer', 'target_team_id_34' => 'integer', 'favorite_country_id_35' => 'integer', 'interview_published_by_id_36' => 'integer', 'favorite_country_id_37' => 'integer', 'interview_published_by_id_38' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'u' => null, ], ], 'metaMappings' => [ 2 => [ 'team_id_31' => 'team_id', 'joker_id_32' => 'joker_id', 'match_id_33' => 'match_id', 'target_team_id_34' => 'target_team_id', 'favorite_country_id_35' => 'favorite_country_id', 'interview_published_by_id_36' => 'interview_published_by_id', 'favorite_country_id_37' => 'favorite_country_id', 'interview_published_by_id_38' => 'interview_published_by_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'u', 'placed_at_1' => 'u', 'id_2' => 'j', 'code_3' => 'j', 'name_4' => 'j', 'title_5' => 'j', 'tag_6' => 'j', 'description_7' => 'j', 'technical_explanation_8' => 'j', 'image_9' => 'j', 'active_10' => 'j', 'sort_order_11' => 'j', 'live_story_templates_12' => 'j', 'id_13' => 't', 'name_14' => 't', 'logo_15' => 't', 'slogan_16' => 't', 'vendee_17' => 't', 'created_at_18' => 't', 'interview_published_at_19' => 't', 'interview_enabled_20' => 't', 'interview_enabled_at_21' => 't', 'id_22' => 'tt', 'name_23' => 'tt', 'logo_24' => 'tt', 'slogan_25' => 'tt', 'vendee_26' => 'tt', 'created_at_27' => 'tt', 'interview_published_at_28' => 'tt', 'interview_enabled_29' => 'tt', 'interview_enabled_at_30' => 'tt', 'team_id_31' => 'u', 'joker_id_32' => 'u', 'match_id_33' => 'u', 'target_team_id_34' => 'u', 'favorite_country_id_35' => 't', 'interview_published_by_id_36' => 't', 'favorite_country_id_37' => 'tt', 'interview_published_by_id_38' => 'tt', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\TeamJokerUsage', 'placed_at_1' => 'App\\Entity\\TeamJokerUsage', 'id_2' => 'App\\Entity\\Joker', 'code_3' => 'App\\Entity\\Joker', 'name_4' => 'App\\Entity\\Joker', 'title_5' => 'App\\Entity\\Joker', 'tag_6' => 'App\\Entity\\Joker', 'description_7' => 'App\\Entity\\Joker', 'technical_explanation_8' => 'App\\Entity\\Joker', 'image_9' => 'App\\Entity\\Joker', 'active_10' => 'App\\Entity\\Joker', 'sort_order_11' => 'App\\Entity\\Joker', 'live_story_templates_12' => 'App\\Entity\\Joker', 'id_13' => 'App\\Entity\\Team', 'name_14' => 'App\\Entity\\Team', 'logo_15' => 'App\\Entity\\Team', 'slogan_16' => 'App\\Entity\\Team', 'vendee_17' => 'App\\Entity\\Team', 'created_at_18' => 'App\\Entity\\Team', 'interview_published_at_19' => 'App\\Entity\\Team', 'interview_enabled_20' => 'App\\Entity\\Team', 'interview_enabled_at_21' => 'App\\Entity\\Team', 'id_22' => 'App\\Entity\\Team', 'name_23' => 'App\\Entity\\Team', 'logo_24' => 'App\\Entity\\Team', 'slogan_25' => 'App\\Entity\\Team', 'vendee_26' => 'App\\Entity\\Team', 'created_at_27' => 'App\\Entity\\Team', 'interview_published_at_28' => 'App\\Entity\\Team', 'interview_enabled_29' => 'App\\Entity\\Team', 'interview_enabled_at_30' => 'App\\Entity\\Team', ], ], ], ], $o[0], [] ); } }];