I submitted a ticket. Here's the Ticket ID: 376686

How long does it take to get a response?

Here are the details:

I am having a problem with Alllowed memory size. When I click on a group link to Groupjive I get this error:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 71 bytes) in /home/******/public_html/components/com_comprofiler/plugin/user/plug_cbgroupjive/cbgroupjive.class.php on line 5185

Here's the Groujive page:
360sportsagency.com/index.php?option=com_comprofiler&task=pluginclass&plugin=cbgroupjive

I have contacted my hosting provider. I ran memory tests. The hosting provider (siteground.com) worked hard to resolve this and pinpointed the error to be with groupjive plugin. There are no other memory "leaks" on any of the modules or components on my site.

Versions:
Community Builder: 1.9. upgraded from 1.8 which was an original install (after deleting it and reinstalling it in a new database)

CB Groupjive version: 2.7.0rc2

PHP Built On Linux serv01.siteground206.com 2.6.32.59-sg3 #9 SMP Wed Sep 26 03:29:25 CDT 2012 x86_64
Database Version 5.5.28-29.3-log
Database Collation utf8_general_ci
PHP Version 5.3.23
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 2.5.9 Stable [ Ember ] 4-February-2013 14:00 GMT
Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31

I found the issue. I have over 1,200 groups and categories. There are more than 1200 database calls for Groupjive alone. It needs more than the allocated memory to do this. Is there a way for groupjive not to do this? See below bug report:


HOME


A community based sports agency.

Whenever you think sports, think 360. We provide all of your local sports needs. Go to 360sportsagency.com and search for an agency near you.
HOME
ABOUT US | CONTACT US
ATHLETES
ORGANIZATIONS
EVENTS
AGENCIES
MAP | LOCATIONS
MY PAGE
LOGOUT
360 SPORTS PRODUCTS



Create an account
Choose your market
Take our training program
Make money in sports
Athlete representation | Event Management | Sports Apparel
CHOOSE AN AGENCY NEAR YOU


Enter city or zip code to search for an agency near you

View 360 Sports Agencies in a full screen map
360 PRESS RELEASES

360 Sports Agency Announces Vice President of Marketing & PR Columbia University Graduate Allie MacLeod
360 Sports Agency Announces President Columbia University Graduate Dean Forthun
360 Sports Agency Announces Vice President of Finance Columbia University’s Eric Williams
360 Sports Agency Announces Vice President of Franchising Mike Walker
Jennifer Hudson Will Be Performing At The Grand Gala Event During Kentucky Derby Weekend
360 Sports Agency Announces Super Bowl Champion Victor Cruz Will Be Attending The Grand Gala Event During Kentucky Derby Weekend
Pro Bowler, Tony Gonzalez, To Attend The Grand Gala Event During Kentucky Derby Weekend
360 Sports Agency Announces Pro Tennis Player Serena Williams Will Be Attending The Grand Gala Event During Kentucky Derby Weekend
360 Sports Agency Announces Super Bowl Champion Ray Lewis Will Be Attending The Grand Gala Event During Kentucky Derby Weekend
LATEST WALL POSTS

justin kirstein posted #1221 to Port Washington (NY) Office in United States on 2013-03-22 16:36:38
posted #1220 to Tampa (FL) Office in United States on 2013-01-10 20:44:24
360 Sports Administrator posted #1 to Aberdeen (MD) Office in United States on
360 Sports Administrator posted #2 to Abilene (TX) Office in United States on
360 Sports Administrator posted #3 to Abingdon (MD) Office in United States on
LATEST EVENTS

John Madden scheduled test in Abington (MA) Office of United States for 2012-12-01 12:30 AM
NEWEST MEMBERS

Jim Hauck
Andrew Grosso
LATEST PHOTOS

There are no photos uploaded.
LATEST VIDEOS

