585 Queries Logged

1. SELECT `data`
  FROM `jqmso_session`
  WHERE `session_id` = '7ffe071cb6bcc3750bafa3daee587c77'
2. DELETE
  FROM `jqmso_session`
  WHERE `time` < '1561414939'
3. SELECT `session_id`
  FROM `jqmso_session`
  WHERE `session_id` = '7ffe071cb6bcc3750bafa3daee587c77'
  LIMIT 0, 1
4. INSERT INTO `jqmso_session` (`session_id`, `client_id`, `time`)
  VALUES ('7ffe071cb6bcc3750bafa3daee587c77', 0, '1561418539')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jqmso_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM jqmso_usergroups AS a
  LEFT JOIN jqmso_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `jqmso_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM jqmso_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jqmso_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. 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 jqmso_menu AS m
  LEFT JOIN jqmso_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
11. SELECT id, home, template, s.params
  FROM jqmso_template_styles as s
  LEFT JOIN jqmso_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
12. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jqmso_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
13. SHOW TABLES LIKE "%virtuemart_configs%"
14. SELECT `config`
  FROM `jqmso_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
15. SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `jqmso_virtuemart_permgroups`
  ORDER BY `group_level`
16. SELECT *
  FROM jqmso_languages
  WHERE published=1
  ORDER BY ordering ASC
17. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jqmso_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_virtuemart'
18. SELECT *
  FROM `jqmso_menu`
  where `link` like "index.php?option=com_virtuemart%"
  and client_id=0
  and published=1
  and (language="*" or language="en_gb")
19. SELECT `virtuemart_category_id`
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `slug` LIKE 'flora-i-fauna'
20. SHOW FULL COLUMNS
  FROM `jqmso_virtuemart_categories`
21. SELECT `jqmso_virtuemart_categories_en_gb`.* ,`jqmso_virtuemart_categories`.*
  FROM `jqmso_virtuemart_categories_en_gb` JOIN jqmso_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jqmso_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
22. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "14"
  ORDER BY `ordering`
23. SELECT `category_child_id`
  FROM `jqmso_virtuemart_category_categories`
  WHERE `category_parent_id` = 14
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 `jqmso_virtuemart_categories_en_gb` l JOIN `jqmso_virtuemart_categories` AS c using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` AS cx
  ON l.`virtuemart_category_id` = cx.`category_child_id`
  WHERE c.`published` = 1
  AND cx.`category_parent_id` = 14
  AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
  ORDER BY category_name ASC
  LIMIT 0, 8
25. SELECT FOUND_ROWS()
26. SELECT count(jqmso_virtuemart_products.virtuemart_product_id) AS total
  FROM `jqmso_virtuemart_products`, `jqmso_virtuemart_product_categories`
  WHERE `jqmso_virtuemart_products`.`virtuemart_vendor_id` = "1"
  AND `jqmso_virtuemart_product_categories`.`virtuemart_category_id` = 14
  AND `jqmso_virtuemart_products`.`virtuemart_product_id` = `jqmso_virtuemart_product_categories`.`virtuemart_product_id`
  AND `jqmso_virtuemart_products`.`published` = "1"
27. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `jqmso_virtuemart_category_categories` AS `xref`
  WHERE `xref`.`category_child_id`= 14
28. SELECT `category_name`,`virtuemart_category_id`
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=14
29. SHOW FULL COLUMNS
  FROM `jqmso_virtuemart_medias`
30. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "535"
31. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 14
32. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 14
33. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=14
34. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "535"
35. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 14
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
36. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "29"
  ORDER BY `ordering`
37. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "30"
  ORDER BY `ordering`
38. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "31"
  ORDER BY `ordering`
39. SELECT `virtuemart_shoppergroup_id`
  FROM `jqmso_virtuemart_vmuser_shoppergroups`
  WHERE `virtuemart_user_id` = "0"
40. SELECT *
  FROM `jqmso_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND `virtuemart_vendor_id` = "1"
41. SELECT `virtuemart_userinfo_id`
  FROM `jqmso_virtuemart_userinfos`
  WHERE `virtuemart_user_id` = "0"
42. SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
  FROM `jqmso_virtuemart_products_en_gb` as l JOIN `jqmso_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `jqmso_virtuemart_product_categories`
  ON p.`virtuemart_product_id` = `jqmso_virtuemart_product_categories`.`virtuemart_product_id`
  LEFT JOIN `jqmso_virtuemart_categories_en_gb` as c
  ON c.`virtuemart_category_id` = `jqmso_virtuemart_product_categories`.`virtuemart_category_id`
  LEFT JOIN `jqmso_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `jqmso_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `jqmso_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `jqmso_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
  WHERE ( p.`published`="1"
  AND `jqmso_virtuemart_product_categories`.`virtuemart_category_id` = 14
  AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) )
  group by p.`virtuemart_product_id`
  ORDER BY product_name ASC
  LIMIT 0, 8
43. SELECT FOUND_ROWS()
44. SHOW FULL COLUMNS
  FROM `jqmso_virtuemart_products`
45. SELECT `jqmso_virtuemart_products_en_gb`.* ,`jqmso_virtuemart_products`.* ,`jqmso_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jqmso_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jqmso_virtuemart_products_en_gb` JOIN jqmso_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jqmso_virtuemart_product_manufacturers`
  on `jqmso_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `jqmso_virtuemart_product_customfields`
  on `jqmso_virtuemart_product_customfields`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE jqmso_virtuemart_products_en_gb.`virtuemart_product_id` = "9473"
46. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "9473"
  ORDER BY `ordering`
47. SELECT `virtuemart_shoppergroup_id`
  FROM `jqmso_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "9473"
48. SHOW FULL COLUMNS
  FROM `jqmso_virtuemart_product_prices`
49. SELECT `jqmso_virtuemart_product_prices`.*
  FROM `jqmso_virtuemart_product_prices`
  WHERE jqmso_virtuemart_product_prices.`virtuemart_product_id` = "9473"
50. SELECT pc.`virtuemart_category_id`
  FROM `jqmso_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 9473
51. SELECT `ordering`,`id`
  FROM `jqmso_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "9473"
  and `virtuemart_category_id`= "14"
52. SELECT `jqmso_virtuemart_categories_en_gb`.* ,`jqmso_virtuemart_categories`.*
  FROM `jqmso_virtuemart_categories_en_gb` JOIN jqmso_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jqmso_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
53. SELECT `slug`
  FROM `jqmso_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 9473
54. SELECT `vendor_currency`
  FROM `jqmso_virtuemart_vendors`
  WHERE `virtuemart_vendor_id`="1"
55. SELECT `price_display`,`custom_price_display`
  FROM `jqmso_virtuemart_shoppergroups` AS `sg`
  WHERE `sg`.`default` = "2"
56. SELECT *
  FROM `jqmso_virtuemart_currencies`
  WHERE `virtuemart_currency_id`="160"
57. SELECT *
  FROM jqmso_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 <= "2019-06-24 23:22:20" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-06-24 23:22:20" ) OR `for_override` = "1" )
58. SELECT `jqmso_virtuemart_products_en_gb`.* ,`jqmso_virtuemart_products`.* ,`jqmso_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jqmso_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jqmso_virtuemart_products_en_gb` JOIN jqmso_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jqmso_virtuemart_product_manufacturers`
  on `jqmso_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `jqmso_virtuemart_product_customfields`
  on `jqmso_virtuemart_product_customfields`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE jqmso_virtuemart_products_en_gb.`virtuemart_product_id` = "3603"
59. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3603"
  ORDER BY `ordering`
60. SELECT `virtuemart_shoppergroup_id`
  FROM `jqmso_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3603"
61. SELECT `jqmso_virtuemart_product_prices`.*
  FROM `jqmso_virtuemart_product_prices`
  WHERE jqmso_virtuemart_product_prices.`virtuemart_product_id` = "3603"
