Collections 2

Profile Information

Memory Usage

431 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'q03oaph4heo0s009tfqbp7n2r1'
2. DELETE
     FROM jos_session
     WHERE ( time < '1746281351' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'q03oaph4heo0s009tfqbp7n2r1'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'q03oaph4heo0s009tfqbp7n2r1','1746288551','','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-03'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'q03oaph4heo0s009tfqbp7n2r1'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('q03oaph4heo0s009tfqbp7n2r1', '0','1746288553')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'q03oaph4heo0s009tfqbp7n2r1'
      AND section='manufacturers'
      AND section_id='5'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('q03oaph4heo0s009tfqbp7n2r1','0','manufacturers','5','1746288555')
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 0, 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 = '62'
29. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '62'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
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='54'
      AND c.category_id = cx.category_parent_id
31. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
32. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 62
33. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 62
      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 <= '1746288555'
      AND end_date >= '1746288555' 
      ORDER BY amount DESC
      LIMIT 0,1
36. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 62
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 = 62
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 = 62
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 = 62
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 = 62
      AND ps.stockroom_id = s.stockroom_id
46. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 62
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 62
      AND discount_enddate>='1746288555'
      AND discount_stratdate<='1746288555'
48. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 62
49. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 62
      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 ="62"
      AND media_type="images" 
      AND media_name = "1306504415_HAV40729.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 = '63'
54. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '63'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
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='54'
      AND c.category_id = cx.category_parent_id
56. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
57. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 63
58. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 63
      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 <= '1746288555'
      AND end_date >= '1746288555' 
      ORDER BY amount DESC
      LIMIT 0,1
61. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 63
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 = 63
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 = 63
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 = 63
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 = 63
      AND ps.stockroom_id = s.stockroom_id
71. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 63
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
72. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 63
      AND discount_enddate>='1746288555'
      AND discount_stratdate<='1746288555'
73. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 63
74. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 63
      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 ="63"
      AND media_type="images" 
      AND media_name = "1306512161_HAV40785.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 = '64'
79. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '64'
      AND pc.category_id = c.category_id 
      AND c.category_id = '54'
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='54'
      AND c.category_id = cx.category_parent_id
81. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '54'
82. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 64
83. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 64
      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 <= '1746288555'
      AND end_date >= '1746288555' 
      ORDER BY amount DESC
      LIMIT 0,1
86. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 64
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 = 64
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 = 64
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 = 64
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 = 64
      AND ps.stockroom_id = s.stockroom_id
96. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 64
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
97. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 64
      AND discount_enddate>='1746288555'
      AND discount_stratdate<='1746288555'
98. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 64
99. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 64
      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 ="64"
       AND media_type="images" 
       AND media_name = "1307107064_HAV40797.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 = '65'
104. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '65'
       AND pc.category_id = c.category_id 
       AND c.category_id = '54'
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='54'
       AND c.category_id = cx.category_parent_id
106. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '54'
107. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 65
108. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 65
       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 <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
111. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 65
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 = 65
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 = 65
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 = 65
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 = 65
       AND ps.stockroom_id = s.stockroom_id
121. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 65
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
122. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 65
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
123. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 65
124. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 65
       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 ="65"
       AND media_type="images" 
       AND media_name = "1307034582_HAV40803.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 = '66'
129. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '66'
       AND pc.category_id = c.category_id 
       AND c.category_id = '54'
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='54'
       AND c.category_id = cx.category_parent_id
131. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '54'
132. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 66
133. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 66
       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 <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
136. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 66
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 = 66
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 = 66
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 = 66
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 = 66
       AND ps.stockroom_id = s.stockroom_id
146. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 66
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
147. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 66
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
148. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 66
149. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 66
       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 ="66"
       AND media_type="images" 
       AND media_name = "1307035942_HAV40816.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 = '67'
154. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '67'
       AND pc.category_id = c.category_id 
       AND c.category_id = '54'
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='54'
       AND c.category_id = cx.category_parent_id
156. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '54'
157. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 67
158. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 67
       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 <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
161. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 67
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 = 67
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 = 67
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 = 67
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 = 67
       AND ps.stockroom_id = s.stockroom_id
171. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 67
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
172. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 67
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
173. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 67
174. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 67
       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 ="67"
       AND media_type="images" 
       AND media_name = "1307037209_HAV40826.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 = '68'
179. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '68'
       AND pc.category_id = c.category_id 
       AND c.category_id = '54'
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='54'
       AND c.category_id = cx.category_parent_id
181. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '54'
182. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 68
183. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 68
       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 <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
186. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 68
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 = 68
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 = 68
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 = 68
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 = 68
       AND ps.stockroom_id = s.stockroom_id
196. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 68
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
197. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 68
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
198. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 68
199. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 68
       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 ="68"
       AND media_type="images" 
       AND media_name = "1307037873_HAV40834.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 = '69'
204. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '69'
       AND pc.category_id = c.category_id 
       AND c.category_id = '54'
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='54'
       AND c.category_id = cx.category_parent_id
206. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '54'
207. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 69
208. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 69
       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 <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
211. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 69
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 = 69
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 = 69
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 = 69
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 = 69
       AND ps.stockroom_id = s.stockroom_id
221. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 69
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
222. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 69
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
223. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 69
224. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 69
       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 ="69"
       AND media_type="images" 
       AND media_name = "1307040489_HAV40846.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 = '70'
229. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '70'
       AND pc.category_id = c.category_id 
       AND c.category_id = '54'
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='54'
       AND c.category_id = cx.category_parent_id
231. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '54'
232. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 70
233. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 70
       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 <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
236. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 70
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 = 70
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 = 70
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 = 70
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 = 70
       AND ps.stockroom_id = s.stockroom_id
246. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 70
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
247. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 70
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
248. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 70
249. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 70
       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 ="70"
       AND media_type="images" 
       AND media_name = "1307041924_HAV40856.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 = '71'
254. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '71'
       AND pc.category_id = c.category_id 
       AND c.category_id = '54'
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='54'
       AND c.category_id = cx.category_parent_id
256. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '54'
257. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 71
258. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 71
       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
259. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
260. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
261. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 71
262. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
263. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 71
264. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
265. 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'
266. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 71
267. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
268. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 71
269. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
270. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 71
       AND ps.stockroom_id = s.stockroom_id
271. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 71
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
272. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 71
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
273. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 71
274. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 71
       AND ps.stockroom_id = s.stockroom_id
275. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
276. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="71"
       AND media_type="images" 
       AND media_name = "1307042897_HAV40863.jpg"
277. SELECT *
       FROM jos_menu
       WHERE id = '222'
278. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '72'
279. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '72'
       AND pc.category_id = c.category_id 
       AND c.category_id = '54'
280. 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='54'
       AND c.category_id = cx.category_parent_id
281. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '54'
282. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 72
283. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 72
       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
284. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
285. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
286. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 72
287. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
288. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 72
289. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
290. 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'
291. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 72
292. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
293. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 72
294. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
295. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 72
       AND ps.stockroom_id = s.stockroom_id
296. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 72
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
297. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 72
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
298. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 72
299. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 72
       AND ps.stockroom_id = s.stockroom_id
300. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
301. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="72"
       AND media_type="images" 
       AND media_name = "1307044016_HAV40874.jpg"
302. SELECT *
       FROM jos_menu
       WHERE id = '222'
303. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '73'
304. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '73'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
305. 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
306. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
307. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 73
308. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 73
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
309. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
310. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
311. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 73
312. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
313. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 73
314. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
315. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
316. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 73
317. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
318. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 73
319. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
320. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 73
       AND ps.stockroom_id = s.stockroom_id
321. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 73
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
322. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 73
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
323. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 73
324. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 73
       AND ps.stockroom_id = s.stockroom_id
325. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
326. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="73"
       AND media_type="images" 
       AND media_name = "1307111373_HMY57503.jpg"
327. SELECT *
       FROM jos_menu
       WHERE id = '222'
328. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '74'
329. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '74'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
330. 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
331. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
332. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 74
333. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 74
       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
334. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
335. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
336. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 74
337. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
338. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 74
339. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
340. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
341. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 74
342. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
343. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 74
344. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
345. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 74
       AND ps.stockroom_id = s.stockroom_id
346. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 74
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
347. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 74
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
348. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 74
349. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 74
       AND ps.stockroom_id = s.stockroom_id
350. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
351. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="74"
       AND media_type="images" 
       AND media_name = "1307114222_HMY57511.jpg"
352. SELECT *
       FROM jos_menu
       WHERE id = '222'
353. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '75'
354. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '75'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
355. 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
356. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
357. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 75
358. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 75
       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
359. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
360. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
361. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 75
362. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
363. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 75
364. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
365. 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'
366. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 75
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 = 75
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 75
       AND ps.stockroom_id = s.stockroom_id
371. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 75
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
372. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 75
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
373. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 75
374. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 75
       AND ps.stockroom_id = s.stockroom_id
375. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
376. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="75"
       AND media_type="images" 
       AND media_name = "1307115096_HMY57533.jpg"
377. SELECT *
       FROM jos_menu
       WHERE id = '222'
378. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '76'
379. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '76'
       AND pc.category_id = c.category_id 
       AND c.category_id = '55'
380. 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
381. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
382. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 76
383. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 76
       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
384. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
385. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746288555'
       AND end_date >= '1746288555' 
       ORDER BY amount DESC
       LIMIT 0,1
386. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 76
387. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
388. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 76
389. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
390. 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'
391. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 76
392. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
393. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 76
394. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
395. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 76
       AND ps.stockroom_id = s.stockroom_id
396. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 76
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
397. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 76
       AND discount_enddate>='1746288555'
       AND discount_stratdate<='1746288555'
398. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 76
399. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 76
       AND ps.stockroom_id = s.stockroom_id
400. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
401. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="76"
       AND media_type="images" 
       AND media_name = "1307115913_HMY57542.jpg"
402. SELECT *
       FROM jos_menu
       WHERE id = '222'
403. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
404. SELECT *
       FROM jos_menu
       WHERE id = '222'
405. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
406. SELECT *
       FROM jos_menu
       WHERE id = '222'
407. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '5'
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_redshop_fields
       WHERE field_section='10'
       AND published=1 
       AND field_name IN ('manufacturer_image')
425. 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
426. SELECT *
       FROM jos_menu
       WHERE id = '71'
427. SELECT *
       FROM jos_menu
       WHERE id = '222'
428. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
429. 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'
430. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
431. 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