Wonder is designed for the curious young minds of the 21st century. Its methodology will provide a pleasant learning experience for both the children and teacher.
Skyrocket is a six-level series for elementary school learners. Each unit of Skyrocket is content-based, to encourage children to focus on the topic more than on the structures and vocabulary being presented.
Compass is a brand new 6-level elementary school language arts program specially written to be used in countries where English is not the official language.
Beep is a six-level course for elementary education. It is based on the guiding principle that all contexts and situations in which English is presented should be meaningful and relevant and draw upon the students’ own worlds.
Compass is a brand new 6-level elementary school language arts program specially written to be used in countries where English is not the official language.
Lighthouse is a six-level series that aims to help primary students navigate the occasionally rough seas of learning English.
Young Achievers will challenge and motivate your students. A blend of skills, a fast-paced grammar syllabus and phonics provides children with a strong foundation.
Thumbs Up! SECOND EDITION is a six-level primary series that motivates children to learn English while developing other areas of knowledge.
Our mission is to contribute to excellence in English language teaching worldwide through the publication of high quality materials in teacher-friendly formats and the provision of additional educational services relevant to local needs.
Juan Manuel Blanes 1132, CP: 11200 Montevideo, Uruguay
Teléfono: +59824107342
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
session.token ⇒ 0d86b6aa9ad7e36a6733db53add15eb1
vmcart ⇒ O:8:"stdClass":21:{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: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";i:0;}
Application 0.000 seconds (+0.000); 0.61 MB (+0.609) - afterLoad
Application 0.073 seconds (+0.073); 3.86 MB (+3.250) - afterInitialise
Application 0.122 seconds (+0.049); 6.27 MB (+2.413) - afterRoute
Application 0.319 seconds (+0.197); 11.95 MB (+5.677) - afterDispatch
Application 0.326 seconds (+0.008); 12.16 MB (+0.211) - beforeRenderModule mod_custom (logos_sellos)
Application 0.337 seconds (+0.011); 12.52 MB (+0.357) - afterRenderModule mod_custom (logos_sellos)
Application 0.337 seconds (+0.000); 12.51 MB (-0.002) - beforeRenderModule mod_custom (FooterContactAs)
Application 0.339 seconds (+0.001); 12.52 MB (+0.004) - afterRenderModule mod_custom (FooterContactAs)
Application 0.339 seconds (+0.000); 12.52 MB (-0.003) - beforeRenderModule mod_custom (About Us)
Application 0.340 seconds (+0.001); 12.52 MB (+0.004) - afterRenderModule mod_custom (About Us)
Application 0.340 seconds (+0.000); 12.52 MB (-0.001) - beforeRenderModule mod_login (Login Form)
Application 0.345 seconds (+0.005); 12.58 MB (+0.057) - afterRenderModule mod_login (Login Form)
Application 0.345 seconds (+0.000); 12.57 MB (-0.004) - beforeRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.370 seconds (+0.025); 12.70 MB (+0.132) - afterRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.371 seconds (+0.000); 12.70 MB (-0.003) - beforeRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.375 seconds (+0.004); 12.72 MB (+0.016) - afterRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.375 seconds (+0.000); 12.71 MB (-0.005) - beforeRenderModule mod_menu (Main Menu)
Application 0.389 seconds (+0.014); 12.90 MB (+0.191) - afterRenderModule mod_menu (Main Menu)
Application 0.389 seconds (+0.000); 12.90 MB (-0.007) - beforeRenderModule mod_custom (Logo-Richmond)
Application 0.390 seconds (+0.001); 12.90 MB (+0.004) - afterRenderModule mod_custom (Logo-Richmond)
Application 0.402 seconds (+0.012); 12.98 MB (+0.081) - afterRender
13 MB (13,632,112 Bytes)
SELECT `data`
FROM `qpf89_session`
WHERE `session_id` = '790ea6acc5a0bcf3db2cec3761fc3fa8'
DELETE
FROM `qpf89_session`
WHERE `time` < '1618910453'
SELECT `session_id`
FROM `qpf89_session`
WHERE `session_id` = '790ea6acc5a0bcf3db2cec3761fc3fa8'
LIMIT 0, 1
INSERT INTO `qpf89_session`
(`session_id`, `client_id`, `time`)
VALUES
('790ea6acc5a0bcf3db2cec3761fc3fa8', 0, '1618911353')
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM qpf89_usergroups AS a
LEFT JOIN qpf89_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `qpf89_viewlevels`
SELECT folder AS type, element AS name, params
FROM qpf89_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 qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM qpf89_menu AS m
LEFT JOIN qpf89_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 "%virtuemart_configs%"
SELECT `config`
FROM `qpf89_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `qpf89_virtuemart_permgroups`
ORDER BY `group_level`
SELECT *
FROM qpf89_languages
WHERE published=1
ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT *
FROM `qpf89_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language="en_gb")
SELECT id, home, template, s.params
FROM qpf89_template_styles as s
LEFT JOIN qpf89_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 `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "25"
ORDER BY `ordering`
SELECT `category_child_id`
FROM `qpf89_virtuemart_category_categories`
WHERE `category_parent_id` = 25
SELECT count(qpf89_virtuemart_products.virtuemart_product_id) AS total
FROM `qpf89_virtuemart_products`, `qpf89_virtuemart_product_categories`
WHERE `qpf89_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `qpf89_virtuemart_product_categories`.`virtuemart_category_id` = 25
AND `qpf89_virtuemart_products`.`virtuemart_product_id` = `qpf89_virtuemart_product_categories`.`virtuemart_product_id`
AND `qpf89_virtuemart_products`.`published` = "1"
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 25
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_vmuser_shoppergroups`
WHERE `virtuemart_user_id` = "0"
SELECT *
FROM `qpf89_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT `virtuemart_userinfo_id`
FROM `qpf89_virtuemart_userinfos`
WHERE `virtuemart_user_id` = "0"
SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
FROM `qpf89_virtuemart_products_en_gb` as l JOIN `qpf89_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_categories_en_gb` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
ON p.`virtuemart_product_id` = `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_manufacturers_en_gb` as m
ON m.`virtuemart_manufacturer_id` = `qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `qpf89_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `qpf89_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `qpf89_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `qpf89_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
WHERE ( p.`published`="1"
AND `pc`.`virtuemart_category_id` = 25
AND `pc`.`virtuemart_category_id` > 0
AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
group by p.`virtuemart_product_id`
ORDER BY `mf_name` ASC
LIMIT 0, 10
SELECT FOUND_ROWS()
SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE qpf89_virtuemart_products_en_gb.`virtuemart_product_id` = "82"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "82"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "82"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "82"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "82"
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` <= "2021-04-20 09:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-04-20 09:35:53" ) )
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 `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 82
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "82"
and `virtuemart_category_id`= "25"
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =82
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 `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `qpf89_virtuemart_vendors` AS v
LEFT JOIN `qpf89_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
WHERE v.`virtuemart_vendor_id`="1"
SELECT *
FROM `qpf89_virtuemart_currencies`
WHERE `virtuemart_currency_id`="144"
SELECT `price_display`,`custom_price_display`
FROM `qpf89_virtuemart_shoppergroups` AS `sg`
WHERE `sg`.`default` = "2"
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =82
and `field_type` = "Z"
and is_cart_attribute = 0
order by virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =82
and `field_type` = "R"
and is_cart_attribute = 0
order by virtuemart_customfield_id
SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =82
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT *
FROM `qpf89_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
SELECT *
FROM qpf89_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 <= "2021-04-20 09:35:53" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-04-20 09:35:53" )
OR `for_override` = "1" )
SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =82
SELECT `virtuemart_category_id`
FROM qpf89_virtuemart_calc_categories
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_shoppergroup_id`
FROM qpf89_virtuemart_calc_shoppergroups
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_country_id`
FROM qpf89_virtuemart_calc_countries
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_state_id`
FROM qpf89_virtuemart_calc_states
WHERE `virtuemart_calc_id`="1"
SELECT `virtuemart_manufacturer_id`
FROM qpf89_virtuemart_calc_manufacturers
WHERE `virtuemart_calc_id`="1"
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 82
SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE qpf89_virtuemart_products_en_gb.`virtuemart_product_id` = "145"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "145"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "145"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "145"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "145"
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` <= "2021-04-20 09:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-04-20 09:35:53" ) )
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 `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 145
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "145"
and `virtuemart_category_id`= "25"
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =145
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =145
and `field_type` = "Z"
and is_cart_attribute = 0
order by virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =145
and `field_type` = "R"
and is_cart_attribute = 0
order by virtuemart_customfield_id
SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =145
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 `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =145
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 145
SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE qpf89_virtuemart_products_en_gb.`virtuemart_product_id` = "148"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "148"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "148"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "148"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "148"
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` <= "2021-04-20 09:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-04-20 09:35:53" ) )
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 `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 148
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "148"
and `virtuemart_category_id`= "25"
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =148
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =148
and `field_type` = "Z"
and is_cart_attribute = 0
order by virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =148
and `field_type` = "R"
and is_cart_attribute = 0
order by virtuemart_customfield_id
SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =148
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 `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =148
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 148
SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE qpf89_virtuemart_products_en_gb.`virtuemart_product_id` = "42"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "42"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "42"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "42"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "42"
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` <= "2021-04-20 09:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-04-20 09:35:53" ) )
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 `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 42
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "42"
and `virtuemart_category_id`= "25"
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =42
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =42
and `field_type` = "Z"
and is_cart_attribute = 0
order by virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =42
and `field_type` = "R"
and is_cart_attribute = 0
order by virtuemart_customfield_id
SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =42
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 `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =42
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 42
SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE qpf89_virtuemart_products_en_gb.`virtuemart_product_id` = "159"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "159"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "159"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "159"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "159"
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` <= "2021-04-20 09:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-04-20 09:35:53" ) )
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 `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 159
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "159"
and `virtuemart_category_id`= "25"
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =159
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =159
and `field_type` = "Z"
and is_cart_attribute = 0
order by virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =159
and `field_type` = "R"
and is_cart_attribute = 0
order by virtuemart_customfield_id
SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =159
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 `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =159
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 159
SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE qpf89_virtuemart_products_en_gb.`virtuemart_product_id` = "47"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "47"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "47"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "47"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "47"
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` <= "2021-04-20 09:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-04-20 09:35:53" ) )
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 `qpf89_virtuemart_manufacturers_en_gb`.* ,`qpf89_virtuemart_manufacturers`.*
FROM `qpf89_virtuemart_manufacturers_en_gb` JOIN qpf89_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE qpf89_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "22"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 47
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "47"
and `virtuemart_category_id`= "25"
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =47
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =47
and `field_type` = "Z"
and is_cart_attribute = 0
order by virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =47
and `field_type` = "R"
and is_cart_attribute = 0
order by virtuemart_customfield_id
SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =47
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 `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =47
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 47
SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE qpf89_virtuemart_products_en_gb.`virtuemart_product_id` = "83"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "83"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "83"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "83"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "83"
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` <= "2021-04-20 09:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-04-20 09:35:53" ) )
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 `qpf89_virtuemart_manufacturers_en_gb`.* ,`qpf89_virtuemart_manufacturers`.*
FROM `qpf89_virtuemart_manufacturers_en_gb` JOIN qpf89_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE qpf89_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "38"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 83
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "83"
and `virtuemart_category_id`= "25"
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =83
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =83
and `field_type` = "Z"
and is_cart_attribute = 0
order by virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =83
and `field_type` = "R"
and is_cart_attribute = 0
order by virtuemart_customfield_id
SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =83
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 `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =83
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 83
SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
WHERE qpf89_virtuemart_products_en_gb.`virtuemart_product_id` = "43"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "43"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "43"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "43"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "43"
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` <= "2021-04-20 09:35:53" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-04-20 09:35:53" ) )
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 `qpf89_virtuemart_manufacturers_en_gb`.* ,`qpf89_virtuemart_manufacturers`.*
FROM `qpf89_virtuemart_manufacturers_en_gb` JOIN qpf89_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
WHERE qpf89_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "38"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 43
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "43"
and `virtuemart_category_id`= "25"
SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
WHERE qpf89_virtuemart_categories_en_gb.`virtuemart_category_id` = "25"
SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =43
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =43
and `field_type` = "Z"
and is_cart_attribute = 0
order by virtuemart_custom_id
SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =43
and `field_type` = "R"
and is_cart_attribute = 0
order by virtuemart_customfield_id
SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
Where `virtuemart_product_id` =43
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 `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =43
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 43
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "231"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "190"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "534"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "531"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "550"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "195"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "232"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "526"
SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_manufacturers_en_gb` as l JOIN `qpf89_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
LEFT JOIN `qpf89_virtuemart_products` as p
ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_categories` as c
ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`
WHERE p.`published` =1
AND c.`virtuemart_category_id` =25
ORDER BY l.`mf_name`
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=41
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=40
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=22
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=38
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=39
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qpf89_modules AS m
LEFT JOIN qpf89_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qpf89_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 <= '2021-04-20 09:35:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-20 09:35:53')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 181 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 30
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "24"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "25"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "26"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "27"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "33"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "32"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "36"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "37"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "35"
ORDER BY `ordering`
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "38"
ORDER BY `ordering`
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 24
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 26
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 27
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 33
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 32
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 36
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 37
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 35
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L
JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
WHERE CC.`category_parent_id` = 38
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `qpf89_virtuemart_category_categories` AS `xref`
WHERE `xref`.`category_child_id`= 25
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `qpf89_virtuemart_category_categories` AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 33
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 33
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=33
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 32
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 32
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=32
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 36
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 36
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=36
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 37
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 37
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=37
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 35
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 35
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=35
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 38
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 30
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 38
SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=38
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 0
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
UPDATE `qpf89_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618911353;s:18:\"session.timer.last\";i:1618911353;s:17:\"session.timer.now\";i:1618911353;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:11:\"categoryc25\";O:8:\"stdClass\":1:{s:5:\"
limit\";s:3:\"int\";}}}}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:13:\"session.token\";s:32:\"0d86b6aa9ad7e36a6733db53add15eb1\";}__vm|a:3:{s:6:\"vmcart\";s:545:\"O:8:\"stdClass\":21:{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: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\";i:0;}\";s:23:\"vmlastvisitedcategoryid\";i:25;s:19:\"vmlastvisitedmanuid\";i:0;}'
, `time` = '1618911353'
WHERE `session_id` = '790ea6acc5a0bcf3db2cec3761fc3fa8'
20 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
16 × 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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
11 × SELECT L.*
FROM `qpf89_virtuemart_categories_en_gb` as L JOIN `qpf89_virtuemart_categories` as C using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` as CC
on C.`virtuemart_category_id` = CC.`category_child_id`
11 × SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
9 × SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
8 × SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
8 × SELECT `qpf89_virtuemart_products_en_gb`.* ,`qpf89_virtuemart_products`.* ,`qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`qpf89_virtuemart_product_customfields`.`virtuemart_customfield_id`
FROM `qpf89_virtuemart_products_en_gb` JOIN qpf89_virtuemart_products using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
on `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_customfields`
on `qpf89_virtuemart_product_customfields`.`virtuemart_product_id`=`qpf89_virtuemart_products_en_gb`.`virtuemart_product_id`
8 × SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
8 × SELECT *
FROM `qpf89_virtuemart_product_prices`
8 × SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_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 `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
8 × SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
8 × SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
8 × SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb` JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
8 × SELECT C.`virtuemart_custom_id`, `custom_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
8 × SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
8 × SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
8 × SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
6 × SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
5 × SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
3 × SELECT `qpf89_virtuemart_manufacturers_en_gb`.* ,`qpf89_virtuemart_manufacturers`.*
FROM `qpf89_virtuemart_manufacturers_en_gb` JOIN qpf89_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
2 × SELECT *
FROM `qpf89_virtuemart_shoppergroups`
2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `qpf89_virtuemart_category_categories` AS `xref`
1 × SELECT `virtuemart_country_id`
FROM qpf89_virtuemart_calc_countries
1 × SELECT `virtuemart_shoppergroup_id`
FROM qpf89_virtuemart_calc_shoppergroups
1 × SELECT `virtuemart_category_id`
FROM qpf89_virtuemart_calc_categories
1 × SELECT id, rules
FROM `qpf89_viewlevels
1 × SELECT `virtuemart_state_id`
FROM qpf89_virtuemart_calc_states
1 × SELECT b.id
FROM qpf89_usergroups AS a
LEFT JOIN qpf89_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qpf89_modules AS m
LEFT JOIN qpf89_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qpf89_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_manufacturers_en_gb` as l JOIN `qpf89_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
LEFT JOIN `qpf89_virtuemart_products` as p
ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_product_categories` as c
ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`
1 × SELECT *
FROM qpf89_virtuemart_calcs
1 × SELECT `session_id`
FROM `qpf89_session`
1 × SELECT `virtuemart_manufacturer_id`
FROM qpf89_virtuemart_calc_manufacturers
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 qpf89_menu AS m
LEFT JOIN qpf89_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `category_child_id`
FROM `qpf89_virtuemart_category_categories`
1 × SELECT id, home, template, s.params
FROM qpf89_template_styles as s
LEFT JOIN qpf89_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `data`
FROM `qpf89_session`
1 × SELECT count(qpf89_virtuemart_products.virtuemart_product_id) AS total
FROM `qpf89_virtuemart_products`, `qpf89_virtuemart_product_categories`
1 × SELECT FOUND_ROWS(
1 × SELECT `virtuemart_userinfo_id`
FROM `qpf89_virtuemart_userinfos`
1 × SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
FROM `qpf89_virtuemart_products_en_gb` as l JOIN `qpf89_virtuemart_products` AS p using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_categories_en_gb` as c
ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
LEFT JOIN `qpf89_virtuemart_product_manufacturers`
ON p.`virtuemart_product_id` = `qpf89_virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_manufacturers_en_gb` as m
ON m.`virtuemart_manufacturer_id` = `qpf89_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `qpf89_virtuemart_product_shoppergroups`
ON p.`virtuemart_product_id` = `qpf89_virtuemart_product_shoppergroups`.`virtuemart_product_id`
LEFT
OUTER JOIN `qpf89_virtuemart_shoppergroups` as s
ON s.`virtuemart_shoppergroup_id` = `qpf89_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
1 × SELECT *
FROM `qpf89_menu`
1 × SELECT *
FROM qpf89_languages
1 × SELECT `price_display`,`custom_price_display`
FROM `qpf89_virtuemart_shoppergroups` AS `sg`
1 × SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_vmuser_shoppergroups`
1 × SELECT *
FROM `qpf89_virtuemart_currencies`
1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
FROM `qpf89_virtuemart_vendors` AS v
LEFT JOIN `qpf89_virtuemart_currencies` AS c
ON virtuemart_currency_id = vendor_currency
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `qpf89_virtuemart_permgroups`
1 × SELECT `config`
FROM `qpf89_virtuemart_configs`
1 × SELECT folder AS type, element AS name, params
FROM qpf89_extensions
1 × UPDATE `qpf89_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618911353;s:18:\"session.timer.last\";i:1618911353;s:17:\"session.timer.now\";i:1618911353;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:11:\"categoryc25\";O:8:\"stdClass\":1:{s:5:\"
limit\";s:3:\"int\";}}}}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:13:\"session.token\";s:32:\"0d86b6aa9ad7e36a6733db53add15eb1\";}__vm|a:3:{s:6:\"vmcart\";s:545:\"O:8:\"stdClass\":21:{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: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\";i:0;}\";s:23:\"vmlastvisitedcategoryid\";i:25;s:19:\"vmlastvisitedmanuid\";i:0;}' , `time` = '1618911353'
1 × SHOW TABLES LIKE "%virtuemart_configs%
1 × INSERT INTO `qpf89_session` (`session_id`, `client_id`, `time`)
VALUES ('790ea6acc5a0bcf3db2cec3761fc3fa8', 0, '1618911353'
1 × DELETE
FROM `qpf89_session`