
The Richmond Practice Tests are a complete series of tests written by Cambridge exam writers for the Cambridge English Qualifications.
The brand new Richmond Practice Tests for Pre A1 Starters, A1 Movers and A2 Flyers offer a friendly and accessible way to familiarize children with the style and format of Cambridge English Qualifications for young learners. Each book is beautifully illustrated in full color and includes three complete practice tests. The series is also accompanied by downloadable Teacher's Resources, including audio files and transcripts, answer keys, mark schemes and useful information about the tests.
Key Features
Three complete sets of tests for the updated Cambridge exam (from 2018): Listening, Reading and Writing, and Speaking tests
Easy-to-understand information about the test
Free downloadable audio and Teacher's Resources from the Richmond Learning Platform
Simple, colorful design and engaging material
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
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.050 seconds (+0.050); 3.86 MB (+3.249) - afterInitialise
Application 0.077 seconds (+0.027); 6.27 MB (+2.414) - afterRoute
Application 0.304 seconds (+0.226); 16.62 MB (+10.343) - beforeRenderModule mod_breadcrumbs (Breadcrumbs Products)
Application 0.308 seconds (+0.004); 16.73 MB (+0.117) - afterRenderModule mod_breadcrumbs (Breadcrumbs Products)
Application 0.310 seconds (+0.002); 16.73 MB (-0.000) - beforeRenderModule mod_social_comments_sharing (Joomla Social Comments and Sharing PRO)
Application 0.311 seconds (+0.001); 16.76 MB (+0.031) - afterRenderModule mod_social_comments_sharing (Joomla Social Comments and Sharing PRO)
Application 0.312 seconds (+0.001); 16.63 MB (-0.131) - afterDispatch
Application 0.314 seconds (+0.002); 16.73 MB (+0.097) - beforeRenderModule mod_custom (logos_sellos)
Application 0.321 seconds (+0.007); 17.05 MB (+0.320) - afterRenderModule mod_custom (logos_sellos)
Application 0.322 seconds (+0.000); 17.05 MB (-0.002) - beforeRenderModule mod_custom (FooterContactAs)
Application 0.322 seconds (+0.000); 17.05 MB (+0.004) - afterRenderModule mod_custom (FooterContactAs)
Application 0.322 seconds (+0.000); 17.05 MB (-0.003) - beforeRenderModule mod_custom (About Us)
Application 0.323 seconds (+0.000); 17.05 MB (+0.004) - afterRenderModule mod_custom (About Us)
Application 0.323 seconds (+0.000); 17.05 MB (-0.002) - beforeRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.339 seconds (+0.016); 17.19 MB (+0.135) - afterRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.339 seconds (+0.000); 17.18 MB (-0.004) - beforeRenderModule mod_menu (Resources)
Application 0.344 seconds (+0.005); 17.24 MB (+0.060) - afterRenderModule mod_menu (Resources)
Application 0.344 seconds (+0.000); 17.24 MB (-0.006) - beforeRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.347 seconds (+0.004); 17.25 MB (+0.015) - afterRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.347 seconds (+0.000); 17.25 MB (-0.005) - beforeRenderModule mod_menu (Main Menu)
Application 0.354 seconds (+0.007); 17.35 MB (+0.098) - afterRenderModule mod_menu (Main Menu)
Application 0.354 seconds (+0.000); 17.34 MB (-0.007) - beforeRenderModule mod_custom (Logo-Richmond)
Application 0.355 seconds (+0.000); 17.34 MB (+0.004) - afterRenderModule mod_custom (Logo-Richmond)
Application 0.360 seconds (+0.006); 17.42 MB (+0.076) - afterRender
17.43 MB (18,280,776 Bytes)
SELECT `data`
FROM `qpf89_session`
WHERE `session_id` = 'c8244be5dbc96c55272ee3988a149813'
SELECT `session_id`
FROM `qpf89_session`
WHERE `session_id` = 'c8244be5dbc96c55272ee3988a149813'
LIMIT 0, 1
INSERT INTO `qpf89_session`
(`session_id`, `client_id`, `time`)
VALUES
('c8244be5dbc96c55272ee3988a149813', 0, '1615272110')
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 `virtuemart_category_id`
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `slug` LIKE 'exams'
SELECT `p`.`virtuemart_product_id`
FROM `qpf89_virtuemart_products_en_gb` AS `p`
LEFT JOIN `qpf89_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`
WHERE `p`.`slug` LIKE "richmond-practice-tests-young-learners-151"
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_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` = "151"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "151"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "151"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "151"
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 *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "151"
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-03-09 06:41:50" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2021-03-09 06:41:50" ) )
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` = 151
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` = 151
AND `published`=1
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "151"
and `virtuemart_category_id`= "32"
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` = "32"
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` =151
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` =151
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` =151
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` =151
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-03-09 06:41:50" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-03-09 06:41:50" )
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` =151
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 `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 `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 151
SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_manufacturers_en_gb` as l JOIN `qpf89_virtuemart_manufacturers` AS m using (`virtuemart_manufacturer_id`) JOIN `qpf89_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
WHERE m.`published`=1
AND pm.`virtuemart_product_id` =151
ORDER BY l.`mf_name`
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "537"
SELECT `l`.`virtuemart_product_id`, `l`.`product_name`
FROM `qpf89_virtuemart_products` as `p`
JOIN `qpf89_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`)
JOIN `qpf89_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_shoppergroups` as `psgr`
on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)
WHERE `virtuemart_category_id` = 32
and `slug` < "richmond-practice-tests-young-learners-151"
AND ( psgr.`virtuemart_shoppergroup_id`= "1" OR psgr.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`= 1
ORDER BY pc.ordering DESC
LIMIT 0,1
SELECT `l`.`virtuemart_product_id`, `l`.`product_name`
FROM `qpf89_virtuemart_products` as `p`
JOIN `qpf89_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`)
JOIN `qpf89_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_shoppergroups` as `psgr`
on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)
WHERE `virtuemart_category_id` = 32
and `slug` > "richmond-practice-tests-young-learners-151"
AND ( psgr.`virtuemart_shoppergroup_id`= "1" OR psgr.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`= 1
ORDER BY pc.ordering ASC
LIMIT 0,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` = "32"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "32"
ORDER BY `ordering`
SELECT `category_child_id`
FROM `qpf89_virtuemart_category_categories`
WHERE `category_parent_id` = 32
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` = 32
AND `qpf89_virtuemart_products`.`virtuemart_product_id` = `qpf89_virtuemart_product_categories`.`virtuemart_product_id`
AND `qpf89_virtuemart_products`.`published` = "1"
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_name`,`virtuemart_category_id`
FROM `qpf89_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=32
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 *
FROM `qpf89_virtuemart_rating_reviews`
WHERE `virtuemart_product_id` = "151"
AND `created_by` = "0"
SELECT SQL_CALC_FOUND_ROWS `u`.*,`pr`.*,`p`.`product_name`,`rv`.`vote`, `u`.`name` AS customer, `pr`.`published`
FROM `qpf89_virtuemart_rating_reviews` AS `pr`
LEFT JOIN `qpf89_users` AS `u`
ON `pr`.`created_by` = `u`.`id`
LEFT JOIN `qpf89_virtuemart_products_en_gb` AS `p`
ON `p`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_rating_votes` AS `rv`
on `rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id`
and `rv`.`created_by`=`u`.`id`
WHERE `p`.`virtuemart_product_id` = "151"
ORDER BY created_on DESC
LIMIT 0, 20
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS `u`.*,`pr`.*,`p`.`product_name`,`rv`.`vote`, `u`.`name` AS customer, `pr`.`published`
FROM `qpf89_virtuemart_rating_reviews` AS `pr`
LEFT JOIN `qpf89_users` AS `u`
ON `pr`.`created_by` = `u`.`id`
LEFT JOIN `qpf89_virtuemart_products_en_gb` AS `p`
ON `p`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_rating_votes` AS `rv`
on `rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id`
and `rv`.`created_by`=`u`.`id`
WHERE `p`.`virtuemart_product_id` = "151"
ORDER BY created_on DESC
LIMIT 0, 20
SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `qpf89_virtuemart_paymentmethods_en_gb` as l JOIN `qpf89_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `qpf89_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `qpf89_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
WHERE v.`published` = "1"
AND j.`element` = "klarna"
AND (v.`virtuemart_vendor_id` = "1" OR v.`virtuemart_vendor_id` = "0")
AND ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY v.`virtuemart_paymentmethod_id`
ORDER BY v.`ordering`
SELECT 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-03-09 06:41:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-09 06:41:50')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 256 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
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` = 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` = 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`= 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`= 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`= 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_contact'
UPDATE `qpf89_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1615272110;s:18:\"session.timer.last\";i:1615272110;s:17:\"session.timer.now\";i:1615272110;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:14:\"productdetails\";O:8:\"stdClass\":3:{s:12:\"filter_order\";s:11:\"pc.ordering\";s:5:\"
limit\";s:3:\"int\";s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}__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:32;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:151;}}'
, `time` = '1615272111'
WHERE `session_id` = 'c8244be5dbc96c55272ee3988a149813'
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 `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
3 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `qpf89_virtuemart_category_categories` AS `xref`
2 × SELECT `l`.`virtuemart_product_id`, `l`.`product_name`
FROM `qpf89_virtuemart_products` as `p` JOIN `qpf89_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `qpf89_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)
LEFT JOIN `qpf89_virtuemart_product_shoppergroups` as `psgr`
on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)
2 × SELECT *
FROM `qpf89_virtuemart_shoppergroups`
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`
2 × SELECT SQL_CALC_FOUND_ROWS `u`.*,`pr`.*,`p`.`product_name`,`rv`.`vote`, `u`.`name` AS customer, `pr`.`published`
FROM `qpf89_virtuemart_rating_reviews` AS `pr`
LEFT JOIN `qpf89_users` AS `u`
ON `pr`.`created_by` = `u`.`id`
LEFT JOIN `qpf89_virtuemart_products_en_gb` AS `p`
ON `p`.`virtuemart_product_id` = `pr`.`virtuemart_product_id`
LEFT JOIN `qpf89_virtuemart_rating_votes` AS `rv`
on `rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id`
and `rv`.`created_by`=`u`.`id`
2 × SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
1 × SELECT *
FROM qpf89_virtuemart_calcs
1 × 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`
1 × SELECT `virtuemart_state_id`
FROM qpf89_virtuemart_calc_states
1 × SELECT `virtuemart_manufacturer_id`
FROM qpf89_virtuemart_calc_manufacturers
1 × SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb` JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
1 × SELECT `virtuemart_category_id`
FROM qpf89_virtuemart_calc_categories
1 × SELECT `virtuemart_shoppergroup_id`
FROM qpf89_virtuemart_calc_shoppergroups
1 × SELECT `virtuemart_country_id`
FROM qpf89_virtuemart_calc_countries
1 × SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
1 × SELECT FOUND_ROWS(
1 × SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`, j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `qpf89_virtuemart_paymentmethods_en_gb` as l JOIN `qpf89_virtuemart_paymentmethods` AS v USING (`virtuemart_paymentmethod_id`)
LEFT JOIN `qpf89_extensions` as j
ON j.`extension_id` = v.`payment_jplugin_id`
LEFT
OUTER JOIN `qpf89_virtuemart_paymentmethod_shoppergroups` AS s
ON v.`virtuemart_paymentmethod_id` = s.`virtuemart_paymentmethod_id`
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 *
FROM `qpf89_virtuemart_rating_reviews`
1 × SELECT `category_name`,`virtuemart_category_id`
FROM `qpf89_virtuemart_categories_en_gb`
1 × SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_manufacturers_en_gb` as l JOIN `qpf89_virtuemart_manufacturers` AS m using (`virtuemart_manufacturer_id`) JOIN `qpf89_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
1 × SELECT `category_child_id`
FROM `qpf89_virtuemart_category_categories`
1 × SELECT count(qpf89_virtuemart_products.virtuemart_product_id) AS total
FROM `qpf89_virtuemart_products`, `qpf89_virtuemart_product_categories`
1 × SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
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 *
FROM `qpf89_menu`
1 × SELECT *
FROM qpf89_languages
1 × SELECT `virtuemart_category_id`
FROM `qpf89_virtuemart_categories_en_gb`
1 × SELECT `p`.`virtuemart_product_id`
FROM `qpf89_virtuemart_products_en_gb` AS `p`
LEFT JOIN `qpf89_virtuemart_product_categories` AS `xref`
ON `p`.`virtuemart_product_id` = `xref`.`virtuemart_product_id`
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 `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `qpf89_virtuemart_permgroups`
1 × SELECT `config`
FROM `qpf89_virtuemart_configs`
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 id, rules
FROM `qpf89_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM qpf89_extensions
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 `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`
1 × SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
1 × SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
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 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`
1 × SELECT `data`
FROM `qpf89_session`
1 × SELECT *
FROM `qpf89_virtuemart_currencies`
1 × SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
1 × SELECT *
FROM `qpf89_virtuemart_product_prices`
1 × SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
1 × SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
1 × SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_vmuser_shoppergroups`
1 × SELECT `virtuemart_userinfo_id`
FROM `qpf89_virtuemart_userinfos`
1 × SELECT `price_display`,`custom_price_display`
FROM `qpf89_virtuemart_shoppergroups` AS `sg`
1 × UPDATE `qpf89_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1615272110;s:18:\"session.timer.last\";i:1615272110;s:17:\"session.timer.now\";i:1615272110;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:14:\"productdetails\";O:8:\"stdClass\":3:{s:12:\"filter_order\";s:11:\"pc.ordering\";s:5:\"
limit\";s:3:\"int\";s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}__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:32;s:23:\"vmlastvisitedproductids\";a:1:{i:0;i:151;}}' , `time` = '1615272111'
1 × SHOW TABLES LIKE "%virtuemart_configs%
1 × INSERT INTO `qpf89_session` (`session_id`, `client_id`, `time`)
VALUES ('c8244be5dbc96c55272ee3988a149813', 0, '1615272110'