Support

Support Options

Submit a Support Ticket

Tags: tool:vmd

No results found.

Debug Console

Close18 MBRequestSessionTimelineDatabase69
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /tags/toolvmd, REDIRECT_SCRIPT_URI => http://chemistryhub.org/t... Array(
REDIRECT_SCRIPT_URL => /tags/toolvmd,
REDIRECT_SCRIPT_URI => http://chemistryhub.org/tags/toolvmd,
REDIRECT_nokeepalive => ,
REDIRECT_STATUS => 200,
SCRIPT_URL => /tags/toolvmd,
SCRIPT_URI => http://chemistryhub.org/tags/toolvmd,
nokeepalive => ,
HTTP_HOST => chemistryhub.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 => Thu, 27 Jul 2017 18:49:26 GMT,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.2.15 (CentOS),
SERVER_NAME => chemistryhub.org,
SERVER_ADDR => 206.221.159.27,
SERVER_PORT => 80,
REMOTE_ADDR => 54.80.137.187,
DOCUMENT_ROOT => /var/www/chemistryhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/chemistryhub/index.php,
REMOTE_PORT => 51008,
REDIRECT_URL => /tags/toolvmd,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.0,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /tags/toolvmd,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1506093270.335,
REQUEST_TIME => 1506093270
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 7cd239429ef4244c20fa60a90abb5308
tracker.ssid 7cd239429ef4244c20fa60a90abb5308
tracker.rsid 7cd239429ef4244c20fa60a90abb5308
securiy_code0 922d0
session.token ba3db9a34400a4e3fdf2b0fa1cffa4dd
  • site 0.049 seconds (+0.049); 9.75 MB (+9.750) - afterInitialise
  • site 0.071 seconds (+0.022); 11.50 MB (+1.750) - afterRoute
  • site 0.183 seconds (+0.112); 15.75 MB (+4.250) - afterDispatch
  • site 0.192 seconds (+0.008); 16.00 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.193 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.193 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.195 seconds (+0.001); 16.25 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.195 seconds (+0.000); 16.25 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.198 seconds (+0.003); 16.25 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.198 seconds (+0.000); 16.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.224 seconds (+0.026); 16.75 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.224 seconds (+0.000); 16.75 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.226 seconds (+0.002); 16.75 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.226 seconds (+0.000); 16.75 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.240 seconds (+0.014); 18.00 MB (+1.250) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.243 seconds (+0.002); 18.00 MB (0.000) - onAfterRender
  • site 0.245 seconds (+0.002); 18.00 MB (0.000) - sessionStore
18 MB

