Profile Information

Memory Usage

498 queries logged

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