Lars Contzen 3 Collection

Profile Information

Memory Usage

549 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '44ugbi75cufsu8au6lb1sfioq3'
2. DELETE
     FROM jos_session
     WHERE ( time < '1758217462' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '44ugbi75cufsu8au6lb1sfioq3'
4. UPDATE `jos_session`
     SET `time`='1758224662',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1758224641;s:18:\"session.timer.last\";i:1758224650;s:17:\"session.timer.now\";i:1758224655;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:65:\"/home/ontwall/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:7:\"visited\";a:3:{i:0;s:3:\"515\";i:1;s:3:\"494\";i:2;s:3:\"544\";}}'
     WHERE session_id='44ugbi75cufsu8au6lb1sfioq3'
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-09-18'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '44ugbi75cufsu8au6lb1sfioq3'
13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '44ugbi75cufsu8au6lb1sfioq3'
      AND section='product'
      AND section_id='491'
14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('44ugbi75cufsu8au6lb1sfioq3','0','product','491','1758224668')
15. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
16. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 155)
      ORDER BY menuid DESC
      LIMIT 0, 1
17. SELECT id
      FROM `jos_components`
      WHERE `link` LIKE '%com_reddesign%'
18. 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=491
      AND pcr.product_id=491
      AND pcr.category_id=c.category_id 
      AND p.published = 1
19. 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 = 491
      AND ps.stockroom_id = s.stockroom_id
      AND ps.quantity >0
      ORDER BY min_del_time ASC
      LIMIT 0,1
20. 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=491
      AND t.published = 1
      LIMIT 0,1
21. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
22. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 491
      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
23. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
24. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1758224668'
      AND end_date >= '1758224668' 
      ORDER BY amount DESC
      LIMIT 0,1
25. SELECT *
      FROM jos_menu
      WHERE id = '155'
26. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '491'
27. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '491'
      AND pc.category_id = c.category_id 
      AND c.category_id = '70'
28. 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='70'
      AND c.category_id = cx.category_parent_id
29. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '70'
30. 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')
31. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 13
32. SELECT *
      FROM jos_menu
      WHERE id = '155'
33. SELECT sef_url,manufacturer_name
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = '13'
34. SELECT product_id AS value,product_name AS text
                                           
      FROM `jos_redshop_product`
                                           
      WHERE `product_parent_id` =491
35. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 491
      AND ps.stockroom_id = s.stockroom_id
36. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 491
37. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 491
      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
38. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
39. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1758224669'
      AND end_date >= '1758224669' 
      ORDER BY amount DESC
      LIMIT 0,1
40. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
41. 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
42. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
43. 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
44. 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'
45. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
46. 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
47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
48. 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
49. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 491
      AND ps.stockroom_id = s.stockroom_id
50. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 491
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
      AND discount_enddate>='1758224669'
      AND discount_stratdate<='1758224669'
52. 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=491
      AND m.published = 1
53. SELECT *
      FROM jos_redshop_wrapper
      WHERE published = 1
      AND (FIND_IN_SET(491,product_id)  OR wrapper_use_to_all = 1  )
54. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'wrapper_template'
      AND published=1
55. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'attribute_template'
      AND published=1
56. 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=491
      AND p.published = 1
      ORDER BY a.ordering ASC
57. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'accessory_template'
      AND published=1
58. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'review'
      AND published=1
      LIMIT 0,1
59. 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=491
      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
60. SELECT pr.*
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=491
      AND pr.published = 1
61. SELECT sum(user_rating) AS rating
      FROM jos_redshop_product_rating AS pr
      WHERE pr.product_id=491
      AND pr.published = 1
62. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
63. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 491
64. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 491
      AND ps.stockroom_id = s.stockroom_id
65. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
66. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="491"
      AND media_type="images" 
      AND media_name = "1356109960_881588.jpg"
67. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
68. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 491
      AND ps.stockroom_id = s.stockroom_id
69. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 491
70. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 491
      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
71. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
72. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1758224669'
      AND end_date >= '1758224669' 
      ORDER BY amount DESC
      LIMIT 0,1
73. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
74. 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
75. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
76. 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
77. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
      AND discount_enddate>='1758224669'
      AND discount_stratdate<='1758224669'
