Profile Information

Memory Usage

896 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '48q37sqldcao1qtqc1kalp5ai7'
2. DELETE
     FROM jos_session
     WHERE ( time < '1746230989' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '48q37sqldcao1qtqc1kalp5ai7'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '48q37sqldcao1qtqc1kalp5ai7','1746238189','','0','1','0' )
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT m.*, c.`option` AS component
     FROM jos_menu AS m
     LEFT JOIN jos_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT *
     FROM jos_redshop_configuration
9. SELECT *
     FROM jos_redshop_catalog_request
     WHERE block = 0
10. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
11. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-05-02'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '48q37sqldcao1qtqc1kalp5ai7'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('48q37sqldcao1qtqc1kalp5ai7', '0','1746238192')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '48q37sqldcao1qtqc1kalp5ai7'
      AND section='category'
      AND section_id='58'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('48q37sqldcao1qtqc1kalp5ai7','0','category','58','1746238196')
16. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
17. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
18. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=58
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
19. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=58
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
20. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=58
      AND published = 1
      ORDER BY c.category_name ASC
21. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '58'
22. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=58%')
      ORDER BY 'ordering'
23. SELECT *
      FROM jos_menu
      WHERE id = '222'
24. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
25. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='58'
      AND c.category_id = cx.category_parent_id
26. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
27. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=58
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 15, 15
28. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=58
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
29. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=58
      AND published = 1
      ORDER BY c.category_name ASC
30. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '58'
31. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=58%')
      ORDER BY 'ordering'
32. SELECT *
      FROM jos_menu
      WHERE id = '222'
33. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
34. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='58'
      AND c.category_id = cx.category_parent_id
35. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
36. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=127
      AND p.published = 1
      ORDER BY a.ordering ASC
37. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=127
      AND t.published = 1
      LIMIT 0,1
38. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
39. SELECT *
      FROM jos_menu
      WHERE id = '222'
40. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '127'
41. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '127'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
42. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='58'
      AND c.category_id = cx.category_parent_id
43. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
44. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
45. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
46. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='127'
      AND section='1'
47. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 127
48. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 127
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
49. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
50. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746238197'
      AND end_date >= '1746238197' 
      ORDER BY amount DESC
      LIMIT 0,1
51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
52. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
53. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
54. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
55. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
56. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
57. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
58. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
59. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
60. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 127
      AND ps.stockroom_id = s.stockroom_id
61. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 127
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
      AND discount_enddate>='1746238197'
      AND discount_stratdate<='1746238197'
63. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 127
64. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 127
      AND ps.stockroom_id = s.stockroom_id
65. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
66. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="127"
      AND media_type="images" 
      AND media_name = "1307726316_GIR9400-3B.jpg"
67. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
68. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 127
      AND ps.stockroom_id = s.stockroom_id
69. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
70. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 127
71. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 127
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
72. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
73. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746238197'
      AND end_date >= '1746238197' 
      ORDER BY amount DESC
      LIMIT 0,1
74. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
75. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
76. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
77. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
78. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
      AND discount_enddate>='1746238197'
      AND discount_stratdate<='1746238197'
79. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 127
      AND ps.stockroom_id = s.stockroom_id
80. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
81. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 127
82. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 127
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
83. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
84. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746238197'
      AND end_date >= '1746238197' 
      ORDER BY amount DESC
      LIMIT 0,1
85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
86. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
87. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
88. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
89. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 127
      AND discount_enddate>='1746238197'
      AND discount_stratdate<='1746238197'
90. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=141
      AND p.published = 1
      ORDER BY a.ordering ASC
91. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=141
      AND t.published = 1
      LIMIT 0,1
92. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
93. SELECT *
      FROM jos_menu
      WHERE id = '222'
94. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '141'
95. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '141'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
96. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='58'
      AND c.category_id = cx.category_parent_id
97. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
98. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
99. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
100. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='141'
       AND section='1'
101. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 141
102. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 141
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
103. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
104. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
105. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
106. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
107. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
108. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
109. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
110. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
111. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
112. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
113. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
114. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 141
       AND ps.stockroom_id = s.stockroom_id
115. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 141
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
116. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
117. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 141
118. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 141
       AND ps.stockroom_id = s.stockroom_id
119. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
120. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="141"
       AND media_type="images" 
       AND media_name = "1307735645_GIR9401-1B.jpg"
121. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
122. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 141
       AND ps.stockroom_id = s.stockroom_id
123. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
124. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 141
125. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 141
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
126. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
127. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
128. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
129. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
130. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
131. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
132. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
133. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 141
       AND ps.stockroom_id = s.stockroom_id
134. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
135. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 141
136. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 141
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
137. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
138. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
139. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
140. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
141. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
142. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
143. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 141
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
144. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=144
       AND p.published = 1
       ORDER BY a.ordering ASC
145. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=144
       AND t.published = 1
       LIMIT 0,1
146. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
147. SELECT *
       FROM jos_menu
       WHERE id = '222'
148. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '144'
149. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '144'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
150. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
151. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
152. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
153. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
154. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='144'
       AND section='1'
155. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 144
156. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 144
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
157. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
158. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
159. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
160. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
161. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
162. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
163. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
164. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
165. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
166. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
167. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
168. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 144
       AND ps.stockroom_id = s.stockroom_id
169. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 144
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
170. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
171. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 144
172. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 144
       AND ps.stockroom_id = s.stockroom_id
173. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
174. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="144"
       AND media_type="images" 
       AND media_name = "1307736697_GIR9401-2B.jpg"
175. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
176. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 144
       AND ps.stockroom_id = s.stockroom_id
177. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
178. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 144
179. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 144
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
180. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
181. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
182. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
183. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
184. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
185. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
186. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
187. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 144
       AND ps.stockroom_id = s.stockroom_id
188. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
189. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 144
190. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 144
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
191. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
192. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
193. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
194. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
195. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
196. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
197. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 144
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
198. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=173
       AND p.published = 1
       ORDER BY a.ordering ASC
199. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=173
       AND t.published = 1
       LIMIT 0,1
200. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
201. SELECT *
       FROM jos_menu
       WHERE id = '222'
202. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '173'
203. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '173'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
204. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
205. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
206. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
207. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
208. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='173'
       AND section='1'
209. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 173
210. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 173
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
211. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
212. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
213. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
214. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
215. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
216. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
217. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
218. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
219. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
220. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
221. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
222. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 173
       AND ps.stockroom_id = s.stockroom_id
223. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 173
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
224. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
225. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 173
226. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 173
       AND ps.stockroom_id = s.stockroom_id
227. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
228. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="173"
       AND media_type="images" 
       AND media_name = "1308076095_GIR9402-1B.jpg"
229. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
230. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 173
       AND ps.stockroom_id = s.stockroom_id
231. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
232. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 173
233. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 173
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
234. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
235. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
236. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
237. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
238. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
239. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
240. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
241. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 173
       AND ps.stockroom_id = s.stockroom_id
242. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
243. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 173
244. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 173
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
245. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
246. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
247. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
248. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
249. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
250. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
251. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 173
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
252. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=93
       AND p.published = 1
       ORDER BY a.ordering ASC
253. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=93
       AND t.published = 1
       LIMIT 0,1
254. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
255. SELECT *
       FROM jos_menu
       WHERE id = '222'
256. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '93'
257. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '93'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
258. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
259. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
260. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
261. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
262. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='93'
       AND section='1'
263. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 93
264. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 93
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
265. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
266. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
267. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
268. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
269. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
270. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
271. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
272. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
273. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
274. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
275. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
276. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 93
       AND ps.stockroom_id = s.stockroom_id
277. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 93
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
278. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
279. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 93
280. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 93
       AND ps.stockroom_id = s.stockroom_id
281. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
282. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="93"
       AND media_type="images" 
       AND media_name = "1307566197_GIR9403-1B.jpg"
283. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
284. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 93
       AND ps.stockroom_id = s.stockroom_id
285. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
286. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 93
287. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 93
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
288. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
289. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
290. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
291. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
292. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
293. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
294. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
295. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 93
       AND ps.stockroom_id = s.stockroom_id
296. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
297. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 93
298. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 93
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
299. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
300. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
301. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
302. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
303. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
304. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
305. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 93
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
306. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=98
       AND p.published = 1
       ORDER BY a.ordering ASC
307. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=98
       AND t.published = 1
       LIMIT 0,1
308. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
309. SELECT *
       FROM jos_menu
       WHERE id = '222'
310. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '98'
311. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '98'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
312. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
313. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
314. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
315. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
316. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='98'
       AND section='1'
317. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 98
318. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 98
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
319. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
320. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
321. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
322. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
323. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
324. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
325. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
326. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
327. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
328. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
329. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
330. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 98
       AND ps.stockroom_id = s.stockroom_id
331. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 98
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
332. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
333. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 98
334. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 98
       AND ps.stockroom_id = s.stockroom_id
335. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
336. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="98"
       AND media_type="images" 
       AND media_name = "1307630630_GIR9403-2B.jpg"
337. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
338. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 98
       AND ps.stockroom_id = s.stockroom_id
339. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
340. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 98
341. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 98
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
342. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
343. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
344. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
345. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
346. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
347. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
348. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
349. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 98
       AND ps.stockroom_id = s.stockroom_id
350. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
351. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 98
352. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 98
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
353. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
354. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
355. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
356. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
357. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
358. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
359. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 98
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
360. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=88
       AND p.published = 1
       ORDER BY a.ordering ASC
361. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=88
       AND t.published = 1
       LIMIT 0,1
362. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
363. SELECT *
       FROM jos_menu
       WHERE id = '222'
364. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '88'
365. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '88'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
366. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
367. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
368. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
369. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
370. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='88'
       AND section='1'
371. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 88
372. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 88
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
373. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
374. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
375. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
376. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
377. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
378. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
379. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
380. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
381. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
382. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
383. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
384. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 88
       AND ps.stockroom_id = s.stockroom_id
385. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 88
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
386. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
387. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 88
388. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 88
       AND ps.stockroom_id = s.stockroom_id
389. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
390. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="88"
       AND media_type="images" 
       AND media_name = "1307555687_GIR9403-3B.jpg"
391. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
392. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 88
       AND ps.stockroom_id = s.stockroom_id
393. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
394. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 88
395. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 88
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
396. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
397. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
398. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
399. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
400. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
401. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
402. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
403. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 88
       AND ps.stockroom_id = s.stockroom_id
404. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
405. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 88
406. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 88
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
407. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
408. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
409. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
410. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
411. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
412. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
413. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
414. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=90
       AND p.published = 1
       ORDER BY a.ordering ASC
415. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=90
       AND t.published = 1
       LIMIT 0,1
416. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
417. SELECT *
       FROM jos_menu
       WHERE id = '222'
418. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '90'
419. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '90'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
420. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
421. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
422. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
423. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
424. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='90'
       AND section='1'
425. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 90
426. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 90
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
427. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
428. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
429. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
430. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
431. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
432. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
433. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
434. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
435. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
436. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
437. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
438. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 90
       AND ps.stockroom_id = s.stockroom_id
439. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 90
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
440. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
441. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 90
442. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 90
       AND ps.stockroom_id = s.stockroom_id
443. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
444. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="90"
       AND media_type="images" 
       AND media_name = "1307558555_GIR9404-1B.jpg"
445. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
446. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 90
       AND ps.stockroom_id = s.stockroom_id
447. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
448. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 90
449. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 90
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
450. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
451. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
452. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
453. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
454. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
455. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
456. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
457. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 90
       AND ps.stockroom_id = s.stockroom_id
458. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
459. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 90
460. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 90
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
461. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
462. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
463. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
464. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
465. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
466. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
467. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
468. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=161
       AND p.published = 1
       ORDER BY a.ordering ASC
469. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=161
       AND t.published = 1
       LIMIT 0,1
470. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
471. SELECT *
       FROM jos_menu
       WHERE id = '222'
472. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '161'
473. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '161'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
474. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
475. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
476. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
477. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
478. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='161'
       AND section='1'
479. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 161
480. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 161
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
481. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
482. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
483. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
484. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
485. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
486. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
487. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
488. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
489. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
490. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
491. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
492. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 161
       AND ps.stockroom_id = s.stockroom_id
493. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 161
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
494. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
495. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 161
496. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 161
       AND ps.stockroom_id = s.stockroom_id
497. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
498. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="161"
       AND media_type="images" 
       AND media_name = "1308062330_GIR9404-2B.jpg"
499. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
500. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 161
       AND ps.stockroom_id = s.stockroom_id
501. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
502. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 161
503. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 161
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
504. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
505. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
506. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
507. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
508. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
509. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
510. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
511. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 161
       AND ps.stockroom_id = s.stockroom_id
512. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
513. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 161
514. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 161
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
515. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
516. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
517. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
518. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
519. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
520. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
521. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 161
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
522. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=87
       AND p.published = 1
       ORDER BY a.ordering ASC
523. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=87
       AND t.published = 1
       LIMIT 0,1
524. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
525. SELECT *
       FROM jos_menu
       WHERE id = '222'
526. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '87'
527. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '87'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
528. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
529. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
530. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
531. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
532. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='87'
       AND section='1'
533. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 87
534. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 87
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
535. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
536. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
537. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
538. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
539. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
540. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
541. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
542. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
543. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
544. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
545. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
546. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 87
       AND ps.stockroom_id = s.stockroom_id
547. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 87
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
548. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
549. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 87
550. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 87
       AND ps.stockroom_id = s.stockroom_id
551. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
552. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="87"
       AND media_type="images" 
       AND media_name = "1307553969_GIR9405-1B.jpg"
553. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
554. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 87
       AND ps.stockroom_id = s.stockroom_id
555. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
556. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 87
557. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 87
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
558. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
559. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
560. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
561. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
562. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
563. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
564. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
565. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 87
       AND ps.stockroom_id = s.stockroom_id
566. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
567. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 87
568. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 87
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
569. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
570. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
571. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
572. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
573. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
574. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
575. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
576. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=134
       AND p.published = 1
       ORDER BY a.ordering ASC
577. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=134
       AND t.published = 1
       LIMIT 0,1
578. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
579. SELECT *
       FROM jos_menu
       WHERE id = '222'
580. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '134'
581. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '134'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
582. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
583. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
584. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
585. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
586. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='134'
       AND section='1'
587. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 134
588. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 134
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
589. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
590. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
591. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
592. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
593. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
594. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
595. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
596. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
597. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
598. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
599. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
600. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 134
       AND ps.stockroom_id = s.stockroom_id
601. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 134
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
602. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
603. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 134
604. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 134
       AND ps.stockroom_id = s.stockroom_id
605. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
606. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="134"
       AND media_type="images" 
       AND media_name = "1307730657_GIR9405-2B.jpg"
607. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
608. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 134
       AND ps.stockroom_id = s.stockroom_id
609. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
610. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 134
611. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 134
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
612. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
613. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
614. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
615. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
616. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
617. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
618. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
619. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 134
       AND ps.stockroom_id = s.stockroom_id
620. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
621. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 134
622. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 134
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
623. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
624. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
625. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
626. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
627. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
628. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
629. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 134
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
630. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=155
       AND p.published = 1
       ORDER BY a.ordering ASC
631. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=155
       AND t.published = 1
       LIMIT 0,1
632. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
633. SELECT *
       FROM jos_menu
       WHERE id = '222'
634. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '155'
635. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '155'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
636. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
637. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
638. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
639. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
640. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='155'
       AND section='1'
641. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 155
642. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 155
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
643. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
644. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
645. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
646. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
647. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
648. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
649. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
650. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
651. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
652. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
653. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
654. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 155
       AND ps.stockroom_id = s.stockroom_id
655. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 155
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
656. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
657. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 155
658. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 155
       AND ps.stockroom_id = s.stockroom_id
659. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
660. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="155"
       AND media_type="images" 
       AND media_name = "1308059355_GIR9406-1B.jpg"
661. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
662. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 155
       AND ps.stockroom_id = s.stockroom_id
663. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
664. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 155
665. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 155
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
666. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
667. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
668. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
669. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
670. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
671. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
672. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
673. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 155
       AND ps.stockroom_id = s.stockroom_id
674. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
675. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 155
676. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 155
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
677. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
678. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
679. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
680. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
681. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
682. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
683. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 155
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
684. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=150
       AND p.published = 1
       ORDER BY a.ordering ASC
685. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=150
       AND t.published = 1
       LIMIT 0,1
686. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
687. SELECT *
       FROM jos_menu
       WHERE id = '222'
688. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '150'
689. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '150'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
690. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
691. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
692. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
693. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
694. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='150'
       AND section='1'
695. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 150
696. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 150
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
697. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
698. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
699. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
700. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
701. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
702. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
703. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
704. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
705. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
706. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
707. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
708. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 150
       AND ps.stockroom_id = s.stockroom_id
709. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 150
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
710. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
711. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 150
712. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 150
       AND ps.stockroom_id = s.stockroom_id
713. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
714. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="150"
       AND media_type="images" 
       AND media_name = "1307974977_GIR9406-2B.jpg"
715. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
716. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 150
       AND ps.stockroom_id = s.stockroom_id
717. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
718. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 150
719. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 150
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
720. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
721. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
722. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
723. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
724. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
725. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
726. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
727. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 150
       AND ps.stockroom_id = s.stockroom_id
728. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
729. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 150
730. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 150
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
731. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
732. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
733. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
734. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
735. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
736. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
737. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
738. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=152
       AND p.published = 1
       ORDER BY a.ordering ASC
739. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=152
       AND t.published = 1
       LIMIT 0,1
740. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
741. SELECT *
       FROM jos_menu
       WHERE id = '222'
742. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '152'
743. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '152'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
744. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
745. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
746. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
747. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
748. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='152'
       AND section='1'
749. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 152
750. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 152
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
751. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
752. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
753. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
754. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
755. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
756. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
757. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
758. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
759. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
760. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
761. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
762. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 152
       AND ps.stockroom_id = s.stockroom_id
763. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 152
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
764. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
765. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 152
766. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 152
       AND ps.stockroom_id = s.stockroom_id
767. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
768. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="152"
       AND media_type="images" 
       AND media_name = "1308058095_GIR9406-3B.jpg"
769. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
770. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 152
       AND ps.stockroom_id = s.stockroom_id
771. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
772. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 152
773. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 152
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
774. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
775. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
776. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
777. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
778. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
779. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
780. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
781. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 152
       AND ps.stockroom_id = s.stockroom_id
782. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
783. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 152
784. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 152
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
785. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
786. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
787. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
788. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
789. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
790. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
791. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
792. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=109
       AND p.published = 1
       ORDER BY a.ordering ASC
793. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=109
       AND t.published = 1
       LIMIT 0,1
794. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
795. SELECT *
       FROM jos_menu
       WHERE id = '222'
796. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '109'
797. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '109'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
798. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
799. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
800. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
801. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
802. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='109'
       AND section='1'
803. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 109
804. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 109
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
805. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
806. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
807. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
808. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
809. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
810. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
811. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
812. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
813. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
814. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
815. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
816. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 109
       AND ps.stockroom_id = s.stockroom_id
817. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 109
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
818. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
819. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 109
820. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 109
       AND ps.stockroom_id = s.stockroom_id
821. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
822. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="109"
       AND media_type="images" 
       AND media_name = "1307647463_GIR9407-1B.jpg"
823. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
824. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 109
       AND ps.stockroom_id = s.stockroom_id
825. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
826. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 109
827. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 109
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
828. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
829. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
830. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
831. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
832. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
833. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
834. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
835. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 109
       AND ps.stockroom_id = s.stockroom_id
836. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
837. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 109
838. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 109
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
839. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
840. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238197'
       AND end_date >= '1746238197' 
       ORDER BY amount DESC
       LIMIT 0,1
841. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
842. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
843. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
844. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
845. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
       AND discount_enddate>='1746238197'
       AND discount_stratdate<='1746238197'
846. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 58
847. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '222'
848. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params NOT LIKE '%categoryid%'
849. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=58
     %'
850. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 58
851. SELECT *
       FROM jos_menu
       WHERE id = '222'
852. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
853. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
854. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
855. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=58
856. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=56
     %'
857. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 56
858. SELECT *
       FROM jos_menu
       WHERE id = '222'
859. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '56'
860. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
861. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=56
862. SELECT *
       FROM jos_menu
       WHERE id = '222'
863. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
864. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
865. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
866. SELECT *
       FROM jos_menu
       WHERE id = '222'
867. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
868. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
869. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
870. SELECT *
       FROM jos_menu
       WHERE id = '222'
871. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
872. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
873. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
874. SELECT *
       FROM jos_menu
       WHERE id = '222'
875. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
876. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
877. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
878. SELECT *
       FROM jos_menu
       WHERE id = '222'
879. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
880. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
881. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
882. SELECT *
       FROM jos_menu
       WHERE id = '222'
883. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
884. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
885. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
886. SELECT *
       FROM jos_menu
       WHERE id = '222'
887. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
888. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
889. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
890. SELECT id, title, module, position, content, showtitle, control, params
       FROM jos_modules AS m
       LEFT JOIN jos_modules_menu AS mm
       ON mm.moduleid = m.id
       WHERE m.published = 1
       AND m.access <= 0
       AND m.client_id = 0
       AND ( mm.menuid = 222 OR mm.menuid = 0 )
       ORDER BY position, ordering
891. SELECT *
       FROM jos_menu
       WHERE id = '71'
892. SELECT *
       FROM jos_menu
       WHERE id = '222'
893. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
894. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`link` LIKE '%id=216%'  OR `params` LIKE '%categoryid=216%')
       ORDER BY 'ordering'
895. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
896. SELECT *
       FROM jos_menu
       WHERE id = '222'