array:3 [ "total" => 45 "categories" => array:5 [ "rose" => array:4 [ "url" => "/wine-bottles?field_tip_vina_target_id=114" "title" => "Роз" "category" => null "count" => 2 ] "red" => array:4 [ "url" => "/wine-bottles?field_tip_vina_target_id=34" "title" => "Крас" "category" => null "count" => 21 ] "white" => array:4 [ "url" => "/wine-bottles?field_tip_vina_target_id=35" "title" => "Бел" "category" => null "count" => 10 ] "quiet" => array:4 [ "url" => "/wine-bottles?field_kategoriya_target_id=3" "title" => "Тихие" "category" => true "count" => 33 ] "sparkling" => array:4 [ "url" => "/wine-bottles?field_kategoriya_target_id=2" "title" => "Игристые" "category" => true "count" => 12 ] ] "countries" => array:12 [ 0 => array:5 [ "term" => "Россия" "term_id" => "9" "term_url" => "/wine-bottles?field_strana_target_id=9" "count" => 17 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=9&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 5 "url" => "/wine-bottles?field_strana_target_id=9&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 6 "url" => "/wine-bottles?field_strana_target_id=9&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 12 "url" => "/wine-bottles?field_strana_target_id=9&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 5 "url" => "/wine-bottles?field_strana_target_id=9&field_kategoriya_target_id=2" "category" => true ] ] ] 1 => array:5 [ "term" => "Испания" "term_id" => "12" "term_url" => "/wine-bottles?field_strana_target_id=12" "count" => 5 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=12&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 4 "url" => "/wine-bottles?field_strana_target_id=12&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=12&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 4 "url" => "/wine-bottles?field_strana_target_id=12&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=12&field_kategoriya_target_id=2" "category" => true ] ] ] 2 => array:5 [ "term" => "Италия" "term_id" => "11" "term_url" => "/wine-bottles?field_strana_target_id=11" "count" => 5 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=11&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 5 "url" => "/wine-bottles?field_strana_target_id=11&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=11&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 5 "url" => "/wine-bottles?field_strana_target_id=11&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=11&field_kategoriya_target_id=2" "category" => true ] ] ] 3 => array:5 [ "term" => "Франция" "term_id" => "50" "term_url" => "/wine-bottles?field_strana_target_id=50" "count" => 5 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=50&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 4 "url" => "/wine-bottles?field_strana_target_id=50&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=50&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 5 "url" => "/wine-bottles?field_strana_target_id=50&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=50&field_kategoriya_target_id=2" "category" => true ] ] ] 4 => array:5 [ "term" => "Шампань" "term_id" => "10" "term_url" => "/wine-bottles?field_strana_target_id=10" "count" => 4 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=10&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=10&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=10&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=10&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 4 "url" => "/wine-bottles?field_strana_target_id=10&field_kategoriya_target_id=2" "category" => true ] ] ] 5 => array:5 [ "term" => "Австрия" "term_id" => "18" "term_url" => "/wine-bottles?field_strana_target_id=18" "count" => 2 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=18&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=18&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=18&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=18&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=18&field_kategoriya_target_id=2" "category" => true ] ] ] 6 => array:5 [ "term" => "США" "term_id" => "22" "term_url" => "/wine-bottles?field_strana_target_id=22" "count" => 2 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=22&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=22&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=22&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 2 "url" => "/wine-bottles?field_strana_target_id=22&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=22&field_kategoriya_target_id=2" "category" => true ] ] ] 7 => array:5 [ "term" => "Австралия" "term_id" => "21" "term_url" => "/wine-bottles?field_strana_target_id=21" "count" => 1 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=21&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=21&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=21&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=21&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=21&field_kategoriya_target_id=2" "category" => true ] ] ] 8 => array:5 [ "term" => "Аргентина" "term_id" => "19" "term_url" => "/wine-bottles?field_strana_target_id=19" "count" => 1 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=19&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=19&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=19&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=19&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=19&field_kategoriya_target_id=2" "category" => true ] ] ] 9 => array:5 [ "term" => "Германия" "term_id" => "17" "term_url" => "/wine-bottles?field_strana_target_id=17" "count" => 1 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=17&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=17&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=17&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=17&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=17&field_kategoriya_target_id=2" "category" => true ] ] ] 10 => array:5 [ "term" => "Канада" "term_id" => "132" "term_url" => "/wine-bottles?field_strana_target_id=132" "count" => 1 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=132&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=132&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=132&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=132&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=132&field_kategoriya_target_id=2" "category" => true ] ] ] 11 => array:5 [ "term" => "Новая зеландия" "term_id" => "13" "term_url" => "/wine-bottles?field_strana_target_id=13" "count" => 1 "wine_types" => array:5 [ "rose" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=13&field_tip_vina_target_id=114" "category" => null ] "red" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=13&field_tip_vina_target_id=34" "category" => null ] "white" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=13&field_tip_vina_target_id=35" "category" => null ] "quiet" => array:3 [ "count" => 1 "url" => "/wine-bottles?field_strana_target_id=13&field_kategoriya_target_id=3" "category" => true ] "sparkling" => array:3 [ "count" => 0 "url" => "/wine-bottles?field_strana_target_id=13&field_kategoriya_target_id=2" "category" => true ] ] ] ] ]
Моносорт (тихие)
Всего
Рислинг
Алиготе
Каберне Совиньон
Менсия
Неббиоло
Темпранильо
Видаль
Зинфандель
Красностоп Золотовский
Пино Нуар
Пти Вердо
Ркацители
Санджовезе
Совиньон Блан
Шардоне
Шенен Блан
Итого:
23
array:2 [ "total" => 23 "grapes" => array:16 [ 0 => array:4 [ "term" => "Рислинг" "count" => 3 "url" => "/wine-bottles?field_vinograd_target_id=%D0%A0%D0%B8%D1%81%D0%BB%D0%B8%D0%BD%D0%B3&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '47') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 1 => array:4 [ "term" => "Алиготе" "count" => 2 "url" => "/wine-bottles?field_vinograd_target_id=%D0%90%D0%BB%D0%B8%D0%B3%D0%BE%D1%82%D0%B5&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '56') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 2 => array:4 [ "term" => "Каберне Совиньон" "count" => 2 "url" => "/wine-bottles?field_vinograd_target_id=%D0%9A%D0%B0%D0%B1%D0%B5%D1%80%D0%BD%D0%B5%20%D0%A1%D0%BE%D0%B2%D0%B8%D0%BD%D1%8C%D0%BE%D0%BD&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '88') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 3 => array:4 [ "term" => "Менсия" "count" => 2 "url" => "/wine-bottles?field_vinograd_target_id=%D0%9C%D0%B5%D0%BD%D1%81%D0%B8%D1%8F&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '128') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 4 => array:4 [ "term" => "Неббиоло" "count" => 2 "url" => "/wine-bottles?field_vinograd_target_id=%D0%9D%D0%B5%D0%B1%D0%B1%D0%B8%D0%BE%D0%BB%D0%BE&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '107') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 5 => array:4 [ "term" => "Темпранильо" "count" => 2 "url" => "/wine-bottles?field_vinograd_target_id=%D0%A2%D0%B5%D0%BC%D0%BF%D1%80%D0%B0%D0%BD%D0%B8%D0%BB%D1%8C%D0%BE&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '129') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 6 => array:4 [ "term" => "Видаль" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%92%D0%B8%D0%B4%D0%B0%D0%BB%D1%8C&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '131') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 7 => array:4 [ "term" => "Зинфандель" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%97%D0%B8%D0%BD%D1%84%D0%B0%D0%BD%D0%B4%D0%B5%D0%BB%D1%8C&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '125') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 8 => array:4 [ "term" => "Красностоп Золотовский" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%9A%D1%80%D0%B0%D1%81%D0%BD%D0%BE%D1%81%D1%82%D0%BE%D0%BF%20%D0%97%D0%BE%D0%BB%D0%BE%D1%82%D0%BE%D0%B2%D1%81%D0%BA%D0%B8%D0%B9&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '110') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 9 => array:4 [ "term" => "Пино Нуар" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%9F%D0%B8%D0%BD%D0%BE%20%D0%9D%D1%83%D0%B0%D1%80&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '38') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 10 => array:4 [ "term" => "Пти Вердо" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%9F%D1%82%D0%B8%20%D0%92%D0%B5%D1%80%D0%B4%D0%BE&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '111') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 11 => array:4 [ "term" => "Ркацители" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%A0%D0%BA%D0%B0%D1%86%D0%B8%D1%82%D0%B5%D0%BB%D0%B8&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '62') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 12 => array:4 [ "term" => "Санджовезе" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%A1%D0%B0%D0%BD%D0%B4%D0%B6%D0%BE%D0%B2%D0%B5%D0%B7%D0%B5&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '130') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 13 => array:4 [ "term" => "Совиньон Блан" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%A1%D0%BE%D0%B2%D0%B8%D0%BD%D1%8C%D0%BE%D0%BD%20%D0%91%D0%BB%D0%B0%D0%BD&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '63') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 14 => array:4 [ "term" => "Шардоне" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%A8%D0%B0%D1%80%D0%B4%D0%BE%D0%BD%D0%B5&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '37') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] 15 => array:4 [ "term" => "Шенен Блан" "count" => 1 "url" => "/wine-bottles?field_vinograd_target_id=%D0%A8%D0%B5%D0%BD%D0%B5%D0%BD%20%D0%91%D0%BB%D0%B0%D0%BD&field_kategoriya_target_id=3" "sql" => """ SELECT "base_table"."vid" AS "vid", "base_table"."nid" AS "nid"\n FROM\n "node" "base_table"\n INNER JOIN "node_field_data" "node_field_data" ON "node_field_data"."nid" = "base_table"."nid"\n INNER JOIN "node__field_cellar" "node__field_cellar" ON "node__field_cellar"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_kategoriya" "node__field_kategoriya" ON "node__field_kategoriya"."entity_id" = "base_table"."nid"\n INNER JOIN "node__field_vinograd" "node__field_vinograd" ON "node__field_vinograd"."entity_id" = "base_table"."nid"\n LEFT JOIN "node__field_vinograd" "node__field_vinograd_2" ON "node__field_vinograd_2"."entity_id" = "base_table"."nid" AND "node__field_vinograd_2"."delta" = '1'\n WHERE ("node_field_data"."type" = 'wine') AND ("node__field_cellar"."field_cellar_value" = '1') AND ("node__field_kategoriya"."field_kategoriya_target_id" = '3') AND ("node_field_data"."status" = '1') AND ("node__field_vinograd"."field_vinograd_target_id" = '83') AND ("node__field_vinograd_2"."field_vinograd_target_id" IS NULL)\n GROUP BY "base_table"."vid", "base_table"."nid" """ ] ] ]