Gazelle Puur_NL Midnight, Heren; Black mat 7 versnellingen
Keuze uit 8% korting of 10% van de adviesprijs als winkeltegoed
Beschrijving
Gazelle PUUR-NL MIDNIGHT
Een transportfiets in zijn zuiverste vorm: een stoer buizenframe met smalle voor- en achterdrager.
Je kunt heel veel meenemen en toch gemakkelijk blijven sturen en licht trappen.
Dat zit 'm in de combinatie van lichtgewicht materialen en brede banden met een comfortabele zitpositie.
Dit speciale model is uitgevoerd met verlichting via de naafdynamo en lichtgevende details op het frame.
Met keuze uit 3 of 7 versnellingen stem je 'm helemaal af op wat je ermee wilt gaan doen.
De pluspunten van de Puur_NL Midnight:
• Altijd licht doormiddel van verlichting op naafdynamo
• Handige stuurblokkering en dubbele pootstandaard
• Standaard uitgevoerd met smalle voor- én achterdrager
• Robuuste fiets die tegen een stootje kan
De techniek in beeld:
3 versnellingen Shimano Nexus met terugtraprem
of 7 versnellingen Shimano Nexus met terugtraprem achter en rollerbrake voor
Stabiel lichtgewicht oversized aluminium frame
Spanninga Swingo, LED koplamp, 20 Lux
AXA Solid Plus, ART ** gecertificeerd
In de kleur: Black mat (D/H)
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 krat of mand 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.343) - afterLoad
Application 0.008 seconds (+0.008); 1.49 MB (+1.143) - afterInitialise
Application 0.013 seconds (+0.005); 2.35 MB (+0.868) - afterRoute
Application 0.122 seconds (+0.109); 7.44 MB (+5.088) - afterDispatch
Application 0.123 seconds (+0.001); 7.51 MB (+0.068) - beforeRenderModule mod_custom (Social Links)
Application 0.124 seconds (+0.001); 7.52 MB (+0.008) - afterRenderModule mod_custom (Social Links)
Application 0.124 seconds (+0.000); 7.52 MB (-0.001) - beforeRenderModule mod_menu (Mijn account)
Application 0.126 seconds (+0.002); 7.55 MB (+0.032) - afterRenderModule mod_menu (Mijn account)
Application 0.126 seconds (+0.000); 7.54 MB (-0.005) - beforeRenderModule mod_menu (Klantenservice)
Application 0.126 seconds (+0.000); 7.55 MB (+0.006) - afterRenderModule mod_menu (Klantenservice)
Application 0.126 seconds (+0.000); 7.55 MB (-0.004) - beforeRenderModule mod_menu (Informatie)
Application 0.127 seconds (+0.001); 7.57 MB (+0.028) - afterRenderModule mod_menu (Informatie)
Application 0.127 seconds (+0.000); 7.57 MB (-0.005) - beforeRenderModule mod_custom (YouTube Kanaal)
Application 0.127 seconds (+0.000); 7.57 MB (+0.004) - afterRenderModule mod_custom (YouTube Kanaal)
Application 0.127 seconds (+0.000); 7.57 MB (-0.002) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.128 seconds (+0.001); 7.59 MB (+0.016) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.128 seconds (+0.000); 7.58 MB (-0.005) - beforeRenderModule mod_wft_responsiveslides (WFT Responsive Slides Module)
Application 0.129 seconds (+0.000); 7.60 MB (+0.013) - afterRenderModule mod_wft_responsiveslides (WFT Responsive Slides Module)
Application 0.129 seconds (+0.000); 7.60 MB (+0.003) - beforeRenderModule mod_maximenuck (Maximenu CK)
Application 0.136 seconds (+0.007); 7.86 MB (+0.262) - afterRenderModule mod_maximenuck (Maximenu CK)
Application 0.136 seconds (+0.000); 7.83 MB (-0.034) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.139 seconds (+0.003); 7.85 MB (+0.021) - afterRenderModule mod_wft_search (Zoeken)
Application 0.139 seconds (+0.000); 7.84 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.145 seconds (+0.006); 8.08 MB (+0.236) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.145 seconds (+0.000); 8.08 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.145 seconds (+0.000); 8.08 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.145 seconds (+0.000); 8.08 MB (-0.004) - beforeRenderModule mod_menu (Mijn account)
Application 0.146 seconds (+0.001); 8.09 MB (+0.007) - afterRenderModule mod_menu (Mijn account)
Application 0.146 seconds (+0.000); 8.08 MB (-0.006) - beforeRenderModule mod_custom (Telefoon)
Application 0.146 seconds (+0.000); 8.08 MB (+0.004) - afterRenderModule mod_custom (Telefoon)
Application 0.146 seconds (+0.000); 8.08 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.146 seconds (+0.000); 8.09 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.146 seconds (+0.000); 8.08 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.149 seconds (+0.003); 8.09 MB (+0.004) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.154 seconds (+0.005); 8.15 MB (+0.064) - afterRender
8.2 MB (8,593,880 Bytes)
122 queries gelogd
SELECT `data`
FROM `Dv2vH_session`
WHERE `session_id` = '40c73afdded78c9b6d15b26fddf214c7'DELETE
FROM `Dv2vH_session`
WHERE `time` < '1711648713'SELECT `session_id`
FROM `Dv2vH_session`
WHERE `session_id` = '40c73afdded78c9b6d15b26fddf214c7'
LIMIT 0, 1INSERT INTO `Dv2vH_session` (`session_id`, `client_id`, `time`)
VALUES ('40c73afdded78c9b6d15b26fddf214c7', 0, '1711650513')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 'heren'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-puur-nl-midnight-heren-black-7-versnellingen"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` = "6072"SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6072"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6072"SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6072"
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-03-28 18:28:33" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 18:28:33" ) )
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` = 6072SELECT 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` = 6072
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6072"
and `virtuemart_category_id`= "29"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` = "29"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` =6072
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` =6072
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` =6072
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` =6072
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-03-28 18:28:33" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-28 18:28:33" ) 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` =6072
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` =6072
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=11
ORDER BY field.`ordering`SELECT `currency_exchange_rate`
FROM `Dv2vH_virtuemart_currencies`
WHERE `virtuemart_currency_id` ="191"SELECT currency_code_3 AS fld
FROM `Dv2vH_virtuemart_currencies`
WHERE virtuemart_currency_id = 191SELECT currency_code_3 AS fld
FROM `Dv2vH_virtuemart_currencies`
WHERE virtuemart_currency_id = 47SELECT 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` =6072
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` =6072
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` =6072SELECT `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` = "6069"SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6069"
ORDER BY `ordering`SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6069"SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6069"
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-03-28 18:28:33" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-03-28 18:28:33" ) )
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` = 6069SELECT 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` = 6069
AND `published`=1
ORDER BY `c`.`ordering` ASCSELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6069"
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` =6069
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` = "6069" OR `virtuemart_product_id` = "6069")
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` = 6069SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6069SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6070SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6069SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6070SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6298SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6069SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6298SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6348SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6069SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6348SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6072SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6069SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6072SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6072SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6069SELECT 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` =6069
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` =6069
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` =6069
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` =6069SELECT 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` =6070
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` =6298
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` =6072
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` =6348
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 `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "15501"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` = 29
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
AND l.`virtuemart_product_id`!="6072"
AND product_name <= "Gazelle Puur_NL Midnight, Heren; Black mat 7 versnellingen"
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` = 29
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
AND l.`virtuemart_product_id`!="6072"
AND product_name >= "Gazelle Puur_NL Midnight, Heren; Black mat 7 versnellingen"
ORDER BY product_name ASC
LIMIT 1SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "29"
ORDER BY `ordering`SELECT `category_child_id`
FROM `Dv2vH_virtuemart_category_categories`
WHERE `category_parent_id` = 29SELECT 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` = 29
AND `Dv2vH_virtuemart_products`.`virtuemart_product_id` = `Dv2vH_virtuemart_product_categories`.`virtuemart_product_id`
AND `Dv2vH_virtuemart_products`.`published` = "1"SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 29SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 1SELECT `category_name`,`virtuemart_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`
WHERE `virtuemart_category_id`=1SELECT `category_name`,`virtuemart_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`
WHERE `virtuemart_category_id`=29SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "10799"SELECT 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` = "6348"
WHERE `virtuemart_product_id` = "6348"
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` = "16304"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` = "6298"
WHERE `virtuemart_product_id` = "6298"
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` = "16120"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-03-28 18:28:33')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-28 18:28:33')
AND m.access IN (1,1,2)
AND m.client_id = 0
AND (mm.menuid = 348 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-03-28 18:28:33" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-28 18:28:33" )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-03-28 18:28:33" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-28 18:28:33" )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-03-28 18:28:33" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-28 18:28:33" )UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711650513;s:18:\"session.timer.last\";i:1711650513;s:17:\"session.timer.now\";i:1711650513;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:29;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:6072;}}' , `time` = '1711650514'
WHERE `session_id` = '40c73afdded78c9b6d15b26fddf214c7'
70 query types gelogd, gesorteerd op weergave
SELECTEER Tabellen:
6 × SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`5 × SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions5 × SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`4 × 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 `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`4 × 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 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`3 × SELECT id
FROM Dv2vH_assets2 × 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 `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 `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`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 pc
LEFT JOIN `Dv2vH_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`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 b.rules
FROM Dv2vH_assets AS a
LEFT JOIN Dv2vH_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT `category_name`,`virtuemart_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`2 × SELECT currency_code_3 AS fld
FROM `Dv2vH_virtuemart_currencies`2 × SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc2 × SELECT FOUND_ROWS(
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 *
FROM `Dv2vH_virtuemart_shoppergroups`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 *
FROM `Dv2vH_virtuemart_product_prices`2 × SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`2 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`1 × SELECT `virtuemart_manufacturer_id`
FROM Dv2vH_virtuemart_calc_manufacturers1 × SELECT `session_id`
FROM `Dv2vH_session`1 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`1 × SELECT count(Dv2vH_virtuemart_products.virtuemart_product_id) AS total
FROM `Dv2vH_virtuemart_products`, `Dv2vH_virtuemart_product_categories`1 × SELECT `category_child_id`
FROM `Dv2vH_virtuemart_category_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` = "6298"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 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` = "6348"1 × SELECT `virtuemart_state_id`
FROM Dv2vH_virtuemart_calc_states1 × 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 `customer_number`
FROM `Dv2vH_virtuemart_vmusers`1 × SELECT *
FROM `Dv2vH_virtuemart_userfields`1 × SELECT a.rules
FROM Dv2vH_assets AS a1 × 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 `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 `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_shoppergroup_id`
FROM `Dv2vH_virtuemart_vmuser_shoppergroups`1 × 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 *
FROM Dv2vH_languages1 × 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 `config`
FROM `Dv2vH_virtuemart_configs`1 × SELECT `data`
FROM `Dv2vH_session`1 × 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 `virtuemart_category_id`
FROM Dv2vH_virtuemart_calc_categories1 × SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_calc_shoppergroups1 × SELECT id, rules
FROM `Dv2vH_viewlevels1 × SELECT folder AS type, element AS name, params
FROM Dv2vH_extensions1 × SELECT `currency_exchange_rate`
FROM `Dv2vH_virtuemart_currencies`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_category_id`
FROM `Dv2vH_virtuemart_categories_nl_nl`1 × SELECT `virtuemart_country_id`
FROM Dv2vH_virtuemart_calc_countries
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:1711650513;s:18:\"session.timer.last\";i:1711650513;s:17:\"session.timer.now\";i:1711650513;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:29;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:6072;}}' , `time` = '1711650514'1 × SHOW FULL COLUMNS
FROM `Dv2vH_assets1 × SHOW TABLES LIKE "Dv2vH_virtuemart_configs
1 × INSERT INTO `Dv2vH_session` (`session_id`, `client_id`, `time`)
VALUES ('40c73afdded78c9b6d15b26fddf214c7', 0, '1711650513'1 × DELETE
FROM `Dv2vH_session`