163 Queries Logged

1. SELECT `data`
  FROM `josnj_session`
  WHERE `session_id` = '14a80d405d8de27d1c1aad77319ab7dd'
2. SELECT folder AS type, element AS name, params
  FROM josnj_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
3. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
4. 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 josnj_menu AS m
  LEFT JOIN josnj_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
5. SHOW TABLES LIKE "%virtuemart_configs%"
6. SELECT `config`
  FROM `josnj_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
7. SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `josnj_virtuemart_permgroups`
  ORDER BY `group_level`
8. SELECT *
  FROM josnj_languages
  WHERE published=1
  ORDER BY ordering ASC
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_virtuemart'
10. SELECT *
  FROM `josnj_menu`
  where `link` like "index.php?option=com_virtuemart%"
  and client_id=0
  and published=1
  and (language="*" or language="en_gb")
11. SELECT `virtuemart_manufacturer_id`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE `slug` LIKE 'red-lion'
12. SELECT id, home, template, s.params
  FROM josnj_template_styles as s
  LEFT JOIN josnj_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
13. SELECT manifest_cache
  FROM josnj_extensions
  WHERE element LIKE 'jsn_epic_free'
14. SELECT COUNT(*)
  FROM josnj_extensions
  WHERE type = 'component'
  AND element = 'com_sh404sef'
15. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_menus'
16. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "0"
  ORDER BY `ordering`
17. SELECT `category_child_id`
  FROM `josnj_virtuemart_category_categories`
  WHERE `category_parent_id` = 0
18. 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 `josnj_virtuemart_categories_en_gb` l JOIN `josnj_virtuemart_categories` AS c using (`virtuemart_category_id`)
  LEFT JOIN `josnj_virtuemart_category_categories` AS cx
  ON l.`virtuemart_category_id` = cx.`category_child_id`
  WHERE c.`published` = 1
  AND cx.`category_parent_id` = 0
  AND (c.`virtuemart_vendor_id` = "1" OR c.`shared` = "1")
  ORDER BY category_name ASC
  LIMIT 0, 20
19. SELECT FOUND_ROWS()
20. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_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
21. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "13"
  ORDER BY `ordering`
22. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "4"
  ORDER BY `ordering`
23. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "1"
  ORDER BY `ordering`
24. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "5"
  ORDER BY `ordering`
25. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "6"
  ORDER BY `ordering`
26. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "7"
  ORDER BY `ordering`
27. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "8"
  ORDER BY `ordering`
28. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "9"
  ORDER BY `ordering`
29. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "10"
  ORDER BY `ordering`
30. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "11"
  ORDER BY `ordering`
31. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "12"
  ORDER BY `ordering`
32. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "83"
33. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "82"
34. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "81"
35. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "80"
36. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "79"
37. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "78"
38. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "77"
39. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "76"
40. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "75"
41. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "74"
42. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 0
43. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_vmuser_shoppergroups`
  WHERE `virtuemart_user_id` = "0"
44. SELECT *
  FROM `josnj_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
45. SELECT `virtuemart_userinfo_id`
  FROM `josnj_virtuemart_userinfos`
  WHERE `virtuemart_user_id` = "0"
46. SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
  FROM `josnj_virtuemart_products_en_gb` as l JOIN `josnj_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `josnj_virtuemart_product_categories` as pc
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_categories_en_gb` as c
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
  LEFT JOIN `josnj_virtuemart_product_manufacturers`
  ON p.`virtuemart_product_id` = `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_manufacturers_en_gb` as m
  ON m.`virtuemart_manufacturer_id` = `josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
  LEFT JOIN `josnj_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `josnj_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `josnj_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `josnj_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
  WHERE ( p.`published`="1"
  AND `pc`.`virtuemart_category_id` > 0
  AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL )
  AND `josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = 9)
  group by p.`virtuemart_product_id`
  ORDER BY `category_name` DESC
  LIMIT 0, 9
47. SELECT FOUND_ROWS()
48. SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `josnj_virtuemart_product_manufacturers`
  on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_product_customfields`
  on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "61"
49. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "61"
  ORDER BY `ordering`
50. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "61"
51. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "61"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:52" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:52" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
52. SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
  FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "9"
53. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 61
54. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "61"
  and `virtuemart_category_id`= "10"
55. SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
  FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
  WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "10"
56. SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
  FROM `josnj_virtuemart_vendors` AS v
  LEFT JOIN `josnj_virtuemart_currencies` AS c
  ON virtuemart_currency_id = vendor_currency
  WHERE v.`virtuemart_vendor_id`="1"
57. SELECT *
  FROM `josnj_virtuemart_currencies`
  WHERE `virtuemart_currency_id`="65"
58. SELECT `price_display`,`custom_price_display`
  FROM `josnj_virtuemart_shoppergroups` AS `sg`
  WHERE `sg`.`default` = "2"
59. SELECT *
  FROM `josnj_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
60. SELECT *
  FROM josnj_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 <= "2025-08-05 21:35:52" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-08-05 21:35:52" ) OR `for_override` = "1" )
61. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
62. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=10
63. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 61
64. SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `josnj_virtuemart_product_manufacturers`
  on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_product_customfields`
  on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "62"
65. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "62"
  ORDER BY `ordering`
66. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "62"
67. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "62"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:52" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:52" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
68. SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
  FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "9"
69. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 62
70. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "62"
  and `virtuemart_category_id`= "10"
71. SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
  FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
  WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "10"
72. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 62
73. SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `josnj_virtuemart_product_manufacturers`
  on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_product_customfields`
  on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "59"
74. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "59"
  ORDER BY `ordering`
75. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "59"
76. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "59"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:52" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:52" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
77. SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
  FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "9"
78. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 59
79. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "59"
  and `virtuemart_category_id`= "10"
80. SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
  FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
  WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "10"
81. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 59
82. SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `josnj_virtuemart_product_manufacturers`
  on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_product_customfields`
  on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
  WHERE josnj_virtuemart_products_en_gb.`virtuemart_product_id` = "60"
83. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "60"
  ORDER BY `ordering`
84. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "60"
85. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "60"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-08-05 21:35:52" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-08-05 21:35:52" ) )
  AND( (`price_quantity_start` IS NULL OR `price_quantity_start`="0" OR `price_quantity_start` <= 1)
  AND (`price_quantity_end` IS NULL OR `price_quantity_end`="0" OR `price_quantity_end` >= 1) )
86. SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
  FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
  WHERE josnj_virtuemart_manufacturers_en_gb.`virtuemart_manufacturer_id` = "9"
87. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 60
88. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "60"
  and `virtuemart_category_id`= "10"
89. SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
  FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
  WHERE josnj_virtuemart_categories_en_gb.`virtuemart_category_id` = "10"
90. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 60
91. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "61"
92. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "62"
93. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "59"
94. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "60"
95. SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
  FROM `josnj_virtuemart_manufacturers_en_gb` as l JOIN `josnj_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
  LEFT JOIN `josnj_virtuemart_products` as p
  ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_product_categories` as c
  ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`
  WHERE p.`published` =1
  ORDER BY l.`mf_name`
96. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=12
97. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=2
98. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
99. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=3
100. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=4
101. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
102. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=6
103. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=7
104. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
105. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=10
106. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=11
107. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
108. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
109. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
110. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 13
111. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=13
112. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 4
113. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=4
114. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
115. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=1
116. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
117. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=5
118. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 6
119. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=6
120. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 7
121. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=7
122. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 8
123. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=8
124. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 9
125. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=9
126. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 11
127. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=11
128. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
129. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=12
130. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
131. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
132. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
133. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
134. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
135. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
136. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
137. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
138. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
139. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM josnj_modules AS m
  LEFT JOIN josnj_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN josnj_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 <= '2025-08-05 21:35:52')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-08-05 21:35:52')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 0 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
140. SELECT m.id
  FROM josnj_modules AS m
  INNER JOIN josnj_modules_menu AS mm
  ON mm.moduleid = m.id
  WHERE m.client_id = 0
  AND m.published = 1
  AND m.module LIKE 'mod_k2_%'
  AND (mm.menuid < 0
  AND mm.menuid = 0)
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
141. SELECT m.id
  FROM josnj_modules AS m
  INNER JOIN josnj_modules_menu AS mm
  ON mm.moduleid = m.id
  WHERE m.client_id = 0
  AND m.published = 1
  AND m.module LIKE 'mod_k2_%'
  AND (mm.menuid = 0 OR mm.menuid = 0 OR (mm.menuid < 0
  AND mm.menuid != 0))
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
  GROUP BY m.id
142. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
143. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_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
144. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_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
145. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_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
146. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "2"
  ORDER BY `ordering`
147. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "3"
  ORDER BY `ordering`
148. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_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
149. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 6
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
150. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 7
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
151. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
  WHERE CC.`category_parent_id` = 8
  AND C.`virtuemart_vendor_id` = 1
  AND C.`published` = 1
  ORDER BY C.`ordering`, L.`category_name` ASC
152. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_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
153. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_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
154. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_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
155. SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_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
156. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `josnj_virtuemart_category_categories` AS `xref`
  WHERE `xref`.`category_child_id`= 0
157. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 2
158. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
159. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=2
160. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
161. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
162. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=3
163. UPDATE `josnj_session`
  SET `data` = 'A2O9rwiWvQK68y_tIHt668Q3w9hfKUS6qpXlI9w3skD_601GziSkL1ll9yIl2lgps8WK-EIKXUXo1iJlVWvcprC-boKZELiCJhCT1-Z6kWzS9Y31iaoJ8Nf-tEXXuCnKHl3mIzhXr_XDbWzLoJ_iTfeDqUiduo_CEyXDvyV22LIAgxSg9317iM_P2d9gGNqAvCELxC5ego5QgZYGfPtwA34QgXY5-09qhons2VV3bDEzL0igQFmCB8JLmyu2enPzbyvpIBl1ScrjO64cXkZfoZSbEJ2X5Q1S38xQIUJqBCPJE_3yeqU6qlRPYn6ODM_Ve_5Y7sbyjqh2eHGhF_i2XiaomiH5CPr5wYBPrVBwXFy29Xd2UZ7FZg02EDSXQE47ceImHJvatnoQtCq-cECtQf2oC-F6JB4c7NhgNazUNK8kZqGuxI7hl2sw-7PourGgc68yr_zOgZHhcmedcT4zkxhQ29IHYgveEO5uTVmxs52HLvE2LWwgh6lBJio9xGvUA0nnv-6umuycWt37y2LSKm6q2e-ndLj9GOI9c4IhQ3QYPCCTBNDb8ibunZQtJWJ2XIihvrCP3RLM1Pse5L-26HyqWxuO-Hs3GVUybhftHjQUGz0uHaUpNl2u9CrpiW-EZ0G1SslJ74-9Z-1WqSA4-p43op4Dc3Itl_Jkx3keE9aC52hx2ty-4OPsqkQIfNJUjG2PCJilPiOPTGZn3O3kzgL34NygQfVNa9yRoGpo-FnnhzXxyAjJ18ZI00UterPnHODW5RSGXfGSq0SnzIsMOm6vIQb3V4HEwnf8uOJOSrVN_HOQlYRPcehy38W0OnCjZEFwJ9XR9KONIDf-41n9azFVoWS0SU2WpnOKqzeoTr4TuPb2f_qFY4nZ4K18OniPamxrjTvLAnfFJW9IVCsP5alifBsITCt2g36puTC6UroW1NgYbK6Db4_1CbTwHqtKmYtuk-F0PHbyAFHOrnVARLRhehGp6qYzXNNPGpHdIfe_kgCKxPQmx3qNMQWoa0qS4xnza5tCQgvBpTvEvXP77mbyDnrqJmmofaXSQV90hGQIcclcWVT6WJl-GPWFIfGZ8szgD_mrfnZPW1RmzCQO6c7lQPjv1ehtT0b42MdKbgmnhMPqWtAwcGvD0VHXVFn2A0Z8bymEHn3cJIy43MAqviLTMeA4iWmiURVy1w2PDbEz78BlKesUjMKjunT6Y6qkJDf7Z4tZJmU3pBys_bRB0r8ExoTZ2lRepowwcQI4Jdcw0MWrnv_o4pXfa5b9mzGJQM9aOyh-XEv3JLCt9iP3QUW0E6MT6k_i49ypjE_nN8PVUkKmQTYRcX8ZW2SVGC3LHDEDVfNdF_tphPRyA5Zxn569KjDRso4Sl2RgTY7CRr_NwDl88pZov9CTZLuUlMCPS6Efpcp96vq2D6Ie-DnVqcCG6dpxDgFYqdv2cbLV6zTYjcezZS715ubDyPKl5vagA5dhe7FjhSLcANT0FuQg_00Sgt2WW8P0oxedDIFhyqQYwQdyE8URBKYHGuQs2ANAkIhfWHKT96L8VL-LXrEHpIdKf8x22600hkXkfNrGuC5gewwO7luZzu9QPotdBWX1Xx6K-KfUiN7k-5kXGMBNpczTgMsYmuugAckkr0yIaijqZr82p1NYQqvBCLyrkBfd_6fd8Z8hb1x7DPAPWc0Wv1Mrbqmr4p0iedKce1VCxk7OKjehmJKt_yBqz6MD0wpWeHYT8DpKLF58t1cJ2tkKNc-WKMJr0fW5SFdBvW_D8MrpN6ntaejIJwctaKS3k_zoM2RHqHgXp9EwI_tOjoUNbVf0JNRClS6l7VjLgGzyWnTwYBX848gcPnklsTEnm7x7UVkejkR4qN3kCfmPhgk0TCezPVWGbCg_yu9GiFF_CjacWimPNG13lAFVdrj7ko7tnA2koenRKqIAVqzPwQrHWfzClKZCoHIeb_FcJ1BAPfiLo5pLtBzgOKMUwX4n9qjOsMWISeX9MVSulM__SmpmcwF4vwRrXWOIAvMqqU9dBEo4m06Jbh5Maw-NhwY1LhSYi0tmWljIWq6aEzGtfHElZ0vR2e_iVcDTrg4q24HuYYIj1zEGjwHgCw7m6E5I1Smr4MjFx_l9NyonW3Bo8c8LxCC7yWoA1o1zuYRxogRNCGw0VayKO4D26eCs0VIiWh4yZtRqITXEZOhag52hlfAd6bczEr10QbBzl5qJUZiMwjuJuDW7wgCnAXYnSRXhyMGjwCheOttS9eWUfKg83REBAn8fc7AnAAh3YKsfzY3-QaJoUhuiN9bho-7n8yj19Vfs5mPutGRdb4DHkKtSylJIjKQBTQtU27sF3QNujDDE_dNSpoFGYOveCGQV6-G2tsjitQDJoNftl4p9rts6JrTC2Q..' , `time` = '1754429752'
  WHERE `session_id` = '14a80d405d8de27d1c1aad77319ab7dd'

44 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 23 × SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
2. 16 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
3. 14 × SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
4. 14 × SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
5. 13 × SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
6. 12 × SELECT L.*
  FROM `josnj_virtuemart_categories_en_gb` as L JOIN `josnj_virtuemart_categories` as C using (`virtuemart_category_id`)
  LEFT JOIN `josnj_virtuemart_category_categories` as CC
  on C.`virtuemart_category_id` = CC.`category_child_id`
7. 4 × SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
8. 4 × SELECT `josnj_virtuemart_products_en_gb`.* ,`josnj_virtuemart_products`.* ,`josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`josnj_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `josnj_virtuemart_products_en_gb` JOIN josnj_virtuemart_products using (`virtuemart_product_id`)
  LEFT JOIN `josnj_virtuemart_product_manufacturers`
  on `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_product_customfields`
  on `josnj_virtuemart_product_customfields`.`virtuemart_product_id`=`josnj_virtuemart_products_en_gb`.`virtuemart_product_id`
9. 4 × SELECT *
  FROM `josnj_virtuemart_product_prices`
10. 4 × SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
11. 4 × SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
12. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
13. 4 × SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
14. 4 × SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
  FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
15. 4 × SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
  FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
16. 4 × SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
17. 2 × SELECT m.id
  FROM josnj_modules AS m
  INNER JOIN josnj_modules_menu AS mm
  ON mm.moduleid = m.id
18. 2 × SELECT *
  FROM `josnj_virtuemart_shoppergroups`
19. 2 × SELECT FOUND_ROWS(
20. 1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `josnj_virtuemart_permgroups`
21. 1 × SELECT *
  FROM josnj_virtuemart_calcs
22. 1 × SELECT *
  FROM `josnj_virtuemart_currencies`
23. 1 × SELECT `config`
  FROM `josnj_virtuemart_configs`
24. 1 × SELECT `price_display`,`custom_price_display`
  FROM `josnj_virtuemart_shoppergroups` AS `sg`
25. 1 × SELECT DISTINCT l.`mf_name`,l.`virtuemart_manufacturer_id`
  FROM `josnj_virtuemart_manufacturers_en_gb` as l JOIN `josnj_virtuemart_product_manufacturers` AS pm using (`virtuemart_manufacturer_id`)
  LEFT JOIN `josnj_virtuemart_products` as p
  ON p.`virtuemart_product_id` = pm.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_product_categories` as c
  ON c.`virtuemart_product_id` = pm.`virtuemart_product_id`
