User Two

The profile picture for User Two

Projects

Projects I own (0)

No projects found.
Other projects I have access to (0)

No projects found.

Debug Console

Close18 MBRequestSessionTimelineDatabase71Events52
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( cookie => 43a25f71035b89b5, d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 24445... Array(
cookie => 43a25f71035b89b5,
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B5F F 65252 C 4 65557 1 3 95D5C 254 8 05E5655 0 25357 45F5C55 5 F1B 3165952 2164044 C 016 A17 25056 31A 0 75353 6 4 4515B A55 7 1 05C 45357 0 C5452 7545752 55E 7 1 C E44 B4358 6 A16164A515412 24A 256515C1A52 5545450 0 1505A51 1 E 05F545152 3 8 C 35C5A 0535A585E 1 653 E16 94A,
81f30cf708470b974874c8a96a6bcdb2 => f7c14404b2e789da0188feb0ccafde56,
8512ae7d57b1396273f76fe6ed341a23 => es
)
$_SERVER
Array( REDIRECT_HTTPS => on, REDIRECT_SCRIPT_URL => /en/members/1080/projects, REDIRECT_SCR... Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /en/members/1080/projects,
REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/members/1080/projects,
REDIRECT_STATUS => 200,
HTTPS => on,
SCRIPT_URL => /en/members/1080/projects,
SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/members/1080/projects,
HTTP_HOST => hsscommons.rs-dev.uvic.ca,
HTTP_USER_AGENT => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com),
HTTP_ACCEPT => */*,
HTTP_ACCEPT_ENCODING => gzip, br, zstd, deflate,
HTTP_COOKIE => cookie=43a25f71035b89b5; d482552ea4a74f85af0bb3d73890dabc=%205%20E%2045E43105E%20E%202444543%207406F5D%2011B%2037E%20B4A%203%2005F41134B514059%204%20951135F765817%203%20B5C1243%20B5612%20F16%203%20B%202%20A1B5F%20F%2065252%20C%204%2065557%201%203%2095D5C%20254%208%2005E5655%200%2025357%2045F5C55%205%20F1B%203165952%202164044%20C%20016%20A17%2025056%2031A%200%2075353%206%204%204515B%20A55%207%201%2005C%2045357%200%20C5452%207545752%2055E%207%201%20C%20E44%20B4358%206%20A16164A515412%2024A%20256515C1A52%205545450%200%201505A51%201%20E%2005F545152%203%208%20C%2035C5A%200535A585E%201%20653%20E16%2094A; 81f30cf708470b974874c8a96a6bcdb2=f7c14404b2e789da0188feb0ccafde56; 8512ae7d57b1396273f76fe6ed341a23=es,
HTTP_X_FORWARDED_FOR => 3.145.124.186,
HTTP_X_FORWARDED_HOST => hsscommons.rs-dev.uvic.ca,
HTTP_X_FORWARDED_PORT => 443,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_SERVER => traefik-b8d8564f8-2whv9,
HTTP_X_REAL_IP => 3.145.124.186,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.62 (Debian),
SERVER_NAME => hsscommons.rs-dev.uvic.ca,
SERVER_ADDR => 10.233.98.122,
SERVER_PORT => 80,
REMOTE_ADDR => 10.233.94.22,
DOCUMENT_ROOT => /var/www/html,
REQUEST_SCHEME => http,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/html,
SERVER_ADMIN => webmaster@localhost,
SCRIPT_FILENAME => /var/www/html/index.php,
REMOTE_PORT => 47840,
REDIRECT_URL => /en/members/1080/projects,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /en/members/1080/projects,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745186524.3359,
REQUEST_TIME => 1745186524
)
session.client.forwarded ⇒ 3.145.124.186
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
always ⇒
0 ⇒ registerDate
1 ⇒ registerIP
2 ⇒ access
renew ⇒
tracker.sid ⇒ f7c14404b2e789da0188feb0ccafde56
tracker.ssid ⇒ f7c14404b2e789da0188feb0ccafde56
tracker.rsid ⇒ f7c14404b2e789da0188feb0ccafde56
  • site 0.102 seconds (+0.102); 12.00 MB (+12.000) - afterInitialise
  • site 0.124 seconds (+0.021); 12.00 MB (0.000) - afterRoute
  • site 0.436 seconds (+0.313); 18.00 MB (+6.000) - afterDispatch
  • site 0.444 seconds (+0.008); 18.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.451 seconds (+0.007); 18.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.452 seconds (+0.001); 18.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.452 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.452 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.453 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.453 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_wrapper (Wrapper)
  • site 0.453 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_wrapper (Wrapper)
  • site 0.453 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.453 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.453 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.454 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.454 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.465 seconds (+0.011); 18.00 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.465 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.466 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.467 seconds (+0.001); 18.00 MB (0.000) - onAfterRender
  • site 0.474 seconds (+0.007); 18.00 MB (0.000) - sessionStore
18 MB

71 Queries Logged: 0.31089997291565 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'f7c14404b2e789da0188feb0ccafde56'
  2. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  3. SELECT b.id, b.title
      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'
  4. SELECT *
      FROM `jos_viewlevels`
  5. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= ''
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  6. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  7. SELECT *
      FROM `jos_languages`
      WHERE `published` = '1'
      ORDER BY `ordering` ASC
  8. SELECT language,id
      FROM `jos_menu`
      WHERE `home` = '1'
      AND `published` = '1'
      AND `client_id` = ''
  9. 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` > ''
      AND `m`.`client_id` = ''
      ORDER BY `m`.`lft` ASC
  10. 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` = ''
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  11. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  12. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1080'
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jobs'
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  16. SHOW FULL COLUMNS
      FROM `jos_publication_logs`
  17. SELECT V.id as publication_version_id, V.publication_id, V.title, V.version_label, V.version_number, V.doi, V.published_up, P.alias as project_alias, P.title as project_title, t.url_alias as cat_url, t.name as cat_name, t.alias as cat_alias, (SELECT VV.published_up
      FROM jos_publication_versions as VV
      WHERE VV.publication_id=V.publication_id
      and VV.published_up IS NOT NULL
      ORDER BY VV.published_up ASC
      limit 1) AS first_published , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='4') AS thismonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='4') AS thismonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='4') AS thismonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='3') AS lastmonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='3') AS lastmonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='3') AS lastmonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='2') AS twomonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='2') AS twomonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='2') AS twomonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='1') AS threemonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='1') AS threemonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='1') AS threemonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id) AS total_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id) AS total_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id) AS total_support
      FROM jos_publications as C, jos_projects as P, jos_publication_categories AS t, jos_publication_versions as V JOIN jos_publication_authors as A
      ON A.publication_version_id = V.id
      AND A.status=1
      AND A.user_id='1080'
      WHERE (A.role!='submitter' OR (A.role IS NULL))
      AND P.id=C.project_id
      AND C.id=V.publication_id
      AND C.category = t.id
      AND V.main=1
      AND V.state=1
      AND V.published_up < '2025-04-20 22:02:04'
      GROUP BY V.publication_id
      ORDER BY V.title ASC
  18. SHOW FULL COLUMNS
      FROM `jos_jobs_employers`
  19. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  20. 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_members.component'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  21. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = ''
  22. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  23. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = ''
      AND s.status=1
      AND s.expires > '2025-04-20 22:02:04'
  24. SELECT COUNT(jos_xmessage_recipient.id) AS count
      FROM `jos_xmessage_recipient`
      INNER JOIN jos_xmessage
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      LEFT JOIN jos_xmessage_seen
      ON jos_xmessage_seen.mid=jos_xmessage.id
      AND jos_xmessage_seen.uid=1080
      WHERE `jos_xmessage_recipient`.`uid` = '1080'
      AND `jos_xmessage_recipient`.`state` = ''
  25. SELECT COUNT(jos_xmessage.id) AS count
      FROM `jos_xmessage`
      INNER JOIN jos_xmessage_recipient
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      WHERE `jos_xmessage_recipient`.`uid` = '1080'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=1080)
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  27. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1080'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2025-04-20 22:02:04' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2025-04-20 22:02:04' )
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  29. SHOW FULL COLUMNS
      FROM `jos_collections`
  30. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.object_id='1080'
      AND b.object_type='member'
  31. SHOW FULL COLUMNS
      FROM `jos_collections`
  32. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.access=''
      AND b.object_id='1080'
      AND b.object_type='member'
  33. SHOW FULL COLUMNS
      FROM `jos_publications`
  34. SHOW FULL COLUMNS
      FROM `jos_publications`
  35. SELECT C.id
      FROM jos_publication_versions V
      LEFT JOIN jos_publications C
      ON V.publication_id = C.id
      LEFT JOIN jos_projects PP
      ON PP.id = C.project_id
      LEFT JOIN jos_publication_master_types MT
      ON MT.id = C.master_type
      LEFT JOIN jos_publication_categories AS t
      ON t.id = C.category
      LEFT JOIN jos_publication_authors A
      ON A.publication_version_id = V.id
      WHERE 1
      AND V.version_number = (SELECT MAX(version_number)
      FROM jos_publication_versions
      WHERE publication_id=C.id
      AND state=1 )
      AND (V.state=1)
      AND A.user_id=1080
      AND A.status=1
      AND (A.role IS NULL OR A.role!='submitter')
      AND (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2025-04-20 22:02:04')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-20 22:02:04')
      AND V.state != 2
      AND (V.access != 2)
      GROUP BY C.id, V.id
  36. SHOW FULL COLUMNS
      FROM `jos_publication_logs`
  37. SELECT V.id as publication_version_id, V.publication_id, V.title, V.version_label, V.version_number, V.doi, V.published_up, P.alias as project_alias, P.title as project_title, t.url_alias as cat_url, t.name as cat_name, t.alias as cat_alias, (SELECT VV.published_up
      FROM jos_publication_versions as VV
      WHERE VV.publication_id=V.publication_id
      and VV.published_up IS NOT NULL
      ORDER BY VV.published_up ASC
      limit 1) AS first_published , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='4') AS thismonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='4') AS thismonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='4') AS thismonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='3') AS lastmonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='3') AS lastmonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='3') AS lastmonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='2') AS twomonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='2') AS twomonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='2') AS twomonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='1') AS threemonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='1') AS threemonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='1') AS threemonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id) AS total_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id) AS total_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id) AS total_support
      FROM jos_publications as C, jos_projects as P, jos_publication_categories AS t, jos_publication_versions as V JOIN jos_publication_authors as A
      ON A.publication_version_id = V.id
      AND A.status=1
      AND A.user_id='1080'
      WHERE (A.role!='submitter' OR (A.role IS NULL))
      AND P.id=C.project_id
      AND C.id=V.publication_id
      AND C.category = t.id
      AND V.main=1
      AND V.state=1
      AND V.published_up < '2025-04-20 22:02:04'
      GROUP BY V.publication_id
      ORDER BY V.title ASC
  38. SHOW FULL COLUMNS
      FROM `jos_publication_logs`
  39. SELECT V.id as publication_version_id, V.publication_id, V.title, V.version_label, V.version_number, V.doi, V.published_up, P.alias as project_alias, P.title as project_title, t.url_alias as cat_url, t.name as cat_name, t.alias as cat_alias, (SELECT VV.published_up
      FROM jos_publication_versions as VV
      WHERE VV.publication_id=V.publication_id
      and VV.published_up IS NOT NULL
      ORDER BY VV.published_up ASC
      limit 1) AS first_published , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='4') AS thismonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='4') AS thismonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='4') AS thismonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='3') AS lastmonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='3') AS lastmonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='3') AS lastmonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='2') AS twomonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='2') AS twomonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='2') AS twomonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='1') AS threemonth_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='1') AS threemonth_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id
      AND year='25'
      AND month='1') AS threemonth_support , (SELECT COALESCE(SUM(L.page_views) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id) AS total_views , (SELECT COALESCE(SUM(L.primary_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id) AS total_primary , (SELECT COALESCE(SUM(L.support_accesses) , 0)
      FROM jos_publication_logs as L
      WHERE L.publication_id=V.publication_id) AS total_support
      FROM jos_publications as C, jos_projects as P, jos_publication_categories AS t, jos_publication_versions as V JOIN jos_publication_authors as A
      ON A.publication_version_id = V.id
      AND A.status=1
      AND A.user_id='1080'
      WHERE (A.role!='submitter' OR (A.role IS NULL))
      AND P.id=C.project_id
      AND C.id=V.publication_id
      AND C.category = t.id
      AND V.main=1
      AND V.state=1
      AND V.published_up < '2025-04-20 22:02:04'
      GROUP BY V.publication_id
      ORDER BY V.title ASC
  40. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'usertwo@mailinator.com'
  41. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1080 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_members` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1080 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_managers` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1080 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_invitees` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1080 )
  42. SHOW FULL COLUMNS
      FROM `jos_projects`
  43. 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_projects'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  44. SELECT count(DISTINCT p.id)
      FROM jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid='1080'
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.owned_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE (o.userid='1080'
      AND o.status!=2
      AND p.state NOT IN (2, 3)
      AND ((p.setup_stage >= '2') OR (o.role = 1
      AND p.owned_by_user='1080')))
      AND p.provisioned = 0
      AND p.private = 0
  45. SELECT DISTINCT p.id
      FROM jos_projects AS p, jos_project_owners as o
      WHERE p.id=o.projectid
      AND (p.state=1 OR (o.role = 1
      AND p.owned_by_user='1080'
      AND p.state !=2))
      AND p.provisioned=0
      AND o.userid=1080
  46. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  47. SELECT p.alias, p.title, o.*
      FROM jos_project_owners AS o
      INNER JOIN `jos_projects` AS p
      ON p.id=o.projectid
      WHERE o.userid=0
      AND o.status=0
      AND o.invited_email='usertwo@mailinator.com'
  48. SELECT p.*, IFNULL(o.role, 0) as role, o.id as owner, o.added as since, o.status as confirmed , x.name as authorname, g.cn as groupcn, g.description as groupname , (SELECT t.type
      FROM `jos_project_types` as t
      WHERE t.id=p.type) as projecttype , ( SELECT COUNT(*)
      FROM `jos_activity_recipients` AS pa
      WHERE pa.scope='project'
      AND pa.scope_id=p.id
      AND pa.created >= o.lastvisit
      AND o.lastvisit IS NOT NULL
      AND o.id IS NOT NULL
      AND pa.state != 2 ) as newactivity
      FROM jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid='1080'
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.owned_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE (o.userid='1080'
      AND o.status!=2
      AND p.state NOT IN (2, 3)
      AND ((p.setup_stage >= '2') OR (o.role = 1
      AND p.owned_by_user='1080')))
      AND (p.owned_by_user ='1080'
      AND p.owned_by_group = 0)
      AND p.provisioned = 0
      AND p.private = 0
      ORDER BY p.title ASC
  49. SELECT p.*, IFNULL(o.role, 0) as role, o.id as owner, o.added as since, o.status as confirmed , x.name as authorname, g.cn as groupcn, g.description as groupname , (SELECT t.type
      FROM `jos_project_types` as t
      WHERE t.id=p.type) as projecttype , ( SELECT COUNT(*)
      FROM `jos_activity_recipients` AS pa
      WHERE pa.scope='project'
      AND pa.scope_id=p.id
      AND pa.created >= o.lastvisit
      AND o.lastvisit IS NOT NULL
      AND o.id IS NOT NULL
      AND pa.state != 2 ) as newactivity
      FROM jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid='1080'
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.owned_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE (o.userid='1080'
      AND o.status!=2
      AND p.state NOT IN (2, 3)
      AND ((p.setup_stage >= '2') OR (o.role = 1
      AND p.owned_by_user='1080')))
      AND (p.owned_by_user != '1080' OR p.owned_by_group != 0)
      AND p.provisioned = 0
      AND p.private = 0
      ORDER BY p.title ASC
  50. SELECT p.alias, p.title, o.*
      FROM jos_project_owners AS o
      INNER JOIN `jos_projects` AS p
      ON p.id=o.projectid
      WHERE o.userid=0
      AND o.status=0
      AND o.invited_email='usertwo@mailinator.com'
  51. SHOW TABLES
  52. SHOW FULL COLUMNS
      FROM `jos_project_todo`
  53. SHOW FULL COLUMNS
      FROM `jos_projects`
  54. SELECT DISTINCT p.id
      FROM jos_projects AS p, jos_project_owners as o
      WHERE p.id=o.projectid
      AND (p.state=1 OR (o.role = 1
      AND p.owned_by_user='1080'
      AND p.state !=2))
      AND p.provisioned=0
      AND o.userid=1080
  55. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '1080'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  56. SELECT *
      FROM `jos_auth_link`
      WHERE `jos_auth_link`.`user_id` = '1080'
  57. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1080';
  58. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  59. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  60. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_register'
  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` IS NULL OR `m`.`publish_up` <= '2025-04-20 22:02:04' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2025-04-20 22:02:04' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = ''
      AND (`mm`.`menuid` = '83' OR `mm`.`menuid` <= '' )
      AND `m`.`language` IN ('en-GB','*')
      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_menus'
  63. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  64. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  65. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  66. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  67. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  68. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  69. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  70. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  71. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:52;s:19:\"session.timer.start\";i:1745186509;s:18:\"session.timer.last\";i:1745186524;s:17:\"session.timer.now\";i:1745186524;s:24:\"session.client.forwarded\";s:13:\"3.145.124.186\";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\";O:17:\"Hubzero\\User\\User\":1:{s:5:\"guest\";b:1;}s:11:\"tracker.sid\";s:32:\"f7c14404b2e789da0188feb0ccafde56\";s:12:\"tracker.ssid\";s:32:\"f7c14404b2e789da0188feb0ccafde56\";s:12:\"tracker.rsid\";s:32:\"f7c14404b2e789da0188feb0ccafde56\";}',`time` = '1745186524',`ip` = '10.233.94.22'
      WHERE `session_id` = 'f7c14404b2e789da0188feb0ccafde56'
  • onAfterInitialise — Method — plgSystemLanguageFilter::onAfterInitialise → /app/plugins/system/languagefilter/languagefilter.php:186
  • 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 → /app/plugins/system/password/password.php:21
  • onMembersAreas — Method — plgMembersDashboard::onMembersAreas → /app/plugins/members/dashboard/dashboard.php:62
  • onMembersAreas — Method — plgMembersProfile::onMembersAreas → /app/plugins/members/profile/profile.php:30
  • onMembersAreas — Method — plgMembersAccount::onMembersAreas → /app/plugins/members/account/account.php:34
  • onMembersAreas — Method — plgMembersResume::onMembersAreas → /app/plugins/members/resume/resume.php:85
  • onMembersAreas — Method — plgMembersMessages::onMembersAreas → /app/plugins/members/messages/messages.php:30
  • onMembersAreas — Method — plgMembersBlog::onMembersAreas → /app/plugins/members/blog/blog.php:30
  • onMembersAreas — Method — plgMembersCollections::onMembersAreas → /app/plugins/members/collections/collections.php:30
  • onMembersAreas — Method — plgMembersContributions::onMembersAreas → /app/plugins/members/contributions/contributions.php:30
  • onMembersAreas — Method — plgMembersRepository::onMembersAreas → /app/plugins/members/repository/repository.php:115
  • onMembersAreas — Method — plgMembersImpact::onMembersAreas → /app/plugins/members/impact/impact.php:105
  • onMembersAreas — Method — plgMembersGroups::onMembersAreas → /app/plugins/members/groups/groups.php:30
  • onMembersAreas — Method — plgMembersProjects::onMembersAreas → /app/plugins/members/projects/projects.php:46
  • onMembersAreas — Method — plgMembersUsage::onMembersAreas → /app/plugins/members/usage/usage.php:30
  • onMembersAreas — Method — plgMembersTodo::onMembersAreas → /app/plugins/members/todo/todo.php:30
  • onMembersAreas — Method — plgMembersActivity::onMembersAreas → /app/plugins/members/activity/activity.php:30
  • onMembersContributionsAreas — Method — plgMembersRepository::onMembersContributionsAreas → /app/plugins/members/repository/repository.php:341
  • onMembersContributionsAreas — Method — plgMembersImpact::onMembersContributionsAreas → /app/plugins/members/impact/impact.php:221
  • onMembersContributions — Method — plgMembersRepository::onMembersContributions → /app/plugins/members/repository/repository.php:387
  • onMembersContributions — Method — plgMembersImpact::onMembersContributions → /app/plugins/members/impact/impact.php:266
  • onMembers — Method — plgMembersDashboard::onMembers → /app/plugins/members/dashboard/dashboard.php:88
  • onMembers — Method — plgMembersProfile::onMembers → /app/plugins/members/profile/profile.php:50
  • onMembers — Method — plgMembersAccount::onMembers → /app/plugins/members/account/account.php:60
  • onMembers — Method — plgMembersResume::onMembers → /app/plugins/members/resume/resume.php:190
  • onMembers — Method — plgMembersMessages::onMembers → /app/plugins/members/messages/messages.php:56
  • onMembers — Method — plgMembersBlog::onMembers → /app/plugins/members/blog/blog.php:50
  • onMembers — Method — plgMembersCollections::onMembers → /app/plugins/members/collections/collections.php:50
  • onMembers — Method — plgMembersContributions::onMembers → /app/plugins/members/contributions/contributions.php:50
  • onMembers — Method — plgMembersRepository::onMembers → /app/plugins/members/repository/repository.php:182
  • onMembers — Method — plgMembersImpact::onMembers → /app/plugins/members/impact/impact.php:138
  • onMembers — Method — plgMembersGroups::onMembers → /app/plugins/members/groups/groups.php:56
  • onMembers — Method — plgMembersProjects::onMembers → /app/plugins/members/projects/projects.php:71
  • onMembers — Method — plgMembersUsage::onMembers → /app/plugins/members/usage/usage.php:50
  • onMembers — Method — plgMembersTodo::onMembers → /app/plugins/members/todo/todo.php:57
  • onMembers — Method — plgMembersActivity::onMembers → /app/plugins/members/activity/activity.php:54
  • onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:22
  • onAfterDispatch — Method — plgSystemLanguageFilter::onAfterDispatch → /app/plugins/system/languagefilter/languagefilter.php:554
  • 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