Tags: australia

datasets (1-1 of 1)

  1. Australian State & Territory MRIO Table Timeseries

    17 Jun 2021 | | Contributor(s):: Jacob Fry, Thomas Wiedmann

    This resource contains subnational multi-regional input-output tables (MRIOs) for Australia, built using the IELab infrastructure. The model resolution is 8 sub-regions (Australian states and territories) at 25 sectors. The tables cover the timeseries 2009-2018. For each year, the model contains...

Debug Console

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

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( USER => apache, HOME => /usr/share/httpd, FCGI_ROLE => RESPONDER, REDIRECT_HTTP_AU... Array(
USER => apache,
HOME => /usr/share/httpd,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_UNIQUE_ID => ZgWacKnriirIyQalR94EngAAAAs,
REDIRECT_SCRIPT_URL => /tags/australia/datasets,
REDIRECT_SCRIPT_URI => https://ielab.info/tags/australia/datasets,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
UNIQUE_ID => ZgWacKnriirIyQalR94EngAAAAs,
SCRIPT_URL => /tags/australia/datasets,
SCRIPT_URI => https://ielab.info/tags/australia/datasets,
HTTPS => on,
HTTP_X_FORWARDED_FOR => 18.209.209.246,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_PORT => 443,
HTTP_HOST => ielab.info,
HTTP_X_AMZN_TRACE_ID => Root=1-66059a70-3e9738a64c836a145c964cc1,
HTTP_ACCEPT => */*,
HTTP_USER_AGENT => claudebot,
HTTP_REFERER => http://ielab.info/tags/australia/datasets?sort=date,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_python/3.5.0- Python/2.7.5,
SERVER_NAME => ielab.info,
SERVER_ADDR => 10.84.154.253,
SERVER_PORT => 443,
REMOTE_ADDR => 10.84.154.252,
DOCUMENT_ROOT => /var/www/ielab,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/ielab,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/ielab/index.php,
REMOTE_PORT => 61004,
REDIRECT_QUERY_STRING => sort=date,
REDIRECT_URL => /tags/australia/datasets,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => sort=date,
REQUEST_URI => /tags/australia/datasets?sort=date,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1711643248.6301,
REQUEST_TIME => 1711643248
)
session.client.forwarded 18.209.209.246
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid ddc0e755357eadac9a688924851b634f
tracker.ssid ddc0e755357eadac9a688924851b634f
tracker.rsid ddc0e755357eadac9a688924851b634f
  • site 0.061 seconds (+0.061); 9.50 MB (+9.500) - afterInitialise
  • site 0.092 seconds (+0.031); 11.25 MB (+1.750) - afterRoute
  • site 0.210 seconds (+0.118); 19.50 MB (+8.250) - afterDispatch
  • site 0.219 seconds (+0.010); 19.75 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.221 seconds (+0.001); 19.75 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.221 seconds (+0.000); 19.75 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.222 seconds (+0.001); 19.75 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.223 seconds (+0.000); 19.75 MB (0.000) - beforeRenderModule mod_menu (Community)
  • site 0.224 seconds (+0.001); 20.00 MB (+0.250) - afterRenderModule mod_menu (Community)
  • site 0.224 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_menu (Support)
  • site 0.224 seconds (+0.000); 20.00 MB (0.000) - afterRenderModule mod_menu (Support)
  • site 0.225 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_menu (Analyse)
  • site 0.225 seconds (+0.000); 20.00 MB (0.000) - afterRenderModule mod_menu (Analyse)
  • site 0.225 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.230 seconds (+0.005); 20.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.230 seconds (+0.000); 20.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.249 seconds (+0.019); 20.50 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.249 seconds (+0.000); 20.50 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.251 seconds (+0.001); 20.50 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.251 seconds (+0.000); 20.50 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.253 seconds (+0.003); 20.50 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.255 seconds (+0.002); 20.50 MB (0.000) - onAfterRender
  • site 0.257 seconds (+0.002); 20.50 MB (0.000) - sessionStore
20 MB

70 Queries Logged: 0.028680801391602 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'df959f958ecbff022bacc3d3f90d5944'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = 'df959f958ecbff022bacc3d3f90d5944'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'ddc0e755357eadac9a688924851b634f'
  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` = 'ddc0e755357eadac9a688924851b634f'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('ddc0e755357eadac9a688924851b634f','0','1711643248','10.84.154.252')
  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` = 'australia'
  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 (11)
      AND r.type=9
      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 (11)
      AND r.type=3
      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 (11)
      AND r.type=1
      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 (11)
      AND r.type=31
      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 (11)
      AND r.type=39
      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 (11)
      AND r.type=7
      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 (11)
      AND r.type=64
      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 (11)
      AND r.type=2
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  27. 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 (11)
      AND r.type=9
      GROUP BY r.id
      HAVING uniques=1
      ORDER BY publish_up DESC
      LIMIT 0,20
  28. 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 (11)
      GROUP BY page_id
      HAVING uniques=1 ) AS f
  29. 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 (11)
      GROUP BY a.id, b.profile_value
      HAVING uniques=1) AS f
  30. 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 (11)
      GROUP BY e.id
      HAVING uniques=1) AS f
  31. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  32. 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
  33. 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 (11)
      GROUP BY a.gidNumber
      HAVING uniques=1) AS f
  34. 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 (11)
      AND a.state!=2
      GROUP BY a.id
      HAVING uniques=1) AS f
  35. SELECT DISTINCT gidNumber
      FROM `jos_xgroups_members`
      WHERE uidNumber=0
  36. 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
  37. 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 (11)
      WHERE e.state=1
      AND e.parent=0
      AND e.scope_id IN (0)
      GROUP BY e.id
      HAVING uniques=1) AS f
  38. 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 (11)
      AND e.state=1
      AND (e.publish_up IS NULL OR e.publish_up <= '2024-03-28 16:27:28')
      AND (e.publish_down IS NULL OR e.publish_down >= '2024-03-28 16:27:28')
      GROUP BY e.id
      HAVING uniques=1) AS f
  39. 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 (11)
      AND e.published=1
      AND e.id!=''
      GROUP BY e.id
      HAVING uniques=1) AS f
  40. 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 (11)
      WHERE e.state=1
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  41. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  42. SELECT *
      FROM jos_publication_categories as C
      WHERE C.state=1
      ORDER BY C.name ASC
  43. SHOW FULL COLUMNS
      FROM `jos_publications`
  44. ( 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 )
  45. 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=V.id
      AND t.tbl='publications'
      AND t.tagid IN (11)
      AND r.category=1
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  46. 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=V.id
      AND t.tbl='publications'
      AND t.tagid IN (11)
      AND r.category=7
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  47. 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=V.id
      AND t.tbl='publications'
      AND t.tagid IN (11)
      AND r.category=1
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1
      ORDER BY publish_up DESC
      LIMIT 0,20
  48. 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 (11)
      AND i.access=0
      AND c.access=0
      GROUP BY p.id
      HAVING uniques=1) AS f
  49. 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 (11)
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  50. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = NULL
  51. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tools'
  52. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '117'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  53. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '117'
      AND `jos_author_assoc`.`subtable` = 'resources'
  54. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  55. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  56. 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` <= '2024-03-28 16:27:28' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-03-28 16:27:28' )
      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
  57. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  58. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  59. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  60. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  61. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  62. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  63. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  64. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  65. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  66. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  67. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  68. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  69. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  70. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1711643248;s:18:\"session.timer.last\";i:1711643248;s:17:\"session.timer.now\";i:1711643248;s:24:\"session.client.forwarded\";s:14:\"18.209.209.246\";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:\"ddc0e755357eadac9a688924851b634f\";s:12:\"tracker.ssid\";s:32:\"ddc0e755357eadac9a688924851b634f\";s:12:\"tracker.rsid\";s:32:\"ddc0e755357eadac9a688924851b634f\";}',`time` = '1711643248',`ip` = '10.84.154.252'
      WHERE `session_id` = 'ddc0e755357eadac9a688924851b634f'
  • 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