Bestsellers Vol.2 Collection

Profile Information

Memory Usage

986 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '805t1a0u0n85i8uttoma873vo4'
2. DELETE
     FROM jos_session
     WHERE ( time < '1743451604' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '805t1a0u0n85i8uttoma873vo4'
4. UPDATE `jos_session`
     SET `time`='1743458804',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1743458778;s:18:\"session.timer.last\";i:1743458799;s:17:\"session.timer.now\";i:1743458801;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:65:\"/home/ontwall/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:7:\"visited\";a:2:{i:0;s:2:\"64\";i:1;s:2:\"85\";}}'
     WHERE session_id='805t1a0u0n85i8uttoma873vo4'
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-03-31'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '805t1a0u0n85i8uttoma873vo4'
13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '805t1a0u0n85i8uttoma873vo4'
      AND section='category'
      AND section_id='176'
14. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
15. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 238)
      ORDER BY menuid DESC
      LIMIT 0, 1
16. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=176
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
17. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=176
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
18. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=176
      AND published = 1
      ORDER BY c.category_name ASC
19. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '176'
20. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=176%')
      ORDER BY 'ordering'
21. SELECT *
      FROM jos_menu
      WHERE id = '238'
22. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '176'
23. 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='176'
      AND c.category_id = cx.category_parent_id
24. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=176
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 40, 200
25. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=176
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
26. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=176
      AND published = 1
      ORDER BY c.category_name ASC
27. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '176'
28. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=176%')
      ORDER BY 'ordering'
29. SELECT *
      FROM jos_menu
      WHERE id = '238'
30. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '176'
31. 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='176'
      AND c.category_id = cx.category_parent_id
32. 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=8719
      AND p.published = 1
      ORDER BY a.ordering ASC
33. 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=8719
      AND t.published = 1
      LIMIT 0,1
34. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
35. SELECT *
      FROM jos_menu
      WHERE id = '238'
36. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '8719'
37. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '8719'
      AND pc.category_id = c.category_id
38. 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='176'
      AND c.category_id = cx.category_parent_id
39. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '176'
40. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
41. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='8719'
      AND section='1'
42. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 8719
43. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 8719
      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
44. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
45. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743458804'
      AND end_date >= '1743458804' 
      ORDER BY amount DESC
      LIMIT 0,1
46. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
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 = 8719
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 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'
51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
52. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
53. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
54. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
55. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 8719
      AND ps.stockroom_id = s.stockroom_id
56. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 8719
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
57. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
      AND discount_enddate>='1743458804'
      AND discount_stratdate<='1743458804'
58. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 8719
59. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 8719
      AND ps.stockroom_id = s.stockroom_id
60. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
61. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="8719"
      AND media_type="images" 
      AND media_name = "1536689345_6309-11.jpg"
62. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
63. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 8719
      AND ps.stockroom_id = s.stockroom_id
64. 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'
65. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 8719
66. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 8719
      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
67. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
68. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743458804'
      AND end_date >= '1743458804' 
      ORDER BY amount DESC
      LIMIT 0,1
69. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
70. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
71. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
72. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
73. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
      AND discount_enddate>='1743458804'
      AND discount_stratdate<='1743458804'
74. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 8719
      AND ps.stockroom_id = s.stockroom_id
75. 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'
76. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 8719
77. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 8719
      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
78. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
79. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743458804'
      AND end_date >= '1743458804' 
      ORDER BY amount DESC
      LIMIT 0,1
80. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
81. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
82. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
83. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
84. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8719
      AND discount_enddate>='1743458804'
      AND discount_stratdate<='1743458804'
85. 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=8720
      AND p.published = 1
      ORDER BY a.ordering ASC
86. 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=8720
      AND t.published = 1
      LIMIT 0,1
87. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
88. SELECT *
      FROM jos_menu
      WHERE id = '238'
89. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '8720'
90. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '8720'
      AND pc.category_id = c.category_id
