234 Queries Logged

1. SELECT `data`
  FROM `josnj_session`
  WHERE `session_id` = '14a80d405d8de27d1c1aad77319ab7dd'
2. DELETE
  FROM `josnj_session`
  WHERE `time` < '1754428851'
3. SELECT `session_id`
  FROM `josnj_session`
  WHERE `session_id` = '14a80d405d8de27d1c1aad77319ab7dd'
  LIMIT 0, 1
4. INSERT INTO `josnj_session` (`session_id`, `client_id`, `time`)
  VALUES ('14a80d405d8de27d1c1aad77319ab7dd', 0, '1754429751')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM josnj_usergroups AS a
  LEFT JOIN josnj_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `josnj_viewlevels`
8. 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
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_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 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
11. SHOW TABLES LIKE "%virtuemart_configs%"
12. SELECT `config`
  FROM `josnj_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
13. SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `josnj_virtuemart_permgroups`
  ORDER BY `group_level`
14. SELECT *
  FROM josnj_languages
  WHERE published=1
  ORDER BY ordering ASC
15. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_virtuemart'
16. 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")
17. SELECT `virtuemart_manufacturer_id`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE `slug` LIKE 'hengstler'
18. 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
19. SELECT manifest_cache
  FROM josnj_extensions
  WHERE element LIKE 'jsn_epic_free'
20. SELECT COUNT(*)
  FROM josnj_extensions
  WHERE type = 'component'
  AND element = 'com_sh404sef'
21. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_menus'
22. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "0"
  ORDER BY `ordering`
23. SELECT `category_child_id`
  FROM `josnj_virtuemart_category_categories`
  WHERE `category_parent_id` = 0
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 `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
25. SELECT FOUND_ROWS()
26. 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
27. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "13"
  ORDER BY `ordering`
28. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "4"
  ORDER BY `ordering`
29. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "1"
  ORDER BY `ordering`
30. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "5"
  ORDER BY `ordering`
31. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "6"
  ORDER BY `ordering`
32. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "7"
  ORDER BY `ordering`
33. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "8"
  ORDER BY `ordering`
34. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "9"
  ORDER BY `ordering`
35. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "10"
  ORDER BY `ordering`
36. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "11"
  ORDER BY `ordering`
37. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "12"
  ORDER BY `ordering`
38. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "83"
39. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "82"
40. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "81"
41. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "80"
42. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "79"
43. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "78"
44. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "77"
45. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "76"
46. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "75"
47. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "74"
48. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 0
49. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_vmuser_shoppergroups`
  WHERE `virtuemart_user_id` = "0"
50. SELECT *
  FROM `josnj_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
51. SELECT `virtuemart_userinfo_id`
  FROM `josnj_virtuemart_userinfos`
  WHERE `virtuemart_user_id` = "0"
52. 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` = 1)
  group by p.`virtuemart_product_id`
  ORDER BY `category_name` DESC
  LIMIT 0, 9
53. SELECT FOUND_ROWS()
54. 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` = "1"
55. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1"
  ORDER BY `ordering`
56. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1"
57. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1"
  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:51" )
  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:51" ) )
  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) )
58. 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` = "1"
59. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1
60. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 1
  AND `published`=1
61. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "1"
  and `virtuemart_category_id`= "1"
62. 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` = "1"
63. 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"
64. SELECT *
  FROM `josnj_virtuemart_currencies`
  WHERE `virtuemart_currency_id`="65"
65. SELECT `price_display`,`custom_price_display`
  FROM `josnj_virtuemart_shoppergroups` AS `sg`
  WHERE `sg`.`default` = "2"
66. SELECT *
  FROM `josnj_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
67. 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:51" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-08-05 21:35:51" ) OR `for_override` = "1" )
68. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
69. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=1
70. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 1
71. 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` = "14"
72. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "14"
  ORDER BY `ordering`
73. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "14"
74. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "14"
  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:51" )
  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:51" ) )
  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) )
75. 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` = "1"
76. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 14
77. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 14
  AND `published`=1
78. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "14"
  and `virtuemart_category_id`= "1"
79. 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` = "1"
80. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 14
81. 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` = "8"
82. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "8"
  ORDER BY `ordering`
83. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "8"
84. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "8"
  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:51" )
  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:51" ) )
  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) )
85. 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` = "1"
86. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 8
87. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 8
  AND `published`=1
88. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "8"
  and `virtuemart_category_id`= "1"
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` = "1"
90. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 8
91. 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` = "2"
92. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "2"
  ORDER BY `ordering`
93. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "2"
94. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "2"
  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:51" )
  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:51" ) )
  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) )
95. 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` = "1"
96. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 2
97. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 2
  AND `published`=1
98. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "2"
  and `virtuemart_category_id`= "1"
99. 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` = "1"
100. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 2
101. 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` = "9"
102. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "9"
  ORDER BY `ordering`
103. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "9"
104. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "9"
  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:51" )
  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:51" ) )
  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) )
105. 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` = "1"
106. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 9
107. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 9
  AND `published`=1
108. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "9"
  and `virtuemart_category_id`= "1"
109. 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` = "1"
110. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 9
111. 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` = "3"
112. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3"
  ORDER BY `ordering`
113. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3"
114. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3"
  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:51" )
  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:51" ) )
  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) )
115. 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` = "1"
116. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3
117. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 3
  AND `published`=1
118. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "3"
  and `virtuemart_category_id`= "1"
119. 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` = "1"
120. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 3
121. 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` = "10"
122. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "10"
  ORDER BY `ordering`
123. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "10"
124. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "10"
  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:51" )
  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:51" ) )
  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) )
125. 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` = "1"
126. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 10
127. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 10
  AND `published`=1
128. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "10"
  and `virtuemart_category_id`= "1"
129. 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` = "1"
130. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 10
131. 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` = "4"
132. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4"
  ORDER BY `ordering`
133. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4"
134. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4"
  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:51" )
  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:51" ) )
  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) )
135. 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` = "1"
136. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4
137. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 4
  AND `published`=1
138. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "4"
  and `virtuemart_category_id`= "1"
139. 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` = "1"
140. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 4
141. 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` = "11"
142. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "11"
  ORDER BY `ordering`
143. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "11"
144. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "11"
  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:51" )
  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:51" ) )
  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) )
145. 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` = "1"
146. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 11
147. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 11
  AND `published`=1
148. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "11"
  and `virtuemart_category_id`= "1"
149. 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` = "1"
150. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 11
151. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "1"
152. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "14"
153. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "8"
154. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "2"
155. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "9"
156. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "3"
157. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "10"
158. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "4"
159. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "11"
160. 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`
161. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=12
162. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=2
163. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
164. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=3
165. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=4
166. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
167. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=6
168. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=7
169. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
170. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=10
171. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=11
172. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
173. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
174. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
175. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 13
176. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=13
177. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 4
178. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=4
179. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
180. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=5
181. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 6
182. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=6
183. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 7
184. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=7
185. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 8
186. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=8
187. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 9
188. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=9
189. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
190. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=10
191. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 11
192. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=11
193. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
194. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=12
195. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
196. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
197. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
198. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
199. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
200. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
201. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
202. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
203. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
204. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
205. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
206. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
207. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
208. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
209. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
210. 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:51')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-08-05 21:35:51')
  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
211. 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")
212. 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
213. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
214. 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
215. 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
216. 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
217. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "2"
  ORDER BY `ordering`
218. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "3"
  ORDER BY `ordering`
219. 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
220. 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
221. 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
222. 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
223. 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
224. 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
225. 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
226. 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
227. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `josnj_virtuemart_category_categories` AS `xref`
  WHERE `xref`.`category_child_id`= 0
228. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 2
229. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
230. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=2
231. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
232. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
233. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=3
234. UPDATE `josnj_session`
  SET `data` = 'DOctTTh6fTVVovQ44gtwTBG_dw4VhJKRDRGP7-dWBya_YvGgO7B34IBG4U5jVkC3mEsfYNC1PXOfWUXctt7wBjeiYK5HEybVwJoyLa51bYLzHwoeHy5-oaXObE0BoPAvIqnwby96ojA5m4h4cFVeEI6pTdVCAcBGg0ShJl9DL7U0GK0V7LdlN8eXIh4xE4O5Fbn4mwQllymJo-XK1C6SdPvtYmKKrjD9L1hNknAxf-UCjKOVWrU7VZwuDvD5-28J-zooJexC02_C48_53bntr_ZjjEvS_XTDBfb8lWgbT0np4jrBEH-szgtZlUgvTE46KsMAQv-vgU8FY_KTo2VpmRUiyL9NLaEcgEUGkVohanl8TwOu81ZmnuxQtoN89m-toYc_4qDDejjVrDHExAulb_aGqQnQ-wYq4a8OdYViODB09c9AcwzP3DL90WvFZ2x1a6VlR53lDY1yi_97N6WIO_8EV2leVAEMtcU_5rZNbGv9q0Hm3Cbk0i_F__cT9KGr_PGcbv67k3R7Ak6mMJdKpIfU6mPWKxH4BoqxJKZ4jFE_eJ0UXHnmHevR5fY2m9lNirxOnCwe9ay8jUmDqD2ZRBiQNBmwaiP0ba9QvGvby-pcvCnN3cJAEVaMjqPn0_slfw7pKC7lBD28smZqoMYlpnqnbBrFUjaBr-AdXOzB8zz86LRH4V-pr1MX_EI6qRMEp_D-wQxJ0MaKIftgrDoq9FK51Q6aq1g2vq91c14N87utWgqwAEYSq3kWaSIucyInRf-QAZPNh_3DwEGYt5ei5wxa5ovi82cQx07CDoakFEi027pybfp9s-OXu4wpCyjNcxO-n3JMXfePLyRTnZkZDmTwfaNL0l0qdPRanl8--gH0ESEdfc0t-LS-LzJ6nuldX2i035wMVqa_NmNBfOBIV0rNxt-o216I3zeGsZzMO3qQqg2SKUZx12l04Q6FbOCY0cjYLXvknGoLnNNgEaNXvBBVPKSr9RbBMAd9dYF1rM9UQsGxLBmCIkenK5GQ0EON6PahT8nvqk61h3g3Eroo4OmIdYYlxRoh0wpzdv-M5HNgoUtFPnwcUjVnnC5mMMrlKowTE_5XKa61KtrV1K_ve6zefHpRu8yJobtDAn98qhgcENg3rg1n8_tgH5YUFA3XPchMHLTC2i4OUXNp5p9hwSNySm0hoGYqcS7UbucjnCAFJiEe-qvvL7Hi3eghm6OtAofNwdl8C-AhGlC4MKDVjFPI5BfrqFEnVaKMVfM8mJox1iCF46mY6-FCP4sDZDuiJ5N0j_a_L20ktDQdGBuyfBfFBH981aZYdAfMpf_iViJAi6SVxeetHk5n7d--gSh_LYcLGswhQih7HsFiASicif_VgWzgl2fz0AZdSzt6G2jBHauP0SmiJTu3rmqsnutqtQX1QRFslAm-OU1PaiFIJ1pS-34vFryl-wIuj2a_YqY6Tvwv8mm35ZSnKFIbU9UzfqRbXXATib89tn6K3sa_Dp_Sth4Dtpbl63F8m-dibEYJaXWFcCiqR7evIlkDN0N2N3a42eWidw1FKCr78RJRllco0fiXcj6F_4CPK3gbkJEGM3eWOBGFmbVkNcDV6hFyY6js9gZP9tjdPRTyT28urE9rV5iajtbHGZJ6KrkSwt1eUA1PJu6lCwe4W3ytoBM-grrfGCRP6nI02NI40gJftQ_3v2yvw05vx4SVRD4ODGlHv72g8HbaSLnyCeLYNZChFlB3He4azg6Aj_YrtUM8fZ1R3WVclS3yPTWQtvpKixMXaKYPP4TJtGTy71DdXAW4232H6Pl4P08X1sRLnN25wnZKrveRJmQGmAzLDq0MHK31k2YKR6GQ-XdoYzKOfeSbrQOBsm_TU46WjF4Lp9PUXhYtXa5x95Qo6DvYWoHPJJIjGbavQ-2XMcTw9l-SMQsXSgnpwGiA6m4CFvn_wvN51FtB4BWb2ynYrh5nyUY0vRDZxLAjDfzLLd2CJna6EpuJUTDA67IBv7r3jTML3FQ4Y5MwcT1riijxejKnWsLNv827ppqLDnu3GaQZcf0LgJGieH6uQroRm_wjWr1QIxdWu52ZjUZ82sRyPWextpDYAOVkgDE-8xWu4x-IaFkVnvoJOU95VGX6rz-tbfRvHGsO8g_-nlFY2sjHQ_n9yDQPBNahdzFNR4dZTE6l0RhVDlrd5WiAN0DTj_MCZKX57XurX43_zrh3lOohuPeeFc7hZMfJHgqUhbELGtwJ81VuyP7C0j_cUIQI_1KNbBuKGf9eoWgCoitEbqBSFOBQ-Rj9dHnPDxuDJ9e-jkIf7IyLmtYXQjibg3UlUFZnIAPE1P2SqVPQhAldeaKczEKyK7MSgdoYozNR63_1CE3-FLs5kaFIAqFfG0X_vYVzonNVJoUuLQ..' , `time` = '1754429751'
  WHERE `session_id` = '14a80d405d8de27d1c1aad77319ab7dd'