62. SELECT pc.`virtuemart_category_id`
  FROM `jqmso_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3603
63. SELECT `ordering`,`id`
  FROM `jqmso_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "3603"
  and `virtuemart_category_id`= "14"
64. SELECT `jqmso_virtuemart_categories_en_gb`.* ,`jqmso_virtuemart_categories`.*
  FROM `jqmso_virtuemart_categories_en_gb` JOIN jqmso_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jqmso_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
65. SELECT `slug`
  FROM `jqmso_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 3603
66. SELECT `jqmso_virtuemart_products_en_gb`.* ,`jqmso_virtuemart_products`.* ,`jqmso_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jqmso_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jqmso_virtuemart_products_en_gb` JOIN jqmso_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jqmso_virtuemart_product_manufacturers`
  on `jqmso_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `jqmso_virtuemart_product_customfields`
  on `jqmso_virtuemart_product_customfields`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE jqmso_virtuemart_products_en_gb.`virtuemart_product_id` = "1610"
67. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1610"
  ORDER BY `ordering`
68. SELECT `virtuemart_shoppergroup_id`
  FROM `jqmso_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1610"
69. SELECT `jqmso_virtuemart_product_prices`.*
  FROM `jqmso_virtuemart_product_prices`
  WHERE jqmso_virtuemart_product_prices.`virtuemart_product_id` = "1610"
70. SELECT pc.`virtuemart_category_id`
  FROM `jqmso_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1610
71. SELECT `ordering`,`id`
  FROM `jqmso_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1610"
  and `virtuemart_category_id`= "14"
72. SELECT `jqmso_virtuemart_categories_en_gb`.* ,`jqmso_virtuemart_categories`.*
  FROM `jqmso_virtuemart_categories_en_gb` JOIN jqmso_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jqmso_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
73. SELECT `slug`
  FROM `jqmso_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1610
74. SELECT `jqmso_virtuemart_products_en_gb`.* ,`jqmso_virtuemart_products`.* ,`jqmso_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jqmso_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jqmso_virtuemart_products_en_gb` JOIN jqmso_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jqmso_virtuemart_product_manufacturers`
  on `jqmso_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `jqmso_virtuemart_product_customfields`
  on `jqmso_virtuemart_product_customfields`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE jqmso_virtuemart_products_en_gb.`virtuemart_product_id` = "1609"
75. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1609"
  ORDER BY `ordering`
76. SELECT `virtuemart_shoppergroup_id`
  FROM `jqmso_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1609"
77. SELECT `jqmso_virtuemart_product_prices`.*
  FROM `jqmso_virtuemart_product_prices`
  WHERE jqmso_virtuemart_product_prices.`virtuemart_product_id` = "1609"
78. SELECT pc.`virtuemart_category_id`
  FROM `jqmso_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1609
79. SELECT `ordering`,`id`
  FROM `jqmso_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1609"
  and `virtuemart_category_id`= "14"
80. SELECT `jqmso_virtuemart_categories_en_gb`.* ,`jqmso_virtuemart_categories`.*
  FROM `jqmso_virtuemart_categories_en_gb` JOIN jqmso_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jqmso_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
81. SELECT `slug`
  FROM `jqmso_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1609
82. SELECT `jqmso_virtuemart_products_en_gb`.* ,`jqmso_virtuemart_products`.* ,`jqmso_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jqmso_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jqmso_virtuemart_products_en_gb` JOIN jqmso_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jqmso_virtuemart_product_manufacturers`
  on `jqmso_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `jqmso_virtuemart_product_customfields`
  on `jqmso_virtuemart_product_customfields`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE jqmso_virtuemart_products_en_gb.`virtuemart_product_id` = "3290"
83. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3290"
  ORDER BY `ordering`
84. SELECT `virtuemart_shoppergroup_id`
  FROM `jqmso_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3290"
85. SELECT `jqmso_virtuemart_product_prices`.*
  FROM `jqmso_virtuemart_product_prices`
  WHERE jqmso_virtuemart_product_prices.`virtuemart_product_id` = "3290"
