Tags: challenge

General Resources (1-1 of 1)

  1. SCUDEM IV 2019 PROBLEMS AND SUPPLEMENTAL MATERIALS

    04 Dec 2019 | | Contributor(s):: Brian Winkel

    SCUDEM IV 2019 PROBLEMS AND SUPPLEMENTAL MATERIALSHere you will find the Problems for SCUDEM IV 2019 with Additional Issues (click on "Download (PDF)" black box above right). These problems were posted on 1 November 2019 for students to select one problem from which to build a...

Debug Console

Close9 MBRequestSessionTimelineDatabase70Events31
$_GET
Array( sort => date ) Array(
sort => date
)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /tags/challenge/generalresources, REDIRECT_SCRIPT_URI => https:... Array(
REDIRECT_SCRIPT_URL => /tags/challenge/generalresources,
REDIRECT_SCRIPT_URI => https://www.simiode.org/tags/challenge/generalresources,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => www.simiode.org,
REDIRECT_STATUS => 200,
SCRIPT_URL => /tags/challenge/generalresources,
SCRIPT_URI => https://www.simiode.org/tags/challenge/generalresources,
HTTPS => on,
SSL_TLS_SNI => www.simiode.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => www.simiode.org,
HTTP_CONNECTION => Keep-Alive,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.10 (Debian),
SERVER_NAME => www.simiode.org,
SERVER_ADDR => 74.208.170.104,
SERVER_PORT => 443,
REMOTE_ADDR => 3.235.175.15,
DOCUMENT_ROOT => /var/www/simiode,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/simiode,
SERVER_ADMIN => [no address given],
SCRIPT_FILENAME => /var/www/simiode/index.php,
REMOTE_PORT => 49940,
REDIRECT_QUERY_STRING => sort=date,
REDIRECT_URL => /tags/challenge/generalresources,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => sort=date,
REQUEST_URI => /tags/challenge/generalresources?sort=date,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1632440781.285,
REQUEST_TIME => 1632440781
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 2c70ea283ddf76429f7cd99d44ccc6c8
tracker.ssid 2c70ea283ddf76429f7cd99d44ccc6c8
tracker.rsid 2c70ea283ddf76429f7cd99d44ccc6c8
  • site 0.051 seconds (+0.051); 3.50 MB (+3.500) - afterInitialise
  • site 0.111 seconds (+0.060); 5.00 MB (+1.500) - afterRoute
  • site 0.346 seconds (+0.235); 9.00 MB (+4.000) - afterDispatch
  • site 0.366 seconds (+0.020); 9.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.369 seconds (+0.003); 9.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.369 seconds (+0.000); 9.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics for Website)
  • site 0.371 seconds (+0.002); 9.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics for Website)
  • site 0.371 seconds (+0.000); 9.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics 4 for Website)
  • site 0.372 seconds (+0.001); 9.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics 4 for Website)
  • site 0.372 seconds (+0.000); 9.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.375 seconds (+0.002); 9.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.375 seconds (+0.001); 9.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.384 seconds (+0.009); 9.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.385 seconds (+0.000); 9.00 MB (0.000) - beforeRenderModule mod_menu (SIMIODE Main Menu)
  • site 0.436 seconds (+0.052); 9.25 MB (+0.250) - afterRenderModule mod_menu (SIMIODE Main Menu)
  • site 0.437 seconds (+0.000); 9.25 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.440 seconds (+0.003); 9.25 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.446 seconds (+0.006); 9.25 MB (0.000) - onAfterRender
  • site 0.450 seconds (+0.005); 9.25 MB (0.000) - sessionStore
9 MB

