600 Queries Logged

1. SELECT `data`
  FROM `htocx_session`
  WHERE `session_id` = '078470927072b3836638e1ae6fd57706'
2. DELETE
  FROM `htocx_session`
  WHERE `time` < '1759337499'
3. SELECT `enabled`
  FROM `htocx_extensions`
  WHERE `element` = 'com_akeeba'
  AND `type` = 'component'
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 htocx_menu AS m
  LEFT JOIN htocx_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. SELECT `params`
  FROM htocx_extensions
  WHERE `element`='com_sh404sef'
  AND `type`='component';
6. select `alias`,`newurl`
  from `htocx_sh404sef_aliases`
  where `alias` = 'shopping-cart/stockings/modern/lacetop.html?error=404' or `alias` = 'shopping-cart/stockings/modern/lacetop.html' or `alias` = 'shopping-cart/stockings/modern/lacetop.html/'
  order by `alias` desc
7. SELECT `oldurl`, `newurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `oldurl`='shopping-cart/stockings/modern/lacetop.html'
  ORDER BY `rank`;
8. SHOW TABLES LIKE "htocx_virtuemart_configs"
9. SELECT `config`
  FROM `htocx_virtuemart_configs`
  WHERE `virtuemart_config_id` = "1";
10. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=category&virtuemart_category_id=105';
11. SELECT *
  FROM `htocx_menu`
  where `link` like "index.php?option=com_virtuemart%"
  and client_id=0
  and published=1
  and (language="*" or language = "en-GB" )
12. SELECT `htocx_virtuemart_categories`.* ,`htocx_virtuemart_categories_en_gb`.*
  FROM `htocx_virtuemart_categories`
  INNER JOIN `htocx_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
  WHERE `htocx_virtuemart_categories`.`virtuemart_category_id` = "105"
13. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_category_medias`
  WHERE `virtuemart_category_id` = "105"
  ORDER BY `ordering`
14. SELECT `category_child_id`
  FROM `htocx_virtuemart_category_categories`
  WHERE `category_parent_id` = 105
15. SELECT count(htocx_virtuemart_products.virtuemart_product_id) AS total
  FROM `htocx_virtuemart_products`, `htocx_virtuemart_product_categories`
  WHERE `htocx_virtuemart_products`.`virtuemart_vendor_id` = "1"
  AND `htocx_virtuemart_product_categories`.`virtuemart_category_id` = 105
  AND `htocx_virtuemart_products`.`virtuemart_product_id` = `htocx_virtuemart_product_categories`.`virtuemart_product_id`
  AND `htocx_virtuemart_products`.`published` = "1"
16. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM htocx_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 105
17. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM htocx_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 93
18. SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
  FROM htocx_virtuemart_category_categories AS `xref`
  WHERE `xref`.`category_child_id`= 92
19. SELECT `category_name`,`virtuemart_category_id`
  FROM `htocx_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=92
20. SELECT `category_name`,`virtuemart_category_id`
  FROM `htocx_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=93
21. SELECT `category_name`,`virtuemart_category_id`
  FROM `htocx_virtuemart_categories_en_gb`
  WHERE `virtuemart_category_id`=105
22. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_vmuser_shoppergroups`
  WHERE `virtuemart_user_id` = "0"
23. SELECT *
  FROM `htocx_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
24. SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`
  FROM `htocx_virtuemart_products` as p
  INNER JOIN `htocx_virtuemart_products_en_gb` as l using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_shoppergroups` as ps
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_categories` as pc
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
  WHERE ( p.`published`="1"
  AND `pc`.`virtuemart_category_id` = 105
  AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) )
  group by p.`virtuemart_product_id`
  ORDER BY `pc`.`ordering` ASC
  LIMIT 0, 18
25. SELECT FOUND_ROWS()
26. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "4711"
27. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4711"
  ORDER BY `ordering`
28. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4711"
29. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4711"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
30. SELECT `htocx_virtuemart_manufacturers`.* ,`htocx_virtuemart_manufacturers_en_gb`.*
  FROM `htocx_virtuemart_manufacturers`
  INNER JOIN `htocx_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
  WHERE `htocx_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "16"
31. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4711
32. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 4711
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
33. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "4711"
  and `virtuemart_category_id`= "105"
34. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4711
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
35. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4711
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
36. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4711
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
37. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4711
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
38. SELECT `vendor_currency`,`currency_code_3`,`currency_numeric_code`
  FROM `htocx_virtuemart_vendors` AS v
  LEFT JOIN `htocx_virtuemart_currencies` AS c
  ON virtuemart_currency_id = vendor_currency
  WHERE v.`virtuemart_vendor_id`="1"
39. SELECT *
  FROM `htocx_virtuemart_currencies`
  WHERE `virtuemart_currency_id`="144"
40. SELECT `price_display`,`custom_price_display`
  FROM `htocx_virtuemart_shoppergroups` AS `sg`
  WHERE `sg`.`default` = "2"
41. SELECT *
  FROM `htocx_virtuemart_shoppergroups`
  WHERE `default` = "2"
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
  AND `published`="1"
42. SELECT *
  FROM htocx_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-10-01 19:21:39" )
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-10-01 19:21:39" ) OR `for_override` = "1" )
43. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4711
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=230
  ORDER BY field.`ordering`
44. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "4714"
45. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4714"
  ORDER BY `ordering`
46. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4714"
47. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4714"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
48. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4714
49. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4711"
  ORDER BY `ordering`
50. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4711"
51. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4711"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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 pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4711
53. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 4711
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
54. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "4711"
  and `virtuemart_category_id`= "105"
55. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=4714';
56. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=4714';
57. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "4716"
58. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4716"
  ORDER BY `ordering`
59. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4716"
60. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4716"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
61. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4716
62. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=4716';
63. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=4716';
64. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "4717"
65. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4717"
  ORDER BY `ordering`
66. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4717"
67. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4717"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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 pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4717
69. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=4717';
70. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=4717';
71. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =4711
72. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4712
  and C.field_type = "C"
73. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4713
  and C.field_type = "C"
74. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4714
  and C.field_type = "C"
75. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4715
  and C.field_type = "C"
76. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4716
  and C.field_type = "C"
77. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4717
  and C.field_type = "C"
78. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=4711';
79. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=4711';
80. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5148"
81. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5148"
  ORDER BY `ordering`
82. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5148"
83. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5148"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
84. SELECT `htocx_virtuemart_manufacturers`.* ,`htocx_virtuemart_manufacturers_en_gb`.*
  FROM `htocx_virtuemart_manufacturers`
  INNER JOIN `htocx_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
  WHERE `htocx_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "48"
85. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5148
86. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 5148
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
87. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "5148"
  and `virtuemart_category_id`= "105"
88. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5148
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
89. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5148
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
90. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5148
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
91. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5148
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
92. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5148
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=267
  ORDER BY field.`ordering`
93. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5149"
94. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5149"
  ORDER BY `ordering`
95. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5149"
96. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5149"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
97. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5149
98. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5148"
  ORDER BY `ordering`
99. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5148"
100. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5148"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
101. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5148
102. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 5148
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
103. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "5148"
  and `virtuemart_category_id`= "105"
104. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5149';
105. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5149';
106. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =5148
107. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5149
  and C.field_type = "C"
108. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5150
  and C.field_type = "C"
109. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5151
  and C.field_type = "C"
110. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5148';
111. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5148';
112. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5212"
113. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5212"
  ORDER BY `ordering`
114. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5212"
115. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5212"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
116. SELECT `htocx_virtuemart_manufacturers`.* ,`htocx_virtuemart_manufacturers_en_gb`.*
  FROM `htocx_virtuemart_manufacturers`
  INNER JOIN `htocx_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
  WHERE `htocx_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "19"
117. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5212
118. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 5212
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
119. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "5212"
  and `virtuemart_category_id`= "105"
120. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5212
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
121. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5212
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
122. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5212
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
123. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5212
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
124. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5212
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=273
  ORDER BY field.`ordering`
125. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5213"
126. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5213"
  ORDER BY `ordering`
127. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5213"
128. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5213"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
129. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5213
130. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5212"
  ORDER BY `ordering`
131. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5212"
132. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5212"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
133. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5212
134. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 5212
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
135. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "5212"
  and `virtuemart_category_id`= "105"
136. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5213';
137. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5213';
138. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5214"
139. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5214"
  ORDER BY `ordering`
140. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5214"
141. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5214"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
142. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5214
143. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5214';
144. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5214';
145. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5215"
146. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5215"
  ORDER BY `ordering`
147. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5215"
148. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5215"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
149. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5215
150. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5215';
151. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5215';
152. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5216"
153. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5216"
  ORDER BY `ordering`
154. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5216"
155. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5216"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
156. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5216
157. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5216';
158. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5216';
159. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5218"
160. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5218"
  ORDER BY `ordering`
161. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5218"
162. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5218"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
163. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5218
164. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5218';
165. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5218';
166. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =5212
167. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5213
  and C.field_type = "C"
168. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5214
  and C.field_type = "C"
169. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5215
  and C.field_type = "C"
170. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5216
  and C.field_type = "C"
171. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5217
  and C.field_type = "C"
172. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5218
  and C.field_type = "C"
173. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5212';
174. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5212';
175. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5446"
176. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5446"
  ORDER BY `ordering`
177. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5446"
178. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5446"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
179. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5446
180. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 5446
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
181. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "5446"
  and `virtuemart_category_id`= "105"
182. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5446
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
183. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5446
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
184. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5446
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
185. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5446
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
186. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5446
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=290
  ORDER BY field.`ordering`
187. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5447"
188. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5447"
  ORDER BY `ordering`
189. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5447"
190. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5447"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
191. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5447
192. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5446"
  ORDER BY `ordering`
193. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5446"
194. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5446"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
195. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5446
196. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 5446
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
197. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "5446"
  and `virtuemart_category_id`= "105"
198. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5447';
199. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5447';
200. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5458"
201. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5458"
  ORDER BY `ordering`
202. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5458"
203. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5458"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
204. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5458
205. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5458';
206. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5458';
207. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5773"
208. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5773"
  ORDER BY `ordering`
209. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5773"
210. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5773"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
211. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5773
212. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5773';
213. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5773';
214. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =5446
215. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5447
  and C.field_type = "C"
216. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5448
  and C.field_type = "C"
217. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5449
  and C.field_type = "C"
218. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5450
  and C.field_type = "C"
219. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5458
  and C.field_type = "C"
220. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5459
  and C.field_type = "C"
221. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5772
  and C.field_type = "C"
222. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5773
  and C.field_type = "C"
223. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5446';
224. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5446';
225. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5682"
226. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5682"
  ORDER BY `ordering`
227. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5682"
228. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5682"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
229. SELECT `htocx_virtuemart_manufacturers`.* ,`htocx_virtuemart_manufacturers_en_gb`.*
  FROM `htocx_virtuemart_manufacturers`
  INNER JOIN `htocx_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
  WHERE `htocx_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "26"
230. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5682
231. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 5682
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
232. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "5682"
  and `virtuemart_category_id`= "105"
233. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5682
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
234. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5682
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
235. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5682
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
236. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5682
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
237. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =5682
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=311
  ORDER BY field.`ordering`
238. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5689"
239. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5689"
  ORDER BY `ordering`
240. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5689"
241. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5689"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
242. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5689
243. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5682"
  ORDER BY `ordering`
244. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5682"
245. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5682"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
246. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5682
247. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 5682
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
248. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "5682"
  and `virtuemart_category_id`= "105"
249. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5689';
250. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5689';
251. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5686"
252. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5686"
  ORDER BY `ordering`
253. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5686"
254. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5686"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
255. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5686
256. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5686';
257. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5686';
258. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =5682
259. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5683
  and C.field_type = "C"
260. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5684
  and C.field_type = "C"
261. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5685
  and C.field_type = "C"
262. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5686
  and C.field_type = "C"
263. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5687
  and C.field_type = "C"
264. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5688
  and C.field_type = "C"
265. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5689
  and C.field_type = "C"
266. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5690
  and C.field_type = "C"
267. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5691
  and C.field_type = "C"
268. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=5682';
269. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5682';
270. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "6004"
271. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "6004"
  ORDER BY `ordering`
272. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "6004"
273. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "6004"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
274. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 6004
275. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 6004
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
276. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "6004"
  and `virtuemart_category_id`= "105"
277. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =6004
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
278. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =6004
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
279. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =6004
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
280. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =6004
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
281. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =6004
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=344
  ORDER BY field.`ordering`
282. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "6006"
283. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "6006"
  ORDER BY `ordering`
284. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "6006"
285. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "6006"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
286. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 6006
287. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "6004"
  ORDER BY `ordering`
288. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "6004"
289. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "6004"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
290. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 6004
291. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 6004
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
292. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "6004"
  and `virtuemart_category_id`= "105"
293. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=6006';
294. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=6006';
295. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "6020"
296. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "6020"
  ORDER BY `ordering`
297. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "6020"
298. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "6020"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
299. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 6020
300. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=6020';
301. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=6020';
302. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =6004
303. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =6005
  and C.field_type = "C"
304. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =6006
  and C.field_type = "C"
305. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =6020
  and C.field_type = "C"
306. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=6004';
307. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=6004';
308. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "802"
309. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "802"
  ORDER BY `ordering`
310. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "802"
311. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "802"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
312. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 802
313. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 802
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
314. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "802"
  and `virtuemart_category_id`= "105"
315. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =802
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
316. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =802
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
317. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =802
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
318. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =802
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
319. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =802
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=95
  ORDER BY field.`ordering`
320. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3689"
321. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3689"
  ORDER BY `ordering`
322. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3689"
323. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3689"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
324. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3689
325. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "802"
  ORDER BY `ordering`
326. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "802"
327. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "802"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
328. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 802
329. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 802
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
330. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "802"
  and `virtuemart_category_id`= "105"
331. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=3689';
332. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3689';
333. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "1956"
334. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1956"
  ORDER BY `ordering`
335. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1956"
336. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1956"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
337. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1956
338. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "1957"
339. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "1957"
  ORDER BY `ordering`
340. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "1957"
341. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "1957"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
342. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 1957
343. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =802
344. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =1955
  and C.field_type = "C"
345. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =1956
  and C.field_type = "C"
346. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =1957
  and C.field_type = "C"
347. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =1958
  and C.field_type = "C"
348. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =1959
  and C.field_type = "C"
349. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3689
  and C.field_type = "C"
350. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3571"
351. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3571"
  ORDER BY `ordering`
352. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3571"
353. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3571"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
354. SELECT `htocx_virtuemart_manufacturers`.* ,`htocx_virtuemart_manufacturers_en_gb`.*
  FROM `htocx_virtuemart_manufacturers`
  INNER JOIN `htocx_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
  WHERE `htocx_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "45"
355. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3571
356. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 3571
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
357. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "3571"
  and `virtuemart_category_id`= "105"
358. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3571
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
359. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3571
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
360. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3571
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
361. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3571
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
362. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3571
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=178
  ORDER BY field.`ordering`
363. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3584"
364. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3584"
  ORDER BY `ordering`
365. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3584"
366. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3584"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
367. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3584
368. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3571"
  ORDER BY `ordering`
369. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3571"
370. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3571"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
371. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3571
372. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 3571
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
373. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "3571"
  and `virtuemart_category_id`= "105"
374. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3584';
375. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3584';
376. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3582"
377. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3582"
  ORDER BY `ordering`
378. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3582"
379. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3582"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
380. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3582
381. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3582';
382. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3582';
383. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3578"
384. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3578"
  ORDER BY `ordering`
385. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3578"
386. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3578"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
387. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3578
388. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3578';
389. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3578';
390. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3577"
391. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3577"
  ORDER BY `ordering`
392. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3577"
393. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3577"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
394. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3577
395. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3577';
396. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3577';
397. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =3571
398. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3572
  and C.field_type = "C"
399. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3573
  and C.field_type = "C"
400. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3574
  and C.field_type = "C"
401. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3575
  and C.field_type = "C"
402. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3576
  and C.field_type = "C"
403. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3577
  and C.field_type = "C"
404. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3578
  and C.field_type = "C"
405. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3579
  and C.field_type = "C"
406. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3580
  and C.field_type = "C"
407. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3581
  and C.field_type = "C"
408. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3582
  and C.field_type = "C"
409. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3583
  and C.field_type = "C"
410. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3584
  and C.field_type = "C"
411. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3585
  and C.field_type = "C"
412. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4821
  and C.field_type = "C"
413. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3571';
414. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3571';
415. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3868"
416. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3868"
  ORDER BY `ordering`
417. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3868"
418. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3868"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
419. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3868
420. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 3868
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
421. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "3868"
  and `virtuemart_category_id`= "105"
422. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3868
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
423. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3868
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
424. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3868
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
425. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3868
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
426. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =3868
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=192
  ORDER BY field.`ordering`
427. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3869"
428. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3869"
  ORDER BY `ordering`
429. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3869"
430. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3869"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
431. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3869
432. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3868"
  ORDER BY `ordering`
433. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3868"
434. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3868"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
435. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3868
436. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 3868
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
437. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "3868"
  and `virtuemart_category_id`= "105"
438. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3869';
439. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3869';
440. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3870"
441. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3870"
  ORDER BY `ordering`
442. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3870"
443. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3870"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
444. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3870
445. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3870';
446. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3870';
447. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3871"
448. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3871"
  ORDER BY `ordering`
449. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3871"
450. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3871"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
451. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3871
452. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3871';
453. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3871';
454. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3875"
455. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3875"
  ORDER BY `ordering`
456. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3875"
457. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3875"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
458. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3875
459. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3875';
460. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3875';
461. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "3876"
462. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "3876"
  ORDER BY `ordering`
463. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "3876"
464. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "3876"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
465. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 3876
466. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3876';
467. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3876';
468. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "4772"
469. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4772"
  ORDER BY `ordering`
470. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4772"
471. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4772"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
472. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4772
473. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=4772';
474. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=4772';
475. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "5614"
476. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "5614"
  ORDER BY `ordering`
477. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "5614"
478. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "5614"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
479. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 5614
480. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=5614';
481. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=5614';
482. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =3868
483. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3869
  and C.field_type = "C"
484. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3870
  and C.field_type = "C"
485. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3871
  and C.field_type = "C"
486. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3872
  and C.field_type = "C"
487. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3873
  and C.field_type = "C"
488. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3874
  and C.field_type = "C"
489. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3875
  and C.field_type = "C"
490. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =3876
  and C.field_type = "C"
491. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4771
  and C.field_type = "C"
492. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4772
  and C.field_type = "C"
493. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5033
  and C.field_type = "C"
494. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5614
  and C.field_type = "C"
495. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=3868';
496. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=3868';
497. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "4108"
498. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4108"
  ORDER BY `ordering`
499. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4108"
500. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4108"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
501. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4108
502. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 4108
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
503. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "4108"
  and `virtuemart_category_id`= "105"
504. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4108
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
505. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4108
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
506. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4108
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
507. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4108
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
508. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4108
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=204
  ORDER BY field.`ordering`
509. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "4110"
510. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4110"
  ORDER BY `ordering`
511. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4110"
512. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4110"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
513. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4110
514. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4108"
  ORDER BY `ordering`
515. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4108"
516. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4108"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
517. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4108
518. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 4108
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
519. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "4108"
  and `virtuemart_category_id`= "105"
520. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=4110';
521. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=4110';
522. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =4108
523. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4109
  and C.field_type = "C"
524. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4110
  and C.field_type = "C"
525. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4111
  and C.field_type = "C"
526. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4112
  and C.field_type = "C"
527. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4770
  and C.field_type = "C"
528. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =5050
  and C.field_type = "C"
529. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=93&virtuemart_product_id=4108';
530. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=4108';
531. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "4627"
532. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4627"
  ORDER BY `ordering`
533. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4627"
534. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4627"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
535. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4627
536. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 4627
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
537. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "4627"
  and `virtuemart_category_id`= "105"
538. SELECT C.`virtuemart_custom_id` , `custom_element`, `custom_params`, `custom_parent_id` , `admin_only` , `custom_title` , `show_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden`, `layout_pos`, C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4627
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 0
  order by field.`ordering`,virtuemart_custom_id
539. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4627
  and `field_type` = "Z"
  and is_cart_attribute = 0
  order by ordering
540. SELECT C.`virtuemart_custom_id` , `custom_parent_id` , `admin_only` , `custom_title` , `custom_tip` , C.`custom_value` AS value, `custom_field_desc` , `field_type` , `is_list` , `is_hidden` , C.`published` , field.`virtuemart_customfield_id` , field.`custom_value`, field.`custom_param`, field.`custom_price`, field.`ordering`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4627
  and `field_type` = "R"
  and is_cart_attribute = 0
  order by ordering
541. SELECT C.`virtuemart_custom_id`, `custom_title`, `show_title`, C.`custom_value`,`custom_field_desc` ,`custom_tip`,`field_type`,field.`virtuemart_customfield_id`,`is_hidden`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4627
  and `field_type` != "G"
  and `field_type` != "R"
  and `field_type` != "Z"
  and is_cart_attribute = 1
  group by virtuemart_custom_id
  ORDER BY field.`ordering`
