EXPLAIN not possible on query: SELECT b.rules
FROM u8vcj_assets AS a
LEFT JOIN u8vcj_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_virtuemart')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft

EXPLAIN not possible on query: SELECT id, home, template, s.params
FROM u8vcj_template_styles as s
LEFT JOIN u8vcj_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

EXPLAIN not possible on query: SELECT * FROM `u8vcj_virtuemart_userfields` WHERE 1 = 1 AND `account`=1 AND published = 1 AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0 ORDER BY ordering

EXPLAIN not possible on query: SELECT * FROM `u8vcj_virtuemart_userfields` WHERE 1 = 1 AND `shipment`=1 AND published = 1 AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0 ORDER BY ordering

EXPLAIN not possible on query: SELECT count(u8vcj_virtuemart_products.virtuemart_product_id) AS total
FROM `u8vcj_virtuemart_products`, `u8vcj_virtuemart_product_categories`
WHERE `u8vcj_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `u8vcj_virtuemart_product_categories`.`virtuemart_category_id` = 35
AND `u8vcj_virtuemart_products`.`virtuemart_product_id` = `u8vcj_virtuemart_product_categories`.`virtuemart_product_id`
AND `u8vcj_virtuemart_products`.`published` = "1"

EXPLAIN not possible on query: SELECT L.*
FROM `u8vcj_virtuemart_categories_th_th` as L
INNER JOIN `u8vcj_virtuemart_categories` as c using (`virtuemart_category_id`) LEFT JOIN `u8vcj_virtuemart_category_categories` as cx on c.`virtuemart_category_id` = cx.`category_child_id` WHERE cx.`category_parent_id` = 35 AND c.`virtuemart_vendor_id` = 1 AND c.`published` = 1 ORDER BY c.ordering ASC