Collections 2

Profile Information

Memory Usage

437 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '3hib66qlgf2dptfk1dqanu4494'
2. DELETE
     FROM jos_session
     WHERE ( time < '1754250970' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '3hib66qlgf2dptfk1dqanu4494'
4. UPDATE `jos_session`
     SET `time`='1754258170',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1754258138;s:18:\"session.timer.last\";i:1754258138;s:17:\"session.timer.now\";i:1754258138;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:65:\"/home/ontwall/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:7:\"visited\";a:1:{i:0;s:5:\"16690\";}}'
     WHERE session_id='3hib66qlgf2dptfk1dqanu4494'
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-08-03'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '3hib66qlgf2dptfk1dqanu4494'
13. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '3hib66qlgf2dptfk1dqanu4494'
      AND section='manufacturers'
      AND section_id='7'
14. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('3hib66qlgf2dptfk1dqanu4494','0','manufacturers','7','1754258173')
15. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
16. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
17. SELECT mn.*, m.media_name,m.section_id
      FROM  jos_redshop_manufacturer AS mn
      LEFT JOIN jos_redshop_media AS m
      ON m.section_id=mn.manufacturer_id
      AND m.published = 1
      AND m.media_section='manufacturer'
      WHERE mn.published = 1 
      AND mn.manufacturer_id='7'
18. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '222'
19. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=manufacturers%' 
      AND params  LIKE '%manufacturerid=7
    %'
20. SELECT *
      FROM jos_redshop_manufacturer
      WHERE manufacturer_id = 7
21. SELECT *
      FROM  jos_redshop_manufacturer
      WHERE published = 1
22. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=7
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_name ASC
23. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'manufacturer_products'
      AND published=1
      AND template_id='109'
      LIMIT 0,1
24. SELECT category_id AS value, category_name AS text
      FROM jos_redshop_category
      WHERE published = '1'
      ORDER BY category_name ASC
25. SELECT DISTINCT(p.product_id),p.product_number,p.product_name,p.product_price,p.product_s_desc,p.product_thumb_image,p.product_full_image , c.category_name
      FROM jos_redshop_product AS p , jos_redshop_manufacturer AS m , jos_redshop_category AS c , jos_redshop_product_category_xref AS pc
      WHERE p.published=1
      AND p.manufacturer_id=7
      AND p.manufacturer_id=m.manufacturer_id 
      AND p.product_id = pc.product_id 
      AND p.expired = 0 
      AND p.product_parent_id = 0 
      AND pc.category_id = c.category_id 
      GROUP BY p.product_id   
      ORDER BY p.product_name ASC
      LIMIT 15, 15
26. SELECT *
      FROM jos_menu
      WHERE id = '222'
27. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '27'
28. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '27'
      AND pc.category_id = c.category_id
29. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='31'
      AND c.category_id = cx.category_parent_id
30. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='29'
      AND c.category_id = cx.category_parent_id
31. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
32. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 27
33. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 27
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
34. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
35. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1754258174'
      AND end_date >= '1754258174' 
      ORDER BY amount DESC
      LIMIT 0,1
36. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 27
37. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
38. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 27
39. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
40. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
      FROM jos_redshop_users_info AS u
      LEFT JOIN jos_redshop_shopper_group AS sh
      ON sh.shopper_group_id=u.shopper_group_id
      WHERE u.user_id='0'
      AND u.address_type='BT'
41. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 27
42. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
43. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 27
44. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
45. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 27
      AND ps.stockroom_id = s.stockroom_id
46. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 27
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
47. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 27
      AND discount_enddate>='1754258174'
      AND discount_stratdate<='1754258174'
48. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 27
49. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 27
      AND ps.stockroom_id = s.stockroom_id
50. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
51. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="27"
      AND media_type="images" 
      AND media_name = "1301288336_CT3606-9.jpg"
52. SELECT *
      FROM jos_menu
      WHERE id = '222'
53. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '28'
54. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '28'
      AND pc.category_id = c.category_id
55. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='31'
      AND c.category_id = cx.category_parent_id
56. 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='29'
      AND c.category_id = cx.category_parent_id
57. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
58. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 28
59. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 28
      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
60. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
61. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1754258174'
      AND end_date >= '1754258174' 
      ORDER BY amount DESC
      LIMIT 0,1
62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 28
63. 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
64. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 28
65. 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
66. 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'
67. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 28
68. 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
69. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 28
70. 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
71. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 28
      AND ps.stockroom_id = s.stockroom_id
72. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 28
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
73. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 28
      AND discount_enddate>='1754258174'
      AND discount_stratdate<='1754258174'
74. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 28
75. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 28
      AND ps.stockroom_id = s.stockroom_id
76. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
77. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="28"
      AND media_type="images" 
      AND media_name = "1301288719_CT4707-6.jpg"
78. SELECT *
      FROM jos_menu
      WHERE id = '222'
79. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '29'
80. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '29'
      AND pc.category_id = c.category_id 
      AND c.category_id = '31'
81. 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='31'
      AND c.category_id = cx.category_parent_id
82. 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='29'
      AND c.category_id = cx.category_parent_id
83. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '31'
84. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 29
85. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 29
      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
86. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
87. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1754258174'
      AND end_date >= '1754258174' 
      ORDER BY amount DESC
      LIMIT 0,1
88. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 29
89. 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
90. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 29
91. 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
92. 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'
93. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 29
94. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
95. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 29
96. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
97. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 29
      AND ps.stockroom_id = s.stockroom_id
98. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 29
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
99. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 29
      AND discount_enddate>='1754258174'
      AND discount_stratdate<='1754258174'
100. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 29
101. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 29
       AND ps.stockroom_id = s.stockroom_id
102. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
103. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="29"
       AND media_type="images" 
       AND media_name = "1301288793_CT47501.jpg"
104. SELECT *
       FROM jos_menu
       WHERE id = '222'
105. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '30'
106. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '30'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
107. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='31'
       AND c.category_id = cx.category_parent_id
108. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
109. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
110. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 30
111. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 30
       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
112. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
113. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
114. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 30
115. 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
116. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 30
117. 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
118. 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'
119. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 30
120. 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
121. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 30
122. 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
123. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 30
       AND ps.stockroom_id = s.stockroom_id
124. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 30
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
125. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 30
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
126. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 30
127. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 30
       AND ps.stockroom_id = s.stockroom_id
128. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
129. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="30"
       AND media_type="images" 
       AND media_name = "1301288934_CT4751-1.jpg"
130. SELECT *
       FROM jos_menu
       WHERE id = '222'
131. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '31'
132. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '31'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
133. 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='31'
       AND c.category_id = cx.category_parent_id
134. 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='29'
       AND c.category_id = cx.category_parent_id
135. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
136. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 31
137. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 31
       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
138. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
139. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
140. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 31
141. 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
142. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 31
143. 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
144. 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'
145. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 31
146. 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
147. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 31
148. 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
149. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 31
       AND ps.stockroom_id = s.stockroom_id
150. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 31
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
151. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 31
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
152. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 31
153. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 31
       AND ps.stockroom_id = s.stockroom_id
154. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
155. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="31"
       AND media_type="images" 
       AND media_name = "1301289068_CT4753-1.jpg"
156. SELECT *
       FROM jos_menu
       WHERE id = '222'
157. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '32'
158. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '32'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
159. 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='31'
       AND c.category_id = cx.category_parent_id
160. 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='29'
       AND c.category_id = cx.category_parent_id
161. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
162. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 32
163. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 32
       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
164. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
165. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
166. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 32
167. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
168. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 32
169. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
170. SELECT 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'
171. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 32
172. 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
173. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 32
174. 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
175. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 32
       AND ps.stockroom_id = s.stockroom_id
176. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 32
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
177. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 32
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
178. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 32
179. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 32
       AND ps.stockroom_id = s.stockroom_id
180. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
181. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="32"
       AND media_type="images" 
       AND media_name = "1301289200_CT4754-1.jpg"
182. SELECT *
       FROM jos_menu
       WHERE id = '222'
183. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '33'
184. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '33'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
185. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='31'
       AND c.category_id = cx.category_parent_id
186. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
187. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
188. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 33
189. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 33
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
190. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
191. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
192. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 33
193. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
194. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 33
195. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
196. SELECT 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'
197. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 33
198. 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
199. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 33
200. 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
201. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 33
       AND ps.stockroom_id = s.stockroom_id
202. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 33
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
203. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 33
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
204. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 33
205. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 33
       AND ps.stockroom_id = s.stockroom_id
206. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
207. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="33"
       AND media_type="images" 
       AND media_name = "1301289466_CT4755-1.jpg"
208. SELECT *
       FROM jos_menu
       WHERE id = '222'
209. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '47'
210. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '47'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
211. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='31'
       AND c.category_id = cx.category_parent_id
212. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
213. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
214. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 47
215. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 47
       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
216. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
217. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
218. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 47
219. 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
220. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 47
221. 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
222. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
223. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 47
224. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
225. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 47
226. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
227. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 47
       AND ps.stockroom_id = s.stockroom_id
228. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 47
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
229. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 47
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
230. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 47
231. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 47
       AND ps.stockroom_id = s.stockroom_id
232. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
233. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="47"
       AND media_type="images" 
       AND media_name = "1301544336_CT4756-1.jpg"
234. SELECT *
       FROM jos_menu
       WHERE id = '222'
235. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '48'
236. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '48'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
237. 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='31'
       AND c.category_id = cx.category_parent_id
238. 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='29'
       AND c.category_id = cx.category_parent_id
239. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
240. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 48
241. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 48
       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
242. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
243. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
244. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 48
245. 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
246. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 48
247. 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
248. 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'
249. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 48
250. 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
251. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 48
252. 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
253. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 48
       AND ps.stockroom_id = s.stockroom_id
254. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 48
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
255. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 48
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
256. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 48
257. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 48
       AND ps.stockroom_id = s.stockroom_id
258. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
259. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="48"
       AND media_type="images" 
       AND media_name = "1301544506_CT4757-1.jpg"
260. SELECT *
       FROM jos_menu
       WHERE id = '222'
261. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '49'
262. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '49'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
263. 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='31'
       AND c.category_id = cx.category_parent_id
264. 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='29'
       AND c.category_id = cx.category_parent_id
265. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
266. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 49
267. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 49
       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
268. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
269. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
270. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 49
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 = 49
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 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'
275. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 49
276. 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
277. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 49
278. 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
279. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 49
       AND ps.stockroom_id = s.stockroom_id
280. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 49
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
281. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 49
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
282. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 49
283. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 49
       AND ps.stockroom_id = s.stockroom_id
284. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
285. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="49"
       AND media_type="images" 
       AND media_name = "1301544610_CT4758-1.jpg"
286. SELECT *
       FROM jos_menu
       WHERE id = '222'
287. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '50'
288. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '50'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
289. 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='31'
       AND c.category_id = cx.category_parent_id
290. 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='29'
       AND c.category_id = cx.category_parent_id
291. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
292. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 50
293. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 50
       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
294. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
295. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
296. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 50
297. 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
298. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 50
299. 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
300. 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'
301. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 50
302. 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
303. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 50
304. 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
305. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 50
       AND ps.stockroom_id = s.stockroom_id
306. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 50
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
307. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 50
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
308. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 50
309. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 50
       AND ps.stockroom_id = s.stockroom_id
310. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
311. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="50"
       AND media_type="images" 
       AND media_name = "1301544685_CT4759-1.jpg"
312. SELECT *
       FROM jos_menu
       WHERE id = '222'
313. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '51'
314. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '51'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
315. 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='31'
       AND c.category_id = cx.category_parent_id
316. 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='29'
       AND c.category_id = cx.category_parent_id
317. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
318. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 51
319. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 51
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
320. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
321. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
322. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 51
323. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
324. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 51
325. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
326. SELECT sh.tax_exempt AS shopper_tax_exempt,sh.*,u.*
       FROM jos_redshop_users_info AS u
       LEFT JOIN jos_redshop_shopper_group AS sh
       ON sh.shopper_group_id=u.shopper_group_id
       WHERE u.user_id='0'
       AND u.address_type='BT'
327. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 51
328. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
329. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 51
330. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
331. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 51
       AND ps.stockroom_id = s.stockroom_id
332. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 51
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
333. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 51
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
334. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 51
335. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 51
       AND ps.stockroom_id = s.stockroom_id
336. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
337. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="51"
       AND media_type="images" 
       AND media_name = "1301544769_CT4760-1.jpg"
338. SELECT *
       FROM jos_menu
       WHERE id = '222'
339. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '52'
340. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '52'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
341. 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='31'
       AND c.category_id = cx.category_parent_id
342. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
343. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
344. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 52
345. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 52
       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
346. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
347. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
348. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 52
349. 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
350. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 52
351. 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
352. 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'
353. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 52
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 = 52
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 sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 52
       AND ps.stockroom_id = s.stockroom_id
358. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 52
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
359. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 52
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
360. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 52
361. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 52
       AND ps.stockroom_id = s.stockroom_id
362. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
363. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="52"
       AND media_type="images" 
       AND media_name = "1301544875_CT4761-1.jpg"
364. SELECT *
       FROM jos_menu
       WHERE id = '222'
365. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '53'
366. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '53'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
367. 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='31'
       AND c.category_id = cx.category_parent_id
368. 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='29'
       AND c.category_id = cx.category_parent_id
369. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
370. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 53
371. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 53
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
372. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
373. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
374. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 53
375. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
376. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 53
377. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
378. SELECT 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'
379. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 53
380. 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
381. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 53
382. 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
383. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 53
       AND ps.stockroom_id = s.stockroom_id
384. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 53
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
385. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 53
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
386. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 53
387. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 53
       AND ps.stockroom_id = s.stockroom_id
388. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
389. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="53"
       AND media_type="images" 
       AND media_name = "1301544923_CT5840-8.jpg"
390. SELECT *
       FROM jos_menu
       WHERE id = '222'
391. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '54'
392. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '54'
       AND pc.category_id = c.category_id 
       AND c.category_id = '31'
393. 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='31'
       AND c.category_id = cx.category_parent_id
394. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
395. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '31'
396. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 54
397. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 54
       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
398. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
399. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1754258174'
       AND end_date >= '1754258174' 
       ORDER BY amount DESC
       LIMIT 0,1
400. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 54
401. 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
402. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 54
403. 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
404. 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'
405. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 54
406. 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
407. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 54
408. 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
409. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 54
       AND ps.stockroom_id = s.stockroom_id
410. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 54
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
411. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 54
       AND discount_enddate>='1754258174'
       AND discount_stratdate<='1754258174'
412. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 54
413. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 54
       AND ps.stockroom_id = s.stockroom_id
414. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
415. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="54"
       AND media_type="images" 
       AND media_name = "1301545040_CT5851-6.jpg"
416. SELECT *
       FROM jos_menu
       WHERE id = '222'
417. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '7'
418. SELECT *
       FROM jos_menu
       WHERE id = '222'
419. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '7'
420. SELECT *
       FROM jos_menu
       WHERE id = '222'
421. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '7'
422. SELECT *
       FROM jos_menu
       WHERE id = '222'
423. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '7'
424. SELECT *
       FROM jos_menu
       WHERE id = '222'
425. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '7'
426. SELECT *
       FROM jos_menu
       WHERE id = '222'
427. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '7'
428. SELECT *
       FROM jos_menu
       WHERE id = '222'
429. SELECT sef_url,manufacturer_name
       FROM jos_redshop_manufacturer
       WHERE manufacturer_id = '7'
430. SELECT *
       FROM jos_redshop_fields
       WHERE field_section='10'
       AND published=1 
       AND field_name IN ('manufacturer_name','manufacturer_image','manufacturer_description')
431. 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
432. SELECT *
       FROM jos_menu
       WHERE id = '71'
433. SELECT *
       FROM jos_menu
       WHERE id = '222'
434. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
435. 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'
436. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
437. SELECT *
       FROM jos_menu
       WHERE id = '222'

Language Files Loaded

• /home/ontwall/public_html/language/en-GB/en-GB.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.com_redshop.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.tpl_granit.ini
• /home/ontwall/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.mod_redshop_search.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None