78. 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'
79. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
80. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 491
      AND ps.stockroom_id = s.stockroom_id
81. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 491
82. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 491
      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
83. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
84. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1758224669'
      AND end_date >= '1758224669' 
      ORDER BY amount DESC
      LIMIT 0,1
85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
86. 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
87. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
88. 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
89. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 491
      AND discount_enddate>='1758224669'
      AND discount_stratdate<='1758224669'
90. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
91. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
92. UPDATE jos_redshop_product
      SET `visited` = visited + 1
      WHERE `product_id` = '491'
93. SELECT p.product_name,pcx.category_id
      FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
      WHERE p.product_id = 491
      AND p.product_id = pcx.product_id
94. 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
95. SELECT pcx.product_id,p.product_name
      FROM jos_redshop_product AS p,jos_redshop_product_category_xref AS pcx
      WHERE pcx.category_id=70
      AND pcx.product_id=p.product_id
      ORDER BY pcx.product_id
96. SELECT *
      FROM jos_menu
      WHERE id = '155'
97. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '492'
98. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '492'
      AND pc.category_id = c.category_id 
      AND c.category_id = '70'
99. 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='70'
      AND c.category_id = cx.category_parent_id
100. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
101. SELECT *
       FROM jos_menu
       WHERE id = '155'
102. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '490'
103. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '490'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
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='70'
       AND c.category_id = cx.category_parent_id
105. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
106. SELECT *
       FROM jos_redshop_textlibrary
       WHERE published=1
107. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '155'
108. SELECT category_id
       FROM jos_redshop_product_category_xref
       WHERE product_id=491
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=category%' 
       AND params  LIKE '%categoryid=70
     %'
111. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=70
112. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=product%' 
       AND params  LIKE '%productid=491
     %'
113. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 491
114. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'related_product'
       AND published=1
115. SELECT *
       FROM jos_redshop_product AS p ,jos_redshop_product_related  AS r
       WHERE r.related_id = p.product_id
       AND r.product_id=491
       AND p.published = 1
116. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
117. SELECT *
       FROM jos_menu
       WHERE id = '155'
118. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '544'
119. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '544'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
120. 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='70'
       AND c.category_id = cx.category_parent_id
121. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
122. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 544
123. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 544
       AND ps.stockroom_id = s.stockroom_id
124. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
125. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="544"
       AND media_type="images" 
       AND media_name = "1356123991_881014.jpg"
126. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 544
127. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 544
       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
128. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
129. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
130. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 544
131. 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
132. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 544
133. 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
134. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 544
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
135. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 544
136. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 544
       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
137. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
138. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
139. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 544
140. 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
141. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 544
142. 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
143. 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'
144. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 544
       AND ps.stockroom_id = s.stockroom_id
145. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 544
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
146. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 544
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
147. SELECT *
       FROM jos_menu
       WHERE id = '155'
148. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '544'
149. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '544'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
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='70'
       AND c.category_id = cx.category_parent_id
151. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
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=544
       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 = 544
       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=544
       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 = 544
157. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 544
       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 <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
160. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 544
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 = 544
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 = 544
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
165. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 544
       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=544
       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 = 544
169. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 544
       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 <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
172. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 544
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 = 544
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 = 544
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
177. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
178. SELECT *
       FROM jos_menu
       WHERE id = '155'
179. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '519'
180. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '519'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
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='70'
       AND c.category_id = cx.category_parent_id
182. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
183. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 519
184. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 519
       AND ps.stockroom_id = s.stockroom_id
185. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
186. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="519"
       AND media_type="images" 
       AND media_name = "1356117038_881335.jpg"
187. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 519
188. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 519
       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
189. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
190. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
191. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
192. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
193. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
194. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
195. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
196. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 519
197. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 519
       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
198. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
199. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
200. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
201. 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
202. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
203. 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
204. 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'
205. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 519
       AND ps.stockroom_id = s.stockroom_id
206. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 519
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
207. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
208. SELECT *
       FROM jos_menu
       WHERE id = '155'
209. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '519'
210. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '519'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
211. 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='70'
       AND c.category_id = cx.category_parent_id
212. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
213. 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=519
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
214. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 519
       AND ps.stockroom_id = s.stockroom_id
215. 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=519
       AND p.published = 1
       ORDER BY a.ordering ASC
