Authentic Collection

Profile Information

Memory Usage

1320 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'u1okcnp2etemcii1upinvniaf6'
2. DELETE
     FROM jos_session
     WHERE ( time < '1740204578' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'u1okcnp2etemcii1upinvniaf6'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'u1okcnp2etemcii1upinvniaf6','1740211778','','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-02-22'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'u1okcnp2etemcii1upinvniaf6'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('u1okcnp2etemcii1upinvniaf6', '0','1740211780')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'u1okcnp2etemcii1upinvniaf6'
      AND section='category'
      AND section_id='88'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('u1okcnp2etemcii1upinvniaf6','0','category','88','1740211782')
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 = 130)
      ORDER BY menuid DESC
      LIMIT 0, 1
18. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=88
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
19. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=88
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
20. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=88
      AND published = 1
      ORDER BY c.category_name ASC
21. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '88'
22. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=88%')
      ORDER BY 'ordering'
23. SELECT *
      FROM jos_menu
      WHERE id = '130'
24. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '88'
25. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='88'
      AND c.category_id = cx.category_parent_id
26. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=88
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 0, 100
27. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=88
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
28. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=88
      AND published = 1
      ORDER BY c.category_name ASC
29. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '88'
30. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=88%')
      ORDER BY 'ordering'
31. SELECT *
      FROM jos_menu
      WHERE id = '130'
32. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '88'
33. 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='88'
      AND c.category_id = cx.category_parent_id
34. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=1919
      AND p.published = 1
      ORDER BY a.ordering ASC
35. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=1919
      AND t.published = 1
      LIMIT 0,1
36. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
37. SELECT *
      FROM jos_menu
      WHERE id = '130'
38. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '1919'
39. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '1919'
      AND pc.category_id = c.category_id 
      AND c.category_id = '88'
40. 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='88'
      AND c.category_id = cx.category_parent_id
41. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '88'
42. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
43. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='1919'
      AND section='1'
44. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 1919
45. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 1919
      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
46. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
47. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1740211782'
      AND end_date >= '1740211782' 
      ORDER BY amount DESC
      LIMIT 0,1
48. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
49. 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
50. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
51. 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
52. 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'
53. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
54. 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
55. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
56. 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
57. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 1919
      AND ps.stockroom_id = s.stockroom_id
58. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 1919
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
59. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
      AND discount_enddate>='1740211782'
      AND discount_stratdate<='1740211782'
60. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 1919
61. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 1919
      AND ps.stockroom_id = s.stockroom_id
62. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
63. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="1919"
      AND media_type="images" 
      AND media_name = "1396634534_6823-10.jpg"
64. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
65. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 1919
      AND ps.stockroom_id = s.stockroom_id
66. 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'
67. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 1919
68. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 1919
      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
69. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
70. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1740211782'
      AND end_date >= '1740211782' 
      ORDER BY amount DESC
      LIMIT 0,1
71. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
72. 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
73. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
74. 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
75. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
      AND discount_enddate>='1740211782'
      AND discount_stratdate<='1740211782'
76. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 1919
      AND ps.stockroom_id = s.stockroom_id
77. 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'
78. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 1919
79. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 1919
      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
80. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
81. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1740211782'
      AND end_date >= '1740211782' 
      ORDER BY amount DESC
      LIMIT 0,1
82. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
83. 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
84. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
85. 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
86. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 1919
      AND discount_enddate>='1740211782'
      AND discount_stratdate<='1740211782'
87. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=1918
      AND p.published = 1
      ORDER BY a.ordering ASC
88. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=1918
      AND t.published = 1
      LIMIT 0,1
89. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
90. SELECT *
      FROM jos_menu
      WHERE id = '130'
91. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '1918'
92. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '1918'
      AND pc.category_id = c.category_id 
      AND c.category_id = '88'
93. 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='88'
      AND c.category_id = cx.category_parent_id
94. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '88'
95. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
96. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='1918'
      AND section='1'
97. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 1918
98. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 1918
      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
99. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
100. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
101. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
102. 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
103. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
104. 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
105. 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'
106. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
107. 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
108. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
109. 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
110. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1918
       AND ps.stockroom_id = s.stockroom_id
111. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1918
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
112. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
113. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1918
114. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1918
       AND ps.stockroom_id = s.stockroom_id
115. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
116. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1918"
       AND media_type="images" 
       AND media_name = "1396634534_6823-15.jpg"
117. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
118. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1918
       AND ps.stockroom_id = s.stockroom_id
119. 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'
120. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1918
121. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1918
       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
122. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
123. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
124. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
125. 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
126. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
127. 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
128. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
129. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1918
       AND ps.stockroom_id = s.stockroom_id
130. 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'
131. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1918
132. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1918
       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
133. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
134. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
135. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
136. 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
137. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
138. 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
139. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1918
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
140. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1917
       AND p.published = 1
       ORDER BY a.ordering ASC
141. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1917
       AND t.published = 1
       LIMIT 0,1
142. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
143. SELECT *
       FROM jos_menu
       WHERE id = '130'
144. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1917'
145. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1917'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
146. 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='88'
       AND c.category_id = cx.category_parent_id
147. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
148. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
149. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1917'
       AND section='1'
150. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1917
151. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1917
       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
152. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
153. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
154. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
155. 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
156. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
157. 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
158. 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'
159. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
160. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
161. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
162. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
163. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1917
       AND ps.stockroom_id = s.stockroom_id
164. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1917
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
165. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
166. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1917
167. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1917
       AND ps.stockroom_id = s.stockroom_id
168. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
169. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1917"
       AND media_type="images" 
       AND media_name = "1396634534_6823-34.jpg"
170. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
171. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1917
       AND ps.stockroom_id = s.stockroom_id
172. 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'
173. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1917
174. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1917
       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
175. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
176. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
177. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
178. 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
179. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
180. 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
181. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
182. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1917
       AND ps.stockroom_id = s.stockroom_id
183. 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'
184. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1917
185. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1917
       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
186. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
187. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
188. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
189. 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
190. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
191. 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
192. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1917
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
193. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1916
       AND p.published = 1
       ORDER BY a.ordering ASC
194. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1916
       AND t.published = 1
       LIMIT 0,1
195. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
196. SELECT *
       FROM jos_menu
       WHERE id = '130'
197. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1916'
198. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1916'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
199. 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='88'
       AND c.category_id = cx.category_parent_id
200. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
201. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
202. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1916'
       AND section='1'
203. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1916
204. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1916
       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
205. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
206. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
207. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1916
208. 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
209. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1916
210. 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
211. 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'
212. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1916
213. 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
214. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1916
215. 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
216. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1916
       AND ps.stockroom_id = s.stockroom_id
217. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1916
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
218. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1916
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
219. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1916
220. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1916
       AND ps.stockroom_id = s.stockroom_id
221. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
222. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1916"
       AND media_type="images" 
       AND media_name = "1396634534_6824-02.jpg"
223. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
224. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1916
       AND ps.stockroom_id = s.stockroom_id
225. 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'
226. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1916
227. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1916
       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
228. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
229. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
230. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1916
231. 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
232. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1916
233. 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
234. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1916
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
235. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1916
       AND ps.stockroom_id = s.stockroom_id
236. 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'
237. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1916
238. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1916
       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
239. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
240. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
241. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1916
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 = 1916
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 *
       FROM jos_redshop_product
       WHERE product_id = 1916
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
246. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1915
       AND p.published = 1
       ORDER BY a.ordering ASC
247. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1915
       AND t.published = 1
       LIMIT 0,1
248. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
249. SELECT *
       FROM jos_menu
       WHERE id = '130'
250. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1915'
251. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1915'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
252. 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='88'
       AND c.category_id = cx.category_parent_id
253. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
254. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
255. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1915'
       AND section='1'
256. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1915
257. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1915
       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
258. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
259. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
260. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
261. 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
262. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
263. 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
264. 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'
265. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
266. 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
267. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
268. 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
269. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1915
       AND ps.stockroom_id = s.stockroom_id
270. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1915
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
271. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
272. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1915
273. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1915
       AND ps.stockroom_id = s.stockroom_id
274. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
275. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1915"
       AND media_type="images" 
       AND media_name = "1396634534_6824-10.jpg"
276. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
277. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1915
       AND ps.stockroom_id = s.stockroom_id
278. 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'
279. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1915
280. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1915
       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
281. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
282. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
283. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
284. 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
285. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
286. 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
287. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
288. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1915
       AND ps.stockroom_id = s.stockroom_id
289. 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'
290. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1915
291. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1915
       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
292. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
293. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
294. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
295. 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
296. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
297. 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
298. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1915
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
299. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1914
       AND p.published = 1
       ORDER BY a.ordering ASC
300. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1914
       AND t.published = 1
       LIMIT 0,1
301. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
302. SELECT *
       FROM jos_menu
       WHERE id = '130'
303. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1914'
304. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1914'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
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='88'
       AND c.category_id = cx.category_parent_id
306. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
307. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
308. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1914'
       AND section='1'
309. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1914
310. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1914
       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
311. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
312. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
313. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1914
314. 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
315. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1914
316. 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
317. 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'
318. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1914
319. 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
320. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1914
321. 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
322. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1914
       AND ps.stockroom_id = s.stockroom_id
323. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1914
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
324. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1914
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
325. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1914
326. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1914
       AND ps.stockroom_id = s.stockroom_id
327. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
328. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1914"
       AND media_type="images" 
       AND media_name = "1396634534_6824-11.jpg"
329. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
330. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1914
       AND ps.stockroom_id = s.stockroom_id
331. 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'
332. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1914
333. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1914
       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 <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
336. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1914
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 = 1914
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 *
       FROM jos_redshop_product
       WHERE product_id = 1914
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
341. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1914
       AND ps.stockroom_id = s.stockroom_id
