Meer over ons weten? Klik hier al meer dan 120 jaar een familiebedrijf.
7225,00 €
3799,00 €
329,95 €
2699,00 €
5125,00 €
Recordaantal e-bike diefstallen Met ca. 90.000 stuks werd volgens aangiftecijfers van de Nationale...
Verkoopstop De bakfietsen van Babboe kwamen in februari en maart volop in de...
Headsets en koptelefoons Koptelefoons zijn een onmisbare accessoire geworden in het dagelijks leven....
Call stack | ||
# | Function | Location |
---|---|---|
1 | JSite->render() | JROOT/index.php:48 |
2 | JDocumentHTML->render() | JROOT/includes/application.php:268 |
3 | JDocumentHTML->_renderTemplate() | JROOT/libraries/joomla/document/html/html.php:433 |
4 | JDocumentHTML->getBuffer() | JROOT/libraries/joomla/document/html/html.php:652 |
5 | JDocumentRendererModules->render() | JROOT/libraries/joomla/document/html/html.php:371 |
6 | JDocumentRendererModule->render() | JROOT/libraries/joomla/document/html/renderer/modules.php:39 |
7 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/html/renderer/module.php:107 |
8 | include() | JROOT/libraries/joomla/application/module/helper.php:173 |
9 | modFeedHelper::getFeed() | JROOT/modules/mod_feed/mod_feed.php:27 |
10 | JFactory::getFeedParser() | JROOT/modules/mod_feed/helper.php:33 |
11 | JError::raiseWarning() | JROOT/libraries/joomla/factory.php:366 |
12 | JError::raise() | JROOT/libraries/joomla/error/error.php:276 |
password_clear ⇒
groups ⇒
vmcart ⇒ O:8:"stdClass":28:{s:8:"products";a:0:{}s:8:"vendorId";i:1;s:21:"lastVisitedCategoryId";i:0;s:28:"virtuemart_shipmentmethod_id";i:0;s:27:"virtuemart_paymentmethod_id";i:0;s:25:"automaticSelectedShipment";b:0;s:24:"automaticSelectedPayment";b:0;s:12:"order_number";N;s:19:"virtuemart_order_id";b:0;s:2:"BT";i:0;s:2:"ST";i:0;s:11:"tosAccepted";b:0;s:16:"customer_comment";s:0:"";s:10:"couponCode";s:0:"";s:20:"_triesValidateCoupon";a:0:{}s:14:"order_language";s:0:"";s:8:"cartData";N;s:5:"lists";N;s:14:"pricesCurrency";N;s:15:"paymentCurrency";N;s:10:"_inConfirm";b:0;s:11:"_inCheckOut";b:0;s:14:"_dataValidated";b:0;s:12:"_confirmDone";b:0;s:10:"STsameAsBT";b:1;s:15:"customer_number";s:7:"nonreg_";s:6:"layout";s:7:"default";s:10:"layoutPath";s:0:"";}
Application 0.000 seconds (+0.000); 0.34 MB (+0.337) - afterLoad
Application 0.009 seconds (+0.009); 1.48 MB (+1.143) - afterInitialise
Application 0.011 seconds (+0.002); 1.92 MB (+0.444) - afterRoute
Application 0.275 seconds (+0.264); 6.28 MB (+4.355) - afterDispatch
Application 0.276 seconds (+0.001); 6.38 MB (+0.099) - beforeRenderModule mod_custom (Social Links)
Application 0.278 seconds (+0.001); 6.38 MB (+0.008) - afterRenderModule mod_custom (Social Links)
Application 0.278 seconds (+0.000); 6.38 MB (-0.001) - beforeRenderModule mod_menu (Mijn account)
Application 0.280 seconds (+0.002); 6.42 MB (+0.032) - afterRenderModule mod_menu (Mijn account)
Application 0.280 seconds (+0.000); 6.41 MB (-0.005) - beforeRenderModule mod_menu (Klantenservice)
Application 0.280 seconds (+0.000); 6.42 MB (+0.006) - afterRenderModule mod_menu (Klantenservice)
Application 0.280 seconds (+0.000); 6.41 MB (-0.004) - beforeRenderModule mod_menu (Informatie)
Application 0.281 seconds (+0.001); 6.44 MB (+0.032) - afterRenderModule mod_menu (Informatie)
Application 0.281 seconds (+0.000); 6.44 MB (-0.006) - beforeRenderModule mod_custom (Contact)
Application 0.284 seconds (+0.003); 6.52 MB (+0.077) - afterRenderModule mod_custom (Contact)
Application 0.284 seconds (+0.000); 6.51 MB (-0.001) - beforeRenderModule mod_feed (NIEUWS)
Application 0.747 seconds (+0.463); 7.24 MB (+0.724) - afterRenderModule mod_feed (NIEUWS)
Application 0.747 seconds (+0.000); 7.13 MB (-0.109) - beforeRenderModule mod_custom (YouTube Kanaal)
Application 0.747 seconds (+0.000); 7.13 MB (+0.004) - afterRenderModule mod_custom (YouTube Kanaal)
Application 0.747 seconds (+0.000); 7.13 MB (-0.003) - beforeRenderModule mod_custom (Over Bikes & Care)
Application 0.747 seconds (+0.000); 7.13 MB (+0.004) - afterRenderModule mod_custom (Over Bikes & Care)
Application 0.747 seconds (+0.000); 7.13 MB (-0.002) - beforeRenderModule mod_custom (Links)
Application 0.747 seconds (+0.000); 7.14 MB (+0.004) - afterRenderModule mod_custom (Links)
Application 0.747 seconds (+0.000); 7.14 MB (-0.001) - beforeRenderModule mod_banners (Banners)
Application 0.750 seconds (+0.003); 7.21 MB (+0.074) - afterRenderModule mod_banners (Banners)
Application 0.750 seconds (+0.000); 7.20 MB (-0.006) - beforeRenderModule mod_articles_latest (Aanbiedingen)
Application 0.756 seconds (+0.006); 7.35 MB (+0.145) - afterRenderModule mod_articles_latest (Aanbiedingen)
Application 0.756 seconds (+0.000); 7.31 MB (-0.040) - beforeRenderModule mod_virtuemart_manufacturer (Onze merken)
Application 0.763 seconds (+0.006); 7.46 MB (+0.154) - afterRenderModule mod_virtuemart_manufacturer (Onze merken)
Application 0.763 seconds (+0.000); 7.46 MB (-0.003) - beforeRenderModule mod_feed (Reviews)
Application 0.926 seconds (+0.163); 7.51 MB (+0.051) - afterRenderModule mod_feed (Reviews)
Application 0.926 seconds (+0.000); 7.51 MB (+0.002) - beforeRenderModule mod_wft_responsiveslides (WFT Responsive Slides Module)
Application 0.927 seconds (+0.000); 7.53 MB (+0.013) - afterRenderModule mod_wft_responsiveslides (WFT Responsive Slides Module)
Application 0.927 seconds (+0.000); 7.53 MB (+0.003) - beforeRenderModule mod_maximenuck (Maximenu CK)
Application 0.935 seconds (+0.008); 7.79 MB (+0.265) - afterRenderModule mod_maximenuck (Maximenu CK)
Application 0.935 seconds (+0.000); 7.76 MB (-0.034) - beforeRenderModule mod_wft_search (Zoeken)
Application 0.937 seconds (+0.002); 7.78 MB (+0.020) - afterRenderModule mod_wft_search (Zoeken)
Application 0.937 seconds (+0.000); 7.77 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 1.002 seconds (+0.065); 10.32 MB (+2.550) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 1.002 seconds (+0.000); 10.32 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 1.002 seconds (+0.000); 10.33 MB (+0.008) - afterRenderModule mod_wft_search (Zoeken)
Application 1.002 seconds (+0.000); 10.33 MB (-0.004) - beforeRenderModule mod_menu (Mijn account)
Application 1.003 seconds (+0.001); 10.33 MB (+0.007) - afterRenderModule mod_menu (Mijn account)
Application 1.003 seconds (+0.000); 10.33 MB (-0.006) - beforeRenderModule mod_custom (Telefoon)
Application 1.003 seconds (+0.000); 10.33 MB (+0.004) - afterRenderModule mod_custom (Telefoon)
Application 1.003 seconds (+0.000); 10.33 MB (-0.002) - beforeRenderModule mod_wft_search (Zoeken)
Application 1.004 seconds (+0.000); 10.34 MB (+0.007) - afterRenderModule mod_wft_search (Zoeken)
Application 1.004 seconds (+0.000); 10.33 MB (-0.006) - beforeRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 1.006 seconds (+0.002); 10.34 MB (+0.009) - afterRenderModule mod_wft_virtuemart_cart (Winkelwagen)
Application 1.012 seconds (+0.007); 10.42 MB (+0.078) - afterRender
10.43 MB (10,941,224 Bytes)
SELECT `data`
FROM `Dv2vH_session`
WHERE `session_id` = '2c19235c8abdca1817ef0665a7901055'
DELETE
FROM `Dv2vH_session`
WHERE `time` < '1711706543'
SELECT `session_id`
FROM `Dv2vH_session`
WHERE `session_id` = '2c19235c8abdca1817ef0665a7901055'
LIMIT 0, 1
INSERT INTO `Dv2vH_session`
(`session_id`, `client_id`, `time`)
VALUES
('2c19235c8abdca1817ef0665a7901055', 0, '1711708343')
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
SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
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
SHOW TABLES LIKE "Dv2vH_virtuemart_configs"
SELECT `config`
FROM `Dv2vH_virtuemart_configs`
WHERE `virtuemart_config_id` = "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`)
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 L.*
FROM `Dv2vH_virtuemart_categories_nl_nl` as L
JOIN `Dv2vH_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `Dv2vH_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 0
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY category_name ASC
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "22"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "13"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "1"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "18"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "97"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "100"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "17"
ORDER BY `ordering`
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16305"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "3015"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "4276"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16285"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16467"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "4275"
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 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 `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 p.`virtuemart_product_id`
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` > 0
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`product_special`="1" )
group by p.`virtuemart_product_id`
ORDER BY RAND() ASC
LIMIT 0, 3
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` = "6359"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6359"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6359"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6359"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6359
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`
WHERE pc.`virtuemart_product_id` = 6359
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6359"
and `virtuemart_category_id`= "28"
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` = "28"
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` =6359
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
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`
Where `virtuemart_product_id` =6359
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6359
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6359
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 *
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 10:32:23" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-29 10:32:23" )
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` =6359
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` =6359
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=11
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6359
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` =6359
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` =6359
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` = "5959"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "5959"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "5959"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "5959"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 5959
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`
WHERE pc.`virtuemart_product_id` = 5959
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "5959"
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` =5959
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "5959" OR `virtuemart_product_id` = "5959")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
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 `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 5959
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 5959
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 5963
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5959
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 5963
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6359
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5959
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6359
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6483
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5959
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6483
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 5960
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5959
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 5960
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 5961
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5959
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 5961
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 5962
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5959
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 5962
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =5959
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =5959
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =5959
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` =5959
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` =5960
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` =5963
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` =5961
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` =6359
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` =5962
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` =6483
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_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` = "6473"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6473"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6473"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6473"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = "14"
SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 6473
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`
WHERE pc.`virtuemart_product_id` = 6473
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6473"
and `virtuemart_category_id`= "97"
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` = "97"
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` =6473
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "6473" OR `virtuemart_product_id` = "6473")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6473
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6473
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6475
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6473
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6475
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6476
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6473
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6476
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =6473
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6473
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6473
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` =6473
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` =6474
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` =6475
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` =6476
and C.field_type = "C"
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` = "6441"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6441"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6441"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6441"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6441
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`
WHERE pc.`virtuemart_product_id` = 6441
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6441"
and `virtuemart_category_id`= "97"
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` =6441
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "6441" OR `virtuemart_product_id` = "6441")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6441
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6441
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6442
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6441
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6442
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6443
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6441
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6443
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6444
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6441
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6444
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =6441
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6441
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6441
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` =6441
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` =6442
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` =6443
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` =6444
and C.field_type = "C"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16336"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16599"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16356"
SELECT id
FROM Dv2vH_assets
WHERE parent_id = 0
SELECT p.`virtuemart_product_id`
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` > 0
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
group by p.`virtuemart_product_id`
ORDER BY p.`created_on` DESC
LIMIT 0, 9
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` = "6495"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6495"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6495"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6495"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6495
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`
WHERE pc.`virtuemart_product_id` = 6495
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6495"
and `virtuemart_category_id`= "105"
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` = "105"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 105
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 100
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 105
SELECT `slug` as name
FROM `Dv2vH_virtuemart_categories_nl_nl`
WHERE `virtuemart_category_id`=105
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6495
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` = "6494"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6494"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6494"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6494"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6494
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`
WHERE pc.`virtuemart_product_id` = 6494
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6494"
and `virtuemart_category_id`= "97"
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` =6494
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "6494" OR `virtuemart_product_id` = "6494")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6494
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5497
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6494
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =6494
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6494
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6494
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` =6494
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` = "5497"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "5497"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "5497"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "5497"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 5497
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`
WHERE pc.`virtuemart_product_id` = 5497
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "5497"
and `virtuemart_category_id`= "97"
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` =5497
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "5497" OR `virtuemart_product_id` = "5497")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6494
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5497
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6448
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 5497
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6448
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =5497
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =5497
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =5497
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` =5497
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` =5498
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` =6447
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` =6448
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` =6494
and C.field_type = "C"
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` = "6493"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6493"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6493"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6493"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6493
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`
WHERE pc.`virtuemart_product_id` = 6493
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6493"
and `virtuemart_category_id`= "100"
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` = "100"
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6493
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` = "6492"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6492"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6492"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6492"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6492
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`
WHERE pc.`virtuemart_product_id` = 6492
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6492"
and `virtuemart_category_id`= "67"
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` = "67"
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` =6492
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
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`
Where `virtuemart_product_id` =6492
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6492
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6492
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 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` =6492
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` =6492
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=11
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6492
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` =6492
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` =6492
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` = "6490"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6490"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6490"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6490"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6490
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`
WHERE pc.`virtuemart_product_id` = 6490
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6490"
and `virtuemart_category_id`= "18"
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` = "18"
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` =6490
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "6490" OR `virtuemart_product_id` = "6490")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6490
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6490
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6491
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6490
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6491
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6492
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6490
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6492
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =6490
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6490
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6490
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` =6490
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` =6491
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` =6492
and C.field_type = "C"
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` = "6491"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6491"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6491"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6491"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6491
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`
WHERE pc.`virtuemart_product_id` = 6491
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6491"
and `virtuemart_category_id`= "67"
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` =6491
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
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`
Where `virtuemart_product_id` =6491
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6491
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6491
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 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` =6491
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` =6491
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=11
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6491
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` =6491
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` =6491
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` = "6489"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6489"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6489"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6489"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6489
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`
WHERE pc.`virtuemart_product_id` = 6489
AND `published`=1
ORDER BY `c`.`ordering` ASC
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` =6489
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
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`
Where `virtuemart_product_id` =6489
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6489
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6489
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 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` =6489
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` =6489
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=11
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6489
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` =6489
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` =6489
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` = "2005"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "2005"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "2005"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "2005"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 2005
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`
WHERE pc.`virtuemart_product_id` = 2005
AND `published`=1
ORDER BY `c`.`ordering` ASC
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` =2005
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "2005" OR `virtuemart_product_id` = "2005")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 2005
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 2005
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6489
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 2005
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 8
SELECT `slug` as name
FROM `Dv2vH_virtuemart_categories_nl_nl`
WHERE `virtuemart_category_id`=8
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6489
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 2007
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 2005
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 2007
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 2006
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 2005
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 2006
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =2005
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =2005
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =2005
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` =2005
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` =2006
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` =2007
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` =6489
and C.field_type = "C"
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6489
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 2005
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` = "6488"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6488"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6488"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6488"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6488
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`
WHERE pc.`virtuemart_product_id` = 6488
AND `published`=1
ORDER BY `c`.`ordering` ASC
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` =6488
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
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`
Where `virtuemart_product_id` =6488
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6488
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6488
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 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` =6488
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` =6488
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=11
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6488
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` =6488
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` =6488
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` = "6486"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6486"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6486"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6486"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6486
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`
WHERE pc.`virtuemart_product_id` = 6486
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6486"
and `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` =6486
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "6486" OR `virtuemart_product_id` = "6486")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6486
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6486
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6487
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6486
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6487
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6488
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6486
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6488
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =6486
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6486
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6486
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` =6486
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` =6487
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` =6488
and C.field_type = "C"
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` = "6487"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6487"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6487"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6487"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6487
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`
WHERE pc.`virtuemart_product_id` = 6487
AND `published`=1
ORDER BY `c`.`ordering` ASC
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` =6487
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
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`
Where `virtuemart_product_id` =6487
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6487
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6487
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 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` =6487
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` =6487
and is_cart_attribute = 1
and C.`virtuemart_custom_id`=11
ORDER BY field.`ordering`
SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`,
field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6487
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` =6487
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` =6487
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16738"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16733"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16732"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16731"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16730"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16728"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16703"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16699"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16698"
SELECT id
FROM Dv2vH_assets
WHERE parent_id = 0
SELECT id
FROM Dv2vH_assets
WHERE parent_id = 0
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 10:32:23')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-29 10:32:23')
AND m.access IN (1,1,2)
AND m.client_id = 0
AND (mm.menuid = 190 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16598"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16359"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16579"
SELECT `Dv2vH_virtuemart_product_prices`.virtuemart_product_id as id
FROM `Dv2vH_virtuemart_product_prices`
INNER JOIN `Dv2vH_virtuemart_calcs`
ON `Dv2vH_virtuemart_product_prices`.product_discount_id=`Dv2vH_virtuemart_calcs`.virtuemart_calc_id
INNER JOIN `Dv2vH_virtuemart_products`
ON `Dv2vH_virtuemart_product_prices`.virtuemart_product_id=`Dv2vH_virtuemart_products`.virtuemart_product_id
WHERE `Dv2vH_virtuemart_product_prices`.`product_discount_id` != 0
AND `Dv2vH_virtuemart_products`.published="1"
LIMIT 0, 3
SELECT virtuemart_product_id as id
FROM `Dv2vH_virtuemart_products`
WHERE published="1"
AND DATE(created_on) >= DATE_SUB(CURDATE(), INTERVAL 0 DAY)
ORDER BY created_on DESC
LIMIT 0, 3
SELECT id
FROM Dv2vH_assets
WHERE parent_id = 0
SELECT p.`virtuemart_product_id`
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`
LEFT JOIN `Dv2vH_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
WHERE ( p.`published`="1"
AND `pc`.`virtuemart_category_id` > 0
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND pp.`product_price`>"0.0" )
group by p.`virtuemart_product_id`
ORDER BY p.`product_sales` DESC
LIMIT 0, 3
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` = "6314"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6314"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6314"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6314"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6314
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`
WHERE pc.`virtuemart_product_id` = 6314
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6314"
and `virtuemart_category_id`= "13"
SELECT `Dv2vH_virtuemart_categories`.* ,`Dv2vH_virtuemart_categories_nl_nl`.*
FROM `Dv2vH_virtuemart_categories`
INNER JOIN `Dv2vH_virtuemart_categories_nl_nl` using (`virtuemart_category_id`)
WHERE `Dv2vH_virtuemart_categories`.`virtuemart_category_id` = "13"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6314
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "6314" OR `virtuemart_product_id` = "6314")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6314
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6314
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6316
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6314
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6316
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6318
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6314
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6318
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6484
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6314
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6484
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =6314
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6314
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6314
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` =6314
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` =6316
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` =6484
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` =6318
and C.field_type = "C"
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` = "6052"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6052"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6052"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6052"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6052
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`
WHERE pc.`virtuemart_product_id` = 6052
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "6052"
and `virtuemart_category_id`= "13"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `Dv2vH_virtuemart_customs` AS C
LEFT JOIN `Dv2vH_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =6052
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "6052" OR `virtuemart_product_id` = "6052")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6052
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6052
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6053
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6052
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6053
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6054
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6052
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6054
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6323
SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 6052
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6323
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =6052
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6052
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6052
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` =6052
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` =6053
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` =6054
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` =6323
and C.field_type = "C"
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` = "6312"
SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "6312"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "6312"
SELECT *
FROM `Dv2vH_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "6312"
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-29 10:32:23" )
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-29 10:32:23" ) )
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` = 6312
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`
WHERE pc.`virtuemart_product_id` = 6312
AND `published`=1
ORDER BY `c`.`ordering` ASC
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` =6312
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT *
FROM `Dv2vH_virtuemart_products` as p
LEFT JOIN `Dv2vH_virtuemart_products_nl_nl` as pl
USING (`virtuemart_product_id`)
LEFT JOIN `Dv2vH_virtuemart_product_categories` as pc
USING (`virtuemart_product_id`)
WHERE (`product_parent_id` = "6312" OR `virtuemart_product_id` = "6312")
AND p.`published`="1"
GROUP BY `virtuemart_product_id`
ORDER BY p.pordering ASC
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6312
SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 6312
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 0
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`
Where `virtuemart_product_id` =6312
and `field_type` = "Z"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6312
and `field_type` = "R"
and is_cart_attribute = 0
order by ordering
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`
Where `virtuemart_product_id` =6312
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` =6312
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6312
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16706"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16705"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16709"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16710"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16713"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16714"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16157"
SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
WHERE `virtuemart_product_id` = 6312
SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM Dv2vH_banners
WHERE '2024-03-29 10:32:23' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM Dv2vH_banners as a
LEFT JOIN Dv2vH_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
ORDER BY a.sticky DESC,a.ordering
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM Dv2vH_banners as a
LEFT JOIN Dv2vH_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 4
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_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(
SELECT MAX(contact.id) AS id
FROM Dv2vH_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM Dv2vH_content AS a
LEFT JOIN Dv2vH_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN Dv2vH_categories AS c
ON c.id = a.catid
LEFT JOIN Dv2vH_users AS ua
ON ua.id = a.created_by
LEFT JOIN Dv2vH_users AS uam
ON uam.id = a.modified_by
LEFT JOIN Dv2vH_categories as parent
ON parent.id = c.parent_id
LEFT JOIN Dv2vH_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM Dv2vH_categories AS cat JOIN Dv2vH_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,2)
AND c.access IN (1,1,2)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.featured = 0
AND a.catid IN (15)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-29 10:32:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-29 10:32:23')
ORDER BY a.created DESC
LIMIT 0, 4
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM Dv2vH_categories as c
LEFT JOIN Dv2vH_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM Dv2vH_categories AS cat JOIN Dv2vH_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,2)
AND c.published = 1
AND s.id=15
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT `m`.*,`Dv2vH_virtuemart_manufacturers_nl_nl`.*, mc.`mf_category_name` ,mmex.virtuemart_media_id
FROM `Dv2vH_virtuemart_manufacturers_nl_nl` JOIN `Dv2vH_virtuemart_manufacturers` as m USING (`virtuemart_manufacturer_id`)
LEFT JOIN `Dv2vH_virtuemart_manufacturercategories_nl_nl` AS mc
on mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id`
LEFT JOIN `Dv2vH_virtuemart_manufacturer_medias` as mmex
ON `m`.`virtuemart_manufacturer_id`= mmex.`virtuemart_manufacturer_id`
WHERE `m`.`published` = 1
GROUP BY `m`.`virtuemart_manufacturer_id`
ORDER BY mf_name ASC
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16446"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "13437"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "13432"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "16447"
SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
WHERE `Dv2vH_virtuemart_medias`.`virtuemart_media_id` = "13461"
SELECT `slug`
FROM `Dv2vH_virtuemart_manufacturers_nl_nl`
WHERE virtuemart_manufacturer_id=18
SELECT `slug`
FROM `Dv2vH_virtuemart_manufacturers_nl_nl`
WHERE virtuemart_manufacturer_id=10
SELECT `slug`
FROM `Dv2vH_virtuemart_manufacturers_nl_nl`
WHERE virtuemart_manufacturer_id=15
SELECT `slug`
FROM `Dv2vH_virtuemart_manufacturers_nl_nl`
WHERE virtuemart_manufacturer_id=19
SELECT `slug`
FROM `Dv2vH_virtuemart_manufacturers_nl_nl`
WHERE virtuemart_manufacturer_id=14
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-29 10:32:23" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-29 10:32:23" )
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 10:32:23" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-29 10:32:23" )
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 10:32:23" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-03-29 10:32:23" )
UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711708343;s:18:\"session.timer.last\";i:1711708343;s:17:\"session.timer.now\";i:1711708343;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":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: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:\"\";}\";}'
, `time` = '1711708344'
WHERE `session_id` = '2c19235c8abdca1817ef0665a7901055'
50 × SELECT `product_parent_id`
FROM `Dv2vH_virtuemart_products`
37 × SELECT `slug`
FROM `Dv2vH_virtuemart_products_nl_nl`
34 × 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`
33 × SELECT `Dv2vH_virtuemart_medias`.*
FROM `Dv2vH_virtuemart_medias`
29 × 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`
28 × SELECT `virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories`
24 × 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`
19 × SELECT pc.`virtuemart_category_id`
FROM `Dv2vH_virtuemart_product_categories` as pc
19 × SELECT *
FROM `Dv2vH_virtuemart_product_prices`
19 × 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`
19 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_product_medias`
19 × SELECT `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_product_shoppergroups`
19 × 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`
17 × 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`
17 × SELECT virtuemart_product_id, product_name
FROM `Dv2vH_virtuemart_products_nl_nl` JOIN `Dv2vH_virtuemart_products` as C using (`virtuemart_product_id`)
17 × 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`
14 × SELECT `ordering`,`id`
FROM `Dv2vH_virtuemart_product_categories`
11 × 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`)
8 × SELECT `Dv2vH_virtuemart_categories`.* ,`Dv2vH_virtuemart_categories_nl_nl`.*
FROM `Dv2vH_virtuemart_categories`
INNER JOIN `Dv2vH_virtuemart_categories_nl_nl` using (`virtuemart_category_id`)
7 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_category_medias`
5 × SELECT id
FROM Dv2vH_assets
5 × SELECT `slug`
FROM `Dv2vH_virtuemart_manufacturers_nl_nl`
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM Dv2vH_extensions
4 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM Dv2vH_virtuemart_category_categories AS `xref`
4 × SELECT *
FROM Dv2vH_virtuemart_calcs
3 × 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 a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM Dv2vH_banners as a
LEFT JOIN Dv2vH_banner_clients AS cl
ON cl.id = a.cid
2 × SELECT *
FROM `Dv2vH_virtuemart_shoppergroups`
2 × SELECT `slug` as name
FROM `Dv2vH_virtuemart_categories_nl_nl`
2 × SELECT `Dv2vH_virtuemart_manufacturers`.* ,`Dv2vH_virtuemart_manufacturers_nl_nl`.*
FROM `Dv2vH_virtuemart_manufacturers`
INNER JOIN `Dv2vH_virtuemart_manufacturers_nl_nl` using (`virtuemart_manufacturer_id`)
2 × SELECT p.`virtuemart_product_id`
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`
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 `virtuemart_country_id`
FROM Dv2vH_virtuemart_calc_countries
1 × SELECT `virtuemart_shoppergroup_id`
FROM Dv2vH_virtuemart_calc_shoppergroups
1 × SELECT `virtuemart_state_id`
FROM Dv2vH_virtuemart_calc_states
1 × SELECT `virtuemart_manufacturer_id`
FROM Dv2vH_virtuemart_calc_manufacturers
1 × SELECT *
FROM Dv2vH_banners
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM Dv2vH_categories as c
LEFT JOIN Dv2vH_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM Dv2vH_categories AS cat JOIN Dv2vH_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT `m`.*,`Dv2vH_virtuemart_manufacturers_nl_nl`.*, mc.`mf_category_name` ,mmex.virtuemart_media_id
FROM `Dv2vH_virtuemart_manufacturers_nl_nl` JOIN `Dv2vH_virtuemart_manufacturers` as m USING (`virtuemart_manufacturer_id`)
LEFT JOIN `Dv2vH_virtuemart_manufacturercategories_nl_nl` AS mc
on mc.`virtuemart_manufacturercategories_id`= `m`.`virtuemart_manufacturercategories_id`
LEFT JOIN `Dv2vH_virtuemart_manufacturer_medias` as mmex
ON `m`.`virtuemart_manufacturer_id`= mmex.`virtuemart_manufacturer_id`
1 × SELECT *
FROM Dv2vH_modules
1 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
FROM Dv2vH_contact_details AS contact
1 × SELECT `virtuemart_category_id`
FROM Dv2vH_virtuemart_calc_categories
1 × SELECT virtuemart_product_id as id
FROM `Dv2vH_virtuemart_products`
1 × SELECT p.`virtuemart_product_id`
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`
LEFT JOIN `Dv2vH_virtuemart_product_prices` as pp
ON p.`virtuemart_product_id` = pp.`virtuemart_product_id`
1 × SELECT `Dv2vH_virtuemart_product_prices`.virtuemart_product_id as id
FROM `Dv2vH_virtuemart_product_prices`
INNER JOIN `Dv2vH_virtuemart_calcs`
ON `Dv2vH_virtuemart_product_prices`.product_discount_id=`Dv2vH_virtuemart_calcs`.virtuemart_calc_id
INNER JOIN `Dv2vH_virtuemart_products`
ON `Dv2vH_virtuemart_product_prices`.virtuemart_product_id=`Dv2vH_virtuemart_products`.virtuemart_product_id
1 × SELECT *
FROM `Dv2vH_menu`
1 × SELECT `virtuemart_media_id`
FROM `Dv2vH_virtuemart_vendor_medias`
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 `data`
FROM `Dv2vH_session`
1 × SELECT L.*
FROM `Dv2vH_virtuemart_categories_nl_nl` as L JOIN `Dv2vH_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `Dv2vH_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
1 × SELECT `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 `virtuemart_shoppergroup_id`
FROM `Dv2vH_virtuemart_vmuser_shoppergroups`
1 × SELECT *
FROM `Dv2vH_virtuemart_currencies`
1 × SELECT `config`
FROM `Dv2vH_virtuemart_configs`
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 a.rules
FROM Dv2vH_assets AS a
1 × SELECT id, rules
FROM `Dv2vH_viewlevels
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 `price_display`,`custom_price_display`
FROM `Dv2vH_virtuemart_shoppergroups` AS `sg`
1 × SELECT folder AS type, element AS name, params
FROM Dv2vH_extensions
1 × SELECT *
FROM Dv2vH_languages
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 `session_id`
FROM `Dv2vH_session`
1 × UPDATE `Dv2vH_session`
SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711708343;s:18:\"session.timer.last\";i:1711708343;s:17:\"session.timer.now\";i:1711708343;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":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: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:\"\";}\";}' , `time` = '1711708344'
1 × SHOW FULL COLUMNS
FROM `Dv2vH_assets
1 × SHOW TABLES LIKE "Dv2vH_virtuemart_configs
1 × INSERT INTO `Dv2vH_session` (`session_id`, `client_id`, `time`)
VALUES ('2c19235c8abdca1817ef0665a7901055', 0, '1711708343'
1 × DELETE
FROM `Dv2vH_session`