Collections 2

Profile Information

Memory Usage

450 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'r3k1vbk92p5u39esslrs3ckna1'
2. DELETE
     FROM jos_session
     WHERE ( time < '1746334541' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'r3k1vbk92p5u39esslrs3ckna1'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'r3k1vbk92p5u39esslrs3ckna1','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 = 'r3k1vbk92p5u39esslrs3ckna1'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('r3k1vbk92p5u39esslrs3ckna1', '0','1746341744')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'r3k1vbk92p5u39esslrs3ckna1'
      AND section='manufacturers'
      AND section_id='5'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('r3k1vbk92p5u39esslrs3ckna1','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 75, 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 = '134'
29. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '134'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
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='58'
      AND c.category_id = cx.category_parent_id
31. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
32. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
33. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 134
34. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 134
      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
35. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
36. 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
37. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 134
38. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
39. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 134
40. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
41. 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'
42. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 134
43. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
44. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 134
45. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
46. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 134
      AND ps.stockroom_id = s.stockroom_id
47. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 134
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
48. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 134
      AND discount_enddate>='1746341748'
      AND discount_stratdate<='1746341748'
49. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 134
50. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 134
      AND ps.stockroom_id = s.stockroom_id
51. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
52. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="134"
      AND media_type="images" 
      AND media_name = "1307730657_GIR9405-2B.jpg"
53. SELECT *
      FROM jos_menu
      WHERE id = '222'
54. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '155'
55. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '155'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
56. 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='58'
      AND c.category_id = cx.category_parent_id
57. 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
58. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
59. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 155
60. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 155
      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
61. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
62. 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
63. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 155
64. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
65. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 155
66. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
67. 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'
68. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 155
69. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
70. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 155
71. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
72. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 155
      AND ps.stockroom_id = s.stockroom_id
73. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 155
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
74. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 155
      AND discount_enddate>='1746341748'
      AND discount_stratdate<='1746341748'
75. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 155
76. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 155
      AND ps.stockroom_id = s.stockroom_id
77. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
78. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="155"
      AND media_type="images" 
      AND media_name = "1308059355_GIR9406-1B.jpg"
79. SELECT *
      FROM jos_menu
      WHERE id = '222'
80. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '150'
81. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '150'
      AND pc.category_id = c.category_id 
      AND c.category_id = '58'
82. 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='58'
      AND c.category_id = cx.category_parent_id
83. 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
84. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '58'
85. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 150
86. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 150
      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
87. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
88. 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
89. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 150
90. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
91. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 150
92. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
93. 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'
94. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 150
95. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
96. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 150
97. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
98. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 150
      AND ps.stockroom_id = s.stockroom_id
99. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 150
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
100. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 150
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
101. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 150
102. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 150
       AND ps.stockroom_id = s.stockroom_id
103. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
104. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="150"
       AND media_type="images" 
       AND media_name = "1307974977_GIR9406-2B.jpg"
105. SELECT *
       FROM jos_menu
       WHERE id = '222'
106. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '152'
107. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '152'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
108. 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='58'
       AND c.category_id = cx.category_parent_id
109. 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
110. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
111. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 152
112. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 152
       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
113. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
114. 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
115. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
116. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
117. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
118. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
119. 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'
120. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
121. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
122. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
123. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
124. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 152
       AND ps.stockroom_id = s.stockroom_id
125. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 152
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
126. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 152
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
127. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 152
128. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 152
       AND ps.stockroom_id = s.stockroom_id
129. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
130. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="152"
       AND media_type="images" 
       AND media_name = "1308058095_GIR9406-3B.jpg"
131. SELECT *
       FROM jos_menu
       WHERE id = '222'
132. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '109'
133. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '109'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
134. 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='58'
       AND c.category_id = cx.category_parent_id
135. 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
136. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
137. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 109
138. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 109
       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
139. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
140. 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
141. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
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 = 109
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 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'
146. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
147. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
148. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
149. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
150. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 109
       AND ps.stockroom_id = s.stockroom_id
151. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 109
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
152. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 109
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
153. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 109
154. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 109
       AND ps.stockroom_id = s.stockroom_id
155. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
156. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="109"
       AND media_type="images" 
       AND media_name = "1307647463_GIR9407-1B.jpg"
157. SELECT *
       FROM jos_menu
       WHERE id = '222'
158. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '115'
159. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '115'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
160. 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='58'
       AND c.category_id = cx.category_parent_id
161. 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
162. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
163. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 115
164. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 115
       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
165. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
166. 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
167. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 115
168. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
169. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 115
170. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
171. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
172. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 115
173. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
174. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 115
175. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
176. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 115
       AND ps.stockroom_id = s.stockroom_id
177. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 115
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
178. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 115
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
179. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 115
180. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 115
       AND ps.stockroom_id = s.stockroom_id
181. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
182. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="115"
       AND media_type="images" 
       AND media_name = "1307654121_GIR9407-2B.jpg"
183. SELECT *
       FROM jos_menu
       WHERE id = '222'
184. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '164'
185. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '164'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
186. 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='58'
       AND c.category_id = cx.category_parent_id
187. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
188. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
189. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 164
190. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 164
       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
191. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
192. 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
193. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 164
194. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
195. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 164
196. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
197. 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'
198. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 164
199. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
200. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 164
201. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
202. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 164
       AND ps.stockroom_id = s.stockroom_id
203. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 164
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
204. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 164
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
205. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 164
206. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 164
       AND ps.stockroom_id = s.stockroom_id
207. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
208. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="164"
       AND media_type="images" 
       AND media_name = "1308067958_GIR9408-1B.jpg"
209. SELECT *
       FROM jos_menu
       WHERE id = '222'
210. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '167'
211. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '167'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
212. 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='58'
       AND c.category_id = cx.category_parent_id
213. 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
214. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
215. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 167
216. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 167
       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
217. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
218. 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
219. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 167
220. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
221. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 167
222. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
223. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
224. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 167
225. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
226. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 167
227. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
228. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 167
       AND ps.stockroom_id = s.stockroom_id
229. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 167
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
230. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 167
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
231. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 167
232. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 167
       AND ps.stockroom_id = s.stockroom_id
233. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
234. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="167"
       AND media_type="images" 
       AND media_name = "1308070120_GIR9408-2B.jpg"
235. SELECT *
       FROM jos_menu
       WHERE id = '222'
236. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '103'
237. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '103'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
238. 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='58'
       AND c.category_id = cx.category_parent_id
239. 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
240. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
241. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 103
242. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 103
       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
243. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
244. 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
245. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 103
246. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
247. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 103
248. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
249. 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'
250. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 103
251. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
252. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 103
253. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
254. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 103
       AND ps.stockroom_id = s.stockroom_id
255. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 103
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
256. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 103
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
257. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 103
258. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 103
       AND ps.stockroom_id = s.stockroom_id
259. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
260. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="103"
       AND media_type="images" 
       AND media_name = "1307634457_GIR9409-1B.jpg"
261. SELECT *
       FROM jos_menu
       WHERE id = '222'
262. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '105'
263. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '105'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
264. 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='58'
       AND c.category_id = cx.category_parent_id
265. 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
266. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
267. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 105
268. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 105
       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
269. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
270. 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
271. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 105
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 = 105
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 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'
276. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 105
277. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
278. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 105
279. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
280. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 105
       AND ps.stockroom_id = s.stockroom_id
281. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 105
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
282. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 105
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
283. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 105
284. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 105
       AND ps.stockroom_id = s.stockroom_id
285. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
286. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="105"
       AND media_type="images" 
       AND media_name = "1307637868_GIR9409-2B.jpg"
287. SELECT *
       FROM jos_menu
       WHERE id = '222'
288. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '176'
289. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '176'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
290. 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='58'
       AND c.category_id = cx.category_parent_id
291. 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
292. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
293. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 176
294. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 176
       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
295. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
296. 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
297. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 176
298. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
299. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 176
300. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
301. 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'
302. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 176
303. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
304. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 176
305. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
306. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 176
       AND ps.stockroom_id = s.stockroom_id
307. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 176
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
308. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 176
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
309. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 176
310. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 176
       AND ps.stockroom_id = s.stockroom_id
311. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
312. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="176"
       AND media_type="images" 
       AND media_name = "1308077843_GIR9419-1B.jpg"
313. SELECT *
       FROM jos_menu
       WHERE id = '222'
314. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '178'
315. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '178'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
316. 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='58'
       AND c.category_id = cx.category_parent_id
317. 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
318. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
319. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 178
320. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 178
       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
321. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
322. 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
323. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 178
324. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
325. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 178
326. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
327. 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'
328. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 178
329. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
330. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 178
331. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
332. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 178
       AND ps.stockroom_id = s.stockroom_id
333. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 178
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
334. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 178
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
335. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 178
336. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 178
       AND ps.stockroom_id = s.stockroom_id
337. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
338. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="178"
       AND media_type="images" 
       AND media_name = "1308079185_GIR9419-2B.jpg"
339. SELECT *
       FROM jos_menu
       WHERE id = '222'
340. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '170'
341. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '170'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
342. 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='58'
       AND c.category_id = cx.category_parent_id
343. 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
344. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
345. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 170
346. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 170
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
347. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
348. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746341748'
       AND end_date >= '1746341748' 
       ORDER BY amount DESC
       LIMIT 0,1
349. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 170
350. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
351. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 170
352. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
353. SELECT 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'
354. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 170
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 = 170
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 170
       AND ps.stockroom_id = s.stockroom_id
359. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 170
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
360. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 170
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
361. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 170
362. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 170
       AND ps.stockroom_id = s.stockroom_id
363. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
364. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="170"
       AND media_type="images" 
       AND media_name = "1308074521_GIR9421-1B.jpg"
365. SELECT *
       FROM jos_menu
       WHERE id = '222'
366. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '91'
367. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '91'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
368. 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='58'
       AND c.category_id = cx.category_parent_id
369. 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
370. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
371. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 91
372. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 91
       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
373. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
374. 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
375. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
376. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
377. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
378. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
379. 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'
380. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
381. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
382. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
383. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
384. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 91
       AND ps.stockroom_id = s.stockroom_id
385. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 91
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
386. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
387. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 91
388. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 91
       AND ps.stockroom_id = s.stockroom_id
389. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
390. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="91"
       AND media_type="images" 
       AND media_name = "1307559282_GIR9421-2B.jpg"
391. SELECT *
       FROM jos_menu
       WHERE id = '222'
392. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '139'
393. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '139'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
394. 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='58'
       AND c.category_id = cx.category_parent_id
395. 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
396. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
397. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 139
398. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 139
       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
399. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
400. 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
401. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 139
402. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
403. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 139
404. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
405. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
406. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 139
407. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
408. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 139
409. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
410. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 139
       AND ps.stockroom_id = s.stockroom_id
411. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 139
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
412. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 139
       AND discount_enddate>='1746341748'
       AND discount_stratdate<='1746341748'
413. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 139
414. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 139
       AND ps.stockroom_id = s.stockroom_id
415. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
416. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="139"
       AND media_type="images" 
       AND media_name = "1307733386_GIR9425-1B.jpg"
417. SELECT *
       FROM jos_menu
       WHERE id = '222'
418. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
419. SELECT *
       FROM jos_menu
       WHERE id = '222'
420. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
421. SELECT *
       FROM jos_menu
       WHERE id = '222'
422. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
423. SELECT *
       FROM jos_menu
       WHERE id = '222'
424. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
425. SELECT *
       FROM jos_menu
       WHERE id = '222'
426. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
427. SELECT *
       FROM jos_menu
       WHERE id = '222'
428. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
429. SELECT *
       FROM jos_menu
       WHERE id = '222'
430. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
431. SELECT *
       FROM jos_menu
       WHERE id = '222'
432. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
433. SELECT *
       FROM jos_menu
       WHERE id = '222'
434. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
435. SELECT *
       FROM jos_menu
       WHERE id = '222'
436. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
437. SELECT *
       FROM jos_menu
       WHERE id = '222'
438. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
439. SELECT *
       FROM jos_menu
       WHERE id = '222'
440. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
441. SELECT *
       FROM jos_menu
       WHERE id = '222'
442. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
443. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='10'
       AND published=1 
       AND field_name IN ('manufacturer_image')
444. 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
445. SELECT *
       FROM jos_menu
       WHERE id = '71'
446. SELECT *
       FROM jos_menu
       WHERE id = '222'
447. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
448. 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'
449. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
450. 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