Gazelle Avignon C8 HMB NEW; Dames, Coral red mat
Keuze uit 8% korting of 10% van de adviesprijs als winkeltegoed.
Beschrijving
In het weekend frank en vrij toeren door de heuvels of in de thuisomgeving?
Het kan met de Avignon C8 HMB. Deze e-bike met middenmotor scoort qua comfort. Het begint al bij het opstappen.
Dat gaat met de lage, brede doorstap vlot en gemakkelijk. Onderweg heb je profijt van de hoogwaardige afwerking.
Brede banden, het gelzadel, de vering en de lederen handvatten maken de rit net wat aangenamer.
De Grenoble C8 is standaard uitgerust met een slim ant-diefstal systeem van Gazelle connect.
De pluspunten van de Avignon C8 HMB Connect:
• Stabiel frame met geintegreerde accu in het frame
- • Connectiviteit voor meer fietsplezoer en betere diefstalbescherming
- • Handige features, zoals Find my bike
- • Krachtige dagrijverlichting met zijwaartse zichtbaarheid
De techniek in beeld:
8 versnellingen Shimano Nexus in de naaf
Magura CT4 Hydraulische schijfremmen
Stabiel, oversized aluminium frame
Gazelle Fendervision, LED koplamp
Abus 4750L, ART ** gecertificeerd ringslot
Bosch Intuvia 100 Smart midden display
In de kleur: Coral red (D) Midnight blue mat (D)
Accu keuze 500Wh of 625Wh Bosch tube accu in het frame.
Nog meer technische gegevens nalezen? Dat kan hier.
Let op; De fietsen op onze website zijn een indicatie van onze voorraad.
Zeker weten of uw fiets direct op voorraad staat? Stuur ons een e-mail, bel of kom langs.
Zo voorkomt u teleurstelling.
WAT BIEDT BIKES&CARE U EXTRA?
Bij ons kunt u bij aanschaf van uw Gazelle Grenoble C8 HMB kiezen tussen:
- • 8% korting op de adviesprijs van de fiets. U schaft de fiets dus voordeliger aan....of,
- • 10% van de aanschafwaarde retour als winkeltegoed voor accessoires & onderhoudspaketten.
- Mooie tas nodig, stevig kettingslot of een spiegel op de nieuwe fiets? Gebruik uw tegoed daarvoor.
- • Of u ruilt uw huidige fiets in en verlaag op die manier de aanschafwaarde van uw nieuwe fiets.
EN.....
- U ontvangt altijd een eerste gratis servicebeurt na 3 maanden,
- Het eerste jaar een gratis leenfiets bij reparatie,
- En het eerste jaar gratis haal & breng service* (* mist woonachtig in de nabije omgeving van onze winkels).
EEN GAZELLE LEASEN? JA ZEKER!
Deze Gazelle leasen tegen vaste kosten per maand, ook dat kan.
Frieslandlease is onze partner als het gaat om operational lease; Leasen inclusief onderhoud en reparaties.
Echt iets voor u? Vraag ons naar de voorwaarden en kosten.
Joomla! Foutopsporingsconsole
password_clear ⇒
groups ⇒
vmcart ⇒ O:8:"stdClass":28:{s:8:"products";a:0:{}s:8:"vendorId";i:1;s:21:"lastVisitedCategoryId";i:0;s:28:"virtuemart_shipmentmethod_id";i:0;s:27:"virtuemart_paymentmethod_id";i:0;s:25:"automaticSelectedShipment";b:0;s:24:"automaticSelectedPayment";b:0;s:12:"order_number";N;s:19:"virtuemart_order_id";b:0;s:2:"BT";i:0;s:2:"ST";i:0;s:11:"tosAccepted";b:0;s:16:"customer_comment";s:0:"";s:10:"couponCode";s:0:"";s:20:"_triesValidateCoupon";a:0:{}s:14:"order_language";s:0:"";s:8:"cartData";N;s:5:"lists";N;s:14:"pricesCurrency";N;s:15:"paymentCurrency";N;s:10:"_inConfirm";b:0;s:11:"_inCheckOut";b:0;s:14:"_dataValidated";b:0;s:12:"_confirmDone";b:0;s:10:"STsameAsBT";b:1;s:15:"customer_number";s:7:"nonreg_";s:6:"layout";s:7:"default";s:10:"layoutPath";s:0:"";}
Application 0.000 seconds (+0.000); 0.34 MB (+0.337) - afterLoad
Application 0.013 seconds (+0.013); 1.49 MB (+1.150) - afterInitialise
Application 0.020 seconds (+0.007); 2.35 MB (+0.868) - afterRoute
Application 0.138 seconds (+0.118); 7.43 MB (+5.071) - afterDispatch
Application 0.138 seconds (+0.001); 7.49 MB (+0.067) - beforeRenderModule mod_custom (Social Links)
Application 0.140 seconds (+0.001); 7.50 MB (+0.008) - afterRenderModule mod_custom (Social Links)
Application 0.140 seconds (+0.000); 7.50 MB (-0.001) - beforeRenderModule mod_menu (Mijn account)
Application 0.142 seconds (+0.002); 7.53 MB (+0.032) - afterRenderModule mod_menu (Mijn account)
Application 0.142 seconds (+0.000); 7.53 MB (-0.005) - beforeRenderModule mod_menu (Klantenservice)
Application 0.142 seconds (+0.000); 7.53 MB (+0.006) - afterRenderModule mod_menu (Klantenservice)
Application 0.142 seconds (+0.000); 7.53 MB (-0.004) - beforeRenderModule mod_menu (Informatie)
Application 0.143 seconds (+0.001); 7.56 MB (+0.028) - afterRenderModule mod_menu (Informatie)
Application 0.143 seconds (+0.000); 7.55 MB (-0.005) - beforeRenderModule mod_custom (YouTube Kanaal)
Application 0.143 seconds (+0.000); 7.56 MB (+0.004) - afterRenderModule mod_custom (YouTube Kanaal)
Application 0.143 seconds (+0.000); 7.55 MB (-0.002) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.145 seconds (+0.002); 7.57 MB (+0.018) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.145 seconds (+0.000); 7.58 MB (+0.006) - beforeRenderModule mod_maximenuck (Maximenu CK)
Application 0.151 seconds (+0.006); 7.84 MB (+0.263) - afterRenderModule mod_maximenuck (Maximenu CK)
Application 0.151 seconds (+0.000); 7.81 MB (-0.035) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.154 seconds (+0.002); 7.83 MB (+0.021) - afterRenderModule mod_wft_search (Zoeken)
Application 0.154 seconds (+0.000); 7.82 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.159 seconds (+0.006); 8.06 MB (+0.235) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.159 seconds (+0.000); 8.05 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.160 seconds (+0.000); 8.06 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.160 seconds (+0.000); 8.06 MB (-0.004) - beforeRenderModule mod_menu (Mijn account)
Application 0.160 seconds (+0.001); 8.06 MB (+0.007) - afterRenderModule mod_menu (Mijn account)
Application 0.160 seconds (+0.000); 8.06 MB (-0.006) - beforeRenderModule mod_custom (Telefoon)
Application 0.160 seconds (+0.000); 8.06 MB (+0.004) - afterRenderModule mod_custom (Telefoon)
Application 0.161 seconds (+0.000); 8.06 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.161 seconds (+0.000); 8.07 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.161 seconds (+0.000); 8.06 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.163 seconds (+0.003); 8.06 MB (+0.004) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.168 seconds (+0.005); 8.13 MB (+0.063) - afterRender
8.17 MB (8,568,944 Bytes)
116 queries gelogd
SELECT `data`
FROM `Dv2vH_session`
WHERE `session_id` = 'a0832f94f377413cfbd96eed8b8587c6'DELETE
FROM `Dv2vH_session`
WHERE `time` < '1714817391'SELECT `session_id`
FROM `Dv2vH_session`
WHERE `session_id` = 'a0832f94f377413cfbd96eed8b8587c6'
LIMIT 0, 1INSERT INTO `Dv2vH_session` (`session_id`, `client_id`, `time`)
VALUES ('a0832f94f377413cfbd96eed8b8587c6', 0, '1714819191')SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM Dv2vH_usergroups AS a
LEFT JOIN Dv2vH_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `Dv2vH_viewlevels`SELECT folder AS type, element AS name, params
FROM Dv2vH_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM Dv2vH_menu AS m
LEFT JOIN Dv2vH_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSHOW TABLES LIKE "Dv2vH_virtuemart_configs"
SELECT `config`
FROM `Dv2vH_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'SELECT *
FROM `Dv2vH_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "nl-NL" )SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`
WHERE `slug` LIKE 'bosch'SELECT `p`.`virtuemart_product_id`
FROM `Dv2vH_virtuemart_products_nl_nl` AS `p`
LEFT JOIN `Dv2vH_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`
WHERE `p`.`slug` LIKE "gazelle-avignon-c8-hmb-new-coral-red-mat"SELECT *
FROM Dv2vH_languages
WHERE published=1
ORDER BY ordering ASCSELECT id, home, template, s.params
FROM Dv2vH_template_styles as s
LEFT JOIN Dv2vH_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_vmuser_shoppergroups`
WHERE `virtuemart_user_id` = "0"SELECT *
FROM `Dv2vH_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"SELECT `Dv2vH_virtuemart_products`.* ,`Dv2vH_virtuemart_products_nl_nl`.* ,`Dv2vH_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`Dv2vH_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `Dv2vH_virtuemart_products`
INNER JOIN `Dv2vH_virtuemart_products_nl_nl` using (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_manufacturers`
on `Dv2vH_virtuemart_product_manufacturers`.`virtuemart_product_id`=`Dv2vH_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `Dv2vH_virtuemart_product_customfields`
on `Dv2vH_virtuemart_product_customfields`.`virtuemart_product_id`=`Dv2vH_virtuemart_products`.`virtuemart_product_id`
WHERE `Dv2vH_virtuemart_products`.`virtuemart_product_id` = "6428"SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6428"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6428"SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6428"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-05-04 10:39:51" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-05-04 10:39:51" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT `Dv2vH_virtuemart_manufacturers`.* ,`Dv2vH_virtuemart_manufacturers_nl_nl`.*
FROM `Dv2vH_virtuemart_manufacturers`
INNER JOIN `Dv2vH_virtuemart_manufacturers_nl_nl` using (`virtuemart_manufacturer_id`)
WHERE `Dv2vH_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "2"SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 6428SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc
LEFT JOIN `Dv2vH_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 6428
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6428"
and `virtuemart_category_id`= "36"SELECT `Dv2vH_virtuemart_categories`.* ,`Dv2vH_virtuemart_categories_nl_nl`.*
FROM `Dv2vH_virtuemart_categories`
INNER JOIN `Dv2vH_virtuemart_categories_nl_nl` using (`virtuemart_category_id`)
WHERE `Dv2vH_virtuemart_categories`.`virtuemart_category_id` = "36"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6428
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6428
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6428
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6428
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `Dv2vH_virtuemart_vendors` AS v
LEFT JOIN `Dv2vH_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"SELECT *
FROM `Dv2vH_virtuemart_currencies`
WHERE `virtuemart_currency_id`="47"SELECT `price_display`,`custom_price_display`
FROM `Dv2vH_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"SELECT *
FROM `Dv2vH_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"SELECT *
FROM Dv2vH_virtuemart_calcs
WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-04 10:39:51" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-04 10:39:51" ) OR `for_override` = "1" )SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6428
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=4
ORDER BY field.`ordering`SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6428
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=7
ORDER BY field.`ordering`SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6428
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=11
ORDER BY field.`ordering`SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6428
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=16
ORDER BY field.`ordering`SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6428
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=25
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `Dv2vH_virtuemart_products_nl_nl` JOIN `Dv2vH_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =6428SELECT `Dv2vH_virtuemart_products`.* ,`Dv2vH_virtuemart_products_nl_nl`.* ,`Dv2vH_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`Dv2vH_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `Dv2vH_virtuemart_products`
INNER JOIN `Dv2vH_virtuemart_products_nl_nl` using (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_manufacturers`
on `Dv2vH_virtuemart_product_manufacturers`.`virtuemart_product_id`=`Dv2vH_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `Dv2vH_virtuemart_product_customfields`
on `Dv2vH_virtuemart_product_customfields`.`virtuemart_product_id`=`Dv2vH_virtuemart_products`.`virtuemart_product_id`
WHERE `Dv2vH_virtuemart_products`.`virtuemart_product_id` = "6427"SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6427"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6427"SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6427"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-05-04 10:39:51" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-05-04 10:39:51" ) )
AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 6427SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc
LEFT JOIN `Dv2vH_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 6427
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6427"
and `virtuemart_category_id`= "13"SELECT `Dv2vH_virtuemart_categories`.* ,`Dv2vH_virtuemart_categories_nl_nl`.*
FROM `Dv2vH_virtuemart_categories`
INNER JOIN `Dv2vH_virtuemart_categories_nl_nl` using (`virtuemart_category_id`)
WHERE `Dv2vH_virtuemart_categories`.`virtuemart_category_id` = "13"SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6427
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "6427" OR `virtuemart_product_id` = "6427")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASCSELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6427SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6427SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6428SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6427SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6428SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6429SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6427SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6429SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6428SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6427SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6427
and `field_type` = "Z"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6427
and `field_type` = "R"
and is_cart_attribute = 0
order by orderingSELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6427
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`SELECT virtuemart_product_id, product_name
FROM `Dv2vH_virtuemart_products_nl_nl` JOIN `Dv2vH_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =6427SELECT C.* , field.*
FROM `Dv2vH_virtuemart_product_customfields` AS field
LEFT JOIN `Dv2vH_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =6428
and C.field_type = "C"SELECT C.* , field.*
FROM `Dv2vH_virtuemart_product_customfields` AS field
LEFT JOIN `Dv2vH_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =6429
and C.field_type = "C"SELECT `virtuemart_category_id`
FROM Dv2vH_virtuemart_calc_categories
WHERE `virtuemart_calc_id`="6"SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_calc_shoppergroups
WHERE `virtuemart_calc_id`="6"SELECT `virtuemart_country_id`
FROM Dv2vH_virtuemart_calc_countries
WHERE `virtuemart_calc_id`="6"SELECT `virtuemart_state_id`
FROM Dv2vH_virtuemart_calc_states
WHERE `virtuemart_calc_id`="6"SELECT `virtuemart_manufacturer_id`
FROM Dv2vH_virtuemart_calc_manufacturers
WHERE `virtuemart_calc_id`="6"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 36SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 34SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 13SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 36SELECT `slug` as name
FROM `Dv2vH_virtuemart_categories_nl_nl`
WHERE `virtuemart_category_id`=36SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16543"SELECT p.`virtuemart_product_id`, l.`product_name`, `pc`.ordering
FROM `Dv2vH_virtuemart_products` as p
INNER JOIN `Dv2vH_virtuemart_products_nl_nl` as l using (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
WHERE ( p.`published`="1"
AND `pc`.`virtuemart_category_id` = 36
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
AND l.`virtuemart_product_id`!="6428"
AND product_name <= "Gazelle Avignon C8 HMB NEW; Dames, Coral red mat"
ORDER BY product_name DESC
LIMIT 1SELECT p.`virtuemart_product_id`, l.`product_name`, `pc`.ordering
FROM `Dv2vH_virtuemart_products` as p
INNER JOIN `Dv2vH_virtuemart_products_nl_nl` as l using (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
WHERE ( p.`published`="1"
AND `pc`.`virtuemart_category_id` = 36
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
AND l.`virtuemart_product_id`!="6428"
AND product_name >= "Gazelle Avignon C8 HMB NEW; Dames, Coral red mat"
ORDER BY product_name ASC
LIMIT 1SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "36"
ORDER BY `ordering`SELECT `category_child_id`
FROM `Dv2vH_virtuemart_category_categories`
WHERE `category_parent_id` = 36SELECT count(Dv2vH_virtuemart_products.virtuemart_product_id) AS total
FROM `Dv2vH_virtuemart_products`, `Dv2vH_virtuemart_product_categories`
WHERE `Dv2vH_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `Dv2vH_virtuemart_product_categories`.`virtuemart_category_id` = 36
AND `Dv2vH_virtuemart_products`.`virtuemart_product_id` = `Dv2vH_virtuemart_product_categories`.`virtuemart_product_id`
AND `Dv2vH_virtuemart_products`.`published` = "1"SELECT `category_name`,`virtuemart_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`
WHERE `virtuemart_category_id`=36SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16282"SELECT L.*
FROM `Dv2vH_virtuemart_categories_nl_nl` as L JOIN `Dv2vH_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `Dv2vH_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 36
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY category_name ASCSELECT a.rules
FROM Dv2vH_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSHOW FULL COLUMNS
FROM `Dv2vH_assets`SELECT id
FROM Dv2vH_assets
WHERE parent_id = 0SELECT b.rules
FROM Dv2vH_assets AS a
LEFT JOIN Dv2vH_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT b.rules
FROM Dv2vH_assets AS a
LEFT JOIN Dv2vH_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_virtuemart')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT id
FROM Dv2vH_assets
WHERE parent_id = 0SELECT id
FROM Dv2vH_assets
WHERE parent_id = 0SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `Dv2vH_virtuemart_shipmentmethods_nl_nl` as l JOIN `Dv2vH_virtuemart_shipmentmethods` AS v USING (`virtuemart_shipmentmethod_id`)
LEFT JOIN `Dv2vH_extensions` as j
ON j.`extension_id` = v.`shipment_jplugin_id`
LEFT
OUTER JOIN `Dv2vH_virtuemart_shipmentmethod_shoppergroups` AS s
ON v.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`
WHERE v.`published` = "1"
AND j.`element` = "weight_countries"
AND (v.`virtuemart_vendor_id` = "1" OR v.`virtuemart_vendor_id` = "0")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY v.`virtuemart_shipmentmethod_id`
ORDER BY v.`ordering`SELECT `customer_number`
FROM `Dv2vH_virtuemart_vmusers`
WHERE `virtuemart_user_id`='0'SHOW FULL COLUMNS
FROM `Dv2vH_virtuemart_userfields`SELECT *
FROM `Dv2vH_virtuemart_userfields`
WHERE 1 = 1
AND `account`=1
AND published = 1
ORDER BY orderingSELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `Dv2vH_virtuemart_paymentmethods_nl_nl` as l JOIN `Dv2vH_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `Dv2vH_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `Dv2vH_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
WHERE v.`published` = "1"
AND j.`element` = "klarna"
AND (v.`virtuemart_vendor_id` = "1" OR v.`virtuemart_vendor_id` = "0")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY v.`virtuemart_paymentmethod_id`
ORDER BY v.`ordering`SELECT SQL_CALC_FOUND_ROWS `Dv2vH_virtuemart_medias`.`virtuemart_media_id` as virtuemart_media_id
FROM `Dv2vH_virtuemart_product_medias`
LEFT JOIN `Dv2vH_virtuemart_medias`
ON `Dv2vH_virtuemart_medias`.`virtuemart_media_id`=`Dv2vH_virtuemart_product_medias`.`virtuemart_media_id`
and `virtuemart_product_id` = "6425"
WHERE `virtuemart_product_id` = "6425"
AND `Dv2vH_virtuemart_medias`.`published` = 1
ORDER BY `Dv2vH_virtuemart_medias`.created_on DESC
LIMIT 0, 120SELECT FOUND_ROWS()
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16541"SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6425SELECT SQL_CALC_FOUND_ROWS `Dv2vH_virtuemart_medias`.`virtuemart_media_id` as virtuemart_media_id
FROM `Dv2vH_virtuemart_product_medias`
LEFT JOIN `Dv2vH_virtuemart_medias`
ON `Dv2vH_virtuemart_medias`.`virtuemart_media_id`=`Dv2vH_virtuemart_product_medias`.`virtuemart_media_id`
and `virtuemart_product_id` = "6429"
WHERE `virtuemart_product_id` = "6429"
AND `Dv2vH_virtuemart_medias`.`published` = 1
ORDER BY `Dv2vH_virtuemart_medias`.created_on DESC
LIMIT 0, 120SELECT FOUND_ROWS()
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16547"SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM Dv2vH_modules AS m
LEFT JOIN Dv2vH_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN Dv2vH_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-04 10:39:51')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-04 10:39:51')
AND m.access IN (1,1,2)
AND m.client_id = 0
AND (mm.menuid = 372 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT *
FROM Dv2vH_modules
WHERE published=1
ORDER BY id ;SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'SELECT *
FROM Dv2vH_virtuemart_calcs
WHERE `calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-04 10:39:51" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-04 10:39:51" )SELECT *
FROM Dv2vH_virtuemart_calcs
WHERE `calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-04 10:39:51" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-04 10:39:51" )SELECT *
FROM Dv2vH_virtuemart_calcs
WHERE `calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-04 10:39:51" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-04 10:39:51" )UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714819191;s:18:\"session.timer.last\";i:1714819191;s:17:\"session.timer.now\";i:1714819191;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:14:\"productdetails\";O:8:\"stdClass\":2:{s:5:\"
limit\";s:3:\"int\";s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:2;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}__vm|a:3:{s:6:\"vmcart\";s:752:\"O:8:\"stdClass\":28:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:19:\"virtuemart_order_id\";b:0;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";b:0;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:10:\"_inConfirm\";b:0;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";s:6:\"layout\";s:7:\"default\";s:10:\"layoutPath\";s:0:\"\";}\";s:23:\"vmlastvisitedcategoryid\";i:36;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:6428;}}' , `time` = '1714819191'
WHERE `session_id` = 'a0832f94f377413cfbd96eed8b8587c6'
70 query types gelogd, gesorteerd op weergave
SELECTEER Tabellen:
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions5 × SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`4 × SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`4 × SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`4 × SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`4 × SELECT *
FROM Dv2vH_virtuemart_calcs4 × SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`4 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`3 × SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`3 × SELECT id
FROM Dv2vH_assets2 × SELECT `Dv2vH_virtuemart_categories`.* ,`Dv2vH_virtuemart_categories_nl_nl`.*
FROM `Dv2vH_virtuemart_categories`
INNER JOIN `Dv2vH_virtuemart_categories_nl_nl` using (`virtuemart_category_id`)2 × SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`2 × SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`2 × SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc
LEFT JOIN `Dv2vH_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`2 × SELECT FOUND_ROWS(
2 × SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`2 × SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc2 × SELECT p.`virtuemart_product_id`, l.`product_name`, `pc`.ordering
FROM `Dv2vH_virtuemart_products` as p
INNER JOIN `Dv2vH_virtuemart_products_nl_nl` as l using (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`2 × SELECT b.rules
FROM Dv2vH_assets AS a
LEFT JOIN Dv2vH_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT C.* , field.*
FROM `Dv2vH_virtuemart_product_customfields` AS field
LEFT JOIN `Dv2vH_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`2 × SELECT virtuemart_product_id, product_name
FROM `Dv2vH_virtuemart_products_nl_nl` JOIN `Dv2vH_virtuemart_products` as C using (`virtuemart_product_id`)2 × SELECT *
FROM `Dv2vH_virtuemart_shoppergroups`2 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`2 × SELECT `Dv2vH_virtuemart_products`.* ,`Dv2vH_virtuemart_products_nl_nl`.* ,`Dv2vH_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`Dv2vH_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `Dv2vH_virtuemart_products`
INNER JOIN `Dv2vH_virtuemart_products_nl_nl` using (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_manufacturers`
on `Dv2vH_virtuemart_product_manufacturers`.`virtuemart_product_id`=`Dv2vH_virtuemart_products`.`virtuemart_product_id`
LEFT JOIN `Dv2vH_virtuemart_product_customfields`
on `Dv2vH_virtuemart_product_customfields`.`virtuemart_product_id`=`Dv2vH_virtuemart_products`.`virtuemart_product_id`2 × SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`2 × SELECT *
FROM `Dv2vH_virtuemart_product_prices`1 × SELECT L.*
FROM `Dv2vH_virtuemart_categories_nl_nl` as L JOIN `Dv2vH_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `Dv2vH_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`1 × SELECT a.rules
FROM Dv2vH_assets AS a1 × SELECT folder AS type, element AS name, params
FROM Dv2vH_extensions1 × SELECT `category_name`,`virtuemart_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM Dv2vH_menu AS m
LEFT JOIN Dv2vH_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, rules
FROM `Dv2vH_viewlevels1 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`1 × SELECT `category_child_id`
FROM `Dv2vH_virtuemart_category_categories`1 × SELECT count(Dv2vH_virtuemart_products.virtuemart_product_id) AS total
FROM `Dv2vH_virtuemart_products`, `Dv2vH_virtuemart_product_categories`1 × SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `Dv2vH_virtuemart_paymentmethods_nl_nl` as l JOIN `Dv2vH_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `Dv2vH_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `Dv2vH_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`1 × SELECT SQL_CALC_FOUND_ROWS `Dv2vH_virtuemart_medias`.`virtuemart_media_id` as virtuemart_media_id
FROM `Dv2vH_virtuemart_product_medias`
LEFT JOIN `Dv2vH_virtuemart_medias`
ON `Dv2vH_virtuemart_medias`.`virtuemart_media_id`=`Dv2vH_virtuemart_product_medias`.`virtuemart_media_id`
and `virtuemart_product_id` = "6429"1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM Dv2vH_modules AS m
LEFT JOIN Dv2vH_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN Dv2vH_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM Dv2vH_modules1 × SELECT b.id
FROM Dv2vH_usergroups AS a
LEFT JOIN Dv2vH_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT SQL_CALC_FOUND_ROWS `Dv2vH_virtuemart_medias`.`virtuemart_media_id` as virtuemart_media_id
FROM `Dv2vH_virtuemart_product_medias`
LEFT JOIN `Dv2vH_virtuemart_medias`
ON `Dv2vH_virtuemart_medias`.`virtuemart_media_id`=`Dv2vH_virtuemart_product_medias`.`virtuemart_media_id`
and `virtuemart_product_id` = "6425"1 × SELECT `customer_number`
FROM `Dv2vH_virtuemart_vmusers`1 × SELECT *
FROM `Dv2vH_virtuemart_userfields`1 × SELECT `config`
FROM `Dv2vH_virtuemart_configs`1 × SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `Dv2vH_virtuemart_shipmentmethods_nl_nl` as l JOIN `Dv2vH_virtuemart_shipmentmethods` AS v USING (`virtuemart_shipmentmethod_id`)
LEFT JOIN `Dv2vH_extensions` as j
ON j.`extension_id` = v.`shipment_jplugin_id`
LEFT
OUTER JOIN `Dv2vH_virtuemart_shipmentmethod_shoppergroups` AS s
ON v.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`1 × SELECT `virtuemart_manufacturer_id`
FROM Dv2vH_virtuemart_calc_manufacturers1 × SELECT `session_id`
FROM `Dv2vH_session`1 × SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc USING (`virtuemart_product_id`)1 × SELECT id, home, template, s.params
FROM Dv2vH_template_styles as s
LEFT JOIN Dv2vH_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `data`
FROM `Dv2vH_session`1 × SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_vmuser_shoppergroups`1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `Dv2vH_virtuemart_vendors` AS v
LEFT JOIN `Dv2vH_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency1 × SELECT *
FROM `Dv2vH_virtuemart_currencies`1 × SELECT `price_display`,`custom_price_display`
FROM `Dv2vH_virtuemart_shoppergroups` AS `sg`1 × SELECT *
FROM Dv2vH_languages1 × SELECT `p`.`virtuemart_product_id`
FROM `Dv2vH_virtuemart_products_nl_nl` AS `p`
LEFT JOIN `Dv2vH_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`1 × SELECT `virtuemart_state_id`
FROM Dv2vH_virtuemart_calc_states1 × SELECT `Dv2vH_virtuemart_manufacturers`.* ,`Dv2vH_virtuemart_manufacturers_nl_nl`.*
FROM `Dv2vH_virtuemart_manufacturers`
INNER JOIN `Dv2vH_virtuemart_manufacturers_nl_nl` using (`virtuemart_manufacturer_id`)1 × SELECT *
FROM `Dv2vH_menu`1 × SELECT `virtuemart_country_id`
FROM Dv2vH_virtuemart_calc_countries1 × SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_calc_shoppergroups1 × SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`1 × SELECT `virtuemart_category_id`
FROM Dv2vH_virtuemart_calc_categories1 × SELECT `slug` as name
FROM `Dv2vH_virtuemart_categories_nl_nl`
ANDERE Tabellen:
1 × SHOW FULL COLUMNS
FROM `Dv2vH_virtuemart_userfields1 × UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714819191;s:18:\"session.timer.last\";i:1714819191;s:17:\"session.timer.now\";i:1714819191;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:14:\"productdetails\";O:8:\"stdClass\":2:{s:5:\"
limit\";s:3:\"int\";s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:2;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}__vm|a:3:{s:6:\"vmcart\";s:752:\"O:8:\"stdClass\":28:{s:8:\"products\";a:0:{}s:8:\"vendorId\";i:1;s:21:\"lastVisitedCategoryId\";i:0;s:28:\"virtuemart_shipmentmethod_id\";i:0;s:27:\"virtuemart_paymentmethod_id\";i:0;s:25:\"automaticSelectedShipment\";b:0;s:24:\"automaticSelectedPayment\";b:0;s:12:\"order_number\";N;s:19:\"virtuemart_order_id\";b:0;s:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";b:0;s:16:\"customer_comment\";s:0:\"\";s:10:\"couponCode\";s:0:\"\";s:20:\"_triesValidateCoupon\";a:0:{}s:14:\"order_language\";s:0:\"\";s:8:\"cartData\";N;s:5:\"lists\";N;s:14:\"pricesCurrency\";N;s:15:\"paymentCurrency\";N;s:10:\"_inConfirm\";b:0;s:11:\"_inCheckOut\";b:0;s:14:\"_dataValidated\";b:0;s:12:\"_confirmDone\";b:0;s:10:\"STsameAsBT\";b:1;s:15:\"customer_number\";s:7:\"nonreg_\";s:6:\"layout\";s:7:\"default\";s:10:\"layoutPath\";s:0:\"\";}\";s:23:\"vmlastvisitedcategoryid\";i:36;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:6428;}}' , `time` = '1714819191'1 × SHOW FULL COLUMNS
FROM `Dv2vH_assets1 × SHOW TABLES LIKE "Dv2vH_virtuemart_configs
1 × INSERT INTO `Dv2vH_session` (`session_id`, `client_id`, `time`)
VALUES ('a0832f94f377413cfbd96eed8b8587c6', 0, '1714819191'1 × DELETE
FROM `Dv2vH_session`