342. 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'
343. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1914
344. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1914
       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
345. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
346. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
347. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1914
348. 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
349. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1914
350. 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
351. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1914
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
352. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1913
       AND p.published = 1
       ORDER BY a.ordering ASC
353. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1913
       AND t.published = 1
       LIMIT 0,1
354. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
355. SELECT *
       FROM jos_menu
       WHERE id = '130'
356. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1913'
357. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1913'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
358. 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='88'
       AND c.category_id = cx.category_parent_id
359. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
360. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
361. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1913'
       AND section='1'
362. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1913
363. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1913
       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
364. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
365. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
366. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
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 = 1913
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 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'
371. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
372. 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
373. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
374. 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
375. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1913
       AND ps.stockroom_id = s.stockroom_id
376. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1913
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
377. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
378. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1913
379. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1913
       AND ps.stockroom_id = s.stockroom_id
380. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
381. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1913"
       AND media_type="images" 
       AND media_name = "1396634534_6825-02.jpg"
382. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
383. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1913
       AND ps.stockroom_id = s.stockroom_id
384. 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'
385. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1913
386. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1913
       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
387. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
388. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
389. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
390. 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
391. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
392. 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
393. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
394. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1913
       AND ps.stockroom_id = s.stockroom_id
395. 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'
396. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1913
397. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1913
       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
398. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
399. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
400. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
401. 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
402. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
403. 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
404. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1913
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
405. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1912
       AND p.published = 1
       ORDER BY a.ordering ASC
406. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1912
       AND t.published = 1
       LIMIT 0,1
407. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
408. SELECT *
       FROM jos_menu
       WHERE id = '130'
409. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1912'
410. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1912'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
411. 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='88'
       AND c.category_id = cx.category_parent_id
412. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
413. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
414. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1912'
       AND section='1'
415. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1912
416. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1912
       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
417. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
418. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
419. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
420. 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
421. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
422. 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
423. 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'
424. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
425. 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
426. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
427. 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
428. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1912
       AND ps.stockroom_id = s.stockroom_id
429. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1912
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
430. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
431. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1912
432. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1912
       AND ps.stockroom_id = s.stockroom_id
433. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
434. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1912"
       AND media_type="images" 
       AND media_name = "1396634534_6825-15.jpg"
435. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
436. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1912
       AND ps.stockroom_id = s.stockroom_id
437. 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'
438. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1912
439. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1912
       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
440. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
441. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
442. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
443. 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
444. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
445. 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
446. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
447. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1912
       AND ps.stockroom_id = s.stockroom_id
448. 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'
449. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1912
450. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1912
       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
451. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
452. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
453. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
454. 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
455. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
456. 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
457. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1912
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
458. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1911
       AND p.published = 1
       ORDER BY a.ordering ASC
459. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1911
       AND t.published = 1
       LIMIT 0,1
460. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
461. SELECT *
       FROM jos_menu
       WHERE id = '130'
462. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1911'
463. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1911'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
464. 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='88'
       AND c.category_id = cx.category_parent_id
465. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
466. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
467. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1911'
       AND section='1'
468. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1911
469. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1911
       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
470. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
471. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
472. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
473. 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
474. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
475. 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
476. 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'
477. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
478. 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
479. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
480. 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
481. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1911
       AND ps.stockroom_id = s.stockroom_id
482. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1911
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
483. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
484. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1911
485. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1911
       AND ps.stockroom_id = s.stockroom_id
486. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
487. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1911"
       AND media_type="images" 
       AND media_name = "1396634534_6826-02.jpg"
488. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
489. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1911
       AND ps.stockroom_id = s.stockroom_id
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 p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1911
492. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1911
       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
493. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
494. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
495. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
496. 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
497. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
498. 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
499. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
500. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1911
       AND ps.stockroom_id = s.stockroom_id
501. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
502. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1911
503. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1911
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
504. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
505. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
506. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
507. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
508. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
509. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
510. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1911
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
511. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1910
       AND p.published = 1
       ORDER BY a.ordering ASC
512. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1910
       AND t.published = 1
       LIMIT 0,1
513. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
514. SELECT *
       FROM jos_menu
       WHERE id = '130'
515. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1910'
516. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1910'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
517. 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='88'
       AND c.category_id = cx.category_parent_id
518. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
519. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
520. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1910'
       AND section='1'
521. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1910
522. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1910
       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
523. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
524. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
525. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
526. 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
527. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
528. 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
529. 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'
530. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
531. 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
532. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
533. 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
534. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1910
       AND ps.stockroom_id = s.stockroom_id
535. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1910
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
536. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
537. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1910
538. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1910
       AND ps.stockroom_id = s.stockroom_id
539. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
540. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1910"
       AND media_type="images" 
       AND media_name = "1396634534_6826-11.jpg"
541. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
542. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1910
       AND ps.stockroom_id = s.stockroom_id
