Sherry

stdClass Object ( [virtuemart_manufacturer_id] => Array ( [0] => 6 ) [mf_name] => Hidalgo-La Gitana [slug] => oloroso-seco-faraon [mf_email] => info@puertadelsol.be [mf_desc] =>

Bodegas Hidalgo maakt reeds meer dan 200 jaar sherry. Hun wereldwijd gekende product is La Gitana, een ziltige sherry uit Sanlúcar de Barrameda op basis van de Palomino-druif, die verscheidene internationale prijzen won en geldt als één van de beste van Spanje. Men maakt ook uitstekende gerijpte sherry’s: oloroso's, amontillado's, cream, ...

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.lagitana.es [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 33c9a62ccda18c6162c742769c094916 [_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: 319872 Threads: 1 Questions: 28449328 Slow queries: 375 Opens: 692097 Flush tables: 1 Open tables: 2048 Queries per second avg: 88.939 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 661992 [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 =49 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-09-28 14:03:16 [created_by] => 0 [modified_on] => 2018-12-07 09:51:43 [modified_by] => 68 [virtuemart_product_id] => 49 [virtuemart_vendor_id] => 1 [product_parent_id] => 0 [product_sku] => JEHI10 [product_gtin] => [product_mpn] => [product_name] => Oloroso Seco Faraón [product_s_desc] => Sherry droog, RP 91/100 [product_desc] =>

Waardering	Parker 91/100 (2007) Guia Peñin 88/100
Druiven	100% Palomino
Lagering	Oloroso seco: solera van oude Amerikaanse eiken vaten met totaal geen 'flor'-veroudering. Toevoeging van alcohol tot 18-20%
Kleur
Neus
Mond
Gastronomie
Schenktemperatuur	10 - 12 °C
Bewaarpotentieel	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] => -1 [product_ordered] => 0 [product_stockhandle] => 0 [low_stock_notification] => 0 [product_available_date] => 2007-09-27 22:00:00 [product_availability] => [product_special] => 0 [product_discontinued] => 0 [pordering] => 0 [product_sales] => 21 [product_unit] => L [product_packaging] => 0.7500 [product_params] => min_order_level=""|max_order_level=""|step_order_level=""|product_box=""| [intnotes] => [layout] => default [product_canon_category_id] => [min_order_level] => [max_order_level] => [step_order_level] => [shared_stock] => 0 [product_box] => [allIds] => Array ( [0] => 49 ) [virtuemart_media_id] => Array ( [0] => 115 ) [shoppergroups] => [allPrices] => Array ( [0] => Array ( [virtuemart_product_price_id] => 84 [virtuemart_product_id] => 49 [virtuemart_shoppergroup_id] => 0 [product_price] => 14.41322 [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-09-28 14:03:16 [created_by] => 0 [modified_on] => 2018-12-07 09:51:43 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 14.41322 [basePrice] => 14.41322 [basePriceVariant] => 14.41322 [basePriceWithTax] => 17.44 [discountedPriceWithoutTax] => 14.41322 [priceBeforeTax] => 14.41322 [salesPrice] => 17.44 [taxAmount] => 3.02678 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 17.44 [unitPrice] => 23.25333 [discountAmount] => -0 [priceWithoutTax] => 14.41322 [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.44 [discountedPriceWithoutTaxTt] => 14.41322 [priceWithoutTaxTt] => 14.41322 [discountAmountTt] => -0 [taxAmountTt] => 3.02678 ) ) [selectedPrice] => 0 [categoryItem] => Array ( [0] => Array ( [virtuemart_category_id] => 13 [virtuemart_vendor_id] => 1 [category_name] => Sherry [slug] => sherry [category_description] =>

Jerez/Xérès/Sherry y Manzanilla de Sanlúcar de Barrameda ligt in de provincie Cádiz in het Zuidwesten van Spanje. Op de kalkrijkste bodems (albariza) worden de beste sherry's gemaakt in een systeem van Soleras en Criaderas, een stel op elkaar gestapelde vaten, gedurende 3 tot >50 jaar! Druiven: Palomino Fino en Pedro Ximénez.

Type	Lagering	Alcohol
Fino	Minimum 3 jaar op Solera onder flor	15-17%
Manzanilla	Zoals een Fino, maar gerijpt aan zee in Sanlúcar de Barrameda. Beendroog met een zilte smaak	15-17%
Amontillado	Is een oude Fino, vanaf ongeveer 10 jaar, maar de beste zijn 50 of 60 jaar	16-18%
Oloroso	Is een wijn waarin zich geen flor vormde; gewoonlijk 10-15 jaar oud, maar kan rijpen tot 100 jaar	18-20%
Cream	Zoete sherry, door toevoeging van druivensuiker of zoete wijn van Pedro Ximénez	18%

[category_template] => 0 [category_layout] => 0 [category_product_layout] => 0 [products_per_row] => 1 [ordering] => 0 [shared] => 0 [cat_params] => [limit_list_step] => 10 [limit_list_initial] => 0 [metadesc] => [customtitle] => [metakey] => [metarobot] => [metaauthor] => [published] => 1 [created_on] => 2007-06-29 11:47:15 [created_by] => 0 [modified_on] => 2015-10-21 19:18:53 [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] => 78 ) [1] => Array ( [virtuemart_category_id] => 31 [virtuemart_vendor_id] => 1 [category_name] => Jerez [slug] => jerez [category_description] =>

Jerez/Xérès/Sherry y Manzanilla de Sanlúcar de Barrameda ligt in de provincie Cádiz in het Zuidwesten van Spanje. Op de kalkrijkste bodems (albariza) worden de beste sherry's gemaakt in een systeem van Soleras en Criaderas, een stel op elkaar gestapelde vaten, gedurende 3 tot >50 jaar! Druiven: Palomino Fino en Pedro Ximénez.

[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:10:43 [created_by] => 0 [modified_on] => 2017-10-04 09:38:35 [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] => 76 ) [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] => 77 ) ) [canonCatId] => 13 [canonCatIdname] => [categories] => Array ( [0] => 13 [1] => 31 [2] => 59 ) [virtuemart_category_id] => 13 [ordering] => 0 [id] => 78 [category_name] => Sherry [orderable] => 1 [product_realparent_id] => 0 [modificatorSum] => 0 [product_tax_id] => 3 [amount] => 1 [quantity] => 1 [prices] => Array ( [virtuemart_product_price_id] => 84 [virtuemart_product_id] => 49 [virtuemart_shoppergroup_id] => 0 [product_price] => 14.41322 [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-09-28 14:03:16 [created_by] => 0 [modified_on] => 2018-12-07 09:51:43 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 14.41322 [basePrice] => 14.41322 [basePriceVariant] => 14.41322 [basePriceWithTax] => 17.44 [discountedPriceWithoutTax] => 14.41322 [priceBeforeTax] => 14.41322 [salesPrice] => 17.44 [taxAmount] => 3.02678 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 17.44 [unitPrice] => 23.25333 [discountAmount] => -0 [priceWithoutTax] => 14.41322 [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.44 [discountedPriceWithoutTaxTt] => 14.41322 [priceWithoutTaxTt] => 14.41322 [discountAmountTt] => -0 [taxAmountTt] => 3.02678 ) [canonical] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=49&virtuemart_category_id=13 [link] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=49&virtuemart_category_id=13 [addToCartButton] => [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] => 72 [virtuemart_product_id] => 49 [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] => 73 [virtuemart_product_id] => 49 [customfield_value] => Andalucía [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] => Andalucía ) ) ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-oloroso-faraon [file_extension] => jpg [virtuemart_media_id] => 115 [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-oloroso-faraon.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => product [file_url] => images/stories/virtuemart/product/puerta-del-sol-oloroso-faraon.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-23 14:45:21 [created_by] => 68 [modified_on] => 2018-12-07 09:51:43 [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-oloroso-faraon.jpg [product_price] => 14.41322 [neighbours] => Array ( [previous] => Array ( [0] => Array ( [virtuemart_product_id] => 50 [product_name] => Manzanilla La Gitana [product_price] => 10.603306 ) ) [next] => Array ( [0] => Array ( [virtuemart_product_id] => 23 [product_name] => Cream Alameda [product_price] => 14.644630 ) ) ) [manufacturers] => Array ( [0] => TableManufacturers Object ( [virtuemart_manufacturer_id] => 6 [mf_name] => Hidalgo-La Gitana [slug] => bodegas-hidalgo-la-gitana [mf_email] => info@puertadelsol.be [mf_desc] =>

Bodegas Hidalgo maakt reeds meer dan 200 jaar sherry. Hun wereldwijd gekende product is La Gitana, een ziltige sherry uit Sanlúcar de Barrameda op basis van de Palomino-druif, die verscheidene internationale prijzen won en geldt als één van de beste van Spanje. Men maakt ook uitstekende gerijpte sherry’s: oloroso's, amontillado's, cream, ...

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.lagitana.es [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 50f520761ddc1a4f75de6e154d5f1a36 [_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: 319872 Threads: 1 Questions: 28449329 Slow queries: 375 Opens: 692097 Flush tables: 1 Open tables: 2048 Queries per second avg: 88.939 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 661992 [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 =49 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:37:48 [modified_by] => 68 [virtuemart_media_id] => Array ( [0] => 61 ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-emilio-hidalgo [file_extension] => jpg [virtuemart_media_id] => 61 [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-emilio-hidalgo.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => manufacturer [file_url] => images/stories/virtuemart/manufacturer/puerta-del-sol-emilio-hidalgo.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-11 13:53:12 [created_by] => 68 [modified_on] => 2015-10-16 09:37:48 [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-emilio-hidalgo.jpg ) ) [event] => stdClass Object ( [afterDisplayTitle] => [beforeDisplayContent] => [afterDisplayContent] => ) )