Tags: hormone

All Categories (1-3 of 3)

  1. Active ghrelin assay - Feb 2017

    15 Feb 2017 | Hormone assays | Contributor(s): Bartek Rajwa, Bob Phillips, Jennie Sturgis

    The calibration curve and the results od the ghrelin assays performed on fasting and fed rats. The information about the computation of the calibration curve is avalable at...

    https://sparc.purdue.edu/resources/70

  2. Acyl- and des-acyl ghrelin

    Closed | Responses: 1

    What is the difference between acyl- and des-acyl ghrelin?

    https://sparc.purdue.edu/answers/question/2

  3. RayBio Human/Mouse/Rat CCK Enzyme Immunoassay Kit

    16 Jan 2017 | Experimental protocols | Contributor(s): RayBio

    Cholecystokinin (CCK) is a peptide hormone of the gastrointestinal system responsible for stimulating the digestion of fat and protein. It is synthesized by I-cells in the mucosal epithelium of...

    https://sparc.purdue.edu/resources/8

Debug Console

Close6 MBRequestSessionTimelineDatabase67Events28
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /tags/hormone, REDIRECT_SCRIPT_URI => https://sparc.purdue.edu/... Array(
REDIRECT_SCRIPT_URL => /tags/hormone,
REDIRECT_SCRIPT_URI => https://sparc.purdue.edu/tags/hormone,
REDIRECT_nokeepalive => ,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => sparc.purdue.edu,
REDIRECT_STATUS => 200,
SCRIPT_URL => /tags/hormone,
SCRIPT_URI => https://sparc.purdue.edu/tags/hormone,
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:30:21 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 => 52874,
REDIRECT_URL => /tags/hormone,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.0,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /tags/hormone,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1506416646.23,
REQUEST_TIME => 1506416646
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 0bda1a1ce030a896fc1bec4f3a6fe465
tracker.ssid 0bda1a1ce030a896fc1bec4f3a6fe465
tracker.rsid 0bda1a1ce030a896fc1bec4f3a6fe465
  • site 0.130 seconds (+0.130); 3.50 MB (+3.500) - afterInitialise
  • site 0.239 seconds (+0.109); 4.25 MB (+0.750) - afterRoute
  • site 0.928 seconds (+0.689); 6.25 MB (+2.000) - afterDispatch
  • site 0.993 seconds (+0.065); 6.25 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 1.011 seconds (+0.019); 6.25 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 1.012 seconds (+0.001); 6.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 1.139 seconds (+0.127); 6.50 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 1.140 seconds (+0.001); 6.50 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 1.145 seconds (+0.004); 6.50 MB (0.000) - afterRenderModule mod_search (Search)
  • site 1.149 seconds (+0.005); 6.50 MB (0.000) - onAfterRender
  • site 1.169 seconds (+0.020); 6.50 MB (0.000) - sessionStore
6 MB