86. SELECT pc.`virtuemart_category_id`
  FROM `jqmso_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3290
87. SELECT `ordering`,`id`
  FROM `jqmso_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "3290"
  and `virtuemart_category_id`= "14"
88. SELECT `jqmso_virtuemart_categories_en_gb`.* ,`jqmso_virtuemart_categories`.*
  FROM `jqmso_virtuemart_categories_en_gb` JOIN jqmso_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jqmso_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
89. SELECT `slug`
  FROM `jqmso_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 3290
90. SELECT `jqmso_virtuemart_products_en_gb`.* ,`jqmso_virtuemart_products`.* ,`jqmso_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jqmso_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jqmso_virtuemart_products_en_gb` JOIN jqmso_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jqmso_virtuemart_product_manufacturers`
  on `jqmso_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `jqmso_virtuemart_product_customfields`
  on `jqmso_virtuemart_product_customfields`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE jqmso_virtuemart_products_en_gb.`virtuemart_product_id` = "1618"
91. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1618"
  ORDER BY `ordering`
92. SELECT `virtuemart_shoppergroup_id`
  FROM `jqmso_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1618"
93. SELECT `jqmso_virtuemart_product_prices`.*
  FROM `jqmso_virtuemart_product_prices`
  WHERE jqmso_virtuemart_product_prices.`virtuemart_product_id` = "1618"
94. SELECT pc.`virtuemart_category_id`
  FROM `jqmso_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1618
95. SELECT `ordering`,`id`
  FROM `jqmso_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1618"
  and `virtuemart_category_id`= "14"
96. SELECT `jqmso_virtuemart_categories_en_gb`.* ,`jqmso_virtuemart_categories`.*
  FROM `jqmso_virtuemart_categories_en_gb` JOIN jqmso_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jqmso_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
97. SELECT `slug`
  FROM `jqmso_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1618
98. SELECT `jqmso_virtuemart_products_en_gb`.* ,`jqmso_virtuemart_products`.* ,`jqmso_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jqmso_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jqmso_virtuemart_products_en_gb` JOIN jqmso_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jqmso_virtuemart_product_manufacturers`
  on `jqmso_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `jqmso_virtuemart_product_customfields`
  on `jqmso_virtuemart_product_customfields`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE jqmso_virtuemart_products_en_gb.`virtuemart_product_id` = "9228"
99. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "9228"
  ORDER BY `ordering`
100. SELECT `virtuemart_shoppergroup_id`
  FROM `jqmso_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "9228"
101. SELECT `jqmso_virtuemart_product_prices`.*
  FROM `jqmso_virtuemart_product_prices`
  WHERE jqmso_virtuemart_product_prices.`virtuemart_product_id` = "9228"
102. SELECT pc.`virtuemart_category_id`
  FROM `jqmso_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 9228
103. SELECT `ordering`,`id`
  FROM `jqmso_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "9228"
  and `virtuemart_category_id`= "14"
104. SELECT `jqmso_virtuemart_categories_en_gb`.* ,`jqmso_virtuemart_categories`.*
  FROM `jqmso_virtuemart_categories_en_gb` JOIN jqmso_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jqmso_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
105. SELECT `slug`
  FROM `jqmso_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 9228
106. SELECT `jqmso_virtuemart_products_en_gb`.* ,`jqmso_virtuemart_products`.* ,`jqmso_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`jqmso_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `jqmso_virtuemart_products_en_gb` JOIN jqmso_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `jqmso_virtuemart_product_manufacturers`
  on `jqmso_virtuemart_product_manufacturers`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `jqmso_virtuemart_product_customfields`
  on `jqmso_virtuemart_product_customfields`.`virtuemart_product_id`=`jqmso_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE jqmso_virtuemart_products_en_gb.`virtuemart_product_id` = "8226"
107. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "8226"
  ORDER BY `ordering`
108. SELECT `virtuemart_shoppergroup_id`
  FROM `jqmso_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "8226"
109. SELECT `jqmso_virtuemart_product_prices`.*
  FROM `jqmso_virtuemart_product_prices`
  WHERE jqmso_virtuemart_product_prices.`virtuemart_product_id` = "8226"
110. SELECT pc.`virtuemart_category_id`
  FROM `jqmso_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 8226