91. 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='176'
      AND c.category_id = cx.category_parent_id
92. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '176'
93. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
94. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='8720'
      AND section='1'
95. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 8720
96. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 8720
      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
97. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
98. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1743458804'
      AND end_date >= '1743458804' 
      ORDER BY amount DESC
      LIMIT 0,1
99. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 8720
100. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
101. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
102. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
103. 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'
104. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
105. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
106. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
107. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
108. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8720
       AND ps.stockroom_id = s.stockroom_id
109. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8720
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
110. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
111. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8720
112. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8720
       AND ps.stockroom_id = s.stockroom_id
113. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
114. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8720"
       AND media_type="images" 
       AND media_name = "1536689440_6309-36.jpg"
115. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
116. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8720
       AND ps.stockroom_id = s.stockroom_id
117. 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'
118. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8720
119. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8720
       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
120. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
121. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
122. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
123. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
124. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
125. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
126. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
127. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8720
       AND ps.stockroom_id = s.stockroom_id
128. 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'
129. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8720
130. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8720
       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
131. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
132. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
133. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
134. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
135. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
136. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
137. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8720
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
138. 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=8721
       AND p.published = 1
       ORDER BY a.ordering ASC
139. 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=8721
       AND t.published = 1
       LIMIT 0,1
140. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
141. SELECT *
       FROM jos_menu
       WHERE id = '238'
142. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8721'
143. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8721'
       AND pc.category_id = c.category_id
144. 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='176'
       AND c.category_id = cx.category_parent_id
145. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
146. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
147. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8721'
       AND section='1'
148. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8721
149. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8721
       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
150. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
151. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
152. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
153. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
154. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
155. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
156. 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'
157. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
158. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
159. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
160. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
161. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8721
       AND ps.stockroom_id = s.stockroom_id
162. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8721
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
163. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
164. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8721
165. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8721
       AND ps.stockroom_id = s.stockroom_id
166. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
167. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8721"
       AND media_type="images" 
       AND media_name = "1536689507_6310-07.jpg"
168. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
169. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8721
       AND ps.stockroom_id = s.stockroom_id
170. 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'
171. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8721
172. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8721
       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
173. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
174. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
175. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
176. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
177. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
178. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
179. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
180. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8721
       AND ps.stockroom_id = s.stockroom_id
181. 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'
182. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8721
183. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8721
       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
184. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
185. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
186. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
187. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
188. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
189. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
190. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8721
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
191. 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=8722
       AND p.published = 1
       ORDER BY a.ordering ASC
192. 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=8722
       AND t.published = 1
       LIMIT 0,1
193. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
194. SELECT *
       FROM jos_menu
       WHERE id = '238'
195. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8722'
196. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8722'
       AND pc.category_id = c.category_id
197. 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='176'
       AND c.category_id = cx.category_parent_id
198. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
199. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
200. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8722'
       AND section='1'
201. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8722
202. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8722
       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
203. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
204. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
205. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8722
206. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
207. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8722
208. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
209. 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'
210. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8722
211. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
212. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8722
213. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
214. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8722
       AND ps.stockroom_id = s.stockroom_id
215. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8722
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
216. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8722
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
217. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8722
218. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8722
       AND ps.stockroom_id = s.stockroom_id
219. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
220. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8722"
       AND media_type="images" 
       AND media_name = "1536689569_6310-37.jpg"
221. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
222. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8722
       AND ps.stockroom_id = s.stockroom_id
223. 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'
224. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8722
225. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8722
       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
226. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
227. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
228. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8722
229. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
230. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8722
231. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
232. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8722
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
233. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8722
       AND ps.stockroom_id = s.stockroom_id
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 = 8722
236. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8722
       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 <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
239. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8722
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 = 8722
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 = 8722
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
244. 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=8723
       AND p.published = 1
       ORDER BY a.ordering ASC
245. 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=8723
       AND t.published = 1
       LIMIT 0,1
246. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
247. SELECT *
       FROM jos_menu
       WHERE id = '238'
248. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8723'
249. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8723'
       AND pc.category_id = c.category_id
250. 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='176'
       AND c.category_id = cx.category_parent_id
251. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
252. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
253. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8723'
       AND section='1'
254. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8723
255. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8723
       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 <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
258. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
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 = 8723
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 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'
263. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
264. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
265. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
266. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
267. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8723
       AND ps.stockroom_id = s.stockroom_id
268. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8723
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
269. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
270. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8723
271. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8723
       AND ps.stockroom_id = s.stockroom_id
272. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
273. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8723"
       AND media_type="images" 
       AND media_name = "1536689636_6311-07.jpg"
274. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
275. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8723
       AND ps.stockroom_id = s.stockroom_id
276. 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'
277. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8723
278. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8723
       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
279. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
280. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
281. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
282. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
283. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
284. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
285. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
286. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8723
       AND ps.stockroom_id = s.stockroom_id
287. 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'
288. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8723
289. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8723
       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
290. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
291. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
292. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
293. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
294. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
295. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
296. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8723
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
297. 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=8724
       AND p.published = 1
       ORDER BY a.ordering ASC
298. 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=8724
       AND t.published = 1
       LIMIT 0,1
299. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
300. SELECT *
       FROM jos_menu
       WHERE id = '238'
301. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8724'
302. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8724'
       AND pc.category_id = c.category_id
303. 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='176'
       AND c.category_id = cx.category_parent_id
304. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
305. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
306. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8724'
       AND section='1'
307. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8724
308. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8724
       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
309. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
310. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
311. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
312. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
313. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
314. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
315. 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'
316. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
317. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
318. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
319. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
320. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8724
       AND ps.stockroom_id = s.stockroom_id
321. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8724
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
322. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
323. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8724
324. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8724
       AND ps.stockroom_id = s.stockroom_id
325. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
326. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8724"
       AND media_type="images" 
       AND media_name = "1536689693_6311-37.jpg"
327. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
328. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8724
       AND ps.stockroom_id = s.stockroom_id
329. 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'
330. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8724
331. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8724
       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
332. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
333. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
334. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
335. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
336. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
337. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
338. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
339. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8724
       AND ps.stockroom_id = s.stockroom_id
340. 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'
341. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8724
342. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8724
       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
343. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
344. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
345. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
346. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
347. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
348. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
349. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8724
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
350. 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=8725
       AND p.published = 1
       ORDER BY a.ordering ASC
351. 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=8725
       AND t.published = 1
       LIMIT 0,1
352. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
353. SELECT *
       FROM jos_menu
       WHERE id = '238'
354. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8725'
355. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8725'
       AND pc.category_id = c.category_id
356. 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='176'
       AND c.category_id = cx.category_parent_id
357. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
358. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
359. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8725'
       AND section='1'
360. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8725
361. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8725
       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
362. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
363. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
364. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
365. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
366. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
367. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
368. 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'
369. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
370. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
371. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
372. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
373. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8725
       AND ps.stockroom_id = s.stockroom_id
374. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8725
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
375. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
376. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8725
377. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8725
       AND ps.stockroom_id = s.stockroom_id
378. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
379. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8725"
       AND media_type="images" 
       AND media_name = "1536689751_6311-38.jpg"
380. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
381. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8725
       AND ps.stockroom_id = s.stockroom_id
382. 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'
383. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8725
384. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8725
       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
385. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
386. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
387. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
388. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
389. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
390. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
391. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
392. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8725
       AND ps.stockroom_id = s.stockroom_id
393. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
394. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8725
395. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8725
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
396. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
397. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
398. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
399. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
400. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
401. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
402. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8725
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
403. 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=8726
       AND p.published = 1
       ORDER BY a.ordering ASC
404. 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=8726
       AND t.published = 1
       LIMIT 0,1
405. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
406. SELECT *
       FROM jos_menu
       WHERE id = '238'
407. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8726'
408. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8726'
       AND pc.category_id = c.category_id
409. 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='176'
       AND c.category_id = cx.category_parent_id
410. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
411. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
412. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8726'
       AND section='1'
413. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8726
414. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8726
       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
415. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
416. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
417. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
418. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
419. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
420. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
421. 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'
422. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
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 = 8726
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8726
       AND ps.stockroom_id = s.stockroom_id
427. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8726
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
428. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
429. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8726
430. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8726
       AND ps.stockroom_id = s.stockroom_id
431. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
432. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8726"
       AND media_type="images" 
       AND media_name = "1536689814_6435-06.jpg"
433. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
434. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8726
       AND ps.stockroom_id = s.stockroom_id
435. 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'
436. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8726
437. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8726
       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
438. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
439. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
440. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
441. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
442. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
443. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
444. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
445. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8726
       AND ps.stockroom_id = s.stockroom_id
446. 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'
447. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8726
448. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8726
       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
449. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
450. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
451. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
452. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
453. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
454. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
455. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8726
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
456. 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=8727
       AND p.published = 1
       ORDER BY a.ordering ASC
457. 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=8727
       AND t.published = 1
       LIMIT 0,1
458. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
459. SELECT *
       FROM jos_menu
       WHERE id = '238'
460. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8727'
461. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8727'
       AND pc.category_id = c.category_id
462. 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='176'
       AND c.category_id = cx.category_parent_id
463. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
464. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
465. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8727'
       AND section='1'
466. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8727
467. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8727
       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
468. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
469. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
470. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
471. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
472. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
473. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
474. 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'
475. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
476. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
477. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
478. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
479. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8727
       AND ps.stockroom_id = s.stockroom_id
480. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8727
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
481. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
482. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8727
483. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8727
       AND ps.stockroom_id = s.stockroom_id
484. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
485. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8727"
       AND media_type="images" 
       AND media_name = "1536689854_6435-37.jpg"
486. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
487. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8727
       AND ps.stockroom_id = s.stockroom_id
488. 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'
489. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8727
490. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8727
       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
491. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
492. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
493. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
494. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
495. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
496. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
497. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
498. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8727
       AND ps.stockroom_id = s.stockroom_id
499. 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'
500. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8727
501. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8727
       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
502. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
503. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
504. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
505. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
506. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
507. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
508. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8727
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
509. 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=8728
       AND p.published = 1
       ORDER BY a.ordering ASC
510. 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=8728
       AND t.published = 1
       LIMIT 0,1
511. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
512. SELECT *
       FROM jos_menu
       WHERE id = '238'
513. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8728'
514. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8728'
       AND pc.category_id = c.category_id
515. 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='176'
       AND c.category_id = cx.category_parent_id
516. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
517. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
518. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8728'
       AND section='1'
519. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8728
520. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8728
       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
521. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
522. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
523. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
524. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
525. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
526. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
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 *
       FROM jos_redshop_product
       WHERE product_id = 8728
529. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
530. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
531. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
532. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8728
       AND ps.stockroom_id = s.stockroom_id
533. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8728
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
534. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
535. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8728
536. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8728
       AND ps.stockroom_id = s.stockroom_id
537. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
538. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8728"
       AND media_type="images" 
       AND media_name = "1536689913_6442-29.jpg"
539. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
540. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8728
       AND ps.stockroom_id = s.stockroom_id
541. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
542. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8728
543. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8728
       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
544. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
545. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
546. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
547. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
548. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
549. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
550. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
551. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8728
       AND ps.stockroom_id = s.stockroom_id
552. 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'
553. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8728
554. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8728
       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
555. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
556. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
557. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
558. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
559. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
560. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
561. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8728
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
562. 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=8729
       AND p.published = 1
       ORDER BY a.ordering ASC
563. 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=8729
       AND t.published = 1
       LIMIT 0,1
564. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
565. SELECT *
       FROM jos_menu
       WHERE id = '238'
566. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8729'
567. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8729'
       AND pc.category_id = c.category_id
568. 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='176'
       AND c.category_id = cx.category_parent_id
569. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
570. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
571. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8729'
       AND section='1'
572. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8729
573. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8729
       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
574. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
575. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
576. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
577. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
578. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
579. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
580. 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'
581. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
582. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
583. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
584. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
585. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8729
       AND ps.stockroom_id = s.stockroom_id
586. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8729
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
587. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
588. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8729
589. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8729
       AND ps.stockroom_id = s.stockroom_id
590. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
591. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8729"
       AND media_type="images" 
       AND media_name = "1536689964_6450-15.jpg"
592. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
593. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8729
       AND ps.stockroom_id = s.stockroom_id
594. 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'
595. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8729
596. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8729
       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
597. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
598. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
599. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
600. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
601. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
602. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
603. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
604. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8729
       AND ps.stockroom_id = s.stockroom_id
605. 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'
606. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8729
607. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8729
       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
608. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
609. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
610. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
611. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
612. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
613. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
614. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8729
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
615. 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=8730
       AND p.published = 1
       ORDER BY a.ordering ASC
616. 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=8730
       AND t.published = 1
       LIMIT 0,1
617. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
618. SELECT *
       FROM jos_menu
       WHERE id = '238'
619. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8730'
620. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8730'
       AND pc.category_id = c.category_id
621. 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='176'
       AND c.category_id = cx.category_parent_id
622. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
623. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
624. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8730'
       AND section='1'
625. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8730
626. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8730
       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
627. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
628. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
629. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
630. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
631. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
632. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
633. 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'
634. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
635. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
636. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
637. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
638. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8730
       AND ps.stockroom_id = s.stockroom_id
639. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8730
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
640. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
641. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8730
642. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8730
       AND ps.stockroom_id = s.stockroom_id
643. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
644. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8730"
       AND media_type="images" 
       AND media_name = "1536690007_6451-01.jpg"
645. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
646. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8730
       AND ps.stockroom_id = s.stockroom_id
647. 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'
648. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8730
649. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8730
       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
650. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
651. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
652. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
653. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
654. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
655. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
656. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
657. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8730
       AND ps.stockroom_id = s.stockroom_id
658. 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'
659. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8730
660. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8730
       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
661. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
662. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
663. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
664. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
665. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
666. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
667. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8730
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
668. 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=8731
       AND p.published = 1
       ORDER BY a.ordering ASC
669. 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=8731
       AND t.published = 1
       LIMIT 0,1
670. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
671. SELECT *
       FROM jos_menu
       WHERE id = '238'
672. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8731'
673. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8731'
       AND pc.category_id = c.category_id
674. 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='176'
       AND c.category_id = cx.category_parent_id
675. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
676. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
677. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8731'
       AND section='1'
678. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8731
679. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8731
       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
680. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
681. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
682. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
683. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
684. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
685. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
686. 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'
687. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
688. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
689. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
690. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
691. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8731
       AND ps.stockroom_id = s.stockroom_id
692. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8731
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
693. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
694. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8731
695. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8731
       AND ps.stockroom_id = s.stockroom_id
696. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
697. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8731"
       AND media_type="images" 
       AND media_name = "1536690080_6451-06.jpg"
698. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
699. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8731
       AND ps.stockroom_id = s.stockroom_id
700. 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'
701. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8731
702. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8731
       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
703. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
704. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
705. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
706. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
707. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
708. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
709. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
710. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8731
       AND ps.stockroom_id = s.stockroom_id
711. 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'
712. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8731
713. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8731
       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
714. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
715. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
716. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
717. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
718. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
719. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
720. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8731
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
721. 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=8732
       AND p.published = 1
       ORDER BY a.ordering ASC
722. 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=8732
       AND t.published = 1
       LIMIT 0,1
723. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
724. SELECT *
       FROM jos_menu
       WHERE id = '238'
725. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8732'
726. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8732'
       AND pc.category_id = c.category_id
727. 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='176'
       AND c.category_id = cx.category_parent_id
728. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
729. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
730. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8732'
       AND section='1'
731. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8732
732. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8732
       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
733. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
734. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
735. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
736. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
737. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
738. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
739. 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'
740. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
741. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
742. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
743. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
744. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8732
       AND ps.stockroom_id = s.stockroom_id
745. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8732
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
746. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
747. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8732
748. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8732
       AND ps.stockroom_id = s.stockroom_id
749. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
750. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8732"
       AND media_type="images" 
       AND media_name = "1536690161_6950-15.jpg"
751. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
752. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8732
       AND ps.stockroom_id = s.stockroom_id
753. 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'
754. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8732
755. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8732
       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
756. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
757. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
758. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
759. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
760. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
761. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
762. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
763. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8732
       AND ps.stockroom_id = s.stockroom_id
764. 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'
765. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8732
766. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8732
       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
767. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
768. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
769. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
770. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
771. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
772. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
773. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8732
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
774. 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=8733
       AND p.published = 1
       ORDER BY a.ordering ASC
775. 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=8733
       AND t.published = 1
       LIMIT 0,1
776. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
777. SELECT *
       FROM jos_menu
       WHERE id = '238'
778. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8733'
779. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8733'
       AND pc.category_id = c.category_id
780. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='176'
       AND c.category_id = cx.category_parent_id
781. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
782. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
783. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8733'
       AND section='1'
784. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8733
785. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8733
       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
786. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
787. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
788. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
789. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
790. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
791. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
792. 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'
793. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
794. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
795. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
796. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
797. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8733
       AND ps.stockroom_id = s.stockroom_id
798. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8733
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
799. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
800. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8733
801. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8733
       AND ps.stockroom_id = s.stockroom_id
802. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
803. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8733"
       AND media_type="images" 
       AND media_name = "1536690226_6950-37.jpg"
804. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
805. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8733
       AND ps.stockroom_id = s.stockroom_id
806. 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'
807. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8733
808. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8733
       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
809. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
810. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
811. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
812. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
813. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
814. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
815. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
816. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8733
       AND ps.stockroom_id = s.stockroom_id
817. 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'
818. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8733
819. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8733
       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
820. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
821. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
822. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
823. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
824. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
825. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
826. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8733
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
827. 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=8734
       AND p.published = 1
       ORDER BY a.ordering ASC
828. 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=8734
       AND t.published = 1
       LIMIT 0,1
829. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
830. SELECT *
       FROM jos_menu
       WHERE id = '238'
831. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8734'
832. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8734'
       AND pc.category_id = c.category_id
833. 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='176'
       AND c.category_id = cx.category_parent_id
834. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
835. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
836. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8734'
       AND section='1'
837. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8734
838. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8734
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
839. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
840. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
841. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
842. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
843. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
844. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
845. SELECT 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'
846. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
847. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
848. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
849. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
850. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8734
       AND ps.stockroom_id = s.stockroom_id
851. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8734
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
852. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
853. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8734
854. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8734
       AND ps.stockroom_id = s.stockroom_id
855. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
856. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8734"
       AND media_type="images" 
       AND media_name = "1536690288_6975-02.jpg"
857. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
858. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8734
       AND ps.stockroom_id = s.stockroom_id
859. 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'
860. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8734
861. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8734
       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
862. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
863. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
864. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
865. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
866. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
867. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
868. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
869. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8734
       AND ps.stockroom_id = s.stockroom_id
870. 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'
871. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8734
872. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8734
       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
873. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
874. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
875. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
876. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
877. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
878. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
879. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8734
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
880. 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=8735
       AND p.published = 1
       ORDER BY a.ordering ASC
881. 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=8735
       AND t.published = 1
       LIMIT 0,1
882. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
883. SELECT *
       FROM jos_menu
       WHERE id = '238'
884. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '8735'
885. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '8735'
       AND pc.category_id = c.category_id
886. 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='176'
       AND c.category_id = cx.category_parent_id
887. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
888. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
889. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='8735'
       AND section='1'
890. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8735
891. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8735
       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
892. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
893. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
894. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
895. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
896. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
897. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
898. 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'
899. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
900. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
901. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
902. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
903. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8735
       AND ps.stockroom_id = s.stockroom_id
904. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8735
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
905. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
906. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 8735
907. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8735
       AND ps.stockroom_id = s.stockroom_id
908. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
909. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="8735"
       AND media_type="images" 
       AND media_name = "1536690352_6975-10.jpg"
910. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
911. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8735
       AND ps.stockroom_id = s.stockroom_id
912. 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'
913. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8735
914. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8735
       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
915. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
916. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
917. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
918. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
919. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
920. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
921. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
922. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 8735
       AND ps.stockroom_id = s.stockroom_id
923. 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'
924. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 8735
925. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 8735
       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
926. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
927. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1743458804'
       AND end_date >= '1743458804' 
       ORDER BY amount DESC
       LIMIT 0,1
928. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
929. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
930. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
931. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
932. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 8735
       AND discount_enddate>='1743458804'
       AND discount_stratdate<='1743458804'
933. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 176
934. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '238'
935. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params NOT LIKE '%categoryid%'
936. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=176
     %'
937. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=176
938. SELECT *
       FROM jos_menu
       WHERE id = '238'
939. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
940. 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='176'
       AND c.category_id = cx.category_parent_id
941. SELECT *
       FROM jos_menu
       WHERE id = '238'
942. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
943. 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='176'
       AND c.category_id = cx.category_parent_id
944. SELECT *
       FROM jos_menu
       WHERE id = '238'
945. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
946. 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='176'
       AND c.category_id = cx.category_parent_id
947. SELECT *
       FROM jos_menu
       WHERE id = '238'
948. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
949. 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='176'
       AND c.category_id = cx.category_parent_id
950. SELECT *
       FROM jos_menu
       WHERE id = '238'
951. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
952. 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='176'
       AND c.category_id = cx.category_parent_id
953. SELECT *
       FROM jos_menu
       WHERE id = '238'
954. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
955. 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='176'
       AND c.category_id = cx.category_parent_id
956. SELECT *
       FROM jos_menu
       WHERE id = '238'
957. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
958. 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='176'
       AND c.category_id = cx.category_parent_id
959. SELECT *
       FROM jos_menu
       WHERE id = '238'
960. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
961. 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='176'
       AND c.category_id = cx.category_parent_id
962. SELECT *
       FROM jos_menu
       WHERE id = '238'
963. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
964. 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='176'
       AND c.category_id = cx.category_parent_id
965. SELECT *
       FROM jos_menu
       WHERE id = '238'
966. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
967. 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='176'
       AND c.category_id = cx.category_parent_id
968. SELECT *
       FROM jos_menu
       WHERE id = '238'
969. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
970. 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='176'
       AND c.category_id = cx.category_parent_id
971. SELECT *
       FROM jos_menu
       WHERE id = '238'
972. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
973. 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='176'
       AND c.category_id = cx.category_parent_id
974. SELECT *
       FROM jos_menu
       WHERE id = '238'
975. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
976. 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='176'
       AND c.category_id = cx.category_parent_id
977. SELECT *
       FROM jos_menu
       WHERE id = '238'
978. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
979. 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='176'
       AND c.category_id = cx.category_parent_id
980. 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 = 238 OR mm.menuid = 0 )
       ORDER BY position, ordering
981. SELECT *
       FROM jos_menu
       WHERE id = '71'
982. SELECT *
       FROM jos_menu
       WHERE id = '222'
983. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
984. 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'
985. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
986. SELECT *
       FROM jos_menu
       WHERE id = '238'