0

Er steken 0 items in uw winkelwagentje

Het winkelwagentje is leeg

Rode wijnen

Sembro 2018
Jaro
Prijs per eenheid : € 10,30
stdClass Object ( [virtuemart_manufacturer_id] => Array ( [0] => 15 ) [mf_name] => Jaro [slug] => sembro [mf_email] => info@puertadelsol.be [mf_desc] =>

Op één van de beste landgoederen van D.O. Ribera del Duero bouwde de Grupo Iberian haar bodega ‘El Jaro’, 105 ha groot. 1 km verder stroomt de rivier Duero, die samen met de ondergrond en de oriëntatie van de wijngaarden de basis vormen van de uitstekende rode wijnen op basis van de Tinto Fino-druif.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.vinosiberian.com/ [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => ec1c0bf0a4734ca9d65e607d7d82202c [_tbl:protected] => #__virtuemart_products [_tbl_lang:protected] => #__virtuemart_products_nl_nl [_tbl_key:protected] => virtuemart_product_id [_tbl_keys:protected] => Array ( [0] => virtuemart_product_id ) [_pkey:protected] => virtuemart_product_id [_pkeyForm:protected] => cid [_obkeys:protected] => Array ( [product_name] => 1 [slug] => 1 ) [_unique:protected] => 1 [_unique_name:protected] => Array ( [slug] => 1 ) [_orderingKey:protected] => ordering [_slugAutoName:protected] => product_name [_slugName:protected] => slug [_db:protected] => JDatabaseDriverMysqli Object ( [name] => mysqli [serverType] => mysql [connection:protected] => mysqli Object ( [affected_rows] => 1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.6.36-82.1-log [server_version] => 50636 [stat] => Uptime: 179570 Threads: 1 Questions: 11764634 Slow queries: 53 Opens: 293796 Flush tables: 1 Open tables: 2048 Queries per second avg: 65.515 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 312466 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 84 [cursor:protected] => [debug:protected] => [limit:protected] => 0 [log:protected] => Array ( ) [timings:protected] => Array ( ) [callStacks:protected] => Array ( ) [offset:protected] => 0 [options:protected] => Array ( [driver] => mysqli [host] => localhost [user] => puertade_site [password] => 0CuU@T%rjOoqZ6p [database] => puertade_site [prefix] => pue_ [select] => 1 [port] => 3306 [socket] => ) [sql:protected] => SELECT nl.category_name FROM pue_virtuemart_categories_nl_nl nl INNER JOIN pue_virtuemart_category_categories par on par.category_child_id = nl.virtuemart_category_id INNER JOIN pue_virtuemart_product_categories cat on cat.virtuemart_category_id = nl.virtuemart_category_id WHERE cat.virtuemart_product_id =90 AND par.category_parent_id=22 LIMIT 1 [tablePrefix:protected] => pue_ [utf:protected] => 1 [utf8mb4:protected] => 1 [errorNum:protected] => 0 [errorMsg:protected] => [transactionDepth:protected] => 0 [disconnectHandlers:protected] => Array ( ) ) [_rules:protected] => [_trackAssets:protected] => [_locked:protected] => [_loggable:protected] => 1 [_xParams] => product_params [_varsToPushParam] => Array ( [min_order_level] => Array ( [0] => [1] => float ) [max_order_level] => Array ( [0] => [1] => float ) [step_order_level] => Array ( [0] => [1] => float ) [product_box] => Array ( [0] => [1] => float ) ) [_translatable] => 1 [_translatableFields:protected] => Array ( [0] => product_name [1] => product_s_desc [2] => product_desc [3] => metadesc [4] => metakey [5] => customtitle [slug] => slug ) [_hashName:protected] => [_omittedHashFields:protected] => Array ( ) [_cryptedFields] => [_langTag:protected] => nl_nl [_ltmp] => [_loadedWithLangFallback] => 0 [_loaded] => 1 [_updateNulls:protected] => 1 [_toConvertDec:protected] => [_tablePreFix] => p. [_autoincrement] => 1 [_observers] => JObserverUpdater Object ( [aliases:protected] => Array ( ) [observers:protected] => Array ( ) [doCallObservers:protected] => 1 ) [created_on] => 2007-10-10 14:31:57 [created_by] => 0 [modified_on] => 2019-08-01 13:45:57 [modified_by] => 68 [virtuemart_product_id] => 90 [virtuemart_vendor_id] => 1 [product_parent_id] => 0 [product_sku] => RDJA30 [product_gtin] => [product_mpn] => [product_name] => Sembro 2018 [product_s_desc] => Rode wijn [product_desc] =>
Waardering 91/100 James Suckling: "Full bodied red wine with lots of ripe fruit (strawberries) and velvety tannins and a flavorful finish."
Druiven Tinto Fino
Lagering 4 maanden vatlagering op Amerikaanse en Franse eik
Kleur Donkerrood met een dun waterrandje
Neus Hoge aromatische intensiteit, die herinnert aan verse bosvruchten en een zachte kruidigheid van de eerder korte passage in eiken vaten
Mond Vol, evenwichtig zwart bosfruit met zachte tannines van fruit en hout
Gastronomie Sembro past bij allerhande vleesgerechten (rood, lam, varken, ...), het betere BBQ-werk en verse pasta's en pizza's
Schenktemperatuur 16 - 18 °C
Bewaarpotentieel 3 - 5 jaar
[product_weight] => 0.0000 [product_weight_uom] => LB [product_length] => 0.0000 [product_width] => 0.0000 [product_height] => 0.0000 [product_lwh_uom] => IN [product_url] => [product_in_stock] => -386 [product_ordered] => 16 [product_stockhandle] => 0 [low_stock_notification] => 0 [product_available_date] => 2007-10-09 22:00:00 [product_availability] => [product_special] => 0 [product_discontinued] => 0 [pordering] => 0 [product_sales] => 685 [product_unit] => L [product_packaging] => 0.7500 [product_params] => min_order_level=""|max_order_level=""|step_order_level=""|product_box=""| [intnotes] => [layout] => [product_canon_category_id] => [min_order_level] => [max_order_level] => [step_order_level] => [product_box] => [allIds] => Array ( [0] => 90 ) [virtuemart_media_id] => Array ( [0] => 193 ) [shoppergroups] => [allPrices] => Array ( [0] => Array ( [virtuemart_product_price_id] => 190 [virtuemart_product_id] => 90 [virtuemart_shoppergroup_id] => 0 [product_price] => 8.5124 [override] => 0 [product_override_price] => 0 [product_tax_id] => 3 [product_discount_id] => 0 [product_currency] => 47 [product_price_publish_up] => 0000-00-00 00:00:00 [product_price_publish_down] => 0000-00-00 00:00:00 [price_quantity_start] => 0 [price_quantity_end] => 0 [created_on] => 2007-10-10 14:31:57 [created_by] => 0 [modified_on] => 2019-08-01 13:45:57 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 8.5124 [basePrice] => 8.5124 [basePriceVariant] => 8.5124 [basePriceWithTax] => 10.3 [discountedPriceWithoutTax] => 8.5124 [priceBeforeTax] => 8.5124 [salesPrice] => 10.3 [taxAmount] => 1.7876 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 10.3 [unitPrice] => 13.73334 [discountAmount] => -0 [priceWithoutTax] => 8.5124 [variantModification] => 0 [DBTax] => Array ( ) [Tax] => Array ( [3] => Array ( [0] => Tax 21% (BEL / -) [1] => 21.0000 [2] => +% [3] => 0 [4] => 47 [5] => [6] => 1 [7] => 3 ) ) [VatTax] => Array ( ) [DATax] => Array ( ) [Marge] => Array ( ) [salesPriceTt] => 10.3 [discountedPriceWithoutTaxTt] => 8.5124 [priceWithoutTaxTt] => 8.5124 [discountAmountTt] => -0 [taxAmountTt] => 1.7876 ) ) [selectedPrice] => 0 [categoryItem] => Array ( [0] => Array ( [virtuemart_category_id] => 11 [virtuemart_vendor_id] => 1 [category_name] => Rode wijnen [slug] => rode-wijnen [category_description] =>

Spaanse rode wijnen hebben de laatste jaren menig wijnliefhebber verbaasd met hun uitstekende prijs/kwaliteitsverhouding. Ook vandaag zorgt de passie van de Spaanse wijnmaker voor een continue zoektocht naar kwaliteit en dit op een zo natuurlijk mogelijke manier. In de nabije toekomst zal dit resulteren in meer wijnen met bio-label!

[category_template] => [category_layout] => default [category_product_layout] => default [products_per_row] => 1 [ordering] => 0 [shared] => 0 [cat_params] => show_store_desc=""|showcategory_desc=""|showcategory=""|categories_per_row=""|showproducts=""|omitLoaded=""|showsearch=""|productsublayout=""|featured=""|featured_rows=""|omitLoaded_featured=""|discontinued=""|discontinued_rows=""|omitLoaded_discontinued=""|latest=""|latest_rows=""|omitLoaded_latest=""|topten=""|topten_rows=""|omitLoaded_topten=""|recent=""|recent_rows=""|omitLoaded_recent=""| [limit_list_step] => 10 [limit_list_initial] => 0 [metadesc] => [customtitle] => [metakey] => [metarobot] => [metaauthor] => [published] => 1 [created_on] => 2007-06-29 11:45:18 [created_by] => 0 [modified_on] => 2018-06-15 12:03:22 [modified_by] => 68 [show_store_desc] => [showcategory_desc] => [showcategory] => [categories_per_row] => [showproducts] => [omitLoaded] => [showsearch] => [productsublayout] => [featured] => [featured_rows] => [omitLoaded_featured] => [discontinued] => [discontinued_rows] => [omitLoaded_discontinued] => [latest] => [latest_rows] => [omitLoaded_latest] => [topten] => [topten_rows] => [omitLoaded_topten] => [recent] => [recent_rows] => [omitLoaded_recent] => [id] => 170 ) [1] => Array ( [virtuemart_category_id] => 40 [virtuemart_vendor_id] => 1 [category_name] => Ribera del Duero [slug] => ribera-del-duero [category_description] =>

Absolute top in Spaanse wijn, dankzij het uitzonderlijk microklimaat en aandeel kalk in de ondergrond van het hoogplateau aan de oevers van de Duero, nabij Burgos. Belangrijkste druif: Tinta del País of Tinto Fino (Tempranillo), accent op elegantie, terroir en bewaarpotentieel. Er is ook een top witte landwijn van 100% Albillo!

[category_template] => [category_layout] => [category_product_layout] => [products_per_row] => 1 [ordering] => 0 [shared] => 0 [cat_params] => show_store_desc=""|showcategory_desc=""|showcategory=""|categories_per_row=""|showproducts=""|omitLoaded=""|showsearch=""|productsublayout=""|featured=""|featured_rows=""|omitLoaded_featured=""|discontinued=""|discontinued_rows=""|omitLoaded_discontinued=""|latest=""|latest_rows=""|omitLoaded_latest=""|topten=""|topten_rows=""|omitLoaded_topten=""|recent=""|recent_rows=""|omitLoaded_recent=""| [limit_list_step] => 10 [limit_list_initial] => 0 [metadesc] => [customtitle] => [metakey] => [metarobot] => [metaauthor] => [published] => 1 [created_on] => 2007-07-02 11:20:21 [created_by] => 0 [modified_on] => 2017-10-04 09:42:33 [modified_by] => 68 [show_store_desc] => [showcategory_desc] => [showcategory] => [categories_per_row] => [showproducts] => [omitLoaded] => [showsearch] => [productsublayout] => [featured] => [featured_rows] => [omitLoaded_featured] => [discontinued] => [discontinued_rows] => [omitLoaded_discontinued] => [latest] => [latest_rows] => [omitLoaded_latest] => [topten] => [topten_rows] => [omitLoaded_topten] => [recent] => [recent_rows] => [omitLoaded_recent] => [id] => 169 ) [2] => Array ( [virtuemart_category_id] => 59 [virtuemart_vendor_id] => 1 [category_name] => 90+ wijnen [slug] => 90plus-wijnen [category_description] =>

Deze lijst bevat al onze wijnen die onder het bekende kwaliteitslabel 90PLUS WINES vallen. Dit wil zeggen wijnen die door wijngoeroes en -magazines zoals Robert Parker, Wine Spectator, José Peñin, ... zijn beoordeeld en 90/100 of meer hebben gescoord.

 

[category_template] => [category_layout] => default [category_product_layout] => default [products_per_row] => 1 [ordering] => 0 [shared] => 0 [cat_params] => show_store_desc=""|showcategory_desc=""|showcategory=""|categories_per_row=""|showproducts=""|omitLoaded=""|showsearch=""|productsublayout=""|featured=""|featured_rows=""|omitLoaded_featured=""|discontinued=""|discontinued_rows=""|omitLoaded_discontinued=""|latest=""|latest_rows=""|omitLoaded_latest=""|topten=""|topten_rows=""|omitLoaded_topten=""|recent=""|recent_rows=""|omitLoaded_recent=""| [limit_list_step] => 10 [limit_list_initial] => 0 [metadesc] => [customtitle] => [metakey] => [metarobot] => [metaauthor] => [published] => 1 [created_on] => 2011-08-11 13:53:02 [created_by] => 0 [modified_on] => 2018-06-15 12:04:09 [modified_by] => 68 [show_store_desc] => [showcategory_desc] => [showcategory] => [categories_per_row] => [showproducts] => [omitLoaded] => [showsearch] => [productsublayout] => [featured] => [featured_rows] => [omitLoaded_featured] => [discontinued] => [discontinued_rows] => [omitLoaded_discontinued] => [latest] => [latest_rows] => [omitLoaded_latest] => [topten] => [topten_rows] => [omitLoaded_topten] => [recent] => [recent_rows] => [omitLoaded_recent] => [id] => 759 ) ) [canonCatId] => 11 [canonCatIdname] => [categories] => Array ( [0] => 11 [1] => 40 [2] => 59 ) [virtuemart_category_id] => 11 [ordering] => 0 [id] => 170 [category_name] => Rode wijnen [orderable] => 1 [modificatorSum] => 0 [product_tax_id] => 3 [amount] => 1 [quantity] => 1 [prices] => Array ( [virtuemart_product_price_id] => 190 [virtuemart_product_id] => 90 [virtuemart_shoppergroup_id] => 0 [product_price] => 8.5124 [override] => 0 [product_override_price] => 0 [product_tax_id] => 3 [product_discount_id] => 0 [product_currency] => 47 [product_price_publish_up] => 0000-00-00 00:00:00 [product_price_publish_down] => 0000-00-00 00:00:00 [price_quantity_start] => 0 [price_quantity_end] => 0 [created_on] => 2007-10-10 14:31:57 [created_by] => 0 [modified_on] => 2019-08-01 13:45:57 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 8.5124 [basePrice] => 8.5124 [basePriceVariant] => 8.5124 [basePriceWithTax] => 10.3 [discountedPriceWithoutTax] => 8.5124 [priceBeforeTax] => 8.5124 [salesPrice] => 10.3 [taxAmount] => 1.7876 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 10.3 [unitPrice] => 13.73334 [discountAmount] => -0 [priceWithoutTax] => 8.5124 [variantModification] => 0 [DBTax] => Array ( ) [Tax] => Array ( [3] => Array ( [0] => Tax 21% (BEL / -) [1] => 21.0000 [2] => +% [3] => 0 [4] => 47 [5] => [6] => 1 [7] => 3 ) ) [VatTax] => Array ( ) [DATax] => Array ( ) [Marge] => Array ( ) [salesPriceTt] => 10.3 [discountedPriceWithoutTaxTt] => 8.5124 [priceWithoutTaxTt] => 8.5124 [discountAmountTt] => -0 [taxAmountTt] => 1.7876 ) [canonical] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=90&virtuemart_category_id=11 [link] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=90&virtuemart_category_id=11 [addToCartButton] => [customfieldsSorted] => Array ( [normal] => Array ( [0] => stdClass Object ( [virtuemart_custom_id] => 7 [custom_parent_id] => 0 [virtuemart_vendor_id] => 1 [custom_jplugin_id] => 0 [custom_element] => [admin_only] => 0 [custom_title] => Regio [show_title] => 0 [custom_tip] => [custom_value] => Andalucía;Aragón;Principado de Asturias;Islas Baleares;Canarias;Cantabria;Castilla-La Mancha;Castilla y León;Cataluña;Comunidad Valenciana;Extremadura;Galicia;La Rioja;Comunidad de Madrid;Comunidad Foral de Navarra;País Vasco;Región de Murcia [custom_desc] => Autonome regio [field_type] => S [is_list] => 1 [is_hidden] => 0 [is_cart_attribute] => 0 [is_input] => 0 [layout_pos] => [custom_params] => 0 [shared] => 0 [published] => 1 [ordering] => 0 [virtuemart_customfield_id] => 196 [virtuemart_product_id] => 90 [customfield_value] => Castilla y León [customfield_price] => 0.000000 [customfield_params] => [fpublished] => 0 [override] => 0 [disabler] => 0 [_varsToPushParam] => Array ( [addEmpty] => Array ( [0] => 0 [1] => int ) [selectType] => Array ( [0] => 0 [1] => int ) [multiplyPrice] => Array ( [0] => [1] => string ) [transform] => Array ( [0] => [1] => area ) ) [addEmpty] => 0 [selectType] => 0 [multiplyPrice] => [transform] => [_xParams] => customfield_params [display] => Castilla y León ) [1] => stdClass Object ( [virtuemart_custom_id] => 5 [custom_parent_id] => 0 [virtuemart_vendor_id] => 1 [custom_jplugin_id] => 0 [custom_element] => [admin_only] => 0 [custom_title] => Middle ribbon [show_title] => 0 [custom_tip] => [custom_value] => 90plus;goud;topwijn [custom_desc] => options for the middle ribbon [field_type] => S [is_list] => 1 [is_hidden] => 1 [is_cart_attribute] => 0 [is_input] => 0 [layout_pos] => [custom_params] => 0 [shared] => 0 [published] => 1 [ordering] => 1 [virtuemart_customfield_id] => 1056 [virtuemart_product_id] => 90 [customfield_value] => 90plus [customfield_price] => 0.000000 [customfield_params] => [fpublished] => 0 [override] => 0 [disabler] => 0 [_varsToPushParam] => Array ( [addEmpty] => Array ( [0] => 0 [1] => int ) [selectType] => Array ( [0] => 0 [1] => int ) [multiplyPrice] => Array ( [0] => [1] => string ) [transform] => Array ( [0] => [1] => area ) ) [addEmpty] => 0 [selectType] => 0 [multiplyPrice] => [transform] => [_xParams] => customfield_params [display] => 90plus ) ) ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-sembro [file_extension] => jpg [virtuemart_media_id] => 193 [_foldersToTest:VmMediaHandler:private] => Array ( [0] => /home/puertade/public_html/images/stories/virtuemart/product/ [1] => /home/puertade/public_html/images/stories/virtuemart/product/resized/ ) [_actions:VmMediaHandler:private] => Array ( ) [_mLocation:VmMediaHandler:private] => Array ( ) [_hidden:VmMediaHandler:private] => Array ( ) [theme_url] => components/com_virtuemart/ [virtuemart_vendor_id] => 1 [file_title] => puerta-del-sol-sembro.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => product [file_url] => images/stories/virtuemart/product/puerta-del-sol-sembro.jpg [file_url_thumb] => [published] => 1 [file_is_downloadable] => 0 [file_is_forSale] => 0 [file_is_product_image] => 0 [shared] => 0 [file_params] => [file_lang] => [created_on] => 2015-09-26 10:58:15 [created_by] => 68 [modified_on] => 2019-08-01 13:45:57 [modified_by] => 68 [file_url_folder] => images/stories/virtuemart/product/ [file_path_folder] => images/stories/virtuemart/product/ [file_url_folder_thumb] => images/stories/virtuemart/product/resized/ [media_role] => file_is_displayable ) ) [file_url_thumb] => [file_url] => images/stories/virtuemart/product/puerta-del-sol-sembro.jpg [product_price] => 8.5124 [neighbours] => Array ( [previous] => Array ( [0] => Array ( [virtuemart_product_id] => 211 [product_name] => Barahonda Organic Barrica 2017 BIO [product_price] => 8.181820 ) ) [next] => Array ( [0] => Array ( [virtuemart_product_id] => 70 [product_name] => Dignus Crianza 2013 [product_price] => 9.082650 ) ) ) [manufacturers] => Array ( [0] => TableManufacturers Object ( [virtuemart_manufacturer_id] => 15 [mf_name] => Jaro [slug] => vinas-del-jaro [mf_email] => info@puertadelsol.be [mf_desc] =>

Op één van de beste landgoederen van D.O. Ribera del Duero bouwde de Grupo Iberian haar bodega ‘El Jaro’, 105 ha groot. 1 km verder stroomt de rivier Duero, die samen met de ondergrond en de oriëntatie van de wijngaarden de basis vormen van de uitstekende rode wijnen op basis van de Tinto Fino-druif.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.vinosiberian.com/ [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => cdc6f5ba86021f0356f5bcb4571573a4 [_tbl:protected] => #__virtuemart_manufacturers [_tbl_lang:protected] => #__virtuemart_manufacturers_nl_nl [_tbl_key:protected] => virtuemart_manufacturer_id [_tbl_keys:protected] => Array ( [0] => virtuemart_manufacturer_id ) [_pkey:protected] => virtuemart_manufacturer_id [_pkeyForm:protected] => cid [_obkeys:protected] => Array ( [mf_name] => 1 [slug] => 1 ) [_unique:protected] => 1 [_unique_name:protected] => Array ( [mf_name] => 1 [slug] => 1 ) [_orderingKey:protected] => ordering [_slugAutoName:protected] => mf_name [_slugName:protected] => slug [_db:protected] => JDatabaseDriverMysqli Object ( [name] => mysqli [serverType] => mysql [connection:protected] => mysqli Object ( [affected_rows] => -1 [client_info] => 5.5.32 [client_version] => 50532 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 1 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.6.36-82.1-log [server_version] => 50636 [stat] => Uptime: 179570 Threads: 1 Questions: 11764635 Slow queries: 53 Opens: 293796 Flush tables: 1 Open tables: 2048 Queries per second avg: 65.515 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 312466 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 84 [cursor:protected] => [debug:protected] => [limit:protected] => 0 [log:protected] => Array ( ) [timings:protected] => Array ( ) [callStacks:protected] => Array ( ) [offset:protected] => 0 [options:protected] => Array ( [driver] => mysqli [host] => localhost [user] => puertade_site [password] => 0CuU@T%rjOoqZ6p [database] => puertade_site [prefix] => pue_ [select] => 1 [port] => 3306 [socket] => ) [sql:protected] => SELECT nl.category_name FROM pue_virtuemart_categories_nl_nl nl INNER JOIN pue_virtuemart_category_categories par on par.category_child_id = nl.virtuemart_category_id INNER JOIN pue_virtuemart_product_categories cat on cat.virtuemart_category_id = nl.virtuemart_category_id WHERE cat.virtuemart_product_id =90 AND par.category_parent_id=22 LIMIT 1 [tablePrefix:protected] => pue_ [utf:protected] => 1 [utf8mb4:protected] => 1 [errorNum:protected] => 0 [errorMsg:protected] => [transactionDepth:protected] => 0 [disconnectHandlers:protected] => Array ( ) ) [_rules:protected] => [_trackAssets:protected] => [_locked:protected] => [_loggable:protected] => 1 [_xParams] => 0 [_varsToPushParam] => Array ( ) [_translatable] => 1 [_translatableFields:protected] => Array ( [0] => mf_name [1] => mf_email [2] => mf_desc [3] => mf_url [4] => metadesc [5] => metakey [6] => customtitle [slug] => slug ) [_hashName:protected] => [_omittedHashFields:protected] => Array ( ) [_cryptedFields] => [_langTag:protected] => nl_nl [_ltmp] => [_loadedWithLangFallback] => 0 [_loaded] => [_updateNulls:protected] => [_toConvertDec:protected] => [_tablePreFix] => m. [_autoincrement] => 1 [_observers] => JObserverUpdater Object ( [aliases:protected] => Array ( ) [observers:protected] => Array ( ) [doCallObservers:protected] => 1 ) [created_on] => 0000-00-00 00:00:00 [created_by] => 0 [modified_on] => 2015-10-16 09:32:19 [modified_by] => 68 [virtuemart_media_id] => Array ( [0] => 111 ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-viñas-del-jaro5 [file_extension] => jpg [virtuemart_media_id] => 111 [_foldersToTest:VmMediaHandler:private] => Array ( [0] => /home/puertade/public_html/images/stories/virtuemart/manufacturer/ [1] => /home/puertade/public_html/images/stories/virtuemart/manufacturer/resized/ ) [_actions:VmMediaHandler:private] => Array ( ) [_mLocation:VmMediaHandler:private] => Array ( ) [_hidden:VmMediaHandler:private] => Array ( ) [theme_url] => components/com_virtuemart/ [virtuemart_vendor_id] => 1 [file_title] => puerta-del-sol-viñas-del-jaro.jpg_manufacturer [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => manufacturer [file_url] => images/stories/virtuemart/manufacturer/puerta-del-sol-viñas-del-jaro5.jpg [file_url_thumb] => [published] => 1 [file_is_downloadable] => 0 [file_is_forSale] => 0 [file_is_product_image] => 0 [shared] => 0 [file_params] => [file_lang] => [created_on] => 2015-09-22 14:35:07 [created_by] => 68 [modified_on] => 2015-10-16 09:32:19 [modified_by] => 68 [file_url_folder] => images/stories/virtuemart/manufacturer/ [file_path_folder] => images/stories/virtuemart/manufacturer/ [file_url_folder_thumb] => images/stories/virtuemart/manufacturer/resized/ [media_role] => file_is_displayable ) ) [file_url_thumb] => [file_url] => images/stories/virtuemart/manufacturer/puerta-del-sol-viñas-del-jaro5.jpg ) ) [event] => stdClass Object ( [afterDisplayTitle] => [beforeDisplayContent] => [afterDisplayContent] => ) )
 
RegioCastilla y León
D.O.Ribera del Duero
Type Rode wijn
Inhoud 0.75 l
Waardering 91/100 James Suckling: "Full bodied red wine with lots of ripe fruit (strawberries) and velvety tannins and a flavorful finish."
Druiven Tinto Fino
Lagering 4 maanden vatlagering op Amerikaanse en Franse eik
Kleur Donkerrood met een dun waterrandje
Neus Hoge aromatische intensiteit, die herinnert aan verse bosvruchten en een zachte kruidigheid van de eerder korte passage in eiken vaten
Mond Vol, evenwichtig zwart bosfruit met zachte tannines van fruit en hout
Gastronomie Sembro past bij allerhande vleesgerechten (rood, lam, varken, ...), het betere BBQ-werk en verse pasta's en pizza's
Schenktemperatuur 16 - 18 °C
Bewaarpotentieel 3 - 5 jaar