69 Queries Logged: 0.034158706665039 seconds

  1. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '1b7b99fd52a9a95b049b3e11361fcdc4'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '1b7b99fd52a9a95b049b3e11361fcdc4'
  3. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '7cd239429ef4244c20fa60a90abb5308'
  4. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT `session_id`
      FROM `jos_session`
      WHERE `session_id` = '7cd239429ef4244c20fa60a90abb5308'
  6. INSERT INTO `jos_session` (`session_id`, `client_id`, `time`, `ip`)
      VALUES ('7cd239429ef4244c20fa60a90abb5308', 0, '1506093270', '54.80.137.187')
  7. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  9. 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
  10. SELECT id, rules
      FROM `jos_viewlevels`
  11. 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
  12. 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 m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
  13. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  14. 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
  15. SELECT *
      FROM `jos_tags`
      WHERE `jos_tags`.`tag` = 'toolvmd'
  16. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  17. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  18. SHOW FULL COLUMNS
      FROM `jos_resource_types`
  19. SELECT *
      FROM jos_resource_types
      WHERE category='27'
      ORDER BY type
  20. SHOW FULL COLUMNS
      FROM `jos_resources`
  21. ( 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 )
  22. 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 (8)
      AND r.type=9
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  23. 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 (8)
      AND r.type=3
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  24. 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 (8)
      AND r.type=1
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  25. 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 (8)
      AND r.type=31
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  26. 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 (8)
      AND r.type=39
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  27. 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 (8)
      AND r.type=7
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  28. 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 (8)
      AND r.type=64
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  29. 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 (8)
      AND r.type=2
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  30. 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', 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 (8)
      GROUP BY page_id
      HAVING uniques=1 ) AS f
  31. SELECT 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 (8)
      GROUP BY a.uidNumber
      HAVING uniques=1) AS f
  32. SELECT 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 (8)
      GROUP BY e.id
      HAVING uniques=1) AS f
  33. SELECT a.rules
      FROM jos_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id, a.rules, a.lft
  34. 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 = 'com_groups')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
  35. 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
  36. 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 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 (8)
      GROUP BY a.gidNumber
      HAVING uniques=1) AS f
  37. 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 (8)
      AND a.state!=2
      GROUP BY a.id
      HAVING uniques=1) AS f
  38. SELECT DISTINCT gidNumber
      FROM `jos_xgroups_members`
      WHERE uidNumber=0
  39. 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 = 'com_forum')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
  40. 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 (8)
      WHERE e.state=1
      AND e.parent=0
      AND e.scope_id IN (0)
      GROUP BY e.id
      HAVING uniques=1) AS f
  41. 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 u
      WHERE e.created_by=u.id
      AND t.objectid=e.id
      AND t.tbl='blog'
      AND t.tagid IN (8)
      AND e.state=1
      AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2017-09-22 15:14:30')
      AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2017-09-22 15:14:30')
      GROUP BY e.id
      HAVING uniques=1) AS f
  42. SELECT 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 (8)
      AND e.published=1
      AND e.id!=''
      GROUP BY e.id
      HAVING uniques=1) AS f
  43. 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 (8)
      WHERE e.state=1
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  44. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  45. SELECT *
      FROM jos_publication_categories as C
      WHERE C.state=1
      ORDER BY C.name ASC
  46. SHOW FULL COLUMNS
      FROM `jos_publications`
  47. ( 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 )
  48. 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 (8)
      AND r.category=1
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  49. 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 (8)
      AND r.category=7
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  50. 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 t
      WHERE i.state=1
      AND c.state=1
      AND t.objectid=p.item_id
      AND t.tbl='bulletinboard'
      AND t.tagid IN (8)
      AND i.access=0
      AND c.access=0
      GROUP BY p.id
      HAVING uniques=1) AS f
  51. (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 (8)
      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 (8)
      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 (8)
      GROUP BY a.uidNumber
      HAVING uniques=1) UNION (SELECT e.id, e.title, NULL AS 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_events&task=details&id=', e.id) AS href, 'events' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, NULL AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
      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 (8)
      GROUP BY e.id
      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 (8)
      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 (8)
      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 (8)
      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 (8)
      AND e.state=1
      AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2017-09-22 15:14:30')
      AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2017-09-22 15:14:30')
      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 (8)
      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 (8)
      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 (8)
      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 (8)
      AND i.access=0
      AND c.access=0
      GROUP BY p.id
      HAVING uniques=1)
      ORDER BY publish_up DESC, title
      LIMIT 0,20
  52. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  53. 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-22 15:14:30')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-22 15:14:30')
      AND m.access IN (1,1,4)
      AND m.client_id = 0
      AND (mm.menuid = 89 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  54. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  55. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  56. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  57. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  58. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  59. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  60. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  61. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_store'
  62. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  63. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  64. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  65. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  66. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  67. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  68. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  69. UPDATE `jos_session`
      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1506093270;s:18:\"session.timer.last\";i:1506093270;s:17:\"session.timer.now\";i:1506093270;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:\"7cd239429ef4244c20fa60a90abb5308\";s:12:\"tracker.ssid\";s:32:\"7cd239429ef4244c20fa60a90abb5308\";s:12:\"tracker.rsid\";s:32:\"7cd239429ef4244c20fa60a90abb5308\";s:13:\"securiy_code0\";s:5:\"922d0\";s:13:\"session.token\";s:32:\"ba3db9a34400a4e3fdf2b0fa1cffa4dd\";}' , `time` = '1506093270' , `ip` = '54.80.137.187'
      WHERE `session_id` = '7cd239429ef4244c20fa60a90abb5308'