Profile Information

Memory Usage

1112 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'asr23vt4g5npnq1gqq49mgr186'
2. DELETE
     FROM jos_session
     WHERE ( time < '1747078278' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'asr23vt4g5npnq1gqq49mgr186'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'asr23vt4g5npnq1gqq49mgr186','1747085478','','0','1','0' )
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT m.*, c.`option` AS component
     FROM jos_menu AS m
     LEFT JOIN jos_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT *
     FROM jos_redshop_configuration
9. SELECT *
     FROM jos_redshop_catalog_request
     WHERE block = 0
10. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
11. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-05-12'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'asr23vt4g5npnq1gqq49mgr186'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('asr23vt4g5npnq1gqq49mgr186', '0','1747085481')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'asr23vt4g5npnq1gqq49mgr186'
      AND section='category'
      AND section_id=''
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('asr23vt4g5npnq1gqq49mgr186','0','category','','1747085483')
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 = 180)
      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=129
      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
      WHERE category_id = 129
20. 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=129
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
21. 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=129
      AND published = 1
      ORDER BY c.category_name ASC
22. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '129'
23. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=129%')
      ORDER BY 'ordering'
24. SELECT *
      FROM jos_menu
      WHERE id = '180'
25. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '129'
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='129'
      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=129
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 0, 20
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=129
      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=129
      AND published = 1
      ORDER BY c.category_name ASC
30. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '129'
31. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=129%')
      ORDER BY 'ordering'
32. SELECT *
      FROM jos_menu
      WHERE id = '180'
33. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '129'
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='129'
      AND c.category_id = cx.category_parent_id
35. 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=5764
      AND p.published = 1
      ORDER BY a.ordering ASC
36. 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=5764
      AND t.published = 1
      LIMIT 0,1
37. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
38. SELECT *
      FROM jos_menu
      WHERE id = '180'
39. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '5764'
40. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '5764'
      AND pc.category_id = c.category_id
41. 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='129'
      AND c.category_id = cx.category_parent_id
42. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '129'
43. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
44. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='5764'
      AND section='1'
45. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 5764
46. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 5764
      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
47. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
48. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1747085483'
      AND end_date >= '1747085483' 
      ORDER BY amount DESC
      LIMIT 0,1
49. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
50. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
52. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
53. 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'
54. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
55. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
56. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
57. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
58. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 5764
      AND ps.stockroom_id = s.stockroom_id
59. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 5764
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
60. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
      AND discount_enddate>='1747085483'
      AND discount_stratdate<='1747085483'
61. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 5764
62. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 5764
      AND ps.stockroom_id = s.stockroom_id
63. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
64. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="5764"
      AND media_type="images" 
      AND media_name = "1432322444_35200.jpg"
65. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
66. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 5764
      AND ps.stockroom_id = s.stockroom_id
67. 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'
68. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 5764
69. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 5764
      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
70. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
71. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1747085483'
      AND end_date >= '1747085483' 
      ORDER BY amount DESC
      LIMIT 0,1
72. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
73. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
74. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
75. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
76. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
      AND discount_enddate>='1747085483'
      AND discount_stratdate<='1747085483'
77. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 5764
      AND ps.stockroom_id = s.stockroom_id
78. 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'
79. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 5764
80. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 5764
      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
81. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
82. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1747085483'
      AND end_date >= '1747085483' 
      ORDER BY amount DESC
      LIMIT 0,1
83. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
84. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
86. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
87. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 5764
      AND discount_enddate>='1747085483'
      AND discount_stratdate<='1747085483'
88. 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=5765
      AND p.published = 1
      ORDER BY a.ordering ASC
89. 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=5765
      AND t.published = 1
      LIMIT 0,1
90. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
91. SELECT *
      FROM jos_menu
      WHERE id = '180'
92. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '5765'
93. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '5765'
      AND pc.category_id = c.category_id
94. 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='129'
      AND c.category_id = cx.category_parent_id
95. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '129'
96. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
97. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='5765'
      AND section='1'
98. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 5765
99. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 5765
      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
100. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
101. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
102. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
103. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
104. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
105. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
106. 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'
107. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
108. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
109. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
110. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
111. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5765
       AND ps.stockroom_id = s.stockroom_id
112. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5765
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
113. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
114. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5765
115. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5765
       AND ps.stockroom_id = s.stockroom_id
116. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
117. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5765"
       AND media_type="images" 
       AND media_name = "1432322532_35201.jpg"
118. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
119. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5765
       AND ps.stockroom_id = s.stockroom_id
120. 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'
121. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5765
122. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5765
       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
123. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
124. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
125. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
126. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
127. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
128. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
129. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
130. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5765
       AND ps.stockroom_id = s.stockroom_id