26. 1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `josnj_virtuemart_category_categories` AS `xref`
27. 1 × SELECT folder AS type, element AS name, params
  FROM josnj_extensions
28. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM josnj_modules AS m
  LEFT JOIN josnj_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN josnj_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
29. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM josnj_menu AS m
  LEFT JOIN josnj_extensions AS e
  ON m.component_id = e.extension_id
30. 1 × SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
  FROM `josnj_virtuemart_vendors` AS v
  LEFT JOIN `josnj_virtuemart_currencies` AS c
  ON virtuemart_currency_id = vendor_currency
31. 1 × SELECT *
  FROM `josnj_menu`
32. 1 × SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id`
  FROM `josnj_virtuemart_products_en_gb` as l JOIN `josnj_virtuemart_products` AS p using (`virtuemart_product_id`)
  LEFT JOIN `josnj_virtuemart_product_categories` as pc
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_categories_en_gb` as c
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`
  LEFT JOIN `josnj_virtuemart_product_manufacturers`
  ON p.`virtuemart_product_id` = `josnj_virtuemart_product_manufacturers`.`virtuemart_product_id`
  LEFT JOIN `josnj_virtuemart_manufacturers_en_gb` as m
  ON m.`virtuemart_manufacturer_id` = `josnj_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id`
  LEFT JOIN `josnj_virtuemart_product_shoppergroups`
  ON p.`virtuemart_product_id` = `josnj_virtuemart_product_shoppergroups`.`virtuemart_product_id`
  LEFT
  OUTER JOIN `josnj_virtuemart_shoppergroups` as s
  ON s.`virtuemart_shoppergroup_id` = `josnj_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id`
33. 1 × SELECT `virtuemart_userinfo_id`
  FROM `josnj_virtuemart_userinfos`
34. 1 × SELECT `data`
  FROM `josnj_session`
35. 1 × SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_vmuser_shoppergroups`
36. 1 × 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 `josnj_virtuemart_categories_en_gb` l JOIN `josnj_virtuemart_categories` AS c using (`virtuemart_category_id`)
  LEFT JOIN `josnj_virtuemart_category_categories` AS cx
  ON l.`virtuemart_category_id` = cx.`category_child_id`