50 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 29 × SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
2. 19 × SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
3. 16 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
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. 9 × SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  LEFT JOIN `josnj_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
8. 9 × SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
9. 9 × 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`
10. 9 × SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
  FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
11. 9 × SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
12. 9 × SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
13. 9 × SELECT *
  FROM `josnj_virtuemart_product_prices`
14. 9 × SELECT `josnj_virtuemart_categories_en_gb`.* ,`josnj_virtuemart_categories`.*
  FROM `josnj_virtuemart_categories_en_gb` JOIN josnj_virtuemart_categories using (`virtuemart_category_id`)
15. 9 × SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
16. 9 × SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
17. 5 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
18. 2 × SELECT m.id
  FROM josnj_modules AS m
  INNER JOIN josnj_modules_menu AS mm
  ON mm.moduleid = m.id
19. 2 × SELECT *
  FROM `josnj_virtuemart_shoppergroups`
20. 2 × SELECT FOUND_ROWS(
21. 1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `josnj_virtuemart_category_categories` AS `xref`
22. 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
23. 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`
24. 1 × SELECT `price_display`,`custom_price_display`
  FROM `josnj_virtuemart_shoppergroups` AS `sg`
25. 1 × SELECT *
  FROM josnj_virtuemart_calcs
26. 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
27. 1 × SELECT *
  FROM `josnj_virtuemart_currencies`
28. 1 × SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_vmuser_shoppergroups`
29. 1 × SELECT `config`
  FROM `josnj_virtuemart_configs`
30. 1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
  FROM `josnj_virtuemart_permgroups`
31. 1 × SELECT *
  FROM josnj_languages
32. 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
33. 1 × SELECT folder AS type, element AS name, params
  FROM josnj_extensions
34. 1 × SELECT `session_id`
  FROM `josnj_session`
35. 1 × SELECT b.id
  FROM josnj_usergroups AS a
  LEFT JOIN josnj_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
36. 1 × SELECT id, rules
  FROM `josnj_viewlevels
37. 1 × SELECT *
  FROM `josnj_menu`
38. 1 × SELECT `virtuemart_manufacturer_id`
  FROM `josnj_virtuemart_manufacturers_en_gb`
39. 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`
40. 1 × SELECT `data`
  FROM `josnj_session`
41. 1 × SELECT `virtuemart_userinfo_id`
  FROM `josnj_virtuemart_userinfos`
42. 1 × SELECT `category_child_id`
  FROM `josnj_virtuemart_category_categories`
43. 1 × SELECT COUNT(*)
  FROM josnj_extensions
44. 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
45. 1 × SELECT manifest_cache
  FROM josnj_extensions
46. 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`

OTHER Tables:

1. 1 × UPDATE `josnj_session`
  SET `data` = 'DOctTTh6fTVVovQ44gtwTBG_dw4VhJKRDRGP7-dWBya_YvGgO7B34IBG4U5jVkC3mEsfYNC1PXOfWUXctt7wBjeiYK5HEybVwJoyLa51bYLzHwoeHy5-oaXObE0BoPAvIqnwby96ojA5m4h4cFVeEI6pTdVCAcBGg0ShJl9DL7U0GK0V7LdlN8eXIh4xE4O5Fbn4mwQllymJo-XK1C6SdPvtYmKKrjD9L1hNknAxf-UCjKOVWrU7VZwuDvD5-28J-zooJexC02_C48_53bntr_ZjjEvS_XTDBfb8lWgbT0np4jrBEH-szgtZlUgvTE46KsMAQv-vgU8FY_KTo2VpmRUiyL9NLaEcgEUGkVohanl8TwOu81ZmnuxQtoN89m-toYc_4qDDejjVrDHExAulb_aGqQnQ-wYq4a8OdYViODB09c9AcwzP3DL90WvFZ2x1a6VlR53lDY1yi_97N6WIO_8EV2leVAEMtcU_5rZNbGv9q0Hm3Cbk0i_F__cT9KGr_PGcbv67k3R7Ak6mMJdKpIfU6mPWKxH4BoqxJKZ4jFE_eJ0UXHnmHevR5fY2m9lNirxOnCwe9ay8jUmDqD2ZRBiQNBmwaiP0ba9QvGvby-pcvCnN3cJAEVaMjqPn0_slfw7pKC7lBD28smZqoMYlpnqnbBrFUjaBr-AdXOzB8zz86LRH4V-pr1MX_EI6qRMEp_D-wQxJ0MaKIftgrDoq9FK51Q6aq1g2vq91c14N87utWgqwAEYSq3kWaSIucyInRf-QAZPNh_3DwEGYt5ei5wxa5ovi82cQx07CDoakFEi027pybfp9s-OXu4wpCyjNcxO-n3JMXfePLyRTnZkZDmTwfaNL0l0qdPRanl8--gH0ESEdfc0t-LS-LzJ6nuldX2i035wMVqa_NmNBfOBIV0rNxt-o216I3zeGsZzMO3qQqg2SKUZx12l04Q6FbOCY0cjYLXvknGoLnNNgEaNXvBBVPKSr9RbBMAd9dYF1rM9UQsGxLBmCIkenK5GQ0EON6PahT8nvqk61h3g3Eroo4OmIdYYlxRoh0wpzdv-M5HNgoUtFPnwcUjVnnC5mMMrlKowTE_5XKa61KtrV1K_ve6zefHpRu8yJobtDAn98qhgcENg3rg1n8_tgH5YUFA3XPchMHLTC2i4OUXNp5p9hwSNySm0hoGYqcS7UbucjnCAFJiEe-qvvL7Hi3eghm6OtAofNwdl8C-AhGlC4MKDVjFPI5BfrqFEnVaKMVfM8mJox1iCF46mY6-FCP4sDZDuiJ5N0j_a_L20ktDQdGBuyfBfFBH981aZYdAfMpf_iViJAi6SVxeetHk5n7d--gSh_LYcLGswhQih7HsFiASicif_VgWzgl2fz0AZdSzt6G2jBHauP0SmiJTu3rmqsnutqtQX1QRFslAm-OU1PaiFIJ1pS-34vFryl-wIuj2a_YqY6Tvwv8mm35ZSnKFIbU9UzfqRbXXATib89tn6K3sa_Dp_Sth4Dtpbl63F8m-dibEYJaXWFcCiqR7evIlkDN0N2N3a42eWidw1FKCr78RJRllco0fiXcj6F_4CPK3gbkJEGM3eWOBGFmbVkNcDV6hFyY6js9gZP9tjdPRTyT28urE9rV5iajtbHGZJ6KrkSwt1eUA1PJu6lCwe4W3ytoBM-grrfGCRP6nI02NI40gJftQ_3v2yvw05vx4SVRD4ODGlHv72g8HbaSLnyCeLYNZChFlB3He4azg6Aj_YrtUM8fZ1R3WVclS3yPTWQtvpKixMXaKYPP4TJtGTy71DdXAW4232H6Pl4P08X1sRLnN25wnZKrveRJmQGmAzLDq0MHK31k2YKR6GQ-XdoYzKOfeSbrQOBsm_TU46WjF4Lp9PUXhYtXa5x95Qo6DvYWoHPJJIjGbavQ-2XMcTw9l-SMQsXSgnpwGiA6m4CFvn_wvN51FtB4BWb2ynYrh5nyUY0vRDZxLAjDfzLLd2CJna6EpuJUTDA67IBv7r3jTML3FQ4Y5MwcT1riijxejKnWsLNv827ppqLDnu3GaQZcf0LgJGieH6uQroRm_wjWr1QIxdWu52ZjUZ82sRyPWextpDYAOVkgDE-8xWu4x-IaFkVnvoJOU95VGX6rz-tbfRvHGsO8g_-nlFY2sjHQ_n9yDQPBNahdzFNR4dZTE6l0RhVDlrd5WiAN0DTj_MCZKX57XurX43_zrh3lOohuPeeFc7hZMfJHgqUhbELGtwJ81VuyP7C0j_cUIQI_1KNbBuKGf9eoWgCoitEbqBSFOBQ-Rj9dHnPDxuDJ9e-jkIf7IyLmtYXQjibg3UlUFZnIAPE1P2SqVPQhAldeaKczEKyK7MSgdoYozNR63_1CE3-FLs5kaFIAqFfG0X_vYVzonNVJoUuLQ..' , `time` = '1754429751'
2. 1 × SHOW TABLES LIKE "%virtuemart_configs%
3. 1 × INSERT INTO `josnj_session` (`session_id`, `client_id`, `time`)
  VALUES ('14a80d405d8de27d1c1aad77319ab7dd', 0, '1754429751'
4. 1 × DELETE
  FROM `josnj_session`