Profile Information

Memory Usage

900 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '7hr16ecv0htpqubq3eqnfbf0l6'
2. DELETE
     FROM jos_session
     WHERE ( time < '1746230989' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '7hr16ecv0htpqubq3eqnfbf0l6'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '7hr16ecv0htpqubq3eqnfbf0l6','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 = '7hr16ecv0htpqubq3eqnfbf0l6'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('7hr16ecv0htpqubq3eqnfbf0l6', '0','1746238191')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '7hr16ecv0htpqubq3eqnfbf0l6'
      AND section='category'
      AND section_id='57'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('7hr16ecv0htpqubq3eqnfbf0l6','0','category','57','1746238195')
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=57
      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=57
      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=57
      AND published = 1
      ORDER BY c.category_name ASC
21. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '57'
22. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=57%')
      ORDER BY 'ordering'
23. SELECT *
      FROM jos_menu
      WHERE id = '222'
24. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
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='57'
      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=57
      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=57
      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=57
      AND published = 1
      ORDER BY c.category_name ASC
30. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '57'
31. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=57%')
      ORDER BY 'ordering'
32. SELECT *
      FROM jos_menu
      WHERE id = '222'
33. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
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='57'
      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=135
      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=135
      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 = '135'
41. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '135'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
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='57'
      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 = '57'
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='135'
      AND section='1'
47. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 135
48. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 135
      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 <= '1746238195'
      AND end_date >= '1746238195' 
      ORDER BY amount DESC
      LIMIT 0,1
51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
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 = 135
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 = 135
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 = 135
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 = 135
      AND ps.stockroom_id = s.stockroom_id
61. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 135
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
      AND discount_enddate>='1746238195'
      AND discount_stratdate<='1746238195'
63. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 135
64. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 135
      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 ="135"
      AND media_type="images" 
      AND media_name = "1307731276_GIR3604-7.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 = 135
      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 = 135
71. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 135
      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 <= '1746238195'
      AND end_date >= '1746238195' 
      ORDER BY amount DESC
      LIMIT 0,1
74. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
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 = 135
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 = 135
      AND discount_enddate>='1746238195'
      AND discount_stratdate<='1746238195'
79. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 135
      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 = 135
82. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 135
      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 <= '1746238195'
      AND end_date >= '1746238195' 
      ORDER BY amount DESC
      LIMIT 0,1
85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
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 = 135
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 = 135
      AND discount_enddate>='1746238195'
      AND discount_stratdate<='1746238195'
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=166
      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=166
      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 = '166'
95. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '166'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
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='57'
      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 = '57'
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='166'
       AND section='1'
101. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 166
102. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 166
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
105. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
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 = 166
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 = 166
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 = 166
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 = 166
       AND ps.stockroom_id = s.stockroom_id
115. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 166
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
116. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
117. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 166
118. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 166
       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 ="166"
       AND media_type="images" 
       AND media_name = "1308069513_GIR3606-15.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 = 166
       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 = 166
125. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 166
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
128. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
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 = 166
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 = 166
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
133. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 166
       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 = 166
136. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 166
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
139. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
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 = 166
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 = 166
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=169
       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=169
       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 = '169'
149. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '169'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='169'
       AND section='1'
155. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 169
156. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 169
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
159. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
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 = 169
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 = 169
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 = 169
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 = 169
       AND ps.stockroom_id = s.stockroom_id
169. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 169
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
170. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
171. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 169
172. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 169
       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 ="169"
       AND media_type="images" 
       AND media_name = "1308070841_Simple Damask Grape.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 = 169
       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 = 169
179. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 169
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
182. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
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 = 169
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 = 169
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
187. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 169
       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 = 169
190. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 169
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
193. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
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 = 169
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 = 169
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=172
       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=172
       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 = '172'
203. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '172'
       AND pc.category_id = c.category_id
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='57'
       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 = '57'
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='172'
       AND section='1'
209. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 172
210. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 172
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
213. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
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 = 172
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 = 172
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 = 172
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 = 172
       AND ps.stockroom_id = s.stockroom_id
223. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 172
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
224. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
225. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 172
226. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 172
       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 ="172"
       AND media_type="images" 
       AND media_name = "1308075449_GU4707_5.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 = 172
       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 = 172
233. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 172
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
236. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
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 = 172
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 = 172
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
241. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 172
       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 = 172
244. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 172
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
247. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
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 = 172
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 = 172
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=117
       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=117
       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 = '117'
257. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '117'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='117'
       AND section='1'
263. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 117
264. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 117
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
267. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
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 = 117
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 = 117
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 = 117
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 = 117
       AND ps.stockroom_id = s.stockroom_id
277. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 117
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
278. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
279. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 117
280. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 117
       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 ="117"
       AND media_type="images" 
       AND media_name = "1307723884_GIR6618-21.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 = 117
       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 = 117
287. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 117
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
290. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
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 = 117
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 = 117
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
295. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 117
       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 = 117
298. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 117
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
301. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
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 = 117
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 = 117
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=177
       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=177
       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 = '177'
311. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '177'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='177'
       AND section='1'
317. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 177
318. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 177
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
321. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
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 = 177
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 = 177
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 = 177
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 = 177
       AND ps.stockroom_id = s.stockroom_id
331. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 177
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
332. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
333. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 177
334. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 177
       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 ="177"
       AND media_type="images" 
       AND media_name = "1308078251_GIR7616-10.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 = 177
       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 = 177
341. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 177
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
344. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
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 = 177
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 = 177
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
349. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 177
       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 = 177
352. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 177
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
355. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
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 = 177
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 = 177
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=102
       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=102
       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 = '102'
365. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '102'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='102'
       AND section='1'
371. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 102
372. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 102
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
375. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
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 = 102
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 = 102
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 = 102
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 = 102
       AND ps.stockroom_id = s.stockroom_id
385. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 102
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
386. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
387. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 102
388. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 102
       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 ="102"
       AND media_type="images" 
       AND media_name = "1307633921_GIR7616-20.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 = 102
       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 = 102
395. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 102
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
398. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
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 = 102
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 = 102
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
403. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 102
       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 = 102
406. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 102
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
409. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
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 = 102
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 = 102
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=179
       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=179
       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 = '179'
419. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '179'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='179'
       AND section='1'
425. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 179
426. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 179
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
429. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
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 = 179
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 = 179
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 = 179
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 = 179
       AND ps.stockroom_id = s.stockroom_id
439. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 179
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
440. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
441. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 179
442. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 179
       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 ="179"
       AND media_type="images" 
       AND media_name = "1308079399_GIR7616-21.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 = 179
       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 = 179
449. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 179
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
452. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
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 = 179
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 = 179
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
457. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 179
       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 = 179
460. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 179
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
463. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
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 = 179
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 = 179
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=165
       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=165
       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 = '165'
473. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '165'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='165'
       AND section='1'
479. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 165
480. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 165
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
483. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
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 = 165
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 = 165
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 = 165
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 = 165
       AND ps.stockroom_id = s.stockroom_id
493. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 165
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
494. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
495. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 165
496. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 165
       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 ="165"
       AND media_type="images" 
       AND media_name = "1308068446_GIR9300-4.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 = 165
       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 = 165
503. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 165
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
506. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
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 = 165
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 = 165
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
511. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 165
       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 = 165
514. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 165
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
517. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
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 = 165
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 = 165
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=168
       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=168
       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 = '168'
527. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '168'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='168'
       AND section='1'
533. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 168
534. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 168
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
537. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
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 = 168
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 = 168
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 = 168
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 = 168
       AND ps.stockroom_id = s.stockroom_id
547. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 168
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
548. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
549. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 168
550. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 168
       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 ="168"
       AND media_type="images" 
       AND media_name = "1308070454_GIR9300-5.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 = 168
       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 = 168
557. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 168
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
560. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
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 = 168
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 = 168
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
565. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 168
       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 = 168
568. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 168
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
571. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
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 = 168
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 = 168
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=107
       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=107
       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 = '107'
581. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '107'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='107'
       AND section='1'
587. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 107
588. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 107
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
591. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
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 = 107
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 = 107
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 = 107
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 = 107
       AND ps.stockroom_id = s.stockroom_id
601. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 107
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
602. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
603. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 107
604. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 107
       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 ="107"
       AND media_type="images" 
       AND media_name = "1307641215_GIR9310-11.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 = 107
       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 = 107
611. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 107
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
614. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
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 = 107
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 = 107
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
619. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 107
       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 = 107
622. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 107
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
625. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
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 = 107
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 = 107
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=130
       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=130
       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 = '130'
635. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '130'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='130'
       AND section='1'
641. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 130
642. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 130
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
645. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
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 = 130
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 = 130
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 = 130
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 = 130
       AND ps.stockroom_id = s.stockroom_id
655. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 130
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
656. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
657. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 130
658. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 130
       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 ="130"
       AND media_type="images" 
       AND media_name = "1307728079_GIR9550-3.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 = 130
       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 = 130
665. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 130
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
668. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
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 = 130
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 = 130
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
673. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 130
       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 = 130
676. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 130
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
679. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
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 = 130
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 = 130
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=125
       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=125
       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 = '125'
689. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '125'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='125'
       AND section='1'
695. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 125
696. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 125
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
699. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
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 = 125
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 = 125
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 = 125
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 = 125
       AND ps.stockroom_id = s.stockroom_id
709. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 125
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
710. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
711. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 125
712. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 125
       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 ="125"
       AND media_type="images" 
       AND media_name = "1307722919_GIR9550-4.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 = 125
       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 = 125
719. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 125
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
722. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
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 = 125
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 = 125
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
727. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 125
       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 = 125
730. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 125
       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 <= '1746238195'
       AND end_date >= '1746238195' 
       ORDER BY amount DESC
       LIMIT 0,1
733. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
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 = 125
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 = 125
       AND discount_enddate>='1746238195'
       AND discount_stratdate<='1746238195'
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=123
       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=123
       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 = '123'
743. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '123'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='123'
       AND section='1'
749. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 123
750. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 123
       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 <= '1746238196'
       AND end_date >= '1746238196' 
       ORDER BY amount DESC
       LIMIT 0,1
753. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
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 = 123
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 = 123
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 = 123
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 = 123
       AND ps.stockroom_id = s.stockroom_id
763. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 123
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
764. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
       AND discount_enddate>='1746238196'
       AND discount_stratdate<='1746238196'
765. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 123
766. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 123
       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 ="123"
       AND media_type="images" 
       AND media_name = "1307722013_GIR9550-6.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 = 123
       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 = 123
773. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 123
       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 <= '1746238196'
       AND end_date >= '1746238196' 
       ORDER BY amount DESC
       LIMIT 0,1
776. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
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 = 123
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 = 123
       AND discount_enddate>='1746238196'
       AND discount_stratdate<='1746238196'
781. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 123
       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 = 123
784. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 123
       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 <= '1746238196'
       AND end_date >= '1746238196' 
       ORDER BY amount DESC
       LIMIT 0,1
787. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
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 = 123
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 = 123
       AND discount_enddate>='1746238196'
       AND discount_stratdate<='1746238196'
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=113
       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=113
       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 = '113'
797. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '113'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       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 = '57'
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='113'
       AND section='1'
803. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 113
804. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 113
       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 <= '1746238196'
       AND end_date >= '1746238196' 
       ORDER BY amount DESC
       LIMIT 0,1
807. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
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 = 113
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 = 113
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 = 113
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 = 113
       AND ps.stockroom_id = s.stockroom_id
817. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 113
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
818. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
       AND discount_enddate>='1746238196'
       AND discount_stratdate<='1746238196'
819. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 113
820. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 113
       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 ="113"
       AND media_type="images" 
       AND media_name = "1307650456_GIR9551-1.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 = 113
       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 = 113
827. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 113
       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 <= '1746238196'
       AND end_date >= '1746238196' 
       ORDER BY amount DESC
       LIMIT 0,1
830. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
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 = 113
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 = 113
       AND discount_enddate>='1746238196'
       AND discount_stratdate<='1746238196'
835. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 113
       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 = 113
838. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 113
       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 <= '1746238196'
       AND end_date >= '1746238196' 
       ORDER BY amount DESC
       LIMIT 0,1
841. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
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 = 113
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 = 113
       AND discount_enddate>='1746238196'
       AND discount_stratdate<='1746238196'
846. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 57
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=57
     %'
850. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 57
851. SELECT *
       FROM jos_menu
       WHERE id = '222'
852. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
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='57'
       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=57
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 = '57'
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='57'
       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 = '57'
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='57'
       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 = '57'
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='57'
       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 = '57'
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='57'
       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 = '57'
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='57'
       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 = '57'
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='57'
       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 = '57'
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='57'
       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 *
       FROM jos_menu
       WHERE id = '222'
891. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
892. 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='57'
       AND c.category_id = cx.category_parent_id
893. 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
894. 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
895. SELECT *
       FROM jos_menu
       WHERE id = '71'
896. SELECT *
       FROM jos_menu
       WHERE id = '222'
897. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
898. 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'
899. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
900. SELECT *
       FROM jos_menu
       WHERE id = '222'