Find information on common issues.
Ask questions and find answers from other users.
Suggest a new site feature or improvement.
Check on status of your tickets.
sort => dateREDIRECT_UNIQUE_ID => Wy@sDIAuE9gAAzzoVeUAAAAB, REDIRECT_SCRIPT_URL => /tags/impacts/members, REDIRECT_SCRIPT_URI => https://vhub.org/tags/impacts/members, REDIRECT_nokeepalive => REDIRECT_HTTPS => on, REDIRECT_SSL_TLS_SNI => vhub.org, REDIRECT_STATUS => 200, UNIQUE_ID => Wy@sDIAuE9gAAzzoVeUAAAAB, SCRIPT_URL => /tags/impacts/members, SCRIPT_URI => https://vhub.org/tags/impacts/members, nokeepalive => HTTPS => on, SSL_TLS_SNI => vhub.org, HTTP_HOST => vhub.org, 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 => Fri, 23 Feb 2018 04:47:59 GMT, HTTP_CONNECTION => close, PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin, SERVER_SIGNATURE => SERVER_SOFTWARE => Apache, SERVER_NAME => vhub.org, SERVER_ADDR => 128.46.19.216, SERVER_PORT => 443, REMOTE_ADDR => 54.145.103.69, DOCUMENT_ROOT => /www/vhub, REQUEST_SCHEME => https, CONTEXT_PREFIX => CONTEXT_DOCUMENT_ROOT => /www/vhub, SERVER_ADMIN => nkissebe@purdue.edu, SCRIPT_FILENAME => /www/vhub/index.php, REMOTE_PORT => 42236, REDIRECT_QUERY_STRING => sort=date, REDIRECT_URL => /tags/impacts/members, GATEWAY_INTERFACE => CGI/1.1, SERVER_PROTOCOL => HTTP/1.1, REQUEST_METHOD => GET, QUERY_STRING => sort=date, REQUEST_URI => /tags/impacts/members?sort=date, SCRIPT_NAME => /index.php, PHP_SELF => /index.php, REQUEST_TIME_FLOAT => 1529850892.51, REQUEST_TIME => 1529850892, argv => Array(
0 => sort=date
)
, argc => 1separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ d352e3e42032af08075772207c03aa9e
tracker.ssid ⇒ d352e3e42032af08075772207c03aa9e
tracker.rsid ⇒ d352e3e42032af08075772207c03aa9e
securiy_code0 ⇒ 07e43
session.token ⇒ 46006828902a044e6833a7635457ff76
site 0.023 seconds (+0.023); 3.50 MB (+3.500) - afterInitialisesite 0.039 seconds (+0.015); 4.00 MB (+0.500) - afterRoutesite 0.115 seconds (+0.077); 7.00 MB (+3.000) - afterDispatchsite 1.145 seconds (+1.030); 27.75 MB (+20.750) - beforeRenderModule mod_search (Search Module)site 1.148 seconds (+0.003); 27.75 MB (0.000) - afterRenderModule mod_search (Search Module)site 1.148 seconds (+0.000); 27.75 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)site 1.161 seconds (+0.013); 28.50 MB (+0.750) - afterRenderModule mod_reportproblems (Trouble Report)site 1.161 seconds (+0.000); 28.50 MB (0.000) - beforeRenderModule mod_custom (V template footer)site 1.162 seconds (+0.001); 28.50 MB (0.000) - afterRenderModule mod_custom (V template footer)site 1.162 seconds (+0.000); 28.50 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)site 1.165 seconds (+0.003); 28.50 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)site 1.165 seconds (+0.000); 28.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)site 1.175 seconds (+0.010); 28.50 MB (0.000) - afterRenderModule mod_menu (Main Menu)site 1.179 seconds (+0.004); 28.50 MB (0.000) - onAfterRendersite 1.182 seconds (+0.003); 28.50 MB (0.000) - sessionStoreSELECT data
FROM `jos_session`
WHERE `session_id` = '03bd208af9322142c49276b0c9d5fe50'DELETE
FROM`jos_session`
WHERE `session_id` = '03bd208af9322142c49276b0c9d5fe50'SELECT data
FROM `jos_session`
WHERE `session_id` = 'd352e3e42032af08075772207c03aa9e'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` = 'd352e3e42032af08075772207c03aa9e'
LIMIT 1INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('d352e3e42032af08075772207c03aa9e','0','1529850892','54.145.103.69')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 con.`id`
FROM `jos_content` AS con
LEFT JOIN `jos_categories` AS cat
ON con.catid = cat.id
WHERE con.state=1
AND con.`alias` = 'members'
AND cat.`path` = 'tags/impacts'SELECT 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`
ORDER BY `home` DESCSELECT *
FROM `jos_tags`
WHERE `jos_tags`.`tag` = 'impacts'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'SELECT 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 (682)
AND a.state!=2
GROUP BY a.id
HAVING uniques=1) AS fSELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`category` = '27'
ORDER BY `type` ASC( 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 (682)
AND r.type=6
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 (682)
AND r.type=62
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 (682)
AND r.type=64
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 (682)
AND r.type=10
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 (682)
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 (682)
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 (682)
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 (682)
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 (682)
AND r.type=67
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 (682)
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'
LEFT JOIN `jos_projects` xp
ON xp.id = w.scope_id
AND w.scope='project', 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 (682)
GROUP BY page_id
HAVING uniques=1 ) AS fSELECT COUNT(f.id)
FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_users AS a
LEFT JOIN jos_user_profiles AS b
ON a.id=b.user_id
AND b.profile_key='bio', jos_tags_object AS t
WHERE a.access IN (1,1,4)
AND a.block=0
AND a.activation > 0
AND a.id=t.objectid
AND t.tbl='xprofiles'
AND t.tagid IN (682)
GROUP BY a.id
HAVING uniques=1) AS fSELECT a.id, a.name AS title, a.username as alias, NULL AS itext, b.profile_value AS ftext, a.activation AS state, a.registerDate AS created,
a.id AS created_by, NULL AS modified, a.registerDate AS publish_up, NULL AS publish_down,
CONCAT('index.php?option=com_members&id=', a.id) 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_users AS a
LEFT JOIN jos_user_profiles AS b
ON a.id=b.user_id
AND b.profile_key='bio', jos_tags_object AS t
WHERE a.access IN (1,1,4)
AND a.block=0
AND a.activation > 0
AND a.id=t.objectid
AND t.tbl='xprofiles'
AND t.tagid IN (682)
GROUP BY a.id
HAVING uniques=1
ORDER BY publish_up DESC, title
LIMIT 0,20SELECT COUNT(f.id)
FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_events AS e, jos_tags_object AS t
WHERE e.state=1
AND t.objectid=e.id
AND t.tbl='events'
AND t.tagid IN (682)
GROUP BY e.id
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 (682)
GROUP BY a.gidNumber
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 (682)
AND e.state=1
AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2018-06-24 14:34:52')
AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2018-06-24 14:34:52')
GROUP BY e.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 (682)
WHERE e.state=1
AND e.parent=0
AND e.scope_id IN (0)
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 (682)
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 (682)
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 (682)
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 (682)
AND e.access IN (1,1,4)
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 (682)
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 (682)
WHERE e.state=1
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1) AS fSELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = '1490'SELECT *
FROM `jos_xprofiles`
WHERE uidNumber = '1490';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` <= '2018-06-24 14:34:53'
)
AND (`m`.`publish_down` = '0000-00-00 00:00:00'
OR `m`.`publish_down` >= '2018-06-24 14:34:53'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '0'
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_support'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_users'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_kb'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_wishlist'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_usage'UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1529850892;s:18:\"session.timer.last\";i:1529850892;s:17:\"session.timer.now\";i:1529850892;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{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: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:\"d352e3e42032af08075772207c03aa9e\";s:12:\"tracker.ssid\";s:32:\"d352e3e42032af08075772207c03aa9e\";s:12:\"tracker.rsid\";s:32:\"d352e3e42032af08075772207c03aa9e\";s:13:\"securiy_code0\";s:5:\"07e43\";s:13:\"session.token\";s:32:\"46006828902a044e6833a7635457ff76\";}',`time` = '1529850893',`ip` = '54.145.103.69'
WHERE `session_id` = 'd352e3e42032af08075772207c03aa9e'13 × SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`10 × 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 t2 × SELECT b.rules
FROM `jos_assets` AS `a`
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × 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 t2 × SELECT data
FROM `jos_session`1 × SELECT 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 (682)1 × SELECT 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 u1 × SELECT 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 t1 × SELECT *
FROM jos_publication_categories as C1 × SELECT DISTINCT gidNumber
FROM `jos_xgroups_members`1 × SELECT 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 t1 × SELECT *
FROM `jos_xprofiles`1 × 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_id1 × SELECT *
FROM `jos_users`1 × SELECT 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 (682)1 × SELECT COUNT(f.id)
FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_citations` AS e, `jos_tags_object` AS t1 × SELECT 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 u1 × SELECT a.id, a.name AS title, a.username as alias, NULL AS itext, b.profile_value AS ftext, a.activation AS state, a.registerDate AS created, a.id AS created_by, NULL AS modified, a.registerDate AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_members&id=', a.id) 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_users AS a
LEFT JOIN jos_user_profiles AS b
ON a.id=b.user_id
AND b.profile_key='bio', jos_tags_object AS t1 × 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_id1 × SELECT con.`id`
FROM `jos_content` AS con
LEFT JOIN `jos_categories` AS cat
ON con.catid = cat.id1 × SELECT folder AS type,element AS name,protected,params
FROM `jos_extensions`1 × SELECT *
FROM `jos_viewlevels1 × SELECT session_id
FROM `jos_session`1 × SELECT b.id
FROM `jos_usergroups` AS `a`
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × 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.template1 × SELECT *
FROM `jos_tags`1 × SELECT COUNT(f.id)
FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_users AS a
LEFT JOIN jos_user_profiles AS b
ON a.id=b.user_id
AND b.profile_key='bio', jos_tags_object AS t1 × SELECT COUNT(f.id)
FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_events AS e, jos_tags_object AS t1 × SELECT 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'
LEFT JOIN `jos_projects` xp
ON xp.id = w.scope_id
AND w.scope='project', jos_tags_object AS t1 × SELECT *
FROM `jos_resource_types`1 × SELECT COUNT(f.id)
FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_answers_questions` AS a, `jos_tags_object` AS t1 × SELECT a.rules
FROM `jos_assets` AS `a`2 × ( 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 m1 × UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1529850892;s:18:\"session.timer.last\";i:1529850892;s:17:\"session.timer.now\";i:1529850892;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{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: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:\"d352e3e42032af08075772207c03aa9e\";s:12:\"tracker.ssid\";s:32:\"d352e3e42032af08075772207c03aa9e\";s:12:\"tracker.rsid\";s:32:\"d352e3e42032af08075772207c03aa9e\";s:13:\"securiy_code0\";s:5:\"07e43\";s:13:\"session.token\";s:32:\"46006828902a044e6833a7635457ff76\";}',`time` = '1529850893',`ip` = '54.145.103.69'1 × SHOW FULL COLUMNS
FROM `jos_publications1 × SHOW FULL COLUMNS
FROM `jos_publication_categories1 × DELETE
FROM`jos_session`1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
VALUES ('d352e3e42032af08075772207c03aa9e','0','1529850892','54.145.103.69'onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:46onAfterInitialise — 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 — 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 — plgTagsAnswers::onTagView → /core/plugins/tags/answers/answers.php:58onTagView — Method — plgTagsResources::onTagView → /core/plugins/tags/resources/resources.php:72onTagView — Method — plgTagsWiki::onTagView → /core/plugins/tags/wiki/wiki.php:58onTagView — Method — plgTagsMembers::onTagView → /core/plugins/tags/members/members.php:58onTagView — Method — plgTagsEvents::onTagView → /core/plugins/tags/events/events.php:58onTagView — Method — plgTagsGroups::onTagView → /core/plugins/tags/groups/groups.php:58onTagView — Method — plgTagsBlogs::onTagView → /core/plugins/tags/blogs/blogs.php:58onTagView — Method — plgTagsForum::onTagView → /core/plugins/tags/forum/forum.php:73onTagView — 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:58onTagView — Method — plgTagsCitations::onTagView → /core/plugins/tags/citations/citations.php:58onTagView — Method — plgTagsKb::onTagView → /core/plugins/tags/kb/kb.php:58onGetMultiEntry — Method — plgHubzeroAutocompleter::onGetMultiEntry → /core/plugins/hubzero/autocompleter/autocompleter.php:164onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:87onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:49onGetModuleCaptcha — Method — plgSupportCaptcha::onGetModuleCaptcha → /core/plugins/support/captcha/captcha.php:217onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:45