Profile Information

Memory Usage

182 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '6d4u6pu6g9jtk62f5fn0racvk6'
2. DELETE
     FROM jos_session
     WHERE ( time < '1745076349' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '6d4u6pu6g9jtk62f5fn0racvk6'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '6d4u6pu6g9jtk62f5fn0racvk6','1745083549','','0','1','0' )
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT m.*, c.`option` AS component
     FROM jos_menu AS m
     LEFT JOIN jos_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT *
     FROM jos_redshop_configuration
9. SELECT *
     FROM jos_redshop_catalog_request
     WHERE block = 0
10. SELECT *
      FROM jos_redshop_sample_request
      WHERE block = 0
11. SELECT count(id)
      FROM jos_redshop_cron
      WHERE date = '2025-04-19'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = '6d4u6pu6g9jtk62f5fn0racvk6'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('6d4u6pu6g9jtk62f5fn0racvk6', '0','1745083552')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = '6d4u6pu6g9jtk62f5fn0racvk6'
      AND section='category'
      AND section_id='30'
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('6d4u6pu6g9jtk62f5fn0racvk6','0','category','30','1745083555')
16. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
17. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 222)
      ORDER BY menuid DESC
      LIMIT 0, 1
18. SELECT *
      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=30
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY c.ordering ASC
19. 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=30
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
20. 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=30
      AND published = 1
      ORDER BY c.category_name ASC
21. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '30'
22. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=30%')
      ORDER BY 'ordering'
23. SELECT *
      FROM jos_menu
      WHERE id = '222'
24. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '30'
25. 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='30'
      AND c.category_id = cx.category_parent_id
26. 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
27. 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=30
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 11, 15
28. 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=30
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
29. 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=30
      AND published = 1
      ORDER BY c.category_name ASC
30. SELECT *
      FROM jos_redshop_category
      WHERE category_id = '30'
31. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=30%')
      ORDER BY 'ordering'
32. SELECT *
      FROM jos_menu
      WHERE id = '222'
33. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '30'
34. 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='30'
      AND c.category_id = cx.category_parent_id
35. 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
36. 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=45
      AND p.published = 1
      ORDER BY a.ordering ASC
37. 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=45
      AND t.published = 1
      LIMIT 0,1
38. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
39. SELECT *
      FROM jos_menu
      WHERE id = '222'
40. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '45'
41. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '45'
      AND pc.category_id = c.category_id
42. 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='30'
      AND c.category_id = cx.category_parent_id
43. 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
44. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '30'
45. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
46. SELECT *
      FROM jos_redshop_fields_data
      WHERE fieldid='1'
      AND itemid='45'
      AND section='1'
47. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 45
48. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 45
      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
49. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
50. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1745083555'
      AND end_date >= '1745083555' 
      ORDER BY amount DESC
      LIMIT 0,1
51. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
52. 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
53. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
54. 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
55. 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'
56. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
57. 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
58. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
59. 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
60. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 45
      AND ps.stockroom_id = s.stockroom_id
61. SELECT p.* 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 45
      AND p.shopper_group_id = '0' 
      ORDER BY price_quantity_start ASC
62. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
      AND discount_enddate>='1745083555'
      AND discount_stratdate<='1745083555'
63. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 45
64. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 45
      AND ps.stockroom_id = s.stockroom_id
65. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
66. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="45"
      AND media_type="images" 
      AND media_name = "1301543869_CT4610-1.jpg"
67. SELECT *
      FROM jos_redshop_template
      WHERE template_section LIKE 'add_to_cart'
      AND published=1
68. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 45
      AND ps.stockroom_id = s.stockroom_id
69. 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'
70. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 45
71. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 45
      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
72. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
73. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1745083555'
      AND end_date >= '1745083555' 
      ORDER BY amount DESC
      LIMIT 0,1
74. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
75. 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
76. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
77. 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
78. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
      AND discount_enddate>='1745083555'
      AND discount_stratdate<='1745083555'
79. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 45
      AND ps.stockroom_id = s.stockroom_id
80. 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'
81. SELECT p.* 
      FROM jos_redshop_product AS p   
      WHERE  p.product_id = 45
82. SELECT p.price_id,p.product_price,p.product_currency 
      FROM jos_redshop_product_price AS p 
      WHERE  p.product_id = 45
      AND p.shopper_group_id = '0' 
      AND ( p.price_quantity_start <= '1'
      AND p.price_quantity_end >= '1' ) 
      ORDER BY price_quantity_start ASC
      LIMIT 0,1
83. SELECT *
      FROM jos_redshop_discount_product_shoppers AS ps
      WHERE ps.shopper_group_id ='0'
84. SELECT *
      FROM jos_redshop_discount_product 
      WHERE amount <= 0
      AND discount_product_id IN (0) 
      AND published =1
      AND start_date <= '1745083555'
      AND end_date >= '1745083555' 
      ORDER BY amount DESC
      LIMIT 0,1
85. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
86. SELECT sg.*
     
      FROM jos_redshop_shopper_group AS sg
     
      LEFT JOIN jos_redshop_users_info AS ui
      ON ui.shopper_group_id = sg.shopper_group_id
      WHERE ui.user_id = '0'
      LIMIT 0,1
87. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
88. SELECT tr.*
      FROM jos_redshop_tax_rate AS tr
      WHERE tr.tax_group_id = 1
      AND tr.tax_country="CAN"
      AND tr.tax_state = "ON"  
      ORDER BY `tax_rate` DESC
