Rode wijnen

stdClass Object ( [virtuemart_manufacturer_id] => Array ( [0] => 43 ) [mf_name] => Chozas Carrascal [slug] => anma-tinto [mf_email] => info@puertadelsol.be [mf_desc] =>

Chozas Carrascal uit D.O. Utiel-Requena maakt uitsluitend wijnen die het Europese bio-label dragen! In 1989 startte de familie López dit ambitieus project op basis van 11 variëteiten van eigen wijngaarden.

Het resultaat zijn wijnen van hoge kwaliteit en een uitgesproken karakter.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.chozascarrascal.es/webnueva/index.html [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 1624363426 [_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] => 62673104 [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 =507 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] => 2021-03-26 14:38:17 [created_by] => 68 [modified_on] => 2023-04-22 09:38:37 [modified_by] => 68 [virtuemart_product_id] => 507 [virtuemart_vendor_id] => 1 [product_parent_id] => 0 [product_sku] => URCC33 [product_gtin] => [product_mpn] => [product_name] => Anma Tinto 2018 BIO [product_s_desc] => 90/100 [product_desc] =>

Waardering
Druiven	Syrah, Garnacha
Lagering	10 maanden vatlagering van 5.000 liter
Kleur	Levendig kersenrood met een robijnen rand
Neus	Fijn en complex aroma, intens en elegant. Vooral rijp fruit met een toest van toast, geconcentreerd met aanvullende rokerige en minerale toetsen.
Mond	Zachte en ronde aanzet met zeer beleefde tannines. Mooi evenwicht tussen zuren en fruit, wat het verleidelijke van deze wijn verklaard. Aanhoudens smakenpalet met de herkenbare toast
Gastronomie	Anma Tinto BIO laat zich zo drinken en past bij vele vlees-, pastagerechten en pizza's
Schenktemperatuur	14 - 16 °C
Bewaarpotentieel	3 - 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] => -180 [product_ordered] => 0 [product_stockhandle] => 0 [low_stock_notification] => 0 [product_available_date] => 2021-03-26 00:00:00 [product_availability] => ico_medaille.gif [product_special] => 0 [product_discontinued] => 0 [pordering] => 0 [product_sales] => 33 [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] => 507 ) [virtuemart_media_id] => Array ( [0] => 540 ) [allPrices] => Array ( [0] => Array ( [virtuemart_product_price_id] => 732 [virtuemart_product_id] => 507 [virtuemart_shoppergroup_id] => 0 [product_price] => 12.45455 [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] => 2021-03-26 14:38:17 [created_by] => 68 [modified_on] => 2023-04-22 09:38:37 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 12.45455 [basePrice] => 12.45455 [basePriceVariant] => 12.45455 [basePriceWithTax] => 15.07001 [discountedPriceWithoutTax] => 12.45455 [priceBeforeTax] => 12.45455 [salesPrice] => 15.07001 [taxAmount] => 2.61546 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 15.07001 [unitPrice] => 20.09334 [discountAmount] => -0 [priceWithoutTax] => 12.45455 [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] => 15.07001 [discountedPriceWithoutTaxTt] => 12.45455 [priceWithoutTaxTt] => 12.45455 [discountAmountTt] => -0 [taxAmountTt] => 2.61546 ) ) [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] => 846 ) [1] => Array ( [virtuemart_category_id] => 56 [category_parent_id] => 22 [virtuemart_vendor_id] => 1 [category_name] => Utiel-Requena [slug] => utiel-requena [category_description] =>

Gelegen ten westen van Valencia rond de 2 buurstadjes Utiel en Requena met de Bobal- druif als visitekaartje. De wijnbouwers leren volop hoe ze maximaal hun voordeel kunnen doen met de uitstekende wijnbouwom- standigheden, die zich zeer goed lenen voor biologische wijnbouw. Belangrijkste druiven: Bobal, Tempranillo, Macabeo en S.-Blanc.

[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] => 2010-06-08 12:44:40 [created_by] => 0 [modified_on] => 2017-10-04 09:45:12 [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] => 847 ) [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] => 849 ) ) [canonCatId] => 11 [canonCatIdname] => [categories] => Array ( [0] => 11 [1] => 56 [2] => 66 ) [virtuemart_category_id] => 11 [ordering] => 0 [id] => 846 [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] => 732 [virtuemart_product_id] => 507 [virtuemart_shoppergroup_id] => 0 [product_price] => 12.45455 [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] => 2021-03-26 14:38:17 [created_by] => 68 [modified_on] => 2023-04-22 09:38:37 [modified_by] => 68 [locked_on] => 0000-00-00 00:00:00 [locked_by] => 0 [costPrice] => 12.45455 [basePrice] => 12.45455 [basePriceVariant] => 12.45455 [basePriceWithTax] => 15.07001 [discountedPriceWithoutTax] => 12.45455 [priceBeforeTax] => 12.45455 [salesPrice] => 15.07001 [taxAmount] => 2.61546 [salesPriceWithDiscount] => 0 [salesPriceTemp] => 15.07001 [unitPrice] => 20.09334 [discountAmount] => -0 [priceWithoutTax] => 12.45455 [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] => 15.07001 [discountedPriceWithoutTaxTt] => 12.45455 [priceWithoutTaxTt] => 12.45455 [discountAmountTt] => -0 [taxAmountTt] => 2.61546 ) [canonical] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=507&virtuemart_category_id=11 [link] => index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=507&virtuemart_category_id=11 [addToCartButton] => [availability] => ico_medaille.gif [customfieldsSorted] => Array ( [normal] => Array ( [0] => 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] => 0 [virtuemart_shoppergroup_id] => [virtuemart_customfield_id] => 1521 [virtuemart_product_id] => 507 [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 ) [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 [searchable] => 0 [layout_pos] => [custom_params] => 0 [shared] => 0 [published] => 1 [ordering] => 1 [virtuemart_shoppergroup_id] => [virtuemart_customfield_id] => 1523 [virtuemart_product_id] => 507 [customfield_value] => Comunidad Valenciana [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] => Comunidad Valenciana ) ) ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-anma-tinto [file_extension] => jpg [virtuemart_media_id] => 540 [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-anma-tinto.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => product [file_url] => images/stories/virtuemart/product/puerta-del-sol-anma-tinto.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] => 2021-03-26 15:36:12 [created_by] => 68 [modified_on] => 2023-04-22 09:38:37 [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-anma-tinto.jpg [product_price] => 12.45455 [neighbours] => Array ( [previous] => Array ( [0] => Array ( [virtuemart_product_id] => 517 [product_name] => Sembro Edición Limitada 2020 [product_price] => 11.454550 ) ) [next] => Array ( [0] => Array ( [virtuemart_product_id] => 541 [product_name] => Vi Cool Negre 2020 [product_price] => 12.818180 ) ) ) [manufacturers] => Array ( [0] => TableManufacturers Object ( [virtuemart_manufacturer_id] => 43 [mf_name] => Chozas Carrascal [slug] => bodegas-chozas-carrascal [mf_email] => info@puertadelsol.be [mf_desc] =>

Chozas Carrascal uit D.O. Utiel-Requena maakt uitsluitend wijnen die het Europese bio-label dragen! In 1989 startte de familie López dit ambitieus project op basis van 11 variëteiten van eigen wijngaarden.

Het resultaat zijn wijnen van hoge kwaliteit en een uitgesproken karakter.

[virtuemart_manufacturercategories_id] => 1 [mf_url] => http://www.chozascarrascal.es/webnueva/index.html [customtitle] => [metakey] => [metadesc] => [metarobot] => [metaauthor] => [published] => 1 [_lhash:VmTable:private] => 2235868530 [_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] => 62673104 [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 =507 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:39:10 [modified_by] => 68 [virtuemart_media_id] => Array ( [0] => 54 ) [images] => Array ( [0] => VmImage Object ( [media_attributes] => 0 [setRole] => [file_name] => puerta-del-sol-chozas-carrascal [file_extension] => jpg [virtuemart_media_id] => 54 [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-chozas-carrascal.jpg [file_description] => [file_meta] => [file_class] => [file_mimetype] => image/jpeg [file_type] => manufacturer [file_url] => images/stories/virtuemart/manufacturer/puerta-del-sol-chozas-carrascal.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:47:44 [created_by] => 68 [modified_on] => 2015-10-16 09:39:10 [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-chozas-carrascal.jpg ) ) [event] => stdClass Object ( [afterDisplayTitle] => [beforeDisplayContent] => [afterDisplayContent] => ) )