Collections 2

Profile Information

Memory Usage

441 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'h1s0scc492r1kagscrpsjtsfc3'
2. DELETE
     FROM jos_session
     WHERE ( time < '1746334541' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'h1s0scc492r1kagscrpsjtsfc3'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'h1s0scc492r1kagscrpsjtsfc3','1746341741','','0','1','0' )
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT m.*, c.`option` AS component
     FROM jos_menu AS m
     LEFT JOIN jos_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT *
     FROM jos_redshop_configuration
9. SELECT *
     FROM jos_redshop_catalog_request
     WHERE block = 0
10. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
11. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-05-04'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'h1s0scc492r1kagscrpsjtsfc3'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('h1s0scc492r1kagscrpsjtsfc3', '0','1746341743')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'h1s0scc492r1kagscrpsjtsfc3'
      AND section='manufacturers'
      AND section_id='5'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('h1s0scc492r1kagscrpsjtsfc3','0','manufacturers','5','1746341747')
16. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
17. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
18. SELECT mn.*, m.media_name,m.section_id
      FROM  jos_redshop_manufacturer AS mn
      LEFT JOIN jos_redshop_media AS m
      ON m.section_id=mn.manufacturer_id
      AND m.published = 1
      AND m.media_section='manufacturer'
      WHERE mn.published = 1 
      AND mn.manufacturer_id='5'
19. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '222'
20. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=manufacturers%' 
      AND params  LIKE '%manufacturerid=5
    %'
21. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 5
22. SELECT *
      FROM  jos_redshop_manufacturer
      WHERE published = 1
23. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=5
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_name ASC
24. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'manufacturer_products'
      AND published=1
      AND template_id='14'
      LIMIT 0,1
25. SELECT category_id AS value, category_name AS text
      FROM jos_redshop_category
      WHERE published = '1'
      ORDER BY category_name ASC
26. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=5
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_name ASC
      LIMIT 15, 15
27. SELECT *
      FROM jos_menu
      WHERE id = '222'
28. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '77'
29. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '77'
      AND pc.category_id = c.category_id 
      AND c.category_id = '55'
30. 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='55'
      AND c.category_id = cx.category_parent_id
31. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '55'
32. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 77
33. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 77
      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
34. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
35. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746341747'
      AND end_date >= '1746341747' 
      ORDER BY amount DESC
      LIMIT 0,1
36. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 77
37. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
38. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 77
39. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
40. 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'
41. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 77
42. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
43. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 77
44. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
45. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 77
      AND ps.stockroom_id = s.stockroom_id
46. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 77
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 77
      AND discount_enddate>='1746341747'
      AND discount_stratdate<='1746341747'
48. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 77
49. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 77
      AND ps.stockroom_id = s.stockroom_id
50. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
51. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="77"
      AND media_type="images" 
      AND media_name = "1307116641_HMY57567.jpg"
52. SELECT *
      FROM jos_menu
      WHERE id = '222'
53. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '78'
54. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '78'
      AND pc.category_id = c.category_id 
      AND c.category_id = '55'
55. 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='55'
      AND c.category_id = cx.category_parent_id
56. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '55'
57. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 78
58. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 78
      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
59. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
60. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746341747'
      AND end_date >= '1746341747' 
      ORDER BY amount DESC
      LIMIT 0,1
61. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 78
62. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
63. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 78
64. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
65. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
66. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 78
67. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
68. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 78
69. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
70. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 78
      AND ps.stockroom_id = s.stockroom_id
71. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 78
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
72. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 78
      AND discount_enddate>='1746341747'
      AND discount_stratdate<='1746341747'
73. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 78
74. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 78
      AND ps.stockroom_id = s.stockroom_id
75. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
76. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="78"
      AND media_type="images" 
      AND media_name = "1307117933_HMY57585.jpg"
77. SELECT *
      FROM jos_menu
      WHERE id = '222'
78. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '79'
79. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '79'
      AND pc.category_id = c.category_id 
      AND c.category_id = '55'
80. 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='55'
      AND c.category_id = cx.category_parent_id
81. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '55'
82. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 79
83. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 79
      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
84. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
85. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746341747'
      AND end_date >= '1746341747' 
      ORDER BY amount DESC
      LIMIT 0,1
86. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 79
87. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
88. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 79
89. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
90. 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'
91. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 79
92. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
93. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 79
94. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
95. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 79
      AND ps.stockroom_id = s.stockroom_id
96. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 79
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
97. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 79
      AND discount_enddate>='1746341747'
      AND discount_stratdate<='1746341747'
98. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 79
99. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 79
      AND ps.stockroom_id = s.stockroom_id
100. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
101. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="79"
       AND media_type="images" 
       AND media_name = "1307119517_HMY57591.jpg"
102. SELECT *
       FROM jos_menu
       WHERE id = '222'
103. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '80'
104. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '80'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
105. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='55'
       AND c.category_id = cx.category_parent_id
106. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
107. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 80
108. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 80
       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
109. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
110. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341747'
       AND end_date >= '1746341747' 
       ORDER BY amount DESC
       LIMIT 0,1
111. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 80
112. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
113. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 80
114. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
115. 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'
116. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 80
117. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
118. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 80
119. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
120. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 80
       AND ps.stockroom_id = s.stockroom_id
121. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 80
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
122. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 80
       AND discount_enddate>='1746341747'
       AND discount_stratdate<='1746341747'
123. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 80
124. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 80
       AND ps.stockroom_id = s.stockroom_id
125. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
126. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="80"
       AND media_type="images" 
       AND media_name = "1307120415_HMY57607.jpg"
127. SELECT *
       FROM jos_menu
       WHERE id = '222'
128. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '81'
129. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '81'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
130. 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='55'
       AND c.category_id = cx.category_parent_id
131. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
132. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 81
133. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 81
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
134. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
135. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
136. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 81
137. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
138. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 81
139. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
140. SELECT 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'
141. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 81
142. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
143. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 81
144. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
145. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 81
       AND ps.stockroom_id = s.stockroom_id
146. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 81
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
147. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 81
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
148. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 81
149. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 81
       AND ps.stockroom_id = s.stockroom_id
150. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
151. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="81"
       AND media_type="images" 
       AND media_name = "1307122859_HMY57619.jpg"
152. SELECT *
       FROM jos_menu
       WHERE id = '222'
153. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '82'
154. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '82'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
155. 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='55'
       AND c.category_id = cx.category_parent_id
156. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
157. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 82
158. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 82
       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
159. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
160. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
161. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 82
162. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
163. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 82
164. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
165. 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'
166. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 82
167. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
168. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 82
169. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
170. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 82
       AND ps.stockroom_id = s.stockroom_id
171. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 82
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
172. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 82
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
173. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 82
174. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 82
       AND ps.stockroom_id = s.stockroom_id
175. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
176. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="82"
       AND media_type="images" 
       AND media_name = "1307123419_HMY57635.jpg"
177. SELECT *
       FROM jos_menu
       WHERE id = '222'
178. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '83'
179. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '83'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
180. 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='55'
       AND c.category_id = cx.category_parent_id
181. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
182. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 83
183. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 83
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
184. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
185. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
186. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 83
187. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
188. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 83
189. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
190. SELECT 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'
191. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 83
192. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
193. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 83
194. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
195. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 83
       AND ps.stockroom_id = s.stockroom_id
196. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 83
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
197. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 83
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
198. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 83
199. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 83
       AND ps.stockroom_id = s.stockroom_id
200. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
201. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="83"
       AND media_type="images" 
       AND media_name = "1307126274_HMY57646.jpg"
202. SELECT *
       FROM jos_menu
       WHERE id = '222'
203. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '84'
204. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '84'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
205. 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='55'
       AND c.category_id = cx.category_parent_id
206. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
207. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 84
208. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 84
       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
209. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
210. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
211. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 84
212. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
213. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 84
214. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
215. SELECT 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'
216. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 84
217. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
218. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 84
219. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
220. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 84
       AND ps.stockroom_id = s.stockroom_id
221. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 84
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
222. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 84
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
223. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 84
224. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 84
       AND ps.stockroom_id = s.stockroom_id
225. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
226. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="84"
       AND media_type="images" 
       AND media_name = "1307129553_HMY57654.jpg"
227. SELECT *
       FROM jos_menu
       WHERE id = '222'
228. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '85'
229. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '85'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
230. 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='55'
       AND c.category_id = cx.category_parent_id
231. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
232. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 85
233. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 85
       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
234. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
235. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
236. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 85
237. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
238. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 85
239. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
240. 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'
241. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 85
242. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
243. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 85
244. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
245. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 85
       AND ps.stockroom_id = s.stockroom_id
246. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 85
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
247. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 85
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
248. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 85
249. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 85
       AND ps.stockroom_id = s.stockroom_id
250. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
251. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="85"
       AND media_type="images" 
       AND media_name = "1307130887_HMY57665.jpg"
252. SELECT *
       FROM jos_menu
       WHERE id = '222'
253. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '163'
254. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '163'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
255. 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='57'
       AND c.category_id = cx.category_parent_id
256. 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='56'
       AND c.category_id = cx.category_parent_id
257. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
258. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 163
259. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 163
       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
260. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
261. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
262. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 163
263. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
264. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 163
265. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
266. 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'
267. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 163
268. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
269. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 163
270. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
271. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 163
       AND ps.stockroom_id = s.stockroom_id
272. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 163
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
273. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 163
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
274. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 163
275. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 163
       AND ps.stockroom_id = s.stockroom_id
276. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
277. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="163"
       AND media_type="images" 
       AND media_name = "1308063597_GIR9552-3.jpg"
278. SELECT *
       FROM jos_menu
       WHERE id = '222'
279. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '116'
280. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '116'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
281. 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='57'
       AND c.category_id = cx.category_parent_id
282. 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='56'
       AND c.category_id = cx.category_parent_id
283. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
284. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 116
285. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 116
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
286. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
287. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
288. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 116
289. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
290. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 116
291. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
292. SELECT 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'
293. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 116
294. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
295. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 116
296. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
297. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 116
       AND ps.stockroom_id = s.stockroom_id
298. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 116
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
299. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 116
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
300. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 116
301. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 116
       AND ps.stockroom_id = s.stockroom_id
302. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
303. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="116"
       AND media_type="images" 
       AND media_name = "1307654584_DS1945_12.jpg"
304. SELECT *
       FROM jos_menu
       WHERE id = '222'
305. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '110'
306. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '110'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
307. 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='57'
       AND c.category_id = cx.category_parent_id
308. 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='56'
       AND c.category_id = cx.category_parent_id
309. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
310. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 110
311. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 110
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
312. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
313. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
314. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 110
315. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
316. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 110
317. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
318. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
319. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 110
320. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
321. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 110
322. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
323. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 110
       AND ps.stockroom_id = s.stockroom_id
324. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 110
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
325. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 110
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
326. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 110
327. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 110
       AND ps.stockroom_id = s.stockroom_id
328. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
329. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="110"
       AND media_type="images" 
       AND media_name = "1307655206_GIR1945-16.jpg"
330. SELECT *
       FROM jos_menu
       WHERE id = '222'
331. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '100'
332. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '100'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
333. 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='57'
       AND c.category_id = cx.category_parent_id
334. 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='56'
       AND c.category_id = cx.category_parent_id
335. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
336. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 100
337. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 100
       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
338. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
339. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
340. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 100
341. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
342. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 100
343. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
344. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
345. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 100
346. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
347. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 100
348. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
349. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 100
       AND ps.stockroom_id = s.stockroom_id
350. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 100
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
351. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 100
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
352. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 100
353. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 100
       AND ps.stockroom_id = s.stockroom_id
354. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
355. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="100"
       AND media_type="images" 
       AND media_name = "1307631626_GIR1945-17.jpg"
356. SELECT *
       FROM jos_menu
       WHERE id = '222'
357. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '171'
358. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '171'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
359. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
360. 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='56'
       AND c.category_id = cx.category_parent_id
361. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
362. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 171
363. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 171
       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
364. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
365. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
366. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 171
367. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
368. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 171
369. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
370. 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'
371. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 171
372. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
373. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 171
374. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
375. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 171
       AND ps.stockroom_id = s.stockroom_id
376. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 171
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
377. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 171
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
378. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 171
379. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 171
       AND ps.stockroom_id = s.stockroom_id
380. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
381. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="171"
       AND media_type="images" 
       AND media_name = "1308074853_CK2570_15.jpg"
382. SELECT *
       FROM jos_menu
       WHERE id = '222'
383. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '95'
384. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '95'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
385. 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='57'
       AND c.category_id = cx.category_parent_id
386. 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='56'
       AND c.category_id = cx.category_parent_id
387. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
388. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 95
389. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 95
       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
390. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
391. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
392. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 95
393. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
394. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 95
395. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
396. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
397. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 95
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 = 95
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 95
       AND ps.stockroom_id = s.stockroom_id
402. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 95
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
403. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 95
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
404. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 95
405. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 95
       AND ps.stockroom_id = s.stockroom_id
406. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
407. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="95"
       AND media_type="images" 
       AND media_name = "1307567822_CK2570_16.jpg"
408. SELECT *
       FROM jos_menu
       WHERE id = '222'
409. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
410. SELECT *
       FROM jos_menu
       WHERE id = '222'
411. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
412. SELECT *
       FROM jos_menu
       WHERE id = '222'
413. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
414. SELECT *
       FROM jos_menu
       WHERE id = '222'
415. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
416. SELECT *
       FROM jos_menu
       WHERE id = '222'
417. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
418. SELECT *
       FROM jos_menu
       WHERE id = '222'
419. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
420. SELECT *
       FROM jos_menu
       WHERE id = '222'
421. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
422. SELECT *
       FROM jos_menu
       WHERE id = '222'
423. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
424. SELECT *
       FROM jos_menu
       WHERE id = '222'
425. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
426. SELECT *
       FROM jos_menu
       WHERE id = '222'
427. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
428. SELECT *
       FROM jos_menu
       WHERE id = '222'
429. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
430. SELECT *
       FROM jos_menu
       WHERE id = '222'
431. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
432. SELECT *
       FROM jos_menu
       WHERE id = '222'
433. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
434. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='10'
       AND published=1 
       AND field_name IN ('manufacturer_image')
435. 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
436. SELECT *
       FROM jos_menu
       WHERE id = '71'
437. SELECT *
       FROM jos_menu
       WHERE id = '222'
438. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
439. 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'
440. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
441. SELECT *
       FROM jos_menu
       WHERE id = '222'

Language Files Loaded

• /home/ontwall/public_html/language/en-GB/en-GB.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.com_redshop.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.tpl_granit.ini
• /home/ontwall/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.mod_redshop_search.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None