- $_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
=>
ZRiyABxMS9joEAFQ21tYBQAAAAI
,
REDIRECT_SCRIPT_URL
=>
/groups/general
,
REDIRECT_SCRIPT_URI
=>
https://ielab.info/groups/general
,
REDIRECT_HTTPS
=>
on
,
REDIRECT_STATUS
=>
200
,
HTTP_AUTHORIZATION
=>
,
UNIQUE_ID
=>
ZRiyABxMS9joEAFQ21tYBQAAAAI
,
SCRIPT_URL
=>
/groups/general
,
SCRIPT_URI
=>
https://ielab.info/groups/general
,
HTTPS
=>
on
,
HTTP_X_FORWARDED_FOR
=>
34.239.148.127
,
HTTP_X_FORWARDED_PROTO
=>
https
,
HTTP_X_FORWARDED_PORT
=>
443
,
HTTP_HOST
=>
ielab.info
,
HTTP_X_AMZN_TRACE_ID
=>
Root=1-6518b200-73dbcd4b4fdf955f37f31b7d
,
HTTP_USER_AGENT
=>
CCBot/2.0 (https://commoncrawl.org/faq/)
,
HTTP_ACCEPT
=>
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
,
HTTP_ACCEPT_LANGUAGE
=>
en-US,en;q=0.5
,
HTTP_IF_MODIFIED_SINCE
=>
Wed, 22 Mar 2023 03:52:00 GMT
,
HTTP_ACCEPT_ENCODING
=>
br,gzip
,
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.140
,
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
=>
52610
,
REDIRECT_URL
=>
/groups/general
,
GATEWAY_INTERFACE
=>
CGI/1.1
,
SERVER_PROTOCOL
=>
HTTP/1.1
,
REQUEST_METHOD
=>
GET
,
QUERY_STRING
=>
,
REQUEST_URI
=>
/groups/general
,
SCRIPT_NAME
=>
/index.php
,
PHP_SELF
=>
/index.php
,
REQUEST_TIME_FLOAT
=>
1696117248.6077
,
REQUEST_TIME
=>
1696117248
)
session.client.forwarded ⇒ 34.239.148.127
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ d7ba743b5b05eec8424b78779b8278fe
tracker.ssid ⇒ d7ba743b5b05eec8424b78779b8278fe
tracker.rsid ⇒ d7ba743b5b05eec8424b78779b8278fe
40 MB
427 Queries Logged: 0.0890052318573 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = '9f2b4e0fd918f6cbc02d4b0feb803fe0'
DELETE
FROM `jos_session`
WHERE `session_id` = '9f2b4e0fd918f6cbc02d4b0feb803fe0'
SELECT data
FROM `jos_session`
WHERE `session_id` = 'd7ba743b5b05eec8424b78779b8278fe'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT session_id
FROM `jos_session`
WHERE `session_id` = 'd7ba743b5b05eec8424b78779b8278fe'
LIMIT 1
INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('d7ba743b5b05eec8424b78779b8278fe','0','1696117248','10.84.154.140')
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_members'
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'
SELECT *
FROM `jos_viewlevels`
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
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
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_groups'
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
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tags'
DELETE
FROM `jos_xgroups_pages_checkout`
WHERE `userid`='0'
SELECT *
FROM `jos_xgroups`
WHERE cn = 'general';
(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')
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_projects'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_resources'
SHOW FULL COLUMNS
FROM `jos_xgroups_pages`
SELECT *
FROM jos_xgroups_pages
WHERE gidNumber='1012'
AND state IN (0,1)
ORDER BY lft ASC
SHOW FULL COLUMNS
FROM `jos_xgroups_pages_versions`
SELECT *
FROM jos_xgroups_pages_versions
WHERE pageid='13'
ORDER BY version DESC
SHOW FULL COLUMNS
FROM `jos_xgroups_pages_hits`
INSERT INTO `jos_xgroups_pages_hits` (`gidNumber`,`pageid`,`userid`,`date`,`ip`)
VALUES ('1012','13','0','2023-09-30 23:40:49','10.84.154.140')
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_courses'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_publications'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_search'
SHOW TABLES LIKE 'jos_solr_search_searchcomponents'
SELECT *
FROM `jos_solr_search_searchcomponents`
WHERE `jos_solr_search_searchcomponents`.`name` = 'groups'
SHOW FULL COLUMNS
FROM `jos_xgroups_pages_categories`
SELECT *
FROM `jos_xgroups_description_fields`
ORDER BY `ordering` ASC
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
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
SELECT r.id, 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'
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
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
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` <= '2023-09-30 23:40:49'
)
AND (`jos_announcements`.`publish_down` IS NULL
OR `jos_announcements`.`publish_down` >= '2023-09-30 23:40:49'
)
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_blog'
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` <= '2023-09-30 23:40:49'
)
AND (`jos_blog_entries`.`publish_down` IS NULL
OR `jos_blog_entries`.`publish_down` >= '2023-09-30 23:40:49'
)
SELECT COUNT(*)
FROM `jos_events`
WHERE scope='
group'
AND scope_id=1012
AND state=1
AND (publish_up >='2023-09-30 23:40:49' OR publish_down >= '2023-09-30 23:40:49')
SELECT COUNT(*)
FROM `jos_events`
WHERE scope='
group'
AND scope_id=1012
AND state=1
AND (publish_up >= '2023-09-30 23:40:49' OR publish_down >= '2023-09-30 23:40:49')
AND publish_up <= '2023-09-30 23:59:59'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_collections'
SHOW FULL COLUMNS
FROM `jos_collections`
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'
SHOW FULL COLUMNS
FROM `jos_courses`
SELECT COUNT(*)
FROM jos_courses AS c
WHERE c.group_id='1012'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_forum'
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'
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'
SHOW FULL COLUMNS
FROM `jos_projects`
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
SELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`category` = '27'
ORDER BY `type` ASC
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` <= '2023-09-30 23:40:49'
)
AND (`jos_resources`.`publish_down` = '0000-00-00 00:00:00'
OR `jos_resources`.`publish_down` >= '2023-09-30 23:40:49'
)
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` <= '2023-09-30 23:40:49'
)
AND (`jos_resources`.`publish_down` = '0000-00-00 00:00:00'
OR `jos_resources`.`publish_down` IS NULL
OR `jos_resources`.`publish_down` >= '2023-09-30 23:40:49'
)
GROUP BY jos_resources.id
ORDER BY `rating` ASC
LIMIT 15
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wiki'
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'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wishlist'
SELECT *
FROM `jos_wishlist`
WHERE `jos_wishlist`.`referenceid` = '1012'
AND `jos_wishlist`.`category` = '
group'
SELECT *
FROM `jos_wishlist_ownergroups`
WHERE `jos_wishlist_ownergroups`.`wishlist` = '14'
SELECT *
FROM `jos_wishlist_owners`
WHERE `jos_wishlist_owners`.`wishlist` = '14'
AND `jos_wishlist_owners`.`type` != '2'
SELECT a.rules
FROM `jos_assets` AS `a`
WHERE `a`.`id` = '1'
GROUP BY a.id, a.rules, a.lft
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
SELECT *
FROM `jos_assets`
WHERE `jos_assets`.`parent_id` = '0'
SELECT *
FROM `jos_assets`
WHERE `jos_assets`.`id` = '1'
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'
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
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT *
FROM jos_xgroups_pages
WHERE gidNumber='1012'
AND state IN (1)
ORDER BY lft ASC
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
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` <= '2023-09-30 23:40:49'
)
AND (`m`.`publish_down` IS NULL
OR `m`.`publish_down` >= '2023-09-30 23:40:49'
)
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
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_support'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_categories'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_newsletter'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_answers'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_citations'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_kb'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_media'
UPDATE `jos_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1696117248;s:18:\"session.timer.last\";i:1696117248;s:17:\"session.timer.now\";i:1696117248;s:24:\"session.client.forwarded\";s:14:\"34.239.148.127\";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:\"d7ba743b5b05eec8424b78779b8278fe\";s:12:\"tracker.ssid\";s:32:\"d7ba743b5b05eec8424b78779b8278fe\";s:12:\"tracker.rsid\";s:32:\"d7ba743b5b05eec8424b78779b8278fe\";}',`time` = '1696117249',`ip` = '10.84.154.140'
WHERE `session_id` = 'd7ba743b5b05eec8424b78779b8278fe'
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