Profile Information

Memory Usage

898 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '6dmn21prpaj7r3onjc06n005d5'
2. DELETE
     FROM jos_session
     WHERE ( time < '1753921488' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '6dmn21prpaj7r3onjc06n005d5'
4. UPDATE `jos_session`
     SET `time`='1753928688',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1753928682;s:18:\"session.timer.last\";i:1753928682;s:17:\"session.timer.now\";i:1753928682;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:{}}}'
     WHERE session_id='6dmn21prpaj7r3onjc06n005d5'
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-07-30'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '6dmn21prpaj7r3onjc06n005d5'
13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '6dmn21prpaj7r3onjc06n005d5'
      AND section='category'
      AND section_id='57'
14. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
15. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
16. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=57
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
17. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=57
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
18. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=57
      AND published = 1
      ORDER BY c.category_name ASC
19. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '57'
20. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=57%')
      ORDER BY 'ordering'
21. SELECT *
      FROM jos_menu
      WHERE id = '222'
22. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
23. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='57'
      AND c.category_id = cx.category_parent_id
24. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
25. SELECT *
      FROM jos_redshop_product AS p, jos_redshop_category AS c
      LEFT JOIN jos_redshop_product_category_xref AS pc
      ON pc.category_id=c.category_id
      WHERE p.product_id = pc.product_id
      AND pc.category_id=57
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 15, 15
26. SELECT *
      FROM jos_redshop_category AS c, jos_redshop_template AS t
      WHERE t.template_id = c.category_template
      AND t.template_section='category'
      AND c.category_id=57
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
27. SELECT *
      FROM  jos_redshop_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE cat_ref.category_child_id=c.category_id
      AND category_parent_id=57
      AND published = 1
      ORDER BY c.category_name ASC
28. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '57'
29. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=57%')
      ORDER BY 'ordering'
30. SELECT *
      FROM jos_menu
      WHERE id = '222'
31. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
32. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='57'
      AND c.category_id = cx.category_parent_id
33. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
34. 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=135
      AND p.published = 1
      ORDER BY a.ordering ASC
35. 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=135
      AND t.published = 1
      LIMIT 0,1
36. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
37. SELECT *
      FROM jos_menu
      WHERE id = '222'
38. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '135'
39. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '135'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
40. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='57'
      AND c.category_id = cx.category_parent_id
41. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
42. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
43. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
44. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='135'
      AND section='1'
45. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 135
46. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 135
      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
47. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
48. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928693'
      AND end_date >= '1753928693' 
      ORDER BY amount DESC
      LIMIT 0,1
49. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
50. 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
51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
52. 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
53. 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'
54. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
55. 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
56. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
57. 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
58. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 135
      AND ps.stockroom_id = s.stockroom_id
59. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 135
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
60. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
      AND discount_enddate>='1753928693'
      AND discount_stratdate<='1753928693'
61. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 135
62. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 135
      AND ps.stockroom_id = s.stockroom_id
63. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
64. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="135"
      AND media_type="images" 
      AND media_name = "1307731276_GIR3604-7.jpg"
65. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
66. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 135
      AND ps.stockroom_id = s.stockroom_id
67. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
68. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 135
69. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 135
      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
70. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
71. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928693'
      AND end_date >= '1753928693' 
      ORDER BY amount DESC
      LIMIT 0,1
72. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
73. 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
74. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
75. 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
76. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
      AND discount_enddate>='1753928693'
      AND discount_stratdate<='1753928693'
77. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 135
      AND ps.stockroom_id = s.stockroom_id
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 p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 135
80. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 135
      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
81. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
82. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1753928693'
      AND end_date >= '1753928693' 
      ORDER BY amount DESC
      LIMIT 0,1
83. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
84. 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
85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
86. 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
87. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 135
      AND discount_enddate>='1753928693'
      AND discount_stratdate<='1753928693'
88. 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=166
      AND p.published = 1
      ORDER BY a.ordering ASC
89. 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=166
      AND t.published = 1
      LIMIT 0,1
90. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
91. SELECT *
      FROM jos_menu
      WHERE id = '222'
92. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '166'
93. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '166'
      AND pc.category_id = c.category_id 
      AND c.category_id = '57'
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='57'
      AND c.category_id = cx.category_parent_id
95. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='56'
      AND c.category_id = cx.category_parent_id
96. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '57'
97. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
98. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='166'
      AND section='1'
99. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 166
100. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 166
       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
101. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
102. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
103. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
104. 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
105. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
106. 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
107. 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'
108. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
109. 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
110. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
111. 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
112. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 166
       AND ps.stockroom_id = s.stockroom_id
113. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 166
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
114. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
115. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 166
116. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 166
       AND ps.stockroom_id = s.stockroom_id
117. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
118. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="166"
       AND media_type="images" 
       AND media_name = "1308069513_GIR3606-15.jpg"
119. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
120. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 166
       AND ps.stockroom_id = s.stockroom_id
121. 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'
122. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 166
123. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 166
       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
124. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
125. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
126. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
127. 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
128. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
129. 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
130. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
131. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 166
       AND ps.stockroom_id = s.stockroom_id
132. 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'
133. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 166
134. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 166
       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
135. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
136. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
137. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
138. 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
139. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
140. 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
141. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 166
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
142. 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=169
       AND p.published = 1
       ORDER BY a.ordering ASC
143. 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=169
       AND t.published = 1
       LIMIT 0,1
144. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
145. SELECT *
       FROM jos_menu
       WHERE id = '222'
146. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '169'
147. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '169'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
148. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
149. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
150. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
151. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
152. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='169'
       AND section='1'
153. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 169
154. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 169
       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
155. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
156. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
157. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
158. 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
159. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
160. 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
161. 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'
162. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
163. 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
164. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
165. 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
166. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 169
       AND ps.stockroom_id = s.stockroom_id
167. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 169
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
168. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
169. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 169
170. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 169
       AND ps.stockroom_id = s.stockroom_id
171. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
172. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="169"
       AND media_type="images" 
       AND media_name = "1308070841_Simple Damask Grape.jpg"
173. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
174. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 169
       AND ps.stockroom_id = s.stockroom_id
175. 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'
176. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 169
177. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 169
       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
178. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
179. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
180. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
181. 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
182. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
183. 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
184. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
185. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 169
       AND ps.stockroom_id = s.stockroom_id
186. 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'
187. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 169
188. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 169
       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 <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
191. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 169
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 = 169
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 = 169
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
196. 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=172
       AND p.published = 1
       ORDER BY a.ordering ASC
197. 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=172
       AND t.published = 1
       LIMIT 0,1
198. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
199. SELECT *
       FROM jos_menu
       WHERE id = '222'
200. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '172'
201. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '172'
       AND pc.category_id = c.category_id
202. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
203. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
204. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
205. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
206. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='172'
       AND section='1'
207. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 172
208. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 172
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
209. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
210. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
211. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
212. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
213. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
214. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
215. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
216. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
217. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
218. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
219. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
220. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 172
       AND ps.stockroom_id = s.stockroom_id
221. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 172
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
222. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
223. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 172
224. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 172
       AND ps.stockroom_id = s.stockroom_id
225. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
226. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="172"
       AND media_type="images" 
       AND media_name = "1308075449_GU4707_5.jpg"
227. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
228. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 172
       AND ps.stockroom_id = s.stockroom_id
229. 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'
230. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 172
231. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 172
       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
232. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
233. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
234. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
235. 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
236. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
237. 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
238. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
239. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 172
       AND ps.stockroom_id = s.stockroom_id
240. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
241. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 172
242. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 172
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
243. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
244. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
245. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
246. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
247. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
248. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
249. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 172
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
250. 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=117
       AND p.published = 1
       ORDER BY a.ordering ASC
251. 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=117
       AND t.published = 1
       LIMIT 0,1
252. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
253. SELECT *
       FROM jos_menu
       WHERE id = '222'
254. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '117'
255. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '117'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
256. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
257. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
258. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
259. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
260. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='117'
       AND section='1'
261. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 117
262. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 117
       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
263. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
264. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
265. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
266. 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
267. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
268. 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
269. 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'
270. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
271. 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
272. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
273. 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
274. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 117
       AND ps.stockroom_id = s.stockroom_id
275. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 117
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
276. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
277. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 117
278. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 117
       AND ps.stockroom_id = s.stockroom_id
279. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
280. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="117"
       AND media_type="images" 
       AND media_name = "1307723884_GIR6618-21.jpg"
281. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
282. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 117
       AND ps.stockroom_id = s.stockroom_id
283. 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'
284. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 117
285. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 117
       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
286. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
287. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
288. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
289. 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
290. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
291. 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
292. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
293. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 117
       AND ps.stockroom_id = s.stockroom_id
294. 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'
295. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 117
296. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 117
       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
297. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
298. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
299. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
300. 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
301. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
302. 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
303. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 117
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
304. 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=177
       AND p.published = 1
       ORDER BY a.ordering ASC
305. 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=177
       AND t.published = 1
       LIMIT 0,1
306. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
307. SELECT *
       FROM jos_menu
       WHERE id = '222'
308. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '177'
309. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '177'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
310. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
311. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
312. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
313. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
314. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='177'
       AND section='1'
315. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 177
316. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 177
       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
317. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
318. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
319. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
320. 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
321. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
322. 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
323. 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'
324. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
325. 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
326. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
327. 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
328. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 177
       AND ps.stockroom_id = s.stockroom_id
329. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 177
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
330. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
331. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 177
332. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 177
       AND ps.stockroom_id = s.stockroom_id
333. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
334. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="177"
       AND media_type="images" 
       AND media_name = "1308078251_GIR7616-10.jpg"
335. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
336. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 177
       AND ps.stockroom_id = s.stockroom_id
337. 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'
338. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 177
339. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 177
       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
340. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
341. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
342. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
343. 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
344. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
345. 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
346. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
347. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 177
       AND ps.stockroom_id = s.stockroom_id
348. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
349. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 177
350. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 177
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
351. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
352. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
353. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
354. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
355. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
356. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
357. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 177
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
358. 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=102
       AND p.published = 1
       ORDER BY a.ordering ASC
359. 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=102
       AND t.published = 1
       LIMIT 0,1
360. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
361. SELECT *
       FROM jos_menu
       WHERE id = '222'
362. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '102'
363. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '102'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
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='57'
       AND c.category_id = cx.category_parent_id
365. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
366. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
367. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
368. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='102'
       AND section='1'
369. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 102
370. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 102
       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
371. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
372. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
373. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
374. 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
375. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
376. 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
377. 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'
378. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
379. 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
380. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
381. 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
382. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 102
       AND ps.stockroom_id = s.stockroom_id
383. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 102
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
384. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
385. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 102
386. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 102
       AND ps.stockroom_id = s.stockroom_id
387. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
388. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="102"
       AND media_type="images" 
       AND media_name = "1307633921_GIR7616-20.jpg"
389. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
390. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 102
       AND ps.stockroom_id = s.stockroom_id
391. 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'
392. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 102
393. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 102
       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
394. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
395. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
396. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
397. 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
398. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
399. 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
400. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
401. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 102
       AND ps.stockroom_id = s.stockroom_id
402. 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'
403. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 102
404. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 102
       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
405. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
406. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
407. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
408. 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
409. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
410. 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
411. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 102
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
412. 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=179
       AND p.published = 1
       ORDER BY a.ordering ASC
413. 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=179
       AND t.published = 1
       LIMIT 0,1
414. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
415. SELECT *
       FROM jos_menu
       WHERE id = '222'
416. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '179'
417. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '179'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
418. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
419. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
420. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
421. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
422. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='179'
       AND section='1'
423. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 179
424. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 179
       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
425. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
426. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
427. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
428. 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
429. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
430. 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
431. 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'
432. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
433. 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
434. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
435. 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
436. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 179
       AND ps.stockroom_id = s.stockroom_id
437. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 179
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
438. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
439. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 179
440. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 179
       AND ps.stockroom_id = s.stockroom_id
441. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
442. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="179"
       AND media_type="images" 
       AND media_name = "1308079399_GIR7616-21.jpg"
443. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
444. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 179
       AND ps.stockroom_id = s.stockroom_id
445. 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'
446. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 179
447. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 179
       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
448. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
449. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
450. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
451. 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
452. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
453. 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
454. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
455. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 179
       AND ps.stockroom_id = s.stockroom_id
456. 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'
457. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 179
458. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 179
       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
459. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
460. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
461. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
462. 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
463. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
464. 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
465. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 179
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
466. 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=165
       AND p.published = 1
       ORDER BY a.ordering ASC
467. 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=165
       AND t.published = 1
       LIMIT 0,1
468. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
469. SELECT *
       FROM jos_menu
       WHERE id = '222'
470. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '165'
471. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '165'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
472. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
473. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
474. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
475. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
476. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='165'
       AND section='1'
477. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 165
478. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 165
       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
479. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
480. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
481. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
482. 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
483. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
484. 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
485. 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'
486. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
487. 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
488. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
489. 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
490. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 165
       AND ps.stockroom_id = s.stockroom_id
491. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 165
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
492. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
493. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 165
494. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 165
       AND ps.stockroom_id = s.stockroom_id
495. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
496. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="165"
       AND media_type="images" 
       AND media_name = "1308068446_GIR9300-4.jpg"
497. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
498. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 165
       AND ps.stockroom_id = s.stockroom_id
499. 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'
500. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 165
501. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 165
       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
502. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
503. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
504. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
505. 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
506. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
507. 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
508. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
509. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 165
       AND ps.stockroom_id = s.stockroom_id
510. 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'
511. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 165
512. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 165
       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
513. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
514. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
515. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
516. 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
517. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
518. 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
519. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 165
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
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=168
       AND p.published = 1
       ORDER BY a.ordering ASC
521. 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=168
       AND t.published = 1
       LIMIT 0,1
522. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
523. SELECT *
       FROM jos_menu
       WHERE id = '222'
524. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '168'
525. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '168'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
526. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
527. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
528. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
529. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
530. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='168'
       AND section='1'
531. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 168
532. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 168
       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
533. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
534. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
535. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
536. 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
537. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
538. 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
539. 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'
540. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
541. 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
542. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
543. 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
544. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 168
       AND ps.stockroom_id = s.stockroom_id
545. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 168
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
546. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
547. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 168
548. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 168
       AND ps.stockroom_id = s.stockroom_id
549. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
550. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="168"
       AND media_type="images" 
       AND media_name = "1308070454_GIR9300-5.jpg"
551. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
552. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 168
       AND ps.stockroom_id = s.stockroom_id
553. 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'
554. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 168
555. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 168
       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
556. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
557. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
558. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
559. 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
560. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
561. 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
562. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
563. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 168
       AND ps.stockroom_id = s.stockroom_id
564. 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'
565. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 168
566. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 168
       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
567. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
568. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
569. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
570. 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
571. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
572. 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
573. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 168
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
574. 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=107
       AND p.published = 1
       ORDER BY a.ordering ASC
575. 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=107
       AND t.published = 1
       LIMIT 0,1
576. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
577. SELECT *
       FROM jos_menu
       WHERE id = '222'
578. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '107'
579. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '107'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
580. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
581. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
582. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
583. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
584. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='107'
       AND section='1'
585. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 107
586. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 107
       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
587. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
588. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
589. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
590. 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
591. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
592. 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
593. 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'
594. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
595. 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
596. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
597. 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
598. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 107
       AND ps.stockroom_id = s.stockroom_id
599. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 107
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
600. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
601. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 107
602. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 107
       AND ps.stockroom_id = s.stockroom_id
603. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
604. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="107"
       AND media_type="images" 
       AND media_name = "1307641215_GIR9310-11.jpg"
605. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
606. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 107
       AND ps.stockroom_id = s.stockroom_id
607. 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'
608. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 107
609. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 107
       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
610. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
611. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
612. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
613. 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
614. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
615. 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
616. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
617. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 107
       AND ps.stockroom_id = s.stockroom_id
618. 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'
619. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 107
620. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 107
       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
621. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
622. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
623. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
624. 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
625. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
626. 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
627. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 107
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
628. 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=130
       AND p.published = 1
       ORDER BY a.ordering ASC
629. 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=130
       AND t.published = 1
       LIMIT 0,1
630. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
631. SELECT *
       FROM jos_menu
       WHERE id = '222'
632. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '130'
633. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '130'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
634. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
635. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
636. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
637. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
638. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='130'
       AND section='1'
639. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 130
640. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 130
       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
641. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
642. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
643. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
644. 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
645. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
646. 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
647. 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'
648. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
649. 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
650. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
651. 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
652. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 130
       AND ps.stockroom_id = s.stockroom_id
653. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 130
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
654. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
655. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 130
656. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 130
       AND ps.stockroom_id = s.stockroom_id
657. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
658. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="130"
       AND media_type="images" 
       AND media_name = "1307728079_GIR9550-3.jpg"
659. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
660. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 130
       AND ps.stockroom_id = s.stockroom_id
661. 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'
662. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 130
663. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 130
       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
664. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
665. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
666. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
667. 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
668. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
669. 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
670. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
671. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 130
       AND ps.stockroom_id = s.stockroom_id
672. 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'
673. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 130
674. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 130
       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
675. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
676. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
677. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
678. 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
679. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
680. 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
681. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 130
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
682. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=125
       AND p.published = 1
       ORDER BY a.ordering ASC
683. 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=125
       AND t.published = 1
       LIMIT 0,1
684. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
685. SELECT *
       FROM jos_menu
       WHERE id = '222'
686. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '125'
687. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '125'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
688. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
689. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
690. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
691. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
692. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='125'
       AND section='1'
693. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 125
694. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 125
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
695. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
696. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
697. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
698. 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
699. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
700. 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
701. 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'
702. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
703. 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
704. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
705. 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
706. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 125
       AND ps.stockroom_id = s.stockroom_id
707. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 125
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
708. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
709. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 125
710. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 125
       AND ps.stockroom_id = s.stockroom_id
711. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
712. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="125"
       AND media_type="images" 
       AND media_name = "1307722919_GIR9550-4.jpg"
713. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
714. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 125
       AND ps.stockroom_id = s.stockroom_id
715. 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'
716. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 125
717. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 125
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
718. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
719. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
720. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
721. 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
722. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
723. 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
724. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
725. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 125
       AND ps.stockroom_id = s.stockroom_id
726. 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'
727. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 125
728. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 125
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
729. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
730. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
731. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
732. 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
733. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
734. 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
735. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 125
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
736. SELECT count(a.attribute_id)
       FROM jos_redshop_product AS p, jos_redshop_product_attribute AS a
       WHERE a.product_id = p.product_id
       AND p.product_id=123
       AND p.published = 1
       ORDER BY a.ordering ASC
737. 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=123
       AND t.published = 1
       LIMIT 0,1
738. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
739. SELECT *
       FROM jos_menu
       WHERE id = '222'
740. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '123'
741. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '123'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
742. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
743. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
744. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
745. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
746. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='123'
       AND section='1'
747. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 123
748. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 123
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
749. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
750. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
751. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
752. 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
753. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
754. 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
755. 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'
756. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
757. 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
758. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
759. 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
760. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 123
       AND ps.stockroom_id = s.stockroom_id
761. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 123
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
762. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
763. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 123
764. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 123
       AND ps.stockroom_id = s.stockroom_id
765. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
766. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="123"
       AND media_type="images" 
       AND media_name = "1307722013_GIR9550-6.jpg"
767. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
768. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 123
       AND ps.stockroom_id = s.stockroom_id
769. 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'
770. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 123
771. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 123
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
772. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
773. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
774. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
775. 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
776. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
777. 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
778. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
779. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 123
       AND ps.stockroom_id = s.stockroom_id
780. 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'
781. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 123
782. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 123
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
783. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
784. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
785. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
786. 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
787. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
788. 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
789. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 123
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
790. 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=113
       AND p.published = 1
       ORDER BY a.ordering ASC
791. 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=113
       AND t.published = 1
       LIMIT 0,1
792. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='12'
       AND field_name=''
       AND published=1
       AND field_show_in_front=1
793. SELECT *
       FROM jos_menu
       WHERE id = '222'
794. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '113'
795. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '113'
       AND pc.category_id = c.category_id 
       AND c.category_id = '57'
796. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
797. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
798. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
799. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='1'
       AND published=1
800. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='113'
       AND section='1'
801. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 113
802. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 113
       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
803. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
804. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
805. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
806. 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
807. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
808. 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
809. 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'
810. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
811. 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
812. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
813. 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
814. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 113
       AND ps.stockroom_id = s.stockroom_id
815. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 113
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
816. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
817. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 113
818. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 113
       AND ps.stockroom_id = s.stockroom_id
819. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
820. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="113"
       AND media_type="images" 
       AND media_name = "1307650456_GIR9551-1.jpg"
821. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
822. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 113
       AND ps.stockroom_id = s.stockroom_id
823. 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'
824. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 113
825. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 113
       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
826. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
827. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
828. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
829. 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
830. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
831. 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
832. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
833. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 113
       AND ps.stockroom_id = s.stockroom_id
834. 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'
835. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 113
836. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 113
       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
837. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
838. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1753928693'
       AND end_date >= '1753928693' 
       ORDER BY amount DESC
       LIMIT 0,1
839. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
840. 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
841. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
842. 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
843. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 113
       AND discount_enddate>='1753928693'
       AND discount_stratdate<='1753928693'
844. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 57
845. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '222'
846. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params NOT LIKE '%categoryid%'
847. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=57
     %'
848. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 57
849. SELECT *
       FROM jos_menu
       WHERE id = '222'
850. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
851. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
852. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
853. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=57
854. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=56
     %'
855. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 56
856. SELECT *
       FROM jos_menu
       WHERE id = '222'
857. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '56'
858. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
859. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=56
860. SELECT *
       FROM jos_menu
       WHERE id = '222'
861. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
862. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
863. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
864. SELECT *
       FROM jos_menu
       WHERE id = '222'
865. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
866. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
867. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
868. SELECT *
       FROM jos_menu
       WHERE id = '222'
869. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
870. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
871. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
872. SELECT *
       FROM jos_menu
       WHERE id = '222'
873. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
874. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
875. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
876. SELECT *
       FROM jos_menu
       WHERE id = '222'
877. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
878. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
879. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
880. SELECT *
       FROM jos_menu
       WHERE id = '222'
881. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
882. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
883. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
884. SELECT *
       FROM jos_menu
       WHERE id = '222'
885. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
886. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
887. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
888. SELECT *
       FROM jos_menu
       WHERE id = '222'
889. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '57'
890. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='57'
       AND c.category_id = cx.category_parent_id
891. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
892. SELECT id, title, module, position, content, showtitle, control, params
       FROM jos_modules AS m
       LEFT JOIN jos_modules_menu AS mm
       ON mm.moduleid = m.id
       WHERE m.published = 1
       AND m.access <= 0
       AND m.client_id = 0
       AND ( mm.menuid = 222 OR mm.menuid = 0 )
       ORDER BY position, ordering
893. SELECT *
       FROM jos_menu
       WHERE id = '71'
894. SELECT *
       FROM jos_menu
       WHERE id = '222'
895. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
896. 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'
897. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
898. SELECT *
       FROM jos_menu
       WHERE id = '222'