221 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 'optex'
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` = 5)
  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` = "38"
49. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "38"
  ORDER BY `ordering`
50. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "38"
51. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "38"
  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` = "5"
53. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 38
54. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "38"
  and `virtuemart_category_id`= "7"
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` = "7"
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`= 7
62. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=7
63. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 38
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` = "32"
65. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "32"
  ORDER BY `ordering`
66. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "32"
67. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "32"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "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` = "5"
69. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 32
70. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "32"
  and `virtuemart_category_id`= "7"
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` = "7"
72. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 32
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` = "45"
74. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "45"
  ORDER BY `ordering`
75. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "45"
76. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "45"
  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` = "5"
78. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 45
79. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "45"
  and `virtuemart_category_id`= "7"
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` = "7"
81. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 45
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` = "39"
83. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "39"
  ORDER BY `ordering`
84. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "39"
85. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "39"
  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` = "5"
87. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 39
88. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "39"
  and `virtuemart_category_id`= "7"
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` = "7"
90. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 39
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` = "33"
92. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "33"
  ORDER BY `ordering`
93. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "33"
94. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "33"
  AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "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) )
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` = "5"
96. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 33
97. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "33"
  and `virtuemart_category_id`= "7"
98. 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` = "7"
99. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 33
100. 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` = "46"
101. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "46"
  ORDER BY `ordering`
102. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "46"
103. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "46"
  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) )
104. 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` = "5"
105. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 46
106. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "46"
  and `virtuemart_category_id`= "7"
107. 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` = "7"
108. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 46
109. 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` = "40"
110. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "40"
  ORDER BY `ordering`
111. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "40"
112. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "40"
  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) )
113. 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` = "5"
114. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 40
115. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "40"
  and `virtuemart_category_id`= "7"
116. 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` = "7"
117. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 40
118. 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` = "34"
119. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "34"
  ORDER BY `ordering`
120. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "34"
121. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "34"
  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) )
122. 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` = "5"
123. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 34
124. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "34"
  and `virtuemart_category_id`= "7"
125. 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` = "7"
126. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 34
127. 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` = "47"
128. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "47"
  ORDER BY `ordering`
129. SELECT `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "47"
130. SELECT *
  FROM `josnj_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "47"
  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) )
131. 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` = "5"
132. SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 47
133. SELECT `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "47"
  and `virtuemart_category_id`= "7"
134. 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` = "7"
135. SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
  WHERE `virtuemart_product_id` = 47
136. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "38"
137. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "32"
138. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "45"
139. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "39"
140. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "33"
141. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "46"
142. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "40"
143. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "34"
144. SELECT `josnj_virtuemart_medias`.*
  FROM `josnj_virtuemart_medias`
  WHERE josnj_virtuemart_medias.`virtuemart_media_id` = "47"
145. 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`
146. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=12
147. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=2
148. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=1
149. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=3
150. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=4
151. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
152. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=6
153. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=7
154. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=9
155. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=10
156. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=11
157. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
158. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
159. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
160. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 13
161. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=13
162. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 4
163. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=4
164. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
165. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=1
166. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 5
167. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=5
168. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 6
169. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=6
170. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 8
171. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=8
172. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 9
173. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=9
174. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 10
175. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=10
176. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 11
177. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=11
178. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 12
179. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=12
180. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
181. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
182. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
183. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
184. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
185. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
186. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
187. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
188. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
189. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
190. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
191. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
192. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
193. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
194. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
195. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
196. SELECT `slug`
  FROM `josnj_virtuemart_manufacturers_en_gb`
  WHERE virtuemart_manufacturer_id=5
197. 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
198. 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")
199. 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
200. SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
201. 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
202. 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
203. 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
204. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "2"
  ORDER BY `ordering`
205. SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "3"
  ORDER BY `ordering`
206. 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
207. 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
208. 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
209. 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
210. 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
211. 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
212. 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
213. 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
214. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM `josnj_virtuemart_category_categories` AS `xref`
  WHERE `xref`.`category_child_id`= 0
215. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 2
216. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
217. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=2
218. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 3
219. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM josnj_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 1
220. SELECT `slug` as name
  FROM `josnj_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=3
221. UPDATE `josnj_session`
  SET `data` = 'qaMKW-RS6V4iuqgUwY6k650JdLlEzjaTMTxcmG294ZdWTCbe9qM6v5akW4eikSccdQKtCIqmCRKYkP77tFehzF-Oy6Qw_etepzTlUKJNAPb4zUB7b4pStTfoBpzl5jRsb70KWiSh30FmGQY0TeXSaK8QQzTIig6kwU8n2RMls_DDX78d8KKuROsZyCTjEwQB9HsPGj-F6ndrUaHOuWM-YaUC6r92nZCkBV0UeibS86kwYAAXukq5YnCH2bUO_VzsM6InG5zJ3N6hrgzi4Fp3zQ8nDmQDCAyiRTGxvtzAIEGrt88sV3pGnyApVghuL8_ox_xqZryqb-7FhqwP2R0fhLy_ySFUNcHRVs1WnboccJeSAwlnIyKMoGs1cprgCtm82pDwTfRu-ngPF68rqugD1Nsbf4Njvgqj91NV3ofX9qOjRDOSMejMldTH_Rb72QuLyp5-6cZLOZgSUNSjk8oixBBKp9DdQ2JQCsMFoIPyWo4zkYfYl-rJA1PKumIpsyUsSq6wASY8YT2YE5AZCqYfoLhWboo6Ek_DZ0QWZX958xMdq-JL7L-CyAi5TDFiPo5NMID5QZYf1SWF_uD3ZqiqQuQKXTlnwt_TdthkduD9W66s_aAFBGZePaXmv9B7fcLMBHttOxiqpa0HtQmtLxb2lAU2IZXYkx80wYeavoVCOuuOawdMGQgjPry4CVBJka1npraMkFVpbfFzAZ9GuYrcH-4belHaH_GTWOjJHsT68-hPGw3JxqhUbrR6q2IppPnL6Rkf9-Y21O5ZBxZm8BkXTFrye5BmbYBkjz38Htk-MyG2sOOXFe1sg0gndi5325mS_BX1LpLXbN5Y68o_V6ClryBMXzpDPn72eyXW3J_M88kv1yP1kmd5Ev6KK-a7wL1pv4McCF43rsL160-9skkY8uAeIUQDQ4lqJsUbwmwQw9FHNTGG7sa4oxP9hAgsjpAGihMEWBWz4psI8Z6DdYLJewehFsT_5rK0jMyK9pQtlsrol4fmFACUKVw1_nyg4dQqMQ3Etk1gOoqf0F9RL2_z1cIgE4UKTezluDY7IJfLbJxEGDye5o8w_cTtE84_Q-Qc2TKt3Q0GIy5noTehAqi8HQMGvDeNYVoYZW07PeFvwNKlrLOm-7QBGphQjxzVDrm15MO9eo1jBNRmJjnger67bX6c8RrTyA0xWYyd5mlMfGeK-isqzDsrghHSpy6CX-nyXCEMbfD2J4wm4H5PusHDpSJUri0AafUXA2qPKh3ii_SGUCaaJNRHwRIJQIMBEN2lIWMWP2bKD7rA1nfGJAVE8wE7vpUqM4Ub1IcGRKC4bI6CSmDQ_e9ek3Ns0C6lGOD6Wzx6QgkspnyCZURJqa1lnMLuMMvw5XrVZqK7X_FJQwnHwx5vlqX-9j07vX0bHjJ0HRKlKjmPrTHizmC25ODatDbBqadHqhyQGdoWmk-MbiiDz3EDIdRAbDzobx8Y0DNGsvnqm3yhkV23XOoE677AWjqXXJ52tCYioaQ8x7_kTwkB5GUQhkRbPNEDnb72TCur7wfbqBiN7AAWcQ6sA2YrY2rHSU1045c0dUb7Vy7D0Jw10Wj_RzpkJSEV-q4HU0yOMFEZB1H7MfE-Hc12YBoSt_mvzEbHmAzcVn4GcTP9j9-bnFp0mnZWd8fKkTCaWnkPaNLOq1-AB_wZkuc8bX_Jk83n3wuIn38RYcIoaYbu9WEYDDXyMmD16dEAnhOA-MhHg4a-SSKELwVDCZ8AO7Q_h39GIloIZWAUYtYZhUxMAdW7udnWGOhOxCpGMNPx_ambVKcNh5a8m0-xH0AzU9Fq94iFR73w_IaHA8mCr9hcEEwOA9NNwz3Yu4VDv3Dn6jUKZk4qB9WYndaMdOfVZO8E4ky_kN5ir-lTluSVPwBXK9zPpXsXW2PRd_y-ECnD2d89nnifpG8tdybjNcCb8odAKkQFPeOoaZk7CmtloFiPcRTkwJSnRlHVSWpQMDuog7WFObhSyAC8oUmFtPZJKoNoF6_pVirYImAi9lHqnuFQMrM1z1O5vK5xFyonTVPk87t-lJNcpkYqO90GcfVbRCeC09ei5STxukZUkMZ-Dyrw1Y7Cath7vL4y9mt6LxKfyFYvFnpehyo6g8j8q2hwIerxW01fuvIgVMV0vBl5QYKNyIAHi5BNS2ngAFWPzvxYxEfLwpMUBqhFmCp6xl7QNy0-B_tnnWyYdD87wX4Otc2Q1KzE5yHaKYTArA-naH1FMv8ove_g1VAuycCucrr97giGJY8vFazx1X4G-PxJvb39_hNwLKoJDV75SMt1nl6ipWPKyKPIRLvKH7HQlhM42tYpTJwUXM-IKiVd1WVR4rzLjrig9cOMdMBXy7TXniGAbMR0JzyFmE0XJXg-XFssSYMSmQ..' , `time` = '1754429752'
  WHERE `session_id` = '14a80d405d8de27d1c1aad77319ab7dd'

44 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 31 × 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 `virtuemart_shoppergroup_id`
  FROM `josnj_virtuemart_product_shoppergroups`
8. 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`
9. 9 × SELECT *
  FROM `josnj_virtuemart_product_prices`