111. SELECT `ordering`,`id`
  FROM `jqmso_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "8226"
  and `virtuemart_category_id`= "14"
112. SELECT `jqmso_virtuemart_categories_en_gb`.* ,`jqmso_virtuemart_categories`.*
  FROM `jqmso_virtuemart_categories_en_gb` JOIN jqmso_virtuemart_categories using (`virtuemart_category_id`)
  WHERE jqmso_virtuemart_categories_en_gb.`virtuemart_category_id` = "14"
113. SELECT `slug`
  FROM `jqmso_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 8226
114. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "9865"
115. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "4050"
116. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "2065"
117. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "2064"
118. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "3739"
119. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "2072"
120. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "9621"
121. SELECT `jqmso_virtuemart_medias`.*
  FROM `jqmso_virtuemart_medias`
  WHERE jqmso_virtuemart_medias.`virtuemart_media_id` = "8631"
122. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jqmso_modules AS m
  LEFT JOIN jqmso_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jqmso_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 <= '2019-06-24 23:22:20')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-06-24 23:22:20')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 629 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
123. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jqmso_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
124. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 0
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
125. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "21"
  ORDER BY `ordering`
126. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "20"
  ORDER BY `ordering`
127. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "19"
  ORDER BY `ordering`
128. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "18"
  ORDER BY `ordering`
129. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "17"
  ORDER BY `ordering`
130. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "16"
  ORDER BY `ordering`
131. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "15"
  ORDER BY `ordering`
132. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "14"
  ORDER BY `ordering`
133. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "13"
  ORDER BY `ordering`
134. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "12"
  ORDER BY `ordering`
135. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "11"
  ORDER BY `ordering`
136. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "3"
  ORDER BY `ordering`
137. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "4"
  ORDER BY `ordering`
138. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "10"
  ORDER BY `ordering`
139. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "9"
  ORDER BY `ordering`
140. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "1"
  ORDER BY `ordering`
141. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "2"
  ORDER BY `ordering`
142. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "5"
  ORDER BY `ordering`
143. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "46"
  ORDER BY `ordering`
144. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "47"
  ORDER BY `ordering`
145. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "48"
  ORDER BY `ordering`
146. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "52"
  ORDER BY `ordering`
147. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "53"
  ORDER BY `ordering`
148. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "58"
  ORDER BY `ordering`
149. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "66"
  ORDER BY `ordering`
150. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "63"
  ORDER BY `ordering`
151. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 21
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
152. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 20
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
153. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 19
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
154. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "22"
  ORDER BY `ordering`
155. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "23"
  ORDER BY `ordering`
156. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "24"
  ORDER BY `ordering`
157. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "25"
  ORDER BY `ordering`
158. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 18
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
159. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 17
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
160. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "26"
  ORDER BY `ordering`
161. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "27"
  ORDER BY `ordering`
162. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "28"
  ORDER BY `ordering`
163. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 16
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
164. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 15
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
165. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 13
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
166. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 12
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
167. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "32"
  ORDER BY `ordering`
168. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "33"
  ORDER BY `ordering`
169. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "34"
  ORDER BY `ordering`
170. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 11
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
171. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 3
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
172. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "35"
  ORDER BY `ordering`
173. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "36"
  ORDER BY `ordering`
174. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "37"
  ORDER BY `ordering`
175. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 4
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
176. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 10
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
177. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "38"
  ORDER BY `ordering`
178. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "39"
  ORDER BY `ordering`
179. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "40"
  ORDER BY `ordering`
180. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "41"
  ORDER BY `ordering`
181. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 9
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
182. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 1
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
183. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 2
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
184. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 5
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
185. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "42"
  ORDER BY `ordering`
186. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "43"
  ORDER BY `ordering`
187. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "44"
  ORDER BY `ordering`
188. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "45"
  ORDER BY `ordering`
189. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 46
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
190. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 47
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
191. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 48
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
192. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "49"
  ORDER BY `ordering`
193. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "50"
  ORDER BY `ordering`
194. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "51"
  ORDER BY `ordering`
195. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 52
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
196. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 53
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
197. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "54"
  ORDER BY `ordering`
198. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "55"
  ORDER BY `ordering`
199. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "56"
  ORDER BY `ordering`
200. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "57"
  ORDER BY `ordering`
201. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 58
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
202. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "59"
  ORDER BY `ordering`
203. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "61"
  ORDER BY `ordering`
204. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "70"
  ORDER BY `ordering`
205. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "60"
  ORDER BY `ordering`
206. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "67"
  ORDER BY `ordering`
207. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "62"
  ORDER BY `ordering`
208. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 66
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
209. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 63
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
210. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "71"
  ORDER BY `ordering`
211. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "64"
  ORDER BY `ordering`
212. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "69"
  ORDER BY `ordering`
213. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "65"
  ORDER BY `ordering`
214. SELECT `virtuemart_media_id`
  FROM `jqmso_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "72"
  ORDER BY `ordering`
215. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `jqmso_virtuemart_category_categories` AS `xref`
  WHERE `xref`.`category_child_id`= 14
216. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 21
217. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 21
218. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=21
219. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 20
220. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 20
221. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=20
222. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
223. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
224. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=19
225. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 22
226. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
227. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 22
228. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
229. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=19
230. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=22
231. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 23
232. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
233. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 23
234. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
235. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=19
236. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=23
237. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 24
238. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
239. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 24
240. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
241. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=19
242. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=24
243. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 25
244. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
245. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 25
246. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 19
247. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=19
248. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=25
249. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 18
250. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 18
251. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=18
252. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 17
253. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 17
254. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=17
255. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 26
256. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 17
257. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 26
258. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 17
259. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=17
260. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=26
261. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 27
262. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 17
263. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 27
264. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 17
265. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=17
266. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=27
267. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 28
268. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 17
269. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 28
270. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 17
271. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=17
272. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=28
273. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 16
274. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 16
275. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=16
276. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 15
277. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 15
278. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=15
279. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 29
280. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 14
281. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 29
282. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 14
283. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=14
284. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=29
285. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 30
286. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 14
287. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 30
288. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 14
289. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=14
290. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=30
291. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 31
292. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 14
293. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 31
294. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 14
295. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=14
296. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=31
297. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 13
298. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 13
299. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=13
300. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
301. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
302. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=12
303. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 32
304. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
305. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 32
306. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
307. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=12
308. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=32
309. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 33
310. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
311. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 33
312. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
313. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=12
314. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=33
315. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 34
316. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
317. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 34
318. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
319. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=12
320. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=34
321. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 11
322. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 11
323. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=11
324. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
325. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
326. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=3
327. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 35
328. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
329. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 35
330. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
331. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=3
332. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=35
333. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 36
334. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
335. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 36
336. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
337. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=3
338. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=36
339. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 37
340. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
341. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 37
342. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
343. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=3
344. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=37
345. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 4
346. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 4
347. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=4
348. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
349. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
350. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=10
351. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 38
352. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
353. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 38
354. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
355. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=10
356. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=38
357. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 39
358. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
359. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 39
360. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
361. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=10
362. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=39
363. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 40
364. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
365. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 40
366. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
367. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=10
368. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=40
369. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 41
370. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
371. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 41
372. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
373. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=10
374. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=41
375. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 9
376. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 9
377. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=9
378. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
379. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
380. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=1
381. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 2
382. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 2
383. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=2
384. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
385. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
386. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=5
387. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 42
388. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
389. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 42
390. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
391. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=5
392. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=42
393. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 43
394. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
395. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 43
396. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
397. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=5
398. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=43
399. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 44
400. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
401. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 44
402. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
403. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=5
404. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=44
405. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 45
406. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
407. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 45
408. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
409. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=5
410. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=45
411. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 46
412. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 46
413. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=46
414. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 47
415. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 47
416. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=47
417. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 48
418. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 48
419. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=48
420. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 49
421. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 48
422. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 49
423. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 48
424. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=48
425. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=49
426. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 50
427. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 48
428. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 50
429. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 48
430. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=48
431. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=50
432. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 51
433. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 48
434. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 51
435. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 48
436. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=48
437. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=51
438. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 52
439. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 52
440. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=52
441. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
442. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
443. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=53
444. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 54
445. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
446. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 54
447. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
448. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=53
449. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=54
450. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 55
451. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
452. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 55
453. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
454. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=53
455. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=55
456. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 56
457. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
458. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 56
459. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
460. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=53
461. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=56
462. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 57
463. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
464. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 57
465. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 53
466. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=53
467. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=57
468. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
469. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
470. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=58
471. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 59
472. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
473. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 59
474. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
475. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=58
476. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=59
477. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 61
478. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
479. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 61
480. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
481. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=58
482. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=61
483. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 70
484. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
485. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 70
486. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
487. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=58
488. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=70
489. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 60
490. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
491. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 60
492. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
493. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=58
494. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=60
495. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 67
496. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
497. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 67
498. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
499. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=58
500. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=67
501. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 62
502. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
503. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 62
504. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 58
505. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=58
506. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=62
507. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
508. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
509. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=63
510. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 71
511. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
512. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 71
513. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
514. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=63
515. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=71
516. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 64
517. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
518. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 64
519. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
520. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=63
521. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=64
522. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 69
523. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
524. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 69
525. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
526. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=63
527. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=69
528. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 65
529. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
530. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 65
531. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
532. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=63
533. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=65
534. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 72
535. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
536. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 72
537. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM jqmso_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 63
538. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=63
539. SELECT `slug` as name
  FROM `jqmso_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=72