543. 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'
544. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1910
545. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1910
       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
546. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
547. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
548. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
549. 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
550. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
551. 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
552. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
553. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1910
       AND ps.stockroom_id = s.stockroom_id
554. 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'
555. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1910
556. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1910
       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
557. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
558. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
559. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
560. 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
561. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
562. 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
563. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1910
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
564. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1909
       AND p.published = 1
       ORDER BY a.ordering ASC
565. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1909
       AND t.published = 1
       LIMIT 0,1
566. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
567. SELECT *
       FROM jos_menu
       WHERE id = '130'
568. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1909'
569. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1909'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
570. 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='88'
       AND c.category_id = cx.category_parent_id
571. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
572. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
573. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1909'
       AND section='1'
574. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1909
575. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1909
       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
576. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
577. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
578. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
579. 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
580. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
581. 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
582. 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'
583. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
584. 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
585. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
586. 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
587. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1909
       AND ps.stockroom_id = s.stockroom_id
588. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1909
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
589. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
590. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1909
591. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1909
       AND ps.stockroom_id = s.stockroom_id
592. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
593. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1909"
       AND media_type="images" 
       AND media_name = "1396634534_6826-15.jpg"
594. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
595. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1909
       AND ps.stockroom_id = s.stockroom_id
596. 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'
597. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1909
598. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1909
       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
599. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
600. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
601. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
602. 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
603. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
604. 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
605. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
606. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1909
       AND ps.stockroom_id = s.stockroom_id
607. 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'
608. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1909
609. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1909
       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
610. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
611. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
612. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
613. 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
614. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
615. 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
616. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1909
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
617. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1908
       AND p.published = 1
       ORDER BY a.ordering ASC
618. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1908
       AND t.published = 1
       LIMIT 0,1
619. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
620. SELECT *
       FROM jos_menu
       WHERE id = '130'
621. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1908'
622. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1908'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
623. 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='88'
       AND c.category_id = cx.category_parent_id
624. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
625. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
626. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1908'
       AND section='1'
627. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1908
628. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1908
       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
629. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
630. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
631. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
632. 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
633. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
634. 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
635. 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'
636. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
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 = 1908
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1908
       AND ps.stockroom_id = s.stockroom_id
641. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1908
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
642. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
643. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1908
644. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1908
       AND ps.stockroom_id = s.stockroom_id
645. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
646. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1908"
       AND media_type="images" 
       AND media_name = "1396634534_6827-10.jpg"
647. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
648. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1908
       AND ps.stockroom_id = s.stockroom_id
649. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
650. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1908
651. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1908
       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
652. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
653. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
654. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
655. 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
656. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
657. 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
658. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
659. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1908
       AND ps.stockroom_id = s.stockroom_id
660. 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'
661. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1908
662. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1908
       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
663. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
664. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
665. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
666. 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
667. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
668. 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
669. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1908
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
670. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1907
       AND p.published = 1
       ORDER BY a.ordering ASC
671. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1907
       AND t.published = 1
       LIMIT 0,1
672. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
673. SELECT *
       FROM jos_menu
       WHERE id = '130'
674. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1907'
675. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1907'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
676. 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='88'
       AND c.category_id = cx.category_parent_id
677. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
678. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
679. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1907'
       AND section='1'
680. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1907
681. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1907
       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
682. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
683. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
684. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
685. 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
686. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
687. 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
688. 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'
689. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
690. 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
691. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
692. 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
693. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1907
       AND ps.stockroom_id = s.stockroom_id
694. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1907
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
695. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
696. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1907
697. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1907
       AND ps.stockroom_id = s.stockroom_id
698. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
699. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1907"
       AND media_type="images" 
       AND media_name = "1396634534_6827-11.jpg"
700. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
701. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1907
       AND ps.stockroom_id = s.stockroom_id
702. 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'
703. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1907
704. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1907
       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
705. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
706. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
707. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
708. 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
709. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
710. 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
711. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
712. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1907
       AND ps.stockroom_id = s.stockroom_id
713. 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'
714. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1907
715. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1907
       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
716. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
717. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
718. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
719. 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
720. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
721. 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
722. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1907
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
723. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1906
       AND p.published = 1
       ORDER BY a.ordering ASC
724. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1906
       AND t.published = 1
       LIMIT 0,1
725. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
726. SELECT *
       FROM jos_menu
       WHERE id = '130'
727. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1906'
728. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1906'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
729. 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='88'
       AND c.category_id = cx.category_parent_id
730. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
731. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
732. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1906'
       AND section='1'
733. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1906
734. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1906
       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
735. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
736. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
737. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
738. 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
739. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
740. 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
741. 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'
742. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
743. 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
744. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
745. 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
746. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1906
       AND ps.stockroom_id = s.stockroom_id
747. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1906
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
748. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
749. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1906
750. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1906
       AND ps.stockroom_id = s.stockroom_id
751. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
752. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1906"
       AND media_type="images" 
       AND media_name = "1396634534_6827-37.jpg"
753. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
754. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1906
       AND ps.stockroom_id = s.stockroom_id
755. 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'
756. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1906
757. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1906
       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
758. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
759. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
760. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
761. 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
762. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
763. 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
764. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
765. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1906
       AND ps.stockroom_id = s.stockroom_id
766. 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'
767. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1906
768. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1906
       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
769. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
770. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
771. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
772. 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
773. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
774. 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
775. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1906
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
776. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1905
       AND p.published = 1
       ORDER BY a.ordering ASC
777. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1905
       AND t.published = 1
       LIMIT 0,1
778. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
779. SELECT *
       FROM jos_menu
       WHERE id = '130'
780. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1905'
781. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1905'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
782. 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='88'
       AND c.category_id = cx.category_parent_id
783. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
784. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
785. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1905'
       AND section='1'
786. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1905
787. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1905
       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
788. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
789. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
790. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
791. 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
792. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
793. 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
794. 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'
795. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
796. 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
797. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
798. 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
799. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1905
       AND ps.stockroom_id = s.stockroom_id
800. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1905
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
801. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
802. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1905
803. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1905
       AND ps.stockroom_id = s.stockroom_id
804. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
805. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1905"
       AND media_type="images" 
       AND media_name = "1396634534_6828-02.jpg"
806. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
807. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1905
       AND ps.stockroom_id = s.stockroom_id
808. 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'
809. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1905
810. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1905
       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
811. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
812. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
813. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
814. 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
815. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
816. 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
817. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
818. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1905
       AND ps.stockroom_id = s.stockroom_id
819. 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'
820. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1905
821. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1905
       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
822. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
823. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
824. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
825. 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
826. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
827. 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
828. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1905
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
829. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1904
       AND p.published = 1
       ORDER BY a.ordering ASC
830. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1904
       AND t.published = 1
       LIMIT 0,1
831. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
832. SELECT *
       FROM jos_menu
       WHERE id = '130'
833. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1904'
834. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1904'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
835. 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='88'
       AND c.category_id = cx.category_parent_id
836. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
837. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
838. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1904'
       AND section='1'
839. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1904
840. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1904
       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
841. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
842. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
843. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1904
844. 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
845. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1904
846. 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
847. 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'
848. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1904
849. 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
850. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1904
851. 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
852. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1904
       AND ps.stockroom_id = s.stockroom_id
853. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1904
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
854. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1904
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
855. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1904
856. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1904
       AND ps.stockroom_id = s.stockroom_id
857. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
858. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1904"
       AND media_type="images" 
       AND media_name = "1396634534_6828-10.jpg"
859. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
860. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1904
       AND ps.stockroom_id = s.stockroom_id
861. 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'
862. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1904
863. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1904
       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
864. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
865. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
866. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1904
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 = 1904
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 *
       FROM jos_redshop_product
       WHERE product_id = 1904
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
871. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1904
       AND ps.stockroom_id = s.stockroom_id
872. 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'
873. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1904
874. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1904
       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
875. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
876. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
877. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1904
878. 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
879. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1904
880. 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
881. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1904
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
882. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1903
       AND p.published = 1
       ORDER BY a.ordering ASC
883. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1903
       AND t.published = 1
       LIMIT 0,1
884. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
885. SELECT *
       FROM jos_menu
       WHERE id = '130'
886. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1903'
887. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1903'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
888. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='88'
       AND c.category_id = cx.category_parent_id
889. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
890. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
891. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1903'
       AND section='1'
892. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1903
893. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1903
       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
894. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
895. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
896. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
897. 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
898. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
899. 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
900. 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'
901. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
902. 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
903. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
904. 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
905. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1903
       AND ps.stockroom_id = s.stockroom_id
906. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1903
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
907. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
908. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1903
909. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1903
       AND ps.stockroom_id = s.stockroom_id
910. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
911. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1903"
       AND media_type="images" 
       AND media_name = "1396634534_6828-11.jpg"
912. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
913. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1903
       AND ps.stockroom_id = s.stockroom_id
914. 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'
915. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1903
916. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1903
       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
917. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
918. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
919. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
920. 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
921. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
922. 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
923. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
924. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1903
       AND ps.stockroom_id = s.stockroom_id
925. 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'
926. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1903
927. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1903
       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
928. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
929. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
930. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
931. 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
932. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
933. 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
934. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1903
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
935. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1902
       AND p.published = 1
       ORDER BY a.ordering ASC
936. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1902
       AND t.published = 1
       LIMIT 0,1
937. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
938. SELECT *
       FROM jos_menu
       WHERE id = '130'
939. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1902'
940. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1902'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
941. 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='88'
       AND c.category_id = cx.category_parent_id
942. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
943. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
944. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1902'
       AND section='1'
945. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1902
946. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1902
       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
947. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
948. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
949. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
950. 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
951. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
952. 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
953. 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'
954. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
955. 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
956. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
957. 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
958. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1902
       AND ps.stockroom_id = s.stockroom_id
959. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1902
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
960. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
961. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 1902
962. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1902
       AND ps.stockroom_id = s.stockroom_id
963. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
964. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="1902"
       AND media_type="images" 
       AND media_name = "1396634534_7319-06.jpg"
965. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
966. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1902
       AND ps.stockroom_id = s.stockroom_id
967. 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'
968. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1902
969. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1902
       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
970. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
971. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
972. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
973. 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
974. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
975. 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
976. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
977. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 1902
       AND ps.stockroom_id = s.stockroom_id
978. 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'
979. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1902
980. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1902
       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
981. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
982. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1740211782'
       AND end_date >= '1740211782' 
       ORDER BY amount DESC
       LIMIT 0,1
983. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
984. 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
985. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
986. 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
987. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 1902
       AND discount_enddate>='1740211782'
       AND discount_stratdate<='1740211782'
988. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=1901
       AND p.published = 1
       ORDER BY a.ordering ASC
989. SELECT *
       FROM jos_redshop_product AS p, jos_redshop_template AS t
       WHERE t.template_id = p.product_template
       AND t.template_section='product'
       AND p.product_id=1901
       AND t.published = 1
       LIMIT 0,1
990. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
991. SELECT *
       FROM jos_menu
       WHERE id = '130'
992. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '1901'
993. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '1901'
       AND pc.category_id = c.category_id 
       AND c.category_id = '88'
994. 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='88'
       AND c.category_id = cx.category_parent_id
995. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
996. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
997. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='1901'
       AND section='1'
998. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 1901
999. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 1901
       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
1000. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1001. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1002. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1901
1003. 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
1004. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1901
1005. 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
1006. 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'
1007. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1901
1008. 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
1009. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1901
1010. 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
1011. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1901
        AND ps.stockroom_id = s.stockroom_id
1012. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1901
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1013. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1901
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1014. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 1901
1015. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1901
        AND ps.stockroom_id = s.stockroom_id
1016. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1017. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="1901"
        AND media_type="images" 
        AND media_name = "1396634534_7319-10.jpg"
1018. SELECT *
        FROM jos_redshop_template
        WHERE template_section LIKE 'add_to_cart'
        AND published=1
1019. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1901
        AND ps.stockroom_id = s.stockroom_id
1020. 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'
1021. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1901
1022. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1901
        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
1023. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1024. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1025. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1901
1026. 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
1027. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1901
1028. 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
1029. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1901
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1030. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1901
        AND ps.stockroom_id = s.stockroom_id
1031. 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'
1032. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1901
1033. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1901
        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 <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1036. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1901
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 = 1901
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 *
        FROM jos_redshop_product
        WHERE product_id = 1901
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1041. SELECT count(a.attribute_id)
        FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
        WHERE a.product_id = p.product_id
        AND p.product_id=1900
        AND p.published = 1
        ORDER BY a.ordering ASC
1042. SELECT *
        FROM jos_redshop_product AS p, jos_redshop_template AS t
        WHERE t.template_id = p.product_template
        AND t.template_section='product'
        AND p.product_id=1900
        AND t.published = 1
        LIMIT 0,1
1043. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='12'
        AND field_name=''
        AND published=1
        AND field_show_in_front=1
1044. SELECT *
        FROM jos_menu
        WHERE id = '130'
1045. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '1900'
1046. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '1900'
        AND pc.category_id = c.category_id 
        AND c.category_id = '88'
1047. 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='88'
        AND c.category_id = cx.category_parent_id
1048. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '88'
1049. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='1'
        AND published=1
1050. SELECT *
        FROM jos_redshop_fields_data
        WHERE fieldid='1'
        AND itemid='1900'
        AND section='1'
1051. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1900
1052. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1900
        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
1053. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1054. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1055. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
1056. 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
1057. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
1058. 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
1059. 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'
1060. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
1061. 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
1062. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
1063. 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
1064. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1900
        AND ps.stockroom_id = s.stockroom_id
1065. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1900
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1066. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1067. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 1900
1068. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1900
        AND ps.stockroom_id = s.stockroom_id
1069. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1070. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="1900"
        AND media_type="images" 
        AND media_name = "1396634534_7319-11.jpg"
1071. SELECT *
        FROM jos_redshop_template
        WHERE template_section LIKE 'add_to_cart'
        AND published=1
1072. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1900
        AND ps.stockroom_id = s.stockroom_id
1073. 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'
1074. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1900
1075. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1900
        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
1076. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1077. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1078. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
1079. 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
1080. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
1081. 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
1082. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1083. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1900
        AND ps.stockroom_id = s.stockroom_id
1084. 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'
1085. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1900
1086. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1900
        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
1087. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1088. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1089. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
1090. 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
1091. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
1092. 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
1093. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1900
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1094. SELECT count(a.attribute_id)
        FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
        WHERE a.product_id = p.product_id
        AND p.product_id=1899
        AND p.published = 1
        ORDER BY a.ordering ASC
