Exposure

Profile Information

Memory Usage

1286 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '5h73q2gqt4uajv3m3j4mca6034'
2. DELETE
     FROM jos_session
     WHERE ( time < '1745517848' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '5h73q2gqt4uajv3m3j4mca6034'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '5h73q2gqt4uajv3m3j4mca6034','1745525048','','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-04-24'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '5h73q2gqt4uajv3m3j4mca6034'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('5h73q2gqt4uajv3m3j4mca6034', '0','1745525052')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '5h73q2gqt4uajv3m3j4mca6034'
      AND section='manufacturers'
      AND section_id='21'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('5h73q2gqt4uajv3m3j4mca6034','0','manufacturers','21','1745525059')
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 = 252)
      ORDER BY menuid DESC
      LIMIT 0, 1
18. SELECT mn.*, m.media_name,m.section_id
      FROM  jos_redshop_manufacturer AS mn
      LEFT JOIN jos_redshop_media AS m
      ON m.section_id=mn.manufacturer_id
      AND m.published = 1
      AND m.media_section='manufacturer'
      WHERE mn.published = 1 
      AND mn.manufacturer_id='21'
19. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '252'
20. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=manufacturers%' 
      AND params  LIKE '%manufacturerid=21
    %'
21. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 21
22. SELECT *
      FROM  jos_redshop_manufacturer
      WHERE published = 1
23. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=21
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_id DESC
24. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'manufacturer_products'
      AND published=1
      AND template_id='14'
      LIMIT 0,1
25. SELECT category_id AS value, category_name AS text
      FROM jos_redshop_category
      WHERE published = '1'
      ORDER BY category_name ASC
26. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=21
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_id DESC
27. SELECT *
      FROM jos_menu
      WHERE id = '252'
28. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9690'
29. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9690'
      AND pc.category_id = c.category_id 
      AND c.category_id = '191'
30. 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='191'
      AND c.category_id = cx.category_parent_id
31. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '191'
32. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9690
33. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9690
      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
34. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
35. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1745525060'
      AND end_date >= '1745525060' 
      ORDER BY amount DESC
      LIMIT 0,1
36. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9690
37. 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
38. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9690
39. 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
40. 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'
41. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9690
42. 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
43. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9690
44. 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
45. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9690
      AND ps.stockroom_id = s.stockroom_id
46. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9690
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9690
      AND discount_enddate>='1745525060'
      AND discount_stratdate<='1745525060'
48. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9690
49. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9690
      AND ps.stockroom_id = s.stockroom_id
50. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
51. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9690"
      AND media_type="images" 
      AND media_name = "1571431234_r-vea_ene_en3503.jpg"
52. SELECT *
      FROM jos_menu
      WHERE id = '252'
53. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9689'
54. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9689'
      AND pc.category_id = c.category_id 
      AND c.category_id = '191'
55. 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='191'
      AND c.category_id = cx.category_parent_id
56. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '191'
57. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9689
58. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9689
      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
59. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
60. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1745525060'
      AND end_date >= '1745525060' 
      ORDER BY amount DESC
      LIMIT 0,1
61. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9689
62. 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
63. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9689
64. 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
65. 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'
66. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9689
67. 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
68. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9689
69. 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
70. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9689
      AND ps.stockroom_id = s.stockroom_id
71. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9689
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
72. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9689
      AND discount_enddate>='1745525060'
      AND discount_stratdate<='1745525060'
73. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9689
74. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9689
      AND ps.stockroom_id = s.stockroom_id
75. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
76. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="9689"
      AND media_type="images" 
      AND media_name = "1571431162_r-vea_ene_en3502.jpg"
77. SELECT *
      FROM jos_menu
      WHERE id = '252'
78. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '9687'
79. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '9687'
      AND pc.category_id = c.category_id 
      AND c.category_id = '191'
80. 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='191'
      AND c.category_id = cx.category_parent_id
81. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '191'
82. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 9687
83. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9687
      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
84. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
85. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1745525060'
      AND end_date >= '1745525060' 
      ORDER BY amount DESC
      LIMIT 0,1
86. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9687
87. 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
88. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9687
89. 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
90. 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'
91. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9687
92. 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
93. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9687
94. 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
95. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9687
      AND ps.stockroom_id = s.stockroom_id
96. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 9687
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
97. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 9687
      AND discount_enddate>='1745525060'
      AND discount_stratdate<='1745525060'
98. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 9687
99. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 9687
      AND ps.stockroom_id = s.stockroom_id
100. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
101. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9687"
       AND media_type="images" 
       AND media_name = "1571430910_r-vea_ene_en3409.jpg"
102. SELECT *
       FROM jos_menu
       WHERE id = '252'
103. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9684'
104. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9684'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
105. 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='191'
       AND c.category_id = cx.category_parent_id
106. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
107. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9684
108. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9684
       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
109. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
110. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
111. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9684
112. 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
113. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9684
114. 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
115. 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'
116. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9684
117. 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
118. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9684
119. 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
120. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9684
       AND ps.stockroom_id = s.stockroom_id
121. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9684
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
122. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9684
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
123. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9684
124. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9684
       AND ps.stockroom_id = s.stockroom_id
125. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
126. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9684"
       AND media_type="images" 
       AND media_name = "1571430754_r-vea_ene_en3406.jpg"
127. SELECT *
       FROM jos_menu
       WHERE id = '252'
128. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9683'
129. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9683'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
130. 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='191'
       AND c.category_id = cx.category_parent_id
131. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
132. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9683
133. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9683
       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
134. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
135. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
136. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9683
137. 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
138. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9683
139. 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
140. 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'
141. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9683
142. 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
143. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9683
144. 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
145. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9683
       AND ps.stockroom_id = s.stockroom_id
146. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9683
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
147. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9683
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
148. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9683
149. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9683
       AND ps.stockroom_id = s.stockroom_id
150. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
151. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9683"
       AND media_type="images" 
       AND media_name = "1571430651_r-vea_ene_en3405.jpg"
152. SELECT *
       FROM jos_menu
       WHERE id = '252'
153. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9682'
154. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9682'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
155. 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='191'
       AND c.category_id = cx.category_parent_id
156. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
157. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9682
158. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9682
       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
159. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
160. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
161. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9682
162. 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
163. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9682
164. 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
165. 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'
166. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9682
167. 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
168. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9682
169. 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
170. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9682
       AND ps.stockroom_id = s.stockroom_id
171. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9682
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
172. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9682
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
173. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9682
174. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9682
       AND ps.stockroom_id = s.stockroom_id
175. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
176. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9682"
       AND media_type="images" 
       AND media_name = "1571428880_r-vea_ene_en3404.jpg"
177. SELECT *
       FROM jos_menu
       WHERE id = '252'
178. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9681'
179. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9681'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
180. 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='191'
       AND c.category_id = cx.category_parent_id
181. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
182. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9681
183. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9681
       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
184. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
185. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
186. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9681
187. 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
188. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9681
189. 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
190. 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'
191. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9681
192. 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
193. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9681
194. 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
195. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9681
       AND ps.stockroom_id = s.stockroom_id
196. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9681
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
197. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9681
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
198. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9681
199. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9681
       AND ps.stockroom_id = s.stockroom_id
200. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
201. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9681"
       AND media_type="images" 
       AND media_name = "1571428854_r-vea_ene_en3403.jpg"
202. SELECT *
       FROM jos_menu
       WHERE id = '252'
203. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9680'
204. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9680'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
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='191'
       AND c.category_id = cx.category_parent_id
206. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
207. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9680
208. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9680
       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
209. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
210. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
211. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9680
212. 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
213. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9680
214. 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
215. 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'
216. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9680
217. 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
218. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9680
219. 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
220. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9680
       AND ps.stockroom_id = s.stockroom_id
221. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9680
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
222. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9680
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
223. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9680
224. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9680
       AND ps.stockroom_id = s.stockroom_id
225. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
226. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9680"
       AND media_type="images" 
       AND media_name = "1571428827_r-vea_ene_en3402.jpg"
227. SELECT *
       FROM jos_menu
       WHERE id = '252'
228. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9679'
229. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9679'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
230. 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='191'
       AND c.category_id = cx.category_parent_id
231. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
232. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9679
233. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9679
       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 <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
236. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9679
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 = 9679
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 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'
241. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9679
242. 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
243. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9679
244. 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
245. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9679
       AND ps.stockroom_id = s.stockroom_id
246. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9679
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
247. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9679
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
248. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9679
249. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9679
       AND ps.stockroom_id = s.stockroom_id
250. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
251. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9679"
       AND media_type="images" 
       AND media_name = "1571428757_r-vea_ene_en3401.jpg"
252. SELECT *
       FROM jos_menu
       WHERE id = '252'
253. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9677'
254. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9677'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
255. 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='191'
       AND c.category_id = cx.category_parent_id
256. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
257. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9677
258. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9677
       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
259. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
260. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
261. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9677
262. 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
263. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9677
264. 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
265. 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'
266. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9677
267. 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
268. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9677
269. 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
270. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9677
       AND ps.stockroom_id = s.stockroom_id
271. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9677
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
272. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9677
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
273. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9677
274. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9677
       AND ps.stockroom_id = s.stockroom_id
275. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
276. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9677"
       AND media_type="images" 
       AND media_name = "1571428588_r-vea_ene_en3303.jpg"
277. SELECT *
       FROM jos_menu
       WHERE id = '252'
278. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9674'
279. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9674'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
280. 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='191'
       AND c.category_id = cx.category_parent_id
281. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
282. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9674
283. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9674
       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
284. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
285. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
286. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9674
287. 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
288. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9674
289. 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
290. 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'
291. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9674
292. 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
293. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9674
294. 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
295. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9674
       AND ps.stockroom_id = s.stockroom_id
296. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9674
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
297. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9674
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
298. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9674
299. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9674
       AND ps.stockroom_id = s.stockroom_id
300. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
301. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9674"
       AND media_type="images" 
       AND media_name = "1571427203_r-vea_ene_en3204.jpg"
302. SELECT *
       FROM jos_menu
       WHERE id = '252'
303. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9673'
304. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9673'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
305. 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='191'
       AND c.category_id = cx.category_parent_id
306. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
307. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9673
308. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9673
       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
309. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
310. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
311. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9673
312. 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
313. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9673
314. 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
315. 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'
316. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9673
317. 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
318. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9673
319. 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
320. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9673
       AND ps.stockroom_id = s.stockroom_id
321. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9673
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
322. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9673
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
323. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9673
324. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9673
       AND ps.stockroom_id = s.stockroom_id
325. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
326. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9673"
       AND media_type="images" 
       AND media_name = "1571427177_r-vea_ene_en3203.jpg"
327. SELECT *
       FROM jos_menu
       WHERE id = '252'
328. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9672'
329. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9672'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
330. 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='191'
       AND c.category_id = cx.category_parent_id
331. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
332. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9672
333. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9672
       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
334. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
335. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
336. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9672
337. 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
338. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9672
339. 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
340. 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'
341. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9672
342. 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
343. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9672
344. 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
345. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9672
       AND ps.stockroom_id = s.stockroom_id
346. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9672
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
347. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9672
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
348. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9672
349. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9672
       AND ps.stockroom_id = s.stockroom_id
350. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
351. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9672"
       AND media_type="images" 
       AND media_name = "1571427154_r-vea_ene_en3202.jpg"
352. SELECT *
       FROM jos_menu
       WHERE id = '252'
353. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9671'
354. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9671'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
355. 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='191'
       AND c.category_id = cx.category_parent_id
356. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
357. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9671
358. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9671
       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
359. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
360. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
361. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9671
362. 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
363. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9671
364. 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
365. 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'
366. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9671
367. 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
368. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9671
369. 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
370. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9671
       AND ps.stockroom_id = s.stockroom_id
371. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9671
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
372. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9671
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
373. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9671
374. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9671
       AND ps.stockroom_id = s.stockroom_id
375. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
376. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9671"
       AND media_type="images" 
       AND media_name = "1571427123_r-vea_ene_en3201.jpg"
377. SELECT *
       FROM jos_menu
       WHERE id = '252'
378. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9670'
379. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9670'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
380. 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='191'
       AND c.category_id = cx.category_parent_id
381. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
382. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9670
383. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9670
       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
384. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
385. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
386. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9670
387. 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
388. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9670
389. 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
390. 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'
391. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9670
392. 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
393. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9670
394. 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
395. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9670
       AND ps.stockroom_id = s.stockroom_id
396. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9670
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
397. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9670
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
398. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9670
399. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9670
       AND ps.stockroom_id = s.stockroom_id
400. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
401. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9670"
       AND media_type="images" 
       AND media_name = "1571426912_r-vea_ene_en3105.jpg"
402. SELECT *
       FROM jos_menu
       WHERE id = '252'
403. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9668'
404. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9668'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
405. 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='191'
       AND c.category_id = cx.category_parent_id
406. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
407. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9668
408. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9668
       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
409. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
410. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
411. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9668
412. 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
413. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9668
414. 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
415. 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'
416. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9668
417. 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
418. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9668
419. 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
420. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9668
       AND ps.stockroom_id = s.stockroom_id
421. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9668
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
422. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9668
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
423. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9668
424. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9668
       AND ps.stockroom_id = s.stockroom_id
425. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
426. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9668"
       AND media_type="images" 
       AND media_name = "1571426835_r-vea_ene_en3103.jpg"
427. SELECT *
       FROM jos_menu
       WHERE id = '252'
428. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9667'
429. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9667'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
430. 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='191'
       AND c.category_id = cx.category_parent_id
431. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
432. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9667
433. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9667
       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
434. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
435. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
436. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9667
437. 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
438. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9667
439. 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
440. 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'
441. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9667
442. 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
443. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9667
444. 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
445. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9667
       AND ps.stockroom_id = s.stockroom_id
446. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9667
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
447. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9667
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
448. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9667
449. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9667
       AND ps.stockroom_id = s.stockroom_id
450. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
451. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9667"
       AND media_type="images" 
       AND media_name = "1571426776_r-vea_ene_en3102.jpg"
452. SELECT *
       FROM jos_menu
       WHERE id = '252'
453. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9665'
454. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9665'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
455. 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='191'
       AND c.category_id = cx.category_parent_id
456. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
457. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9665
458. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9665
       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
459. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
460. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
461. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9665
462. 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
463. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9665
464. 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
465. 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'
466. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9665
467. 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
468. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9665
469. 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
470. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9665
       AND ps.stockroom_id = s.stockroom_id
471. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9665
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
472. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9665
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
473. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9665
474. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9665
       AND ps.stockroom_id = s.stockroom_id
475. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
476. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9665"
       AND media_type="images" 
       AND media_name = "1571426555_r-vea_ene_en3003.jpg"
477. SELECT *
       FROM jos_menu
       WHERE id = '252'
478. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9664'
479. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9664'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
480. 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='191'
       AND c.category_id = cx.category_parent_id
481. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
482. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9664
483. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9664
       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
484. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
485. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
486. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9664
487. 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
488. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9664
489. 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
490. 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'
491. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9664
492. 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
493. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9664
494. 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
495. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9664
       AND ps.stockroom_id = s.stockroom_id
496. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9664
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
497. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9664
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
498. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9664
499. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9664
       AND ps.stockroom_id = s.stockroom_id
500. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
501. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9664"
       AND media_type="images" 
       AND media_name = "1571426529_r-vea_ene_en3001.jpg"
502. SELECT *
       FROM jos_menu
       WHERE id = '252'
503. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9663'
504. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9663'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
505. 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='191'
       AND c.category_id = cx.category_parent_id
506. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
507. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9663
508. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9663
       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
509. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
510. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
511. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9663
512. 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
513. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9663
514. 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
515. 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'
516. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9663
517. 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
518. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9663
519. 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
520. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9663
       AND ps.stockroom_id = s.stockroom_id
521. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9663
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
522. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9663
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
523. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9663
524. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9663
       AND ps.stockroom_id = s.stockroom_id
525. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
526. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9663"
       AND media_type="images" 
       AND media_name = "1571426395_r-vea_ene_en2003.jpg"
527. SELECT *
       FROM jos_menu
       WHERE id = '252'
528. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9662'
529. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9662'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
530. 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='191'
       AND c.category_id = cx.category_parent_id
531. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
532. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9662
533. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9662
       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
534. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
535. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
536. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9662
537. 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
538. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9662
539. 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
540. 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'
541. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9662
542. 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
543. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9662
544. 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
545. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9662
       AND ps.stockroom_id = s.stockroom_id
546. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9662
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
547. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9662
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
548. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9662
549. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9662
       AND ps.stockroom_id = s.stockroom_id
550. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
551. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9662"
       AND media_type="images" 
       AND media_name = "1571426367_r-vea_ene_en2002.jpg"
552. SELECT *
       FROM jos_menu
       WHERE id = '252'
553. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9661'
554. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9661'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
555. 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='191'
       AND c.category_id = cx.category_parent_id
556. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
557. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9661
558. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9661
       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
559. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
560. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
561. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9661
562. 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
563. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9661
564. 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
565. 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'
566. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9661
567. 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
568. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9661
569. 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
570. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9661
       AND ps.stockroom_id = s.stockroom_id
571. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9661
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
572. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9661
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
573. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9661
574. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9661
       AND ps.stockroom_id = s.stockroom_id
575. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
576. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9661"
       AND media_type="images" 
       AND media_name = "1571426325_r-vea_ene_en2001.jpg"
577. SELECT *
       FROM jos_menu
       WHERE id = '252'
578. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9657'
579. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9657'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
580. 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='191'
       AND c.category_id = cx.category_parent_id
581. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
582. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9657
583. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9657
       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
584. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
585. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
586. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9657
587. 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
588. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9657
589. 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
590. 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'
591. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9657
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 = 9657
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9657
       AND ps.stockroom_id = s.stockroom_id
596. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9657
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
597. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9657
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
598. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9657
599. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9657
       AND ps.stockroom_id = s.stockroom_id
600. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
601. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9657"
       AND media_type="images" 
       AND media_name = "1571423076_r-vea_ene_en1204.jpg"
602. SELECT *
       FROM jos_menu
       WHERE id = '252'
603. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9655'
604. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9655'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
605. 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='191'
       AND c.category_id = cx.category_parent_id
606. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
607. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9655
608. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9655
       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
609. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
610. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
611. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9655
612. 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
613. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9655
614. 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
615. 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'
616. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9655
617. 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
618. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9655
619. 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
620. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9655
       AND ps.stockroom_id = s.stockroom_id
621. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9655
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
622. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9655
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
623. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9655
624. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9655
       AND ps.stockroom_id = s.stockroom_id
625. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
626. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9655"
       AND media_type="images" 
       AND media_name = "1571421927_r-vea_ene_en1202.jpg"
627. SELECT *
       FROM jos_menu
       WHERE id = '252'
628. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9651'
629. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9651'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
630. 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='191'
       AND c.category_id = cx.category_parent_id
631. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
632. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9651
633. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9651
       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
634. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
635. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
636. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9651
637. 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
638. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9651
639. 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
640. 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'
641. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9651
642. 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
643. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9651
644. 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
645. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9651
       AND ps.stockroom_id = s.stockroom_id
646. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9651
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
647. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9651
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
648. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9651
649. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9651
       AND ps.stockroom_id = s.stockroom_id
650. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
651. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9651"
       AND media_type="images" 
       AND media_name = "1571421692_r-vea_ene_en1105.jpg"
652. SELECT *
       FROM jos_menu
       WHERE id = '252'
653. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9649'
654. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9649'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
655. 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='191'
       AND c.category_id = cx.category_parent_id
656. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
657. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9649
658. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9649
       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
659. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
660. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525060'
       AND end_date >= '1745525060' 
       ORDER BY amount DESC
       LIMIT 0,1
661. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9649
662. 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
663. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9649
664. 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
665. 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'
666. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9649
667. 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
668. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9649
669. 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
670. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9649
       AND ps.stockroom_id = s.stockroom_id
671. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9649
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
672. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9649
       AND discount_enddate>='1745525060'
       AND discount_stratdate<='1745525060'
673. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9649
674. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9649
       AND ps.stockroom_id = s.stockroom_id
675. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
676. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9649"
       AND media_type="images" 
       AND media_name = "1571421584_r-vea_ene_en1103.jpg"
677. SELECT *
       FROM jos_menu
       WHERE id = '252'
678. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9647'
679. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9647'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
680. 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='191'
       AND c.category_id = cx.category_parent_id
681. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
682. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9647
683. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9647
       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
684. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
685. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
686. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9647
687. 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
688. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9647
689. 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
690. 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'
691. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9647
692. 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
693. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9647
694. 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
695. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9647
       AND ps.stockroom_id = s.stockroom_id
696. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9647
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
697. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9647
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
698. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9647
699. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9647
       AND ps.stockroom_id = s.stockroom_id
700. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
701. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9647"
       AND media_type="images" 
       AND media_name = "1571421511_r-vea_ene_en1101.jpg"
702. SELECT *
       FROM jos_menu
       WHERE id = '252'
703. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9646'
704. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9646'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
705. 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='191'
       AND c.category_id = cx.category_parent_id
706. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
707. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9646
708. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9646
       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
709. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
710. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
711. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9646
712. 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
713. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9646
714. 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
715. 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'
716. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9646
717. 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
718. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9646
719. 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
720. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9646
       AND ps.stockroom_id = s.stockroom_id
721. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9646
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
722. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9646
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
723. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9646
724. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9646
       AND ps.stockroom_id = s.stockroom_id
725. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
726. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9646"
       AND media_type="images" 
       AND media_name = "1571421394_r-vea_ene_en1006.jpg"
727. SELECT *
       FROM jos_menu
       WHERE id = '252'
728. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9644'
729. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9644'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
730. 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='191'
       AND c.category_id = cx.category_parent_id
731. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
732. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9644
733. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9644
       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
734. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
735. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
736. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9644
737. 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
738. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9644
739. 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
740. 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'
741. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9644
742. 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
743. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9644
744. 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
745. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9644
       AND ps.stockroom_id = s.stockroom_id
746. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9644
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
747. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9644
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
748. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9644
749. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9644
       AND ps.stockroom_id = s.stockroom_id
750. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
751. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9644"
       AND media_type="images" 
       AND media_name = "1571421236_r-vea_ene_en1004.jpg"
752. SELECT *
       FROM jos_menu
       WHERE id = '252'
753. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9641'
754. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9641'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
755. 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='191'
       AND c.category_id = cx.category_parent_id
756. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
757. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9641
758. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9641
       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
759. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
760. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
761. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9641
762. 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
763. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9641
764. 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
765. 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'
766. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9641
767. 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
768. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9641
769. 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
770. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9641
       AND ps.stockroom_id = s.stockroom_id
771. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9641
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
772. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9641
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
773. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9641
774. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9641
       AND ps.stockroom_id = s.stockroom_id
775. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
776. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9641"
       AND media_type="images" 
       AND media_name = "1571420997_r-vea_ene_en1001.jpg"
777. SELECT *
       FROM jos_menu
       WHERE id = '252'
778. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9636'
779. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9636'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
780. 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='191'
       AND c.category_id = cx.category_parent_id
781. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
782. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9636
783. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9636
       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
784. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
785. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
786. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9636
787. 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
788. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9636
789. 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
790. 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'
791. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9636
792. 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
793. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9636
794. 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
795. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9636
       AND ps.stockroom_id = s.stockroom_id
796. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9636
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
797. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9636
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
798. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9636
799. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9636
       AND ps.stockroom_id = s.stockroom_id
800. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
801. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9636"
       AND media_type="images" 
       AND media_name = "1571416478_gl-co_epo_ep3703.jpg"
802. SELECT *
       FROM jos_menu
       WHERE id = '252'
803. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9631'
804. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9631'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
805. 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='191'
       AND c.category_id = cx.category_parent_id
806. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
807. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9631
808. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9631
       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
809. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
810. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
811. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9631
812. 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
813. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9631
814. 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
815. 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'
816. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9631
817. 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
818. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9631
819. 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
820. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9631
       AND ps.stockroom_id = s.stockroom_id
821. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9631
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
822. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9631
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
823. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9631
824. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9631
       AND ps.stockroom_id = s.stockroom_id
825. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
826. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9631"
       AND media_type="images" 
       AND media_name = "1571415106_gl-co_epo_ep3403.jpg"
827. SELECT *
       FROM jos_menu
       WHERE id = '252'
828. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9630'
829. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9630'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
830. 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='191'
       AND c.category_id = cx.category_parent_id
831. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
832. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9630
833. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9630
       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
834. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
835. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
836. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9630
837. 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
838. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9630
839. 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
840. 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'
841. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9630
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 = 9630
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9630
       AND ps.stockroom_id = s.stockroom_id
846. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9630
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
847. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9630
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
848. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9630
849. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9630
       AND ps.stockroom_id = s.stockroom_id
850. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
851. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9630"
       AND media_type="images" 
       AND media_name = "1574461805_gl-co_epo_ep3401.jpg"
852. SELECT *
       FROM jos_menu
       WHERE id = '252'
853. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9629'
854. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9629'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
855. 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='191'
       AND c.category_id = cx.category_parent_id
856. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
857. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9629
858. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9629
       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
859. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
860. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
861. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9629
862. 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
863. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9629
864. 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
865. 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'
866. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9629
867. 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
868. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9629
869. 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
870. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9629
       AND ps.stockroom_id = s.stockroom_id
871. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9629
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
872. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9629
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
873. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9629
874. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9629
       AND ps.stockroom_id = s.stockroom_id
875. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
876. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9629"
       AND media_type="images" 
       AND media_name = "1574461757_gl-co_epo_ep3402.jpg"
877. SELECT *
       FROM jos_menu
       WHERE id = '252'
878. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9628'
879. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9628'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
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='191'
       AND c.category_id = cx.category_parent_id
881. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
882. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9628
883. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9628
       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
884. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
885. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
886. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9628
887. 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
888. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9628
889. 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
890. 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'
891. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9628
892. 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
893. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9628
894. 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
895. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9628
       AND ps.stockroom_id = s.stockroom_id
896. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9628
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
897. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9628
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
898. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9628
899. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9628
       AND ps.stockroom_id = s.stockroom_id
900. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
901. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9628"
       AND media_type="images" 
       AND media_name = "1571414760_gl-co_epo_ep3304.jpg"
902. SELECT *
       FROM jos_menu
       WHERE id = '252'
903. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9627'
904. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9627'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
905. 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='191'
       AND c.category_id = cx.category_parent_id
906. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
907. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9627
908. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9627
       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
909. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
910. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
911. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9627
912. 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
913. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9627
914. 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
915. 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'
916. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9627
917. 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
918. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9627
919. 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
920. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9627
       AND ps.stockroom_id = s.stockroom_id
921. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9627
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
922. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9627
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
923. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9627
924. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9627
       AND ps.stockroom_id = s.stockroom_id
925. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
926. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9627"
       AND media_type="images" 
       AND media_name = "1571414732_gl-co_epo_ep3303.jpg"
927. SELECT *
       FROM jos_menu
       WHERE id = '252'
928. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9626'
929. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9626'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
930. 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='191'
       AND c.category_id = cx.category_parent_id
931. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
932. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9626
933. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9626
       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
934. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
935. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
936. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9626
937. 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
938. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9626
939. 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
940. 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'
941. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9626
942. 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
943. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9626
944. 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
945. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9626
       AND ps.stockroom_id = s.stockroom_id
946. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9626
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
947. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9626
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
948. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9626
949. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9626
       AND ps.stockroom_id = s.stockroom_id
950. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
951. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9626"
       AND media_type="images" 
       AND media_name = "1571414700_gl-co_epo_ep3302.jpg"
952. SELECT *
       FROM jos_menu
       WHERE id = '252'
953. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9625'
954. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9625'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
955. 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='191'
       AND c.category_id = cx.category_parent_id
956. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
957. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9625
958. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9625
       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
959. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
960. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
961. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9625
962. 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
963. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9625
964. 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
965. 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'
966. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9625
967. 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
968. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9625
969. 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
970. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9625
       AND ps.stockroom_id = s.stockroom_id
971. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9625
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
972. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9625
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
973. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9625
974. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9625
       AND ps.stockroom_id = s.stockroom_id
975. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
976. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="9625"
       AND media_type="images" 
       AND media_name = "1571414674_gl-co_epo_ep3301.jpg"
977. SELECT *
       FROM jos_menu
       WHERE id = '252'
978. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '9622'
979. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '9622'
       AND pc.category_id = c.category_id 
       AND c.category_id = '191'
980. 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='191'
       AND c.category_id = cx.category_parent_id
981. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
982. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 9622
983. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9622
       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
984. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
985. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745525061'
       AND end_date >= '1745525061' 
       ORDER BY amount DESC
       LIMIT 0,1
986. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9622
987. 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
988. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9622
989. 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
990. 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'
991. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9622
992. 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
993. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9622
994. 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
995. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9622
       AND ps.stockroom_id = s.stockroom_id
996. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 9622
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
997. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 9622
       AND discount_enddate>='1745525061'
       AND discount_stratdate<='1745525061'
998. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 9622
999. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 9622
       AND ps.stockroom_id = s.stockroom_id
1000. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1001. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9622"
        AND media_type="images" 
        AND media_name = "1571413886_gl-co_epo_ep3201.jpg"
1002. SELECT *
        FROM jos_menu
        WHERE id = '252'
1003. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9621'
1004. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9621'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1005. 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='191'
        AND c.category_id = cx.category_parent_id
1006. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1007. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9621
1008. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9621
        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
1009. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1010. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1011. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9621
1012. 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
1013. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9621
1014. 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
1015. 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'
1016. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9621
1017. 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
1018. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9621
1019. 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
1020. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9621
        AND ps.stockroom_id = s.stockroom_id
1021. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9621
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1022. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9621
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1023. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9621
1024. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9621
        AND ps.stockroom_id = s.stockroom_id
1025. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1026. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9621"
        AND media_type="images" 
        AND media_name = "1571413758_gl-co_epo_ep3104.jpg"
1027. SELECT *
        FROM jos_menu
        WHERE id = '252'
1028. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9620'
1029. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9620'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1030. 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='191'
        AND c.category_id = cx.category_parent_id
1031. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1032. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9620
1033. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9620
        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
1034. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1035. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1036. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9620
1037. 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
1038. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9620
1039. 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
1040. 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'
1041. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9620
1042. 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
1043. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9620
1044. 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
1045. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9620
        AND ps.stockroom_id = s.stockroom_id
1046. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9620
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1047. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9620
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1048. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9620
1049. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9620
        AND ps.stockroom_id = s.stockroom_id
1050. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1051. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9620"
        AND media_type="images" 
        AND media_name = "1571413735_gl-co_epo_ep3103.jpg"
1052. SELECT *
        FROM jos_menu
        WHERE id = '252'
1053. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9619'
1054. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9619'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1055. 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='191'
        AND c.category_id = cx.category_parent_id
1056. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1057. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9619
1058. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9619
        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
1059. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1060. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1061. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9619
1062. 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
1063. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9619
1064. 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
1065. 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'
1066. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9619
1067. 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
1068. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9619
1069. 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
1070. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9619
        AND ps.stockroom_id = s.stockroom_id
1071. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9619
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1072. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9619
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1073. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9619
1074. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9619
        AND ps.stockroom_id = s.stockroom_id
1075. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1076. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9619"
        AND media_type="images" 
        AND media_name = "1571413697_gl-co_epo_ep3102.jpg"
1077. SELECT *
        FROM jos_menu
        WHERE id = '252'
1078. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9618'
1079. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9618'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1080. 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='191'
        AND c.category_id = cx.category_parent_id
1081. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1082. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9618
1083. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9618
        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
1084. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1085. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1086. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9618
1087. 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
1088. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9618
1089. 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
1090. 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'
1091. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9618
1092. 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
1093. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9618
1094. 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
1095. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9618
        AND ps.stockroom_id = s.stockroom_id
1096. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9618
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1097. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9618
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1098. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9618
1099. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9618
        AND ps.stockroom_id = s.stockroom_id
1100. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1101. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9618"
        AND media_type="images" 
        AND media_name = "1571413659_gl-co_epo_ep3101.jpg"
1102. SELECT *
        FROM jos_menu
        WHERE id = '252'
1103. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9617'
1104. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9617'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1105. 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='191'
        AND c.category_id = cx.category_parent_id
1106. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1107. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9617
1108. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9617
        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
1109. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1110. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1111. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9617
1112. 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
1113. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9617
1114. 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
1115. 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'
1116. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9617
1117. 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
1118. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9617
1119. 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
1120. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9617
        AND ps.stockroom_id = s.stockroom_id
1121. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9617
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1122. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9617
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1123. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9617
1124. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9617
        AND ps.stockroom_id = s.stockroom_id
1125. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1126. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9617"
        AND media_type="images" 
        AND media_name = "1571413427_gl-co_epo_ep3002.jpg"
1127. SELECT *
        FROM jos_menu
        WHERE id = '252'
1128. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9616'
1129. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9616'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1130. 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='191'
        AND c.category_id = cx.category_parent_id
1131. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1132. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9616
1133. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9616
        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
1134. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1135. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1136. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9616
1137. 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
1138. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9616
1139. 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
1140. 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'
1141. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9616
1142. 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
1143. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9616
1144. 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
1145. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9616
        AND ps.stockroom_id = s.stockroom_id
1146. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9616
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1147. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9616
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1148. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9616
1149. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9616
        AND ps.stockroom_id = s.stockroom_id
1150. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1151. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9616"
        AND media_type="images" 
        AND media_name = "1571413269_gl-co_epo_ep3001.jpg"