67 Queries Logged: 0.022098064422607 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '70dbb41bed9b1f7a6690c3e976c83d85'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '70dbb41bed9b1f7a6690c3e976c83d85'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '0bda1a1ce030a896fc1bec4f3a6fe465'
  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` = '0bda1a1ce030a896fc1bec4f3a6fe465'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('0bda1a1ce030a896fc1bec4f3a6fe465','0','1506416646','54.156.93.60')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  13. 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` DESC
  14. SELECT *
      FROM `jos_tags`
      WHERE `jos_tags`.`tag` = 'hormone'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  17. SHOW FULL COLUMNS
      FROM `jos_resource_types`
  18. SELECT *
      FROM jos_resource_types
      WHERE category='27'
      ORDER BY type
  19. SHOW FULL COLUMNS
      FROM `jos_resources`
  20. ( 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 )
  21. 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 (15)
      AND r.type=77
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  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 (15)
      AND r.type=72
      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 (15)
      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 (15)
      AND r.type=75
      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 (15)
      AND r.type=9
      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 (15)
      AND r.type=74
      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 (15)
      AND r.type=76
      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 (15)
      AND r.type=1
      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 (15)
      AND r.type=78
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  30. 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 (15)
      AND r.type=71
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  31. 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 (15)
      AND r.type=39
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  32. 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 (15)
      AND r.type=7
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  33. 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 (15)
      AND r.type=2
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  34. 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 (15)
      GROUP BY page_id
      HAVING uniques=1 ) AS f
  35. 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 (15)
      GROUP BY a.uidNumber
      HAVING uniques=1) AS f
  36. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  37. 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` ASC
  38. 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 (15)
      GROUP BY a.gidNumber
      HAVING uniques=1) AS f
  39. 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 (15)
      AND a.state!=2
      GROUP BY a.id
      HAVING uniques=1) AS f
  40. SELECT DISTINCT gidNumber
      FROM `jos_xgroups_members`
      WHERE uidNumber=0
  41. 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` ASC
  42. 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 (15)
      WHERE e.state=1
      AND e.parent=0
      AND e.scope_id IN (0)
      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_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 (15)
      AND e.state=1
      AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2017-09-26 09:04:06')
      AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2017-09-26 09:04:06')
      GROUP BY e.id
      HAVING uniques=1) AS f
  44. 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 (15)
      AND e.published=1
      AND e.id!=''
      GROUP BY e.id
      HAVING uniques=1) AS f
  45. 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 (15)
      WHERE e.state=1
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  46. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  47. SELECT *
      FROM jos_publication_categories as C
      WHERE C.state=1
      ORDER BY C.name ASC
  48. SHOW FULL COLUMNS
      FROM `jos_publications`
  49. ( 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 )
  50. 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 (15)
      AND r.category=1
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  51. 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 (15)
      AND r.category=3
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  52. 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 (15)
      AND r.category=7
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  53. 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 (15)
      AND i.access=0
      AND c.access=0
      GROUP BY p.id
      HAVING uniques=1) AS f
  54. 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 u
      WHERE e.created_by=u.id
      AND e.state=1
      AND t.objectid=e.id
      AND t.tbl='courses'
      AND t.tagid IN (15)
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  55. (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 (15)
      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 (15)
      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 (15)
      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 (15)
      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 (15)
      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 (15)
      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 (15)
      AND e.state=1
      AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2017-09-26 09:04:06')
      AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2017-09-26 09:04:06')
      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 (15)
      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 (15)
      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 (15)
      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 (15)
      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 (15)
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1)
      ORDER BY publish_up DESC, title
      LIMIT 0,20
  56. SELECT 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, middleName
  57. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  58. SELECT 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=8
      ORDER BY ordering, surname, givenName, middleName
  59. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  60. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  61. 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:04:07' )
      AND (`m`.`publish_down` = '0000-00-00 00:00:00' OR `m`.`publish_down` >= '2017-09-26 09:04:07' )
      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` ASC
  62. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  63. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  64. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  65. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  66. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  67. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1506416646;s:18:\"session.timer.last\";i:1506416646;s:17:\"session.timer.now\";i:1506416646;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:\"0bda1a1ce030a896fc1bec4f3a6fe465\";s:12:\"tracker.ssid\";s:32:\"0bda1a1ce030a896fc1bec4f3a6fe465\";s:12:\"tracker.rsid\";s:32:\"0bda1a1ce030a896fc1bec4f3a6fe465\";}',`time` = '1506416647',`ip` = '54.156.93.60'
      WHERE `session_id` = '0bda1a1ce030a896fc1bec4f3a6fe465'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:45
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:44
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:46
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:46
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:138
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:46
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:46
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:46
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:46
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:46
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:46
  • onTagView Method plgTagsResources::onTagView /core/plugins/tags/resources/resources.php:73
  • onTagView Method plgTagsWiki::onTagView /core/plugins/tags/wiki/wiki.php:58
  • onTagView Method plgTagsMembers::onTagView /core/plugins/tags/members/members.php:58
  • onTagView Method plgTagsGroups::onTagView /core/plugins/tags/groups/groups.php:58
  • onTagView Method plgTagsAnswers::onTagView /core/plugins/tags/answers/answers.php:58
  • onTagView Method plgTagsForum::onTagView /core/plugins/tags/forum/forum.php:73
  • onTagView Method plgTagsBlogs::onTagView /core/plugins/tags/blogs/blogs.php:58
  • onTagView Method plgTagsCitations::onTagView /core/plugins/tags/citations/citations.php:58
  • onTagView Method plgTagsKb::onTagView /core/plugins/tags/kb/kb.php:58
  • onTagView Method plgTagsPublications::onTagView /core/plugins/tags/publications/publications.php:73
  • onTagView Method plgTagsCollections::onTagView /core/plugins/tags/collections/collections.php:58
  • onTagView Method plgTagsCourses::onTagView /core/plugins/tags/courses/courses.php:58
  • onGetMultiEntry Method plgHubzeroAutocompleter::onGetMultiEntry /core/plugins/hubzero/autocompleter/autocompleter.php:164
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:47
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:87
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:49
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:45