- $_GET
-
Array(
)
Array(
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
)
Array(
)
- $_SERVER
-
Array(
REDIRECT_SCRIPT_URL => /tags/rproject,
REDIRECT_SCRIPT_URI => https://sparc.purdue.edu...
Array(
REDIRECT_SCRIPT_URL => /tags/rproject,
REDIRECT_SCRIPT_URI => https://sparc.purdue.edu/tags/rproject,
REDIRECT_nokeepalive =>
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => sparc.purdue.edu,
REDIRECT_STATUS => 200,
SCRIPT_URL => /tags/rproject,
SCRIPT_URI => https://sparc.purdue.edu/tags/rproject,
nokeepalive =>
HTTPS => on,
SSL_TLS_SNI => sparc.purdue.edu,
HTTP_HOST => sparc.purdue.edu,
HTTP_ACCEPT_ENCODING => x-gzip, gzip, deflate,
HTTP_USER_AGENT => CCBot/2.0 (http://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_IF_MODIFIED_SINCE => Wed, 26 Jul 2017 16:39:19 GMT,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE =>
SERVER_SOFTWARE => Apache/2.2.15 (CentOS),
SERVER_NAME => sparc.purdue.edu,
SERVER_ADDR => 192.168.1.57,
SERVER_PORT => 443,
REMOTE_ADDR => 54.156.93.60,
DOCUMENT_ROOT => /var/www/kermit,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/kermit/index.php,
REMOTE_PORT => 40214,
REDIRECT_URL => /tags/rproject,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.0,
REQUEST_METHOD => GET,
QUERY_STRING =>
REQUEST_URI => /tags/rproject,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1506416824.819,
REQUEST_TIME => 1506416824
)
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ db811f0ddbe8835d51ad46e55f1347f7
tracker.ssid ⇒ db811f0ddbe8835d51ad46e55f1347f7
tracker.rsid ⇒ db811f0ddbe8835d51ad46e55f1347f7
6 MB
66 Queries Logged: 0.022697925567627 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = 'e9d0c8e034f15acf78686de42c0280b4'DELETE
FROM`jos_session`
WHERE `session_id` = 'e9d0c8e034f15acf78686de42c0280b4'SELECT data
FROM `jos_session`
WHERE `session_id` = 'db811f0ddbe8835d51ad46e55f1347f7'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` = 'db811f0ddbe8835d51ad46e55f1347f7'
LIMIT 1INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('db811f0ddbe8835d51ad46e55f1347f7','0','1506416824','54.156.93.60')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` ASCSELECT 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` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tags'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`
AND `jos_template_styles`.`id` = '15'
ORDER BY `home` DESCSELECT *
FROM `jos_tags`
WHERE `jos_tags`.`tag` = 'rproject'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_resources'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_publications'SHOW FULL COLUMNS
FROM `jos_resource_types`SELECT *
FROM jos_resource_types
WHERE category='27'
ORDER BY typeSHOW FULL COLUMNS
FROM `jos_resources`( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_applicants AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_members AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM jos_xgroups AS g, jos_xgroups_managers AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_invitees AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 )SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=77
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=72
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=3
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=75
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=9
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=74
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=76
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=1
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=78
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=71
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=39
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=7
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
AND r.type=2
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT COUNT(f.id)
FROM (SELECT v.page_id AS id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_wiki_pages AS w
INNER JOIN jos_wiki_versions AS v
ON v.id=w.version_id
LEFT JOIN `jos_xgroups` xg
ON xg.gidNumber = w.scope_id
AND w.scope='
group', jos_tags_object AS t
WHERE w.id=v.page_id
AND v.approved=1
AND w.state < 2
AND (xg.gidNumber IS NULL OR (xg.plugins LIKE '%wiki=anyone%'))
AND w.id=t.objectid
AND t.tbl='wiki'
AND t.tagid IN (46)
GROUP BY page_id
HAVING uniques=1 ) AS fSELECT COUNT(f.uidNumber)
FROM (SELECT a.uidNumber, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_xprofiles AS a
LEFT JOIN jos_xprofiles_bio AS b
ON a.uidNumber=b.uidNumber, jos_tags_object AS t
WHERE a.public=1
AND a.uidNumber=t.objectid
AND t.tbl='xprofiles'
AND t.tagid IN (46)
GROUP BY a.uidNumber
HAVING uniques=1) AS fSELECT a.rules
FROM `jos_assets` AS `a`
WHERE `a`.`id` = '1'
GROUP BY a.id, a.rules, a.lftSELECT 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` = 'com_groups'
GROUP BY b.id, b.rules, b.lft
ORDER BY `b`.`lft` ASCSELECT COUNT(f.gidNumber)
FROM (SELECT a.gidNumber, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
ON m.gidNumber=a.gidNumber
AND m.uidNumber=0
JOIN jos_tags_object AS t
WHERE (a.type=1 OR a.type=3)
AND a.discoverability=0
AND a.gidNumber=t.objectid
AND t.tbl='groups'
AND t.tagid IN (46)
GROUP BY a.gidNumber
HAVING uniques=1) AS fSELECT COUNT(f.id)
FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_answers_questions AS a, jos_tags_object AS t
WHERE a.id=t.objectid
AND t.tbl='answers'
AND t.tagid IN (46)
AND a.state!=2
GROUP BY a.id
HAVING uniques=1) AS fSELECT DISTINCT gidNumber
FROM `jos_xgroups_members`
WHERE uidNumber=0SELECT 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` = 'com_forum'
GROUP BY b.id, b.rules, b.lft
ORDER BY `b`.`lft` ASCSELECT COUNT(f.id)
FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_forum_posts AS e
LEFT JOIN jos_forum_categories c
ON c.id = e.category_id
LEFT JOIN jos_forum_sections s
ON s.id = c.section_id
LEFT JOIN jos_xgroups g
ON g.gidNumber = e.scope_id
LEFT JOIN jos_tags_object AS t
ON t.objectid=e.id
AND t.tbl='forum'
AND t.tagid IN (46)
WHERE e.state=1
AND e.parent=0
AND e.scope_id IN (0)
GROUP BY e.id
HAVING uniques=1) AS fSELECT COUNT(f.id)
FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_blog_entries AS e, jos_tags_object AS t, jos_users AS u
WHERE e.created_by=u.id
AND t.objectid=e.id
AND t.tbl='blog'
AND t.tagid IN (46)
AND e.state=1
AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2017-09-26 09:07:05')
AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2017-09-26 09:07:05')
GROUP BY e.id
HAVING uniques=1) AS fSELECT COUNT(f.id)
FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_citations AS e, jos_tags_object AS t
WHERE t.objectid=e.id
AND t.tbl='citations'
AND t.tagid IN (46)
AND e.published=1
AND e.id!=''
GROUP BY e.id
HAVING uniques=1) AS fSELECT COUNT(f.id)
FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_kb_articles AS e
LEFT JOIN jos_categories AS cc
ON cc.id = e.category
LEFT JOIN jos_tags_object AS t
ON t.objectid=e.id
AND t.tbl='kb'
AND t.tagid IN (46)
WHERE e.state=1
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`SELECT *
FROM jos_publication_categories as C
WHERE C.state=1
ORDER BY C.name ASCSHOW FULL COLUMNS
FROM `jos_publications`( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_applicants AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_members AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM jos_xgroups AS g, jos_xgroups_managers AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_invitees AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 )SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_publication_versions as V, jos_publications AS r
LEFT JOIN jos_publication_categories AS rt
ON r.category=rt.id, jos_tags_object AS t
WHERE V.publication_id=r.id
AND V.state=1
AND V.main = 1
AND t.objectid=r.id
AND t.tbl='publications'
AND t.tagid IN (46)
AND r.category=1
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_publication_versions as V, jos_publications AS r
LEFT JOIN jos_publication_categories AS rt
ON r.category=rt.id, jos_tags_object AS t
WHERE V.publication_id=r.id
AND V.state=1
AND V.main = 1
AND t.objectid=r.id
AND t.tbl='publications'
AND t.tagid IN (46)
AND r.category=3
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_publication_versions as V, jos_publications AS r
LEFT JOIN jos_publication_categories AS rt
ON r.category=rt.id, jos_tags_object AS t
WHERE V.publication_id=r.id
AND V.state=1
AND V.main = 1
AND t.objectid=r.id
AND t.tbl='publications'
AND t.tagid IN (46)
AND r.category=7
GROUP BY r.id
HAVING uniques=1 ) AS fSELECT COUNT(f.id)
FROM (SELECT p.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_collections_posts AS p
INNER JOIN jos_collections AS c
ON c.id=p.collection_id
INNER JOIN jos_collections_items AS i
ON p.item_id=i.id
INNER JOIN jos_tags_object AS t
WHERE i.state=1
AND c.state=1
AND t.objectid=p.item_id
AND t.tbl='bulletinboard'
AND t.tagid IN (46)
AND i.access=0
AND c.access=0
GROUP BY p.id
HAVING uniques=1) AS fSELECT COUNT(f.id)
FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_courses` AS e, `jos_tags_object` AS t, `jos_users` AS u
WHERE e.created_by=u.id
AND e.state=1
AND t.objectid=e.id
AND t.tbl='courses'
AND t.tagid IN (46)
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1) AS f(SELECT DISTINCT r.id, r.title, r.alias, r.introtext AS itext, r.fulltxt AS ftext, r.published AS state, r.created, r.created_by, r.modified, r.publish_up, r.publish_down,
CONCAT('index.php?option=com_resources&id=', r.id) AS href, 'resources' AS section , COUNT(DISTINCT t.tagid) AS uniques , r.params, r.rating AS rcount, r.type AS data1, rt.type AS data2, r.ranking data3
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , jos_tags_object AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (46)
GROUP BY r.id
HAVING uniques=1
ORDER BY publish_up DESC) UNION (SELECT v.page_id AS id, w.title, w.pagename AS alias, v.pagetext AS itext, v.pagehtml AS ftext, w.state, v.created, v.created_by,
v.created AS modified, v.created AS publish_up, NULL AS publish_down,
CASE
WHEN w.scope = 'project' THEN concat('index.php?option=com_projects&scope=', w.path, '&pagename=', w.pagename)
WHEN w.scope = '
group' THEN CONCAT('index.php?option=com_groups&scope=', w.path, '&pagename=', w.pagename)
ELSE CONCAT('index.php?option=com_wiki&pagename=', w.pagename)
END AS href,
'wiki' AS section , COUNT(DISTINCT t.tagid) AS uniques , w.params, NULL AS rcount, w.scope AS data1, NULL AS data2, NULL AS data3
FROM jos_wiki_pages AS w
INNER JOIN jos_wiki_versions AS v
ON v.id=w.version_id
LEFT JOIN `jos_xgroups` xg
ON xg.gidNumber = w.scope_id
AND w.scope='
group', jos_tags_object AS t
WHERE w.id=v.page_id
AND v.approved=1
AND w.state < 2
AND (xg.gidNumber IS NULL OR (xg.plugins LIKE '%wiki=anyone%'))
AND w.id=t.objectid
AND t.tbl='wiki'
AND t.tagid IN (46)
GROUP BY page_id
HAVING uniques=1
ORDER BY created DESC) UNION (SELECT a.uidNumber AS id, a.name AS title, a.username as alias, NULL AS itext, b.bio AS ftext, a.emailConfirmed AS state, a.registerDate AS created,
a.uidNumber AS created_by, NULL AS modified, a.registerDate AS publish_up, a.picture AS publish_down,
CONCAT('index.php?option=com_members&id=', a.uidNumber) AS href, 'members' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.params, NULL AS rcount,
NULL AS data1, NULL AS data2, NULL AS data3
FROM jos_xprofiles AS a
LEFT JOIN jos_xprofiles_bio AS b
ON a.uidNumber=b.uidNumber, jos_tags_object AS t
WHERE a.public=1
AND a.uidNumber=t.objectid
AND t.tbl='xprofiles'
AND t.tagid IN (46)
GROUP BY a.uidNumber
HAVING uniques=1) UNION (SELECT a.gidNumber AS id, a.description AS title, a.cn AS alias, NULL AS itext, a.public_desc AS ftext, a.type AS state, a.created,
a.created_by, NULL AS modified, NULL AS publish_up,
NULL AS publish_down, CONCAT('index.php?option=com_groups&cn=', a.cn) AS href, 'groups' AS section, COUNT(DISTINCT t.tagid) AS uniques,
a.params, NULL AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
ON m.gidNumber=a.gidNumber
AND m.uidNumber=0
JOIN jos_tags_object AS t
WHERE (a.type=1 OR a.type=3)
AND a.discoverability=0
AND a.gidNumber=t.objectid
AND t.tbl='groups'
AND t.tagid IN (46)
GROUP BY a.gidNumber
HAVING uniques=1) UNION (SELECT a.id, a.subject AS title, NULL AS alias, NULL AS itext, a.question AS ftext, a.state, a.created, a.created_by,
NULL AS modified, a.created AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_answers&task=question&id=', a.id) AS href,
'answers' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.anonymous AS params,
(SELECT COUNT(*)
FROM jos_answers_responses AS r
WHERE r.question_id=a.id) AS rcount,
NULL AS data1, NULL AS data2, NULL AS data3
FROM jos_answers_questions AS a, jos_tags_object AS t
WHERE a.id=t.objectid
AND t.tbl='answers'
AND t.tagid IN (46)
AND a.state!=2
GROUP BY a.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.id AS alias, e.comment AS itext, e.comment AS ftext, e.state, e.created, e.created_by, e.modified, e.created AS publish_up, NULL AS publish_down,
(
CASE WHEN e.scope_id > 0
AND e.scope='
group' THEN
concat('/groups/', g.cn, concat('/forum/', coalesce(concat(s.alias, '/', coalesce(concat(c.alias, '/'), ''))),
CASE WHEN e.parent > 0 THEN e.parent ELSE e.id END))
ELSE
concat('/forum/', coalesce(concat(s.alias, '/', coalesce(concat(c.alias, '/'), ''))),
CASE WHEN e.parent > 0 THEN e.parent ELSE e.id END)
END) AS href,
'forum' AS section, COUNT(DISTINCT t.tagid) AS uniques, CONCAT(e.thread, ':', e.parent) AS params, e.scope AS rcount, c.alias AS data1, s.alias AS data2, e.scope_id AS data3
FROM jos_forum_posts AS e
LEFT JOIN jos_forum_categories c
ON c.id = e.category_id
LEFT JOIN jos_forum_sections s
ON s.id = c.section_id
LEFT JOIN jos_xgroups g
ON g.gidNumber = e.scope_id
LEFT JOIN jos_tags_object AS t
ON t.objectid=e.id
AND t.tbl='forum'
AND t.tagid IN (46)
WHERE e.state=1
AND e.parent=0
AND e.scope_id IN (0)
GROUP BY e.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, NULL AS itext, e.content AS ftext, e.state, e.created, e.created_by,
NULL AS modified, e.publish_up, e.publish_down, CONCAT('index.php?option=com_blog&task=view&id=', e.id) AS href,
'blogs' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, e.scope AS rcount, u.name AS data1,
e.scope_id AS data2, NULL AS data3
FROM jos_blog_entries AS e, jos_tags_object AS t, jos_users AS u
WHERE e.created_by=u.id
AND t.objectid=e.id
AND t.tbl='blog'
AND t.tagid IN (46)
AND e.state=1
AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2017-09-26 09:07:05')
AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2017-09-26 09:07:05')
GROUP BY e.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.author, e.booktitle, e.doi, e.published, e.created, e.year, e.month, e.isbn, e.journal, e.url as href,
'citations' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.volume, e.number, e.type, e.pages, e.publisher
FROM jos_citations AS e, jos_tags_object AS t
WHERE t.objectid=e.id
AND t.tbl='citations'
AND t.tagid IN (46)
AND e.published=1
AND e.id!=''
GROUP BY e.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, e.fulltxt AS itext, e.fulltxt AS ftext, e.state, e.created, e.created_by, e.modified, e.created AS publish_up,
NULL AS publish_down, CONCAT('index.php?option=com_kb&category=&alias=', e.alias) AS href, 'kb' AS section, COUNT(DISTINCT t.tagid) AS uniques,
NULL AS params, e.helpful AS rcount, cc.alias AS data1, NULL AS data2, NULL AS data3
FROM jos_kb_articles AS e
LEFT JOIN jos_categories AS cc
ON cc.id = e.category
LEFT JOIN jos_tags_object AS t
ON t.objectid=e.id
AND t.tbl='kb'
AND t.tagid IN (46)
WHERE e.state=1
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1) UNION (SELECT DISTINCT r.id, V.title, V.version_number as alias,
V.abstract as itext, V.id as ftext, V.state AS state, V.created, V.created_by,
V.modified, V.published_up as publish_up, V.published_down as publish_down,
CONCAT('index.php?option=com_publications&id=', r.id) AS href, 'publications' AS section , COUNT(DISTINCT t.tagid) AS uniques , V.params, r.rating AS rcount, r.category AS data1, rt.name AS data2, r.ranking data3
FROM jos_publication_versions as V, jos_publications AS r
LEFT JOIN jos_publication_categories AS rt
ON r.category=rt.id, jos_tags_object AS t
WHERE V.publication_id=r.id
AND V.state=1
AND V.main = 1
AND t.objectid=r.id
AND t.tbl='publications'
AND t.tagid IN (46)
GROUP BY r.id
HAVING uniques=1
ORDER BY publish_up DESC) UNION (SELECT p.id, i.title, c.alias, NULL AS itext,
CASE WHEN (p.description!=''
AND p.description IS NOT NULL) THEN p.description ELSE i.description END AS ftext,
i.state,
p.created,
p.created_by,
NULL AS modified,
p.created AS publish_up,
NULL AS publish_down,
concat('index.php?option=com_collections&controller=posts&post=', p.id) AS href,
'collections' AS section,
COUNT(DISTINCT t.tagid) AS uniques,
c.object_type AS params,
c.object_id AS rcount,
i.type AS data1,
i.object_id AS data2,
NULL AS data3
FROM jos_collections_posts AS p
INNER JOIN jos_collections AS c
ON c.id=p.collection_id
INNER JOIN jos_collections_items AS i
ON p.item_id=i.id
INNER JOIN jos_tags_object AS t
WHERE i.state=1
AND c.state=1
AND t.objectid=p.item_id
AND t.tbl='bulletinboard'
AND t.tagid IN (46)
AND i.access=0
AND c.access=0
GROUP BY p.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, e.blurb AS itext, e.description AS ftext, e.state, e.created, e.created_by,
NULL AS modified, NULL AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_courses&gid=', e.alias) AS href,
'courses' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, 0 AS rcount, u.name AS data1,
NULL AS data2, NULL AS data3
FROM `jos_courses` AS e, `jos_tags_object` AS t, `jos_users` AS u
WHERE e.created_by=u.id
AND e.state=1
AND t.objectid=e.id
AND t.tbl='courses'
AND t.tagid IN (46)
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1)
ORDER BY publish_up DESC, title
LIMIT 0,20SELECT a.authorid, a.name, a.name AS xname, a.organization AS org, a.role, n.uidNumber AS id, n.givenName AS firstname, n.middleName AS middlename, n.surname AS lastname, n.organization AS xorg
FROM jos_author_assoc AS a
LEFT JOIN jos_xprofiles AS n
ON n.uidNumber=a.authorid
WHERE a.subtable='resources'
AND a.subid=70
ORDER BY ordering, surname, givenName, middleNameSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wiki'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_search'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_users'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` = '0000-00-00 00:00:00'
OR `m`.`publish_up` <= '2017-09-26 09:07:05'
)
AND (`m`.`publish_down` = '0000-00-00 00:00:00'
OR `m`.`publish_down` >= '2017-09-26 09:07:05'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '89'
OR `mm`.`menuid` <= '0'
)
ORDER BY `m`.`position` ASC,`m`.`ordering` ASCSELECT 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_collections'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_blog'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_groups'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_answers'UPDATE `jos_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1506416824;s:18:\"session.timer.last\";i:1506416824;s:17:\"session.timer.now\";i:1506416824;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}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:\"db811f0ddbe8835d51ad46e55f1347f7\";s:12:\"tracker.ssid\";s:32:\"db811f0ddbe8835d51ad46e55f1347f7\";s:12:\"tracker.rsid\";s:32:\"db811f0ddbe8835d51ad46e55f1347f7\";}',`time` = '1506416825',`ip` = '54.156.93.60'
WHERE `session_id` = 'db811f0ddbe8835d51ad46e55f1347f7'
onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:45onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:44onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:46onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:46onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:138onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:46onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:46onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:46onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:46onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:46onAfterRoute — Method — plgSystemPassword::onAfterRoute → /core/plugins/system/password/password.php:46onTagView — Method — plgTagsResources::onTagView → /core/plugins/tags/resources/resources.php:73onTagView — Method — plgTagsWiki::onTagView → /core/plugins/tags/wiki/wiki.php:58onTagView — Method — plgTagsMembers::onTagView → /core/plugins/tags/members/members.php:58onTagView — Method — plgTagsGroups::onTagView → /core/plugins/tags/groups/groups.php:58onTagView — Method — plgTagsAnswers::onTagView → /core/plugins/tags/answers/answers.php:58onTagView — Method — plgTagsForum::onTagView → /core/plugins/tags/forum/forum.php:73onTagView — Method — plgTagsBlogs::onTagView → /core/plugins/tags/blogs/blogs.php:58onTagView — Method — plgTagsCitations::onTagView → /core/plugins/tags/citations/citations.php:58onTagView — Method — plgTagsKb::onTagView → /core/plugins/tags/kb/kb.php:58onTagView — Method — plgTagsPublications::onTagView → /core/plugins/tags/publications/publications.php:73onTagView — Method — plgTagsCollections::onTagView → /core/plugins/tags/collections/collections.php:58onTagView — Method — plgTagsCourses::onTagView → /core/plugins/tags/courses/courses.php:58onGetMultiEntry — Method — plgHubzeroAutocompleter::onGetMultiEntry → /core/plugins/hubzero/autocompleter/autocompleter.php:164onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:47onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:87onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:49onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:45