90+ wijnen

stdClass Object ( [virtuemart_manufacturer_id] => Array ( [0] => 15 ) [mf_name] => Jaro [slug] => jaros [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] => e45bbfd3f07f021f7a61d9299a57a5c2 [_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: 90249 Threads: 2 Questions: 8965908 Slow queries: 143 Opens: 177605 Flush tables: 1 Open tables: 2048 Queries per second avg: 99.346 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 209325 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 83 [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 =91 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] => [_tablePreFix] => p. [_autoincrement] => 1 [_observers] => JObserverUpdater Object ( [aliases:protected] => Array ( ) [observers:protected] => Array ( ) [doCallObservers:protected] => 1 ) [created_on] => 2007-10-10 14:39:12 [created_by] => 0 [modified_on] => 2020-02-14 10:54:36 [modified_by] => 68 [virtuemart_product_id] => 91 [virtuemart_vendor_id] => 1 [product_parent_id] => 0 [product_sku] => RDJA31 [product_gtin] => [product_mpn] => [product_name] => Jaros 2017 [product_s_desc] => 90/100 [product_desc] =>

Waardering	Guia Peñin 90/100
Druiven	100% Tinto Fino
Lagering	17 maanden houtlagering in 300l vaten van Franse eik
Kleur	Intense kers
Neus	Rijp fruit en zachte kruiden aangevuld met nieuw hout
Mond	Deze Jaros laat vooral het fruit van de druif (Tinto Fino) en de mineralen van de bodem van de Finca El Quiñón tot uitdrukking komen. Het hout overheerst de primaire karakteristieken niet, dankzij de gedeeltelijke toepassing van Franse eik. Een intense, krachtige wijn, vol en met een goede zuurtegraad
Gastronomie	Bij stevig rood vlees en groot wild
Schenktemperatuur	16 - 18 °C
Bewaarpotentieel	6 - 10 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] => -185 [product_ordered] => 5 [product_stockhandle] => 0 [low_stock_notification] => 0 [product_available_date] => 2007-10-09 22:00:00 [product_availability] => ico_medaille.gif [product_special] => 0 [product_discontinued] => 0 [pordering] => 0 [product_sales] => 391 [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] => [product_canon_category_id] => [min_order_level] => [max_order_level] => [step_order_level] => [shared_stock] => 0 [product_box] => [allIds] => Array ( [0] => 91 ) [virtuemart_media_id] => Array ( [0] => 213 ) [shoppergroups] => [allPrices] => Array ( [0] => Array ( [virtuemart_product_price_id] => 193 [virtuemart_product_id] => 91 [virtuemart_shoppergroup_id] => 0 [product_price] => 14.66942 [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:39:12 [created_by] => 0 [modified_on] => 2020-02-14 10:54:36 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 14.66942 [basePrice] => 14.66942 [basePriceVariant] => 14.66942 [basePriceWithTax] => 17.75 [discountedPriceWithoutTax] => 14.66942 [priceBeforeTax] => 14.66942 [salesPrice] => 17.75 [taxAmount] => 3.08058 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 17.75 [unitPrice] => 23.66666 [discountAmount] => -0 [priceWithoutTax] => 14.66942 [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] => 17.75 [discountedPriceWithoutTaxTt] => 14.66942 [priceWithoutTaxTt] => 14.66942 [discountAmountTt] => -0 [taxAmountTt] => 3.08058 ) ) [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] => 173 ) [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] => 2019-12-02 13:47:20 [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] => 171 ) [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] => 172 ) ) [canonCatId] => 11 [canonCatIdname] => [categories] => Array ( [0] => 11 [1] => 40 [2] => 59 ) [virtuemart_category_id] => 59 [ordering] => 0 [id] => 172 [category_name] => 90+ wijnen [orderable] => 1 [product_realparent_id] => 0 [modificatorSum] => 0 [product_tax_id] => 3 [amount] => 1 [quantity] => 1 [prices] => Array ( [virtuemart_product_price_id] => 193 [virtuemart_product_id] => 91 [virtuemart_shoppergroup_id] => 0 [product_price] => 14.66942 [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:39:12 [created_by] => 0 [modified_on] => 2020-02-14 10:54:36 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 14.66942 [basePrice] => 14.66942 [basePriceVariant] => 14.66942 [basePriceWithTax] => 17.75 [discountedPriceWithoutTax] => 14.66942 [priceBeforeTax] => 14.66942 [salesPrice] => 17.75 [taxAmount] => 3.08058 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 17.75 [unitPrice] => 23.66666 [discountAmount] => -0 [priceWithoutTax] => 14.66942 [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] => 17.75 [discountedPriceWithoutTaxTt] => 14.66942 [priceWithoutTaxTt] => 14.66942 [discountAmountTt] => -0 [taxAmountTt] => 3.08058 ) [canonical] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=91&virtuemart_category_id=11 [link] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=91&virtuemart_category_id=59 [addToCartButton] => [availability] => ico_medaille.gif [customfieldsSorted] => Array ( [normal] => Array ( [0] => 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] => 0 [virtuemart_shoppergroup_id] => [virtuemart_customfield_id] => 194 [virtuemart_product_id] => 91 [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 ) [1] => 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] => 1 [virtuemart_shoppergroup_id] => [virtuemart_customfield_id] => 195 [virtuemart_product_id] => 91 [customfield_value] => Castilla y León [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] => Castilla y León ) ) ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-jaros9 [file_extension] => png [virtuemart_media_id] => 213 [theme_url] => components/com_virtuemart/ [noImageSet] => [_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 ( ) [virtuemart_vendor_id] => 1 [file_title] => puerta-del-sol-jaros.png_product_product [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/png [file_type] => product [file_url] => images/stories/virtuemart/product/puerta-del-sol-jaros9.png [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-29 11:11:26 [created_by] => 68 [modified_on] => 2020-02-14 10:54:36 [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-jaros9.png [product_price] => 14.66942 [neighbours] => Array ( [previous] => Array ( [0] => Array ( [virtuemart_product_id] => 23 [product_name] => Cream Alameda [product_price] => 14.644630 ) ) [next] => Array ( [0] => Array ( [virtuemart_product_id] => 48 [product_name] => Amontillado Napoleón [product_price] => 14.785124 ) ) ) [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: 90249 Threads: 2 Questions: 8965909 Slow queries: 143 Opens: 177605 Flush tables: 1 Open tables: 2048 Queries per second avg: 99.346 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 209325 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 83 [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 =91 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] => [_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 [theme_url] => components/com_virtuemart/ [noImageSet] => [_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 ( ) [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] => ) )