Amanda and Friends is a new three-level preschool series that aims at exposing their students to English following a natural approach.
Gumdrops is an exciting, comprehensive, four-level preschool series that incorporates the most recent methodology proven to be effective in teaching little ones English.
Tippy Toes is an exciting preschool series for very young children. It fosters personal and social development, language and literacy, mathematics, knowing about the world and the environment, artistic development and health development.
Big Jungle Fun is the perfect series for extended timetables of bilingual schools and schools with many contact hours of English.
Crickets is a new four-level preschool series that integrates all the domains of early learning.
Jungle Fun is the perfect series for schools and kindergartens that aim at exposing their students to English without a high frequency of contact hours per week.
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 ⇒ a5f449cc51c81489f767c6402f0185a2
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.052 seconds (+0.051); 3.86 MB (+3.250) - afterInitialise
Application 0.071 seconds (+0.019); 5.16 MB (+1.298) - afterRoute
Application 0.227 seconds (+0.156); 11.79 MB (+6.634) - afterDispatch
Application 0.231 seconds (+0.005); 12.00 MB (+0.211) - beforeRenderModule mod_custom (logos_sellos)
Application 0.238 seconds (+0.007); 12.36 MB (+0.357) - afterRenderModule mod_custom (logos_sellos)
Application 0.238 seconds (+0.000); 12.36 MB (-0.002) - beforeRenderModule mod_custom (FooterContactAs)
Application 0.239 seconds (+0.001); 12.36 MB (+0.004) - afterRenderModule mod_custom (FooterContactAs)
Application 0.239 seconds (+0.000); 12.36 MB (-0.003) - beforeRenderModule mod_custom (About Us)
Application 0.240 seconds (+0.001); 12.36 MB (+0.004) - afterRenderModule mod_custom (About Us)
Application 0.240 seconds (+0.000); 12.36 MB (-0.001) - beforeRenderModule mod_login (Login Form)
Application 0.244 seconds (+0.004); 12.42 MB (+0.057) - afterRenderModule mod_login (Login Form)
Application 0.244 seconds (+0.000); 12.41 MB (-0.004) - beforeRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.260 seconds (+0.017); 12.55 MB (+0.132) - afterRenderModule mod_virtuemart_category (ELT Catalogue)
Application 0.260 seconds (+0.000); 12.54 MB (-0.003) - beforeRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.263 seconds (+0.003); 12.56 MB (+0.016) - afterRenderModule mod_virtuemart_search (VM - Search in Shop)
Application 0.263 seconds (+0.000); 12.55 MB (-0.005) - beforeRenderModule mod_menu (Main Menu)
Application 0.272 seconds (+0.009); 12.74 MB (+0.191) - afterRenderModule mod_menu (Main Menu)
Application 0.273 seconds (+0.000); 12.74 MB (-0.007) - beforeRenderModule mod_custom (Logo-Richmond)
Application 0.273 seconds (+0.001); 12.74 MB (+0.004) - afterRenderModule mod_custom (Logo-Richmond)
Application 0.280 seconds (+0.007); 12.82 MB (+0.078) - afterRender
12.84 MB (13,459,608 Bytes)
SELECT `data`
FROM `qpf89_session`
WHERE `session_id` = 'fe863f39a500ac0ddb039bf4aa6f26ab'
DELETE
FROM `qpf89_session`
WHERE `time` < '1611772401'
SELECT `session_id`
FROM `qpf89_session`
WHERE `session_id` = 'fe863f39a500ac0ddb039bf4aa6f26ab'
LIMIT 0, 1
INSERT INTO `qpf89_session`
(`session_id`, `client_id`, `time`)
VALUES
('fe863f39a500ac0ddb039bf4aa6f26ab', 0, '1611773301')
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` = "24"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "24"
ORDER BY `ordering`
SELECT `category_child_id`
FROM `qpf89_virtuemart_category_categories`
WHERE `category_parent_id` = 24
SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `qpf89_virtuemart_categories_en_gb` l
JOIN `qpf89_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 24
AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
ORDER BY category_name ASC
LIMIT 0, 20
SELECT FOUND_ROWS()
SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `qpf89_virtuemart_categories_en_gb` l
JOIN `qpf89_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 24
AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
ORDER BY category_name ASC
LIMIT 0, 20
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` = 24
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` = 24
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` = 24
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` = "143"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "143"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "143"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "143"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "143"
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:48:21" )
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:48:21" ) )
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` = 143
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "143"
and `virtuemart_category_id`= "24"
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` = "24"
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` =143
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` =143
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` =143
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` =143
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:48:21" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2021-01-27 18:48:21" )
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` =143
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` = 143
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` = "144"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "144"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "144"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "144"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "144"
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:48:21" )
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:48:21" ) )
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` = "25"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 144
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "144"
and `virtuemart_category_id`= "24"
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` = "24"
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` =144
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` =144
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` =144
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` =144
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` =144
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 144
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` = "149"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "149"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "149"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "149"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "149"
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:48:21" )
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:48:21" ) )
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` = "25"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 149
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "149"
and `virtuemart_category_id`= "24"
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` = "24"
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` =149
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` =149
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` =149
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` =149
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` =149
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 149
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` = "32"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "32"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "32"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "32"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "32"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2021-01-27 18:48:21" )
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:48:21" ) )
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` = "31"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 32
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "32"
and `virtuemart_category_id`= "24"
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` = "24"
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` =32
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT 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` =32
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` =32
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` =32
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =32
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 32
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` = "31"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "31"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "31"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "31"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "31"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2021-01-27 18:48:21" )
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:48:21" ) )
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` = "33"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 31
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "31"
and `virtuemart_category_id`= "24"
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` = "24"
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` =31
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT 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` =31
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` =31
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` =31
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =31
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` = "33"
SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "33"
ORDER BY `ordering`
SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "33"
SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "33"
SELECT *
FROM `qpf89_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "33"
AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2021-01-27 18:48:21" )
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:48:21" ) )
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` = "31"
SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
WHERE pc.`virtuemart_product_id` = 33
SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
WHERE `virtuemart_product_id` = "33"
and `virtuemart_category_id`= "24"
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` = "24"
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` =33
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 0
order by field.`ordering`,virtuemart_custom_id
SELECT 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` =33
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` =33
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` =33
and `field_type` != "G"
and `field_type` != "R"
and `field_type` != "Z"
and is_cart_attribute = 1
group by virtuemart_custom_id
ORDER BY field.`ordering`
SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb`
JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
WHERE `product_parent_id` =33
SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
WHERE `virtuemart_product_id` = 33
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "525"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "546"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "535"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "177"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "176"
SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
WHERE qpf89_virtuemart_medias.`virtuemart_media_id` = "522"
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` =24
ORDER BY l.`mf_name`
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=31
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=33
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=37
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=34
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=36
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=32
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=35
SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
WHERE virtuemart_manufacturer_id=25
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:48:21')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-27 18:48:21')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 180 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` = 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` = 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`= 24
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:1611773301;s:18:\"session.timer.last\";i:1611773301;s:17:\"session.timer.now\";i:1611773301;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:\"a5f449cc51c81489f767c6402f0185a2\";}__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:24;s:19:\"vmlastvisitedmanuid\";i:0;}'
, `time` = '1611773301'
WHERE `session_id` = 'fe863f39a500ac0ddb039bf4aa6f26ab'
20 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM qpf89_virtuemart_category_categories AS `xref`
12 × SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
FROM `qpf89_virtuemart_customs` AS C
LEFT JOIN `qpf89_virtuemart_product_customfields` AS field
ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
11 × SELECT `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`
8 × SELECT `slug`
FROM `qpf89_virtuemart_manufacturers_en_gb`
7 × SELECT `qpf89_virtuemart_categories_en_gb`.* ,`qpf89_virtuemart_categories`.*
FROM `qpf89_virtuemart_categories_en_gb` JOIN qpf89_virtuemart_categories using (`virtuemart_category_id`)
6 × SELECT `virtuemart_media_id`
FROM `qpf89_virtuemart_product_medias`
6 × 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`
6 × SELECT `virtuemart_manufacturer_id`
FROM `qpf89_virtuemart_product_manufacturers`
6 × SELECT *
FROM `qpf89_virtuemart_product_prices`
6 × 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`
6 × SELECT `qpf89_virtuemart_medias`.*
FROM `qpf89_virtuemart_medias`
6 × SELECT `slug` as name
FROM `qpf89_virtuemart_categories_en_gb`
6 × SELECT virtuemart_product_id, product_name
FROM `qpf89_virtuemart_products_en_gb` JOIN `qpf89_virtuemart_products` as C using (`virtuemart_product_id`)
6 × 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`
6 × SELECT `ordering`,`id`
FROM `qpf89_virtuemart_product_categories`
6 × SELECT pc.`virtuemart_category_id`
FROM `qpf89_virtuemart_product_categories` as pc
6 × SELECT `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_product_shoppergroups`
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM qpf89_extensions
5 × SELECT `qpf89_virtuemart_manufacturers_en_gb`.* ,`qpf89_virtuemart_manufacturers`.*
FROM `qpf89_virtuemart_manufacturers_en_gb` JOIN qpf89_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
5 × SELECT `slug`
FROM `qpf89_virtuemart_products_en_gb`
2 × SELECT FOUND_ROWS(
2 × SELECT SQL_CALC_FOUND_ROWS c.`virtuemart_category_id`, l.`category_description`, l.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `qpf89_virtuemart_categories_en_gb` l JOIN `qpf89_virtuemart_categories` AS c using (`virtuemart_category_id`)
LEFT JOIN `qpf89_virtuemart_category_categories` AS cx
ON l.`virtuemart_category_id` = cx.`category_child_id`
2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM `qpf89_virtuemart_category_categories` AS `xref`
2 × SELECT *
FROM `qpf89_virtuemart_shoppergroups`
1 × SELECT `virtuemart_state_id`
FROM qpf89_virtuemart_calc_states
1 × SELECT `virtuemart_country_id`
FROM qpf89_virtuemart_calc_countries
1 × SELECT `virtuemart_shoppergroup_id`
FROM qpf89_virtuemart_calc_shoppergroups
1 × SELECT `virtuemart_category_id`
FROM qpf89_virtuemart_calc_categories
1 × SELECT `virtuemart_manufacturer_id`
FROM qpf89_virtuemart_calc_manufacturers
1 × SELECT `session_id`
FROM `qpf89_session`
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 id, rules
FROM `qpf89_viewlevels
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 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 *
FROM qpf89_languages
1 × SELECT `data`
FROM `qpf89_session`
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 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 `virtuemart_shoppergroup_id`
FROM `qpf89_virtuemart_vmuser_shoppergroups`
1 × SELECT `virtuemart_userinfo_id`
FROM `qpf89_virtuemart_userinfos`
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `qpf89_virtuemart_permgroups`
1 × SELECT `config`
FROM `qpf89_virtuemart_configs`
1 × SELECT *
FROM `qpf89_menu`
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 `price_display`,`custom_price_display`
FROM `qpf89_virtuemart_shoppergroups` AS `sg`
1 × SELECT *
FROM `qpf89_virtuemart_currencies`
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 `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_virtuemart_calcs
1 × UPDATE `qpf89_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611773301;s:18:\"session.timer.last\";i:1611773301;s:17:\"session.timer.now\";i:1611773301;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:\"a5f449cc51c81489f767c6402f0185a2\";}__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:24;s:19:\"vmlastvisitedmanuid\";i:0;}' , `time` = '1611773301'
1 × SHOW TABLES LIKE "%virtuemart_configs%
1 × INSERT INTO `qpf89_session` (`session_id`, `client_id`, `time`)
VALUES ('fe863f39a500ac0ddb039bf4aa6f26ab', 0, '1611773301'
1 × DELETE
FROM `qpf89_session`