There are no videos published.
Copyright © 2013. 360 Sports Agency. Designed by 360sportsagency.com
Admin | Email | Terms and Conditions | Privacy
Joomla! Debug Console
Session
Profile Information
Application 0.000 seconds (+0.000); 1.22 MB (+1.222) - afterLoad
Application 0.050 seconds (+0.050); 7.03 MB (+5.804) - afterInitialise
Application 0.058 seconds (+0.008); 7.45 MB (+0.429) - afterRoute
Application 0.345 seconds (+0.287); 48.75 MB (+41.294) - afterDispatch
Application 0.402 seconds (+0.057); 49.61 MB (+0.862) - beforeRenderModule mod_custom (Footer text)
Application 0.404 seconds (+0.002); 49.67 MB (+0.059) - afterRenderModule mod_custom (Footer text)
Application 0.404 seconds (+0.000); 49.67 MB (-0.002) - beforeRenderModule mod_cbgroupjive (LATEST VIDEOS)
Application 0.406 seconds (+0.002); 49.67 MB (+0.006) - afterRenderModule mod_cbgroupjive (LATEST VIDEOS)
Application 0.406 seconds (+0.000); 49.67 MB (-0.006) - beforeRenderModule mod_cbgroupjive (LATEST PHOTOS)
Application 0.409 seconds (+0.002); 49.68 MB (+0.012) - afterRenderModule mod_cbgroupjive (LATEST PHOTOS)
Application 0.409 seconds (+0.000); 49.67 MB (-0.008) - beforeRenderModule mod_cbuserlist (NEWEST MEMBERS)
Application 0.411 seconds (+0.002); 49.74 MB (+0.064) - afterRenderModule mod_cbuserlist (NEWEST MEMBERS)
Application 0.411 seconds (+0.000); 49.73 MB (-0.008) - beforeRenderModule mod_cbgroupjive (LATEST EVENTS)
Application 0.430 seconds (+0.019); 50.68 MB (+0.952) - afterRenderModule mod_cbgroupjive (LATEST EVENTS)
Application 0.430 seconds (+0.000); 50.67 MB (-0.006) - beforeRenderModule mod_cbgroupjive (LATEST WALL POSTS)
Application 4.466 seconds (+4.036); 71.44 MB (+20.765) - afterRenderModule mod_cbgroupjive (LATEST WALL POSTS)
Application 4.466 seconds (+0.000); 71.44 MB (-0.000) - beforeRenderModule mod_articles_category (360 Press Releases)
Application 4.488 seconds (+0.021); 72.00 MB (+0.564) - afterRenderModule mod_articles_category (360 Press Releases)
Application 4.488 seconds (+0.000); 71.72 MB (-0.284) - beforeRenderModule mod_custom (start your own)
Application 4.489 seconds (+0.001); 71.72 MB (+0.005) - afterRenderModule mod_custom (start your own)
Application 4.489 seconds (+0.000); 71.73 MB (+0.007) - beforeRenderModule mod_aricloudcarousel (360 SPORTS PRODUCTS)
Application 4.508 seconds (+0.018); 72.56 MB (+0.826) - afterRenderModule mod_aricloudcarousel (360 SPORTS PRODUCTS)
Application 4.508 seconds (+0.000); 72.52 MB (-0.040) - beforeRenderModule mod_custom (logo)
Application 4.509 seconds (+0.001); 72.52 MB (+0.004) - afterRenderModule mod_custom (logo)
Application 4.515 seconds (+0.006); 72.69 MB (+0.165) - afterRender
Memory Usage
72.13 MB (75,632,264 Bytes)
Database Queries
1279 Queries Logged
SELECT folder AS type, element AS name, params
FROM sgj_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3,5,11,14)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM sgj_menu AS m
LEFT JOIN sgj_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM sgj_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM sgj_template_styles as s
LEFT JOIN sgj_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sgj_content AS a
LEFT JOIN sgj_categories AS c
ON c.id = a.catid
LEFT JOIN sgj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sgj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM sgj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN sgj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sgj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sgj_categories AS cat JOIN sgj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN sgj_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1,2,3,5,11,14)
AND c.access IN (1,1,2,3,5,11,14)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-04-10 03:27:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-04-10 03:27:46')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY c.path, fp.ordering, a.created DESC
LIMIT 0, 10
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM sgj_content AS a
LEFT JOIN sgj_categories AS c
ON c.id = a.catid
LEFT JOIN sgj_users AS ua
ON ua.id = a.created_by
LEFT JOIN sgj_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM sgj_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN sgj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sgj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sgj_categories AS cat JOIN sgj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN sgj_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1,2,3,5,11,14)
AND c.access IN (1,1,2,3,5,11,14)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-04-10 03:27:46')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-04-10 03:27:46')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY c.path, fp.ordering, a.created DESC
SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
WHERE `type` = 'component'
AND `element` = 'com_simplecaddy'
SHOW FULL COLUMNS
FROM `sgj_users`
SELECT c.*, u.*
FROM sgj_users AS u
LEFT JOIN sgj_comprofiler AS c
ON c.id = u.id
WHERE u.id = 310
SELECT a.id
FROM sgj_user_usergroup_map AS map
LEFT JOIN sgj_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 310
SELECT c.*, u.*
FROM sgj_users AS u
LEFT JOIN sgj_comprofiler AS c
ON c.id = u.id
WHERE u.id = 353
SELECT a.id
FROM sgj_user_usergroup_map AS map
LEFT JOIN sgj_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 353
SELECT f.*
FROM sgj_comprofiler_fields f
INNER JOIN sgj_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE ( f.published = 1 OR f.name = 'name' )
ORDER BY t.position, t.ordering, f.ordering
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM sgj_comprofiler_plugin
WHERE published = 1
AND access IN (0,1,2,5,11,14)
AND type = 'user'
ORDER BY ordering
SELECT *
FROM `sgj_comprofiler_plugin`
WHERE `element` = 'cbblogs'
SELECT *
FROM `sgj_comprofiler_tabs`
WHERE `pluginid` = 537
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM sgj_comprofiler_plugin
WHERE published = 1
AND access IN (0,1,2,5,11,14)
AND type = 'user/plug_cbgroupjive/plugins'
ORDER BY ordering
SELECT *
FROM `sgj_comprofiler_plugin`
WHERE `element` = 'cbgroupjive'
SELECT *
FROM `sgj_comprofiler_tabs`
WHERE `pluginid` = 511
SELECT *
FROM `sgj_groupjive_plugin_auto`
WHERE ( `published` = 1 )
ORDER BY `ordering` ASC
SELECT id
FROM sgj_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published = 1
AND access IN (1,2,3,5,11,14)
AND `language` IN ( 'en-GB', '*', '' )
SELECT id
FROM sgj_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published = 1
AND access IN (1,2,3,5,11,14)
AND `language` IN ( 'en-GB', '*', '' )
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sgj_categories as c
LEFT JOIN sgj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sgj_categories AS cat JOIN sgj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,2,3,5,11,14)
AND c.published = 1
AND s.id=9
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT *
FROM sgj_template_styles
WHERE template = 'shape5_vertex';
SELECT *
FROM sgj_menu
WHERE template_style_id IN (121)
AND alias = 'homepage'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sgj_modules AS m
LEFT JOIN sgj_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sgj_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-04-10 03:27:46')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-04-10 03:27:46')
AND m.access IN (1,1,2,3,5,11,14)
AND m.client_id = 0
AND (mm.menuid = 435 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT menutype
FROM sgj_menu
WHERE language = 'en-GB'
AND home = 1
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM sgj_menu AS m
LEFT JOIN sgj_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT a.*
FROM `sgj_groupjive_plugin_video` AS a
ORDER BY a.`date` DESC
SELECT a.*
FROM `sgj_groupjive_plugin_photo` AS a
ORDER BY a.`date` DESC
SELECT u.id AS `id`, u.name AS `name`, DATE_FORMAT(u.registerDate, "%Y-%m-%d") AS `registerdate`
FROM `sgj_users` u, `sgj_comprofiler` b
WHERE u.id = b.id
AND b.approved
AND u.block=0
ORDER BY u.registerDate DESC
LIMIT 2
SELECT a.*
FROM `sgj_groupjive_plugin_events` AS a
ORDER BY (
CASE WHEN ( a.`date` > NOW() ) THEN a.`date` ELSE 99999 END ) ASC, a.`date` DESC
SELECT c.*, u.*
FROM sgj_users AS u
LEFT JOIN sgj_comprofiler AS c
ON c.id = u.id
WHERE u.id = 322
SELECT a.id
FROM sgj_user_usergroup_map AS map
LEFT JOIN sgj_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 322
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 4 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_categories` AS a
WHERE ( a.`id` = 1 )
ORDER BY a.`ordering` ASC
SELECT *
FROM `sgj_usergroups`
ORDER BY `lft`
SELECT parent.id, parent.lft, parent.rgt
FROM sgj_usergroups AS parent
ORDER BY parent.lft
SHOW FULL COLUMNS
FROM `sgj_assets`
SELECT id
FROM sgj_assets
WHERE parent_id = 0
SELECT b.rules
FROM sgj_assets AS a
LEFT JOIN sgj_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = '' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT *
FROM `sgj_usergroups`
ORDER BY `lft`
SELECT b.id
FROM sgj_user_usergroup_map AS map
LEFT JOIN sgj_usergroups AS a
ON a.id = map.group_id
LEFT JOIN sgj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 353
SELECT id
FROM sgj_assets
WHERE parent_id = 0
SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level
FROM `sgj_usergroups` AS a
LEFT JOIN `sgj_usergroups` AS b
ON a.`lft` > b.`lft`
AND a.`rgt` < b.`rgt`
GROUP BY a.`id`
ORDER BY a.`lft` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
LEFT JOIN `sgj_groupjive_categories` AS b
ON b.`id` = a.`category`
WHERE ( a.`user_id` = 353 )
AND ( ( a.`category` = '1' ) OR ( b.`parent` = '1' ) )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_users` AS a
LEFT JOIN `sgj_groupjive_groups` AS b
ON b.`id` = a.`
group`
LEFT JOIN `sgj_groupjive_categories` AS c
ON c.`id` = b.`category`
WHERE ( a.`user_id` = 353 )
AND ( a.`status` >= 1 )
AND ( ( c.`id` = '1' ) OR ( c.`parent` = '1' ) )
ORDER BY (
CASE WHEN ( a.`status` = 0 ) THEN 1 WHEN ( a.`status` >= 1 ) THEN 2 ELSE 3 END ) ASC, a.`status` DESC, a.`date` DESC
SELECT a.*
FROM `sgj_groupjive_users` AS a
WHERE ( a.`user_id` = 353 )
ORDER BY (
CASE WHEN ( a.`status` = 0 ) THEN 1 WHEN ( a.`status` >= 1 ) THEN 2 ELSE 3 END ) ASC, a.`status` DESC, a.`date` DESC
SELECT a.*
FROM `sgj_groupjive_invites` AS a
WHERE ( ( a.`email` = 'rlicopoli@gmail.com' ) OR ( a.`user` = 353 ) )
AND ( a.`accepted` IN ( '0000-00-00', '0000-00-00 00:00:00', '', NULL ) )
ORDER BY a.`accepted` ASC
SELECT `id`
FROM `sgj_menu`
WHERE `link` LIKE 'index.php?option=com_comprofiler&task=pluginclass&plugin=cbgroupjive%'
AND `published` = 1
AND `access` IN ( 1,2,3,5,11,14 )
AND `language` IN ( 'en-GB', '*', '' )
SELECT a.*
FROM `sgj_groupjive_plugin_wall` AS a
ORDER BY a.`date` DESC
SELECT c.*, u.*
FROM sgj_users AS u
LEFT JOIN sgj_comprofiler AS c
ON c.id = u.id
WHERE u.id = 360
SELECT a.id
FROM sgj_user_usergroup_map AS map
LEFT JOIN sgj_usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 360
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 1216 )
ORDER BY a.`ordering` ASC
SELECT c.*, u.*
FROM sgj_users AS u
LEFT JOIN sgj_comprofiler AS c
ON c.id = u.id
WHERE u.id = 395
SELECT u.*, c.*
FROM sgj_comprofiler AS c
LEFT JOIN sgj_users AS u
ON c.id = u.id
WHERE c.id = 395
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 1047 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 1 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 2 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 3 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 5 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 6 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 7 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 8 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 9 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 10 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 11 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 12 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 13 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 14 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 15 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 16 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 17 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 18 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 19 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 20 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 21 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 22 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 23 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 24 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 25 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 26 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 27 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 28 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 29 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 30 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 31 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 32 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 33 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 34 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 35 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 36 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 37 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 38 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 39 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 40 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 41 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 42 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 43 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 44 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 45 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 46 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 47 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 48 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 49 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 50 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 51 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 52 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 53 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 54 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 55 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 56 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 57 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 58 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 59 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 60 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 61 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 62 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 63 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 64 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 65 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 66 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 67 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 68 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 69 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 70 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 71 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 72 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 73 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 74 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 75 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 76 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 77 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 78 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 79 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 80 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 81 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 82 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 83 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 84 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 85 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 86 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 87 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 88 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 89 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 90 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 91 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 92 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 93 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 94 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 95 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 96 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 97 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 98 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 99 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 100 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 101 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 102 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 103 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 104 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 105 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 106 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 107 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 108 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 109 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 110 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 111 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 112 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 113 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 114 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 115 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 116 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 117 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 118 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 119 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 120 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 121 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 122 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 123 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 124 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 125 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 126 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 127 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 128 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 129 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 130 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 131 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 132 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 133 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 134 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 135 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 136 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 137 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 138 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 139 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 140 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 141 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 142 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 143 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 144 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 145 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 146 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 147 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 148 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 149 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 150 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 151 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 152 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 153 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 154 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 155 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 156 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 157 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 158 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 159 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 160 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 161 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 162 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 163 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 164 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 165 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 166 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 167 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 168 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 169 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 170 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 171 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 172 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 173 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 174 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 175 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 176 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 177 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 178 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 179 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 180 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 181 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 182 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 183 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 184 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 185 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 186 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 187 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 188 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 189 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 190 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 191 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 192 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 193 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 194 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 195 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 196 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 197 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 198 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 199 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 200 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 201 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 202 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 203 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 204 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 205 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 206 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 207 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 208 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 209 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 210 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 211 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 212 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 213 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 214 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 215 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 216 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 217 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 218 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 219 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 220 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 221 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 222 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 223 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 224 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 225 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 226 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 227 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 228 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 229 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 230 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 231 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 232 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 233 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 234 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 235 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 236 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 237 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 238 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 239 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 240 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 241 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 242 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 243 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 244 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 245 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 246 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 247 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 248 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 249 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 250 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 251 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 252 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 253 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 254 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 255 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 256 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 257 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 258 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 259 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 260 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 261 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 262 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 263 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 264 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 265 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 266 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 267 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 268 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 269 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 270 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 271 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 272 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 273 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 274 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 275 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 276 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 277 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 278 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 279 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 280 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 281 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 282 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 283 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 284 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 285 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 286 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 287 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 288 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 289 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 290 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 291 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 292 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 293 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 294 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 295 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 296 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 297 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 298 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 299 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 300 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 301 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 302 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 303 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 304 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 305 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 306 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 307 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 308 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 309 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 310 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 311 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 312 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 313 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 314 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 315 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 316 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 317 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 318 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 319 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 320 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 321 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 322 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 323 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 324 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 325 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 326 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 327 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 328 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 329 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 330 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 331 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 332 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 333 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 334 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 335 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 336 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 337 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 338 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 339 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 340 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 341 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 342 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 343 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 344 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 345 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 346 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 347 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 348 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 349 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 350 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 351 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 352 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 353 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 354 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 355 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 356 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 357 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 358 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 359 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 360 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 361 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 362 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 363 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 364 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 365 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 366 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 367 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 368 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 369 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 370 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 371 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 372 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 373 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 374 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 375 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 376 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 377 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 378 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 379 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 380 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 381 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 382 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 383 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 384 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 385 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 386 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 387 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 388 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 389 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 390 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 391 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 392 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 393 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 394 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 395 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 396 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 397 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 398 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 399 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 400 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 401 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 402 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 403 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 404 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 405 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 406 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 407 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 408 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 409 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 410 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 411 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 412 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 413 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 414 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 415 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 416 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 417 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 418 )
ORDER BY a.`ordering` ASC
SELECT a.*
FROM `sgj_groupjive_groups` AS a
WHERE ( a.`id` = 419 )
ORDER BY a.`ordering` ASC
SE