Rode wijnen

stdClass Object ( [virtuemart_manufacturer_id] => Array ( [0] => 1 ) [mf_name] => Sumarroca [slug] => sumarroca-negre [mf_email] => info@puertadelsol.be [mf_desc] =>

Dit is één van de weinige bodegas uit D.O. Penedès en D.O. Cava die uitsluitend eigen druiven gebruiken (465 ha). Het familie- bedrijf onderscheidt zich door het respect voor de ecologie van de terroir. De cavas ondergaan een gisting op fles die veel langer is dan de wettelijke norm. Resultaat: een fi- nesse die de supermarkt-cava ver overstijgt!

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.sumarroca.es [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 2460328338 [_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] => 62616348 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 109 [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 =185 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] => 2010-04-27 11:18:16 [created_by] => 0 [modified_on] => 2023-01-04 10:52:29 [modified_by] => 68 [virtuemart_product_id] => 185 [virtuemart_vendor_id] => 1 [product_parent_id] => 0 [product_sku] => PESR30 [product_gtin] => [product_mpn] => [product_name] => Sumarroca Negre 2021 BIO [product_s_desc] => Rode wijn [product_desc] =>

Waardering
Druiven	35% Merlot, 35% Ull de LLebre (=Tempranillo), 30% Cabernet Sauvignon
Lagering	Malolactische gisting 20°C gedurende 6 dagen in inox tank
Kleur	Helder kersenrood met een purperen rand
Neus	Deze Sumarroca Negre heeft een intens aroma van framboos en kersenconfituur. Jonge eucalyptus en een lichte venkeltoets
Mond	Verfrissend, zacht en fluwelig met een verfijnde smaak van frambozen en kersen. Een licht kruidige toets in balans met de zuren en een blijvend fruitige afdronk
Gastronomie	Tapas, pastas en rijstgerechten, zachte vleesgerechten, BBQ en zachte kazen. Kan in de zomer licht gekoeld geserveerd worden, ook bij vis met afsmakende saus
Schenktemperatuur	15 - 17 °C
Bewaarpotentieel	2 - 3 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] => -135 [product_ordered] => 84 [product_stockhandle] => 0 [low_stock_notification] => 0 [product_available_date] => 2010-04-26 22:00:00 [product_availability] => [product_special] => 0 [product_discontinued] => 0 [pordering] => 0 [product_sales] => 248 [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] => 185 ) [virtuemart_media_id] => Array ( [0] => 511 ) [allPrices] => Array ( [0] => Array ( [virtuemart_product_price_id] => 370 [virtuemart_product_id] => 185 [virtuemart_shoppergroup_id] => 0 [product_price] => 6.36364 [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] => 2010-04-27 11:26:47 [created_by] => 0 [modified_on] => 2023-01-04 10:52:29 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 6.36364 [basePrice] => 6.36364 [basePriceVariant] => 6.36364 [basePriceWithTax] => 7.7 [discountedPriceWithoutTax] => 6.36364 [priceBeforeTax] => 6.36364 [salesPrice] => 7.7 [taxAmount] => 1.33636 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 7.7 [unitPrice] => 10.26667 [discountAmount] => -0 [priceWithoutTax] => 6.36364 [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] => 7.7 [discountedPriceWithoutTaxTt] => 6.36364 [priceWithoutTaxTt] => 6.36364 [discountAmountTt] => -0 [taxAmountTt] => 1.33636 ) ) [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] => 344 ) [1] => Array ( [virtuemart_category_id] => 36 [category_parent_id] => 22 [virtuemart_vendor_id] => 1 [category_name] => Penedés [slug] => penedes [category_description] =>

Penedés biedt een grote verscheidenheid aan microklimaten, op hoogtes die variëren van zeeniveau tot 750 meter en experimenteert duchtig met buitenlandse variëteiten. Ook in biologische technieken is men vooruitstrevend. Belangrijkste druiven: Ull de Llebre (Tempranillo), Merlot, Cabernet Sauvignon, Syrah, en Chardonnay.

 

[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:14:56 [created_by] => 0 [modified_on] => 2017-10-04 09:40:59 [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] => 343 ) [2] => Array ( [virtuemart_category_id] => 66 [category_parent_id] => 7 [virtuemart_vendor_id] => 1 [category_name] => BIO wijnen [slug] => bio-wijnen [category_description] =>

Deze lijst bevat alle wijnen die voorzien zijn van het Europese BIO-label. Meer info over biologische wijnen vind je hier.

[category_template] => [category_layout] => [category_product_layout] => [products_per_row] => [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] => 2019-04-10 15:26:47 [created_by] => 68 [modified_on] => 2019-04-18 09:42:15 [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] => 792 ) ) [canonCatId] => 11 [canonCatIdname] => [categories] => Array ( [0] => 11 [1] => 36 [2] => 66 ) [virtuemart_category_id] => 11 [ordering] => 0 [id] => 344 [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] => 370 [virtuemart_product_id] => 185 [virtuemart_shoppergroup_id] => 0 [product_price] => 6.36364 [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] => 2010-04-27 11:26:47 [created_by] => 0 [modified_on] => 2023-01-04 10:52:29 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 6.36364 [basePrice] => 6.36364 [basePriceVariant] => 6.36364 [basePriceWithTax] => 7.7 [discountedPriceWithoutTax] => 6.36364 [priceBeforeTax] => 6.36364 [salesPrice] => 7.7 [taxAmount] => 1.33636 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 7.7 [unitPrice] => 10.26667 [discountAmount] => -0 [priceWithoutTax] => 6.36364 [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] => 7.7 [discountedPriceWithoutTaxTt] => 6.36364 [priceWithoutTaxTt] => 6.36364 [discountAmountTt] => -0 [taxAmountTt] => 1.33636 ) [canonical] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=185&virtuemart_category_id=11 [link] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=185&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] => 167 [virtuemart_product_id] => 185 [customfield_value] => Cataluñ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] => Cataluña ) [1] => stdClass Object ( [virtuemart_custom_id] => 6 [custom_parent_id] => 0 [virtuemart_vendor_id] => 1 [custom_jplugin_id] => 0 [custom_element] => [admin_only] => 0 [custom_title] => Inner ribbon [show_title] => 0 [custom_tip] => [custom_value] => bio;bio-eu;eco [custom_desc] => options for the inner 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] => 3 [virtuemart_shoppergroup_id] => [virtuemart_customfield_id] => 1282 [virtuemart_product_id] => 185 [customfield_value] => bio [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] => bio ) ) ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-sumarroca-negre9 [file_extension] => jpg [virtuemart_media_id] => 511 [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-sumarroca-negre9.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => product [file_url] => images/stories/virtuemart/product/puerta-del-sol-sumarroca-negre9.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] => 2020-05-04 09:10:05 [created_by] => 68 [modified_on] => 2023-01-04 10:52:29 [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-sumarroca-negre9.jpg [product_price] => 6.36364 [neighbours] => Array ( [previous] => Array ( [0] => Array ( [virtuemart_product_id] => 534 [product_name] => Flor de Añon Roble 2021 [product_price] => 5.760330 ) ) [next] => Array ( [0] => Array ( [virtuemart_product_id] => 187 [product_name] => Barahonda Monastrell 2021 [product_price] => 6.454550 ) ) ) [manufacturers] => Array ( [0] => TableManufacturers Object ( [virtuemart_manufacturer_id] => 1 [mf_name] => Sumarroca [slug] => bodegues-sumarroca [mf_email] => info@puertadelsol.be [mf_desc] =>

Dit is één van de weinige bodegas uit D.O. Penedès en D.O. Cava die uitsluitend eigen druiven gebruiken (465 ha). Het familie- bedrijf onderscheidt zich door het respect voor de ecologie van de terroir. De cavas ondergaan een gisting op fles die veel langer is dan de wettelijke norm. Resultaat: een fi- nesse die de supermarkt-cava ver overstijgt!

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.sumarroca.es [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 3986465724 [_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] => 62616348 [warning_count] => 0 ) [nameQuote:protected] => ` [nullDate:protected] => 0000-00-00 00:00:00 [_database:JDatabaseDriver:private] => puertade_site [count:protected] => 109 [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 =185 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] => 2015-10-16 09:34:03 [modified_by] => 68 [virtuemart_media_id] => Array ( [0] => 51 ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-bedegues-sumarroca [file_extension] => jpg [virtuemart_media_id] => 51 [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-bedegues-sumarroca.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => manufacturer [file_url] => images/stories/virtuemart/manufacturer/puerta-del-sol-bedegues-sumarroca.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:16:42 [created_by] => 68 [modified_on] => 2015-10-16 09:34:03 [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-bedegues-sumarroca.jpg ) ) [event] => stdClass Object ( [afterDisplayTitle] => [beforeDisplayContent] => [afterDisplayContent] => ) )