10. 9 × SELECT `virtuemart_media_id`
  FROM `josnj_virtuemart_product_medias`
11. 9 × SELECT pc.`virtuemart_category_id`
  FROM `josnj_virtuemart_product_categories` as pc
12. 9 × SELECT `slug`
  FROM `josnj_virtuemart_products_en_gb`
13. 9 × SELECT `josnj_virtuemart_manufacturers_en_gb`.* ,`josnj_virtuemart_manufacturers`.*
  FROM `josnj_virtuemart_manufacturers_en_gb` JOIN josnj_virtuemart_manufacturers using (`virtuemart_manufacturer_id`)
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 `ordering`,`id`
  FROM `josnj_virtuemart_product_categories`
16. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM josnj_extensions
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` = 'qaMKW-RS6V4iuqgUwY6k650JdLlEzjaTMTxcmG294ZdWTCbe9qM6v5akW4eikSccdQKtCIqmCRKYkP77tFehzF-Oy6Qw_etepzTlUKJNAPb4zUB7b4pStTfoBpzl5jRsb70KWiSh30FmGQY0TeXSaK8QQzTIig6kwU8n2RMls_DDX78d8KKuROsZyCTjEwQB9HsPGj-F6ndrUaHOuWM-YaUC6r92nZCkBV0UeibS86kwYAAXukq5YnCH2bUO_VzsM6InG5zJ3N6hrgzi4Fp3zQ8nDmQDCAyiRTGxvtzAIEGrt88sV3pGnyApVghuL8_ox_xqZryqb-7FhqwP2R0fhLy_ySFUNcHRVs1WnboccJeSAwlnIyKMoGs1cprgCtm82pDwTfRu-ngPF68rqugD1Nsbf4Njvgqj91NV3ofX9qOjRDOSMejMldTH_Rb72QuLyp5-6cZLOZgSUNSjk8oixBBKp9DdQ2JQCsMFoIPyWo4zkYfYl-rJA1PKumIpsyUsSq6wASY8YT2YE5AZCqYfoLhWboo6Ek_DZ0QWZX958xMdq-JL7L-CyAi5TDFiPo5NMID5QZYf1SWF_uD3ZqiqQuQKXTlnwt_TdthkduD9W66s_aAFBGZePaXmv9B7fcLMBHttOxiqpa0HtQmtLxb2lAU2IZXYkx80wYeavoVCOuuOawdMGQgjPry4CVBJka1npraMkFVpbfFzAZ9GuYrcH-4belHaH_GTWOjJHsT68-hPGw3JxqhUbrR6q2IppPnL6Rkf9-Y21O5ZBxZm8BkXTFrye5BmbYBkjz38Htk-MyG2sOOXFe1sg0gndi5325mS_BX1LpLXbN5Y68o_V6ClryBMXzpDPn72eyXW3J_M88kv1yP1kmd5Ev6KK-a7wL1pv4McCF43rsL160-9skkY8uAeIUQDQ4lqJsUbwmwQw9FHNTGG7sa4oxP9hAgsjpAGihMEWBWz4psI8Z6DdYLJewehFsT_5rK0jMyK9pQtlsrol4fmFACUKVw1_nyg4dQqMQ3Etk1gOoqf0F9RL2_z1cIgE4UKTezluDY7IJfLbJxEGDye5o8w_cTtE84_Q-Qc2TKt3Q0GIy5noTehAqi8HQMGvDeNYVoYZW07PeFvwNKlrLOm-7QBGphQjxzVDrm15MO9eo1jBNRmJjnger67bX6c8RrTyA0xWYyd5mlMfGeK-isqzDsrghHSpy6CX-nyXCEMbfD2J4wm4H5PusHDpSJUri0AafUXA2qPKh3ii_SGUCaaJNRHwRIJQIMBEN2lIWMWP2bKD7rA1nfGJAVE8wE7vpUqM4Ub1IcGRKC4bI6CSmDQ_e9ek3Ns0C6lGOD6Wzx6QgkspnyCZURJqa1lnMLuMMvw5XrVZqK7X_FJQwnHwx5vlqX-9j07vX0bHjJ0HRKlKjmPrTHizmC25ODatDbBqadHqhyQGdoWmk-MbiiDz3EDIdRAbDzobx8Y0DNGsvnqm3yhkV23XOoE677AWjqXXJ52tCYioaQ8x7_kTwkB5GUQhkRbPNEDnb72TCur7wfbqBiN7AAWcQ6sA2YrY2rHSU1045c0dUb7Vy7D0Jw10Wj_RzpkJSEV-q4HU0yOMFEZB1H7MfE-Hc12YBoSt_mvzEbHmAzcVn4GcTP9j9-bnFp0mnZWd8fKkTCaWnkPaNLOq1-AB_wZkuc8bX_Jk83n3wuIn38RYcIoaYbu9WEYDDXyMmD16dEAnhOA-MhHg4a-SSKELwVDCZ8AO7Q_h39GIloIZWAUYtYZhUxMAdW7udnWGOhOxCpGMNPx_ambVKcNh5a8m0-xH0AzU9Fq94iFR73w_IaHA8mCr9hcEEwOA9NNwz3Yu4VDv3Dn6jUKZk4qB9WYndaMdOfVZO8E4ky_kN5ir-lTluSVPwBXK9zPpXsXW2PRd_y-ECnD2d89nnifpG8tdybjNcCb8odAKkQFPeOoaZk7CmtloFiPcRTkwJSnRlHVSWpQMDuog7WFObhSyAC8oUmFtPZJKoNoF6_pVirYImAi9lHqnuFQMrM1z1O5vK5xFyonTVPk87t-lJNcpkYqO90GcfVbRCeC09ei5STxukZUkMZ-Dyrw1Y7Cath7vL4y9mt6LxKfyFYvFnpehyo6g8j8q2hwIerxW01fuvIgVMV0vBl5QYKNyIAHi5BNS2ngAFWPzvxYxEfLwpMUBqhFmCp6xl7QNy0-B_tnnWyYdD87wX4Otc2Q1KzE5yHaKYTArA-naH1FMv8ove_g1VAuycCucrr97giGJY8vFazx1X4G-PxJvb39_hNwLKoJDV75SMt1nl6ipWPKyKPIRLvKH7HQlhM42tYpTJwUXM-IKiVd1WVR4rzLjrig9cOMdMBXy7TXniGAbMR0JzyFmE0XJXg-XFssSYMSmQ..' , `time` = '1754429752'
2. 1 × SHOW TABLES LIKE "%virtuemart_configs%