131. 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'
132. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5765
133. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5765
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
134. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
135. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
136. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
137. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
138. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
139. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
140. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5765
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
141. 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=5766
       AND p.published = 1
       ORDER BY a.ordering ASC
142. 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=5766
       AND t.published = 1
       LIMIT 0,1
143. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
144. SELECT *
       FROM jos_menu
       WHERE id = '180'
145. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5766'
146. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5766'
       AND pc.category_id = c.category_id
147. 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='129'
       AND c.category_id = cx.category_parent_id
148. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
149. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
150. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5766'
       AND section='1'
151. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5766
152. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5766
       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
153. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
154. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
155. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
156. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
157. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
158. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
159. 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'
160. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
161. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
162. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
163. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
164. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5766
       AND ps.stockroom_id = s.stockroom_id
165. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5766
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
166. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
167. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5766
168. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5766
       AND ps.stockroom_id = s.stockroom_id
169. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
170. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5766"
       AND media_type="images" 
       AND media_name = "1432342789_35203.jpg"
171. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
172. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5766
       AND ps.stockroom_id = s.stockroom_id
173. 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'
174. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5766
175. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5766
       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
176. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
177. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
178. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
179. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
180. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
181. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
182. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
183. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5766
       AND ps.stockroom_id = s.stockroom_id
184. 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'
185. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5766
186. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5766
       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
187. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
188. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
189. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
190. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
191. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
192. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
193. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5766
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
194. 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=5767
       AND p.published = 1
       ORDER BY a.ordering ASC
195. 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=5767
       AND t.published = 1
       LIMIT 0,1
196. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
197. SELECT *
       FROM jos_menu
       WHERE id = '180'
198. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5767'
199. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5767'
       AND pc.category_id = c.category_id
200. 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='129'
       AND c.category_id = cx.category_parent_id
201. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
202. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
203. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5767'
       AND section='1'
204. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5767
205. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5767
       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
206. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
207. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
208. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
209. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
210. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
211. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
212. 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'
213. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
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 = 5767
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5767
       AND ps.stockroom_id = s.stockroom_id
218. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5767
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
219. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
220. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5767
221. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5767
       AND ps.stockroom_id = s.stockroom_id
222. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
223. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5767"
       AND media_type="images" 
       AND media_name = "1432342812_35205.jpg"
224. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
225. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5767
       AND ps.stockroom_id = s.stockroom_id
226. 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'
227. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5767
228. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5767
       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
229. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
230. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
231. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
232. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
233. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
234. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
235. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
236. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5767
       AND ps.stockroom_id = s.stockroom_id
237. 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'
238. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5767
239. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5767
       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
240. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
241. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
242. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
243. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
244. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
245. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
246. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5767
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
247. 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=5768
       AND p.published = 1
       ORDER BY a.ordering ASC
248. 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=5768
       AND t.published = 1
       LIMIT 0,1
249. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
250. SELECT *
       FROM jos_menu
       WHERE id = '180'
251. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5768'
252. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5768'
       AND pc.category_id = c.category_id
253. 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='129'
       AND c.category_id = cx.category_parent_id
254. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
255. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
256. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5768'
       AND section='1'
257. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5768
258. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5768
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
259. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
260. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
261. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
262. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
263. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
264. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
265. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
266. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
267. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
268. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
269. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
270. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5768
       AND ps.stockroom_id = s.stockroom_id
271. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5768
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
272. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
273. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5768
274. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5768
       AND ps.stockroom_id = s.stockroom_id
275. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
276. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5768"
       AND media_type="images" 
       AND media_name = "1432342834_35206.jpg"
277. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
278. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5768
       AND ps.stockroom_id = s.stockroom_id
279. 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'
280. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5768
281. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5768
       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
282. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
283. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
284. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
285. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
286. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
287. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
288. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
289. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5768
       AND ps.stockroom_id = s.stockroom_id
290. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
291. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5768
292. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5768
       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
293. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
294. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
295. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
296. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
297. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
298. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
299. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5768
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
300. 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=5769
       AND p.published = 1
       ORDER BY a.ordering ASC
301. 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=5769
       AND t.published = 1
       LIMIT 0,1
302. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
303. SELECT *
       FROM jos_menu
       WHERE id = '180'
304. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5769'
305. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5769'
       AND pc.category_id = c.category_id
306. 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='129'
       AND c.category_id = cx.category_parent_id
307. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
308. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
309. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5769'
       AND section='1'
310. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5769
311. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5769
       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
312. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
313. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
314. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
315. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
316. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
317. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
318. 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'
319. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
320. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
321. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
322. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
323. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5769
       AND ps.stockroom_id = s.stockroom_id
324. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5769
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
325. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
326. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5769
327. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5769
       AND ps.stockroom_id = s.stockroom_id
328. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
329. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5769"
       AND media_type="images" 
       AND media_name = "1432342855_35208.jpg"
330. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
331. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5769
       AND ps.stockroom_id = s.stockroom_id
332. 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'
333. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5769
334. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5769
       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
335. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
336. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
337. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
338. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
339. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
340. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
341. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
342. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5769
       AND ps.stockroom_id = s.stockroom_id
343. 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'
344. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5769
345. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5769
       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
346. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
347. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
348. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
349. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
350. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
351. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
352. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5769
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
353. 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=5770
       AND p.published = 1
       ORDER BY a.ordering ASC
354. 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=5770
       AND t.published = 1
       LIMIT 0,1
355. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
356. SELECT *
       FROM jos_menu
       WHERE id = '180'
357. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5770'
358. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5770'
       AND pc.category_id = c.category_id
359. 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='129'
       AND c.category_id = cx.category_parent_id
360. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
361. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
362. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5770'
       AND section='1'
363. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5770
364. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5770
       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
365. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
366. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
367. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
368. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
369. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
370. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
371. 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'
372. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
373. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
374. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
375. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
376. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5770
       AND ps.stockroom_id = s.stockroom_id
377. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5770
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
378. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
379. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5770
380. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5770
       AND ps.stockroom_id = s.stockroom_id
381. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
382. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5770"
       AND media_type="images" 
       AND media_name = "1432342887_35209.jpg"
383. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
384. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5770
       AND ps.stockroom_id = s.stockroom_id
385. 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'
386. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5770
387. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5770
       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
388. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
389. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
390. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
391. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
392. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
393. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
394. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
395. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5770
       AND ps.stockroom_id = s.stockroom_id
396. 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'
397. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5770
398. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5770
       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
399. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
400. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
401. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
402. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
403. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
404. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
405. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5770
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
406. 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=5771
       AND p.published = 1
       ORDER BY a.ordering ASC
407. 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=5771
       AND t.published = 1
       LIMIT 0,1
408. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
409. SELECT *
       FROM jos_menu
       WHERE id = '180'
410. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5771'
411. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5771'
       AND pc.category_id = c.category_id
412. 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='129'
       AND c.category_id = cx.category_parent_id
413. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
414. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
415. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5771'
       AND section='1'
416. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5771
417. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5771
       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
418. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
419. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
420. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
421. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
422. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
423. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
424. 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'
425. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
426. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
427. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
428. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
429. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5771
       AND ps.stockroom_id = s.stockroom_id
430. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5771
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
431. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
432. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5771
433. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5771
       AND ps.stockroom_id = s.stockroom_id
434. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
435. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5771"
       AND media_type="images" 
       AND media_name = "1432342907_35211.jpg"
436. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
437. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5771
       AND ps.stockroom_id = s.stockroom_id
438. 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'
439. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5771
440. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5771
       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
441. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
442. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
443. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
444. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
445. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
446. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
447. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
448. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5771
       AND ps.stockroom_id = s.stockroom_id
449. 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'
450. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5771
451. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5771
       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
452. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
453. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
454. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
455. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
456. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
457. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
458. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5771
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
459. 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=5772
       AND p.published = 1
       ORDER BY a.ordering ASC
460. 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=5772
       AND t.published = 1
       LIMIT 0,1
461. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
462. SELECT *
       FROM jos_menu
       WHERE id = '180'
463. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5772'
464. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5772'
       AND pc.category_id = c.category_id
465. 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='129'
       AND c.category_id = cx.category_parent_id
466. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
467. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
468. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5772'
       AND section='1'
469. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5772
470. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5772
       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
471. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
472. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
473. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
474. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
475. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
476. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
477. 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'
478. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
479. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
480. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
481. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
482. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5772
       AND ps.stockroom_id = s.stockroom_id
483. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5772
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
484. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
485. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5772
486. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5772
       AND ps.stockroom_id = s.stockroom_id
487. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
488. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5772"
       AND media_type="images" 
       AND media_name = "1432342929_35212.jpg"
489. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
490. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5772
       AND ps.stockroom_id = s.stockroom_id
491. 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'
492. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5772
493. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5772
       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
494. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
495. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
496. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
497. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
498. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
499. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
500. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
501. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5772
       AND ps.stockroom_id = s.stockroom_id
502. 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'
503. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5772
504. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5772
       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
505. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
506. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
507. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
508. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
509. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
510. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
511. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5772
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
512. 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=5773
       AND p.published = 1
       ORDER BY a.ordering ASC
513. 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=5773
       AND t.published = 1
       LIMIT 0,1
514. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
515. SELECT *
       FROM jos_menu
       WHERE id = '180'
516. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5773'
517. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5773'
       AND pc.category_id = c.category_id
518. 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='129'
       AND c.category_id = cx.category_parent_id
519. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
520. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
521. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5773'
       AND section='1'
522. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5773
523. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5773
       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
524. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
525. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
526. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5773
527. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
528. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5773
529. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
530. 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'
531. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5773
532. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
533. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5773
534. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
535. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5773
       AND ps.stockroom_id = s.stockroom_id
536. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5773
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
537. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5773
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
538. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5773
539. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5773
       AND ps.stockroom_id = s.stockroom_id
540. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
541. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5773"
       AND media_type="images" 
       AND media_name = "1432342950_35213.jpg"
542. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
543. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5773
       AND ps.stockroom_id = s.stockroom_id
544. 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'
545. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5773
546. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5773
       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
547. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
548. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
549. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5773
550. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
551. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5773
552. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
553. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5773
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
554. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5773
       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 = 5773
557. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5773
       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 <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
560. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5773
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 = 5773
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 = 5773
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
565. 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=5774
       AND p.published = 1
       ORDER BY a.ordering ASC
566. 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=5774
       AND t.published = 1
       LIMIT 0,1
567. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
568. SELECT *
       FROM jos_menu
       WHERE id = '180'
569. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5774'
570. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5774'
       AND pc.category_id = c.category_id
571. 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='129'
       AND c.category_id = cx.category_parent_id
572. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
573. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
574. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5774'
       AND section='1'
575. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5774
576. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5774
       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
577. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
578. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
579. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
580. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
581. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
582. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
583. 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'
584. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
585. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
586. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
587. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
588. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5774
       AND ps.stockroom_id = s.stockroom_id
589. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5774
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
590. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
591. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5774
592. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5774
       AND ps.stockroom_id = s.stockroom_id
593. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
594. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5774"
       AND media_type="images" 
       AND media_name = "1432342977_35214.jpg"
595. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
596. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5774
       AND ps.stockroom_id = s.stockroom_id
597. 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'
598. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5774
599. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5774
       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
600. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
601. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
602. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
603. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
604. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
605. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
606. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
607. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5774
       AND ps.stockroom_id = s.stockroom_id
608. 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'
609. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5774
610. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5774
       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
611. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
612. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
613. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
614. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
615. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
616. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
617. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5774
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
618. 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=5775
       AND p.published = 1
       ORDER BY a.ordering ASC
619. 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=5775
       AND t.published = 1
       LIMIT 0,1
620. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
621. SELECT *
       FROM jos_menu
       WHERE id = '180'
622. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5775'
623. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5775'
       AND pc.category_id = c.category_id
624. 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='129'
       AND c.category_id = cx.category_parent_id
625. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
626. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
627. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5775'
       AND section='1'
628. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5775
629. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5775
       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
630. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
631. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
632. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
633. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
634. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
635. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
636. 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'
637. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
638. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
639. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
640. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
641. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5775
       AND ps.stockroom_id = s.stockroom_id
642. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5775
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
643. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
644. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5775
645. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5775
       AND ps.stockroom_id = s.stockroom_id
646. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
647. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5775"
       AND media_type="images" 
       AND media_name = "1432342998_35215.jpg"
648. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
649. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5775
       AND ps.stockroom_id = s.stockroom_id
650. 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'
651. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5775
652. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5775
       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
653. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
654. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
655. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
656. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
657. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
658. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
659. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
660. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5775
       AND ps.stockroom_id = s.stockroom_id
661. 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'
662. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5775
663. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5775
       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
664. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
665. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
666. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
667. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
668. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
669. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
670. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5775
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
671. 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=5776
       AND p.published = 1
       ORDER BY a.ordering ASC
672. 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=5776
       AND t.published = 1
       LIMIT 0,1
673. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
674. SELECT *
       FROM jos_menu
       WHERE id = '180'
675. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5776'
676. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5776'
       AND pc.category_id = c.category_id
677. 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='129'
       AND c.category_id = cx.category_parent_id
678. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
679. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
680. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5776'
       AND section='1'
681. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5776
682. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5776
       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
683. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
684. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
685. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
686. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
687. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
688. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
689. 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'
690. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
691. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
692. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
693. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
694. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5776
       AND ps.stockroom_id = s.stockroom_id
695. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5776
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
696. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
697. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5776
698. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5776
       AND ps.stockroom_id = s.stockroom_id
699. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
700. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5776"
       AND media_type="images" 
       AND media_name = "1432343019_35216.jpg"
701. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
702. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5776
       AND ps.stockroom_id = s.stockroom_id
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 p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5776
705. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5776
       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
706. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
707. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
708. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
709. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
710. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
711. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
712. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
713. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5776
       AND ps.stockroom_id = s.stockroom_id
714. 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'
715. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5776
716. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5776
       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
717. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
718. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
719. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
720. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
721. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
722. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
723. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5776
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
724. 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=5777
       AND p.published = 1
       ORDER BY a.ordering ASC
725. 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=5777
       AND t.published = 1
       LIMIT 0,1
726. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
727. SELECT *
       FROM jos_menu
       WHERE id = '180'
728. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5777'
729. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5777'
       AND pc.category_id = c.category_id
730. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='129'
       AND c.category_id = cx.category_parent_id
731. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
732. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
733. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5777'
       AND section='1'
734. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5777
735. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5777
       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
736. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
737. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
738. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
739. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
740. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
741. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
742. 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'
743. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
744. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
745. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
746. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
747. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5777
       AND ps.stockroom_id = s.stockroom_id
748. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5777
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
749. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
750. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5777
751. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5777
       AND ps.stockroom_id = s.stockroom_id
752. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
753. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5777"
       AND media_type="images" 
       AND media_name = "1432343038_35217.jpg"
754. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
755. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5777
       AND ps.stockroom_id = s.stockroom_id
756. 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'
757. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5777
758. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5777
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
759. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
760. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
761. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
762. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
763. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
764. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
765. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
766. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5777
       AND ps.stockroom_id = s.stockroom_id
767. 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'
768. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5777
769. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5777
       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
770. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
771. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
772. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
773. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
774. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
775. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
776. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5777
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
777. 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=5778
       AND p.published = 1
       ORDER BY a.ordering ASC
778. 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=5778
       AND t.published = 1
       LIMIT 0,1
779. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
780. SELECT *
       FROM jos_menu
       WHERE id = '180'
781. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5778'
782. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5778'
       AND pc.category_id = c.category_id
783. 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='129'
       AND c.category_id = cx.category_parent_id
784. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
785. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
786. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5778'
       AND section='1'
787. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5778
788. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5778
       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
789. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
790. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
791. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
792. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
793. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
794. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
795. SELECT 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'
796. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
797. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
798. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
799. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
800. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5778
       AND ps.stockroom_id = s.stockroom_id
801. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5778
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
802. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
803. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5778
804. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5778
       AND ps.stockroom_id = s.stockroom_id
805. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
806. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5778"
       AND media_type="images" 
       AND media_name = "1432343378_35218.jpg"
807. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
808. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5778
       AND ps.stockroom_id = s.stockroom_id
809. 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'
810. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5778
811. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5778
       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
812. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
813. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
814. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
815. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
816. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
817. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
818. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
819. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5778
       AND ps.stockroom_id = s.stockroom_id
820. 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'
821. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5778
822. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5778
       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
823. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
824. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
825. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
826. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
827. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
828. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
829. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5778
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
830. 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=5779
       AND p.published = 1
       ORDER BY a.ordering ASC
831. 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=5779
       AND t.published = 1
       LIMIT 0,1
832. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
833. SELECT *
       FROM jos_menu
       WHERE id = '180'
834. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5779'
835. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5779'
       AND pc.category_id = c.category_id
836. 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='129'
       AND c.category_id = cx.category_parent_id
837. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
838. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
839. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5779'
       AND section='1'
840. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5779
841. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5779
       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
842. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
843. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
844. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
845. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
846. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
847. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
848. 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'
849. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
850. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
851. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
852. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
853. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5779
       AND ps.stockroom_id = s.stockroom_id
854. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5779
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
855. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
856. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5779
857. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5779
       AND ps.stockroom_id = s.stockroom_id
858. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
859. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5779"
       AND media_type="images" 
       AND media_name = "1432343396_35219.jpg"
860. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
861. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5779
       AND ps.stockroom_id = s.stockroom_id
862. 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'
863. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5779
864. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5779
       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
865. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
866. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
867. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
868. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
869. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
870. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
871. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
872. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5779
       AND ps.stockroom_id = s.stockroom_id
873. 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'
874. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5779
875. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5779
       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
876. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
877. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
878. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
879. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
880. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
881. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
882. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5779
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
883. 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=5780
       AND p.published = 1
       ORDER BY a.ordering ASC
884. 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=5780
       AND t.published = 1
       LIMIT 0,1
885. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
886. SELECT *
       FROM jos_menu
       WHERE id = '180'
887. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5780'
888. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5780'
       AND pc.category_id = c.category_id
889. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='129'
       AND c.category_id = cx.category_parent_id
890. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
891. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
892. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5780'
       AND section='1'
893. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5780
894. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5780
       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
895. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
896. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
897. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
898. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
899. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
900. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
901. 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'
902. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
903. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
904. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
905. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
906. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5780
       AND ps.stockroom_id = s.stockroom_id
907. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5780
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
908. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
909. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5780
910. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5780
       AND ps.stockroom_id = s.stockroom_id
911. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
912. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5780"
       AND media_type="images" 
       AND media_name = "1432343414_35220.jpg"
913. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
914. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5780
       AND ps.stockroom_id = s.stockroom_id
915. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
916. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5780
917. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5780
       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
918. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
919. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
920. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
921. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
922. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
923. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
924. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
925. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5780
       AND ps.stockroom_id = s.stockroom_id
926. 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'
927. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5780
928. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5780
       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
929. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
930. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
931. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
932. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
933. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
934. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
935. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5780
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
936. 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=5781
       AND p.published = 1
       ORDER BY a.ordering ASC
937. 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=5781
       AND t.published = 1
       LIMIT 0,1
938. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
939. SELECT *
       FROM jos_menu
       WHERE id = '180'
940. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5781'
941. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5781'
       AND pc.category_id = c.category_id
942. 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='129'
       AND c.category_id = cx.category_parent_id
943. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
944. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
945. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5781'
       AND section='1'
946. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5781
947. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5781
       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
948. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
949. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
950. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
951. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
952. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
953. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
954. 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'
955. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
956. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
957. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
958. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
959. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5781
       AND ps.stockroom_id = s.stockroom_id
960. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5781
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
961. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
962. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 5781
963. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5781
       AND ps.stockroom_id = s.stockroom_id
964. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
965. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="5781"
       AND media_type="images" 
       AND media_name = "1432343436_35221.jpg"
966. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
967. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5781
       AND ps.stockroom_id = s.stockroom_id
968. 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'
969. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5781
970. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5781
       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
971. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
972. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
973. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
974. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
975. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
976. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
977. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
978. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 5781
       AND ps.stockroom_id = s.stockroom_id
979. 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'
980. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5781
981. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 5781
       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
982. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
983. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1747085483'
       AND end_date >= '1747085483' 
       ORDER BY amount DESC
       LIMIT 0,1
984. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
985. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
986. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
987. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
988. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 5781
       AND discount_enddate>='1747085483'
       AND discount_stratdate<='1747085483'
989. 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=5782
       AND p.published = 1
       ORDER BY a.ordering ASC
990. 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=5782
       AND t.published = 1
       LIMIT 0,1
991. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
992. SELECT *
       FROM jos_menu
       WHERE id = '180'
993. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '5782'
994. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '5782'
       AND pc.category_id = c.category_id
995. 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='129'
       AND c.category_id = cx.category_parent_id
996. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '129'
997. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
998. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='5782'
       AND section='1'
999. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 5782
1000. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 5782
        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
1001. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1002. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1747085483'
        AND end_date >= '1747085483' 
        ORDER BY amount DESC
        LIMIT 0,1
1003. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
1004. SELECT sg.*
       
        FROM jos_redshop_shopper_group AS sg
       
        LEFT JOIN jos_redshop_users_info AS ui
        ON ui.shopper_group_id = sg.shopper_group_id
        WHERE ui.user_id = '0'
        LIMIT 0,1
1005. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
1006. SELECT tr.*
        FROM jos_redshop_tax_rate AS tr
        WHERE tr.tax_group_id = 1
        AND tr.tax_country="CAN"
        AND tr.tax_state = "ON"  
        ORDER BY `tax_rate` DESC
1007. 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'
1008. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
1009. SELECT sg.*
       
        FROM jos_redshop_shopper_group AS sg
       
        LEFT JOIN jos_redshop_users_info AS ui
        ON ui.shopper_group_id = sg.shopper_group_id
        WHERE ui.user_id = '0'
        LIMIT 0,1
1010. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
1011. SELECT tr.*
        FROM jos_redshop_tax_rate AS tr
        WHERE tr.tax_group_id = 1
        AND tr.tax_country="CAN"
        AND tr.tax_state = "ON"  
        ORDER BY `tax_rate` DESC
1012. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 5782
        AND ps.stockroom_id = s.stockroom_id
1013. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 5782
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1014. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
        AND discount_enddate>='1747085483'
        AND discount_stratdate<='1747085483'
1015. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 5782
1016. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 5782
        AND ps.stockroom_id = s.stockroom_id
1017. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1018. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="5782"
        AND media_type="images" 
        AND media_name = "1432343469_35223.jpg"
1019. SELECT *
        FROM jos_redshop_template
        WHERE template_section LIKE 'add_to_cart'
        AND published=1
1020. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 5782
        AND ps.stockroom_id = s.stockroom_id
1021. 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'
1022. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 5782
1023. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 5782
        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
