Op deze CD van Frank Mettes staat de complete muziek die speciaal is gecomponeerd voor de MIR-Methode. Gedeeltes van de tracks vind je ook op de MIR-Methode instructie CD, dus sommige muziekstukken zijn een feest van herkenning. Muziek en productie: Frank Mettes, Uno Records.
Op de foto reikt Frank Mettes het 1e exemplaar van de CD Muziek voor de MIR-Methode uit aan zijn zus Mireille Mettes. Inhoud MIR-Methode Muziek CD: 1. Welkom bij de MIR-Methode. 2. Waarom de MIR-Methode? 3. Wat is de MIR-Methode? 4. Hoe doe je de MIR-Methode? 5. Wat kan je met de MIR-Methode? 6. Waarom je hand aaien? 7. Stap 1. Zuurgraad optimaliseren. 8. Stap 2. Detox alle toxische belasting. 9. Stap 3. Vader loskoppelen. Moeder loskoppelen. 10. Stap 4. Meridianen zuiveren. 11. Stap 5. Alle tekorten aanvullen. 12. Stap 6. Hormoonstelsel in evenwicht brengen. 13. Stap 7. Basisbehoeften aanvullen. 14. Stap 8. Chakra’s en aura optimaliseren. 15. Stap 9. Missie verduidelijken. Totale speelduur 46:11 .session.client.browser ⇒ Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
password_clear ⇒
groups ⇒
gantry-current-template ⇒ rt_acacia
session.token ⇒ 1386402b2de82424749f4d689a90be08
vmcart ⇒ O:8:"stdClass":24:{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:2:"BT";i:0;s:2:"ST";i:0;s:11:"tosAccepted";N;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: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_";}
Application 0.003 seconds (+0.003); 0.33 MB (+0.332) - afterLoad
Application 0.472 seconds (+0.470); 2.54 MB (+2.205) - afterInitialise
Application 0.494 seconds (+0.021); 3.34 MB (+0.801) - afterRoute
Application 0.653 seconds (+0.159); 6.24 MB (+2.899) - afterDispatch
Application 0.741 seconds (+0.088); 8.11 MB (+1.870) - beforeRenderModule mod_roknavmenu ()
Application 0.763 seconds (+0.022); 8.41 MB (+0.308) - afterRenderModule mod_roknavmenu ()
Application 0.771 seconds (+0.008); 8.46 MB (+0.043) - beforeRenderModule mod_custom (Copyright)
Application 0.773 seconds (+0.002); 8.47 MB (+0.007) - afterRenderModule mod_custom (Copyright)
Application 0.773 seconds (+0.000); 8.46 MB (-0.002) - beforeRenderModule mod_login (Footer login)
Application 0.780 seconds (+0.007); 8.51 MB (+0.047) - afterRenderModule mod_login (Footer login)
Application 0.780 seconds (+0.000); 8.48 MB (-0.028) - beforeRenderModule mod_custom (Demo info)
Application 0.780 seconds (+0.000); 8.49 MB (+0.004) - afterRenderModule mod_custom (Demo info)
Application 0.780 seconds (+0.000); 8.49 MB (-0.001) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.786 seconds (+0.006); 8.53 MB (+0.040) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.786 seconds (+0.000); 8.50 MB (-0.028) - beforeRenderModule mod_rokajaxsearch (Search)
Application 0.789 seconds (+0.003); 8.52 MB (+0.019) - afterRenderModule mod_rokajaxsearch (Search)
Application 0.796 seconds (+0.007); 8.62 MB (+0.100) - afterRender
7.32 MB (7,675,408 Bytes)
SELECT `data`
FROM `ekfi_session`
WHERE `session_id` = '2g95s7hh0085q1jcqm2hhbic62'
SELECT `session_id`
FROM `ekfi_session`
WHERE `session_id` = '2g95s7hh0085q1jcqm2hhbic62'
LIMIT 0, 1
INSERT INTO `ekfi_session`
(`session_id`, `client_id`, `time`)
VALUES
('2g95s7hh0085q1jcqm2hhbic62', 0, '1714311638')
SELECT extension_id AS id, element AS "option", params, enabled
FROM ekfi_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM ekfi_usergroups AS a
LEFT JOIN ekfi_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `ekfi_viewlevels`
SELECT folder AS type, element AS name, params
FROM ekfi_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM ekfi_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT `value`
FROM `ekfi_admintools_storage`
WHERE `key` = 'cparams'
SELECT `query`
FROM `ekfi_admintools_wafexceptions`
WHERE (`option` IS NULL OR `option` = '')
AND (`view` IS NULL OR `view` = '')
GROUP BY `query`
ORDER BY `query` ASC
SELECT template
FROM ekfi_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
SELECT template
FROM ekfi_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
SELECT extension, file, type
FROM ekfi_rokcommon_configs
ORDER BY priority
SELECT *
FROM `ekfi_admintools_ipautoban`
WHERE `ip` = '18.117.158.47'
SELECT `value`
FROM `ekfi_admintools_storage`
WHERE `key` = 'cparams'
SELECT `source`,`keepurlparams`
FROM `ekfi_admintools_redirects`
WHERE (`dest` = 'shop/cd-muziek/cd-detail') OR (`dest` = 'shop/cd-muziek/cd-detail')
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 0, 1
SHOW FULL COLUMNS
FROM `ekfi_extensions`
SELECT `extension_id`
FROM `ekfi_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
SELECT *
FROM ekfi_extensions
WHERE `extension_id` = '10058'
SELECT `extension_id`
FROM `ekfi_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
SELECT *
FROM ekfi_extensions
WHERE `extension_id` = '10058'
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 ekfi_menu AS m
LEFT JOIN ekfi_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SHOW TABLES LIKE "ekfi_virtuemart_configs"
SELECT `config`
FROM `ekfi_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `ekfi_virtuemart_permgroups`
ORDER BY `group_level`
SELECT extension_id AS id, element AS "option", params, enabled
FROM ekfi_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT *
FROM `ekfi_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "nl-NL" )
SELECT `virtuemart_category_id`
FROM `ekfi_virtuemart_categories_nl_nl`
WHERE `slug` LIKE 'cd-muziek'
SELECT `p`.`virtuemart_product_id`
FROM `ekfi_virtuemart_products_nl_nl` AS `p`
LEFT JOIN `ekfi_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`
WHERE `p`.`slug` LIKE "cd"
SELECT extension_id AS id, element AS "option", params, enabled
FROM ekfi_extensions
WHERE `type` = 'component'
AND `element` = 'com_rokcandy'
SELECT *
FROM ekfi_rokcandy
WHERE published=1
SELECT id, home, template, s.params
FROM ekfi_template_styles as s
LEFT JOIN ekfi_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT *
FROM ekfi_languages
WHERE published=1
ORDER BY ordering ASC
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_vmuser_shoppergroups`
WHERE `virtuemart_user_id` = "0"
SELECT *
FROM `ekfi_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "1"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "1"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "1"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "1"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_manufacturers_nl_nl`.* ,`ekfi_virtuemart_manufacturers`.*
FROM `ekfi_virtuemart_manufacturers_nl_nl` JOIN ekfi_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE ekfi_virtuemart_manufacturers_nl_nl.`virtuemart_manufacturer_id` = "2"
SELECT pc.`virtuemart_category_id`
FROM `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 1
SELECT pc.`virtuemart_category_id`
FROM `ekfi_virtuemart_product_categories` as pc
LEFT JOIN `ekfi_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 1
AND `published`=1
ORDER BY `c`.`ordering` ASC
SELECT `ordering`,`id`
FROM `ekfi_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "1"
and `virtuemart_category_id`= "4"
SELECT `ekfi_virtuemart_categories_nl_nl`.* ,`ekfi_virtuemart_categories`.*
FROM `ekfi_virtuemart_categories_nl_nl` JOIN ekfi_virtuemart_categories using (`virtuemart_category_id`)
WHERE ekfi_virtuemart_categories_nl_nl.`virtuemart_category_id` = "4"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =1
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=1
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "3"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =1
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =1
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =1
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =1
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =27
and C.field_type = "C"
SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `ekfi_virtuemart_vendors` AS v
LEFT JOIN `ekfi_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"
SELECT *
FROM `ekfi_virtuemart_currencies`
WHERE `virtuemart_currency_id`="47"
SELECT `price_display`,`custom_price_display`
FROM `ekfi_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =28
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =29
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =30
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =31
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =32
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =33
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =34
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =35
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =36
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =37
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =38
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =39
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =40
and C.field_type = "C"
SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` =41
and C.field_type = "C"
SELECT *
FROM `ekfi_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT *
FROM ekfi_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-04-28 13:40:39" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-04-28 13:40:39" )
OR `for_override` = "1" )
SELECT `virtuemart_category_id`
FROM ekfi_virtuemart_calc_categories
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_shoppergroup_id`
FROM ekfi_virtuemart_calc_shoppergroups
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_country_id`
FROM ekfi_virtuemart_calc_countries
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_state_id`
FROM ekfi_virtuemart_calc_states
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_manufacturer_id`
FROM ekfi_virtuemart_calc_manufacturers
WHERE `virtuemart_calc_id`="1"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM ekfi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 4
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM ekfi_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 4
SELECT `slug` as name
FROM `ekfi_virtuemart_categories_nl_nl`
WHERE `virtuemart_category_id`=4
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 1
SELECT virtuemart_product_id
FROM `ekfi_virtuemart_products`
WHERE `product_parent_id` =1
ORDER BY pordering ASC
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "27"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "27"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "27"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "27"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 27
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =27
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=27
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "25"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =27
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =27
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =27
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =27
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 27
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "40"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "40"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "40"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "40"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 40
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =40
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=40
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "26"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =40
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =40
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =40
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =40
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 40
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "39"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "39"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "39"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "39"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 39
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =39
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=39
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "27"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =39
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =39
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =39
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =39
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 39
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "38"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "38"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "38"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "38"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 38
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =38
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=38
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "28"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =38
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =38
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =38
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =38
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 38
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "37"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "37"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "37"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "37"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 37
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =37
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=37
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "29"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =37
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =37
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =37
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =37
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 37
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "36"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "36"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "36"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "36"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 36
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =36
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=36
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "30"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =36
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =36
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =36
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =36
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 36
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "35"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "35"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "35"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "35"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 35
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =35
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=35
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "31"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =35
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =35
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =35
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =35
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 35
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "34"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "34"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "34"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "34"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 34
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =34
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=34
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "32"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =34
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =34
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =34
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =34
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 34
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "33"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "33"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "33"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "33"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 33
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =33
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=33
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "33"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =33
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =33
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =33
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =33
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 33
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "32"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "32"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "32"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "32"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 32
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =32
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=32
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "38"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =32
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =32
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =32
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =32
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 32
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "31"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "31"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "31"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "31"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 31
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =31
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=31
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "39"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =31
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =31
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =31
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =31
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 31
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "30"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "30"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "30"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "30"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 30
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =30
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=30
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =30
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =30
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =30
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =30
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 30
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "29"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "29"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "29"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "29"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 29
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =29
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=29
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "35"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =29
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =29
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =29
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =29
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 29
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "28"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "28"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "28"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "28"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =28
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=28
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "36"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =28
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =28
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =28
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =28
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 28
SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
WHERE ekfi_virtuemart_products_nl_nl.`virtuemart_product_id` = "41"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "41"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "41"
SELECT *
FROM `ekfi_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "41"
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-04-28 13:40:39" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-04-28 13:40:39" ) )
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 `ekfi_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 41
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =41
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 `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id`=41
and `virtuemart_custom_id`=3
SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE ekfi_virtuemart_product_custom_plg_music_player.`id` = "37"
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =41
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =41
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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =41
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 `ekfi_virtuemart_products_nl_nl`
JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =41
SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
WHERE `virtuemart_product_id` = 41
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '27'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '40'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '39'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '38'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '37'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '36'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '35'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '34'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '33'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '32'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '31'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '30'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '29'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '28'
SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
WHERE `virtuemart_product_id` = '41'
SELECT `ekfi_virtuemart_medias`.*
FROM `ekfi_virtuemart_medias`
WHERE ekfi_virtuemart_medias.`virtuemart_media_id` = "4"
SELECT `ekfi_virtuemart_categories_nl_nl`.* ,`ekfi_virtuemart_categories`.*
FROM `ekfi_virtuemart_categories_nl_nl` JOIN ekfi_virtuemart_categories using (`virtuemart_category_id`)
WHERE ekfi_virtuemart_categories_nl_nl.`virtuemart_category_id` = "4"
SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "4"
ORDER BY `ordering`
SELECT `category_child_id`
FROM `ekfi_virtuemart_category_categories`
WHERE `category_parent_id` = 4
SELECT count(ekfi_virtuemart_products.virtuemart_product_id) AS total
FROM `ekfi_virtuemart_products`, `ekfi_virtuemart_product_categories`
WHERE `ekfi_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `ekfi_virtuemart_product_categories`.`virtuemart_category_id` = 4
AND `ekfi_virtuemart_products`.`virtuemart_product_id` = `ekfi_virtuemart_product_categories`.`virtuemart_product_id`
AND `ekfi_virtuemart_products`.`published` = "1"
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `ekfi_virtuemart_category_categories` AS `xref`
WHERE `xref`.`category_child_id`= 4
SELECT `category_name`,`virtuemart_category_id`
FROM `ekfi_virtuemart_categories_nl_nl`
WHERE `virtuemart_category_id`=4
SELECT L.*
FROM `ekfi_virtuemart_categories_nl_nl` as L
JOIN `ekfi_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `ekfi_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 4
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY category_name ASC
SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `ekfi_virtuemart_paymentmethods_nl_nl` as l JOIN `ekfi_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `ekfi_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `ekfi_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
WHERE v.`published` = "1"
AND j.`element` = "paypal"
AND (v.`virtuemart_vendor_id` = "1" OR v.`virtuemart_vendor_id` = "0")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY v.`virtuemart_paymentmethod_id`
ORDER BY v.`ordering`
SELECT id, home, template, s.params
FROM ekfi_template_styles as s
LEFT JOIN ekfi_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT id, home, template, s.params
FROM ekfi_template_styles as s
LEFT JOIN ekfi_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ekfi_modules AS m
LEFT JOIN ekfi_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ekfi_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-04-28 13:40:39')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-28 13:40:39')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 111 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT ts.template
FROM ekfi_template_styles AS ts
INNER JOIN ekfi_menu AS m
ON ts.id=m.template_style_id
WHERE m.id = 111
AND m.template_style_id != 0
SELECT extension_id AS id, element AS "option", params, enabled
FROM ekfi_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT `virtuemart_category_id`
FROM `ekfi_virtuemart_categories_nl_nl`
WHERE `slug` LIKE 'cd-muziek'
SELECT `p`.`virtuemart_product_id`
FROM `ekfi_virtuemart_products_nl_nl` AS `p`
LEFT JOIN `ekfi_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`
WHERE `p`.`slug` LIKE "cd"
SHOW FULL COLUMNS
FROM `ekfi_template_styles`
SELECT *
FROM ekfi_template_styles
WHERE `id` = '8'
UPDATE `ekfi_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714311638;s:18:\"session.timer.last\";i:1714311638;s:17:\"session.timer.now\";i:1714311638;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:10:\"com_search\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:0;}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;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\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:23:\"gantry-current-template\";s:9:\"rt_acacia\";s:13:\"session.token\";s:32:\"1386402b2de82424749f4d689a90be08\";}__vm|a:3:{s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{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:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;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: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:23:\"vmlastvisitedcategoryid\";i:4;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:1;}}'
, `time` = '1714311639'
WHERE `session_id` = '2g95s7hh0085q1jcqm2hhbic62'
32 × 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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
16 × SELECT *
FROM `ekfi_virtuemart_product_prices`
16 × SELECT pc.`virtuemart_category_id`
FROM `ekfi_virtuemart_product_categories` as pc
16 × SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_product_shoppergroups`
16 × SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_product_medias`
16 × SELECT `slug`
FROM `ekfi_virtuemart_products_nl_nl`
16 × SELECT `ekfi_virtuemart_products_nl_nl`.* ,`ekfi_virtuemart_products`.* ,`ekfi_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`ekfi_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `ekfi_virtuemart_products_nl_nl` JOIN ekfi_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `ekfi_virtuemart_product_manufacturers`
on `ekfi_virtuemart_product_manufacturers`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
LEFT JOIN `ekfi_virtuemart_product_customfields`
on `ekfi_virtuemart_product_customfields`.`virtuemart_product_id`=`ekfi_virtuemart_products_nl_nl`.`virtuemart_product_id`
16 × 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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
16 × SELECT `id`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
16 × SELECT virtuemart_product_id, product_name
FROM `ekfi_virtuemart_products_nl_nl` JOIN `ekfi_virtuemart_products` as C using (`virtuemart_product_id`)
16 × 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 `ekfi_virtuemart_customs` AS C
LEFT JOIN `ekfi_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
16 × SELECT `ekfi_virtuemart_product_custom_plg_music_player`.*
FROM `ekfi_virtuemart_product_custom_plg_music_player`
15 × SELECT `pathname`,`filename`,`name`
FROM `ekfi_virtuemart_product_custom_plg_music_player`
15 × SELECT C.* , field.*
FROM `ekfi_virtuemart_product_customfields` AS field
LEFT JOIN `ekfi_virtuemart_customs` AS C
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM ekfi_extensions
3 × SELECT id, home, template, s.params
FROM ekfi_template_styles as s
LEFT JOIN ekfi_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
2 × SELECT `extension_id`
FROM `ekfi_extensions`
2 × SELECT *
FROM ekfi_extensions
2 × SELECT `ekfi_virtuemart_categories_nl_nl`.* ,`ekfi_virtuemart_categories`.*
FROM `ekfi_virtuemart_categories_nl_nl` JOIN ekfi_virtuemart_categories using (`virtuemart_category_id`)
2 × SELECT template
FROM ekfi_template_styles as s
2 × SELECT `value`
FROM `ekfi_admintools_storage`
2 × SELECT *
FROM `ekfi_virtuemart_shoppergroups`
2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM ekfi_virtuemart_category_categories AS `xref`
2 × SELECT `virtuemart_category_id`
FROM `ekfi_virtuemart_categories_nl_nl`
2 × SELECT `p`.`virtuemart_product_id`
FROM `ekfi_virtuemart_products_nl_nl` AS `p`
LEFT JOIN `ekfi_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ekfi_modules AS m
LEFT JOIN ekfi_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ekfi_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `ekfi_virtuemart_paymentmethods_nl_nl` as l JOIN `ekfi_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `ekfi_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `ekfi_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
1 × SELECT `virtuemart_media_id`
FROM `ekfi_virtuemart_category_medias`
1 × SELECT ts.template
FROM ekfi_template_styles AS ts
INNER JOIN ekfi_menu AS m
ON ts.id=m.template_style_id
1 × SELECT *
FROM ekfi_template_styles
1 × SELECT `virtuemart_category_id`
FROM ekfi_virtuemart_calc_categories
1 × SELECT `virtuemart_shoppergroup_id`
FROM ekfi_virtuemart_calc_shoppergroups
1 × SELECT `virtuemart_country_id`
FROM ekfi_virtuemart_calc_countries
1 × SELECT L.*
FROM `ekfi_virtuemart_categories_nl_nl` as L
JOIN `ekfi_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `ekfi_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
1 × SELECT `category_child_id`
FROM `ekfi_virtuemart_category_categories`
1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `ekfi_virtuemart_category_categories` AS `xref`
1 × SELECT count(ekfi_virtuemart_products.virtuemart_product_id) AS total
FROM `ekfi_virtuemart_products`, `ekfi_virtuemart_product_categories`
1 × SELECT virtuemart_product_id
FROM `ekfi_virtuemart_products`
1 × SELECT `ekfi_virtuemart_medias`.*
FROM `ekfi_virtuemart_medias`
1 × SELECT `category_name`,`virtuemart_category_id`
FROM `ekfi_virtuemart_categories_nl_nl`
1 × SELECT `slug` as name
FROM `ekfi_virtuemart_categories_nl_nl`
1 × SELECT `virtuemart_state_id`
FROM ekfi_virtuemart_calc_states
1 × SELECT `virtuemart_manufacturer_id`
FROM ekfi_virtuemart_calc_manufacturers
1 × SELECT *
FROM ekfi_virtuemart_calcs
1 × SELECT `ordering`,`id`
FROM `ekfi_virtuemart_product_categories`
1 × SELECT extension, file, type
FROM ekfi_rokcommon_configs
1 × SELECT *
FROM `ekfi_admintools_ipautoban`
1 × SELECT `source`,`keepurlparams`
FROM `ekfi_admintools_redirects`
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 ekfi_menu AS m
LEFT JOIN ekfi_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `query`
FROM `ekfi_admintools_wafexceptions`
1 × SELECT folder AS type, element AS name, params
FROM ekfi_extensions
1 × SELECT `session_id`
FROM `ekfi_session`
1 × SELECT b.id
FROM ekfi_usergroups AS a
LEFT JOIN ekfi_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `ekfi_viewlevels
1 × SELECT `config`
FROM `ekfi_virtuemart_configs`
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `ekfi_virtuemart_permgroups`
1 × SELECT pc.`virtuemart_category_id`
FROM `ekfi_virtuemart_product_categories` as pc
LEFT JOIN `ekfi_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
1 × SELECT `data`
FROM `ekfi_session`
1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `ekfi_virtuemart_vendors` AS v
LEFT JOIN `ekfi_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
1 × SELECT *
FROM `ekfi_virtuemart_currencies`
1 × SELECT `ekfi_virtuemart_manufacturers_nl_nl`.* ,`ekfi_virtuemart_manufacturers`.*
FROM `ekfi_virtuemart_manufacturers_nl_nl` JOIN ekfi_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
1 × SELECT `virtuemart_shoppergroup_id`
FROM `ekfi_virtuemart_vmuser_shoppergroups`
1 × SELECT *
FROM `ekfi_menu`
1 × SELECT *
FROM ekfi_rokcandy
1 × SELECT *
FROM ekfi_languages
1 × SELECT `price_display`,`custom_price_display`
FROM `ekfi_virtuemart_shoppergroups` AS `sg`
1 × UPDATE `ekfi_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714311638;s:18:\"session.timer.last\";i:1714311638;s:17:\"session.timer.now\";i:1714311638;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:10:\"com_search\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:0;}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;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\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:23:\"gantry-current-template\";s:9:\"rt_acacia\";s:13:\"session.token\";s:32:\"1386402b2de82424749f4d689a90be08\";}__vm|a:3:{s:6:\"vmcart\";s:645:\"O:8:\"stdClass\":24:{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:2:\"BT\";i:0;s:2:\"ST\";i:0;s:11:\"tosAccepted\";N;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: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:23:\"vmlastvisitedcategoryid\";i:4;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:1;}}' , `time` = '1714311639'
1 × SHOW FULL COLUMNS
FROM `ekfi_template_styles
1 × SHOW TABLES LIKE "ekfi_virtuemart_configs
1 × SHOW FULL COLUMNS
FROM `ekfi_extensions
1 × INSERT INTO `ekfi_session` (`session_id`, `client_id`, `time`)
VALUES ('2g95s7hh0085q1jcqm2hhbic62', 0, '1714311638'