70 Queries Logged: 0.054109334945679 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '2f7fd48fb742d02e1f70d3624e982646'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '2f7fd48fb742d02e1f70d3624e982646'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '2c70ea283ddf76429f7cd99d44ccc6c8'
  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` = '2c70ea283ddf76429f7cd99d44ccc6c8'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('2c70ea283ddf76429f7cd99d44ccc6c8','0','1632440781','3.235.175.15')
  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`
      ORDER BY `home` DESC
  14. SELECT *
      FROM `jos_tags`
      WHERE `jos_tags`.`tag` = 'challenge'
  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. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  18. ( 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 )
  19. 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 (2342)
      AND r.type=64
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  20. 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 (2342)
      AND r.type=71
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  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 (2342)
      AND r.type=66
      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 (2342)
      AND r.type=67
      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 (2342)
      AND r.type=70
      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 (2342)
      AND r.type=68
      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 (2342)
      AND r.type=65
      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 (2342)
      AND r.type=73
      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 (2342)
      AND r.type=69
      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 (2342)
      AND r.type=7
      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 (2342)
      AND r.type=72
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  30. 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, r.access 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 (2342)
      AND r.type=66
      GROUP BY r.id
      HAVING uniques=1
      ORDER BY publish_up DESC
      LIMIT 0,20
  31. 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 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 (2342)
      GROUP BY page_id
      HAVING uniques=1 ) AS f
  32. 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 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 (2342)
      GROUP BY a.id, b.profile_value
      HAVING uniques=1) AS f
  33. 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 (2342)
      GROUP BY e.id
      HAVING uniques=1) AS f
  34. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  35. 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
  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 (2342)
      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 (2342)
      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` ASC
  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 (2342)
      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 (2342)
      AND e.state=1
      AND (e.publish_up IS NULL OR e.publish_up <= '2021-09-23 23:46:21')
      AND (e.publish_down IS NULL OR e.publish_down >= '2021-09-23 23:46:21')
      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 (2342)
      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 (2342)
      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 (2342)
      AND r.category=1
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      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 (2342)
      AND r.category=4
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  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 (2342)
      AND r.category=7
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  51. 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 (2342)
      AND i.access=0
      AND c.access=0
      GROUP BY p.id
      HAVING uniques=1) AS f
  52. 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 (2342)
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  53. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = NULL
  54. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tools'
  55. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '6507'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  56. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '6507'
      AND `jos_author_assoc`.`subtable` = 'resources'
  57. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  58. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  59. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2021-09-23 23:46:21' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2021-09-23 23:46:21' )
      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
  60. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  61. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  62. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_whatsnew'
  63. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  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_support'
  66. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  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_groups'
  69. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  70. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1632440781;s:18:\"session.timer.last\";i:1632440781;s:17:\"session.timer.now\";i:1632440781;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\":2:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";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:\"2c70ea283ddf76429f7cd99d44ccc6c8\";s:12:\"tracker.ssid\";s:32:\"2c70ea283ddf76429f7cd99d44ccc6c8\";s:12:\"tracker.rsid\";s:32:\"2c70ea283ddf76429f7cd99d44ccc6c8\";}',`time` = '1632440781',`ip` = '3.235.175.15'
      WHERE `session_id` = '2c70ea283ddf76429f7cd99d44ccc6c8'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:20
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:21
  • onTagView Method plgTagsResources::onTagView /core/plugins/tags/resources/resources.php:47
  • onTagView Method plgTagsWiki::onTagView /core/plugins/tags/wiki/wiki.php:33
  • onTagView Method plgTagsMembers::onTagView /core/plugins/tags/members/members.php:33
  • onTagView Method plgTagsEvents::onTagView /core/plugins/tags/events/events.php:33
  • onTagView Method plgTagsGroups::onTagView /core/plugins/tags/groups/groups.php:33
  • onTagView Method plgTagsAnswers::onTagView /core/plugins/tags/answers/answers.php:33
  • onTagView Method plgTagsForum::onTagView /core/plugins/tags/forum/forum.php:48
  • onTagView Method plgTagsBlogs::onTagView /core/plugins/tags/blogs/blogs.php:33
  • onTagView Method plgTagsCitations::onTagView /core/plugins/tags/citations/citations.php:33
  • onTagView Method plgTagsKb::onTagView /core/plugins/tags/kb/kb.php:33
  • onTagView Method plgTagsPublications::onTagView /core/plugins/tags/publications/publications.php:48
  • onTagView Method plgTagsCollections::onTagView /core/plugins/tags/collections/collections.php:33
  • onTagView Method plgTagsCourses::onTagView /core/plugins/tags/courses/courses.php:33
  • onGetMultiEntry Method plgHubzeroAutocompleter::onGetMultiEntry /core/plugins/hubzero/autocompleter/autocompleter.php:139
  • onResourcesList Method plgResourcesCoins::onResourcesList /core/plugins/resources/coins/coins.php:57
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:22
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:60
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:25
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:21