Collections 2

Profile Information

Memory Usage

1236 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'oebp7tv2jgcij6qf4bjuu51hp4'
2. DELETE
     FROM jos_session
     WHERE ( time < '1749753781' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'oebp7tv2jgcij6qf4bjuu51hp4'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'oebp7tv2jgcij6qf4bjuu51hp4','1749760981','','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-06-12'
12. SELECT *
      FROM jos_redshop_siteviewer
      WHERE session_id = 'oebp7tv2jgcij6qf4bjuu51hp4'
13. INSERT INTO jos_redshop_siteviewer (session_id, user_id, created_date)
      VALUES ('oebp7tv2jgcij6qf4bjuu51hp4', '0','1749760983')
14. SELECT *
      FROM jos_redshop_pageviewer
      WHERE session_id = 'oebp7tv2jgcij6qf4bjuu51hp4'
      AND section='category'
      AND section_id=''
15. INSERT INTO jos_redshop_pageviewer (session_id, user_id, section, section_id, created_date)
      VALUES ('oebp7tv2jgcij6qf4bjuu51hp4','0','category','','1749760986')
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_category AS c , jos_redshop_category_xref AS cat_ref
      WHERE category_child_id=c.category_id
      AND category_parent_id=0
      AND published = 1
      ORDER BY c.ordering ASC
19. SELECT *
      FROM  jos_redshop_template AS t
      WHERE t.template_section='frontpage_category'
      AND t.published = 1
      ORDER BY t.template_id 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=0
      AND published = 1
      ORDER BY c.category_name ASC
      LIMIT 0, 100
21. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=249%')
      ORDER BY 'ordering'
22. SELECT *
      FROM jos_menu
      WHERE id = '311'
23. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '249'
24. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='249'
      AND c.category_id = cx.category_parent_id
25. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(249,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
26. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
27. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=186%')
      ORDER BY 'ordering'
28. SELECT *
      FROM jos_menu
      WHERE id = '247'
29. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '186'
30. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
      FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
      WHERE cx.category_child_id='186'
      AND c.category_id = cx.category_parent_id
31. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(186,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
32. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
33. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=215%')
      ORDER BY 'ordering'
34. SELECT *
      FROM jos_menu
      WHERE id = '276'
35. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '215'
36. 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='215'
      AND c.category_id = cx.category_parent_id
37. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(215,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
38. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
39. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=164%')
      ORDER BY 'ordering'
40. SELECT *
      FROM jos_menu
      WHERE id = '224'
41. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '164'
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='164'
      AND c.category_id = cx.category_parent_id
43. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(164,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
44. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
45. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=268%')
      ORDER BY 'ordering'
46. SELECT *
      FROM jos_menu
      WHERE id = '330'
47. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '268'
48. 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='268'
      AND c.category_id = cx.category_parent_id
49. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(268,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
50. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
51. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=108%')
      ORDER BY 'ordering'
52. SELECT *
      FROM jos_menu
      WHERE id = '156'
53. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '108'
54. 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='108'
      AND c.category_id = cx.category_parent_id
55. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(108,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
56. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
57. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=177%')
      ORDER BY 'ordering'
58. SELECT *
      FROM jos_menu
      WHERE id = '236'
59. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '177'
60. 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='177'
      AND c.category_id = cx.category_parent_id
61. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(177,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
62. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
63. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=154%')
      ORDER BY 'ordering'
64. SELECT *
      FROM jos_menu
      WHERE id = '212'
65. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '154'
66. 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='154'
      AND c.category_id = cx.category_parent_id
67. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(154,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
68. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
69. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=105%')
      ORDER BY 'ordering'
70. SELECT *
      FROM jos_menu
      WHERE id = '141'
71. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '105'
72. 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='105'
      AND c.category_id = cx.category_parent_id
73. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(105,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
74. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
75. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=281%')
      ORDER BY 'ordering'
76. SELECT *
      FROM jos_menu
      WHERE id = '353'
77. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '281'
78. 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='281'
      AND c.category_id = cx.category_parent_id
79. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(281,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
80. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
81. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=168%')
      ORDER BY 'ordering'
82. SELECT *
      FROM jos_menu
      WHERE id = '228'
83. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '168'
84. 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='168'
      AND c.category_id = cx.category_parent_id
85. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(168,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
86. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
87. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=196%')
      ORDER BY 'ordering'
88. SELECT *
      FROM jos_menu
      WHERE id = '257'
89. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '196'
90. 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='196'
      AND c.category_id = cx.category_parent_id
91. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(196,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
92. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
93. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=141%')
      ORDER BY 'ordering'
94. SELECT *
      FROM jos_menu
      WHERE id = '195'
95. SELECT sef_url,category_name
      FROM jos_redshop_category
      WHERE category_id = '141'
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='141'
      AND c.category_id = cx.category_parent_id
97. SELECT count(*) AS total,sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
      AND FIND_IN_SET(141,sg.shopper_group_categories)
      GROUP BY sg.shopper_group_id
98. SELECT sg.*
      FROM `jos_redshop_shopper_group` AS sg 
      WHERE  sg.`shopper_group_id` = 0
99. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%com_redshop%'
      AND `link` LIKE '%view=category%'
      AND (`params` LIKE '%categoryid=62%')
      ORDER BY 'ordering'
100. SELECT *
       FROM jos_menu
       WHERE id = '222'
101. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '62'
102. 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='62'
       AND c.category_id = cx.category_parent_id
103. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(62,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
104. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
105. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=88%')
       ORDER BY 'ordering'
106. SELECT *
       FROM jos_menu
       WHERE id = '130'
107. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
108. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='88'
       AND c.category_id = cx.category_parent_id
109. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(88,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
110. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
111. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=192%')
       ORDER BY 'ordering'
112. SELECT *
       FROM jos_menu
       WHERE id = '253'
113. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '192'
114. 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='192'
       AND c.category_id = cx.category_parent_id
115. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(192,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
116. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
117. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=148%')
       ORDER BY 'ordering'
118. SELECT *
       FROM jos_menu
       WHERE id = '202'
119. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '148'
120. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='148'
       AND c.category_id = cx.category_parent_id
121. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(148,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
122. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
123. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=176%')
       ORDER BY 'ordering'
124. SELECT *
       FROM jos_menu
       WHERE id = '238'
125. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
126. 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='176'
       AND c.category_id = cx.category_parent_id
127. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(176,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
128. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
129. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=180%')
       ORDER BY 'ordering'
130. SELECT *
       FROM jos_menu
       WHERE id = '241'
131. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '180'
132. 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='180'
       AND c.category_id = cx.category_parent_id
133. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(180,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
134. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
135. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=170%')
       ORDER BY 'ordering'
136. SELECT *
       FROM jos_menu
       WHERE id = '230'
137. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '170'
138. 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='170'
       AND c.category_id = cx.category_parent_id
139. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(170,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
140. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
141. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=236%')
       ORDER BY 'ordering'
142. SELECT *
       FROM jos_menu
       WHERE id = '298'
143. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '236'
144. 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='236'
       AND c.category_id = cx.category_parent_id
145. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(236,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
146. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
147. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=247%')
       ORDER BY 'ordering'
148. SELECT *
       FROM jos_menu
       WHERE id = '309'
149. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '247'
150. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='247'
       AND c.category_id = cx.category_parent_id
151. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(247,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
152. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
153. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=82%')
       ORDER BY 'ordering'
154. SELECT *
       FROM jos_menu
       WHERE id = '132'
155. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '82'
156. 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='82'
       AND c.category_id = cx.category_parent_id
157. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(82,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
158. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
159. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=156%')
       ORDER BY 'ordering'
160. SELECT *
       FROM jos_menu
       WHERE id = '214'
161. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '156'
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='156'
       AND c.category_id = cx.category_parent_id
163. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(156,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
164. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
165. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=182%')
       ORDER BY 'ordering'
166. SELECT *
       FROM jos_menu
       WHERE id = '243'
167. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '182'
168. 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='182'
       AND c.category_id = cx.category_parent_id
169. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(182,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
170. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
171. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=117%')
       ORDER BY 'ordering'
172. SELECT *
       FROM jos_menu
       WHERE id = '166'
173. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '117'
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='117'
       AND c.category_id = cx.category_parent_id
175. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(117,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
176. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
177. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=243%')
       ORDER BY 'ordering'
178. SELECT *
       FROM jos_menu
       WHERE id = '306'
179. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '243'
180. 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='243'
       AND c.category_id = cx.category_parent_id
181. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(243,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
182. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
183. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=147%')
       ORDER BY 'ordering'
184. SELECT *
       FROM jos_menu
       WHERE id = '200'
185. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '147'
186. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='147'
       AND c.category_id = cx.category_parent_id
187. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(147,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
188. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
189. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=76%')
       ORDER BY 'ordering'
190. SELECT *
       FROM jos_menu
       WHERE id = '152'
191. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '76'
192. 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='76'
       AND c.category_id = cx.category_parent_id
193. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(76,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
194. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
195. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=146%')
       ORDER BY 'ordering'
196. SELECT *
       FROM jos_menu
       WHERE id = '201'
197. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '146'
198. 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='146'
       AND c.category_id = cx.category_parent_id
199. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(146,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
200. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
201. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=152%')
       ORDER BY 'ordering'
202. SELECT *
       FROM jos_menu
       WHERE id = '210'
203. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '152'
204. 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='152'
       AND c.category_id = cx.category_parent_id
205. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(152,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
206. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
207. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=221%')
       ORDER BY 'ordering'
208. SELECT *
       FROM jos_menu
       WHERE id = '282'
209. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '221'
210. 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='221'
       AND c.category_id = cx.category_parent_id
211. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(221,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
212. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
213. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=142%')
       ORDER BY 'ordering'
214. SELECT *
       FROM jos_menu
       WHERE id = '196'
215. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '142'
216. 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='142'
       AND c.category_id = cx.category_parent_id
217. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(142,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
218. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
219. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=64%')
       ORDER BY 'ordering'
220. SELECT *
       FROM jos_menu
       WHERE id = '143'
221. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '64'
222. 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='64'
       AND c.category_id = cx.category_parent_id
223. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(64,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
224. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
225. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=139%')
       ORDER BY 'ordering'
226. SELECT *
       FROM jos_menu
       WHERE id = '193'
227. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '139'
228. 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='139'
       AND c.category_id = cx.category_parent_id
229. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(139,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
230. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
231. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=163%')
       ORDER BY 'ordering'
232. SELECT *
       FROM jos_menu
       WHERE id = '221'
233. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '163'
234. 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='163'
       AND c.category_id = cx.category_parent_id
235. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(163,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
236. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
237. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=109%')
       ORDER BY 'ordering'
238. SELECT *
       FROM jos_menu
       WHERE id = '157'
239. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '109'
240. 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='109'
       AND c.category_id = cx.category_parent_id
241. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(109,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
242. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
243. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=248%')
       ORDER BY 'ordering'
244. SELECT *
       FROM jos_menu
       WHERE id = '310'
245. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '248'
246. 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='248'
       AND c.category_id = cx.category_parent_id
247. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(248,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
248. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
249. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=280%')
       ORDER BY 'ordering'
250. SELECT *
       FROM jos_menu
       WHERE id = '352'
251. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '280'
252. 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='280'
       AND c.category_id = cx.category_parent_id
253. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(280,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
254. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
255. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=184%')
       ORDER BY 'ordering'
256. SELECT *
       FROM jos_menu
       WHERE id = '245'
257. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '184'
258. 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='184'
       AND c.category_id = cx.category_parent_id
259. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(184,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
260. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
261. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=197%')
       ORDER BY 'ordering'
262. SELECT *
       FROM jos_menu
       WHERE id = '258'
263. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '197'
264. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='197'
       AND c.category_id = cx.category_parent_id
265. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(197,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
266. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
267. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=245%')
       ORDER BY 'ordering'
268. SELECT *
       FROM jos_menu
       WHERE id = '308'
269. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '245'
270. 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='245'
       AND c.category_id = cx.category_parent_id
271. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(245,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
272. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
273. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=90%')
       ORDER BY 'ordering'
274. SELECT *
       FROM jos_menu
       WHERE id = '124'
275. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '90'
276. 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='90'
       AND c.category_id = cx.category_parent_id
277. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(90,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
278. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
279. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=167%')
       ORDER BY 'ordering'
280. SELECT *
       FROM jos_menu
       WHERE id = '227'
281. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '167'
282. 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='167'
       AND c.category_id = cx.category_parent_id
283. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(167,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
284. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
285. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=29%')
       ORDER BY 'ordering'
286. SELECT *
       FROM jos_menu
       WHERE id = '222'
287. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '29'
288. 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
289. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(29,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
290. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
291. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=160%')
       ORDER BY 'ordering'
292. SELECT *
       FROM jos_menu
       WHERE id = '218'
293. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '160'
294. 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='160'
       AND c.category_id = cx.category_parent_id
295. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(160,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
296. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
297. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=119%')
       ORDER BY 'ordering'
298. SELECT *
       FROM jos_menu
       WHERE id = '168'
299. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '119'
300. 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='119'
       AND c.category_id = cx.category_parent_id
301. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(119,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
302. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
303. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=92%')
       ORDER BY 'ordering'
304. SELECT *
       FROM jos_menu
       WHERE id = '126'
305. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '92'
306. 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='92'
       AND c.category_id = cx.category_parent_id
307. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(92,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
308. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
309. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=143%')
       ORDER BY 'ordering'
310. SELECT *
       FROM jos_menu
       WHERE id = '198'
311. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '143'
312. 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='143'
       AND c.category_id = cx.category_parent_id
313. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(143,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
314. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
315. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=250%')
       ORDER BY 'ordering'
316. SELECT *
       FROM jos_menu
       WHERE id = '312'
317. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '250'
318. 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='250'
       AND c.category_id = cx.category_parent_id
319. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(250,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
320. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
321. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=71%')
       ORDER BY 'ordering'
322. SELECT *
       FROM jos_menu
       WHERE id = '145'
323. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
324. 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='71'
       AND c.category_id = cx.category_parent_id
325. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(71,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
326. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
327. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=93%')
       ORDER BY 'ordering'
328. SELECT *
       FROM jos_menu
       WHERE id = '127'
329. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '93'
330. 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='93'
       AND c.category_id = cx.category_parent_id
331. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(93,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
332. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
333. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=151%')
       ORDER BY 'ordering'
334. SELECT *
       FROM jos_menu
       WHERE id = '209'
335. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '151'
336. 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='151'
       AND c.category_id = cx.category_parent_id
337. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(151,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
338. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
339. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=131%')
       ORDER BY 'ordering'
340. SELECT *
       FROM jos_menu
       WHERE id = '182'
341. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '131'
342. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='131'
       AND c.category_id = cx.category_parent_id
343. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(131,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
344. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
345. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=198%')
       ORDER BY 'ordering'
346. SELECT *
       FROM jos_menu
       WHERE id = '259'
347. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '198'
348. 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='198'
       AND c.category_id = cx.category_parent_id
349. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(198,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
350. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
351. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=110%')
       ORDER BY 'ordering'
352. SELECT *
       FROM jos_menu
       WHERE id = '158'
353. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '110'
354. 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='110'
       AND c.category_id = cx.category_parent_id
355. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(110,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
356. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
357. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=69%')
       ORDER BY 'ordering'
358. SELECT *
       FROM jos_menu
       WHERE id = '146'
359. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '69'
360. 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='69'
       AND c.category_id = cx.category_parent_id
361. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(69,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
362. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
363. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=124%')
       ORDER BY 'ordering'
364. SELECT *
       FROM jos_menu
       WHERE id = '173'
365. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '124'
366. 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='124'
       AND c.category_id = cx.category_parent_id
367. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(124,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
368. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
369. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=155%')
       ORDER BY 'ordering'
370. SELECT *
       FROM jos_menu
       WHERE id = '213'
371. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '155'
372. 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='155'
       AND c.category_id = cx.category_parent_id
373. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(155,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
374. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
375. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=272%')
       ORDER BY 'ordering'
376. SELECT *
       FROM jos_menu
       WHERE id = '340'
377. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '272'
378. 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='272'
       AND c.category_id = cx.category_parent_id
379. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(272,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
380. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
381. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=199%')
       ORDER BY 'ordering'
382. SELECT *
       FROM jos_menu
       WHERE id = '260'
383. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '199'
384. 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='199'
       AND c.category_id = cx.category_parent_id
385. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(199,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
386. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
387. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=269%')
       ORDER BY 'ordering'
388. SELECT *
       FROM jos_menu
       WHERE id = '331'
389. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '269'
390. 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='269'
       AND c.category_id = cx.category_parent_id
391. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(269,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
392. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
393. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=74%')
       ORDER BY 'ordering'
394. SELECT *
       FROM jos_menu
       WHERE id = '151'
395. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '74'
396. 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='74'
       AND c.category_id = cx.category_parent_id
397. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(74,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
398. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
399. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=195%')
       ORDER BY 'ordering'
400. SELECT *
       FROM jos_menu
       WHERE id = '256'
401. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '195'
402. 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='195'
       AND c.category_id = cx.category_parent_id
403. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(195,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
404. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
405. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=277%')
       ORDER BY 'ordering'
406. SELECT *
       FROM jos_menu
       WHERE id = '348'
407. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '277'
408. 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='277'
       AND c.category_id = cx.category_parent_id
409. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(277,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
410. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
411. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=273%')
       ORDER BY 'ordering'
412. SELECT *
       FROM jos_menu
       WHERE id = '341'
413. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '273'
414. 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='273'
       AND c.category_id = cx.category_parent_id
415. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(273,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
416. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
417. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=208%')
       ORDER BY 'ordering'
418. SELECT *
       FROM jos_menu
       WHERE id = '269'
419. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '208'
420. 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='208'
       AND c.category_id = cx.category_parent_id
421. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(208,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
422. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
423. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=222%')
       ORDER BY 'ordering'
424. SELECT *
       FROM jos_menu
       WHERE id = '283'
425. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '222'
426. 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='222'
       AND c.category_id = cx.category_parent_id
427. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(222,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
428. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
429. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=194%')
       ORDER BY 'ordering'
430. SELECT *
       FROM jos_menu
       WHERE id = '255'
431. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '194'
432. 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='194'
       AND c.category_id = cx.category_parent_id
433. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(194,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
434. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
435. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=270%')
       ORDER BY 'ordering'
436. SELECT *
       FROM jos_menu
       WHERE id = '332'
437. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '270'
438. 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='270'
       AND c.category_id = cx.category_parent_id
439. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(270,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
440. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
441. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=132%')
       ORDER BY 'ordering'
442. SELECT *
       FROM jos_menu
       WHERE id = '183'
443. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '132'
444. 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='132'
       AND c.category_id = cx.category_parent_id
445. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(132,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
446. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
447. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=73%')
       ORDER BY 'ordering'
448. SELECT *
       FROM jos_menu
       WHERE id = '150'
449. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '73'
450. 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='73'
       AND c.category_id = cx.category_parent_id
451. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(73,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
452. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
453. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=102%')
       ORDER BY 'ordering'
454. SELECT *
       FROM jos_menu
       WHERE id = '119'
455. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '102'
456. 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='102'
       AND c.category_id = cx.category_parent_id
457. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(102,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
458. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
459. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=191%')
       ORDER BY 'ordering'
460. SELECT *
       FROM jos_menu
       WHERE id = '252'
461. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '191'
462. 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='191'
       AND c.category_id = cx.category_parent_id
463. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(191,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
464. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
465. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=209%')
       ORDER BY 'ordering'
466. SELECT *
       FROM jos_menu
       WHERE id = '270'
467. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '209'
468. 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='209'
       AND c.category_id = cx.category_parent_id
469. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(209,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
470. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
471. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=251%')
       ORDER BY 'ordering'
472. SELECT *
       FROM jos_menu
       WHERE id = '313'
473. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '251'
474. 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='251'
       AND c.category_id = cx.category_parent_id
475. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(251,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
476. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
477. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=210%')
       ORDER BY 'ordering'
478. SELECT *
       FROM jos_menu
       WHERE id = '271'
479. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '210'
480. 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='210'
       AND c.category_id = cx.category_parent_id
481. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(210,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
482. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
483. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=219%')
       ORDER BY 'ordering'
484. SELECT *
       FROM jos_menu
       WHERE id = '280'
485. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '219'
486. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='219'
       AND c.category_id = cx.category_parent_id
487. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(219,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
488. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
489. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=223%')
       ORDER BY 'ordering'
490. SELECT *
       FROM jos_menu
       WHERE id = '284'
491. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '223'
492. 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='223'
       AND c.category_id = cx.category_parent_id
493. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(223,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
494. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
495. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=276%')
       ORDER BY 'ordering'
496. SELECT *
       FROM jos_menu
       WHERE id = '347'
497. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '276'
498. 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='276'
       AND c.category_id = cx.category_parent_id
499. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(276,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
500. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
501. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=78%')
       ORDER BY 'ordering'
502. SELECT *
       FROM jos_menu
       WHERE id = '137'
503. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '78'
504. 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='78'
       AND c.category_id = cx.category_parent_id
505. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(78,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
506. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
507. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=185%')
       ORDER BY 'ordering'
508. SELECT *
       FROM jos_menu
       WHERE id = '246'
509. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '185'
510. 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='185'
       AND c.category_id = cx.category_parent_id
511. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(185,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
512. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
513. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=120%')
       ORDER BY 'ordering'
514. SELECT *
       FROM jos_menu
       WHERE id = '169'
515. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '120'
516. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='120'
       AND c.category_id = cx.category_parent_id
517. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(120,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
518. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
519. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=252%')
       ORDER BY 'ordering'
520. SELECT *
       FROM jos_menu
       WHERE id = '314'
521. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '252'
522. 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='252'
       AND c.category_id = cx.category_parent_id
523. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(252,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
524. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
525. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=126%')
       ORDER BY 'ordering'
526. SELECT *
       FROM jos_menu
       WHERE id = '179'
527. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '126'
528. 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='126'
       AND c.category_id = cx.category_parent_id
529. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(126,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
530. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
531. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=253%')
       ORDER BY 'ordering'
532. SELECT *
       FROM jos_menu
       WHERE id = '315'
533. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '253'
534. 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='253'
       AND c.category_id = cx.category_parent_id
535. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(253,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
536. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
537. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=99%')
       ORDER BY 'ordering'
538. SELECT *
       FROM jos_menu
       WHERE id = '138'
539. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '99'
540. 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='99'
       AND c.category_id = cx.category_parent_id
541. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(99,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
542. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
543. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=226%')
       ORDER BY 'ordering'
544. SELECT *
       FROM jos_menu
       WHERE id = '287'
545. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '226'
546. 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='226'
       AND c.category_id = cx.category_parent_id
547. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(226,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
548. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
549. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=254%')
       ORDER BY 'ordering'
550. SELECT *
       FROM jos_menu
       WHERE id = '316'
551. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '254'
552. 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='254'
       AND c.category_id = cx.category_parent_id
553. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(254,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
554. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
555. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=211%')
       ORDER BY 'ordering'
556. SELECT *
       FROM jos_menu
       WHERE id = '272'
557. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '211'
558. 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='211'
       AND c.category_id = cx.category_parent_id
559. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(211,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
560. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
561. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=56%')
       ORDER BY 'ordering'
562. SELECT *
       FROM jos_menu
       WHERE id = '222'
563. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '56'
564. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='56'
       AND c.category_id = cx.category_parent_id
565. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(56,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
566. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
567. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=86%')
       ORDER BY 'ordering'
568. SELECT *
       FROM jos_menu
       WHERE id = '128'
569. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '86'
570. 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='86'
       AND c.category_id = cx.category_parent_id
571. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(86,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
572. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
573. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=158%')
       ORDER BY 'ordering'
574. SELECT *
       FROM jos_menu
       WHERE id = '216'
575. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '158'
576. 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='158'
       AND c.category_id = cx.category_parent_id
577. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(158,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
578. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
579. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=72%')
       ORDER BY 'ordering'
580. SELECT *
       FROM jos_menu
       WHERE id = '153'
581. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '72'
582. 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='72'
       AND c.category_id = cx.category_parent_id
583. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(72,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
584. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
585. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=111%')
       ORDER BY 'ordering'
586. SELECT *
       FROM jos_menu
       WHERE id = '159'
587. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '111'
588. 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='111'
       AND c.category_id = cx.category_parent_id
589. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(111,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
590. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
591. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=55%')
       ORDER BY 'ordering'
592. SELECT *
       FROM jos_menu
       WHERE id = '222'
593. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '55'
594. 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='55'
       AND c.category_id = cx.category_parent_id
595. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(55,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
596. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
597. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=104%')
       ORDER BY 'ordering'
598. SELECT *
       FROM jos_menu
       WHERE id = '139'
599. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '104'
600. 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='104'
       AND c.category_id = cx.category_parent_id
601. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(104,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
602. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
603. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=107%')
       ORDER BY 'ordering'
604. SELECT *
       FROM jos_menu
       WHERE id = '140'
605. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '107'
606. 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='107'
       AND c.category_id = cx.category_parent_id
607. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(107,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
608. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
609. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=54%')
       ORDER BY 'ordering'
610. SELECT *
       FROM jos_menu
       WHERE id = '222'
611. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '54'
612. 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='54'
       AND c.category_id = cx.category_parent_id
613. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(54,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
614. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
615. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=121%')
       ORDER BY 'ordering'
616. SELECT *
       FROM jos_menu
       WHERE id = '170'
617. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '121'
618. 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='121'
       AND c.category_id = cx.category_parent_id
619. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(121,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
620. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
621. 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=0
       AND p.published = 1
       AND p.expired = 0
       AND p.product_parent_id = 0
       ORDER BY p.product_name ASC
       LIMIT 0, 100
622. SELECT *
       FROM  jos_redshop_template AS t
       WHERE t.template_section='frontpage_category'
       AND t.published = 1
       ORDER BY t.template_id ASC
       LIMIT 0,1
623. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=249%')
       ORDER BY 'ordering'
624. SELECT *
       FROM jos_menu
       WHERE id = '311'
625. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '249'
626. 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='249'
       AND c.category_id = cx.category_parent_id
627. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(249,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
628. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
629. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=186%')
       ORDER BY 'ordering'
630. SELECT *
       FROM jos_menu
       WHERE id = '247'
631. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '186'
632. 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='186'
       AND c.category_id = cx.category_parent_id
633. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(186,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
634. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
635. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=215%')
       ORDER BY 'ordering'
636. SELECT *
       FROM jos_menu
       WHERE id = '276'
637. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '215'
638. 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='215'
       AND c.category_id = cx.category_parent_id
639. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(215,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
640. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
641. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=164%')
       ORDER BY 'ordering'
642. SELECT *
       FROM jos_menu
       WHERE id = '224'
643. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '164'
644. 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='164'
       AND c.category_id = cx.category_parent_id
645. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(164,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
646. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
647. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=268%')
       ORDER BY 'ordering'
648. SELECT *
       FROM jos_menu
       WHERE id = '330'
649. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '268'
650. 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='268'
       AND c.category_id = cx.category_parent_id
651. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(268,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
652. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
653. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=108%')
       ORDER BY 'ordering'
654. SELECT *
       FROM jos_menu
       WHERE id = '156'
655. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '108'
656. 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='108'
       AND c.category_id = cx.category_parent_id
657. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(108,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
658. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
659. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=177%')
       ORDER BY 'ordering'
660. SELECT *
       FROM jos_menu
       WHERE id = '236'
661. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '177'
662. 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='177'
       AND c.category_id = cx.category_parent_id
663. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(177,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
664. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
665. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=154%')
       ORDER BY 'ordering'
666. SELECT *
       FROM jos_menu
       WHERE id = '212'
667. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '154'
668. 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='154'
       AND c.category_id = cx.category_parent_id
669. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(154,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
670. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
671. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=105%')
       ORDER BY 'ordering'
672. SELECT *
       FROM jos_menu
       WHERE id = '141'
673. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '105'
674. 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='105'
       AND c.category_id = cx.category_parent_id
675. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(105,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
676. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
677. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=281%')
       ORDER BY 'ordering'
678. SELECT *
       FROM jos_menu
       WHERE id = '353'
679. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '281'
680. 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='281'
       AND c.category_id = cx.category_parent_id
681. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(281,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
682. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
683. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=168%')
       ORDER BY 'ordering'
684. SELECT *
       FROM jos_menu
       WHERE id = '228'
685. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '168'
686. 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='168'
       AND c.category_id = cx.category_parent_id
687. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(168,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
688. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
689. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=196%')
       ORDER BY 'ordering'
690. SELECT *
       FROM jos_menu
       WHERE id = '257'
691. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '196'
692. 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='196'
       AND c.category_id = cx.category_parent_id
693. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(196,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
694. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
695. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=141%')
       ORDER BY 'ordering'
696. SELECT *
       FROM jos_menu
       WHERE id = '195'
697. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '141'
698. 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='141'
       AND c.category_id = cx.category_parent_id
699. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(141,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
700. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
701. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=62%')
       ORDER BY 'ordering'
702. SELECT *
       FROM jos_menu
       WHERE id = '222'
703. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '62'
704. 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='62'
       AND c.category_id = cx.category_parent_id
705. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(62,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
706. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
707. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=88%')
       ORDER BY 'ordering'
708. SELECT *
       FROM jos_menu
       WHERE id = '130'
709. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '88'
710. 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='88'
       AND c.category_id = cx.category_parent_id
711. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(88,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
712. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
713. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=192%')
       ORDER BY 'ordering'
714. SELECT *
       FROM jos_menu
       WHERE id = '253'
715. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '192'
716. 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='192'
       AND c.category_id = cx.category_parent_id
717. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(192,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
718. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
719. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=148%')
       ORDER BY 'ordering'
720. SELECT *
       FROM jos_menu
       WHERE id = '202'
721. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '148'
722. 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='148'
       AND c.category_id = cx.category_parent_id
723. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(148,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
724. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
725. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=176%')
       ORDER BY 'ordering'
726. SELECT *
       FROM jos_menu
       WHERE id = '238'
727. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '176'
728. 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='176'
       AND c.category_id = cx.category_parent_id
729. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(176,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
730. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
731. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=180%')
       ORDER BY 'ordering'
732. SELECT *
       FROM jos_menu
       WHERE id = '241'
733. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '180'
734. 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='180'
       AND c.category_id = cx.category_parent_id
735. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(180,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
736. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
737. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=170%')
       ORDER BY 'ordering'
738. SELECT *
       FROM jos_menu
       WHERE id = '230'
739. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '170'
740. 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='170'
       AND c.category_id = cx.category_parent_id
741. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(170,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
742. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
743. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=236%')
       ORDER BY 'ordering'
744. SELECT *
       FROM jos_menu
       WHERE id = '298'
745. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '236'
746. 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='236'
       AND c.category_id = cx.category_parent_id
747. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(236,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
748. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
749. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=247%')
       ORDER BY 'ordering'
750. SELECT *
       FROM jos_menu
       WHERE id = '309'
751. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '247'
752. 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='247'
       AND c.category_id = cx.category_parent_id
753. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(247,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
754. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
755. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=82%')
       ORDER BY 'ordering'
756. SELECT *
       FROM jos_menu
       WHERE id = '132'
757. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '82'
758. 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='82'
       AND c.category_id = cx.category_parent_id
759. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(82,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
760. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
761. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=156%')
       ORDER BY 'ordering'
762. SELECT *
       FROM jos_menu
       WHERE id = '214'
763. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '156'
764. 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='156'
       AND c.category_id = cx.category_parent_id
765. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(156,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
766. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
767. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=182%')
       ORDER BY 'ordering'
768. SELECT *
       FROM jos_menu
       WHERE id = '243'
769. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '182'
770. 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='182'
       AND c.category_id = cx.category_parent_id
771. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(182,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
772. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
773. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=117%')
       ORDER BY 'ordering'
774. SELECT *
       FROM jos_menu
       WHERE id = '166'
775. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '117'
776. 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='117'
       AND c.category_id = cx.category_parent_id
777. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(117,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
778. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
779. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=243%')
       ORDER BY 'ordering'
780. SELECT *
       FROM jos_menu
       WHERE id = '306'
781. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '243'
782. 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='243'
       AND c.category_id = cx.category_parent_id
783. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(243,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
784. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
785. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=147%')
       ORDER BY 'ordering'
786. SELECT *
       FROM jos_menu
       WHERE id = '200'
787. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '147'
788. 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='147'
       AND c.category_id = cx.category_parent_id
789. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(147,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
790. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
791. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=76%')
       ORDER BY 'ordering'
792. SELECT *
       FROM jos_menu
       WHERE id = '152'
793. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '76'
794. 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='76'
       AND c.category_id = cx.category_parent_id
795. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(76,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
796. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
797. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=146%')
       ORDER BY 'ordering'
798. SELECT *
       FROM jos_menu
       WHERE id = '201'
799. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '146'
800. 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='146'
       AND c.category_id = cx.category_parent_id
801. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(146,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
802. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
803. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=152%')
       ORDER BY 'ordering'
804. SELECT *
       FROM jos_menu
       WHERE id = '210'
805. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '152'
806. 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='152'
       AND c.category_id = cx.category_parent_id
807. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(152,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
808. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
809. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=221%')
       ORDER BY 'ordering'
810. SELECT *
       FROM jos_menu
       WHERE id = '282'
811. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '221'
812. 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='221'
       AND c.category_id = cx.category_parent_id
813. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(221,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
814. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
815. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=142%')
       ORDER BY 'ordering'
816. SELECT *
       FROM jos_menu
       WHERE id = '196'
817. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '142'
818. 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='142'
       AND c.category_id = cx.category_parent_id
819. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(142,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
820. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
821. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=64%')
       ORDER BY 'ordering'
822. SELECT *
       FROM jos_menu
       WHERE id = '143'
823. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '64'
824. 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='64'
       AND c.category_id = cx.category_parent_id
825. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(64,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
826. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
827. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=139%')
       ORDER BY 'ordering'
828. SELECT *
       FROM jos_menu
       WHERE id = '193'
829. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '139'
830. 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='139'
       AND c.category_id = cx.category_parent_id
831. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(139,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
832. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
833. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=163%')
       ORDER BY 'ordering'
834. SELECT *
       FROM jos_menu
       WHERE id = '221'
835. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '163'
836. 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='163'
       AND c.category_id = cx.category_parent_id
837. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(163,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
838. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
839. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=109%')
       ORDER BY 'ordering'
840. SELECT *
       FROM jos_menu
       WHERE id = '157'
841. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '109'
842. 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='109'
       AND c.category_id = cx.category_parent_id
843. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(109,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
844. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
845. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=248%')
       ORDER BY 'ordering'
846. SELECT *
       FROM jos_menu
       WHERE id = '310'
847. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '248'
848. 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='248'
       AND c.category_id = cx.category_parent_id
849. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(248,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
850. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
851. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=280%')
       ORDER BY 'ordering'
852. SELECT *
       FROM jos_menu
       WHERE id = '352'
853. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '280'
854. 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='280'
       AND c.category_id = cx.category_parent_id
855. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(280,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
856. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
857. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=184%')
       ORDER BY 'ordering'
858. SELECT *
       FROM jos_menu
       WHERE id = '245'
859. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '184'
860. 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='184'
       AND c.category_id = cx.category_parent_id
861. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(184,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
862. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
863. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=197%')
       ORDER BY 'ordering'
864. SELECT *
       FROM jos_menu
       WHERE id = '258'
865. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '197'
866. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='197'
       AND c.category_id = cx.category_parent_id
867. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(197,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
868. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
869. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=245%')
       ORDER BY 'ordering'
870. SELECT *
       FROM jos_menu
       WHERE id = '308'
871. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '245'
872. 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='245'
       AND c.category_id = cx.category_parent_id
873. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(245,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
874. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
875. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=90%')
       ORDER BY 'ordering'
876. SELECT *
       FROM jos_menu
       WHERE id = '124'
877. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '90'
878. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='90'
       AND c.category_id = cx.category_parent_id
879. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(90,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
880. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
881. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=167%')
       ORDER BY 'ordering'
882. SELECT *
       FROM jos_menu
       WHERE id = '227'
883. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '167'
884. 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='167'
       AND c.category_id = cx.category_parent_id
885. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(167,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
886. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
887. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=29%')
       ORDER BY 'ordering'
888. SELECT *
       FROM jos_menu
       WHERE id = '222'
889. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '29'
890. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
       FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
       WHERE cx.category_child_id='29'
       AND c.category_id = cx.category_parent_id
891. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(29,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
892. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
893. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=160%')
       ORDER BY 'ordering'
894. SELECT *
       FROM jos_menu
       WHERE id = '218'
895. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '160'
896. 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='160'
       AND c.category_id = cx.category_parent_id
897. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(160,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
898. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
899. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=119%')
       ORDER BY 'ordering'
900. SELECT *
       FROM jos_menu
       WHERE id = '168'
901. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '119'
902. 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='119'
       AND c.category_id = cx.category_parent_id
903. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(119,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
904. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
905. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=92%')
       ORDER BY 'ordering'
906. SELECT *
       FROM jos_menu
       WHERE id = '126'
907. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '92'
908. 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='92'
       AND c.category_id = cx.category_parent_id
909. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(92,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
910. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
911. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=143%')
       ORDER BY 'ordering'
912. SELECT *
       FROM jos_menu
       WHERE id = '198'
913. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '143'
914. 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='143'
       AND c.category_id = cx.category_parent_id
915. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(143,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
916. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
917. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=250%')
       ORDER BY 'ordering'
918. SELECT *
       FROM jos_menu
       WHERE id = '312'
919. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '250'
920. 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='250'
       AND c.category_id = cx.category_parent_id
921. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(250,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
922. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
923. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=71%')
       ORDER BY 'ordering'
924. SELECT *
       FROM jos_menu
       WHERE id = '145'
925. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '71'
926. 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='71'
       AND c.category_id = cx.category_parent_id
927. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(71,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
928. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
929. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=93%')
       ORDER BY 'ordering'
930. SELECT *
       FROM jos_menu
       WHERE id = '127'
931. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '93'
932. 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='93'
       AND c.category_id = cx.category_parent_id
933. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(93,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
934. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
935. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=151%')
       ORDER BY 'ordering'
936. SELECT *
       FROM jos_menu
       WHERE id = '209'
937. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '151'
938. 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='151'
       AND c.category_id = cx.category_parent_id
939. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(151,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
940. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
941. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=131%')
       ORDER BY 'ordering'
942. SELECT *
       FROM jos_menu
       WHERE id = '182'
943. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '131'
944. 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='131'
       AND c.category_id = cx.category_parent_id
945. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(131,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
946. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
947. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=198%')
       ORDER BY 'ordering'
948. SELECT *
       FROM jos_menu
       WHERE id = '259'
949. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '198'
950. 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='198'
       AND c.category_id = cx.category_parent_id
951. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(198,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
952. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
953. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=110%')
       ORDER BY 'ordering'
954. SELECT *
       FROM jos_menu
       WHERE id = '158'
955. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '110'
956. 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='110'
       AND c.category_id = cx.category_parent_id
957. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(110,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
958. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
959. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=69%')
       ORDER BY 'ordering'
960. SELECT *
       FROM jos_menu
       WHERE id = '146'
961. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '69'
962. 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='69'
       AND c.category_id = cx.category_parent_id
963. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(69,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
964. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
965. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=124%')
       ORDER BY 'ordering'
966. SELECT *
       FROM jos_menu
       WHERE id = '173'
967. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '124'
968. 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='124'
       AND c.category_id = cx.category_parent_id
969. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(124,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
970. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
971. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=155%')
       ORDER BY 'ordering'
972. SELECT *
       FROM jos_menu
       WHERE id = '213'
973. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '155'
974. 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='155'
       AND c.category_id = cx.category_parent_id
975. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(155,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
976. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
977. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=272%')
       ORDER BY 'ordering'
978. SELECT *
       FROM jos_menu
       WHERE id = '340'
979. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '272'
980. 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='272'
       AND c.category_id = cx.category_parent_id
981. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(272,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
982. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
983. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=199%')
       ORDER BY 'ordering'
984. SELECT *
       FROM jos_menu
       WHERE id = '260'
985. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '199'
986. 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='199'
       AND c.category_id = cx.category_parent_id
987. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(199,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
988. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
989. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=269%')
       ORDER BY 'ordering'
990. SELECT *
       FROM jos_menu
       WHERE id = '331'
991. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '269'
992. 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='269'
       AND c.category_id = cx.category_parent_id
993. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(269,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
994. SELECT sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
995. SELECT id
       FROM jos_menu
       WHERE `link` LIKE '%com_redshop%'
       AND `link` LIKE '%view=category%'
       AND (`params` LIKE '%categoryid=74%')
       ORDER BY 'ordering'
996. SELECT *
       FROM jos_menu
       WHERE id = '151'
997. SELECT sef_url,category_name
       FROM jos_redshop_category
       WHERE category_id = '74'
998. 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='74'
       AND c.category_id = cx.category_parent_id
999. SELECT count(*) AS total,sg.*
       FROM `jos_redshop_shopper_group` AS sg 
       WHERE  sg.`shopper_group_id` = 0
       AND FIND_IN_SET(74,sg.shopper_group_categories)
       GROUP BY sg.shopper_group_id
1000. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1001. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=195%')
        ORDER BY 'ordering'
1002. SELECT *
        FROM jos_menu
        WHERE id = '256'
1003. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '195'
1004. 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='195'
        AND c.category_id = cx.category_parent_id
1005. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(195,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1006. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1007. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=277%')
        ORDER BY 'ordering'
1008. SELECT *
        FROM jos_menu
        WHERE id = '348'
1009. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '277'
1010. 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='277'
        AND c.category_id = cx.category_parent_id
1011. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(277,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1012. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1013. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=273%')
        ORDER BY 'ordering'
1014. SELECT *
        FROM jos_menu
        WHERE id = '341'
1015. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '273'
1016. 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='273'
        AND c.category_id = cx.category_parent_id
1017. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(273,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1018. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1019. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=208%')
        ORDER BY 'ordering'
1020. SELECT *
        FROM jos_menu
        WHERE id = '269'
1021. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '208'
1022. 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='208'
        AND c.category_id = cx.category_parent_id
1023. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(208,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1024. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1025. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=222%')
        ORDER BY 'ordering'
1026. SELECT *
        FROM jos_menu
        WHERE id = '283'
1027. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '222'
1028. 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='222'
        AND c.category_id = cx.category_parent_id
1029. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(222,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1030. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1031. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=194%')
        ORDER BY 'ordering'
1032. SELECT *
        FROM jos_menu
        WHERE id = '255'
1033. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '194'
1034. 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='194'
        AND c.category_id = cx.category_parent_id
1035. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(194,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1036. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1037. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=270%')
        ORDER BY 'ordering'
1038. SELECT *
        FROM jos_menu
        WHERE id = '332'
1039. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '270'
1040. 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='270'
        AND c.category_id = cx.category_parent_id
1041. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(270,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1042. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1043. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=132%')
        ORDER BY 'ordering'
1044. SELECT *
        FROM jos_menu
        WHERE id = '183'
1045. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '132'
1046. 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='132'
        AND c.category_id = cx.category_parent_id
1047. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(132,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1048. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1049. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=73%')
        ORDER BY 'ordering'
1050. SELECT *
        FROM jos_menu
        WHERE id = '150'
1051. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '73'
1052. 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='73'
        AND c.category_id = cx.category_parent_id
1053. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(73,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1054. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1055. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=102%')
        ORDER BY 'ordering'
1056. SELECT *
        FROM jos_menu
        WHERE id = '119'
1057. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '102'
1058. 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='102'
        AND c.category_id = cx.category_parent_id
1059. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(102,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1060. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1061. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=191%')
        ORDER BY 'ordering'
1062. SELECT *
        FROM jos_menu
        WHERE id = '252'
1063. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '191'
1064. 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='191'
        AND c.category_id = cx.category_parent_id
1065. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(191,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1066. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1067. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=209%')
        ORDER BY 'ordering'
1068. SELECT *
        FROM jos_menu
        WHERE id = '270'
1069. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '209'
1070. 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='209'
        AND c.category_id = cx.category_parent_id
1071. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(209,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1072. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1073. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=251%')
        ORDER BY 'ordering'
1074. SELECT *
        FROM jos_menu
        WHERE id = '313'
1075. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '251'
1076. 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='251'
        AND c.category_id = cx.category_parent_id
1077. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(251,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1078. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1079. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=210%')
        ORDER BY 'ordering'
1080. SELECT *
        FROM jos_menu
        WHERE id = '271'
1081. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '210'
1082. 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='210'
        AND c.category_id = cx.category_parent_id
1083. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(210,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1084. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1085. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=219%')
        ORDER BY 'ordering'
1086. SELECT *
        FROM jos_menu
        WHERE id = '280'
1087. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '219'
1088. 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='219'
        AND c.category_id = cx.category_parent_id
1089. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(219,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1090. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1091. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=223%')
        ORDER BY 'ordering'
1092. SELECT *
        FROM jos_menu
        WHERE id = '284'
1093. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '223'
1094. 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='223'
        AND c.category_id = cx.category_parent_id
1095. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(223,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1096. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1097. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=276%')
        ORDER BY 'ordering'
1098. SELECT *
        FROM jos_menu
        WHERE id = '347'
1099. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '276'
1100. 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='276'
        AND c.category_id = cx.category_parent_id
1101. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(276,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1102. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1103. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=78%')
        ORDER BY 'ordering'
1104. SELECT *
        FROM jos_menu
        WHERE id = '137'
1105. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '78'
1106. 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='78'
        AND c.category_id = cx.category_parent_id
1107. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(78,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1108. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1109. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=185%')
        ORDER BY 'ordering'
1110. SELECT *
        FROM jos_menu
        WHERE id = '246'
1111. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '185'
1112. 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='185'
        AND c.category_id = cx.category_parent_id
1113. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(185,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1114. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1115. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=120%')
        ORDER BY 'ordering'
1116. SELECT *
        FROM jos_menu
        WHERE id = '169'
1117. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '120'
1118. 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='120'
        AND c.category_id = cx.category_parent_id
1119. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(120,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1120. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1121. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=252%')
        ORDER BY 'ordering'
1122. SELECT *
        FROM jos_menu
        WHERE id = '314'
1123. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '252'
1124. 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='252'
        AND c.category_id = cx.category_parent_id
1125. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(252,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1126. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1127. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=126%')
        ORDER BY 'ordering'
1128. SELECT *
        FROM jos_menu
        WHERE id = '179'
1129. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '126'
1130. 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='126'
        AND c.category_id = cx.category_parent_id
1131. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(126,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1132. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1133. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=253%')
        ORDER BY 'ordering'
1134. SELECT *
        FROM jos_menu
        WHERE id = '315'
1135. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '253'
1136. 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='253'
        AND c.category_id = cx.category_parent_id
1137. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(253,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1138. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1139. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=99%')
        ORDER BY 'ordering'
1140. SELECT *
        FROM jos_menu
        WHERE id = '138'
1141. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '99'
1142. 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='99'
        AND c.category_id = cx.category_parent_id
1143. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(99,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1144. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1145. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=226%')
        ORDER BY 'ordering'
1146. SELECT *
        FROM jos_menu
        WHERE id = '287'
1147. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '226'
1148. 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='226'
        AND c.category_id = cx.category_parent_id
1149. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(226,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1150. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1151. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=254%')
        ORDER BY 'ordering'
1152. SELECT *
        FROM jos_menu
        WHERE id = '316'
1153. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '254'
1154. 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='254'
        AND c.category_id = cx.category_parent_id
1155. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(254,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1156. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1157. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=211%')
        ORDER BY 'ordering'
1158. SELECT *
        FROM jos_menu
        WHERE id = '272'
1159. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '211'
1160. 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='211'
        AND c.category_id = cx.category_parent_id
1161. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(211,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1162. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1163. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=56%')
        ORDER BY 'ordering'
1164. SELECT *
        FROM jos_menu
        WHERE id = '222'
1165. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '56'
1166. SELECT c.category_id,c.category_name ,cx.category_child_id,cx.category_parent_id
        FROM jos_redshop_category_xref AS cx, jos_redshop_category AS c
        WHERE cx.category_child_id='56'
        AND c.category_id = cx.category_parent_id
1167. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(56,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1168. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1169. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=86%')
        ORDER BY 'ordering'
1170. SELECT *
        FROM jos_menu
        WHERE id = '128'
1171. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '86'
1172. 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='86'
        AND c.category_id = cx.category_parent_id
1173. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(86,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1174. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1175. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=158%')
        ORDER BY 'ordering'
1176. SELECT *
        FROM jos_menu
        WHERE id = '216'
1177. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '158'
1178. 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='158'
        AND c.category_id = cx.category_parent_id
1179. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(158,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1180. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1181. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=72%')
        ORDER BY 'ordering'
1182. SELECT *
        FROM jos_menu
        WHERE id = '153'
1183. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '72'
1184. 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='72'
        AND c.category_id = cx.category_parent_id
1185. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(72,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1186. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1187. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=111%')
        ORDER BY 'ordering'
1188. SELECT *
        FROM jos_menu
        WHERE id = '159'
1189. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '111'
1190. 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='111'
        AND c.category_id = cx.category_parent_id
1191. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(111,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1192. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1193. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=55%')
        ORDER BY 'ordering'
1194. SELECT *
        FROM jos_menu
        WHERE id = '222'
1195. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '55'
1196. 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='55'
        AND c.category_id = cx.category_parent_id
1197. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(55,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1198. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1199. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=104%')
        ORDER BY 'ordering'
1200. SELECT *
        FROM jos_menu
        WHERE id = '139'
1201. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '104'
1202. 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='104'
        AND c.category_id = cx.category_parent_id
1203. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(104,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1204. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1205. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=107%')
        ORDER BY 'ordering'
1206. SELECT *
        FROM jos_menu
        WHERE id = '140'
1207. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '107'
1208. 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='107'
        AND c.category_id = cx.category_parent_id
1209. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(107,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1210. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1211. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=54%')
        ORDER BY 'ordering'
1212. SELECT *
        FROM jos_menu
        WHERE id = '222'
1213. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '54'
1214. 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='54'
        AND c.category_id = cx.category_parent_id
1215. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(54,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1216. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1217. SELECT id
        FROM jos_menu
        WHERE `link` LIKE '%com_redshop%'
        AND `link` LIKE '%view=category%'
        AND (`params` LIKE '%categoryid=121%')
        ORDER BY 'ordering'
1218. SELECT *
        FROM jos_menu
        WHERE id = '170'
1219. SELECT sef_url,category_name
        FROM jos_redshop_category
        WHERE category_id = '121'
1220. 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='121'
        AND c.category_id = cx.category_parent_id
1221. SELECT count(*) AS total,sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
        AND FIND_IN_SET(121,sg.shopper_group_categories)
        GROUP BY sg.shopper_group_id
1222. SELECT sg.*
        FROM `jos_redshop_shopper_group` AS sg 
        WHERE  sg.`shopper_group_id` = 0
1223. SELECT *
        FROM jos_menu
        WHERE link LIKE '%com_redshop%'
        AND published=1
        AND id = '222'
1224. SELECT *
        FROM jos_menu
        WHERE link LIKE '%com_redshop%'
        AND published=1 
        AND link LIKE '%view=category%' 
        AND params NOT LIKE '%categoryid%'
1225. SELECT *
        FROM jos_menu
        WHERE id = '222'
1226. SELECT *
        FROM jos_menu
        WHERE id = '222'
1227. SELECT *
        FROM jos_menu
        WHERE id = '222'
1228. SELECT *
        FROM jos_menu
        WHERE id = '222'
1229. SELECT *
        FROM jos_menu
        WHERE id = '222'
1230. 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
1231. SELECT *
        FROM jos_menu
        WHERE id = '71'
1232. SELECT *
        FROM jos_menu
        WHERE id = '222'
1233. SELECT category_id      
        FROM jos_redshop_product_category_xref cx
        WHERE product_id = ''
1234. 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'
1235. SELECT category_id AS value,category_name AS text
        FROM jos_redshop_category
        WHERE published = 1
1236. SELECT *
        FROM jos_menu
        WHERE id = '222'