Profile Information

Memory Usage

775 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'pj63fr3b2qfgi5ev5ekldsiqt1'
2. DELETE
     FROM jos_session
     WHERE ( time < '1745124844' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'pj63fr3b2qfgi5ev5ekldsiqt1'
4. UPDATE `jos_session`
     SET `time`='1745132044',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1745132027;s:18:\"session.timer.last\";i:1745132031;s:17:\"session.timer.now\";i:1745132038;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:65:\"/home/ontwall/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:7:\"visited\";a:2:{i:0;s:2:\"40\";i:1;s:2:\"25\";}}'
     WHERE session_id='pj63fr3b2qfgi5ev5ekldsiqt1'
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT m.*, c.`option` AS component
     FROM jos_menu AS m
     LEFT JOIN jos_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT *
     FROM jos_redshop_configuration
9. SELECT *
     FROM jos_redshop_catalog_request
     WHERE block = 0
10. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
11. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-04-20'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'pj63fr3b2qfgi5ev5ekldsiqt1'
13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'pj63fr3b2qfgi5ev5ekldsiqt1'
      AND section='category'
      AND section_id='30'
14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('pj63fr3b2qfgi5ev5ekldsiqt1','0','category','30','1745132048')
15. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
16. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
17. 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=30
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
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=30
      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=30
      AND published = 1
      ORDER BY c.category_name ASC
20. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '30'
21. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=30%')
      ORDER BY 'ordering'
22. SELECT *
      FROM jos_menu
      WHERE id = '222'
23. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '30'
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='30'
      AND c.category_id = cx.category_parent_id
25. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='29'
      AND c.category_id = cx.category_parent_id
26. 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=30
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 0, 15
27. 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=30
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
28. 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=30
      AND published = 1
      ORDER BY c.category_name ASC
29. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '30'
30. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=30%')
      ORDER BY 'ordering'
31. SELECT *
      FROM jos_menu
      WHERE id = '222'
32. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '30'
33. 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='30'
      AND c.category_id = cx.category_parent_id
34. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='29'
      AND c.category_id = cx.category_parent_id
35. SELECT count(a.attribute_id)
      FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=34
      AND p.published = 1
      ORDER BY a.ordering ASC
36. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=34
      AND t.published = 1
      LIMIT 0,1
37. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
38. SELECT *
      FROM jos_menu
      WHERE id = '222'
39. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '34'
40. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '34'
      AND pc.category_id = c.category_id
41. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='30'
      AND c.category_id = cx.category_parent_id
42. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='29'
      AND c.category_id = cx.category_parent_id
43. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '30'
44. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
45. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='34'
      AND section='1'
46. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 34
47. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 34
      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
48. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
49. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1745132048'
      AND end_date >= '1745132048' 
      ORDER BY amount DESC
      LIMIT 0,1
50. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
51. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
52. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
53. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
54. 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'
55. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
56. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
57. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
58. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
59. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 34
      AND ps.stockroom_id = s.stockroom_id
60. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 34
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
61. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
      AND discount_enddate>='1745132048'
      AND discount_stratdate<='1745132048'
62. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 34
63. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 34
      AND ps.stockroom_id = s.stockroom_id
64. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
65. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="34"
      AND media_type="images" 
      AND media_name = "1301290969_CT0507-1.jpg"
66. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
67. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 34
      AND ps.stockroom_id = s.stockroom_id
68. 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'
69. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 34
70. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 34
      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
71. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
72. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1745132048'
      AND end_date >= '1745132048' 
      ORDER BY amount DESC
      LIMIT 0,1
73. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
74. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
75. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
76. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
77. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
      AND discount_enddate>='1745132048'
      AND discount_stratdate<='1745132048'
78. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 34
      AND ps.stockroom_id = s.stockroom_id
79. 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'
80. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 34
81. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 34
      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
82. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
83. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1745132048'
      AND end_date >= '1745132048' 
      ORDER BY amount DESC
      LIMIT 0,1
84. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
85. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
86. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
87. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
88. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 34
      AND discount_enddate>='1745132048'
      AND discount_stratdate<='1745132048'
89. 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=35
      AND p.published = 1
      ORDER BY a.ordering ASC
90. 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=35
      AND t.published = 1
      LIMIT 0,1
91. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
92. SELECT *
      FROM jos_menu
      WHERE id = '222'
93. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '35'
94. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '35'
      AND pc.category_id = c.category_id 
      AND c.category_id = '30'
95. 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='30'
      AND c.category_id = cx.category_parent_id
96. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='29'
      AND c.category_id = cx.category_parent_id
97. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '30'
98. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
99. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='35'
      AND section='1'
100. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 35
101. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 35
       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
102. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
103. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132048'
       AND end_date >= '1745132048' 
       ORDER BY amount DESC
       LIMIT 0,1
104. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
105. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
106. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
107. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
108. SELECT 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'
109. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
110. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
111. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
112. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
113. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 35
       AND ps.stockroom_id = s.stockroom_id
114. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 35
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
115. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
       AND discount_enddate>='1745132048'
       AND discount_stratdate<='1745132048'
116. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 35
117. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 35
       AND ps.stockroom_id = s.stockroom_id
118. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
119. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="35"
       AND media_type="images" 
       AND media_name = "1301291108_CT4600-1.jpg"
120. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
121. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 35
       AND ps.stockroom_id = s.stockroom_id
122. 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'
123. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 35
124. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 35
       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
125. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
126. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132048'
       AND end_date >= '1745132048' 
       ORDER BY amount DESC
       LIMIT 0,1
127. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
128. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
129. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
130. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
131. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
       AND discount_enddate>='1745132048'
       AND discount_stratdate<='1745132048'
132. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 35
       AND ps.stockroom_id = s.stockroom_id
133. 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'
134. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 35
135. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 35
       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
136. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
137. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132048'
       AND end_date >= '1745132048' 
       ORDER BY amount DESC
       LIMIT 0,1
138. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
139. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
140. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
141. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
142. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 35
       AND discount_enddate>='1745132048'
       AND discount_stratdate<='1745132048'
143. 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=36
       AND p.published = 1
       ORDER BY a.ordering ASC
144. 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=36
       AND t.published = 1
       LIMIT 0,1
145. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
146. SELECT *
       FROM jos_menu
       WHERE id = '222'
147. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '36'
148. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '36'
       AND pc.category_id = c.category_id 
       AND c.category_id = '30'
149. 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='30'
       AND c.category_id = cx.category_parent_id
150. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
151. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
152. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
153. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='36'
       AND section='1'
154. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 36
155. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 36
       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
156. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
157. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
158. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
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 = 36
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 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'
163. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
164. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
165. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
166. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
167. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 36
       AND ps.stockroom_id = s.stockroom_id
168. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 36
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
169. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
170. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 36
171. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 36
       AND ps.stockroom_id = s.stockroom_id
172. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
173. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="36"
       AND media_type="images" 
       AND media_name = "1301542701_CT4601-1.jpg"
174. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
175. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 36
       AND ps.stockroom_id = s.stockroom_id
176. 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'
177. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 36
178. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 36
       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
179. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
180. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
181. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
182. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
183. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
184. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
185. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
186. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 36
       AND ps.stockroom_id = s.stockroom_id
187. 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'
188. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 36
189. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 36
       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
190. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
191. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
192. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
193. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
194. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
195. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
196. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 36
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
197. 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=37
       AND p.published = 1
       ORDER BY a.ordering ASC
198. 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=37
       AND t.published = 1
       LIMIT 0,1
199. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
200. SELECT *
       FROM jos_menu
       WHERE id = '222'
201. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '37'
202. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '37'
       AND pc.category_id = c.category_id 
       AND c.category_id = '30'
203. 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='30'
       AND c.category_id = cx.category_parent_id
204. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
205. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
206. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
207. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='37'
       AND section='1'
208. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 37
209. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 37
       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
210. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
211. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
212. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
213. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
214. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
215. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
216. 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'
217. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
218. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
219. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
220. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
221. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 37
       AND ps.stockroom_id = s.stockroom_id
222. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 37
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
223. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
224. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 37
225. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 37
       AND ps.stockroom_id = s.stockroom_id
226. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
227. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="37"
       AND media_type="images" 
       AND media_name = "1301542925_CT4602-1.jpg"
228. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
229. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 37
       AND ps.stockroom_id = s.stockroom_id
230. 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'
231. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 37
232. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 37
       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
233. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
234. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
235. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
236. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
237. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
238. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
239. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
240. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 37
       AND ps.stockroom_id = s.stockroom_id
241. 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'
242. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 37
243. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 37
       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
244. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
245. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
246. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
247. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
248. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
249. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
250. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 37
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
251. 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=38
       AND p.published = 1
       ORDER BY a.ordering ASC
252. 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=38
       AND t.published = 1
       LIMIT 0,1
253. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
254. SELECT *
       FROM jos_menu
       WHERE id = '222'
255. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '38'
256. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '38'
       AND pc.category_id = c.category_id 
       AND c.category_id = '30'
257. 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='30'
       AND c.category_id = cx.category_parent_id
258. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
259. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
260. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
261. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='38'
       AND section='1'
262. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 38
263. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 38
       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
264. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
265. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
266. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
267. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
268. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
269. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
270. SELECT 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'
271. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
272. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
273. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
274. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
275. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 38
       AND ps.stockroom_id = s.stockroom_id
276. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 38
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
277. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
278. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 38
279. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 38
       AND ps.stockroom_id = s.stockroom_id
280. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
281. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="38"
       AND media_type="images" 
       AND media_name = "1301543158_CT4603-1.jpg"
282. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
283. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 38
       AND ps.stockroom_id = s.stockroom_id
284. 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'
285. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 38
286. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 38
       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
287. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
288. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
289. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
290. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
291. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
292. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
293. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
294. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 38
       AND ps.stockroom_id = s.stockroom_id
295. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
296. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 38
297. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 38
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
298. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
299. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
300. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
301. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
302. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
303. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
304. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 38
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
305. 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=39
       AND p.published = 1
       ORDER BY a.ordering ASC
306. 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=39
       AND t.published = 1
       LIMIT 0,1
307. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
308. SELECT *
       FROM jos_menu
       WHERE id = '222'
309. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '39'
310. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '39'
       AND pc.category_id = c.category_id 
       AND c.category_id = '30'
311. 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='30'
       AND c.category_id = cx.category_parent_id
312. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
313. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
314. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
315. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='39'
       AND section='1'
316. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 39
317. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 39
       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
318. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
319. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
320. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
321. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
322. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
323. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
324. 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'
325. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
326. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
327. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
328. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
329. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 39
       AND ps.stockroom_id = s.stockroom_id
330. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 39
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
331. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
332. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 39
333. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 39
       AND ps.stockroom_id = s.stockroom_id
334. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
335. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="39"
       AND media_type="images" 
       AND media_name = "1301543305_CT4604-1.jpg"
336. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
337. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 39
       AND ps.stockroom_id = s.stockroom_id
338. 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'
339. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 39
340. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 39
       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
341. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
342. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
343. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
344. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
345. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
346. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
347. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
348. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 39
       AND ps.stockroom_id = s.stockroom_id
349. 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'
350. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 39
351. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 39
       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
352. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
353. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
354. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
355. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
356. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
357. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
358. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 39
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
359. 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=40
       AND p.published = 1
       ORDER BY a.ordering ASC
360. 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=40
       AND t.published = 1
       LIMIT 0,1
361. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
362. SELECT *
       FROM jos_menu
       WHERE id = '222'
363. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '40'
364. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '40'
       AND pc.category_id = c.category_id 
       AND c.category_id = '30'
365. 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='30'
       AND c.category_id = cx.category_parent_id
366. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
367. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
368. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
369. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='40'
       AND section='1'
370. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 40
371. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 40
       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
372. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
373. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
374. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
375. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
376. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
377. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
378. 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'
379. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
380. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
381. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
382. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
383. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 40
       AND ps.stockroom_id = s.stockroom_id
384. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 40
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
385. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
386. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 40
387. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 40
       AND ps.stockroom_id = s.stockroom_id
388. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
389. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="40"
       AND media_type="images" 
       AND media_name = "1301543436_CT4605-1.jpg"
390. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
391. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 40
       AND ps.stockroom_id = s.stockroom_id
392. 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'
393. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 40
394. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 40
       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
395. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
396. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
397. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
398. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
399. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
400. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
401. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
402. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 40
       AND ps.stockroom_id = s.stockroom_id
403. 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'
404. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 40
405. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 40
       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
406. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
407. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
408. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
409. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
410. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
411. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
412. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 40
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
413. 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=41
       AND p.published = 1
       ORDER BY a.ordering ASC
414. 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=41
       AND t.published = 1
       LIMIT 0,1
415. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
416. SELECT *
       FROM jos_menu
       WHERE id = '222'
417. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '41'
418. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '41'
       AND pc.category_id = c.category_id 
       AND c.category_id = '30'
419. 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='30'
       AND c.category_id = cx.category_parent_id
420. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
421. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
422. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
423. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='41'
       AND section='1'
424. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 41
425. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 41
       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
426. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
427. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
428. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
429. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
430. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
431. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
432. 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'
433. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
434. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
435. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
436. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
437. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 41
       AND ps.stockroom_id = s.stockroom_id
438. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 41
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
439. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
440. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 41
441. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 41
       AND ps.stockroom_id = s.stockroom_id
442. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
443. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="41"
       AND media_type="images" 
       AND media_name = "1301543568_CT4606-1.jpg"
444. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
445. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 41
       AND ps.stockroom_id = s.stockroom_id
446. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
447. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 41
448. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 41
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
449. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
450. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
451. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
452. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
453. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
454. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
455. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
456. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 41
       AND ps.stockroom_id = s.stockroom_id
457. 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'
458. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 41
459. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 41
       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
460. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
461. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
462. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
463. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
464. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
465. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
466. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 41
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
467. 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=42
       AND p.published = 1
       ORDER BY a.ordering ASC
468. 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=42
       AND t.published = 1
       LIMIT 0,1
469. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
470. SELECT *
       FROM jos_menu
       WHERE id = '222'
471. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '42'
472. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '42'
       AND pc.category_id = c.category_id
473. 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='30'
       AND c.category_id = cx.category_parent_id
474. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
475. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
476. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
477. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='42'
       AND section='1'
478. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 42
479. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 42
       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
480. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
481. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
482. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 42
483. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
484. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 42
485. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
486. 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'
487. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 42
488. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
489. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 42
490. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
491. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 42
       AND ps.stockroom_id = s.stockroom_id
492. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 42
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
493. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 42
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
494. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 42
495. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 42
       AND ps.stockroom_id = s.stockroom_id
496. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
497. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="42"
       AND media_type="images" 
       AND media_name = "1301543657_CT4607-1.jpg"
498. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
499. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 42
       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 = 42
502. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 42
       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 <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
505. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 42
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 = 42
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 = 42
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
510. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 42
       AND ps.stockroom_id = s.stockroom_id
511. 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'
512. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 42
513. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 42
       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
514. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
515. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
516. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 42
517. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
518. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 42
519. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
520. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 42
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
521. 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=43
       AND p.published = 1
       ORDER BY a.ordering ASC
522. 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=43
       AND t.published = 1
       LIMIT 0,1
523. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
524. SELECT *
       FROM jos_menu
       WHERE id = '222'
525. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '43'
526. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '43'
       AND pc.category_id = c.category_id
527. 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='30'
       AND c.category_id = cx.category_parent_id
528. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
529. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
530. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
531. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='43'
       AND section='1'
532. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 43
533. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 43
       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
534. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
535. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
536. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
537. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
538. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
539. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
540. 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'
541. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
542. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
543. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
544. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
545. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 43
       AND ps.stockroom_id = s.stockroom_id
546. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 43
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
547. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
548. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 43
549. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 43
       AND ps.stockroom_id = s.stockroom_id
550. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
551. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="43"
       AND media_type="images" 
       AND media_name = "1301543735_CT4607-1.jpg"
552. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
553. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 43
       AND ps.stockroom_id = s.stockroom_id
554. 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'
555. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 43
556. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 43
       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
557. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
558. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
559. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
560. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
561. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
562. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
563. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
564. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 43
       AND ps.stockroom_id = s.stockroom_id
565. 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'
566. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 43
567. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 43
       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
568. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
569. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
570. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
571. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
572. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
573. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
574. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 43
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
575. 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=44
       AND p.published = 1
       ORDER BY a.ordering ASC
576. 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=44
       AND t.published = 1
       LIMIT 0,1
577. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
578. SELECT *
       FROM jos_menu
       WHERE id = '222'
579. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '44'
580. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '44'
       AND pc.category_id = c.category_id
581. 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='30'
       AND c.category_id = cx.category_parent_id
582. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
583. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
584. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
585. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='44'
       AND section='1'
586. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 44
587. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 44
       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
588. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
589. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
590. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
591. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
592. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
593. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
594. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
595. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
596. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
597. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
598. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
599. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 44
       AND ps.stockroom_id = s.stockroom_id
600. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 44
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
601. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
602. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 44
603. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 44
       AND ps.stockroom_id = s.stockroom_id
604. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
605. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="44"
       AND media_type="images" 
       AND media_name = "1301543791_CT4609-1.jpg"
606. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
607. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 44
       AND ps.stockroom_id = s.stockroom_id
608. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
609. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 44
610. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 44
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
611. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
612. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
613. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
614. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
615. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
616. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
617. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
618. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 44
       AND ps.stockroom_id = s.stockroom_id
619. 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'
620. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 44
621. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 44
       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
622. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
623. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
624. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
625. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
626. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
627. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
628. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 44
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
629. 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=45
       AND p.published = 1
       ORDER BY a.ordering ASC
630. 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=45
       AND t.published = 1
       LIMIT 0,1
631. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
632. SELECT *
       FROM jos_menu
       WHERE id = '222'
633. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '45'
634. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '45'
       AND pc.category_id = c.category_id
635. 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='30'
       AND c.category_id = cx.category_parent_id
636. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
637. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
638. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
639. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='45'
       AND section='1'
640. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 45
641. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 45
       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
642. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
643. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
644. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
645. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
646. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
647. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
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 *
       FROM jos_redshop_product
       WHERE product_id = 45
650. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
651. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
652. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
653. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 45
       AND ps.stockroom_id = s.stockroom_id
654. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 45
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
655. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
656. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 45
657. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 45
       AND ps.stockroom_id = s.stockroom_id
658. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
659. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="45"
       AND media_type="images" 
       AND media_name = "1301543869_CT4610-1.jpg"
660. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
661. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 45
       AND ps.stockroom_id = s.stockroom_id
662. 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'
663. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 45
664. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 45
       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
665. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
666. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
667. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
668. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
669. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
670. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
671. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
672. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 45
       AND ps.stockroom_id = s.stockroom_id
673. 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'
674. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 45
675. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 45
       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
676. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
677. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
678. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
679. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
680. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
681. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
682. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 45
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
683. 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=46
       AND p.published = 1
       ORDER BY a.ordering ASC
684. 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=46
       AND t.published = 1
       LIMIT 0,1
685. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
686. SELECT *
       FROM jos_menu
       WHERE id = '222'
687. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '46'
688. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '46'
       AND pc.category_id = c.category_id
689. 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='30'
       AND c.category_id = cx.category_parent_id
690. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
691. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
692. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
693. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='46'
       AND section='1'
694. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 46
695. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 46
       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
696. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
697. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
698. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
699. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
700. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
701. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
702. 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'
703. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
704. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
705. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
706. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
707. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 46
       AND ps.stockroom_id = s.stockroom_id
708. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 46
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
709. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
710. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 46
711. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 46
       AND ps.stockroom_id = s.stockroom_id
712. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
713. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="46"
       AND media_type="images" 
       AND media_name = "1301543918_CT4611-1.jpg"
714. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
715. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 46
       AND ps.stockroom_id = s.stockroom_id
716. 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'
717. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 46
718. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 46
       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
719. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
720. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
721. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
722. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
723. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
724. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
725. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
726. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 46
       AND ps.stockroom_id = s.stockroom_id
727. 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'
728. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 46
729. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 46
       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
730. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
731. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745132049'
       AND end_date >= '1745132049' 
       ORDER BY amount DESC
       LIMIT 0,1
732. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
733. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
734. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
735. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
736. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
       AND discount_enddate>='1745132049'
       AND discount_stratdate<='1745132049'
737. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 30
738. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '222'
739. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params NOT LIKE '%categoryid%'
740. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=30
     %'
741. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 30
742. SELECT *
       FROM jos_menu
       WHERE id = '222'
743. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
744. 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='30'
       AND c.category_id = cx.category_parent_id
745. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
746. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=30
747. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=29
     %'
748. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 29
749. SELECT *
       FROM jos_menu
       WHERE id = '222'
750. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '29'
751. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
752. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=29
753. SELECT *
       FROM jos_menu
       WHERE id = '222'
754. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
755. 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='30'
       AND c.category_id = cx.category_parent_id
756. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
757. SELECT *
       FROM jos_menu
       WHERE id = '222'
758. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
759. 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='30'
       AND c.category_id = cx.category_parent_id
760. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
761. SELECT *
       FROM jos_menu
       WHERE id = '222'
762. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
763. 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='30'
       AND c.category_id = cx.category_parent_id
764. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
765. SELECT *
       FROM jos_menu
       WHERE id = '222'
766. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
767. 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='30'
       AND c.category_id = cx.category_parent_id
768. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
769. SELECT id, title, module, position, content, showtitle, control, params
       FROM jos_modules AS m
       LEFT JOIN jos_modules_menu AS mm
       ON mm.moduleid = m.id
       WHERE m.published = 1
       AND m.access <= 0
       AND m.client_id = 0
       AND ( mm.menuid = 222 OR mm.menuid = 0 )
       ORDER BY position, ordering
770. SELECT *
       FROM jos_menu
       WHERE id = '71'
771. SELECT *
       FROM jos_menu
       WHERE id = '222'
772. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
773. 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'
774. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
775. SELECT *
       FROM jos_menu
       WHERE id = '222'