[
"sql" => "SELECT DISTINCT b0_.id AS id_0, b0_.name AS name_1, b0_.logo AS logo_2, b0_.locality AS locality_3, b0_.position AS position_4, b0_.latitude AS latitude_5, b0_.longitude AS longitude_6, b0_.facebook AS facebook_7, b0_.instagram AS instagram_8, b0_.website AS website_9, b0_.untapped AS untapped_10, b0_.twitter AS twitter_11, b0_.white_bg AS white_bg_12, b1_.id AS id_13, b1_.year AS year_14, b2_.id AS id_15, b2_.name AS name_16, b2_.alcool AS alcool_17, b2_.type AS type_18, b2_.position AS position_19, b3_.id AS id_20, b3_.keyword AS keyword_21, b3_.position AS position_22, b1_.brewer_id AS brewer_id_23, b2_.brewer_id AS brewer_id_24, b3_.beer_id AS beer_id_25 FROM brewer b0_ LEFT JOIN brewer_year b1_ ON b0_.id = b1_.brewer_id LEFT JOIN beer b2_ ON b0_.id = b2_.brewer_id LEFT JOIN beer_keyword b3_ ON b2_.id = b3_.beer_id LEFT JOIN brewer_year b4_ ON b0_.id = b4_.brewer_id AND (b4_.year = ?) WHERE b4_.id IS NULL ORDER BY b0_.position ASC, b1_.year DESC, b1_.id ASC, b2_.position ASC, b2_.id ASC, b3_.position ASC, b3_.id ASC"
"params" => [
1 => 2026
]
"types" => [
1 => Doctrine\DBAL\ParameterType {#931
+name: "INTEGER"
}
]
]