Profile Information

Memory Usage

888 queries logged

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