Profile Information

Memory Usage

502 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'uf9dt05qbcft7gqlat1bb122s5'
2. DELETE
     FROM jos_session
     WHERE ( time < '1746231419' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'uf9dt05qbcft7gqlat1bb122s5'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'uf9dt05qbcft7gqlat1bb122s5','1746238619','','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-02'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'uf9dt05qbcft7gqlat1bb122s5'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('uf9dt05qbcft7gqlat1bb122s5', '0','1746238623')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'uf9dt05qbcft7gqlat1bb122s5'
      AND section='product'
      AND section_id='86'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('uf9dt05qbcft7gqlat1bb122s5','0','product','86','1746238627')
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 id
      FROM `jos_components`
      WHERE `link` LIKE '%com_reddesign%'
19. SELECT p.*, c.category_id, c.category_name, m.manufacturer_name ,s.supplier_name 
      FROM (jos_redshop_category AS c ,jos_redshop_product AS p , jos_redshop_product_category_xref AS pcr ) 
      LEFT JOIN jos_redshop_manufacturer AS m
      ON m.manufacturer_id = p.manufacturer_id 
      LEFT JOIN jos_redshop_supplier AS s
      ON s.supplier_id = p.supplier_id   
      WHERE p.product_id=86
      AND pcr.product_id=86
      AND pcr.category_id=c.category_id 
      AND p.published = 1
20. SELECT  min_del_time AS deltime, s.max_del_time, s.delivery_time 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
      AND ps.quantity >0
      ORDER BY min_del_time ASC
      LIMIT 0,1
21. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_template AS t
      WHERE t.template_id = p.product_template
      AND t.template_section='product'
      AND p.product_id=86
      AND t.published = 1
      LIMIT 0,1
22. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
23. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 86
      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
24. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
25. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746238627'
      AND end_date >= '1746238627' 
      ORDER BY amount DESC
      LIMIT 0,1
26. SELECT *
      FROM jos_menu
      WHERE id = '222'
27. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '86'
28. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '86'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
29. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='57'
      AND c.category_id = cx.category_parent_id
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='56'
      AND c.category_id = cx.category_parent_id
31. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
32. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1 
      AND field_name IN ('product_desc','product_thumb_image','more_images','product_s_desc','manufacturer_link','related_product:Related Products')
33. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 5
34. SELECT *
      FROM jos_menu
      WHERE id = '222'
35. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '5'
36. SELECT product_id AS value,product_name AS text
                                           
      FROM `jos_redshop_product`
                                           
      WHERE `product_parent_id` =86
37. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
38. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 86
39. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 86
      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
40. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
41. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746238627'
      AND end_date >= '1746238627' 
      ORDER BY amount DESC
      LIMIT 0,1
42. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
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 = 86
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 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'
47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
48. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
49. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
50. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
51. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
52. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 86
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
53. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
      AND discount_enddate>='1746238627'
      AND discount_stratdate<='1746238627'
54. SELECT *
      FROM jos_redshop_media AS m
      LEFT JOIN jos_redshop_product AS p
      ON p.product_id = m.section_id
      WHERE m.media_section = 'product'
      AND media_type='images'
      AND m.section_id=86
      AND m.published = 1
55. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="355"
56. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="356"
57. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="357"
58. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="358"
59. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="359"
60. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_id="360"
61. SELECT *
      FROM jos_redshop_wrapper
      WHERE published = 1
      AND (FIND_IN_SET(86,product_id)  OR wrapper_use_to_all = 1  )
62. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'wrapper_template'
      AND published=1
63. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'attribute_template'
      AND published=1
64. SELECT a.attribute_id AS value,a.attribute_name AS text,a.*
      FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
      WHERE a.product_id = p.product_id
      AND p.product_id=86
      AND p.published = 1
      ORDER BY a.ordering ASC
65. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'accessory_template'
      AND published=1
66. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'review'
      AND published=1
      LIMIT 0,1
67. SELECT ui.firstname,ui.lastname,pr.*
      FROM jos_redshop_product_rating AS pr, jos_users AS u, jos_redshop_users_info AS ui
      WHERE pr.product_id=86
      AND pr.published = 1
      AND pr.userid=u.id
      AND ui.user_id=u.id
      AND ui.address_type LIKE 'BT'
      ORDER BY pr.favoured DESC
68. SELECT pr.*
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=86
      AND pr.published = 1
69. SELECT sum(user_rating) AS rating
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=86
      AND pr.published = 1
70. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
71. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 86
72. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
73. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
74. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="86"
      AND media_type="images" 
      AND media_name = "1307552016_CK2570-18.jpg"
75. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
76. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
77. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 86
78. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 86
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
79. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
80. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746238627'
      AND end_date >= '1746238627' 
      ORDER BY amount DESC
      LIMIT 0,1
81. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
82. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
83. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
84. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
      AND discount_enddate>='1746238627'
      AND discount_stratdate<='1746238627'
86. 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'
87. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
88. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 86
      AND ps.stockroom_id = s.stockroom_id
89. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 86
90. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 86
      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
91. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
92. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1746238627'
      AND end_date >= '1746238627' 
      ORDER BY amount DESC
      LIMIT 0,1
93. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
94. 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
95. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
96. 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
97. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 86
      AND discount_enddate>='1746238627'
      AND discount_stratdate<='1746238627'
98. 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'
99. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
100. UPDATE jos_redshop_product
       SET `visited` = visited + 1
       WHERE `product_id` = '86'
101. SELECT p.product_name,pcx.category_id
       FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
       WHERE p.product_id = 86
       AND p.product_id = pcx.product_id
102. 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=''
       AND c.category_id = cx.category_parent_id
103. SELECT pcx.product_id,p.product_name
       FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
       WHERE pcx.category_id=57
       AND pcx.product_id=p.product_id
       ORDER BY pcx.product_id
104. SELECT *
       FROM jos_menu
       WHERE id = '222'
105. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '94'
106. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '94'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
107. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
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='56'
       AND c.category_id = cx.category_parent_id
109. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
110. SELECT *
       FROM jos_redshop_textlibrary
       WHERE published=1
111. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '222'
112. SELECT category_id
       FROM jos_redshop_product_category_xref
       WHERE product_id=86
113. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params NOT LIKE '%categoryid%'
114. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=product%' 
       AND params  LIKE '%productid=86
     %'
115. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 86
116. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'related_product'
       AND published=1
117. SELECT *
       FROM jos_redshop_product AS p ,jos_redshop_product_related  AS r
       WHERE r.related_id = p.product_id
       AND r.product_id=86
       AND p.published = 1
118. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
119. SELECT *
       FROM jos_menu
       WHERE id = '222'
120. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '92'
121. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '92'
       AND pc.category_id = c.category_id 
       AND c.category_id = '59'
122. 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='59'
       AND c.category_id = cx.category_parent_id
123. 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
124. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '59'
125. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 92
126. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 92
       AND ps.stockroom_id = s.stockroom_id
127. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
128. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="92"
       AND media_type="images" 
       AND media_name = "1307561491_StarsHearts1.jpg"
129. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 92
130. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 92
       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
131. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
132. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
133. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
134. 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
135. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
136. 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
137. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
138. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 92
139. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 92
       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
140. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
141. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
142. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
143. 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
144. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
145. 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
146. 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'
147. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 92
       AND ps.stockroom_id = s.stockroom_id
148. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 92
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
149. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
150. SELECT *
       FROM jos_menu
       WHERE id = '222'
151. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '92'
152. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '92'
       AND pc.category_id = c.category_id 
       AND c.category_id = '59'
153. 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='59'
       AND c.category_id = cx.category_parent_id
154. 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
155. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '59'
156. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=92
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
157. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 92
       AND ps.stockroom_id = s.stockroom_id
158. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=92
       AND p.published = 1
       ORDER BY a.ordering ASC
159. 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'
160. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 92
161. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 92
       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
162. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
163. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
164. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
165. 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
166. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
167. 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
168. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
169. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 92
       AND ps.stockroom_id = s.stockroom_id
170. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=92
       AND p.published = 1
       ORDER BY a.ordering ASC
171. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
172. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 92
173. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 92
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
174. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
175. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
176. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
177. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
178. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
179. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
180. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 92
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
181. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
182. SELECT *
       FROM jos_menu
       WHERE id = '222'
183. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '90'
184. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '90'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
185. 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
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='56'
       AND c.category_id = cx.category_parent_id
187. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
188. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 90
189. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 90
       AND ps.stockroom_id = s.stockroom_id
190. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
191. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="90"
       AND media_type="images" 
       AND media_name = "1307558555_GIR9404-1B.jpg"
192. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 90
193. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 90
       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
194. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
195. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
196. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
197. 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
198. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
199. 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
200. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
201. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 90
202. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 90
       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
203. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
204. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
205. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
206. 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
207. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
208. 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
209. 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'
210. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 90
       AND ps.stockroom_id = s.stockroom_id
211. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 90
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
212. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
213. SELECT *
       FROM jos_menu
       WHERE id = '222'
214. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '90'
215. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '90'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
216. 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
217. 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
218. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
219. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=90
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
220. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 90
       AND ps.stockroom_id = s.stockroom_id
221. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=90
       AND p.published = 1
       ORDER BY a.ordering ASC
222. 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'
223. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 90
224. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 90
       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
225. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
226. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
227. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
228. 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
229. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
230. 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
231. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
232. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 90
       AND ps.stockroom_id = s.stockroom_id
233. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=90
       AND p.published = 1
       ORDER BY a.ordering ASC
234. 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'
235. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 90
236. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 90
       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
237. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
238. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
239. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
240. 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
241. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
242. 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
243. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 90
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
244. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
245. SELECT *
       FROM jos_menu
       WHERE id = '222'
246. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '87'
247. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '87'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
248. 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
249. 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
250. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
251. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 87
252. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 87
       AND ps.stockroom_id = s.stockroom_id
253. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
254. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="87"
       AND media_type="images" 
       AND media_name = "1307553969_GIR9405-1B.jpg"
255. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 87
256. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 87
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
257. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
258. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
259. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
260. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
261. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
262. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
263. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
264. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 87
265. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 87
       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
266. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
267. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
268. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
269. 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
270. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
271. 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
272. 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'
273. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 87
       AND ps.stockroom_id = s.stockroom_id
274. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 87
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
275. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
276. SELECT *
       FROM jos_menu
       WHERE id = '222'
277. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '87'
278. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '87'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
279. 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
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='56'
       AND c.category_id = cx.category_parent_id
281. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
282. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=87
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
283. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 87
       AND ps.stockroom_id = s.stockroom_id
284. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=87
       AND p.published = 1
       ORDER BY a.ordering ASC
285. 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'
286. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 87
287. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 87
       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
288. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
289. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
290. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
291. 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
292. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
293. 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
294. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
295. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 87
       AND ps.stockroom_id = s.stockroom_id
296. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=87
       AND p.published = 1
       ORDER BY a.ordering ASC
297. 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'
298. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 87
299. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 87
       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
300. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
301. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
302. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 87
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 = 87
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 *
       FROM jos_redshop_product
       WHERE product_id = 87
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
307. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
308. SELECT *
       FROM jos_menu
       WHERE id = '222'
309. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '88'
310. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '88'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
311. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='58'
       AND c.category_id = cx.category_parent_id
312. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
313. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
314. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 88
315. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 88
       AND ps.stockroom_id = s.stockroom_id
316. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
317. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="88"
       AND media_type="images" 
       AND media_name = "1307555687_GIR9403-3B.jpg"
318. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 88
319. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 88
       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
320. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
321. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
322. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
323. 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
324. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
325. 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
326. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
327. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 88
328. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 88
       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
329. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
330. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
331. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
332. 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
333. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
334. 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
335. 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'
336. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 88
       AND ps.stockroom_id = s.stockroom_id
337. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 88
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
338. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
339. SELECT *
       FROM jos_menu
       WHERE id = '222'
340. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '88'
341. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '88'
       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 a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=88
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
346. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 88
       AND ps.stockroom_id = s.stockroom_id
347. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=88
       AND p.published = 1
       ORDER BY a.ordering ASC
348. 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'
349. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 88
350. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 88
       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
351. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
352. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
353. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
354. 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
355. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
356. 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
357. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
358. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 88
       AND ps.stockroom_id = s.stockroom_id
359. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=88
       AND p.published = 1
       ORDER BY a.ordering ASC
360. 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'
361. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 88
362. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 88
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
363. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
364. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
365. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
366. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
367. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
368. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
369. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 88
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
370. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
371. SELECT *
       FROM jos_menu
       WHERE id = '222'
372. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '89'
373. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '89'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
374. 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
375. 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
376. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
377. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 89
378. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 89
       AND ps.stockroom_id = s.stockroom_id
379. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
380. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="89"
       AND media_type="images" 
       AND media_name = "1307556894_GIR9425-2B.jpg"
381. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 89
382. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 89
       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
383. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
384. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
385. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
386. 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
387. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
388. 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
389. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
390. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 89
391. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 89
       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
392. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
393. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
394. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
395. 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
396. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
397. 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
398. 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'
399. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 89
       AND ps.stockroom_id = s.stockroom_id
400. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 89
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
401. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
402. SELECT *
       FROM jos_menu
       WHERE id = '222'
403. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '89'
404. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '89'
       AND pc.category_id = c.category_id 
       AND c.category_id = '58'
405. 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
406. 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
407. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
408. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=89
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
409. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 89
       AND ps.stockroom_id = s.stockroom_id
410. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=89
       AND p.published = 1
       ORDER BY a.ordering ASC
411. 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'
412. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 89
413. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 89
       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
414. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
415. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
416. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
417. 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
418. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
419. 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
420. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
421. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 89
       AND ps.stockroom_id = s.stockroom_id
422. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=89
       AND p.published = 1
       ORDER BY a.ordering ASC
423. 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'
424. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 89
425. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 89
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
426. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
427. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
428. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
429. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
430. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
431. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
432. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 89
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
433. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
434. SELECT *
       FROM jos_menu
       WHERE id = '222'
435. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '91'
436. 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'
437. 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
438. 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
439. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
440. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 91
441. 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
442. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
443. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="91"
       AND media_type="images" 
       AND media_name = "1307559282_GIR9421-2B.jpg"
444. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 91
445. 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
446. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
447. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
448. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
449. 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
450. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
451. 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
452. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
453. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 91
454. 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
455. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
456. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
457. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
458. 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
459. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
460. 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
461. 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'
462. 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
463. 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
464. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
465. SELECT *
       FROM jos_menu
       WHERE id = '222'
466. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '91'
467. 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'
468. 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
469. 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
470. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '58'
471. SELECT a.attribute_id AS value,a.attribute_name AS text,a.attribute_required
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=91
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
472. 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
473. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=91
       AND p.published = 1
       ORDER BY a.ordering ASC
474. 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'
475. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 91
476. 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
477. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
478. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
479. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
480. 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
481. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
482. 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
483. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
484. 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
485. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p , jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=91
       AND p.published = 1
       ORDER BY a.ordering ASC
486. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
487. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 91
488. 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
489. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
490. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1746238627'
       AND end_date >= '1746238627' 
       ORDER BY amount DESC
       LIMIT 0,1
491. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
492. 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
493. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
494. 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
495. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 91
       AND discount_enddate>='1746238627'
       AND discount_stratdate<='1746238627'
496. 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
497. SELECT *
       FROM jos_menu
       WHERE id = '71'
498. SELECT *
       FROM jos_menu
       WHERE id = '222'
499. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
500. 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'
501. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
502. 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