1024. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1025. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1747085483'
        AND end_date >= '1747085483' 
        ORDER BY amount DESC
        LIMIT 0,1
1026. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
1027. SELECT sg.*
       
        FROM jos_redshop_shopper_group AS sg
       
        LEFT JOIN jos_redshop_users_info AS ui
        ON ui.shopper_group_id = sg.shopper_group_id
        WHERE ui.user_id = '0'
        LIMIT 0,1
1028. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
1029. SELECT tr.*
        FROM jos_redshop_tax_rate AS tr
        WHERE tr.tax_group_id = 1
        AND tr.tax_country="CAN"
        AND tr.tax_state = "ON"  
        ORDER BY `tax_rate` DESC
1030. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
        AND discount_enddate>='1747085483'
        AND discount_stratdate<='1747085483'
1031. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 5782
        AND ps.stockroom_id = s.stockroom_id
1032. 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'
1033. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 5782
1034. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 5782
        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
1035. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1036. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1747085483'
        AND end_date >= '1747085483' 
        ORDER BY amount DESC
        LIMIT 0,1
1037. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
1038. SELECT sg.*
       
        FROM jos_redshop_shopper_group AS sg
       
        LEFT JOIN jos_redshop_users_info AS ui
        ON ui.shopper_group_id = sg.shopper_group_id
        WHERE ui.user_id = '0'
        LIMIT 0,1
1039. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
1040. SELECT tr.*
        FROM jos_redshop_tax_rate AS tr
        WHERE tr.tax_group_id = 1
        AND tr.tax_country="CAN"
        AND tr.tax_state = "ON"  
        ORDER BY `tax_rate` DESC
1041. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5782
        AND discount_enddate>='1747085483'
        AND discount_stratdate<='1747085483'
1042. 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=5783
        AND p.published = 1
        ORDER BY a.ordering ASC
1043. 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=5783
        AND t.published = 1
        LIMIT 0,1
1044. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='12'
        AND field_name=''
        AND published=1
        AND field_show_in_front=1
1045. SELECT *
        FROM jos_menu
        WHERE id = '180'
1046. SELECT sef_url,product_name,cat_in_sefurl
        FROM jos_redshop_product
        WHERE product_id = '5783'
1047. SELECT c.category_id
        FROM jos_redshop_category c,jos_redshop_product_category_xref pc
        WHERE pc.product_id = '5783'
        AND pc.category_id = c.category_id
1048. 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='129'
        AND c.category_id = cx.category_parent_id
1049. SELECT category_name
        FROM jos_redshop_category
        WHERE category_id = '129'
1050. SELECT *
        FROM jos_redshop_fields
        WHERE field_section='1'
        AND published=1
1051. SELECT *
        FROM jos_redshop_fields_data
        WHERE fieldid='1'
        AND itemid='5783'
        AND section='1'
1052. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 5783
1053. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 5783
        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
1054. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1055. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1747085483'
        AND end_date >= '1747085483' 
        ORDER BY amount DESC
        LIMIT 0,1
1056. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
1057. SELECT sg.*
       
        FROM jos_redshop_shopper_group AS sg
       
        LEFT JOIN jos_redshop_users_info AS ui
        ON ui.shopper_group_id = sg.shopper_group_id
        WHERE ui.user_id = '0'
        LIMIT 0,1
1058. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
1059. SELECT tr.*
        FROM jos_redshop_tax_rate AS tr
        WHERE tr.tax_group_id = 1
        AND tr.tax_country="CAN"
        AND tr.tax_state = "ON"  
        ORDER BY `tax_rate` DESC
1060. 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'
1061. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
1062. SELECT sg.*
       
        FROM jos_redshop_shopper_group AS sg
       
        LEFT JOIN jos_redshop_users_info AS ui
        ON ui.shopper_group_id = sg.shopper_group_id
        WHERE ui.user_id = '0'
        LIMIT 0,1
1063. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
1064. SELECT tr.*
        FROM jos_redshop_tax_rate AS tr
        WHERE tr.tax_group_id = 1
        AND tr.tax_country="CAN"
        AND tr.tax_state = "ON"  
        ORDER BY `tax_rate` DESC
1065. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 5783
        AND ps.stockroom_id = s.stockroom_id
1066. SELECT p.* 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 5783
        AND p.shopper_group_id = '0' 
        ORDER BY price_quantity_start ASC
1067. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
        AND discount_enddate>='1747085483'
        AND discount_stratdate<='1747085483'
1068. SELECT * 
        FROM jos_redshop_product AS p 
        WHERE  p.product_id = 5783
1069. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 5783
        AND ps.stockroom_id = s.stockroom_id
1070. SELECT * 
        FROM jos_modules
        WHERE `module` LIKE 'mod_redmagicmagnifyplus'
        AND published  = 1
