Gazelle Orange C7+ HMB AANBIEDING
Beschrijving
Moeiteloos door het dagelijks verkeer, of een heerlijke toertocht door het prachtige Hollandse landschap.
Alles is even comfortabel, met een verende zadelpen en dito voorvork.
Overtuig jezelf van het gemak en de veiligheid van de brede, lage instap
De pluspunten van de Orange C7+ HMB:
• Krachtige, geruisloze ondersteuning
- • Het veilige gevoel van een stabiel aluminium frame
- • Eenmaal hydraulisch geremd wil je nooit meer zonder
- •Verkrijgbaar in diverse kleurstellingen
De techniek in beeld:
7 versnellingen Nexus in de naaf
Magura HS11 hydraulische velgremmen
Stabiel, lichtgewicht oversized aluminium frame
Busch & Müller Upp, LED koplamp, 30 Lux, aan-/uitschakeling via display
AXA Defender, ART ** gecertificeerd ringslot
Bosch Intuvia LCD midden display
In de kleur: Dust glans (H/D) Light Olive glans (D) Legion blue mat (D)
Met keuze uit 300 Wh, 400Wh of 500Wh Bosch drageraccu.
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 fiets 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 regenpak voor 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.338) - afterLoad
Application 0.008 seconds (+0.008); 1.49 MB (+1.149) - afterInitialise
Application 0.014 seconds (+0.006); 2.35 MB (+0.861) - afterRoute
Application 0.129 seconds (+0.114); 7.39 MB (+5.043) - afterDispatch
Application 0.130 seconds (+0.001); 7.46 MB (+0.067) - beforeRenderModule mod_custom (Social Links)
Application 0.131 seconds (+0.001); 7.47 MB (+0.008) - afterRenderModule mod_custom (Social Links)
Application 0.131 seconds (+0.000); 7.47 MB (-0.001) - beforeRenderModule mod_menu (Mijn account)
Application 0.133 seconds (+0.002); 7.50 MB (+0.032) - afterRenderModule mod_menu (Mijn account)
Application 0.133 seconds (+0.000); 7.49 MB (-0.005) - beforeRenderModule mod_menu (Klantenservice)
Application 0.134 seconds (+0.000); 7.50 MB (+0.006) - afterRenderModule mod_menu (Klantenservice)
Application 0.134 seconds (+0.000); 7.49 MB (-0.004) - beforeRenderModule mod_menu (Informatie)
Application 0.135 seconds (+0.001); 7.52 MB (+0.028) - afterRenderModule mod_menu (Informatie)
Application 0.135 seconds (+0.000); 7.52 MB (-0.005) - beforeRenderModule mod_custom (YouTube Kanaal)
Application 0.135 seconds (+0.000); 7.52 MB (+0.004) - afterRenderModule mod_custom (YouTube Kanaal)
Application 0.135 seconds (+0.000); 7.52 MB (-0.002) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.136 seconds (+0.002); 7.54 MB (+0.016) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.137 seconds (+0.000); 7.54 MB (+0.007) - beforeRenderModule mod_maximenuck (Maximenu CK)
Application 0.143 seconds (+0.007); 7.81 MB (+0.267) - afterRenderModule mod_maximenuck (Maximenu CK)
Application 0.143 seconds (+0.000); 7.78 MB (-0.034) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.146 seconds (+0.003); 7.80 MB (+0.020) - afterRenderModule mod_wft_search (Zoeken)
Application 0.146 seconds (+0.000); 7.79 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.152 seconds (+0.006); 8.02 MB (+0.235) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.152 seconds (+0.000); 8.02 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.153 seconds (+0.000); 8.03 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.153 seconds (+0.000); 8.03 MB (-0.004) - beforeRenderModule mod_menu (Mijn account)
Application 0.153 seconds (+0.001); 8.03 MB (+0.007) - afterRenderModule mod_menu (Mijn account)
Application 0.153 seconds (+0.000); 8.03 MB (-0.006) - beforeRenderModule mod_custom (Telefoon)
Application 0.153 seconds (+0.000); 8.03 MB (+0.004) - afterRenderModule mod_custom (Telefoon)
Application 0.153 seconds (+0.000); 8.03 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.154 seconds (+0.000); 8.04 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.154 seconds (+0.000); 8.03 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.156 seconds (+0.003); 8.03 MB (+0.004) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.161 seconds (+0.005); 8.09 MB (+0.060) - afterRender
8.13 MB (8,529,152 Bytes)
88 queries gelogd
SELECT `data`
FROM `Dv2vH_session`
WHERE `session_id` = '2899b2600b14ce82e5de845f4ef9f95a'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 ''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-orange-c7-plus-hmb-2"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` = "6036"SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6036"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6036"SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6036"
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-17 11:08:52" )
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-17 11:08:52" ) )
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` = 6036SELECT 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` = 6036
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6036"
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` =6036
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_idSELECT `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_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` = "6036" OR `virtuemart_product_id` = "6036")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASCSELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6036SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6037SELECT 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` =6036
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` =6036
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` =6036
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` =6036SELECT 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` =6256
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` =6037
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` =6038
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` =6039
and C.field_type = "C"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-17 11:08:52" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-17 11:08:52" ) OR `for_override` = "1" )SELECT `customer_number`
FROM `Dv2vH_virtuemart_vmusers`
WHERE `virtuemart_user_id`='0'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 `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16247"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` = 13
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
AND l.`virtuemart_product_id`!="6036"
AND product_name <= "Gazelle Orange C7+ HMB AANBIEDING"
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` = 13
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
AND l.`virtuemart_product_id`!="6036"
AND product_name >= "Gazelle Orange C7+ HMB AANBIEDING"
ORDER BY product_name ASC
LIMIT 1SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "13"
ORDER BY `ordering`SELECT `category_child_id`
FROM `Dv2vH_virtuemart_category_categories`
WHERE `category_parent_id` = 13SHOW 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 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 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 SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `Dv2vH_virtuemart_categories_nl_nl` l JOIN `Dv2vH_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `Dv2vH_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 13
AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
ORDER BY category_name ASC
LIMIT 0, 120SELECT FOUND_ROWS()
SELECT 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` = 13
AND `Dv2vH_virtuemart_products`.`virtuemart_product_id` = `Dv2vH_virtuemart_product_categories`.`virtuemart_product_id`
AND `Dv2vH_virtuemart_products`.`published` = "1"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "10798"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "10797"SELECT id
FROM Dv2vH_assets
WHERE parent_id = 0SELECT 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`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` = "5434"
WHERE `virtuemart_product_id` = "5434"
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` = "16548"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "15333"SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 5434SELECT 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` = "6456"
WHERE `virtuemart_product_id` = "6456"
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` = "16641"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16640"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16639"SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6456SELECT 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-17 11:08:52')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-17 11:08:52')
AND m.access IN (1,1,2)
AND m.client_id = 0
AND (mm.menuid = 369 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-17 11:08:52" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-17 11:08:52" )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-17 11:08:52" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-17 11:08:52" )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-17 11:08:52" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-17 11:08:52" )UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1715944130;s:18:\"session.timer.last\";i:1715944130;s:17:\"session.timer.now\";i:1715944132;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:13;s:23:\"vmlastvisitedproductids\";a:2:{i:0;i:6036;i:1;i:5970;}}' , `time` = '1715944132'
WHERE `session_id` = '2899b2600b14ce82e5de845f4ef9f95a'
59 query types gelogd, gesorteerd op weergave
SELECTEER Tabellen:
8 × SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions4 × SELECT *
FROM Dv2vH_virtuemart_calcs4 × 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`4 × SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`4 × SELECT id
FROM Dv2vH_assets3 × SELECT FOUND_ROWS(
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 *
FROM `Dv2vH_virtuemart_shoppergroups`2 × 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 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`1 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`1 × SELECT `category_child_id`
FROM `Dv2vH_virtuemart_category_categories`1 × SELECT `config`
FROM `Dv2vH_virtuemart_configs`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 *
FROM `Dv2vH_menu`1 × SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`1 × SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_calc_shoppergroups1 × SELECT `virtuemart_country_id`
FROM Dv2vH_virtuemart_calc_countries1 × SELECT `virtuemart_state_id`
FROM Dv2vH_virtuemart_calc_states1 × SELECT `virtuemart_manufacturer_id`
FROM Dv2vH_virtuemart_calc_manufacturers1 × 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 c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `Dv2vH_virtuemart_categories_nl_nl` l JOIN `Dv2vH_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `Dv2vH_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_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` = "5434"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` = "6456"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 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 *
FROM `Dv2vH_virtuemart_userfields`1 × SELECT folder AS type, element AS name, params
FROM Dv2vH_extensions1 × 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_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_category_id`
FROM Dv2vH_virtuemart_calc_categories1 × SELECT `customer_number`
FROM `Dv2vH_virtuemart_vmusers`1 × SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc1 × 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`1 × SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`1 × SELECT `Dv2vH_virtuemart_categories`.* ,`Dv2vH_virtuemart_categories_nl_nl`.*
FROM `Dv2vH_virtuemart_categories`
INNER JOIN `Dv2vH_virtuemart_categories_nl_nl` using (`virtuemart_category_id`)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`)1 × SELECT *
FROM `Dv2vH_virtuemart_product_prices`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`1 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`1 × SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`1 × 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`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 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`1 × SELECT virtuemart_product_id, product_name
FROM `Dv2vH_virtuemart_products_nl_nl` JOIN `Dv2vH_virtuemart_products` as C using (`virtuemart_product_id`)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 `data`
FROM `Dv2vH_session`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 *
FROM `Dv2vH_virtuemart_currencies`1 × SELECT `price_display`,`custom_price_display`
FROM `Dv2vH_virtuemart_shoppergroups` AS `sg`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 `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_vmuser_shoppergroups`
ANDERE Tabellen:
1 × UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1715944130;s:18:\"session.timer.last\";i:1715944130;s:17:\"session.timer.now\";i:1715944132;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:13;s:23:\"vmlastvisitedproductids\";a:2:{i:0;i:6036;i:1;i:5970;}}' , `time` = '1715944132'1 × SHOW FULL COLUMNS
FROM `Dv2vH_virtuemart_userfields1 × SHOW FULL COLUMNS
FROM `Dv2vH_assets1 × SHOW TABLES LIKE "Dv2vH_virtuemart_configs