Profile Information

Memory Usage

1211 queries logged

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