0

Er steken 0ITEMS in uw winkelwagentje

Het winkelwagentje is leeg

Rode wijnen

Covila Reserva 2017
Covila
Prijs per eenheid : € 12,79
stdClass Object ( [virtuemart_manufacturer_id] => Array ( [0] => 20 ) [mf_name] => Covila [slug] => covila-reserva [mf_email] => info@puertadelsol.be [mf_desc] =>

Als je een reeks uitzonderlijke wijngaarden hebt, en je hebt de kennis geërfd van je voorvaderen, dan moet je kunnen dromen…

Covila ontstond uit de vereende inspanningen van een dorp en is vandaag een referentie in de D.O.Ca. Rioja met een grote exportcapaciteit.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http;//www.covila.es [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 1723291093 [_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] => Array ( [product_name] => 1 [slug] => 1 ) [_unique:protected] => 1 [_unique_name] => Array ( [slug] => 1 ) [_orderingKey:protected] => ordering [_slugAutoName] => product_name [_slugName:protected] => slug [_db:protected] => JDatabaseDriverMysqli Object ( [name] => mysqli [serverType] => mysql [connection:protected] => mysqli Object ( [affected_rows] => 1 [client_info] => mysqlnd 7.4.33 [client_version] => 70433 [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.7.39-42-log [server_version] => 50739 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 65645968 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 111 [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 =261 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 ) [shared_stock] => Array ( [0] => 0 [1] => int ) [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] => nl_nl [_ltmp] => [_loadedWithLangFallback] => 0 [_loaded] => 1 [_updateNulls:protected] => 1 [_toConvertDec:protected] => [_genericVendorId:protected] => 1 [_tablePreFix] => p. [_autoincrement] => 1 [_observers] => JObserverUpdater Object ( [aliases:protected] => Array ( ) [observers:protected] => Array ( ) [doCallObservers:protected] => 1 ) [created_on] => 2013-09-05 12:29:29 [created_by] => 0 [modified_on] => 2023-01-04 11:10:39 [modified_by] => 68 [virtuemart_product_id] => 261 [virtuemart_vendor_id] => 1 [product_parent_id] => 0 [product_sku] => ROCO32 [product_gtin] => [product_mpn] => [product_name] => Covila Reserva 2017 [product_s_desc] => 91/100 [product_desc] =>
Waardering 91/100 James Suckling: "A rich, dark fruited style with plum- paste and raisin aromas, leading to a palate that offers a fresh, juicy and gently assertive squeeze of tannin at the finish. Drink or hold" (2015)
Druiven 100% Tempranillo
Lagering 12 maanden houtlagering
Kleur De Covila Reserva is karmijnrood
Neus Gedomineerd door rijp fruit met een vleugje kersenlikeur, mooie rokerige en ledertoetsen
Mond Warm en vol mondgevoel. Lekker fruit afgewerkt met een fijne tabak- en cedertoets
Gastronomie Bij de fijnere vleesschotel, zacht wild en gerijpte kazen
Schenktemperatuur 16 - 18°C
Bewaarpotentieel 6 - 9 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] => -305 [product_ordered] => 0 [product_stockhandle] => 0 [low_stock_notification] => 0 [product_available_date] => 2013-09-04 22:00:00 [product_availability] => [product_special] => 0 [product_discontinued] => 0 [pordering] => 0 [product_sales] => 313 [product_unit] => L [product_packaging] => 0.7500 [product_params] => min_order_level=""|max_order_level=""|step_order_level=""|shared_stock=0|product_box=""| [intnotes] => [layout] => [has_categories] => 1 [has_manufacturers] => 1 [has_medias] => 1 [has_prices] => 1 [has_shoppergroups] => 0 [product_canon_category_id] => [min_order_level] => [max_order_level] => [step_order_level] => [shared_stock] => 0 [product_box] => [allIds] => Array ( [0] => 261 ) [virtuemart_media_id] => Array ( [0] => 606 ) [allPrices] => Array ( [0] => Array ( [virtuemart_product_price_id] => 117 [virtuemart_product_id] => 261 [virtuemart_shoppergroup_id] => 0 [product_price] => 10.57025 [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] => 2013-09-05 12:29:29 [created_by] => 0 [modified_on] => 2023-01-04 11:10:39 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 10.57025 [basePrice] => 10.57025 [basePriceVariant] => 10.57025 [basePriceWithTax] => 12.79 [discountedPriceWithoutTax] => 10.57025 [priceBeforeTax] => 10.57025 [salesPrice] => 12.79 [taxAmount] => 2.21975 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 12.79 [unitPrice] => 17.05333 [discountAmount] => -0 [priceWithoutTax] => 10.57025 [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] => 12.79 [discountedPriceWithoutTaxTt] => 10.57025 [priceWithoutTaxTt] => 10.57025 [discountAmountTt] => -0 [taxAmountTt] => 2.21975 ) ) [selectedPrice] => 0 [categoryItem] => Array ( [0] => Array ( [virtuemart_category_id] => 11 [category_parent_id] => 7 [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 [has_children] => 0 [has_medias] => 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] => 107 ) [1] => Array ( [virtuemart_category_id] => 42 [category_parent_id] => 22 [virtuemart_vendor_id] => 1 [category_name] => Rioja [slug] => rioja [category_description] =>

Rioja is een D.O.Ca. (Denominación de Origen Calificada), in theorie een hogere categorie dan een D.O. Er zijn drie sub-wijngebieden: Rioja Alta, Rioja Baja en Rioja Alavesa (in de Baskische provincie Álava), waarvan de laatste in het algemeen de beste wijnen voortbrengt.  Belangrijkste druiven: Tempranillo, Garnacha en Viura.

[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 [has_children] => 0 [has_medias] => 1 [created_on] => 2007-07-02 11:22:27 [created_by] => 0 [modified_on] => 2017-10-04 09:43:25 [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] => 106 ) [2] => Array ( [virtuemart_category_id] => 59 [category_parent_id] => 7 [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 [has_children] => 0 [has_medias] => 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] => 766 ) ) [canonCatId] => 11 [canonCatIdname] => [categories] => Array ( [0] => 11 [1] => 42 [2] => 59 ) [virtuemart_category_id] => 11 [ordering] => 0 [id] => 107 [category_name] => Rode wijnen [orderable] => 1 [show_notify] => [product_realparent_id] => 0 [modificatorSum] => 0 [product_tax_id] => 3 [amount] => 1 [quantity] => 1 [prices] => Array ( [virtuemart_product_price_id] => 117 [virtuemart_product_id] => 261 [virtuemart_shoppergroup_id] => 0 [product_price] => 10.57025 [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] => 2013-09-05 12:29:29 [created_by] => 0 [modified_on] => 2023-01-04 11:10:39 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 10.57025 [basePrice] => 10.57025 [basePriceVariant] => 10.57025 [basePriceWithTax] => 12.79 [discountedPriceWithoutTax] => 10.57025 [priceBeforeTax] => 10.57025 [salesPrice] => 12.79 [taxAmount] => 2.21975 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 12.79 [unitPrice] => 17.05333 [discountAmount] => -0 [priceWithoutTax] => 10.57025 [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] => 12.79 [discountedPriceWithoutTaxTt] => 10.57025 [priceWithoutTaxTt] => 10.57025 [discountAmountTt] => -0 [taxAmountTt] => 2.21975 ) [canonical] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=261&virtuemart_category_id=11 [link] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=261&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 [searchable] => 0 [layout_pos] => [custom_params] => 0 [shared] => 0 [published] => 1 [ordering] => 0 [virtuemart_shoppergroup_id] => [virtuemart_customfield_id] => 43 [virtuemart_product_id] => 261 [customfield_value] => La Rioja [customfield_price] => 0.000000 [customfield_params] => [fpublished] => 0 [override] => 0 [disabler] => 0 [noninheritable] => 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] => La Rioja ) [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 [searchable] => 0 [layout_pos] => [custom_params] => 0 [shared] => 0 [published] => 1 [ordering] => 1 [virtuemart_shoppergroup_id] => [virtuemart_customfield_id] => 1061 [virtuemart_product_id] => 261 [customfield_value] => 90plus [customfield_price] => 0.000000 [customfield_params] => [fpublished] => 0 [override] => 0 [disabler] => 0 [noninheritable] => 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-covila-reserva8 [file_extension] => jpg [virtuemart_media_id] => 606 [theme_url] => components/com_virtuemart/ [noImageSet] => [_foldersToTest:VmMediaHandler:private] => Array ( [0] => /home/customer/www/puertadelsol.be/public_html/images/stories/virtuemart/product/ [1] => /home/customer/www/puertadelsol.be/public_html/images/stories/virtuemart/product/resized/ ) [_actions] => Array ( ) [_mLocation] => Array ( ) [_hidden:VmMediaHandler:private] => Array ( ) [virtuemart_vendor_id] => 1 [file_title] => puerta-del-sol-covila-reserva8.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => product [file_url] => images/stories/virtuemart/product/puerta-del-sol-covila-reserva8.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] => 2022-10-11 15:35:13 [created_by] => 68 [modified_on] => 2023-01-04 11:10:39 [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-covila-reserva8.jpg [product_price] => 10.57025 [neighbours] => Array ( [previous] => Array ( [0] => Array ( [virtuemart_product_id] => 188 [product_name] => Barahonda Crianza 2019 [product_price] => 9.826450 ) ) [next] => Array ( [0] => Array ( [virtuemart_product_id] => 594 [product_name] => Casa de la Viña BIO [product_price] => 10.636360 ) ) ) [manufacturers] => Array ( [0] => TableManufacturers Object ( [virtuemart_manufacturer_id] => 20 [mf_name] => Covila [slug] => bodegas-covila [mf_email] => info@puertadelsol.be [mf_desc] =>

Als je een reeks uitzonderlijke wijngaarden hebt, en je hebt de kennis geërfd van je voorvaderen, dan moet je kunnen dromen…

Covila ontstond uit de vereende inspanningen van een dorp en is vandaag een referentie in de D.O.Ca. Rioja met een grote exportcapaciteit.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http;//www.covila.es [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 1314264326 [_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] => Array ( [mf_name] => 1 [slug] => 1 ) [_unique:protected] => 1 [_unique_name] => Array ( [mf_name] => 1 [slug] => 1 ) [_orderingKey:protected] => ordering [_slugAutoName] => mf_name [_slugName:protected] => slug [_db:protected] => JDatabaseDriverMysqli Object ( [name] => mysqli [serverType] => mysql [connection:protected] => mysqli Object ( [affected_rows] => 1 [client_info] => mysqlnd 7.4.33 [client_version] => 70433 [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.7.39-42-log [server_version] => 50739 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 65645968 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 111 [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 =261 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] => nl_nl [_ltmp] => [_loadedWithLangFallback] => 0 [_loaded] => [_updateNulls:protected] => [_toConvertDec:protected] => [_genericVendorId:protected] => 1 [_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] => 2022-10-12 13:52:46 [modified_by] => 68 [virtuemart_media_id] => Array ( [0] => 608 ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-covila [file_extension] => jpg [virtuemart_media_id] => 608 [theme_url] => components/com_virtuemart/ [noImageSet] => [_foldersToTest:VmMediaHandler:private] => Array ( [0] => /home/customer/www/puertadelsol.be/public_html/images/stories/virtuemart/manufacturer/ [1] => /home/customer/www/puertadelsol.be/public_html/images/stories/virtuemart/manufacturer/resized/ ) [_actions] => Array ( ) [_mLocation] => Array ( ) [_hidden:VmMediaHandler:private] => Array ( ) [virtuemart_vendor_id] => 1 [file_title] => puerta-del-sol-covila.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => manufacturer [file_url] => images/stories/virtuemart/manufacturer/puerta-del-sol-covila.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] => 2022-10-12 13:47:27 [created_by] => 68 [modified_on] => 2022-10-12 13:52:46 [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-covila.jpg ) ) [event] => stdClass Object ( [afterDisplayTitle] => [beforeDisplayContent] => [afterDisplayContent] => ) )
 
RegioLa Rioja
D.O.Rioja
Type Rode wijn
Inhoud 0.75 l
Waardering 91/100 James Suckling: "A rich, dark fruited style with plum- paste and raisin aromas, leading to a palate that offers a fresh, juicy and gently assertive squeeze of tannin at the finish. Drink or hold" (2015)
Druiven 100% Tempranillo
Lagering 12 maanden houtlagering
Kleur De Covila Reserva is karmijnrood
Neus Gedomineerd door rijp fruit met een vleugje kersenlikeur, mooie rokerige en ledertoetsen
Mond Warm en vol mondgevoel. Lekker fruit afgewerkt met een fijne tabak- en cedertoets
Gastronomie Bij de fijnere vleesschotel, zacht wild en gerijpte kazen
Schenktemperatuur 16 - 18°C
Bewaarpotentieel 6 - 9 jaar