1095. SELECT *
        FROM jos_redshop_product AS p, jos_redshop_template AS t
        WHERE t.template_id = p.product_template
        AND t.template_section='product'
        AND p.product_id=1899
        AND t.published = 1
        LIMIT 0,1
1096. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='12'
        AND field_name=''
        AND published=1
        AND field_show_in_front=1
1097. SELECT *
        FROM jos_menu
        WHERE id = '130'
1098. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '1899'
1099. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '1899'
        AND pc.category_id = c.category_id 
        AND c.category_id = '88'
1100. 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='88'
        AND c.category_id = cx.category_parent_id
1101. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '88'
1102. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='1'
        AND published=1
1103. SELECT *
        FROM jos_redshop_fields_data
        WHERE fieldid='1'
        AND itemid='1899'
        AND section='1'
1104. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1899
1105. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1899
        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
1106. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1107. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1108. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
1109. 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
1110. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
1111. 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
1112. 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'
1113. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
1114. 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
1115. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
1116. 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
1117. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1899
        AND ps.stockroom_id = s.stockroom_id
1118. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1899
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1119. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1120. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 1899
1121. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1899
        AND ps.stockroom_id = s.stockroom_id
1122. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1123. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="1899"
        AND media_type="images" 
        AND media_name = "1396634534_7320-02.jpg"
1124. SELECT *
        FROM jos_redshop_template
        WHERE template_section LIKE 'add_to_cart'
        AND published=1
1125. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1899
        AND ps.stockroom_id = s.stockroom_id
1126. 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'
1127. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1899
1128. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1899
        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
1129. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1130. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1131. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
1132. 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
1133. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
1134. 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
1135. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1136. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1899
        AND ps.stockroom_id = s.stockroom_id
1137. 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'
1138. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1899
1139. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1899
        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
1140. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1141. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1142. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
1143. 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
1144. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
1145. 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
1146. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1899
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1147. SELECT count(a.attribute_id)
        FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
        WHERE a.product_id = p.product_id
        AND p.product_id=1898
        AND p.published = 1
        ORDER BY a.ordering ASC
1148. SELECT *
        FROM jos_redshop_product AS p, jos_redshop_template AS t
        WHERE t.template_id = p.product_template
        AND t.template_section='product'
        AND p.product_id=1898
        AND t.published = 1
        LIMIT 0,1
1149. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='12'
        AND field_name=''
        AND published=1
        AND field_show_in_front=1
1150. SELECT *
        FROM jos_menu
        WHERE id = '130'
1151. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '1898'
1152. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '1898'
        AND pc.category_id = c.category_id 
        AND c.category_id = '88'
1153. 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='88'
        AND c.category_id = cx.category_parent_id
1154. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '88'
1155. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='1'
        AND published=1
1156. SELECT *
        FROM jos_redshop_fields_data
        WHERE fieldid='1'
        AND itemid='1898'
        AND section='1'
1157. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1898
1158. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1898
        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 <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1161. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1898
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 = 1898
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 = 1898
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 = 1898
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 = 1898
        AND ps.stockroom_id = s.stockroom_id
1171. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1898
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1172. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1898
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1173. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 1898
1174. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1898
        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 ="1898"
        AND media_type="images" 
        AND media_name = "1396634534_7320-10.jpg"
1177. SELECT *
        FROM jos_redshop_template
        WHERE template_section LIKE 'add_to_cart'
        AND published=1
1178. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1898
        AND ps.stockroom_id = s.stockroom_id
1179. 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'
1180. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1898
1181. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1898
        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
1182. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1183. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1184. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1898
1185. 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
1186. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1898
1187. 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
1188. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1898
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1189. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1898
        AND ps.stockroom_id = s.stockroom_id
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 p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1898
1192. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1898
        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
1193. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1194. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1195. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1898
1196. 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
1197. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1898
1198. 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
1199. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1898
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1200. SELECT count(a.attribute_id)
        FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
        WHERE a.product_id = p.product_id
        AND p.product_id=1897
        AND p.published = 1
        ORDER BY a.ordering ASC
1201. SELECT *
        FROM jos_redshop_product AS p, jos_redshop_template AS t
        WHERE t.template_id = p.product_template
        AND t.template_section='product'
        AND p.product_id=1897
        AND t.published = 1
        LIMIT 0,1
1202. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='12'
        AND field_name=''
        AND published=1
        AND field_show_in_front=1
1203. SELECT *
        FROM jos_menu
        WHERE id = '130'
1204. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '1897'
1205. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '1897'
        AND pc.category_id = c.category_id 
        AND c.category_id = '88'
1206. 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='88'
        AND c.category_id = cx.category_parent_id
1207. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '88'
1208. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='1'
        AND published=1
1209. SELECT *
        FROM jos_redshop_fields_data
        WHERE fieldid='1'
        AND itemid='1897'
        AND section='1'
