Daniel Hechter II Collection

Profile Information

Memory Usage

616 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'ucut60udb2912spl7bita0npi0'
2. DELETE
     FROM jos_session
     WHERE ( time < '1746947596' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'ucut60udb2912spl7bita0npi0'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'ucut60udb2912spl7bita0npi0','1746954796','','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-11'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'ucut60udb2912spl7bita0npi0'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('ucut60udb2912spl7bita0npi0', '0','1746954799')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'ucut60udb2912spl7bita0npi0'
      AND section='product'
      AND section_id='590'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('ucut60udb2912spl7bita0npi0','0','product','590','1746954801')
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 = 145)
      ORDER BY menuid DESC
      LIMIT 0, 1
18. SELECT id
      FROM `jos_components`
      WHERE `link` LIKE '%com_reddesign%'
19. SELECT p.*, c.category_id, c.category_name, m.manufacturer_name ,s.supplier_name 
      FROM (jos_redshop_category AS c ,jos_redshop_product AS p , jos_redshop_product_category_xref AS pcr ) 
      LEFT JOIN jos_redshop_manufacturer AS m
      ON m.manufacturer_id = p.manufacturer_id 
      LEFT JOIN jos_redshop_supplier AS s
      ON s.supplier_id = p.supplier_id   
      WHERE p.product_id=590
      AND pcr.product_id=590
      AND pcr.category_id=c.category_id 
      AND p.published = 1
20. SELECT  min_del_time AS deltime, s.max_del_time, s.delivery_time 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 590
      AND ps.stockroom_id = s.stockroom_id
      AND ps.quantity >0
      ORDER BY min_del_time ASC
      LIMIT 0,1
21. 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=590
      AND t.published = 1
      LIMIT 0,1
22. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
23. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 590
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
24. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
25. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746954801'
      AND end_date >= '1746954801' 
      ORDER BY amount DESC
      LIMIT 0,1
26. SELECT *
      FROM jos_menu
      WHERE id = '145'
27. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '590'
28. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '590'
      AND pc.category_id = c.category_id 
      AND c.category_id = '71'
29. 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='71'
      AND c.category_id = cx.category_parent_id
30. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '71'
31. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1 
      AND field_name IN ('product_desc','product_thumb_image','more_images','product_s_desc','manufacturer_link','related_product:Related Products')
32. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 13
33. SELECT *
      FROM jos_menu
      WHERE id = '145'
34. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '13'
35. SELECT product_id AS value,product_name AS text
                                           
      FROM `jos_redshop_product`
                                           
      WHERE `product_parent_id` =590
36. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 590
      AND ps.stockroom_id = s.stockroom_id
37. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 590
38. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 590
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
39. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
40. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746954802'
      AND end_date >= '1746954802' 
      ORDER BY amount DESC
      LIMIT 0,1
41. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
42. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
43. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
44. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
45. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
46. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
47. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
48. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
49. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
50. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 590
      AND ps.stockroom_id = s.stockroom_id
51. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 590
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
52. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
      AND discount_enddate>='1746954802'
      AND discount_stratdate<='1746954802'
53. SELECT *
      FROM jos_redshop_media AS m
      LEFT JOIN jos_redshop_product AS p
      ON p.product_id = m.section_id
      WHERE m.media_section = 'product'
      AND media_type='images'
      AND m.section_id=590
      AND m.published = 1
54. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="590"
      AND media_type="images" 
      AND media_id="3437"
55. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="590"
      AND media_type="images" 
      AND media_id="3436"
56. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="590"
      AND media_type="images" 
      AND media_id="3435"
57. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="590"
      AND media_type="images" 
      AND media_id="3434"
58. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="590"
      AND media_type="images" 
      AND media_id="3433"
59. SELECT *
      FROM jos_redshop_wrapper
      WHERE published = 1
      AND (FIND_IN_SET(590,product_id)  OR wrapper_use_to_all = 1  )
60. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'wrapper_template'
      AND published=1
61. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'attribute_template'
      AND published=1
62. SELECT a.attribute_id AS value,a.attribute_name AS text,a.*
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=590
      AND p.published = 1
      ORDER BY a.ordering ASC
63. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'accessory_template'
      AND published=1
64. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'review'
      AND published=1
      LIMIT 0,1
65. SELECT ui.firstname,ui.lastname,pr.*
      FROM jos_redshop_product_rating AS pr, jos_users AS u, jos_redshop_users_info AS ui
      WHERE pr.product_id=590
      AND pr.published = 1
      AND pr.userid=u.id
      AND ui.user_id=u.id
      AND ui.address_type LIKE 'BT'
      ORDER BY pr.favoured DESC
66. SELECT pr.*
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=590
      AND pr.published = 1
67. SELECT sum(user_rating) AS rating
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=590
      AND pr.published = 1
68. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
69. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 590
70. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 590
      AND ps.stockroom_id = s.stockroom_id
71. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
72. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="590"
      AND media_type="images" 
      AND media_name = "1356727156_286314.jpg"
73. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
74. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 590
      AND ps.stockroom_id = s.stockroom_id
75. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 590
76. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 590
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
77. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
78. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746954802'
      AND end_date >= '1746954802' 
      ORDER BY amount DESC
      LIMIT 0,1
79. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
80. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
81. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
82. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
83. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
      AND discount_enddate>='1746954802'
      AND discount_stratdate<='1746954802'
84. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
85. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
86. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 590
      AND ps.stockroom_id = s.stockroom_id
87. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 590
88. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 590
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
89. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
90. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746954802'
      AND end_date >= '1746954802' 
      ORDER BY amount DESC
      LIMIT 0,1
91. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
92. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
93. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
94. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
95. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 590
      AND discount_enddate>='1746954802'
      AND discount_stratdate<='1746954802'
96. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
97. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
98. UPDATE jos_redshop_product
      SET `visited` = visited + 1
      WHERE `product_id` = '590'
99. SELECT p.product_name,pcx.category_id
      FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
      WHERE p.product_id = 590
      AND p.product_id = pcx.product_id
100. 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=''
       AND c.category_id = cx.category_parent_id
101. SELECT pcx.product_id,p.product_name
       FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
       WHERE pcx.category_id=71
       AND pcx.product_id=p.product_id
       ORDER BY pcx.product_id
102. SELECT *
       FROM jos_menu
       WHERE id = '145'
103. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '591'
104. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '591'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
105. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='71'
       AND c.category_id = cx.category_parent_id
106. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
107. SELECT *
       FROM jos_menu
       WHERE id = '145'
108. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '589'
109. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '589'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
110. 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='71'
       AND c.category_id = cx.category_parent_id
111. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
112. SELECT *
       FROM jos_redshop_textlibrary
       WHERE published=1
113. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '145'
114. SELECT category_id
       FROM jos_redshop_product_category_xref
       WHERE product_id=590
115. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params NOT LIKE '%categoryid%'
116. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=71
     %'
117. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=71
118. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=product%' 
       AND params  LIKE '%productid=590
     %'
119. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 590
120. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'related_product'
       AND published=1
121. SELECT *
       FROM jos_redshop_product AS p ,jos_redshop_product_related  AS r
       WHERE r.related_id = p.product_id
       AND r.product_id=590
       AND p.published = 1
122. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
123. SELECT *
       FROM jos_menu
       WHERE id = '145'
124. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '603'
125. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '603'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
126. 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='71'
       AND c.category_id = cx.category_parent_id
127. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
128. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 603
129. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 603
       AND ps.stockroom_id = s.stockroom_id
130. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
131. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="603"
       AND media_type="images" 
       AND media_name = "1356730997_285911.jpg"
132. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 603
133. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 603
       AND p.shopper_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 <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
136. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 603
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 = 603
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 = 603
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
141. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 603
142. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 603
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
143. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
144. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
145. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 603
146. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
147. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 603
148. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
149. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
150. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 603
       AND ps.stockroom_id = s.stockroom_id
151. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 603
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
152. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 603
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
153. SELECT *
       FROM jos_menu
       WHERE id = '145'
154. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '603'
155. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '603'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
156. 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='71'
       AND c.category_id = cx.category_parent_id
157. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
158. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=603
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
159. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 603
       AND ps.stockroom_id = s.stockroom_id
160. 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=603
       AND p.published = 1
       ORDER BY a.ordering ASC
161. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
162. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 603
163. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 603
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
164. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
165. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
166. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 603
167. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
168. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 603
169. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
170. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 603
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
171. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 603
       AND ps.stockroom_id = s.stockroom_id
172. 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=603
       AND p.published = 1
       ORDER BY a.ordering ASC
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 = 603
175. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 603
       AND p.shopper_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 <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
178. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 603
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 = 603
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 = 603
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
183. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
184. SELECT *
       FROM jos_menu
       WHERE id = '145'
185. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '602'
186. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '602'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
187. 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='71'
       AND c.category_id = cx.category_parent_id
188. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
189. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 602
190. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 602
       AND ps.stockroom_id = s.stockroom_id
191. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
192. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="602"
       AND media_type="images" 
       AND media_name = "1356730932_285812.jpg"
193. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 602
194. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 602
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
195. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
196. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
197. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
198. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
199. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
200. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
201. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
202. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 602
203. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 602
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
204. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
205. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
206. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
207. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
208. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
209. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
210. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
211. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 602
       AND ps.stockroom_id = s.stockroom_id
212. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 602
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
213. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
214. SELECT *
       FROM jos_menu
       WHERE id = '145'
215. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '602'
216. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '602'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
217. 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='71'
       AND c.category_id = cx.category_parent_id
218. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
219. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=602
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
220. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 602
       AND ps.stockroom_id = s.stockroom_id
221. 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=602
       AND p.published = 1
       ORDER BY a.ordering ASC
222. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
223. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 602
224. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 602
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
225. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
226. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
227. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
228. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
229. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
230. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
231. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
232. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 602
       AND ps.stockroom_id = s.stockroom_id
233. 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=602
       AND p.published = 1
       ORDER BY a.ordering ASC
234. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
235. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 602
236. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 602
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
237. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
238. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
239. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
240. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
241. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
242. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
243. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 602
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
244. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
245. SELECT *
       FROM jos_menu
       WHERE id = '145'
246. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '588'
247. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '588'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
248. 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='71'
       AND c.category_id = cx.category_parent_id
249. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
250. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 588
251. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 588
       AND ps.stockroom_id = s.stockroom_id
252. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
253. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="588"
       AND media_type="images" 
       AND media_name = "1356724652_285850.jpg"
254. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 588
255. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 588
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
256. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
257. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
258. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
259. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
260. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
261. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
262. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
263. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 588
264. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 588
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
265. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
266. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
267. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
268. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
269. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
270. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
271. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
272. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 588
       AND ps.stockroom_id = s.stockroom_id
273. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 588
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
274. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
275. SELECT *
       FROM jos_menu
       WHERE id = '145'
276. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '588'
277. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '588'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
278. 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='71'
       AND c.category_id = cx.category_parent_id
279. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
280. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=588
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
281. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 588
       AND ps.stockroom_id = s.stockroom_id
282. 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=588
       AND p.published = 1
       ORDER BY a.ordering ASC
283. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
284. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 588
285. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 588
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
286. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
287. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
288. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
289. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
290. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
291. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
292. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
293. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 588
       AND ps.stockroom_id = s.stockroom_id
294. 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=588
       AND p.published = 1
       ORDER BY a.ordering ASC
295. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
296. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 588
297. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 588
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
298. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
299. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
300. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
301. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
302. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
303. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
304. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 588
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
305. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
306. SELECT *
       FROM jos_menu
       WHERE id = '145'
307. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '589'
308. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '589'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
309. 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='71'
       AND c.category_id = cx.category_parent_id
310. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
311. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 589
312. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 589
       AND ps.stockroom_id = s.stockroom_id
313. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
314. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="589"
       AND media_type="images" 
       AND media_name = "1356725072_285959.jpg"
315. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 589
316. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 589
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
317. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
318. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
319. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
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 = 589
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 *
       FROM jos_redshop_product
       WHERE product_id = 589
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
324. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 589
325. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 589
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
326. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
327. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
328. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
329. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
330. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
331. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 589
       AND ps.stockroom_id = s.stockroom_id
334. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 589
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
335. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
336. SELECT *
       FROM jos_menu
       WHERE id = '145'
337. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '589'
338. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '589'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
339. 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='71'
       AND c.category_id = cx.category_parent_id
340. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
341. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=589
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
342. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 589
       AND ps.stockroom_id = s.stockroom_id
343. 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=589
       AND p.published = 1
       ORDER BY a.ordering ASC
344. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
345. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 589
346. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 589
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
347. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
348. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
349. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
350. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
351. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
352. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
353. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
354. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 589
       AND ps.stockroom_id = s.stockroom_id
355. 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=589
       AND p.published = 1
       ORDER BY a.ordering ASC
356. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
357. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 589
358. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 589
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
359. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
360. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
361. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
362. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
363. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
364. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
365. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 589
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
366. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
367. SELECT *
       FROM jos_menu
       WHERE id = '145'
368. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '599'
369. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '599'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
370. 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='71'
       AND c.category_id = cx.category_parent_id
371. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
372. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 599
373. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 599
       AND ps.stockroom_id = s.stockroom_id
374. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
375. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="599"
       AND media_type="images" 
       AND media_name = "1356730058_285843.jpg"
376. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 599
377. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 599
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
378. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
379. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
380. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
381. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
382. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
383. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
384. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
385. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 599
386. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 599
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
387. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
388. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
389. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
390. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
391. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
392. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
393. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
394. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 599
       AND ps.stockroom_id = s.stockroom_id
395. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 599
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
396. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
397. SELECT *
       FROM jos_menu
       WHERE id = '145'
398. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '599'
399. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '599'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
400. 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='71'
       AND c.category_id = cx.category_parent_id
401. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
402. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=599
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
403. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 599
       AND ps.stockroom_id = s.stockroom_id
404. 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=599
       AND p.published = 1
       ORDER BY a.ordering ASC
405. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
406. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 599
407. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 599
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
408. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
409. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
410. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
411. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
412. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
413. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
414. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
415. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 599
       AND ps.stockroom_id = s.stockroom_id
416. 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=599
       AND p.published = 1
       ORDER BY a.ordering ASC
417. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
418. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 599
419. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 599
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
420. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
421. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
422. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
423. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
424. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
425. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
426. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 599
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
427. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
428. SELECT *
       FROM jos_menu
       WHERE id = '145'
429. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '598'
430. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '598'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
431. 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='71'
       AND c.category_id = cx.category_parent_id
432. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
433. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 598
434. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 598
       AND ps.stockroom_id = s.stockroom_id
435. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
436. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="598"
       AND media_type="images" 
       AND media_name = "1356729981_285942.jpg"
437. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 598
438. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 598
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
439. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
440. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
441. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
442. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
443. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
444. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
445. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
446. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 598
447. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 598
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
448. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
449. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
450. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
451. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
452. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
453. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
454. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
455. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 598
       AND ps.stockroom_id = s.stockroom_id
456. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 598
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
457. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
458. SELECT *
       FROM jos_menu
       WHERE id = '145'
459. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '598'
460. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '598'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
461. 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='71'
       AND c.category_id = cx.category_parent_id
462. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
463. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=598
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
464. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 598
       AND ps.stockroom_id = s.stockroom_id
465. 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=598
       AND p.published = 1
       ORDER BY a.ordering ASC
466. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
467. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 598
468. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 598
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
469. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
470. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
471. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
472. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
473. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
474. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
475. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
476. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 598
       AND ps.stockroom_id = s.stockroom_id
477. 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=598
       AND p.published = 1
       ORDER BY a.ordering ASC
478. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
479. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 598
480. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 598
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
481. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
482. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
483. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
484. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
485. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
486. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
487. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 598
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
488. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
489. SELECT *
       FROM jos_menu
       WHERE id = '145'
490. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '606'
491. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '606'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
492. 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='71'
       AND c.category_id = cx.category_parent_id
493. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
494. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 606
495. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 606
       AND ps.stockroom_id = s.stockroom_id
496. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
497. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="606"
       AND media_type="images" 
       AND media_name = "1356731522_285935.jpg"
498. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 606
499. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 606
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
500. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
501. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
502. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
503. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
504. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
505. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
506. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
507. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 606
508. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 606
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
509. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
510. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
511. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
512. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
513. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
514. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
515. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
516. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 606
       AND ps.stockroom_id = s.stockroom_id
517. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 606
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
518. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
519. SELECT *
       FROM jos_menu
       WHERE id = '145'
520. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '606'
521. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '606'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
522. 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='71'
       AND c.category_id = cx.category_parent_id
523. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
524. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=606
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
525. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 606
       AND ps.stockroom_id = s.stockroom_id
526. 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=606
       AND p.published = 1
       ORDER BY a.ordering ASC
527. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
528. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 606
529. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 606
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
530. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
531. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
532. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
533. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
534. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
535. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
536. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
537. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 606
       AND ps.stockroom_id = s.stockroom_id
538. 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=606
       AND p.published = 1
       ORDER BY a.ordering ASC
539. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
540. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 606
541. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 606
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
542. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
543. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
544. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
545. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
546. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
547. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
548. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 606
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
549. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
550. SELECT *
       FROM jos_menu
       WHERE id = '145'
551. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '604'
552. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '604'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
553. 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='71'
       AND c.category_id = cx.category_parent_id
554. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
555. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 604
556. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 604
       AND ps.stockroom_id = s.stockroom_id
557. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
558. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="604"
       AND media_type="images" 
       AND media_name = "1356731356_285836.jpg"
559. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 604
560. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 604
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
561. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
562. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
563. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
564. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
565. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
566. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
567. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
568. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 604
569. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 604
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
570. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
571. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
572. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
573. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
574. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
575. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
576. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
577. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 604
       AND ps.stockroom_id = s.stockroom_id
578. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 604
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
579. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
580. SELECT *
       FROM jos_menu
       WHERE id = '145'
581. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '604'
582. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '604'
       AND pc.category_id = c.category_id 
       AND c.category_id = '71'
583. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='71'
       AND c.category_id = cx.category_parent_id
584. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
585. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=604
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
586. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 604
       AND ps.stockroom_id = s.stockroom_id
587. 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=604
       AND p.published = 1
       ORDER BY a.ordering ASC
588. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
589. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 604
590. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 604
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
591. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
592. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
593. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
594. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
595. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
596. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
597. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
598. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 604
       AND ps.stockroom_id = s.stockroom_id
599. 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=604
       AND p.published = 1
       ORDER BY a.ordering ASC
600. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
601. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 604
602. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 604
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
603. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
604. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746954802'
       AND end_date >= '1746954802' 
       ORDER BY amount DESC
       LIMIT 0,1
605. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
606. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
607. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
608. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
609. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 604
       AND discount_enddate>='1746954802'
       AND discount_stratdate<='1746954802'
610. 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 = 145 OR mm.menuid = 0 )
       ORDER BY position, ordering
611. SELECT *
       FROM jos_menu
       WHERE id = '71'
612. SELECT *
       FROM jos_menu
       WHERE id = '222'
613. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
614. 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'
615. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
616. SELECT *
       FROM jos_menu
       WHERE id = '145'