89. SELECT *
      FROM jos_redshop_product
      WHERE product_id = 45
      AND discount_enddate>='1745083555'
      AND discount_stratdate<='1745083555'
90. 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=46
      AND p.published = 1
      ORDER BY a.ordering ASC
91. 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=46
      AND t.published = 1
      LIMIT 0,1
92. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='12'
      AND field_name=''
      AND published=1
      AND field_show_in_front=1
93. SELECT *
      FROM jos_menu
      WHERE id = '222'
94. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '46'
95. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '46'
      AND pc.category_id = c.category_id
96. 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='30'
      AND c.category_id = cx.category_parent_id
97. 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
98. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '30'
99. SELECT *
      FROM jos_redshop_fields
      WHERE field_section='1'
      AND published=1
100. SELECT *
       FROM jos_redshop_fields_data
       WHERE fieldid='1'
       AND itemid='46'
       AND section='1'
101. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 46
102. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 46
       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
103. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
104. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745083555'
       AND end_date >= '1745083555' 
       ORDER BY amount DESC
       LIMIT 0,1
105. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
106. 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
107. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
108. 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
109. 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'
110. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
111. 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
112. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
113. 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
114. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 46
       AND ps.stockroom_id = s.stockroom_id
115. SELECT p.* 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 46
       AND p.shopper_group_id = '0' 
       ORDER BY price_quantity_start ASC
116. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
       AND discount_enddate>='1745083555'
       AND discount_stratdate<='1745083555'
117. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 46
118. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 46
       AND ps.stockroom_id = s.stockroom_id
119. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
120. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="46"
       AND media_type="images" 
       AND media_name = "1301543918_CT4611-1.jpg"
121. SELECT *
       FROM jos_redshop_template
       WHERE template_section LIKE 'add_to_cart'
       AND published=1
122. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 46
       AND ps.stockroom_id = s.stockroom_id
123. 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'
124. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 46
125. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 46
       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
126. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
127. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745083555'
       AND end_date >= '1745083555' 
       ORDER BY amount DESC
       LIMIT 0,1
128. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
129. 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
130. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
131. 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
132. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
       AND discount_enddate>='1745083555'
       AND discount_stratdate<='1745083555'
133. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 46
       AND ps.stockroom_id = s.stockroom_id
134. 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'
135. SELECT p.* 
       FROM jos_redshop_product AS p   
       WHERE  p.product_id = 46
136. SELECT p.price_id,p.product_price,p.product_currency 
       FROM jos_redshop_product_price AS p 
       WHERE  p.product_id = 46
       AND p.shopper_group_id = '0' 
       AND ( p.price_quantity_start <= '1'
       AND p.price_quantity_end >= '1' ) 
       ORDER BY price_quantity_start ASC
       LIMIT 0,1
137. SELECT *
       FROM jos_redshop_discount_product_shoppers AS ps
       WHERE ps.shopper_group_id ='0'
138. SELECT *
       FROM jos_redshop_discount_product 
       WHERE amount <= 0
       AND discount_product_id IN (0) 
       AND published =1
       AND start_date <= '1745083555'
       AND end_date >= '1745083555' 
       ORDER BY amount DESC
       LIMIT 0,1
139. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
140. SELECT sg.*
      
       FROM jos_redshop_shopper_group AS sg
      
       LEFT JOIN jos_redshop_users_info AS ui
       ON ui.shopper_group_id = sg.shopper_group_id
       WHERE ui.user_id = '0'
       LIMIT 0,1
141. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
142. SELECT tr.*
       FROM jos_redshop_tax_rate AS tr
       WHERE tr.tax_group_id = 1
       AND tr.tax_country="CAN"
       AND tr.tax_state = "ON"  
       ORDER BY `tax_rate` DESC
143. SELECT *
       FROM jos_redshop_product
       WHERE product_id = 46
       AND discount_enddate>='1745083555'
       AND discount_stratdate<='1745083555'
144. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 30
145. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1
       AND id = '222'
146. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params NOT LIKE '%categoryid%'
147. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=30
     %'
148. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 30
149. SELECT *
       FROM jos_menu
       WHERE id = '222'
150. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
151. 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='30'
       AND c.category_id = cx.category_parent_id
152. 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
153. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=30
154. SELECT *
       FROM jos_menu
       WHERE link LIKE '%com_redshop%'
       AND published=1 
       AND link LIKE '%view=category%' 
       AND params  LIKE '%categoryid=29
     %'
155. SELECT *
       FROM jos_redshop_category
       WHERE category_id = 29
156. SELECT *
       FROM jos_menu
       WHERE id = '222'
157. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '29'
158. 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
159. SELECT category_parent_id
       FROM jos_redshop_category_xref
       WHERE category_child_id=29
160. SELECT *
       FROM jos_menu
       WHERE id = '222'
161. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
162. 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='30'
       AND c.category_id = cx.category_parent_id
163. 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
164. SELECT *
       FROM jos_menu
       WHERE id = '222'
165. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
166. 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='30'
       AND c.category_id = cx.category_parent_id
167. 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
168. SELECT *
       FROM jos_menu
       WHERE id = '222'
169. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
170. 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='30'
       AND c.category_id = cx.category_parent_id
171. 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
172. SELECT *
       FROM jos_menu
       WHERE id = '222'
173. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '30'
174. 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='30'
       AND c.category_id = cx.category_parent_id
175. 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
176. 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
177. SELECT *
       FROM jos_menu
       WHERE id = '71'
178. SELECT *
       FROM jos_menu
       WHERE id = '222'
179. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
180. 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'
181. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
182. 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