Gazelle Esprit C
Keuze uit 8% korting of 10% van de adviesprijs als winkeltegoed
Beschrijving
Ontdek de nieuwe Esprit.
Robuust en dankzij het vernieuwde design ontzettend van deze tijd.
Je rijdt soepel en snel en hij is praktisch onverwoestbaar.
Handig in de stad en een drukke stalling.
De verlichting gaat via de naafdynamo, is ingebouwd en altijd aan. Geen lege batterijen meer.
De techniek in beeld:
1 versnelling met terugtraprem
Spanninga Galeo, LED koplamp, 15 Lux
AXA Solid Plus, ART ** gecertificeerd
In de kleur: Black mat mat (H/D)
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 set regenkleding 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.
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.009 seconds (+0.009); 1.49 MB (+1.149) - afterInitialise
Application 0.015 seconds (+0.006); 2.35 MB (+0.861) - afterRoute
Application 0.137 seconds (+0.122); 7.42 MB (+5.075) - afterDispatch
Application 0.138 seconds (+0.001); 7.49 MB (+0.067) - beforeRenderModule mod_custom (Social Links)
Application 0.140 seconds (+0.002); 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.143 seconds (+0.003); 7.53 MB (+0.032) - afterRenderModule mod_menu (Mijn account)
Application 0.143 seconds (+0.000); 7.52 MB (-0.005) - beforeRenderModule mod_menu (Klantenservice)
Application 0.143 seconds (+0.000); 7.53 MB (+0.006) - afterRenderModule mod_menu (Klantenservice)
Application 0.143 seconds (+0.000); 7.52 MB (-0.004) - beforeRenderModule mod_menu (Informatie)
Application 0.144 seconds (+0.001); 7.55 MB (+0.028) - afterRenderModule mod_menu (Informatie)
Application 0.144 seconds (+0.000); 7.55 MB (-0.005) - beforeRenderModule mod_custom (YouTube Kanaal)
Application 0.144 seconds (+0.000); 7.55 MB (+0.004) - afterRenderModule mod_custom (YouTube Kanaal)
Application 0.145 seconds (+0.000); 7.55 MB (-0.002) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.147 seconds (+0.002); 7.57 MB (+0.016) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.147 seconds (+0.000); 7.57 MB (+0.007) - beforeRenderModule mod_maximenuck (Maximenu CK)
Application 0.157 seconds (+0.010); 7.84 MB (+0.267) - afterRenderModule mod_maximenuck (Maximenu CK)
Application 0.158 seconds (+0.000); 7.81 MB (-0.034) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.161 seconds (+0.004); 7.83 MB (+0.021) - afterRenderModule mod_wft_search (Zoeken)
Application 0.162 seconds (+0.000); 7.82 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.169 seconds (+0.008); 8.06 MB (+0.235) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.169 seconds (+0.000); 8.05 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.170 seconds (+0.000); 8.06 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.170 seconds (+0.000); 8.06 MB (-0.004) - beforeRenderModule mod_menu (Mijn account)
Application 0.171 seconds (+0.001); 8.06 MB (+0.007) - afterRenderModule mod_menu (Mijn account)
Application 0.171 seconds (+0.000); 8.06 MB (-0.006) - beforeRenderModule mod_custom (Telefoon)
Application 0.171 seconds (+0.000); 8.06 MB (+0.004) - afterRenderModule mod_custom (Telefoon)
Application 0.171 seconds (+0.000); 8.06 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.171 seconds (+0.000); 8.07 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.171 seconds (+0.000); 8.06 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.175 seconds (+0.004); 8.07 MB (+0.004) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.182 seconds (+0.007); 8.13 MB (+0.060) - afterRender
8.16 MB (8,561,408 Bytes)
93 queries gelogd
SELECT `data`
FROM `Dv2vH_session`
WHERE `session_id` = '6c36f0af72b2a2be2955efb04b821bd9'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-esprit-c"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` = "4018"SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "4018"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "4018"SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "4018"
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-10-29 13:45:34" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-10-29 13:45:34" ) )
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` = 4018SELECT 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` = 4018
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "4018"
and `virtuemart_category_id`= "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`)
WHERE `Dv2vH_virtuemart_categories`.`virtuemart_category_id` = "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`
Where `virtuemart_product_id` =4018
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` = "4018" OR `virtuemart_product_id` = "4018")
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` = 4018SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 4020SELECT 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` =4018
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` =4018
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` =4018
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` =4018SELECT 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` =4019
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` =4020
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-10-29 13:45:34" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-29 13:45:34" ) 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` = "15406"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "15407"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "15408"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` = 1
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
AND l.`virtuemart_product_id`!="4018"
AND product_name <= "Gazelle Esprit C"
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` = 1
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
AND l.`virtuemart_product_id`!="4018"
AND product_name >= "Gazelle Esprit C"
ORDER BY product_name ASC
LIMIT 1SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "1"
ORDER BY `ordering`SELECT `category_child_id`
FROM `Dv2vH_virtuemart_category_categories`
WHERE `category_parent_id` = 1SHOW 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` = 1
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` = 1
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` = "3015"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` = 1
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY category_name ASCSELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "28"
ORDER BY `ordering`SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "29"
ORDER BY `ordering`SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "10800"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "10799"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` = "6387"
WHERE `virtuemart_product_id` = "6387"
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` = "16441"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16440"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16439"SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6387SELECT 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` = "5959"
WHERE `virtuemart_product_id` = "5959"
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` = "16788"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16779"SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16778"SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 5959SELECT 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-10-29 13:45:34')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-29 13:45:34')
AND m.access IN (1,1,2)
AND m.client_id = 0
AND (mm.menuid = 368 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-10-29 13:45:34" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-29 13:45:34" )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-10-29 13:45:34" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-29 13:45:34" )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-10-29 13:45:34" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-10-29 13:45:34" )UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1730209531;s:18:\"session.timer.last\";i:1730209533;s:17:\"session.timer.now\";i:1730209534;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:5:{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:1;s:23:\"vmlastvisitedproductids\";a:2:{i:0;i:4018;i:1;i:6344;}s:19:\"vmlastvisitedmanuid\";i:-1;s:15:\"vmlastvisItemid\";i:368;}' , `time` = '1730209534'
WHERE `session_id` = '6c36f0af72b2a2be2955efb04b821bd9'
60 query types gelogd, gesorteerd op weergave
SELECTEER Tabellen:
12 × SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions4 × SELECT id
FROM Dv2vH_assets4 × SELECT *
FROM Dv2vH_virtuemart_calcs4 × SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`3 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`3 × SELECT FOUND_ROWS(
2 × 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 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 `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 b.id
FROM Dv2vH_usergroups AS a
LEFT JOIN Dv2vH_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM `Dv2vH_menu`1 × SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`1 × 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 `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 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 folder AS type, element AS name, params
FROM Dv2vH_extensions1 × 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` = "6387"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` = "5959"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 count(Dv2vH_virtuemart_products.virtuemart_product_id) AS total
FROM `Dv2vH_virtuemart_products`, `Dv2vH_virtuemart_product_categories`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 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_shoppergroup_id`
FROM Dv2vH_virtuemart_calc_shoppergroups1 × SELECT `virtuemart_category_id`
FROM Dv2vH_virtuemart_calc_categories1 × 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 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 pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc1 × 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 `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`1 × SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`1 × SELECT *
FROM `Dv2vH_virtuemart_product_prices`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 virtuemart_product_id, product_name
FROM `Dv2vH_virtuemart_products_nl_nl` JOIN `Dv2vH_virtuemart_products` as C 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 *
FROM Dv2vH_languages1 × SELECT `customer_number`
FROM `Dv2vH_virtuemart_vmusers`1 × 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 `data`
FROM `Dv2vH_session`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`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`
ANDERE Tabellen:
1 × UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1730209531;s:18:\"session.timer.last\";i:1730209533;s:17:\"session.timer.now\";i:1730209534;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:5:{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:1;s:23:\"vmlastvisitedproductids\";a:2:{i:0;i:4018;i:1;i:6344;}s:19:\"vmlastvisitedmanuid\";i:-1;s:15:\"vmlastvisItemid\";i:368;}' , `time` = '1730209534'1 × SHOW FULL COLUMNS
FROM `Dv2vH_virtuemart_userfields1 × SHOW FULL COLUMNS
FROM `Dv2vH_assets1 × SHOW TABLES LIKE "Dv2vH_virtuemart_configs