1071. SELECT *
        FROM jos_redshop_media 
        WHERE media_section = "product"
        AND section_id ="5783"
        AND media_type="images" 
        AND media_name = "1432343487_35224.jpg"
1072. SELECT *
        FROM jos_redshop_template
        WHERE template_section LIKE 'add_to_cart'
        AND published=1
1073. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 5783
        AND ps.stockroom_id = s.stockroom_id
1074. 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'
1075. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 5783
1076. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 5783
        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
1077. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1078. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1747085483'
        AND end_date >= '1747085483' 
        ORDER BY amount DESC
        LIMIT 0,1
1079. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
1080. SELECT sg.*
       
        FROM jos_redshop_shopper_group AS sg
       
        LEFT JOIN jos_redshop_users_info AS ui
        ON ui.shopper_group_id = sg.shopper_group_id
        WHERE ui.user_id = '0'
        LIMIT 0,1
1081. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
1082. SELECT tr.*
        FROM jos_redshop_tax_rate AS tr
        WHERE tr.tax_group_id = 1
        AND tr.tax_country="CAN"
        AND tr.tax_state = "ON"  
        ORDER BY `tax_rate` DESC
1083. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
        AND discount_enddate>='1747085483'
        AND discount_stratdate<='1747085483'
1084. SELECT sum(quantity) AS quantity 
        FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
        WHERE  ps.product_id = 5783
        AND ps.stockroom_id = s.stockroom_id
1085. 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'
1086. SELECT p.* 
        FROM jos_redshop_product AS p   
        WHERE  p.product_id = 5783
1087. SELECT p.price_id,p.product_price,p.product_currency 
        FROM jos_redshop_product_price AS p 
        WHERE  p.product_id = 5783
        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
1088. SELECT *
        FROM jos_redshop_discount_product_shoppers AS ps
        WHERE ps.shopper_group_id ='0'
1089. SELECT *
        FROM jos_redshop_discount_product 
        WHERE amount <= 0
        AND discount_product_id IN (0) 
        AND published =1
        AND start_date <= '1747085483'
        AND end_date >= '1747085483' 
        ORDER BY amount DESC
        LIMIT 0,1
1090. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
1091. SELECT sg.*
       
        FROM jos_redshop_shopper_group AS sg
       
        LEFT JOIN jos_redshop_users_info AS ui
        ON ui.shopper_group_id = sg.shopper_group_id
        WHERE ui.user_id = '0'
        LIMIT 0,1
1092. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
1093. SELECT tr.*
        FROM jos_redshop_tax_rate AS tr
        WHERE tr.tax_group_id = 1
        AND tr.tax_country="CAN"
        AND tr.tax_state = "ON"  
        ORDER BY `tax_rate` DESC
1094. SELECT *
        FROM jos_redshop_product
        WHERE product_id = 5783
        AND discount_enddate>='1747085483'
        AND discount_stratdate<='1747085483'
1095. SELECT *
        FROM jos_redshop_category
        WHERE category_id = 129
1096. SELECT *
        FROM jos_menu
        WHERE link LIKE '%com_redshop%'
        AND published=1
        AND id = '180'
1097. SELECT *
        FROM jos_menu
        WHERE link LIKE '%com_redshop%'
        AND published=1 
        AND link LIKE '%view=category%' 
        AND params NOT LIKE '%categoryid%'
1098. SELECT *
        FROM jos_menu
        WHERE link LIKE '%com_redshop%'
        AND published=1 
        AND link LIKE '%view=category%' 
        AND params  LIKE '%categoryid=129
      %'
1099. SELECT category_parent_id
        FROM jos_redshop_category_xref
        WHERE category_child_id=129
1100. SELECT *
        FROM jos_menu
        WHERE id = '180'
1101. SELECT *
        FROM jos_menu
        WHERE id = '180'
1102. SELECT *
        FROM jos_menu
        WHERE id = '180'
1103. SELECT *
        FROM jos_menu
        WHERE id = '180'
1104. SELECT *
        FROM jos_menu
        WHERE id = '180'
1105. SELECT *
        FROM jos_menu
        WHERE id = '180'
1106. 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 = 180 OR mm.menuid = 0 )
        ORDER BY position, ordering
1107. SELECT *
        FROM jos_menu
        WHERE id = '71'
1108. SELECT *
        FROM jos_menu
        WHERE id = '222'
1109. SELECT category_id      
        FROM jos_redshop_product_category_xref cx
        WHERE product_id = ''
1110. 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'
1111. SELECT category_id AS value,category_name AS text
        FROM jos_redshop_category
        WHERE published = 1
1112. SELECT *
        FROM jos_menu
        WHERE id = '180'