[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'now' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT a0_.id AS id_0, COALESCE(t1_.content, a0_.title) AS title_1, COALESCE(t2_.content, a0_.subtitle) AS subtitle_2, a0_.slug AS slug_3, COALESCE(t3_.content, a0_.excerpt) AS excerpt_4, COALESCE(t4_.content, a0_.content) AS content_5, a0_.image AS image_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.deleted_at AS deleted_at_9, a0_.is_active AS is_active_10, a0_.published_at AS published_at_11, a0_.is_in_sitemap AS is_in_sitemap_12, a0_.priority AS priority_13, a5_.id AS id_14, COALESCE(t6_.content, a5_.name) AS name_15, a5_.created_at AS created_at_16, a5_.updated_at AS updated_at_17, a5_.deleted_at AS deleted_at_18, a5_.is_active AS is_active_19 FROM article a0_ LEFT JOIN article_article_tag a7_ ON a0_.id = a7_.article_id LEFT JOIN article_tag a5_ ON a5_.id = a7_.article_tag_id LEFT JOIN ext_translations t1_ ON t1_.locale = \'en\' AND t1_.field = \'title\' AND t1_.object_class = \'App\\\\BlogBundle\\\\Entity\\\\Article\' AND t1_.foreign_key = a0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = \'en\' AND t2_.field = \'subtitle\' AND t2_.object_class = \'App\\\\BlogBundle\\\\Entity\\\\Article\' AND t2_.foreign_key = a0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = \'en\' AND t3_.field = \'excerpt\' AND t3_.object_class = \'App\\\\BlogBundle\\\\Entity\\\\Article\' AND t3_.foreign_key = a0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = \'en\' AND t4_.field = \'content\' AND t4_.object_class = \'App\\\\BlogBundle\\\\Entity\\\\Article\' AND t4_.foreign_key = a0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = \'en\' AND t6_.field = \'name\' AND t6_.object_class = \'App\\\\BlogBundle\\\\Entity\\\\ArticleTag\' AND t6_.foreign_key = a5_.id WHERE a0_.is_active = 1 AND ((a0_.published_at IS NULL OR a0_.published_at <= ?)) ORDER BY a0_.published_at DESC, a0_.created_at DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'a' => 'App\\BlogBundle\\Entity\\Article', 'at' => 'App\\BlogBundle\\Entity\\ArticleTag', ], ], 'relationMap' => [ 2 => [ 'at' => 'tags', ], ], 'parentAliasMap' => [ 2 => [ 'at' => 'a', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'title_1' => 'title', 'subtitle_2' => 'subtitle', 'slug_3' => 'slug', 'excerpt_4' => 'excerpt', 'content_5' => 'content', 'image_6' => 'image', 'created_at_7' => 'createdAt', 'updated_at_8' => 'updatedAt', 'deleted_at_9' => 'deletedAt', 'is_active_10' => 'isActive', 'published_at_11' => 'publishedAt', 'is_in_sitemap_12' => 'isInSitemap', 'priority_13' => 'priority', 'id_14' => 'id', 'name_15' => 'name', 'created_at_16' => 'createdAt', 'updated_at_17' => 'updatedAt', 'deleted_at_18' => 'deletedAt', 'is_active_19' => 'isActive', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\BlogBundle\\Entity\\Article' => [ 'a' => [ 'id' => 'id_0', 'title' => 'title_1', 'subtitle' => 'subtitle_2', 'slug' => 'slug_3', 'excerpt' => 'excerpt_4', 'content' => 'content_5', 'image' => 'image_6', 'createdAt' => 'created_at_7', 'updatedAt' => 'updated_at_8', 'deletedAt' => 'deleted_at_9', 'isActive' => 'is_active_10', 'publishedAt' => 'published_at_11', 'isInSitemap' => 'is_in_sitemap_12', 'priority' => 'priority_13', ], ], 'App\\BlogBundle\\Entity\\ArticleTag' => [ 'at' => [ 'id' => 'id_14', 'name' => 'name_15', 'createdAt' => 'created_at_16', 'updatedAt' => 'updated_at_17', 'deletedAt' => 'deleted_at_18', 'isActive' => 'is_active_19', ], ], ], ], 'entityMappings' => [ 2 => [ 'a' => null, ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'a', 'title_1' => 'a', 'subtitle_2' => 'a', 'slug_3' => 'a', 'excerpt_4' => 'a', 'content_5' => 'a', 'image_6' => 'a', 'created_at_7' => 'a', 'updated_at_8' => 'a', 'deleted_at_9' => 'a', 'is_active_10' => 'a', 'published_at_11' => 'a', 'is_in_sitemap_12' => 'a', 'priority_13' => 'a', 'id_14' => 'at', 'name_15' => 'at', 'created_at_16' => 'at', 'updated_at_17' => 'at', 'deleted_at_18' => 'at', 'is_active_19' => 'at', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\BlogBundle\\Entity\\Article', 'title_1' => 'App\\BlogBundle\\Entity\\Article', 'subtitle_2' => 'App\\BlogBundle\\Entity\\Article', 'slug_3' => 'App\\BlogBundle\\Entity\\Article', 'excerpt_4' => 'App\\BlogBundle\\Entity\\Article', 'content_5' => 'App\\BlogBundle\\Entity\\Article', 'image_6' => 'App\\BlogBundle\\Entity\\Article', 'created_at_7' => 'App\\BlogBundle\\Entity\\Article', 'updated_at_8' => 'App\\BlogBundle\\Entity\\Article', 'deleted_at_9' => 'App\\BlogBundle\\Entity\\Article', 'is_active_10' => 'App\\BlogBundle\\Entity\\Article', 'published_at_11' => 'App\\BlogBundle\\Entity\\Article', 'is_in_sitemap_12' => 'App\\BlogBundle\\Entity\\Article', 'priority_13' => 'App\\BlogBundle\\Entity\\Article', 'id_14' => 'App\\BlogBundle\\Entity\\ArticleTag', 'name_15' => 'App\\BlogBundle\\Entity\\ArticleTag', 'created_at_16' => 'App\\BlogBundle\\Entity\\ArticleTag', 'updated_at_17' => 'App\\BlogBundle\\Entity\\ArticleTag', 'deleted_at_18' => 'App\\BlogBundle\\Entity\\ArticleTag', 'is_active_19' => 'App\\BlogBundle\\Entity\\ArticleTag', ], ], ], ], $o[0], [] ); } }];