37. 1 × SELECT `category_child_id`
  FROM `josnj_virtuemart_category_categories`
38. 1 × SELECT `virtuemart_manufacturer_id`
  FROM `josnj_virtuemart_manufacturers_en_gb`
39. 1 × SELECT id, home, template, s.params
  FROM josnj_template_styles as s
  LEFT JOIN josnj_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
40. 1 × SELECT manifest_cache
  FROM josnj_extensions
41. 1 × SELECT COUNT(*)
  FROM josnj_extensions
42. 1 × SELECT *
  FROM josnj_languages

OTHER Tables:

1. 1 × UPDATE `josnj_session`
  SET `data` = 'A2O9rwiWvQK68y_tIHt668Q3w9hfKUS6qpXlI9w3skD_601GziSkL1ll9yIl2lgps8WK-EIKXUXo1iJlVWvcprC-boKZELiCJhCT1-Z6kWzS9Y31iaoJ8Nf-tEXXuCnKHl3mIzhXr_XDbWzLoJ_iTfeDqUiduo_CEyXDvyV22LIAgxSg9317iM_P2d9gGNqAvCELxC5ego5QgZYGfPtwA34QgXY5-09qhons2VV3bDEzL0igQFmCB8JLmyu2enPzbyvpIBl1ScrjO64cXkZfoZSbEJ2X5Q1S38xQIUJqBCPJE_3yeqU6qlRPYn6ODM_Ve_5Y7sbyjqh2eHGhF_i2XiaomiH5CPr5wYBPrVBwXFy29Xd2UZ7FZg02EDSXQE47ceImHJvatnoQtCq-cECtQf2oC-F6JB4c7NhgNazUNK8kZqGuxI7hl2sw-7PourGgc68yr_zOgZHhcmedcT4zkxhQ29IHYgveEO5uTVmxs52HLvE2LWwgh6lBJio9xGvUA0nnv-6umuycWt37y2LSKm6q2e-ndLj9GOI9c4IhQ3QYPCCTBNDb8ibunZQtJWJ2XIihvrCP3RLM1Pse5L-26HyqWxuO-Hs3GVUybhftHjQUGz0uHaUpNl2u9CrpiW-EZ0G1SslJ74-9Z-1WqSA4-p43op4Dc3Itl_Jkx3keE9aC52hx2ty-4OPsqkQIfNJUjG2PCJilPiOPTGZn3O3kzgL34NygQfVNa9yRoGpo-FnnhzXxyAjJ18ZI00UterPnHODW5RSGXfGSq0SnzIsMOm6vIQb3V4HEwnf8uOJOSrVN_HOQlYRPcehy38W0OnCjZEFwJ9XR9KONIDf-41n9azFVoWS0SU2WpnOKqzeoTr4TuPb2f_qFY4nZ4K18OniPamxrjTvLAnfFJW9IVCsP5alifBsITCt2g36puTC6UroW1NgYbK6Db4_1CbTwHqtKmYtuk-F0PHbyAFHOrnVARLRhehGp6qYzXNNPGpHdIfe_kgCKxPQmx3qNMQWoa0qS4xnza5tCQgvBpTvEvXP77mbyDnrqJmmofaXSQV90hGQIcclcWVT6WJl-GPWFIfGZ8szgD_mrfnZPW1RmzCQO6c7lQPjv1ehtT0b42MdKbgmnhMPqWtAwcGvD0VHXVFn2A0Z8bymEHn3cJIy43MAqviLTMeA4iWmiURVy1w2PDbEz78BlKesUjMKjunT6Y6qkJDf7Z4tZJmU3pBys_bRB0r8ExoTZ2lRepowwcQI4Jdcw0MWrnv_o4pXfa5b9mzGJQM9aOyh-XEv3JLCt9iP3QUW0E6MT6k_i49ypjE_nN8PVUkKmQTYRcX8ZW2SVGC3LHDEDVfNdF_tphPRyA5Zxn569KjDRso4Sl2RgTY7CRr_NwDl88pZov9CTZLuUlMCPS6Efpcp96vq2D6Ie-DnVqcCG6dpxDgFYqdv2cbLV6zTYjcezZS715ubDyPKl5vagA5dhe7FjhSLcANT0FuQg_00Sgt2WW8P0oxedDIFhyqQYwQdyE8URBKYHGuQs2ANAkIhfWHKT96L8VL-LXrEHpIdKf8x22600hkXkfNrGuC5gewwO7luZzu9QPotdBWX1Xx6K-KfUiN7k-5kXGMBNpczTgMsYmuugAckkr0yIaijqZr82p1NYQqvBCLyrkBfd_6fd8Z8hb1x7DPAPWc0Wv1Mrbqmr4p0iedKce1VCxk7OKjehmJKt_yBqz6MD0wpWeHYT8DpKLF58t1cJ2tkKNc-WKMJr0fW5SFdBvW_D8MrpN6ntaejIJwctaKS3k_zoM2RHqHgXp9EwI_tOjoUNbVf0JNRClS6l7VjLgGzyWnTwYBX848gcPnklsTEnm7x7UVkejkR4qN3kCfmPhgk0TCezPVWGbCg_yu9GiFF_CjacWimPNG13lAFVdrj7ko7tnA2koenRKqIAVqzPwQrHWfzClKZCoHIeb_FcJ1BAPfiLo5pLtBzgOKMUwX4n9qjOsMWISeX9MVSulM__SmpmcwF4vwRrXWOIAvMqqU9dBEo4m06Jbh5Maw-NhwY1LhSYi0tmWljIWq6aEzGtfHElZ0vR2e_iVcDTrg4q24HuYYIj1zEGjwHgCw7m6E5I1Smr4MjFx_l9NyonW3Bo8c8LxCC7yWoA1o1zuYRxogRNCGw0VayKO4D26eCs0VIiWh4yZtRqITXEZOhag52hlfAd6bczEr10QbBzl5qJUZiMwjuJuDW7wgCnAXYnSRXhyMGjwCheOttS9eWUfKg83REBAn8fc7AnAAh3YKsfzY3-QaJoUhuiN9bho-7n8yj19Vfs5mPutGRdb4DHkKtSylJIjKQBTQtU27sF3QNujDDE_dNSpoFGYOveCGQV6-G2tsjitQDJoNftl4p9rts6JrTC2Q..' , `time` = '1754429752'
2. 1 × SHOW TABLES LIKE "%virtuemart_configs%