Rode wijnen

stdClass Object ( [virtuemart_manufacturer_id] => Array ( [0] => 60 ) [mf_name] => Romero de Ávila Salcedo [slug] => portento-petit-verdot [mf_email] => [mf_desc] =>

Bodegas Romero de Ávila Salcedo, La Mancha, is een van de weinige wijnhuizen ter wereld die nog steeds wijn kan maken in klei-amforen, zoals de Romeinen meer dan 2000 jaar geleden deden. De bodega is er trots op zeer speciale wijnen aan te bieden, anders dan alles wat al bestaat in de wijnmaakkunst.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 3857039210 [_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] => 62674995 [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 =546 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] => 2022-05-17 14:47:50 [created_by] => 68 [modified_on] => 2023-03-22 13:11:51 [modified_by] => 68 [virtuemart_product_id] => 546 [virtuemart_vendor_id] => 1 [product_parent_id] => 0 [product_sku] => LMRA32 [product_gtin] => [product_mpn] => [product_name] => Portento Petit Verdot 2021 [product_s_desc] => GOUD [product_desc] =>

Waardering	Goud - Berliner Wine Trophy 2022 "Onze Petit Verdot heeft net zoveel persoonlijkheid als een vos, daarom verdiende hij het niet om gewoon deel uit te maken van een coupage, hij verdiende het om 100% Petit Verdot te zijn"
Druiven	100% Petit Verdot
Lagering	2 maanden in eiken vaten
Kleur	Helder kersenrood
Neus	Krachtige aroma's van rood en zwart fruit en viooltjes
Mond	Stevig en goed gebalanseerd, mooie structuur en een lange afdronk
Gastronomie	Past zeer goed bij rood vlees, eenvoudig wild, worst en paddestoelen
Schenktemperatuur	14 - 16 °C
Bewaarpotentieel	3 - 4 jaar

[product_weight] => 0.0000 [product_weight_uom] => KG [product_length] => 0.0000 [product_width] => 0.0000 [product_height] => 0.0000 [product_lwh_uom] => IN [product_url] => [product_in_stock] => -13 [product_ordered] => 0 [product_stockhandle] => 0 [low_stock_notification] => 0 [product_available_date] => 2022-05-17 00:00:00 [product_availability] => [product_special] => 0 [product_discontinued] => 0 [pordering] => 0 [product_sales] => 13 [product_unit] => L [product_packaging] => 0.7500 [product_params] => min_order_level=""|max_order_level=""|step_order_level=""|shared_stock=0|product_box="6"| [intnotes] => [layout] => default [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] => 6 [allIds] => Array ( [0] => 546 ) [virtuemart_media_id] => Array ( [0] => 595 ) [allPrices] => Array ( [0] => Array ( [virtuemart_product_price_id] => 771 [virtuemart_product_id] => 546 [virtuemart_shoppergroup_id] => 0 [product_price] => 7.56198 [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] => 2022-05-17 14:47:50 [created_by] => 68 [modified_on] => 2023-03-22 13:11:51 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 7.56198 [basePrice] => 7.56198 [basePriceVariant] => 7.56198 [basePriceWithTax] => 9.15 [discountedPriceWithoutTax] => 7.56198 [priceBeforeTax] => 7.56198 [salesPrice] => 9.15 [taxAmount] => 1.58802 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 9.15 [unitPrice] => 12.19999 [discountAmount] => -0 [priceWithoutTax] => 7.56198 [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] => 9.15 [discountedPriceWithoutTaxTt] => 7.56198 [priceWithoutTaxTt] => 7.56198 [discountAmountTt] => -0 [taxAmountTt] => 1.58802 ) ) [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] => 1008 ) [1] => Array ( [virtuemart_category_id] => 33 [category_parent_id] => 22 [virtuemart_vendor_id] => 1 [category_name] => La Mancha [slug] => la-mancha [category_description] =>

Met 30.700 km² Spanje's grootste D.O. die 182 gemeenten omvat tussen de steden Albacete, Ciudad Real, Cuenca en Toledo. La Mancha is de grootste wijnproducerende regio ter wereld met in totaal 191,699 ha aan wijngaarden. Belangrijkste druiven: Airén en Tempranillo.

[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:12:05 [created_by] => 0 [modified_on] => 2017-10-04 09:39:47 [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] => 1009 ) [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] => 1023 ) ) [canonCatId] => 11 [canonCatIdname] => [categories] => Array ( [0] => 11 [1] => 33 [2] => 59 ) [virtuemart_category_id] => 11 [ordering] => 0 [id] => 1008 [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] => 771 [virtuemart_product_id] => 546 [virtuemart_shoppergroup_id] => 0 [product_price] => 7.56198 [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] => 2022-05-17 14:47:50 [created_by] => 68 [modified_on] => 2023-03-22 13:11:51 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 7.56198 [basePrice] => 7.56198 [basePriceVariant] => 7.56198 [basePriceWithTax] => 9.15 [discountedPriceWithoutTax] => 7.56198 [priceBeforeTax] => 7.56198 [salesPrice] => 9.15 [taxAmount] => 1.58802 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 9.15 [unitPrice] => 12.19999 [discountAmount] => -0 [priceWithoutTax] => 7.56198 [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] => 9.15 [discountedPriceWithoutTaxTt] => 7.56198 [priceWithoutTaxTt] => 7.56198 [discountAmountTt] => -0 [taxAmountTt] => 1.58802 ) [canonical] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=546&virtuemart_category_id=11 [link] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=546&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] => 1896 [virtuemart_product_id] => 546 [customfield_value] => Castilla-La Mancha [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-La Mancha ) [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] => 2 [virtuemart_shoppergroup_id] => [virtuemart_customfield_id] => 2192 [virtuemart_product_id] => 546 [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-portento-petit-verdot2 [file_extension] => jpg [virtuemart_media_id] => 595 [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-portento-petit-verdot2.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => product [file_url] => images/stories/virtuemart/product/puerta-del-sol-portento-petit-verdot2.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-07-27 12:51:48 [created_by] => 68 [modified_on] => 2023-03-22 13:11:51 [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-portento-petit-verdot2.jpg [product_price] => 7.56198 [neighbours] => Array ( [previous] => Array ( [0] => Array ( [virtuemart_product_id] => 547 [product_name] => Portento Merlot 2021 [product_price] => 7.561980 ) ) [next] => Array ( [0] => Array ( [virtuemart_product_id] => 545 [product_name] => Portento Syrah 2021 [product_price] => 7.561980 ) ) ) [manufacturers] => Array ( [0] => TableManufacturers Object ( [virtuemart_manufacturer_id] => 60 [mf_name] => Romero de Ávila Salcedo [slug] => romero-de-ávila-salcedo [mf_email] => [mf_desc] =>

Bodegas Romero de Ávila Salcedo, La Mancha, is een van de weinige wijnhuizen ter wereld die nog steeds wijn kan maken in klei-amforen, zoals de Romeinen meer dan 2000 jaar geleden deden. De bodega is er trots op zeer speciale wijnen aan te bieden, anders dan alles wat al bestaat in de wijnmaakkunst.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 964673918 [_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] => 62674995 [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 =546 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] => 2022-05-17 12:10:35 [created_by] => 68 [modified_on] => 2022-05-23 15:29:20 [modified_by] => 68 [virtuemart_media_id] => Array ( [0] => 580 ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-romero-de-avila-salcedo-b3 [file_extension] => jpg [virtuemart_media_id] => 580 [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-romero-de-avila-salcedo-b3.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => manufacturer [file_url] => images/stories/virtuemart/manufacturer/puerta-del-sol-romero-de-avila-salcedo-b3.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-05-23 15:27:08 [created_by] => 68 [modified_on] => 2022-05-23 15:29:20 [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-romero-de-avila-salcedo-b3.jpg ) ) [event] => stdClass Object ( [afterDisplayTitle] => [beforeDisplayContent] => [afterDisplayContent] => ) )