1210. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1897
1211. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1897
        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
1212. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1213. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1214. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
1215. 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
1216. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
1217. 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
1218. 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'
1219. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
1220. 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
1221. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
1222. 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
1223. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1897
        AND ps.stockroom_id = s.stockroom_id
1224. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1897
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1225. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1226. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 1897
1227. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1897
        AND ps.stockroom_id = s.stockroom_id
1228. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1229. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="1897"
        AND media_type="images" 
        AND media_name = "1396634534_7320-11.jpg"
1230. SELECT *
        FROM jos_redshop_template
        WHERE template_section LIKE 'add_to_cart'
        AND published=1
1231. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1897
        AND ps.stockroom_id = s.stockroom_id
1232. 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'
1233. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1897
1234. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1897
        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
1235. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1236. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1237. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
1238. 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
1239. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
1240. 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
1241. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1242. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1897
        AND ps.stockroom_id = s.stockroom_id
1243. 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'
1244. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1897
1245. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1897
        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
1246. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1247. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1248. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
1249. 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
1250. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
1251. 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
1252. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1897
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1253. SELECT count(a.attribute_id)
        FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
        WHERE a.product_id = p.product_id
        AND p.product_id=1896
        AND p.published = 1
        ORDER BY a.ordering ASC
1254. SELECT *
        FROM jos_redshop_product AS p, jos_redshop_template AS t
        WHERE t.template_id = p.product_template
        AND t.template_section='product'
        AND p.product_id=1896
        AND t.published = 1
        LIMIT 0,1
1255. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='12'
        AND field_name=''
        AND published=1
        AND field_show_in_front=1
1256. SELECT *
        FROM jos_menu
        WHERE id = '130'
1257. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '1896'
1258. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '1896'
        AND pc.category_id = c.category_id 
        AND c.category_id = '88'
1259. 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='88'
        AND c.category_id = cx.category_parent_id
1260. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '88'
1261. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='1'
        AND published=1
1262. SELECT *
        FROM jos_redshop_fields_data
        WHERE fieldid='1'
        AND itemid='1896'
        AND section='1'
1263. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1896
1264. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1896
        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
1265. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1266. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1267. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
1268. 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
1269. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
1270. 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
1271. 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'
1272. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
1273. 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
1274. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
1275. 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
1276. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1896
        AND ps.stockroom_id = s.stockroom_id
1277. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1896
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1278. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1279. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 1896
1280. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1896
        AND ps.stockroom_id = s.stockroom_id
1281. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1282. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="1896"
        AND media_type="images" 
        AND media_name = "1396634534_7320-15.jpg"
1283. SELECT *
        FROM jos_redshop_template
        WHERE template_section LIKE 'add_to_cart'
        AND published=1
1284. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1896
        AND ps.stockroom_id = s.stockroom_id
1285. 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'
1286. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1896
1287. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1896
        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
1288. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1289. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1290. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
1291. 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
1292. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
1293. 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
1294. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1295. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 1896
        AND ps.stockroom_id = s.stockroom_id
1296. 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'
1297. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 1896
1298. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 1896
        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
1299. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1300. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1740211782'
        AND end_date >= '1740211782' 
        ORDER BY amount DESC
        LIMIT 0,1
1301. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
1302. 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
1303. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
1304. 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
1305. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 1896
        AND discount_enddate>='1740211782'
        AND discount_stratdate<='1740211782'
1306. SELECT *
        FROM jos_redshop_category
        WHERE category_id = 88
1307. SELECT *
        FROM jos_menu
        WHERE link LIKE '%com_redshop%'
        AND published=1
        AND id = '130'
1308. SELECT *
        FROM jos_menu
        WHERE link LIKE '%com_redshop%'
        AND published=1 
        AND link LIKE '%view=category%' 
        AND params NOT LIKE '%categoryid%'
1309. SELECT *
        FROM jos_menu
        WHERE link LIKE '%com_redshop%'
        AND published=1 
        AND link LIKE '%view=category%' 
        AND params  LIKE '%categoryid=88
      %'
1310. SELECT category_parent_id
        FROM jos_redshop_category_xref
        WHERE category_child_id=88
1311. SELECT *
        FROM jos_menu
        WHERE id = '130'
1312. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '88'
1313. 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='88'
        AND c.category_id = cx.category_parent_id
1314. 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 = 130 OR mm.menuid = 0 )
        ORDER BY position, ordering
1315. SELECT *
        FROM jos_menu
        WHERE id = '71'
1316. SELECT *
        FROM jos_menu
        WHERE id = '222'
1317. SELECT category_id      
        FROM jos_redshop_product_category_xref cx
        WHERE product_id = ''
1318. 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'
1319. SELECT category_id AS value,category_name AS text
        FROM jos_redshop_category
        WHERE published = 1
1320. SELECT *
        FROM jos_menu
        WHERE id = '130'