540. SELECT *
  FROM jqmso_virtuemart_calcs
  WHERE `calc_kind`="DBTaxBill"
  AND `published`="1"
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-06-24 23:22:20" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-06-24 23:22:20" )
541. SELECT *
  FROM jqmso_virtuemart_calcs
  WHERE `calc_kind`="TaxBill"
  AND `published`="1"
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-06-24 23:22:20" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-06-24 23:22:20" )
542. SELECT *
  FROM jqmso_virtuemart_calcs
  WHERE `calc_kind`="DATaxBill"
  AND `published`="1"
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2019-06-24 23:22:20" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2019-06-24 23:22:20" )
543. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 22
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
544. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 23
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
545. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
546. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
547. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
548. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
549. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 28
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
550. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 29
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
551. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
552. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 31
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
553. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
554. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
555. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 34
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
556. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
557. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
558. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
559. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_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
560. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 39
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
561. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 40
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
562. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 41
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
563. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 42
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
564. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 43
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
565. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 44
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
566. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 45
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
567. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 49
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
568. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 50
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
569. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 51
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
570. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 54
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
571. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 55
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
572. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 56
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
573. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 57
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
574. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 59
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
575. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 61
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
576. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 70
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
577. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 60
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
578. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 67
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
579. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 62
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
580. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 71
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
581. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 64
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
582. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 69
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
583. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 65
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
584. SELECT L.*
  FROM `jqmso_virtuemart_categories_en_gb` as L JOIN `jqmso_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `jqmso_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 72
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
585. UPDATE `jqmso_session`
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1561418539;s:18:\"session.timer.last\";i:1561418539;s:17:\"session.timer.now\";i:1561418539;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\":2:{s:8:\"category\";O:8:\"stdClass\":2:{s:5:\"
  limit\";s:3:\"int\";s:10:\"limitstart\";i:0;}s:11:\"categoryc14\";O:8:\"stdClass\":1:{s:5:\"
  limit\";s:3:\"int\";}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}__vm|a:3:{s:6:\"vmcart\";s:572:\"O:8:\"stdClass\":22:{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:17:\"pricesUnformatted\";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:14;s:19:\"vmlastvisitedmanuid\";i:0;}' , `time` = '1561418541'
  WHERE `session_id` = '7ffe071cb6bcc3750bafa3daee587c77'