1152. SELECT *
        FROM jos_menu
        WHERE id = '252'
1153. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9615'
1154. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9615'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1155. 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='191'
        AND c.category_id = cx.category_parent_id
1156. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1157. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9615
1158. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9615
        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
1159. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1160. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1161. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9615
1162. 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
1163. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9615
1164. 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
1165. 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'
1166. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9615
1167. 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
1168. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9615
1169. 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
1170. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9615
        AND ps.stockroom_id = s.stockroom_id
1171. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9615
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1172. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9615
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1173. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9615
1174. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9615
        AND ps.stockroom_id = s.stockroom_id
1175. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1176. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9615"
        AND media_type="images" 
        AND media_name = "1571413010_gl-co_epo_ep2306.jpg"
1177. SELECT *
        FROM jos_menu
        WHERE id = '252'
1178. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9612'
1179. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9612'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1180. 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='191'
        AND c.category_id = cx.category_parent_id
1181. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1182. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9612
1183. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9612
        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
1184. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1185. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1186. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9612
1187. 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
1188. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9612
1189. 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
1190. 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'
1191. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9612
1192. 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
1193. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9612
1194. 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
1195. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9612
        AND ps.stockroom_id = s.stockroom_id
1196. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9612
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1197. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9612
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1198. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9612
1199. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9612
        AND ps.stockroom_id = s.stockroom_id
1200. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1201. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9612"
        AND media_type="images" 
        AND media_name = "1571411980_gl-co_epo_ep1005.jpg"
1202. SELECT *
        FROM jos_menu
        WHERE id = '252'
1203. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9611'
1204. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9611'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1205. 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='191'
        AND c.category_id = cx.category_parent_id
1206. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1207. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9611
1208. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9611
        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
1209. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1210. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1211. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9611
1212. 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
1213. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9611
1214. 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
1215. 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'
1216. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9611
1217. 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
1218. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9611
1219. 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
1220. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9611
        AND ps.stockroom_id = s.stockroom_id
1221. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9611
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1222. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9611
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1223. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9611
1224. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9611
        AND ps.stockroom_id = s.stockroom_id
1225. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1226. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9611"
        AND media_type="images" 
        AND media_name = "1571411944_gl-co_epo_ep1004.jpg"
1227. SELECT *
        FROM jos_menu
        WHERE id = '252'
1228. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9610'
1229. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9610'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1230. 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='191'
        AND c.category_id = cx.category_parent_id
1231. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1232. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9610
1233. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9610
        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
1234. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1235. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1236. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9610
1237. 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
1238. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9610
1239. 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
1240. 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'
1241. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9610
1242. 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
1243. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9610
1244. 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
1245. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9610
        AND ps.stockroom_id = s.stockroom_id
1246. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9610
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1247. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9610
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1248. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9610
1249. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9610
        AND ps.stockroom_id = s.stockroom_id
1250. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1251. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9610"
        AND media_type="images" 
        AND media_name = "1571411895_gl-co_epo_ep1003.jpg"
1252. SELECT *
        FROM jos_menu
        WHERE id = '252'
1253. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '9609'
1254. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '9609'
        AND pc.category_id = c.category_id 
        AND c.category_id = '191'
1255. 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='191'
        AND c.category_id = cx.category_parent_id
1256. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1257. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 9609
1258. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9609
        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
1259. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1260. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1745525061'
        AND end_date >= '1745525061' 
        ORDER BY amount DESC
        LIMIT 0,1
1261. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9609
1262. 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
1263. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9609
1264. 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
1265. 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'
1266. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9609
1267. 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
1268. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9609
1269. 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
1270. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9609
        AND ps.stockroom_id = s.stockroom_id
1271. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 9609
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1272. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 9609
        AND discount_enddate>='1745525061'
        AND discount_stratdate<='1745525061'
1273. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 9609
1274. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 9609
        AND ps.stockroom_id = s.stockroom_id
1275. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1276. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="9609"
        AND media_type="images" 
        AND media_name = "1571343728_gl-co_epo_ep1001.jpg"
1277. SELECT *
        FROM jos_menu
        WHERE id = '252'
1278. SELECT sef_url,manufacturer_name
        FROM jos_redshop_manufacturer
        WHERE manufacturer_id = '21'
1279. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='10'
        AND published=1 
        AND field_name IN ('manufacturer_image')
1280. 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 = 252 OR mm.menuid = 0 )
        ORDER BY position, ordering
1281. SELECT *
        FROM jos_menu
        WHERE id = '71'
1282. SELECT *
        FROM jos_menu
        WHERE id = '222'
1283. SELECT category_id      
        FROM jos_redshop_product_category_xref cx
        WHERE product_id = ''
1284. 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'
1285. SELECT category_id AS value,category_name AS text
        FROM jos_redshop_category
        WHERE published = 1
1286. SELECT *
        FROM jos_menu
        WHERE id = '252'