General

Discoverability
Visible
Join Policy
Open/Anyone
Created
02 May 2019

About the Group

Comments

There are no comments on this entry.


Debug Console

Close40 MBRequestSessionTimelineDatabase429Events57
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( USER => apache, HOME => /usr/share/httpd, FCGI_ROLE => RESPONDER, REDIRECT_HTTP_AU... Array(
USER => apache,
HOME => /usr/share/httpd,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_UNIQUE_ID => ZgW4CJpenIfKpVJ0@o-DmAAAAAs,
REDIRECT_SCRIPT_URL => /groups/general/overview,
REDIRECT_SCRIPT_URI => https://ielab.info/groups/general/overview,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
UNIQUE_ID => ZgW4CJpenIfKpVJ0@o-DmAAAAAs,
SCRIPT_URL => /groups/general/overview,
SCRIPT_URI => https://ielab.info/groups/general/overview,
HTTPS => on,
HTTP_X_FORWARDED_FOR => 52.90.50.252,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_PORT => 443,
HTTP_HOST => ielab.info,
HTTP_X_AMZN_TRACE_ID => Root=1-6605b808-6f1922117dfe247664e08925,
HTTP_ACCEPT => */*,
HTTP_USER_AGENT => claudebot,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_python/3.5.0- Python/2.7.5,
SERVER_NAME => ielab.info,
SERVER_ADDR => 10.84.154.253,
SERVER_PORT => 443,
REMOTE_ADDR => 10.84.154.133,
DOCUMENT_ROOT => /var/www/ielab,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/ielab,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/ielab/index.php,
REMOTE_PORT => 8360,
REDIRECT_URL => /groups/general/overview,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /groups/general/overview,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1711650824.8992,
REQUEST_TIME => 1711650824
)
session.client.forwarded 52.90.50.252
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid bfc8d44c7fb971355f2062209f152ed4
tracker.ssid bfc8d44c7fb971355f2062209f152ed4
tracker.rsid bfc8d44c7fb971355f2062209f152ed4
  • site 0.039 seconds (+0.039); 9.50 MB (+9.500) - afterInitialise
  • site 0.063 seconds (+0.024); 11.50 MB (+2.000) - afterRoute
  • site 0.371 seconds (+0.307); 38.75 MB (+27.250) - afterDispatch
  • site 0.378 seconds (+0.008); 39.00 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.380 seconds (+0.002); 39.25 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.380 seconds (+0.000); 39.25 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.382 seconds (+0.002); 39.25 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.382 seconds (+0.000); 39.25 MB (0.000) - beforeRenderModule mod_menu (Community)
  • site 0.384 seconds (+0.002); 39.50 MB (+0.250) - afterRenderModule mod_menu (Community)
  • site 0.384 seconds (+0.000); 39.50 MB (0.000) - beforeRenderModule mod_menu (Support)
  • site 0.384 seconds (+0.000); 39.50 MB (0.000) - afterRenderModule mod_menu (Support)
  • site 0.385 seconds (+0.000); 39.50 MB (0.000) - beforeRenderModule mod_menu (Analyse)
  • site 0.385 seconds (+0.000); 39.50 MB (0.000) - afterRenderModule mod_menu (Analyse)
  • site 0.385 seconds (+0.000); 39.50 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.390 seconds (+0.005); 39.50 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.390 seconds (+0.000); 39.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.407 seconds (+0.017); 39.75 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.407 seconds (+0.000); 39.75 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.409 seconds (+0.002); 40.00 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.409 seconds (+0.000); 40.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.412 seconds (+0.003); 40.00 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.414 seconds (+0.002); 40.00 MB (0.000) - onAfterRender
  • site 0.416 seconds (+0.002); 40.00 MB (0.000) - sessionStore
40 MB

429 Queries Logged: 0.056618213653564 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '9ab5100eb5951c68aaef811722b75106'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '9ab5100eb5951c68aaef811722b75106'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'bfc8d44c7fb971355f2062209f152ed4'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = 'bfc8d44c7fb971355f2062209f152ed4'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('bfc8d44c7fb971355f2062209f152ed4','0','1711650824','10.84.154.133')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. 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 `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  13. SELECT *
      FROM `jos_xgroups`
      WHERE cn = 'general';
  14. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1012') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1012') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1012') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1012')
  15. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  17. DELETE
      FROM `jos_xgroups_pages_checkout`
      WHERE `userid`='0'
  18. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  20. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages`
  21. SELECT *
      FROM jos_xgroups_pages
      WHERE gidNumber='1012'
      AND state IN (0,1)
      ORDER BY lft ASC
  22. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_versions`
  23. SELECT *
      FROM jos_xgroups_pages_versions
      WHERE pageid='13'
      ORDER BY version DESC
  24. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_hits`
  25. INSERT INTO `jos_xgroups_pages_hits` (`gidNumber`,`pageid`,`userid`,`date`,`ip`)
      VALUES ('1012','13','0','2024-03-28 18:33:45','10.84.154.133')
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  29. SHOW TABLES LIKE 'jos_solr_search_searchcomponents'
  30. SELECT *
      FROM `jos_solr_search_searchcomponents`
      WHERE `jos_solr_search_searchcomponents`.`name` = 'groups'
  31. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_categories`
  32. SELECT *
      FROM `jos_xgroups_description_fields`
      ORDER BY `ordering` ASC
  33. SELECT *
      FROM `jos_xgroups_description_answers`
      WHERE `jos_xgroups_description_answers`.`group_id` = '1012'
      AND `jos_xgroups_description_answers`.`field_id` IN ('1','2')
      ORDER BY `ordering` ASC
  34. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1000'
      AND r.gidNumber='1012'
  35. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1001'
      AND r.gidNumber='1012'
  36. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1006'
      AND r.gidNumber='1012'
  37. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1007'
      AND r.gidNumber='1012'
  38. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1010'
      AND r.gidNumber='1012'
  39. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1011'
      AND r.gidNumber='1012'
  40. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1013'
      AND r.gidNumber='1012'
  41. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1015'
      AND r.gidNumber='1012'
  42. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1016'
      AND r.gidNumber='1012'
  43. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1017'
      AND r.gidNumber='1012'
  44. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1018'
      AND r.gidNumber='1012'
  45. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1019'
      AND r.gidNumber='1012'
  46. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1020'
      AND r.gidNumber='1012'
  47. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1021'
      AND r.gidNumber='1012'
  48. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1022'
      AND r.gidNumber='1012'
  49. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1023'
      AND r.gidNumber='1012'
  50. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1024'
      AND r.gidNumber='1012'
  51. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1025'
      AND r.gidNumber='1012'
  52. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1026'
      AND r.gidNumber='1012'
  53. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1027'
      AND r.gidNumber='1012'
  54. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1028'
      AND r.gidNumber='1012'
  55. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1030'
      AND r.gidNumber='1012'
  56. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1032'
      AND r.gidNumber='1012'
  57. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1034'
      AND r.gidNumber='1012'
  58. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1036'
      AND r.gidNumber='1012'
  59. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1038'
      AND r.gidNumber='1012'
  60. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1039'
      AND r.gidNumber='1012'
  61. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1041'
      AND r.gidNumber='1012'
  62. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1042'
      AND r.gidNumber='1012'
  63. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1043'
      AND r.gidNumber='1012'
  64. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1044'
      AND r.gidNumber='1012'
  65. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1045'
      AND r.gidNumber='1012'
  66. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1046'
      AND r.gidNumber='1012'
  67. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1048'
      AND r.gidNumber='1012'
  68. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1049'
      AND r.gidNumber='1012'
  69. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1052'
      AND r.gidNumber='1012'
  70. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1053'
      AND r.gidNumber='1012'
  71. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1054'
      AND r.gidNumber='1012'
  72. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1055'
      AND r.gidNumber='1012'
  73. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1056'
      AND r.gidNumber='1012'
  74. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1057'
      AND r.gidNumber='1012'
  75. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1058'
      AND r.gidNumber='1012'
  76. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1059'
      AND r.gidNumber='1012'
  77. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1060'
      AND r.gidNumber='1012'
  78. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1062'
      AND r.gidNumber='1012'
  79. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1063'
      AND r.gidNumber='1012'
  80. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1064'
      AND r.gidNumber='1012'
  81. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1065'
      AND r.gidNumber='1012'
  82. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1066'
      AND r.gidNumber='1012'
  83. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1068'
      AND r.gidNumber='1012'
  84. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1070'
      AND r.gidNumber='1012'
  85. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1072'
      AND r.gidNumber='1012'
  86. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1073'
      AND r.gidNumber='1012'
  87. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1074'
      AND r.gidNumber='1012'
  88. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1075'
      AND r.gidNumber='1012'
  89. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1076'
      AND r.gidNumber='1012'
  90. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1077'
      AND r.gidNumber='1012'
  91. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1079'
      AND r.gidNumber='1012'
  92. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1080'
      AND r.gidNumber='1012'
  93. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1081'
      AND r.gidNumber='1012'
  94. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1082'
      AND r.gidNumber='1012'
  95. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1083'
      AND r.gidNumber='1012'
  96. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1084'
      AND r.gidNumber='1012'
  97. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1085'
      AND r.gidNumber='1012'
  98. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1086'
      AND r.gidNumber='1012'
  99. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1087'
      AND r.gidNumber='1012'
  100. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1088'
      AND r.gidNumber='1012'
  101. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1089'
      AND r.gidNumber='1012'
  102. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1090'
      AND r.gidNumber='1012'
  103. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1091'
      AND r.gidNumber='1012'
  104. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1093'
      AND r.gidNumber='1012'
  105. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1094'
      AND r.gidNumber='1012'
  106. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1097'
      AND r.gidNumber='1012'
  107. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1098'
      AND r.gidNumber='1012'
  108. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1099'
      AND r.gidNumber='1012'
  109. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1104'
      AND r.gidNumber='1012'
  110. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1105'
      AND r.gidNumber='1012'
  111. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1108'
      AND r.gidNumber='1012'
  112. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1110'
      AND r.gidNumber='1012'
  113. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1111'
      AND r.gidNumber='1012'
  114. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1112'
      AND r.gidNumber='1012'
  115. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1113'
      AND r.gidNumber='1012'
  116. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1116'
      AND r.gidNumber='1012'
  117. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1118'
      AND r.gidNumber='1012'
  118. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1120'
      AND r.gidNumber='1012'
  119. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1122'
      AND r.gidNumber='1012'
  120. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1123'
      AND r.gidNumber='1012'
  121. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1124'
      AND r.gidNumber='1012'
  122. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1125'
      AND r.gidNumber='1012'
  123. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1126'
      AND r.gidNumber='1012'
  124. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1129'
      AND r.gidNumber='1012'
  125. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1131'
      AND r.gidNumber='1012'
  126. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1132'
      AND r.gidNumber='1012'
  127. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1133'
      AND r.gidNumber='1012'
  128. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1134'
      AND r.gidNumber='1012'
  129. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1137'
      AND r.gidNumber='1012'
  130. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1140'
      AND r.gidNumber='1012'
  131. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1142'
      AND r.gidNumber='1012'
  132. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1143'
      AND r.gidNumber='1012'
  133. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1144'
      AND r.gidNumber='1012'
  134. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1147'
      AND r.gidNumber='1012'
  135. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1148'
      AND r.gidNumber='1012'
  136. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1149'
      AND r.gidNumber='1012'
  137. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1150'
      AND r.gidNumber='1012'
  138. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1151'
      AND r.gidNumber='1012'
  139. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1152'
      AND r.gidNumber='1012'
  140. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1155'
      AND r.gidNumber='1012'
  141. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1156'
      AND r.gidNumber='1012'
  142. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1157'
      AND r.gidNumber='1012'
  143. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1158'
      AND r.gidNumber='1012'
  144. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1159'
      AND r.gidNumber='1012'
  145. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1161'
      AND r.gidNumber='1012'
  146. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1162'
      AND r.gidNumber='1012'
  147. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1163'
      AND r.gidNumber='1012'
  148. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1164'
      AND r.gidNumber='1012'
  149. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1165'
      AND r.gidNumber='1012'
  150. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1166'
      AND r.gidNumber='1012'
  151. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1167'
      AND r.gidNumber='1012'
  152. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1168'
      AND r.gidNumber='1012'
  153. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1169'
      AND r.gidNumber='1012'
  154. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1170'
      AND r.gidNumber='1012'
  155. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1171'
      AND r.gidNumber='1012'
  156. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1173'
      AND r.gidNumber='1012'
  157. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1174'
      AND r.gidNumber='1012'
  158. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1175'
      AND r.gidNumber='1012'
  159. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1178'
      AND r.gidNumber='1012'
  160. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1179'
      AND r.gidNumber='1012'
  161. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1181'
      AND r.gidNumber='1012'
  162. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1182'
      AND r.gidNumber='1012'
  163. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1183'
      AND r.gidNumber='1012'
  164. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1184'
      AND r.gidNumber='1012'
  165. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1185'
      AND r.gidNumber='1012'
  166. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1186'
      AND r.gidNumber='1012'
  167. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1187'
      AND r.gidNumber='1012'
  168. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1188'
      AND r.gidNumber='1012'
  169. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1189'
      AND r.gidNumber='1012'
  170. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1190'
      AND r.gidNumber='1012'
  171. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1191'
      AND r.gidNumber='1012'
  172. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1192'
      AND r.gidNumber='1012'
  173. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1193'
      AND r.gidNumber='1012'
  174. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1194'
      AND r.gidNumber='1012'
  175. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1195'
      AND r.gidNumber='1012'
  176. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1196'
      AND r.gidNumber='1012'
  177. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1197'
      AND r.gidNumber='1012'
  178. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1198'
      AND r.gidNumber='1012'
  179. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1199'
      AND r.gidNumber='1012'
  180. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1200'
      AND r.gidNumber='1012'
  181. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1201'
      AND r.gidNumber='1012'
  182. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1202'
      AND r.gidNumber='1012'
  183. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1203'
      AND r.gidNumber='1012'
  184. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1204'
      AND r.gidNumber='1012'
  185. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1205'
      AND r.gidNumber='1012'
  186. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1206'
      AND r.gidNumber='1012'
  187. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1208'
      AND r.gidNumber='1012'
  188. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1209'
      AND r.gidNumber='1012'
  189. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1210'
      AND r.gidNumber='1012'
  190. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1211'
      AND r.gidNumber='1012'
  191. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1212'
      AND r.gidNumber='1012'
  192. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1213'
      AND r.gidNumber='1012'
  193. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1214'
      AND r.gidNumber='1012'
  194. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1215'
      AND r.gidNumber='1012'
  195. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1216'
      AND r.gidNumber='1012'
  196. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1217'
      AND r.gidNumber='1012'
  197. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1219'
      AND r.gidNumber='1012'
  198. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1220'
      AND r.gidNumber='1012'
  199. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1221'
      AND r.gidNumber='1012'
  200. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1222'
      AND r.gidNumber='1012'
  201. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1223'
      AND r.gidNumber='1012'
  202. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1224'
      AND r.gidNumber='1012'
  203. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1225'
      AND r.gidNumber='1012'
  204. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1227'
      AND r.gidNumber='1012'
  205. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1228'
      AND r.gidNumber='1012'
  206. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1229'
      AND r.gidNumber='1012'
  207. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1230'
      AND r.gidNumber='1012'
  208. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1231'
      AND r.gidNumber='1012'
  209. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1232'
      AND r.gidNumber='1012'
  210. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1234'
      AND r.gidNumber='1012'
  211. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1235'
      AND r.gidNumber='1012'
  212. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1236'
      AND r.gidNumber='1012'
  213. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1237'
      AND r.gidNumber='1012'
  214. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1238'
      AND r.gidNumber='1012'
  215. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1239'
      AND r.gidNumber='1012'
  216. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1240'
      AND r.gidNumber='1012'
  217. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1241'
      AND r.gidNumber='1012'
  218. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1242'
      AND r.gidNumber='1012'
  219. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1243'
      AND r.gidNumber='1012'
  220. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1244'
      AND r.gidNumber='1012'
  221. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1245'
      AND r.gidNumber='1012'
  222. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1246'
      AND r.gidNumber='1012'
  223. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1247'
      AND r.gidNumber='1012'
  224. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1248'
      AND r.gidNumber='1012'
  225. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1249'
      AND r.gidNumber='1012'
  226. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1250'
      AND r.gidNumber='1012'
  227. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1251'
      AND r.gidNumber='1012'
  228. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1252'
      AND r.gidNumber='1012'
  229. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1253'
      AND r.gidNumber='1012'
  230. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1254'
      AND r.gidNumber='1012'
  231. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1255'
      AND r.gidNumber='1012'
  232. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1257'
      AND r.gidNumber='1012'
  233. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1258'
      AND r.gidNumber='1012'
  234. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1259'
      AND r.gidNumber='1012'
  235. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1262'
      AND r.gidNumber='1012'
  236. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1263'
      AND r.gidNumber='1012'
  237. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1266'
      AND r.gidNumber='1012'
  238. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1267'
      AND r.gidNumber='1012'
  239. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1269'
      AND r.gidNumber='1012'
  240. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1270'
      AND r.gidNumber='1012'
  241. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1271'
      AND r.gidNumber='1012'
  242. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1272'
      AND r.gidNumber='1012'
  243. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1273'
      AND r.gidNumber='1012'
  244. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1274'
      AND r.gidNumber='1012'
  245. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1275'
      AND r.gidNumber='1012'
  246. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1276'
      AND r.gidNumber='1012'
  247. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1277'
      AND r.gidNumber='1012'
  248. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1278'
      AND r.gidNumber='1012'
  249. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1279'
      AND r.gidNumber='1012'
  250. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1280'
      AND r.gidNumber='1012'
  251. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1281'
      AND r.gidNumber='1012'
  252. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1282'
      AND r.gidNumber='1012'
  253. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1283'
      AND r.gidNumber='1012'
  254. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1287'
      AND r.gidNumber='1012'
  255. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1288'
      AND r.gidNumber='1012'
  256. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1289'
      AND r.gidNumber='1012'
  257. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1290'
      AND r.gidNumber='1012'
  258. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1291'
      AND r.gidNumber='1012'
  259. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1293'
      AND r.gidNumber='1012'
  260. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1294'
      AND r.gidNumber='1012'
  261. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1295'
      AND r.gidNumber='1012'
  262. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1296'
      AND r.gidNumber='1012'
  263. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1298'
      AND r.gidNumber='1012'
  264. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1299'
      AND r.gidNumber='1012'
  265. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1300'
      AND r.gidNumber='1012'
  266. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1301'
      AND r.gidNumber='1012'
  267. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1302'
      AND r.gidNumber='1012'
  268. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1303'
      AND r.gidNumber='1012'
  269. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1304'
      AND r.gidNumber='1012'
  270. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1305'
      AND r.gidNumber='1012'
  271. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1308'
      AND r.gidNumber='1012'
  272. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1309'
      AND r.gidNumber='1012'
  273. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1310'
      AND r.gidNumber='1012'
  274. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1312'
      AND r.gidNumber='1012'
  275. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1313'
      AND r.gidNumber='1012'
  276. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1314'
      AND r.gidNumber='1012'
  277. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1315'
      AND r.gidNumber='1012'
  278. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1316'
      AND r.gidNumber='1012'
  279. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1317'
      AND r.gidNumber='1012'
  280. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1319'
      AND r.gidNumber='1012'
  281. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1321'
      AND r.gidNumber='1012'
  282. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1322'
      AND r.gidNumber='1012'
  283. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1325'
      AND r.gidNumber='1012'
  284. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1326'
      AND r.gidNumber='1012'
  285. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1327'
      AND r.gidNumber='1012'
  286. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1329'
      AND r.gidNumber='1012'
  287. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1330'
      AND r.gidNumber='1012'
  288. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1332'
      AND r.gidNumber='1012'
  289. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1333'
      AND r.gidNumber='1012'
  290. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1334'
      AND r.gidNumber='1012'
  291. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1335'
      AND r.gidNumber='1012'
  292. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1336'
      AND r.gidNumber='1012'
  293. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1337'
      AND r.gidNumber='1012'
  294. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1338'
      AND r.gidNumber='1012'
  295. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1339'
      AND r.gidNumber='1012'
  296. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1340'
      AND r.gidNumber='1012'
  297. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1341'
      AND r.gidNumber='1012'
  298. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1342'
      AND r.gidNumber='1012'
  299. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1343'
      AND r.gidNumber='1012'
  300. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1344'
      AND r.gidNumber='1012'
  301. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1345'
      AND r.gidNumber='1012'
  302. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1346'
      AND r.gidNumber='1012'
  303. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1350'
      AND r.gidNumber='1012'
  304. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1353'
      AND r.gidNumber='1012'
  305. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1355'
      AND r.gidNumber='1012'
  306. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1356'
      AND r.gidNumber='1012'
  307. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1357'
      AND r.gidNumber='1012'
  308. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1359'
      AND r.gidNumber='1012'
  309. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1360'
      AND r.gidNumber='1012'
  310. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1361'
      AND r.gidNumber='1012'
  311. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1362'
      AND r.gidNumber='1012'
  312. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1363'
      AND r.gidNumber='1012'
  313. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1364'
      AND r.gidNumber='1012'
  314. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1365'
      AND r.gidNumber='1012'
  315. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1366'
      AND r.gidNumber='1012'
  316. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1367'
      AND r.gidNumber='1012'
  317. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1368'
      AND r.gidNumber='1012'
  318. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1369'
      AND r.gidNumber='1012'
  319. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1370'
      AND r.gidNumber='1012'
  320. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1371'
      AND r.gidNumber='1012'
  321. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1372'
      AND r.gidNumber='1012'
  322. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1373'
      AND r.gidNumber='1012'
  323. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1374'
      AND r.gidNumber='1012'
  324. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1375'
      AND r.gidNumber='1012'
  325. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1376'
      AND r.gidNumber='1012'
  326. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1377'
      AND r.gidNumber='1012'
  327. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1379'
      AND r.gidNumber='1012'
  328. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1380'
      AND r.gidNumber='1012'
  329. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1381'
      AND r.gidNumber='1012'
  330. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1382'
      AND r.gidNumber='1012'
  331. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1383'
      AND r.gidNumber='1012'
  332. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1385'
      AND r.gidNumber='1012'
  333. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1386'
      AND r.gidNumber='1012'
  334. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1387'
      AND r.gidNumber='1012'
  335. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1388'
      AND r.gidNumber='1012'
  336. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1390'
      AND r.gidNumber='1012'
  337. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1391'
      AND r.gidNumber='1012'
  338. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1392'
      AND r.gidNumber='1012'
  339. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1393'
      AND r.gidNumber='1012'
  340. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1394'
      AND r.gidNumber='1012'
  341. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1395'
      AND r.gidNumber='1012'
  342. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1396'
      AND r.gidNumber='1012'
  343. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1397'
      AND r.gidNumber='1012'
  344. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1398'
      AND r.gidNumber='1012'
  345. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1399'
      AND r.gidNumber='1012'
  346. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1401'
      AND r.gidNumber='1012'
  347. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1402'
      AND r.gidNumber='1012'
  348. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1403'
      AND r.gidNumber='1012'
  349. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1404'
      AND r.gidNumber='1012'
  350. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1405'
      AND r.gidNumber='1012'
  351. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1406'
      AND r.gidNumber='1012'
  352. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1407'
      AND r.gidNumber='1012'
  353. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1408'
      AND r.gidNumber='1012'
  354. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1409'
      AND r.gidNumber='1012'
  355. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1410'
      AND r.gidNumber='1012'
  356. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1411'
      AND r.gidNumber='1012'
  357. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1412'
      AND r.gidNumber='1012'
  358. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1413'
      AND r.gidNumber='1012'
  359. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1414'
      AND r.gidNumber='1012'
  360. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1416'
      AND r.gidNumber='1012'
  361. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1417'
      AND r.gidNumber='1012'
  362. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1418'
      AND r.gidNumber='1012'
  363. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1419'
      AND r.gidNumber='1012'
  364. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1420'
      AND r.gidNumber='1012'
  365. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1421'
      AND r.gidNumber='1012'
  366. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1422'
      AND r.gidNumber='1012'
  367. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1423'
      AND r.gidNumber='1012'
  368. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1424'
      AND r.gidNumber='1012'
  369. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1425'
      AND r.gidNumber='1012'
  370. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1447'
      AND r.gidNumber='1012'
  371. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1450'
      AND r.gidNumber='1012'
  372. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1454'
      AND r.gidNumber='1012'
  373. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1467'
      AND r.gidNumber='1012'
  374. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1478'
      AND r.gidNumber='1012'
  375. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1502'
      AND r.gidNumber='1012'
  376. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1514'
      AND r.gidNumber='1012'
  377. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1545'
      AND r.gidNumber='1012'
  378. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1554'
      AND r.gidNumber='1012'
  379. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1578'
      AND r.gidNumber='1012'
  380. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1584'
      AND r.gidNumber='1012'
  381. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1593'
      AND r.gidNumber='1012'
  382. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1608'
      AND r.gidNumber='1012'
  383. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1666'
      AND r.gidNumber='1012'
  384. SELECT r.id, r.name, r.permissions
      FROM `jos_xgroups_roles` as r, `jos_xgroups_member_roles` as m
      WHERE r.id=m.roleid
      AND m.uidNumber='1671'
      AND r.gidNumber='1012'
  385. SELECT COUNT(jos_item_comments.id) AS count
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`item_type` = 'groups'
      AND `jos_item_comments`.`item_id` = '13'
      AND `jos_item_comments`.`parent` = '0'
      AND `jos_item_comments`.`state` IN ('1','3')
      LIMIT 25
  386. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`item_type` = 'groups'
      AND `jos_item_comments`.`item_id` = '13'
      AND `jos_item_comments`.`parent` = '0'
      AND `jos_item_comments`.`state` IN ('1','3')
      ORDER BY `created` ASC
      LIMIT 20
  387. SELECT COUNT(jos_announcements.id) AS count
      FROM `jos_announcements`
      WHERE `jos_announcements`.`scope` = '
      group'
      AND `jos_announcements`.`scope_id` = '1012'
      AND `jos_announcements`.`state` = '1'
      AND (`jos_announcements`.`publish_up` IS NULL OR `jos_announcements`.`publish_up` <= '2024-03-28 18:33:45' )
      AND (`jos_announcements`.`publish_down` IS NULL OR `jos_announcements`.`publish_down` >= '2024-03-28 18:33:45' )
  388. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  389. SELECT COUNT(jos_blog_entries.id) AS count
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = '
      group'
      AND `jos_blog_entries`.`scope_id` = '1012'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2024-03-28 18:33:45' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2024-03-28 18:33:45' )
  390. SELECT COUNT(*)
      FROM `jos_events`
      WHERE scope='
      group'
      AND scope_id=1012
      AND state=1
      AND (publish_up >='2024-03-28 18:33:45' OR publish_down >= '2024-03-28 18:33:45')
  391. SELECT COUNT(*)
      FROM `jos_events`
      WHERE scope='
      group'
      AND scope_id=1012
      AND state=1
      AND (publish_up >= '2024-03-28 18:33:45' OR publish_down >= '2024-03-28 18:33:45')
      AND publish_up <= '2024-03-31 23:59:59'
  392. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  393. SHOW FULL COLUMNS
      FROM `jos_collections`
  394. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      LEFT JOIN `jos_xgroups` AS g
      ON g.gidNumber=b.object_id
      AND b.object_type='
      group'
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='1012'
      AND b.object_type='
      group'
  395. SHOW FULL COLUMNS
      FROM `jos_courses`
  396. SELECT COUNT(*)
      FROM jos_courses AS c
      WHERE c.group_id='1012'
  397. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  398. SELECT COUNT(jos_forum_posts.id) AS count
      FROM `jos_forum_posts`
      WHERE `jos_forum_posts`.`scope` = '
      group'
      AND `jos_forum_posts`.`scope_id` = '1012'
      AND `jos_forum_posts`.`state` = '1'
      AND `jos_forum_posts`.`parent` = '0'
  399. SELECT *
      FROM `jos_xgroups_memberoption`
      WHERE `jos_xgroups_memberoption`.`gidNumber` = '1012'
      AND `jos_xgroups_memberoption`.`userid` = '0'
      AND `jos_xgroups_memberoption`.`optionname` = 'receive-forum-email'
  400. SHOW FULL COLUMNS
      FROM `jos_projects`
  401. SELECT DISTINCT p.id
      FROM jos_project_owners as po, jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.created_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE p.id=po.projectid
      AND p.state NOT IN (2, 3)
      AND po.status=1
      AND po.groupid=1012
  402. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  403. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`published` IN ('1')
      AND `jos_resources`.`group_owner` = 'general'
      AND `jos_resources`.`access` IN ('0','1','2','3','4')
      AND (`jos_resources`.`publish_up` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_up` <= '2024-03-28 18:33:45' )
      AND (`jos_resources`.`publish_down` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_down` >= '2024-03-28 18:33:45' )
  404. SELECT jos_resources.*
      FROM `jos_resources`
      WHERE `jos_resources`.`published` IN ('1')
      AND `jos_resources`.`group_owner` = 'general'
      AND `jos_resources`.`access` IN ('0','1','2','3','4')
      AND (`jos_resources`.`publish_up` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_up` IS NULL OR `jos_resources`.`publish_up` <= '2024-03-28 18:33:45' )
      AND (`jos_resources`.`publish_down` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_down` IS NULL OR `jos_resources`.`publish_down` >= '2024-03-28 18:33:45' )
      GROUP BY jos_resources.id
      ORDER BY `rating` ASC
      LIMIT 15
  405. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  406. SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`scope` = '
      group'
      AND `jos_wiki_pages`.`scope_id` = '1012'
      AND `jos_wiki_pages`.`state` = '1'
  407. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  408. SELECT *
      FROM `jos_wishlist`
      WHERE `jos_wishlist`.`referenceid` = '1012'
      AND `jos_wishlist`.`category` = '
      group'
  409. SELECT *
      FROM `jos_wishlist_ownergroups`
      WHERE `jos_wishlist_ownergroups`.`wishlist` = '14'
  410. SELECT *
      FROM `jos_wishlist_owners`
      WHERE `jos_wishlist_owners`.`wishlist` = '14'
      AND `jos_wishlist_owners`.`type` != '2'
  411. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  412. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'manage'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  413. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  414. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  415. SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
      WHERE `jos_wishlist_item`.`wishlist` = '14'
      AND `jos_wishlist_item`.`status` != '2'
      AND `jos_wishlist_item`.`private` = '0'
  416. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = '
      group'
      AND `jos_activity_recipients`.`scope_id` = '1012'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  417. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  418. SELECT *
      FROM jos_xgroups_pages
      WHERE gidNumber='1012'
      AND state IN (1)
      ORDER BY lft ASC
  419. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'groups'
      AND `jos_tags_object`.`objectid` = '1012'
      GROUP BY jos_tags_object.label,jos_tags.id
  420. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_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` IS NULL OR `m`.`publish_up` <= '2024-03-28 18:33:45' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-03-28 18:33:45' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '81' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  421. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  422. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  423. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  424. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  425. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  426. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  427. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  428. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  429. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711650824;s:18:\"session.timer.last\";i:1711650824;s:17:\"session.timer.now\";i:1711650824;s:24:\"session.client.forwarded\";s:12:\"52.90.50.252\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":4:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":2:{s:6:\"Groups\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:3:\"Orm\";O:8:\"stdClass\":2:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Answer\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}s:7:\"Plugins\";O:8:\"stdClass\":1:{s:7:\"Hubzero\";O:8:\"stdClass\":1:{s:8:\"Comments\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Comment\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:3:\"asc\";}}}}}s:7:\"Comment\";O:8:\"stdClass\":2:{s:5:\"start\";d:0;s:5:\"
      limit\";i:20;}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"bfc8d44c7fb971355f2062209f152ed4\";s:12:\"tracker.ssid\";s:32:\"bfc8d44c7fb971355f2062209f152ed4\";s:12:\"tracker.rsid\";s:32:\"bfc8d44c7fb971355f2062209f152ed4\";}',`time` = '1711650825',`ip` = '10.84.154.133'
      WHERE `session_id` = 'bfc8d44c7fb971355f2062209f152ed4'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:20
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:21
  • onGroupAreas Method plgGroupsMembers::onGroupAreas /core/plugins/groups/members/members.php:59
  • onGroupAreas Method plgGroupsAnnouncements::onGroupAreas /core/plugins/groups/announcements/announcements.php:55
  • onGroupAreas Method plgGroupsBlog::onGroupAreas /core/plugins/groups/blog/blog.php:55
  • onGroupAreas Method plgGroupsCalendar::onGroupAreas /core/plugins/groups/calendar/calendar.php:58
  • onGroupAreas Method plgGroupsCollections::onGroupAreas /core/plugins/groups/collections/collections.php:127
  • onGroupAreas Method plgGroupsCourses::onGroupAreas /core/plugins/groups/courses/courses.php:55
  • onGroupAreas Method plgGroupsForum::onGroupAreas /core/plugins/groups/forum/forum.php:61
  • onGroupAreas Method plgGroupsMemberOptions::onGroupAreas /core/plugins/groups/memberoptions/memberoptions.php:28
  • onGroupAreas Method plgGroupsMessages::onGroupAreas /core/plugins/groups/messages/messages.php:55
  • onGroupAreas Method plgGroupsProjects::onGroupAreas /core/plugins/groups/projects/projects.php:68
  • onGroupAreas Method plgGroupsResources::onGroupAreas /core/plugins/groups/resources/resources.php:78
  • onGroupAreas Method plgGroupsWiki::onGroupAreas /core/plugins/groups/wiki/wiki.php:55
  • onGroupAreas Method plgGroupsWishlist::onGroupAreas /core/plugins/groups/wishlist/wishlist.php:55
  • onGroupAreas Method plgGroupsFiles::onGroupAreas /core/plugins/groups/files/files.php:55
  • onGroupAreas Method plgGroupsActivity::onGroupAreas /core/plugins/groups/activity/activity.php:28
  • onAddIndex Method plgSearchSolr::onAddIndex /core/plugins/search/solr/solr.php:56
  • onContentSave Method plgSystemContent::onContentSave /core/plugins/system/content/content.php:23
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare Method plgContentFormatwiki::onContentPrepare /core/plugins/content/formatwiki/formatwiki.php:63
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • onAfterDisplayContent Method plgHubzeroComments::onAfterDisplayContent /core/plugins/hubzero/comments/comments.php:39
  • onGroup Method plgGroupsMembers::onGroup /core/plugins/groups/members/members.php:84
  • onGroup Method plgGroupsAnnouncements::onGroup /core/plugins/groups/announcements/announcements.php:131
  • onGroup Method plgGroupsBlog::onGroup /core/plugins/groups/blog/blog.php:80
  • onGroup Method plgGroupsCalendar::onGroup /core/plugins/groups/calendar/calendar.php:83
  • onGroup Method plgGroupsCollections::onGroup /core/plugins/groups/collections/collections.php:152
  • onGroup Method plgGroupsCourses::onGroup /core/plugins/groups/courses/courses.php:80
  • onGroup Method plgGroupsForum::onGroup /core/plugins/groups/forum/forum.php:86
  • onGroup Method plgGroupsMemberOptions::onGroup /core/plugins/groups/memberoptions/memberoptions.php:54
  • onGroup Method plgGroupsMessages::onGroup /core/plugins/groups/messages/messages.php:80
  • onGroup Method plgGroupsProjects::onGroup /core/plugins/groups/projects/projects.php:93
  • onGroup Method plgGroupsResources::onGroup /core/plugins/groups/resources/resources.php:103
  • onGroup Method plgGroupsWiki::onGroup /core/plugins/groups/wiki/wiki.php:80
  • onGroup Method plgGroupsWishlist::onGroup /core/plugins/groups/wishlist/wishlist.php:81
  • onGroup Method plgGroupsFiles::onGroup /core/plugins/groups/files/files.php:80
  • onGroup Method plgGroupsActivity::onGroup /core/plugins/groups/activity/activity.php:53
  • onBeforeGroup Method plgGroupsAnnouncements::onBeforeGroup /core/plugins/groups/announcements/announcements.php:74
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:22
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:60
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:25
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:21