216. 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'
217. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 519
218. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 519
       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
219. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
220. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
221. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
222. 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
223. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
224. 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
225. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
226. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 519
       AND ps.stockroom_id = s.stockroom_id
227. 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=519
       AND p.published = 1
       ORDER BY a.ordering ASC
228. 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'
229. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 519
230. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 519
       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
231. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
232. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
233. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
234. 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
235. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
236. 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
237. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 519
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
238. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
239. SELECT *
       FROM jos_menu
       WHERE id = '155'
240. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '496'
241. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '496'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
242. 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='70'
       AND c.category_id = cx.category_parent_id
243. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
244. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 496
245. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 496
       AND ps.stockroom_id = s.stockroom_id
246. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
247. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="496"
       AND media_type="images" 
       AND media_name = "1356110738_881236.jpg"
248. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 496
249. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 496
       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
250. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
251. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
252. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
253. 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
254. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
255. 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
256. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
257. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 496
258. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 496
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
259. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
260. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
261. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
262. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
263. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
264. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
265. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
266. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 496
       AND ps.stockroom_id = s.stockroom_id
267. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 496
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
268. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
269. SELECT *
       FROM jos_menu
       WHERE id = '155'
270. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '496'
271. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '496'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
272. 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='70'
       AND c.category_id = cx.category_parent_id
273. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
274. 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=496
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
275. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 496
       AND ps.stockroom_id = s.stockroom_id
276. 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=496
       AND p.published = 1
       ORDER BY a.ordering ASC
277. 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'
278. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 496
279. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 496
       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
280. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
281. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
282. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
283. 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
284. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
285. 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
286. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
287. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 496
       AND ps.stockroom_id = s.stockroom_id
288. 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=496
       AND p.published = 1
       ORDER BY a.ordering ASC
289. 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'
290. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 496
291. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 496
       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
292. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
293. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
294. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
295. 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
296. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
297. 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
298. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 496
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
299. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
300. SELECT *
       FROM jos_menu
       WHERE id = '155'
301. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '489'
302. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '489'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
303. 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='70'
       AND c.category_id = cx.category_parent_id
304. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
305. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 489
306. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 489
       AND ps.stockroom_id = s.stockroom_id
307. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
308. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="489"
       AND media_type="images" 
       AND media_name = "1356108125_881212.jpg"
309. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 489
310. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 489
       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
311. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
312. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
313. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
314. 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
315. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
316. 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
317. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
318. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 489
319. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 489
       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 <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
322. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
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 = 489
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 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'
327. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 489
       AND ps.stockroom_id = s.stockroom_id
328. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 489
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
329. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
330. SELECT *
       FROM jos_menu
       WHERE id = '155'
331. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '489'
332. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '489'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
333. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='70'
       AND c.category_id = cx.category_parent_id
334. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
335. 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=489
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
336. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 489
       AND ps.stockroom_id = s.stockroom_id
337. 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=489
       AND p.published = 1
       ORDER BY a.ordering ASC
338. 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'
339. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 489
340. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 489
       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
341. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
342. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
343. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
344. 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
345. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
346. 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
347. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
348. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 489
       AND ps.stockroom_id = s.stockroom_id
349. 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=489
       AND p.published = 1
       ORDER BY a.ordering ASC
350. 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'
351. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 489
352. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 489
       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
353. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
354. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
355. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
356. 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
357. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
358. 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
359. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 489
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
360. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
361. SELECT *
       FROM jos_menu
       WHERE id = '155'
362. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '499'
363. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '499'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
364. 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='70'
       AND c.category_id = cx.category_parent_id
365. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
366. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 499
367. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 499
       AND ps.stockroom_id = s.stockroom_id
368. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
369. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="499"
       AND media_type="images" 
       AND media_name = "1356112174_880727.jpg"
370. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 499
371. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 499
       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
372. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
373. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
374. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
375. 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
376. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
377. 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
378. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
379. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 499
380. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 499
       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
381. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
382. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
383. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
384. 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
385. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
386. 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
387. 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'
388. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 499
       AND ps.stockroom_id = s.stockroom_id
389. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 499
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
390. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
391. SELECT *
       FROM jos_menu
       WHERE id = '155'
392. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '499'
393. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '499'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
394. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='70'
       AND c.category_id = cx.category_parent_id
395. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
396. 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=499
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
397. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 499
       AND ps.stockroom_id = s.stockroom_id
398. 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=499
       AND p.published = 1
       ORDER BY a.ordering ASC
399. 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'
400. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 499
401. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 499
       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
402. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
403. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
404. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
405. 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
406. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
407. 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
408. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
409. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 499
       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=499
       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 = 499
413. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 499
       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 <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
416. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 499
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 = 499
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 = 499
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
421. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
422. SELECT *
       FROM jos_menu
       WHERE id = '155'
423. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '537'
424. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '537'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
425. 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='70'
       AND c.category_id = cx.category_parent_id
426. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
427. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 537
428. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 537
       AND ps.stockroom_id = s.stockroom_id
429. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
430. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="537"
       AND media_type="images" 
       AND media_name = "1356121354_880611.jpg"
431. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 537
432. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 537
       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
433. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
434. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
435. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
436. 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
437. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
438. 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
439. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
440. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 537
441. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 537
       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 <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
444. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
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 = 537
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 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'
449. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 537
       AND ps.stockroom_id = s.stockroom_id
450. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 537
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
451. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
452. SELECT *
       FROM jos_menu
       WHERE id = '155'
453. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '537'
454. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '537'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
455. 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='70'
       AND c.category_id = cx.category_parent_id
456. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
457. 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=537
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
458. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 537
       AND ps.stockroom_id = s.stockroom_id
459. 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=537
       AND p.published = 1
       ORDER BY a.ordering ASC
460. 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'
461. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 537
462. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 537
       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
463. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
464. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
465. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
466. 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
467. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
468. 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
469. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
470. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 537
       AND ps.stockroom_id = s.stockroom_id
471. 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=537
       AND p.published = 1
       ORDER BY a.ordering ASC
472. 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'
473. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 537
474. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 537
       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
475. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
476. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
477. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
478. 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
479. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
480. 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
481. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 537
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
482. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
483. SELECT *
       FROM jos_menu
       WHERE id = '155'
484. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '547'
485. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '547'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
486. 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='70'
       AND c.category_id = cx.category_parent_id
487. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
488. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 547
489. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 547
       AND ps.stockroom_id = s.stockroom_id
490. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
491. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="547"
       AND media_type="images" 
       AND media_name = "1356124779_881021.jpg"
492. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 547
493. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 547
       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
494. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
495. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
496. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
497. 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
498. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
499. 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
500. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
501. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 547
502. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 547
       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
503. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
504. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
505. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
506. 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
507. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
508. 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
509. 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'
510. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 547
       AND ps.stockroom_id = s.stockroom_id
511. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 547
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
512. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
513. SELECT *
       FROM jos_menu
       WHERE id = '155'
514. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '547'
515. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '547'
       AND pc.category_id = c.category_id 
       AND c.category_id = '70'
516. 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='70'
       AND c.category_id = cx.category_parent_id
517. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '70'
518. 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=547
       AND p.published = 1
       AND a.attribute_required = 1
       ORDER BY a.ordering ASC
519. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 547
       AND ps.stockroom_id = s.stockroom_id
520. 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=547
       AND p.published = 1
       ORDER BY a.ordering ASC
521. 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'
522. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 547
523. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 547
       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
524. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
525. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
526. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
527. 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
528. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
529. 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
530. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
531. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 547
       AND ps.stockroom_id = s.stockroom_id
532. 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=547
       AND p.published = 1
       ORDER BY a.ordering ASC
533. 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'
534. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 547
535. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 547
       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
536. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
537. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1758224669'
       AND end_date >= '1758224669' 
       ORDER BY amount DESC
       LIMIT 0,1
538. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
539. 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
540. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
541. 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
542. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 547
       AND discount_enddate>='1758224669'
       AND discount_stratdate<='1758224669'
543. 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 = 155 OR mm.menuid = 0 )
       ORDER BY position, ordering
544. SELECT *
       FROM jos_menu
       WHERE id = '71'
545. SELECT *
       FROM jos_menu
       WHERE id = '222'
546. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
547. 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'
548. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
549. SELECT *
       FROM jos_menu
       WHERE id = '155'