Van Gogh

Profile Information

Memory Usage

466 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'pr3rtc1r0gvs098bmf55h6ff65'
2. DELETE
     FROM jos_session
     WHERE ( time < '1748625966' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'pr3rtc1r0gvs098bmf55h6ff65'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'pr3rtc1r0gvs098bmf55h6ff65','1748633166','','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-05-30'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'pr3rtc1r0gvs098bmf55h6ff65'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('pr3rtc1r0gvs098bmf55h6ff65', '0','1748633168')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'pr3rtc1r0gvs098bmf55h6ff65'
      AND section='category'
      AND section_id=''
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('pr3rtc1r0gvs098bmf55h6ff65','0','category','','1748633169')
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 = 189)
      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=138
      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
      WHERE category_id = 138
20. 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=138
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
21. 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=138
      AND p.published = 1
      AND p.expired = 0
      AND p.product_parent_id = 0
      ORDER BY p.product_name ASC
      LIMIT 0, 200
22. 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=138
      AND t.published = 1
      ORDER BY c.ordering ASC
      LIMIT 0,1
23. SELECT *
      FROM jos_redshop_category
      WHERE category_id = 138
24. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1
      AND id = '189'
25. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params NOT LIKE '%categoryid%'
26. SELECT *
      FROM jos_menu
      WHERE link LIKE '%com_redshop%'
      AND published=1 
      AND link LIKE '%view=category%' 
      AND params  LIKE '%categoryid=138
    %'
27. SELECT category_parent_id
      FROM jos_redshop_category_xref
      WHERE category_child_id=138
28. SELECT *
      FROM jos_menu
      WHERE id = '189'
29. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6293'
30. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6293'
      AND pc.category_id = c.category_id
31. 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='138'
      AND c.category_id = cx.category_parent_id
32. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '138'
33. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 6293
34. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 6293
      AND ps.stockroom_id = s.stockroom_id
35. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
36. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6293"
      AND media_type="images" 
      AND media_name = "1438582942_17110.jpg"
37. SELECT *
      FROM jos_menu
      WHERE id = '189'
38. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6294'
39. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6294'
      AND pc.category_id = c.category_id
40. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='138'
      AND c.category_id = cx.category_parent_id
41. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '138'
42. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 6294
43. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 6294
      AND ps.stockroom_id = s.stockroom_id
44. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
45. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6294"
      AND media_type="images" 
      AND media_name = "1438582981_17111.jpg"
46. SELECT *
      FROM jos_menu
      WHERE id = '189'
47. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6296'
48. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6296'
      AND pc.category_id = c.category_id
49. 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='138'
      AND c.category_id = cx.category_parent_id
50. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '138'
51. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 6296
52. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 6296
      AND ps.stockroom_id = s.stockroom_id
53. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
54. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6296"
      AND media_type="images" 
      AND media_name = "1438583051_17112.jpg"
55. SELECT *
      FROM jos_menu
      WHERE id = '189'
56. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6298'
57. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6298'
      AND pc.category_id = c.category_id
58. 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='138'
      AND c.category_id = cx.category_parent_id
59. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '138'
60. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 6298
61. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 6298
      AND ps.stockroom_id = s.stockroom_id
62. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
63. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6298"
      AND media_type="images" 
      AND media_name = "1438583092_17113.jpg"
64. SELECT *
      FROM jos_menu
      WHERE id = '189'
65. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6297'
66. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6297'
      AND pc.category_id = c.category_id
67. 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='138'
      AND c.category_id = cx.category_parent_id
68. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '138'
69. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 6297
70. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 6297
      AND ps.stockroom_id = s.stockroom_id
71. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
72. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6297"
      AND media_type="images" 
      AND media_name = "1438583086_17114.jpg"
73. SELECT *
      FROM jos_menu
      WHERE id = '189'
74. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6295'
75. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6295'
      AND pc.category_id = c.category_id
76. 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='138'
      AND c.category_id = cx.category_parent_id
77. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '138'
78. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 6295
79. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 6295
      AND ps.stockroom_id = s.stockroom_id
80. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
81. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6295"
      AND media_type="images"
82. SELECT *
      FROM jos_menu
      WHERE id = '189'
83. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6299'
84. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6299'
      AND pc.category_id = c.category_id
85. 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='138'
      AND c.category_id = cx.category_parent_id
86. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '138'
87. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 6299
88. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 6299
      AND ps.stockroom_id = s.stockroom_id
89. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
90. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6299"
      AND media_type="images" 
      AND media_name = "1438583118_17116.jpg"
91. SELECT *
      FROM jos_menu
      WHERE id = '189'
92. SELECT sef_url,product_name,cat_in_sefurl
      FROM jos_redshop_product
      WHERE product_id = '6300'
93. SELECT c.category_id
      FROM jos_redshop_category c,jos_redshop_product_category_xref pc
      WHERE pc.product_id = '6300'
      AND pc.category_id = c.category_id
94. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='138'
      AND c.category_id = cx.category_parent_id
95. SELECT category_name
      FROM jos_redshop_category
      WHERE category_id = '138'
96. SELECT * 
      FROM jos_redshop_product AS p 
      WHERE  p.product_id = 6300
97. SELECT sum(quantity) AS quantity 
      FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
      WHERE  ps.product_id = 6300
      AND ps.stockroom_id = s.stockroom_id
98. SELECT * 
      FROM jos_modules
      WHERE `module` LIKE 'mod_redmagicmagnifyplus'
      AND published  = 1
99. SELECT *
      FROM jos_redshop_media 
      WHERE media_section = "product"
      AND section_id ="6300"
      AND media_type="images" 
      AND media_name = "1438583173_17117.jpg"
100. SELECT *
       FROM jos_menu
       WHERE id = '189'
101. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6303'
102. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6303'
       AND pc.category_id = c.category_id
103. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='138'
       AND c.category_id = cx.category_parent_id
104. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
105. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6303
106. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6303
       AND ps.stockroom_id = s.stockroom_id
107. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
108. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6303"
       AND media_type="images" 
       AND media_name = "1438583297_17119.jpg"
109. SELECT *
       FROM jos_menu
       WHERE id = '189'
110. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6301'
111. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6301'
       AND pc.category_id = c.category_id
112. 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='138'
       AND c.category_id = cx.category_parent_id
113. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
114. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6301
115. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6301
       AND ps.stockroom_id = s.stockroom_id
116. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
117. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6301"
       AND media_type="images" 
       AND media_name = "1438583210_17120.jpg"
118. SELECT *
       FROM jos_menu
       WHERE id = '189'
119. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6304'
120. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6304'
       AND pc.category_id = c.category_id
121. 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='138'
       AND c.category_id = cx.category_parent_id
122. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
123. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6304
124. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6304
       AND ps.stockroom_id = s.stockroom_id
125. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
126. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6304"
       AND media_type="images" 
       AND media_name = "1438583308_17121.jpg"
127. SELECT *
       FROM jos_menu
       WHERE id = '189'
128. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6307'
129. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6307'
       AND pc.category_id = c.category_id
130. 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='138'
       AND c.category_id = cx.category_parent_id
131. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
132. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6307
133. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6307
       AND ps.stockroom_id = s.stockroom_id
134. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
135. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6307"
       AND media_type="images" 
       AND media_name = "1438583426_17122.jpg"
136. SELECT *
       FROM jos_menu
       WHERE id = '189'
137. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6302'
138. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6302'
       AND pc.category_id = c.category_id
139. 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='138'
       AND c.category_id = cx.category_parent_id
140. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
141. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6302
142. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6302
       AND ps.stockroom_id = s.stockroom_id
143. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
144. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6302"
       AND media_type="images" 
       AND media_name = "1438583289_17123.jpg"
145. SELECT *
       FROM jos_menu
       WHERE id = '189'
146. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6310'
147. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6310'
       AND pc.category_id = c.category_id
148. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='138'
       AND c.category_id = cx.category_parent_id
149. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
150. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6310
151. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6310
       AND ps.stockroom_id = s.stockroom_id
152. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
153. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6310"
       AND media_type="images" 
       AND media_name = "1438583553_17124.jpg"
154. SELECT *
       FROM jos_menu
       WHERE id = '189'
155. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6306'
156. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6306'
       AND pc.category_id = c.category_id
157. 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='138'
       AND c.category_id = cx.category_parent_id
158. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
159. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6306
160. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6306
       AND ps.stockroom_id = s.stockroom_id
161. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
162. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6306"
       AND media_type="images" 
       AND media_name = "1438583420_17125.jpg"
163. SELECT *
       FROM jos_menu
       WHERE id = '189'
164. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6305'
165. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6305'
       AND pc.category_id = c.category_id
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='138'
       AND c.category_id = cx.category_parent_id
167. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
168. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6305
169. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6305
       AND ps.stockroom_id = s.stockroom_id
170. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
171. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6305"
       AND media_type="images" 
       AND media_name = "1438583417_17126.jpg"
172. SELECT *
       FROM jos_menu
       WHERE id = '189'
173. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6308'
174. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6308'
       AND pc.category_id = c.category_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='138'
       AND c.category_id = cx.category_parent_id
176. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
177. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6308
178. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6308
       AND ps.stockroom_id = s.stockroom_id
179. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
180. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6308"
       AND media_type="images" 
       AND media_name = "1438583438_17127.jpg"
181. SELECT *
       FROM jos_menu
       WHERE id = '189'
182. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6309'
183. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6309'
       AND pc.category_id = c.category_id
184. 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='138'
       AND c.category_id = cx.category_parent_id
185. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
186. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6309
187. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6309
       AND ps.stockroom_id = s.stockroom_id
188. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
189. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6309"
       AND media_type="images" 
       AND media_name = "1438583460_17128.jpg"
190. SELECT *
       FROM jos_menu
       WHERE id = '189'
191. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6311'
192. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6311'
       AND pc.category_id = c.category_id
193. 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='138'
       AND c.category_id = cx.category_parent_id
194. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
195. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6311
196. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6311
       AND ps.stockroom_id = s.stockroom_id
197. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
198. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6311"
       AND media_type="images" 
       AND media_name = "1438583597_17129.jpg"
199. SELECT *
       FROM jos_menu
       WHERE id = '189'
200. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6312'
201. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6312'
       AND pc.category_id = c.category_id 
       AND c.category_id = '23'
202. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id=''
       AND c.category_id = cx.category_parent_id
203. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = ''
204. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6312
205. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6312
       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 ="6312"
       AND media_type="images" 
       AND media_name = "1438583766_17130.jpg"
208. SELECT *
       FROM jos_menu
       WHERE id = '189'
209. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6313'
210. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6313'
       AND pc.category_id = c.category_id
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='138'
       AND c.category_id = cx.category_parent_id
212. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
213. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6313
214. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6313
       AND ps.stockroom_id = s.stockroom_id
215. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
216. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6313"
       AND media_type="images" 
       AND media_name = "1438583768_17131.jpg"
217. SELECT *
       FROM jos_menu
       WHERE id = '189'
218. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6314'
219. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6314'
       AND pc.category_id = c.category_id
220. 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='138'
       AND c.category_id = cx.category_parent_id
221. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
222. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6314
223. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6314
       AND ps.stockroom_id = s.stockroom_id
224. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
225. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6314"
       AND media_type="images" 
       AND media_name = "1438583816_17140.jpg"
226. SELECT *
       FROM jos_menu
       WHERE id = '189'
227. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6315'
228. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6315'
       AND pc.category_id = c.category_id
229. 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='138'
       AND c.category_id = cx.category_parent_id
230. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
231. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6315
232. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6315
       AND ps.stockroom_id = s.stockroom_id
233. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
234. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6315"
       AND media_type="images" 
       AND media_name = "1438583828_17141.jpg"
235. SELECT *
       FROM jos_menu
       WHERE id = '189'
236. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6319'
237. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6319'
       AND pc.category_id = c.category_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='138'
       AND c.category_id = cx.category_parent_id
239. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
240. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6319
241. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6319
       AND ps.stockroom_id = s.stockroom_id
242. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
243. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6319"
       AND media_type="images" 
       AND media_name = "1438584010_17142.jpg"
244. SELECT *
       FROM jos_menu
       WHERE id = '189'
245. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6318'
246. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6318'
       AND pc.category_id = c.category_id
247. 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='138'
       AND c.category_id = cx.category_parent_id
248. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
249. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6318
250. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6318
       AND ps.stockroom_id = s.stockroom_id
251. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
252. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6318"
       AND media_type="images" 
       AND media_name = "1438583952_17143.jpg"
253. SELECT *
       FROM jos_menu
       WHERE id = '189'
254. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6322'
255. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6322'
       AND pc.category_id = c.category_id
256. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='138'
       AND c.category_id = cx.category_parent_id
257. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
258. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6322
259. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6322
       AND ps.stockroom_id = s.stockroom_id
260. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
261. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6322"
       AND media_type="images" 
       AND media_name = "1438584276_17150.jpg"
262. SELECT *
       FROM jos_menu
       WHERE id = '189'
263. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6320'
264. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6320'
       AND pc.category_id = c.category_id
265. 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='138'
       AND c.category_id = cx.category_parent_id
266. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
267. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6320
268. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6320
       AND ps.stockroom_id = s.stockroom_id
269. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
270. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6320"
       AND media_type="images" 
       AND media_name = "1438584037_17151.jpg"
271. SELECT *
       FROM jos_menu
       WHERE id = '189'
272. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6316'
273. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6316'
       AND pc.category_id = c.category_id
274. 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='138'
       AND c.category_id = cx.category_parent_id
275. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
276. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6316
277. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6316
       AND ps.stockroom_id = s.stockroom_id
278. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
279. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6316"
       AND media_type="images" 
       AND media_name = "1438583937_17152.jpg"
280. SELECT *
       FROM jos_menu
       WHERE id = '189'
281. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6317'
282. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6317'
       AND pc.category_id = c.category_id
283. 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='138'
       AND c.category_id = cx.category_parent_id
284. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
285. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6317
286. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6317
       AND ps.stockroom_id = s.stockroom_id
287. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
288. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6317"
       AND media_type="images" 
       AND media_name = "1438583944_17153.jpg"
289. SELECT *
       FROM jos_menu
       WHERE id = '189'
290. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6321'
291. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6321'
       AND pc.category_id = c.category_id
292. 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='138'
       AND c.category_id = cx.category_parent_id
293. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
294. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6321
295. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6321
       AND ps.stockroom_id = s.stockroom_id
296. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
297. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6321"
       AND media_type="images" 
       AND media_name = "1438584267_17160.jpg"
298. SELECT *
       FROM jos_menu
       WHERE id = '189'
299. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6323'
300. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6323'
       AND pc.category_id = c.category_id 
       AND c.category_id = '138'
301. 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='138'
       AND c.category_id = cx.category_parent_id
302. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
303. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6323
304. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6323
       AND ps.stockroom_id = s.stockroom_id
305. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
306. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6323"
       AND media_type="images" 
       AND media_name = "1438584287_17161.jpg"
307. SELECT *
       FROM jos_menu
       WHERE id = '189'
308. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6325'
309. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6325'
       AND pc.category_id = c.category_id
310. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='138'
       AND c.category_id = cx.category_parent_id
311. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
312. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6325
313. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6325
       AND ps.stockroom_id = s.stockroom_id
314. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
315. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6325"
       AND media_type="images" 
       AND media_name = "1438584328_17162.jpg"
316. SELECT *
       FROM jos_menu
       WHERE id = '189'
317. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6324'
318. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6324'
       AND pc.category_id = c.category_id
319. 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='138'
       AND c.category_id = cx.category_parent_id
320. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
321. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6324
322. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6324
       AND ps.stockroom_id = s.stockroom_id
323. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
324. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6324"
       AND media_type="images" 
       AND media_name = "1438584297_17163.jpg"
325. SELECT *
       FROM jos_menu
       WHERE id = '189'
326. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6326'
327. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6326'
       AND pc.category_id = c.category_id
328. 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='138'
       AND c.category_id = cx.category_parent_id
329. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
330. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6326
331. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6326
       AND ps.stockroom_id = s.stockroom_id
332. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
333. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6326"
       AND media_type="images" 
       AND media_name = "1438584420_17171.jpg"
334. SELECT *
       FROM jos_menu
       WHERE id = '189'
335. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6327'
336. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6327'
       AND pc.category_id = c.category_id
337. 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='138'
       AND c.category_id = cx.category_parent_id
338. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
339. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6327
340. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6327
       AND ps.stockroom_id = s.stockroom_id
341. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
342. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6327"
       AND media_type="images" 
       AND media_name = "1438584462_17172.jpg"
343. SELECT *
       FROM jos_menu
       WHERE id = '189'
344. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6328'
345. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6328'
       AND pc.category_id = c.category_id 
       AND c.category_id = '14'
346. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id=''
       AND c.category_id = cx.category_parent_id
347. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = ''
348. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6328
349. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6328
       AND ps.stockroom_id = s.stockroom_id
350. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
351. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6328"
       AND media_type="images" 
       AND media_name = "1438584572_17180.jpg"
352. SELECT *
       FROM jos_menu
       WHERE id = '189'
353. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6330'
354. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6330'
       AND pc.category_id = c.category_id
355. 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='138'
       AND c.category_id = cx.category_parent_id
356. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
357. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6330
358. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6330
       AND ps.stockroom_id = s.stockroom_id
359. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
360. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6330"
       AND media_type="images" 
       AND media_name = "1438584640_17181.jpg"
361. SELECT *
       FROM jos_menu
       WHERE id = '189'
362. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6329'
363. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6329'
       AND pc.category_id = c.category_id
364. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='138'
       AND c.category_id = cx.category_parent_id
365. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
366. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6329
367. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6329
       AND ps.stockroom_id = s.stockroom_id
368. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
369. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6329"
       AND media_type="images" 
       AND media_name = "1438584590_17182.jpg"
370. SELECT *
       FROM jos_menu
       WHERE id = '189'
371. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6331'
372. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6331'
       AND pc.category_id = c.category_id 
       AND c.category_id = '23'
373. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id=''
       AND c.category_id = cx.category_parent_id
374. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = ''
375. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6331
376. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6331
       AND ps.stockroom_id = s.stockroom_id
377. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
378. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6331"
       AND media_type="images" 
       AND media_name = "1438584674_17190.jpg"
379. SELECT *
       FROM jos_menu
       WHERE id = '189'
380. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6333'
381. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6333'
       AND pc.category_id = c.category_id
382. 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='138'
       AND c.category_id = cx.category_parent_id
383. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
384. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6333
385. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6333
       AND ps.stockroom_id = s.stockroom_id
386. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
387. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6333"
       AND media_type="images" 
       AND media_name = "1438584693_17191.jpg"
388. SELECT *
       FROM jos_menu
       WHERE id = '189'
389. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6332'
390. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6332'
       AND pc.category_id = c.category_id
391. 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='138'
       AND c.category_id = cx.category_parent_id
392. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
393. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6332
394. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6332
       AND ps.stockroom_id = s.stockroom_id
395. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
396. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6332"
       AND media_type="images" 
       AND media_name = "1438584681_17192.jpg"
397. SELECT *
       FROM jos_menu
       WHERE id = '189'
398. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6334'
399. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6334'
       AND pc.category_id = c.category_id
400. 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='138'
       AND c.category_id = cx.category_parent_id
401. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
402. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6334
403. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6334
       AND ps.stockroom_id = s.stockroom_id
404. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
405. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6334"
       AND media_type="images" 
       AND media_name = "1438584714_17200.jpg"