542. SELECT field.`virtuemart_product_id`, `custom_params`,`custom_element`, field.`virtuemart_custom_id`, field.`virtuemart_customfield_id`,field.`custom_value`, field.`custom_price`, field.`custom_param`
  FROM `htocx_virtuemart_customs` AS C
  LEFT JOIN `htocx_virtuemart_product_customfields` AS field
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  Where `virtuemart_product_id` =4627
  and is_cart_attribute = 1
  and C.`virtuemart_custom_id`=224
  ORDER BY field.`ordering`
543. SELECT `htocx_virtuemart_products`.* ,`htocx_virtuemart_products_en_gb`.* ,`htocx_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`htocx_virtuemart_product_customfields`.`virtuemart_customfield_id`
  FROM `htocx_virtuemart_products`
  INNER JOIN `htocx_virtuemart_products_en_gb` using (`virtuemart_product_id`)
  LEFT JOIN `htocx_virtuemart_product_manufacturers`
  on `htocx_virtuemart_product_manufacturers`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  LEFT JOIN `htocx_virtuemart_product_customfields`
  on `htocx_virtuemart_product_customfields`.`virtuemart_product_id`=`htocx_virtuemart_products`.`virtuemart_product_id`
  WHERE `htocx_virtuemart_products`.`virtuemart_product_id` = "4628"
544. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4628"
  ORDER BY `ordering`
545. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4628"
546. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4628"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
547. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4628
548. SELECT `virtuemart_media_id`
  FROM `htocx_virtuemart_product_medias`
  WHERE `virtuemart_product_id` = "4627"
  ORDER BY `ordering`
549. SELECT `virtuemart_shoppergroup_id`
  FROM `htocx_virtuemart_product_shoppergroups`
  WHERE `virtuemart_product_id` = "4627"
550. SELECT *
  FROM `htocx_virtuemart_product_prices`
  WHERE `virtuemart_product_id` = "4627"
  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-10-01 19:21:39" )
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-10-01 19:21:39" ) )
  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) )
551. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  WHERE pc.`virtuemart_product_id` = 4627
552. SELECT pc.`virtuemart_category_id`
  FROM `htocx_virtuemart_product_categories` as pc
  LEFT JOIN `htocx_virtuemart_categories` as c
  ON c.`virtuemart_category_id` = pc.`virtuemart_category_id`
  WHERE pc.`virtuemart_product_id` = 4627
  AND `published`=1
  ORDER BY `c`.`ordering` ASC
553. SELECT `ordering`,`id`
  FROM `htocx_virtuemart_product_categories`
  WHERE `virtuemart_product_id` = "4627"
  and `virtuemart_category_id`= "105"
554. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=4628';
555. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=4628';
556. SELECT virtuemart_product_id, product_name
  FROM `htocx_virtuemart_products_en_gb` JOIN `htocx_virtuemart_products` as C using (`virtuemart_product_id`)
  WHERE `product_parent_id` =4627
557. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4628
  and C.field_type = "C"
558. SELECT C.* , field.*
  FROM `htocx_virtuemart_product_customfields` AS field
  LEFT JOIN `htocx_virtuemart_customs` AS C
  ON C.`virtuemart_custom_id` = field.`virtuemart_custom_id`
  WHERE `virtuemart_product_id` =4629
  and C.field_type = "C"
559. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=92&virtuemart_product_id=4627';
560. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=productdetails&virtuemart_category_id=105&virtuemart_product_id=4627';
561. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "907"
562. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "1021"
563. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "1058"
564. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "1124"
565. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "1225"
566. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "1385"
567. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "295"
568. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "676"
569. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "748"
570. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "795"
571. SELECT `htocx_virtuemart_medias`.*
  FROM `htocx_virtuemart_medias`
  WHERE `htocx_virtuemart_medias`.`virtuemart_media_id` = "886"
572. SHOW TABLES
573. SELECT *
  FROM htocx_languages
574. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&lang=en&orderby=virtuemart_product_id&view=category&virtuemart_category_id=105';
575. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&dir=DESC&error=404&lang=en&view=category&virtuemart_category_id=105';
576. SELECT b.id
  FROM htocx_usergroups AS a
  LEFT JOIN htocx_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
577. SELECT a.rules
  FROM htocx_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
578. SHOW FULL COLUMNS
  FROM `htocx_assets`
579. SELECT id
  FROM htocx_assets
  WHERE parent_id = 0
580. SELECT b.rules
  FROM htocx_assets AS a
  LEFT JOIN htocx_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.id = 1)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
581. SELECT b.rules
  FROM htocx_assets AS a
  LEFT JOIN htocx_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_virtuemart')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
582. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=category&virtuemart_category_id=92';
583. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=category&virtuemart_category_id=93';
584. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&lang=en&view=category&virtuemart_category_id=105';
585. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&filter_product=&keyword=&lang=en&
  limit=15&limitstart=0&view=category&virtuemart_category_id=105';
586. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&filter_product=&keyword=&lang=en&
  limit=30&limitstart=0&view=category&virtuemart_category_id=105';
587. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&filter_product=&keyword=&lang=en&
  limit=60&limitstart=0&view=category&virtuemart_category_id=105';
588. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&filter_product=&keyword=&lang=en&
  limit=150&limitstart=0&view=category&virtuemart_category_id=105';
589. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&filter_product=&keyword=&lang=en&
  limit=18&limitstart=0&view=category&virtuemart_category_id=105';
590. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&filter_product=&keyword=&lang=en&
  limit=18&limitstart=0&view=category&virtuemart_category_id=105';
591. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&lang=en&view=category&virtuemart_category_id=105';
592. SELECT params
  FROM htocx_extensions AS e
  WHERE e.element='com_widgetkit'
593. SELECT `oldurl`, `dateadd`
  FROM htocx_sh404sef_urls
  WHERE `newurl`='index.php?option=com_widgetkit&id=&lang=en&tmpl=raw';
594. SELECT `pageid`
  FROM htocx_sh404sef_pageids
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&lang=en&limitstart=0&view=category&virtuemart_category_id=105';
595. SELECT CONCAT(`vendor_accepted_currencies`, ",",`vendor_currency`) AS all_currencies, `vendor_currency`
  FROM `htocx_virtuemart_vendors`
  WHERE `virtuemart_vendor_id`=1
596. SELECT `virtuemart_currency_id`,CONCAT_WS(" ",`currency_name`,`currency_symbol`) as currency_txt
  FROM `htocx_virtuemart_currencies`
  WHERE `virtuemart_currency_id` IN (52,26,47,144,144)
  and (`virtuemart_vendor_id` = "1" OR `shared`="1")
  AND published = "1"
  ORDER BY `ordering`,`currency_name`
597. SELECT *
  FROM htocx_jmap_metainfo
  WHERE `linkurl` = 'https://www.stockingshowcase.com/shopping-cart/stockings/modern/lacetop.html'
  AND `published` = 1
598. SHOW FULL COLUMNS
  FROM `htocx_sh404sef_metas`
599. SELECT *
  FROM htocx_sh404sef_metas
  WHERE `newurl`='index.php?option=com_virtuemart&Itemid=109&error=404&lang=en&limitstart=0&view=category&virtuemart_category_id=105';
600. UPDATE `htocx_session`
  SET `data` = 'joomla|s:2688:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjI7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzU5MzQ2NDk4O3M6NDoibGFzdCI7aToxNzU5MzQ2NDk4O3M6Mzoibm93IjtpOjE3NTkzNDY0OTk7fXM6NToidG9rZW4iO3M6MzI6IjQ5N2E5NTY5Mjc0ZDAxZjNjNWZlYmQ4ZmI0ZjM4ZTM1Ijt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MTp7czoxNDoiY29tX3ZpcnR1ZW1hcnQiO086ODoic3RkQ2xhc3MiOjE6e3M6MTQ6ImNhdGVnb3J5YzEwNW0wIjtPOjg6InN0ZENsYXNzIjoxOntzOjEwOiJsaW1pdHN0YXJ0IjtpOjA7fX19fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtiOjA7czoyOiJpZCI7aTowO3M6NDoibmFtZSI7TjtzOjg6InVzZXJuYW1lIjtOO3M6NToiZW1haWwiO047czo4OiJwYXNzd29yZCI7TjtzOjE0OiJwYXNzd29yZF9jbGVhciI7czowOiIiO3M6ODoidXNlcnR5cGUiO047czo1OiJibG9jayI7TjtzOjk6InNlbmRFbWFpbCI7aTowO3M6MTI6InJlZ2lzdGVyRGF0ZSI7TjtzOjEzOiJsYXN0dmlzaXREYXRlIjtOO3M6MTA6ImFjdGl2YXRpb24iO047czo2OiJwYXJhbXMiO047czo2OiJncm91cHMiO2E6MDp7fXM6NToiZ3Vlc3QiO2k6MTtzOjEzOiJsYXN0UmVzZXRUaW1lIjtOO3M6MTA6InJlc2V0Q291bnQiO047czoxMDoiACoAX3BhcmFtcyI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjE0OiIAKgBfYXV0aEdyb3VwcyI7YToxOntpOjA7aToxO31zOjE0OiIAKgBfYXV0aExldmVscyI7YToyOntpOjA7aToxO2k6MTtpOjE7fXM6MTU6IgAqAF9hdXRoQWN0aW9ucyI7TjtzOjEyOiIAKgBfZXJyb3JNc2ciO047czoxMDoiACoAX2Vycm9ycyI7YTowOnt9czozOiJhaWQiO2k6MDt9czoxMToiYXBwbGljYXRpb24iO086ODoic3RkQ2xhc3MiOjE6e3M6NToicXVldWUiO047fX1zOjQ6Il9fdm0iO086ODoic3RkQ2xhc3MiOjQ6e3M6Njoidm1jYXJ0IjtzOjc1MjoiTzo4OiJzdGRDbGFzcyI6Mjg6e3M6ODoicHJvZHVjdHMiO2E6MDp7fXM6ODoidmVuZG9ySWQiO2k6MTtzOjIxOiJsYXN0VmlzaXRlZENhdGVnb3J5SWQiO2k6MDtzOjI4OiJ2aXJ0dWVtYXJ0X3NoaXBtZW50bWV0aG9kX2lkIjtpOjA7czoyNzoidmlydHVlbWFydF9wYXltZW50bWV0aG9kX2lkIjtpOjA7czoyNToiYXV0b21hdGljU2VsZWN0ZWRTaGlwbWVudCI7YjowO3M6MjQ6ImF1dG9tYXRpY1NlbGVjdGVkUGF5bWVudCI7YjowO3M6MTI6Im9yZGVyX251bWJlciI7TjtzOjE5OiJ2aXJ0dWVtYXJ0X29yZGVyX2lkIjtiOjA7czoyOiJCVCI7aTowO3M6MjoiU1QiO2k6MDtzOjExOiJ0b3NBY2NlcHRlZCI7YjowO3M6MTY6ImN1c3RvbWVyX2NvbW1lbnQiO3M6MDoiIjtzOjEwOiJjb3Vwb25Db2RlIjtzOjA6IiI7czoyMDoiX3RyaWVzVmFsaWRhdGVDb3Vwb24iO2E6MDp7fXM6MTQ6Im9yZGVyX2xhbmd1YWdlIjtzOjA6IiI7czo4OiJjYXJ0RGF0YSI7TjtzOjU6Imxpc3RzIjtOO3M6MTQ6InByaWNlc0N1cnJlbmN5IjtOO3M6MTU6InBheW1lbnRDdXJyZW5jeSI7TjtzOjEwOiJfaW5Db25maXJtIjtiOjA7czoxMToiX2luQ2hlY2tPdXQiO2I6MDtzOjE0OiJfZGF0YVZhbGlkYXRlZCI7YjowO3M6MTI6Il9jb25maXJtRG9uZSI7YjowO3M6MTA6IlNUc2FtZUFzQlQiO2I6MTtzOjE1OiJjdXN0b21lcl9udW1iZXIiO3M6Nzoibm9ucmVnXyI7czo2OiJsYXlvdXQiO3M6NzoiZGVmYXVsdCI7czoxMDoibGF5b3V0UGF0aCI7czowOiIiO30iO3M6MjM6InZtbGFzdHZpc2l0ZWRjYXRlZ29yeWlkIjtpOjEwNTtzOjE5OiJ2bWxhc3R2aXNpdGVkbWFudWlkIjtpOi0xO3M6MTU6InZtbGFzdHZpc0l0ZW1pZCI7aToxMDk7fX19\";' , `time` = '1759346499'
  WHERE `session_id` = '078470927072b3836638e1ae6fd57706'