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";a: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";a:10:{s:6:"VatTax";a:0:{}s:4:"duty";i:1;s:7:"payment";i:0;s:11:"paymentName";s:29:"Geen betaalwijze geselecteerd";s:12:"totalProduct";i:0;s:14:"DBTaxRulesBill";a:0:{}s:12:"taxRulesBill";a:0:{}s:14:"DATaxRulesBill";a:0:{}s:12:"shipmentName";s:30:"Geen verzendwijze geselecteerd";s:5:"vmVat";b:1;}s:5:"lists";N;s:14:"pricesCurrency";i:47;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.010 seconds (+0.010); 1.49 MB (+1.143) - afterInitialise
Application 0.015 seconds (+0.005); 2.35 MB (+0.866) - afterRoute
Application 0.383 seconds (+0.368); 7.93 MB (+5.575) - afterDispatch
Application 0.385 seconds (+0.002); 8.07 MB (+0.146) - beforeRenderModule mod_custom (Social Links)
Application 0.387 seconds (+0.001); 8.08 MB (+0.008) - afterRenderModule mod_custom (Social Links)
Application 0.387 seconds (+0.000); 8.08 MB (-0.001) - beforeRenderModule mod_menu (Mijn account)
Application 0.389 seconds (+0.002); 8.11 MB (+0.032) - afterRenderModule mod_menu (Mijn account)
Application 0.389 seconds (+0.000); 8.11 MB (-0.005) - beforeRenderModule mod_menu (Klantenservice)
Application 0.389 seconds (+0.000); 8.11 MB (+0.006) - afterRenderModule mod_menu (Klantenservice)
Application 0.389 seconds (+0.000); 8.11 MB (-0.004) - beforeRenderModule mod_menu (Informatie)
Application 0.390 seconds (+0.001); 8.14 MB (+0.028) - afterRenderModule mod_menu (Informatie)
Application 0.390 seconds (+0.000); 8.13 MB (-0.005) - beforeRenderModule mod_custom (YouTube Kanaal)
Application 0.390 seconds (+0.000); 8.14 MB (+0.004) - afterRenderModule mod_custom (YouTube Kanaal)
Application 0.390 seconds (+0.000); 8.13 MB (-0.002) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.392 seconds (+0.002); 8.15 MB (+0.015) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.392 seconds (+0.000); 8.16 MB (+0.007) - beforeRenderModule mod_maximenuck (Maximenu CK)
Application 0.400 seconds (+0.008); 8.42 MB (+0.263) - afterRenderModule mod_maximenuck (Maximenu CK)
Application 0.400 seconds (+0.000); 8.38 MB (-0.034) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.403 seconds (+0.003); 8.41 MB (+0.021) - afterRenderModule mod_wft_search (Zoeken)
Application 0.403 seconds (+0.000); 8.40 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.409 seconds (+0.005); 8.42 MB (+0.017) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.409 seconds (+0.000); 8.41 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.409 seconds (+0.000); 8.42 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.409 seconds (+0.000); 8.42 MB (-0.004) - beforeRenderModule mod_menu (Mijn account)
Application 0.410 seconds (+0.001); 8.42 MB (+0.007) - afterRenderModule mod_menu (Mijn account)
Application 0.410 seconds (+0.000); 8.42 MB (-0.006) - beforeRenderModule mod_custom (Telefoon)
Application 0.410 seconds (+0.000); 8.42 MB (+0.004) - afterRenderModule mod_custom (Telefoon)
Application 0.410 seconds (+0.000); 8.42 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.410 seconds (+0.000); 8.43 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 0.410 seconds (+0.000); 8.42 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.413 seconds (+0.003); 8.43 MB (+0.005) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 0.417 seconds (+0.004); 8.48 MB (+0.050) - afterRender
8.49 MB (8,897,776 Bytes)
SELECT `data`
FROM `Dv2vH_session`
WHERE `session_id` = '8dcdc000aa5f05d97318739531d74e90'
DELETE
FROM `Dv2vH_session`
WHERE `time` < '1711717319'
SELECT `session_id`
FROM `Dv2vH_session`
WHERE `session_id` = '8dcdc000aa5f05d97318739531d74e90'
LIMIT 0, 1
INSERT INTO `Dv2vH_session`
(`session_id`, `client_id`, `time`)
VALUES
('8dcdc000aa5f05d97318739531d74e90', 0, '1711719119')
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 = 1
SELECT 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 ordering
SELECT 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.lft
SHOW 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 *
FROM Dv2vH_languages
WHERE published=1
ORDER BY ordering ASC
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_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT `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 `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"
SHOW FULL COLUMNS
FROM `Dv2vH_virtuemart_userfields`
SELECT *
FROM `Dv2vH_virtuemart_userfields`
WHERE 1 = 1
AND `account`=1
AND published = 1
AND FIND_IN_SET(name, 'address_type') = 0
ORDER BY ordering
SELECT a.rules
FROM Dv2vH_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SHOW FULL COLUMNS
FROM `Dv2vH_assets`
SELECT id
FROM Dv2vH_assets
WHERE parent_id = 0
SELECT 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.lft
SELECT 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.lft
SELECT fieldtitle, fieldvalue
FROM Dv2vH_virtuemart_userfield_values
WHERE virtuemart_userfield_id = 10
ORDER BY ordering
SELECT *
FROM `Dv2vH_virtuemart_countries`
WHERE `published` = 1
ORDER BY country_name ASC
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-29 13:31:59" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-29 13:31:59" )
OR `for_override` = "1" )
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-29 13:31:59" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-29 13:31:59" )
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-29 13:31:59" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-29 13:31:59" )
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-29 13:31:59" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-29 13:31:59" )
SELECT `Dv2vH_virtuemart_vendors`.* ,`Dv2vH_virtuemart_vendors_nl_nl`.*
FROM `Dv2vH_virtuemart_vendors`
INNER JOIN `Dv2vH_virtuemart_vendors_nl_nl` using (`virtuemart_vendor_id`)
WHERE `Dv2vH_virtuemart_vendors`.`virtuemart_vendor_id` = "1"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_vendor_medias`
WHERE `virtuemart_vendor_id` = "1"
ORDER BY `ordering`
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "9627"
SELECT SQL_CALC_FOUND_ROWS *
FROM `Dv2vH_virtuemart_shipmentmethods_nl_nl` as l JOIN `Dv2vH_virtuemart_shipmentmethods` USING (`virtuemart_shipmentmethod_id`)
ORDER BY ordering DESC
LIMIT 0, 120
SELECT FOUND_ROWS()
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "1"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "1"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "2"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "2"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "3"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "3"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "4"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "4"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "5"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "5"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "6"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "6"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "7"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "7"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "8"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "8"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "9"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "9"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "10"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "10"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "11"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "11"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "13"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "13"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "14"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "14"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "15"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "15"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "16"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "16"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "17"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "17"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "18"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "18"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "19"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "19"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "20"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "20"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "21"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "21"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "22"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "22"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "23"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "23"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "24"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "24"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "25"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "25"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "26"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "26"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "27"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "27"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "28"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "28"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "29"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "29"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "30"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "30"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "31"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "31"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "32"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "32"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "33"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "33"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "34"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "34"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "35"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "35"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "36"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "36"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "37"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "37"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "38"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "38"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "39"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "39"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "40"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "40"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "41"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "41"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "42"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "42"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "43"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "43"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "44"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "44"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "45"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "45"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "46"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "46"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "47"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "47"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "48"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "48"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "49"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "49"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "50"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "50"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "52"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "52"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "53"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "53"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "54"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "54"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "55"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "55"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "56"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "56"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "57"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "57"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "58"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "58"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "59"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "59"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "60"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "60"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "61"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "61"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "62"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "62"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "63"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "63"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "64"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "64"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "65"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "65"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "66"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "66"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "67"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "67"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "68"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "68"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "69"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "69"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "70"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "70"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "71"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "71"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "72"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "72"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "73"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "73"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "74"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "74"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "75"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "75"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "76"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "76"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "83"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "83"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "84"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "84"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "85"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "85"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "86"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "86"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "87"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "87"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "88"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "88"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "89"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "89"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "90"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "90"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "91"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "91"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "92"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "92"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "93"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "93"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "94"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "94"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "95"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "95"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "96"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "96"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "97"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "97"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "98"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "98"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "99"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "99"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "100"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "100"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "101"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "101"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "102"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "102"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "103"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "103"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "104"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "104"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "105"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "105"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "106"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "106"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "107"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "107"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "108"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "108"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "109"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "109"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "110"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "110"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "111"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "111"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "112"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "112"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "113"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "113"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "114"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "114"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "115"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "115"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "116"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "116"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "117"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "117"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "118"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "118"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "119"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "119"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "120"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "120"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "121"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "121"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "122"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "122"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "123"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "123"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "124"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "124"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "125"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "125"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "126"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "126"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "127"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "127"
SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE `virtuemart_shipmentmethod_id` = "128"
SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
WHERE virtuemart_shipmentmethod_id = "128"
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`
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 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-29 13:31:59')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-29 13:31:59')
AND m.access IN (1,1,2)
AND m.client_id = 0
AND (mm.menuid = 351 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT 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'
UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711719119;s:18:\"session.timer.last\";i:1711719119;s:17:\"session.timer.now\";i:1711719119;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:4:\"cart\";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:1:{s:6:\"vmcart\";s:1050:\"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\";a: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\";a:10:{s:6:\"VatTax\";a:0:{}s:4:\"duty\";i:1;s:7:\"payment\";i:0;s:11:\"paymentName\";s:29:\"Geen betaalwijze geselecteerd\";s:12:\"totalProduct\";i:0;s:14:\"DBTaxRulesBill\";a:0:{}s:12:\"taxRulesBill\";a:0:{}s:14:\"DATaxRulesBill\";a:0:{}s:12:\"shipmentName\";s:30:\"Geen verzendwijze geselecteerd\";s:5:\"vmVat\";b:1;}s:5:\"lists\";N;s:14:\"pricesCurrency\";i:47;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:\"\";}\";}'
, `time` = '1711719119'
WHERE `session_id` = '8dcdc000aa5f05d97318739531d74e90'
120 × SELECT virtuemart_shoppergroup_id
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
120 × SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_shipmentmethod_shoppergroups
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions
4 × SELECT *
FROM Dv2vH_virtuemart_calcs
2 × SELECT b.rules
FROM Dv2vH_assets AS a
LEFT JOIN Dv2vH_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × SELECT *
FROM `Dv2vH_virtuemart_shoppergroups`
1 × SELECT `Dv2vH_virtuemart_vendors`.* ,`Dv2vH_virtuemart_vendors_nl_nl`.*
FROM `Dv2vH_virtuemart_vendors`
INNER JOIN `Dv2vH_virtuemart_vendors_nl_nl` using (`virtuemart_vendor_id`)
1 × SELECT *
FROM `Dv2vH_virtuemart_countries`
1 × SELECT fieldtitle, fieldvalue
FROM Dv2vH_virtuemart_userfield_values
1 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_vendor_medias`
1 × SELECT SQL_CALC_FOUND_ROWS *
FROM `Dv2vH_virtuemart_shipmentmethods_nl_nl` as l JOIN `Dv2vH_virtuemart_shipmentmethods` USING (`virtuemart_shipmentmethod_id`)
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_id
1 × SELECT *
FROM Dv2vH_modules
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 FOUND_ROWS(
1 × SELECT id
FROM Dv2vH_assets
1 × SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
1 × SELECT *
FROM `Dv2vH_virtuemart_userfields`
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_id
1 × SELECT `config`
FROM `Dv2vH_virtuemart_configs`
1 × SELECT folder AS type, element AS name, params
FROM Dv2vH_extensions
1 × SELECT id, rules
FROM `Dv2vH_viewlevels
1 × SELECT `session_id`
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.rgt
1 × SELECT *
FROM `Dv2vH_menu`
1 × SELECT *
FROM Dv2vH_languages
1 × SELECT `price_display`,`custom_price_display`
FROM `Dv2vH_virtuemart_shoppergroups` AS `sg`
1 × SELECT `data`
FROM `Dv2vH_session`
1 × SELECT *
FROM `Dv2vH_virtuemart_currencies`
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_currency
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_id
1 × SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_vmuser_shoppergroups`
1 × SELECT a.rules
FROM Dv2vH_assets AS a
1 × SHOW FULL COLUMNS
FROM `Dv2vH_assets
1 × UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711719119;s:18:\"session.timer.last\";i:1711719119;s:17:\"session.timer.now\";i:1711719119;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:4:\"cart\";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:1:{s:6:\"vmcart\";s:1050:\"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\";a: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\";a:10:{s:6:\"VatTax\";a:0:{}s:4:\"duty\";i:1;s:7:\"payment\";i:0;s:11:\"paymentName\";s:29:\"Geen betaalwijze geselecteerd\";s:12:\"totalProduct\";i:0;s:14:\"DBTaxRulesBill\";a:0:{}s:12:\"taxRulesBill\";a:0:{}s:14:\"DATaxRulesBill\";a:0:{}s:12:\"shipmentName\";s:30:\"Geen verzendwijze geselecteerd\";s:5:\"vmVat\";b:1;}s:5:\"lists\";N;s:14:\"pricesCurrency\";i:47;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:\"\";}\";}' , `time` = '1711719119'
1 × SHOW FULL COLUMNS
FROM `Dv2vH_virtuemart_userfields
1 × SHOW TABLES LIKE "Dv2vH_virtuemart_configs
1 × INSERT INTO `Dv2vH_session` (`session_id`, `client_id`, `time`)
VALUES ('8dcdc000aa5f05d97318739531d74e90', 0, '1711719119'
1 × DELETE
FROM `Dv2vH_session`