Students for Peace is a 4-level series for lower secondary classes. Peace Education is the underlying theme of the series, which seeks to promote tolerance, respect to diversity, empathy and cooperation in the school environment.
Achievers is a brand-new course for teenagers which combines interesting, age-appropriate topics with challenging input, practice and support, so that every student will achieve his or her best.
English In motion is a dynamic four-level course that thoroughly integrates practice of the four skills with work on vocabulary, grammar, and pronunciation.
Next Step is a four-level course that takes students from elementary to intermediate.
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 ⇒ aab6f9b1a848a6f5a5526314e23d9f51
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.041 seconds (+0.040); 3.86 MB (+3.250) - afterInitialise
Application 0.060 seconds (+0.019); 5.16 MB (+1.298) - afterRoute
Application 0.185 seconds (+0.125); 11.63 MB (+6.477) - afterDispatch
Application 0.190 seconds (+0.005); 11.84 MB (+0.211) - beforeRenderModule mod_custom (logos_sellos)
Application 0.198 seconds (+0.007); 12.20 MB (+0.357) - afterRenderModule mod_custom (logos_sellos)
Application 0.198 seconds (+0.000); 12.20 MB (-0.002) - beforeRenderModule mod_custom (FooterContactAs)
Application 0.198 seconds (+0.000); 12.20 MB (+0.004) - afterRenderModule mod_custom (FooterContactAs)
Application 0.198 seconds (+0.000); 12.20 MB (-0.003) - beforeRenderModule mod_custom (About Us)
Application 0.199 seconds (+0.000); 12.21 MB (+0.004) - afterRenderModule mod_custom (About Us)
Application 0.199 seconds (+0.000); 12.20 MB (-0.001) - beforeRenderModule mod_login (Login Form)
Application 0.202 seconds (+0.004); 12.26 MB (+0.057) - afterRenderModule mod_login (Login Form)
Application 0.203 seconds (+0.000); 12.26 MB (-0.004) - beforeRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.219 seconds (+0.016); 12.39 MB (+0.133) - afterRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.219 seconds (+0.000); 12.39 MB (-0.003) - beforeRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.222 seconds (+0.003); 12.40 MB (+0.016) - afterRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.222 seconds (+0.000); 12.40 MB (-0.005) - beforeRenderModule mod_menu (Main Menu)
Application 0.231 seconds (+0.009); 12.59 MB (+0.191) - afterRenderModule mod_menu (Main Menu)
Application 0.231 seconds (+0.000); 12.58 MB (-0.007) - beforeRenderModule mod_custom (Logo-Richmond)
Application 0.232 seconds (+0.001); 12.59 MB (+0.004) - afterRenderModule mod_custom (Logo-Richmond)
Application 0.239 seconds (+0.007); 12.66 MB (+0.074) - afterRender
12.67 MB (13,287,144 Bytes)
SELECT `data`
FROM `qpf89_session`
WHERE `session_id` = '657ed7319936cb4caa26e9ddc397fae6'
SELECT `session_id`
FROM `qpf89_session`
WHERE `session_id` = '657ed7319936cb4caa26e9ddc397fae6'
LIMIT 0, 1
INSERT INTO `qpf89_session`
(`session_id`, `client_id`, `time`)
VALUES
('657ed7319936cb4caa26e9ddc397fae6', 0, '1611773890')
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
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT *
FROM qpf89_languages
WHERE published=1
ORDER BY ordering ASC
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
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 `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` = "26"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "26"
ORDER BY `ordering`
SELECT `category_child_id`
FROM `qpf89_virtuemart_category_categories`
WHERE `category_parent_id` = 26
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` = 26
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` = 26
AND C.`virtuemart_vendor_id` = 1
AND C.`published` = 1
ORDER BY C.`ordering`, L.`category_name` ASC
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 `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_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` = 26
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 `pc`.`ordering` 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` = "154"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "154"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "154"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "154"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "154"
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-01-27 18:58:10" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 18:58:10" ) )
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` = "48"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 154
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
LEFT JOIN `qpf89_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
WHERE pc.`virtuemart_product_id` = 154
AND `published`=1
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "154"
and `virtuemart_category_id`= "26"
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` = "26"
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` =154
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` =154
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` =154
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` =154
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-01-27 18:58:10" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-01-27 18:58:10" )
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` =154
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` = 154
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` = "85"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "85"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "85"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "85"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "85"
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-01-27 18:58:10" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 18:58:10" ) )
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` = 85
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "85"
and `virtuemart_category_id`= "26"
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` = "26"
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` =85
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` =85
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` =85
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` =85
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` =85
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 85
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` = "62"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "62"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "62"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "62"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "62"
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-01-27 18:58:10" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 18:58:10" ) )
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` = "14"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 62
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "62"
and `virtuemart_category_id`= "26"
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` = "26"
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` =62
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` =62
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` =62
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` =62
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` =62
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 62
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` = "63"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "63"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "63"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "63"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "63"
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-01-27 18:58:10" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-01-27 18:58:10" ) )
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` = "13"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 63
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "63"
and `virtuemart_category_id`= "26"
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` = "26"
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 63
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "541"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "234"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "210"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "211"
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` =26
ORDER BY l.`mf_name`
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=19
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=48
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=14
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=13
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-01-27 18:58:10')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-27 18:58:10')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 182 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` = 25
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`= 26
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:1611773890;s:18:\"session.timer.last\";i:1611773890;s:17:\"session.timer.now\";i:1611773890;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:8:\"category\";O:8:\"stdClass\":1:{s:12:\"filter_order\";s:11:\"pc.ordering\";}}}}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:\"aab6f9b1a848a6f5a5526314e23d9f51\";}__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:26;s:19:\"vmlastvisitedmanuid\";i:0;}'
, `time` = '1611773890'
WHERE `session_id` = '657ed7319936cb4caa26e9ddc397fae6'
20 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
11 × SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
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`
6 × 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`
6 × SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
5 × SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
4 × SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
4 × SELECT *
FROM `qpf89_virtuemart_product_prices`
4 × SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
4 × SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
4 × SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
4 × SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
4 × 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`
4 × SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
4 × SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
4 × SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
3 × 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`
3 × 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`
3 × SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb` JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
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_category_id`
FROM qpf89_virtuemart_calc_categories
1 × SELECT *
FROM qpf89_virtuemart_calcs
1 × SELECT `virtuemart_state_id`
FROM qpf89_virtuemart_calc_states
1 × SELECT `virtuemart_shoppergroup_id`
FROM qpf89_virtuemart_calc_shoppergroups
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 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 `session_id`
FROM `qpf89_session`
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 id, rules
FROM `qpf89_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM qpf89_extensions
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 `virtuemart_manufacturer_id`
FROM qpf89_virtuemart_calc_manufacturers
1 × SELECT `price_display`,`custom_price_display`
FROM `qpf89_virtuemart_shoppergroups` AS `sg`
1 × SELECT count(qpf89_virtuemart_products.virtuemart_product_id) AS total
FROM `qpf89_virtuemart_products`, `qpf89_virtuemart_product_categories`
1 × SELECT `category_child_id`
FROM `qpf89_virtuemart_category_categories`
1 × SELECT *
FROM `qpf89_menu`
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_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 `data`
FROM `qpf89_session`
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `qpf89_virtuemart_permgroups`
1 × SELECT *
FROM `qpf89_virtuemart_currencies`
1 × SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_vmuser_shoppergroups`
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 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 `config`
FROM `qpf89_virtuemart_configs`
1 × SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
LEFT JOIN `qpf89_virtuemart_categories` as c
ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
1 × SELECT *
FROM qpf89_languages
1 × UPDATE `qpf89_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611773890;s:18:\"session.timer.last\";i:1611773890;s:17:\"session.timer.now\";i:1611773890;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:8:\"category\";O:8:\"stdClass\":1:{s:12:\"filter_order\";s:11:\"pc.ordering\";}}}}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:\"aab6f9b1a848a6f5a5526314e23d9f51\";}__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:26;s:19:\"vmlastvisitedmanuid\";i:0;}' , `time` = '1611773890'
1 × SHOW TABLES LIKE "%virtuemart_configs%
1 × INSERT INTO `qpf89_session` (`session_id`, `client_id`, `time`)
VALUES ('657ed7319936cb4caa26e9ddc397fae6', 0, '1611773890'