406. SELECT *
       FROM jos_menu
       WHERE id = '189'
407. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6335'
408. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6335'
       AND pc.category_id = c.category_id
409. 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='138'
       AND c.category_id = cx.category_parent_id
410. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
411. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6335
412. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6335
       AND ps.stockroom_id = s.stockroom_id
413. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
414. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6335"
       AND media_type="images" 
       AND media_name = "1438585018_17201.jpg"
415. SELECT *
       FROM jos_menu
       WHERE id = '189'
416. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6337'
417. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6337'
       AND pc.category_id = c.category_id
418. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='138'
       AND c.category_id = cx.category_parent_id
419. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
420. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6337
421. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6337
       AND ps.stockroom_id = s.stockroom_id
422. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
423. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6337"
       AND media_type="images" 
       AND media_name = "1438585062_17202.jpg"
424. SELECT *
       FROM jos_menu
       WHERE id = '189'
425. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6336'
426. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6336'
       AND pc.category_id = c.category_id
427. 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='138'
       AND c.category_id = cx.category_parent_id
428. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
429. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6336
430. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6336
       AND ps.stockroom_id = s.stockroom_id
431. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
432. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6336"
       AND media_type="images" 
       AND media_name = "1438585056_17203.jpg"
433. SELECT *
       FROM jos_menu
       WHERE id = '189'
434. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6339'
435. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6339'
       AND pc.category_id = c.category_id
436. 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='138'
       AND c.category_id = cx.category_parent_id
437. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
438. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6339
439. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6339
       AND ps.stockroom_id = s.stockroom_id
440. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
441. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6339"
       AND media_type="images" 
       AND media_name = "1438585158_17210.jpg"
442. SELECT *
       FROM jos_menu
       WHERE id = '189'
443. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6338'
444. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6338'
       AND pc.category_id = c.category_id
445. 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='138'
       AND c.category_id = cx.category_parent_id
446. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
447. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6338
448. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6338
       AND ps.stockroom_id = s.stockroom_id
449. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
450. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6338"
       AND media_type="images" 
       AND media_name = "1438585100_17211.jpg"
451. SELECT *
       FROM jos_menu
       WHERE id = '189'
452. SELECT sef_url,product_name,cat_in_sefurl
       FROM jos_redshop_product
       WHERE product_id = '6340'
453. SELECT c.category_id
       FROM jos_redshop_category c,jos_redshop_product_category_xref pc
       WHERE pc.product_id = '6340'
       AND pc.category_id = c.category_id
454. 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='138'
       AND c.category_id = cx.category_parent_id
455. SELECT category_name
       FROM jos_redshop_category
       WHERE category_id = '138'
456. SELECT * 
       FROM jos_redshop_product AS p 
       WHERE  p.product_id = 6340
457. SELECT sum(quantity) AS quantity 
       FROM jos_redshop_product_stockroom_xref AS ps , jos_redshop_stockroom AS s 
       WHERE  ps.product_id = 6340
       AND ps.stockroom_id = s.stockroom_id
458. SELECT * 
       FROM jos_modules
       WHERE `module` LIKE 'mod_redmagicmagnifyplus'
       AND published  = 1
459. SELECT *
       FROM jos_redshop_media 
       WHERE media_section = "product"
       AND section_id ="6340"
       AND media_type="images" 
       AND media_name = "1438585172_17212.jpg"
460. 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 = 189 OR mm.menuid = 0 )
       ORDER BY position, ordering
461. SELECT *
       FROM jos_menu
       WHERE id = '71'
462. SELECT *
       FROM jos_menu
       WHERE id = '222'
463. SELECT category_id      
       FROM jos_redshop_product_category_xref cx
       WHERE product_id = ''
464. 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'
465. SELECT category_id AS value,category_name AS text
       FROM jos_redshop_category
       WHERE published = 1
466. SELECT *
       FROM jos_menu
       WHERE id = '189'

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_btslideshow.ini 1
• /home/ontwall/public_html/language/en-GB/en-GB.mod_redshop_search.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None