Profile Information

Memory Usage

788 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'pj63fr3b2qfgi5ev5ekldsiqt1'
2. DELETE
     FROM jos_session
     WHERE ( time < '1745124827' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'pj63fr3b2qfgi5ev5ekldsiqt1'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'pj63fr3b2qfgi5ev5ekldsiqt1','1745132027','','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-20'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'pj63fr3b2qfgi5ev5ekldsiqt1'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('pj63fr3b2qfgi5ev5ekldsiqt1', '0','1745132029')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'pj63fr3b2qfgi5ev5ekldsiqt1'
      AND section='category'
      AND section_id='31'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('pj63fr3b2qfgi5ev5ekldsiqt1','0','category','31','1745132030')
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 10, 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=33
      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=33
      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 = '33'
41. 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'
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='33'
      AND section='1'
47. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 33
48. 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
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 <= '1745132030'
      AND end_date >= '1745132030' 
      ORDER BY amount DESC
      LIMIT 0,1
51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 33
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 = 33
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 = 33
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 = 33
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 = 33
      AND ps.stockroom_id = s.stockroom_id
61. 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
62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 33
      AND discount_enddate>='1745132030'
      AND discount_stratdate<='1745132030'
63. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 33
64. 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
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 ="33"
      AND media_type="images" 
      AND media_name = "1301289466_CT4755-1.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 = 33
      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 = 33
71. 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
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 <= '1745132030'
      AND end_date >= '1745132030' 
      ORDER BY amount DESC
      LIMIT 0,1
74. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 33
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 = 33
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 = 33
      AND discount_enddate>='1745132030'
      AND discount_stratdate<='1745132030'
79. 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
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 = 33
82. 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
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 <= '1745132030'
      AND end_date >= '1745132030' 
      ORDER BY amount DESC
      LIMIT 0,1
85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 33
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 = 33
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 = 33
      AND discount_enddate>='1745132030'
      AND discount_stratdate<='1745132030'
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=47
      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=47
      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 = '47'
95. 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'
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='47'
       AND section='1'
101. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 47
102. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
105. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 47
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 = 47
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 = 47
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 = 47
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 = 47
       AND ps.stockroom_id = s.stockroom_id
115. 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
116. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 47
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
117. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 47
118. 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
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 ="47"
       AND media_type="images" 
       AND media_name = "1301544336_CT4756-1.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 = 47
       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 = 47
125. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
128. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 47
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 = 47
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 = 47
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
133. 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
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 = 47
136. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
139. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 47
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 = 47
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 = 47
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=48
       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=48
       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 = '48'
149. 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'
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='48'
       AND section='1'
155. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 48
156. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
159. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 48
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 = 48
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 = 48
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 = 48
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 = 48
       AND ps.stockroom_id = s.stockroom_id
169. 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
170. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 48
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
171. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 48
172. 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
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 ="48"
       AND media_type="images" 
       AND media_name = "1301544506_CT4757-1.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 = 48
       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 = 48
179. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
182. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 48
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 = 48
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 = 48
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
187. 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
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 = 48
190. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
193. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 48
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 = 48
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 = 48
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=49
       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=49
       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 = '49'
203. 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'
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='49'
       AND section='1'
209. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 49
210. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
213. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 49
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 = 49
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 = 49
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 = 49
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 = 49
       AND ps.stockroom_id = s.stockroom_id
223. 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
224. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 49
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
225. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 49
226. 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
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 ="49"
       AND media_type="images" 
       AND media_name = "1301544610_CT4758-1.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 = 49
       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 = 49
233. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
236. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 49
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 = 49
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 = 49
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
241. 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
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 = 49
244. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
247. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 49
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 = 49
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 = 49
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=50
       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=50
       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 = '50'
257. 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'
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='50'
       AND section='1'
263. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 50
264. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
267. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 50
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 = 50
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 = 50
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 = 50
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 = 50
       AND ps.stockroom_id = s.stockroom_id
277. 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
278. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 50
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
279. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 50
280. 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
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 ="50"
       AND media_type="images" 
       AND media_name = "1301544685_CT4759-1.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 = 50
       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 = 50
287. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
290. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 50
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 = 50
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 = 50
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
295. 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
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 = 50
298. 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
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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
301. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 50
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 = 50
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 = 50
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=51
       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=51
       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 = '51'
311. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '51'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
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='51'
       AND section='1'
317. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 51
318. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 51
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
321. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 51
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 = 51
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 = 51
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 = 51
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 = 51
       AND ps.stockroom_id = s.stockroom_id
331. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 51
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
332. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 51
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
333. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 51
334. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 51
       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 ="51"
       AND media_type="images" 
       AND media_name = "1301544769_CT4760-1.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 = 51
       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 = 51
341. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 51
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
344. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 51
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 = 51
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 = 51
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
349. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 51
       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 = 51
352. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 51
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
355. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 51
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 = 51
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 = 51
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=52
       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=52
       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 = '52'
365. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '52'
       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='52'
       AND section='1'
371. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 52
372. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 52
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
375. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 52
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 = 52
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 = 52
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 = 52
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 = 52
       AND ps.stockroom_id = s.stockroom_id
385. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 52
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
386. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 52
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
387. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 52
388. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 52
       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 ="52"
       AND media_type="images" 
       AND media_name = "1301544875_CT4761-1.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 = 52
       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 = 52
395. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 52
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
398. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 52
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 = 52
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 = 52
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
403. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 52
       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 = 52
406. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 52
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
409. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 52
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 = 52
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 = 52
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=53
       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=53
       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 = '53'
419. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '53'
       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='53'
       AND section='1'
425. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 53
426. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 53
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
429. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 53
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 = 53
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 = 53
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 = 53
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 = 53
       AND ps.stockroom_id = s.stockroom_id
439. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 53
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
440. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 53
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
441. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 53
442. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 53
       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 ="53"
       AND media_type="images" 
       AND media_name = "1301544923_CT5840-8.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 = 53
       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 = 53
449. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 53
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
452. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 53
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 = 53
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 = 53
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
457. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 53
       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 = 53
460. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 53
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
463. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 53
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 = 53
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 = 53
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=54
       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=54
       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 = '54'
473. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '54'
       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='54'
       AND section='1'
479. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 54
480. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 54
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
483. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 54
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 = 54
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 = 54
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 = 54
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 = 54
       AND ps.stockroom_id = s.stockroom_id
493. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 54
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
494. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 54
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
495. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 54
496. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 54
       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 ="54"
       AND media_type="images" 
       AND media_name = "1301545040_CT5851-6.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 = 54
       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 = 54
503. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 54
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
506. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 54
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 = 54
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 = 54
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
511. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 54
       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 = 54
514. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 54
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
517. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 54
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 = 54
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 = 54
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=55
       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=55
       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 = '55'
527. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '55'
       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='55'
       AND section='1'
533. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 55
534. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 55
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
537. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 55
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 = 55
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 = 55
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 = 55
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 = 55
       AND ps.stockroom_id = s.stockroom_id
547. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 55
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
548. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 55
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
549. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 55
550. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 55
       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 ="55"
       AND media_type="images" 
       AND media_name = "1301545226_CT6618-18.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 = 55
       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 = 55
557. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 55
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
560. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 55
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 = 55
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 = 55
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
565. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 55
       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 = 55
568. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 55
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
571. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 55
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 = 55
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 = 55
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=56
       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=56
       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 = '56'
581. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '56'
       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='56'
       AND section='1'
587. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 56
588. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 56
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
591. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 56
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 = 56
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 = 56
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 = 56
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 = 56
       AND ps.stockroom_id = s.stockroom_id
601. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 56
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
602. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 56
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
603. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 56
604. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 56
       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 ="56"
       AND media_type="images" 
       AND media_name = "1301545388_CT7141-7.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 = 56
       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 = 56
611. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 56
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
614. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 56
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 = 56
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 = 56
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
619. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 56
       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 = 56
622. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 56
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
625. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 56
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 = 56
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 = 56
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=57
       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=57
       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 = '57'
635. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '57'
       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='57'
       AND section='1'
641. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 57
642. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 57
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
645. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 57
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 = 57
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 = 57
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 = 57
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 = 57
       AND ps.stockroom_id = s.stockroom_id
655. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 57
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
656. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 57
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
657. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 57
658. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 57
       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 ="57"
       AND media_type="images" 
       AND media_name = "1301545595_CT7143-11.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 = 57
       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 = 57
665. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 57
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
668. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 57
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 = 57
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 = 57
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
673. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 57
       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 = 57
676. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 57
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
679. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 57
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 = 57
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 = 57
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
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=58
       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=58
       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 = '58'
689. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '58'
       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='58'
       AND section='1'
695. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 58
696. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 58
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
699. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 58
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 = 58
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 = 58
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 = 58
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 = 58
       AND ps.stockroom_id = s.stockroom_id
709. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 58
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
710. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 58
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
711. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 58
712. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 58
       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 ="58"
       AND media_type="images" 
       AND media_name = "1301545732_CT7616-7.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 = 58
       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 = 58
719. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 58
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
722. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 58
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 = 58
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 = 58
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
727. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 58
       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 = 58
730. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 58
       AND p.shopper_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 <= '1745132030'
       AND end_date >= '1745132030' 
       ORDER BY amount DESC
       LIMIT 0,1
733. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 58
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 = 58
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 = 58
       AND discount_enddate>='1745132030'
       AND discount_stratdate<='1745132030'
738. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 31
739. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '222'
740. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params NOT LIKE '%categoryid%'
741. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=31
     %'
742. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 31
743. SELECT *
       FROM jos_menu
       WHERE id = '222'
744. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
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='31'
       AND c.category_id = cx.category_parent_id
746. 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
747. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=31
748. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=29
     %'
749. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 29
750. SELECT *
       FROM jos_menu
       WHERE id = '222'
751. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '29'
752. 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
753. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=29
754. SELECT *
       FROM jos_menu
       WHERE id = '222'
755. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
756. 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
757. 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
758. SELECT *
       FROM jos_menu
       WHERE id = '222'
759. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
760. 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
761. 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
762. SELECT *
       FROM jos_menu
       WHERE id = '222'
763. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
764. 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
765. 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
766. SELECT *
       FROM jos_menu
       WHERE id = '222'
767. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
768. 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
769. 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
770. SELECT *
       FROM jos_menu
       WHERE id = '222'
771. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
772. 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
773. 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
774. SELECT *
       FROM jos_menu
       WHERE id = '222'
775. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
776. 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
777. 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
778. SELECT *
       FROM jos_menu
       WHERE id = '222'
779. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
780. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='31'
       AND c.category_id = cx.category_parent_id
781. 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
782. 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
783. SELECT *
       FROM jos_menu
       WHERE id = '71'
784. SELECT *
       FROM jos_menu
       WHERE id = '222'
785. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
786. 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'
787. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
788. SELECT *
       FROM jos_menu
       WHERE id = '222'