- $_GET
-
Array(
)
Array(
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
8512ae7d57b1396273f76fe6ed341a23 => fr-FR,
cookie => 43a25f71035b89b5,
d482552ea4a74...
Array(
8512ae7d57b1396273f76fe6ed341a23 => fr-FR,
cookie => 43a25f71035b89b5,
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B 9 15355 75B52 1 F 7 1 1 9 7 957505A 0 551 35A B 355515A B53 55F1B 3165952 2164044 C 016 A17 25056 31A56 9 65453535256 15A55 5 15A 95157 5 05753 45D5D 750505B50 7 C5E44 B4358 6 A16164A515412 24A 256515C1A 4 B 153 5575757 0 1 1 C 0 5 1 45651 857 4 A 0 9 358 D5B56 0535E16 94A,
81f30cf708470b974874c8a96a6bcdb2 => 0966acf38be58c144c8ca3893a4c3c5f
)
- $_SERVER
-
Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /fr/members/1017/blog/2024/07/testing-ban...
Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /fr/members/1017/blog/2024/07/testing-bangla-support-on-the-hss-commons,
REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/fr/members/1017/blog/2024/07/testing-bangla-support-on-the-hss-commons,
REDIRECT_STATUS => 200,
HTTPS => on,
SCRIPT_URL => /fr/members/1017/blog/2024/07/testing-bangla-support-on-the-hss-commons,
SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/fr/members/1017/blog/2024/07/testing-bangla-support-on-the-hss-commons,
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 => 8512ae7d57b1396273f76fe6ed341a23=fr-FR; cookie=43a25f71035b89b5; d482552ea4a74f85af0bb3d73890dabc=%205%20E%2045E43105E%20E%202444543%207406F5D%2011B%2037E%20B4A%203%2005F41134B514059%204%20951135F765817%203%20B5C1243%20B5612%20F16%203%20B%202%20A1B%209%2015355%2075B52%201%20F%207%201%201%209%207%20957505A%200%20551%2035A%20B%20355515A%20B53%2055F1B%203165952%202164044%20C%20016%20A17%2025056%2031A56%209%2065453535256%2015A55%205%2015A%2095157%205%2005753%2045D5D%20750505B50%207%20C5E44%20B4358%206%20A16164A515412%2024A%20256515C1A%204%20B%20153%205575757%200%201%201%20C%200%205%201%2045651%20857%204%20A%200%209%20358%20D5B56%200535E16%2094A; 81f30cf708470b974874c8a96a6bcdb2=0966acf38be58c144c8ca3893a4c3c5f,
HTTP_X_FORWARDED_FOR => 3.144.48.13,
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.144.48.13,
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 => 48196,
REDIRECT_URL => /fr/members/1017/blog/2024/07/testing-bangla-support-on-the-hss-commons,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING =>
REQUEST_URI => /fr/members/1017/blog/2024/07/testing-bangla-support-on-the-hss-commons,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745984320.7646,
REQUEST_TIME => 1745984320
)
session.client.forwarded ⇒ 3.144.48.13
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
always ⇒
0 ⇒ registerDate
1 ⇒ registerIP
2 ⇒ access
renew ⇒
tracker.sid ⇒ 0966acf38be58c144c8ca3893a4c3c5f
tracker.ssid ⇒ 0966acf38be58c144c8ca3893a4c3c5f
tracker.rsid ⇒ 0966acf38be58c144c8ca3893a4c3c5f
session.token ⇒ b4a87eaf4a308c340c77578084f6295c
18 MB
80 Queries Logged: 0.85832142829895 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = '0966acf38be58c144c8ca3893a4c3c5f'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_members'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'SELECT *
FROM `jos_viewlevels`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` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT *
FROM `jos_languages`
WHERE `published` = '1'
ORDER BY `ordering` ASCSELECT language,id
FROM `jos_menu`
WHERE `home` = '1'
AND `published` = '1'
AND `client_id` = ''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` ASCSELECT 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` DESCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tags'SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = '1017'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_jobs'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_publications'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_projects'SHOW FULL COLUMNS
FROM `jos_publication_logs`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='3') 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='3') 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='3') 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='1017'
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-30 03:38:40'
GROUP BY V.publication_id
ORDER BY V.title ASC SHOW FULL COLUMNS
FROM `jos_jobs_employers`SELECT a.rules
FROM `jos_assets` AS `a`
WHERE `a`.`id` = '1'
GROUP BY a.id, a.rules, a.lftSELECT 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` ASCSELECT *
FROM `jos_assets`
WHERE `jos_assets`.`parent_id` = ''SELECT *
FROM `jos_assets`
WHERE `jos_assets`.`id` = '1'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-30 03:38:41' 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=1017
WHERE `jos_xmessage_recipient`.`uid` = '1017'
AND `jos_xmessage_recipient`.`state` = ''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` = '1017'
AND `jos_xmessage_recipient`.`state` != '2'
AND jos_xmessage.id NOT IN (SELECT s.mid
FROM `jos_xmessage_seen` AS s
WHERE s.uid=1017)SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_blog'SELECT *
FROM `jos_plugin_params`
WHERE `jos_plugin_params`.`object_id` = '1017'
AND `jos_plugin_params`.`folder` = 'members'
AND `jos_plugin_params`.`element` = 'blog'SELECT *
FROM `jos_blog_entries`
WHERE `jos_blog_entries`.`alias` = 'testing-bangla-support-
on-the-hss-commons'
AND `jos_blog_entries`.`scope` = 'member'
AND `jos_blog_entries`.`scope_id` = '1017'
AND `jos_blog_entries`.`state` IN ('','1')
ORDER BY `state` DESCSELECT *
FROM `jos_blog_comments`
WHERE `jos_blog_comments`.`entry_id` = '17'
AND `jos_blog_comments`.`state` IN ('1','3')SELECT jos_tags_object.label,jos_tags.*
FROM `jos_tags`
INNER JOIN jos_tags_object
ON jos_tags_object.tagid = jos_tags.id
WHERE `jos_tags_object`.`tbl` = 'blog'
AND `jos_tags_object`.`objectid` = '17'
AND `jos_tags`.`admin` NOT IN ('1')
GROUP BY jos_tags_object.label,jos_tags.idSELECT *
FROM `jos_blog_entries`
WHERE `jos_blog_entries`.`scope` = 'member'
AND `jos_blog_entries`.`scope_id` = '1017'
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-30 03:38:41'
)
AND (`jos_blog_entries`.`publish_down` IS NULL
OR `jos_blog_entries`.`publish_down` >= '2025-04-30 03:38:41'
)
ORDER BY `hits` DESC
LIMIT 5SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` IN ('1017')SELECT id,entry_id
FROM `jos_blog_comments`
WHERE `jos_blog_comments`.`state` IN ('1','3')
AND `jos_blog_comments`.`entry_id` IN ('17')SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = '1017'SELECT *
FROM `jos_blog_comments`
WHERE `jos_blog_comments`.`entry_id` = '17'
AND `jos_blog_comments`.`state` IN ('1','3')
AND `jos_blog_comments`.`parent` = ''
ORDER BY `created` ASCSELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = ''SELECT *
FROM `jos_user_profiles`
WHERE `jos_user_profiles`.`user_id` = NULLSELECT *
FROM `jos_blog_comments`
WHERE `jos_blog_comments`.`entry_id` = '17'
AND `jos_blog_comments`.`id` = ''
AND `jos_blog_comments`.`state` IN ('1','3')SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT *
FROM `jos_blog_entries`
WHERE `jos_blog_entries`.`scope` = 'member'
AND `jos_blog_entries`.`scope_id` = '1017'
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-30 03:38:41'
)
AND (`jos_blog_entries`.`publish_down` IS NULL
OR `jos_blog_entries`.`publish_down` >= '2025-04-30 03:38:41'
)SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_collections'SHOW FULL COLUMNS
FROM `jos_collections`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='1017'
AND b.object_type='member'SHOW FULL COLUMNS
FROM `jos_collections`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='1017'
AND b.object_type='member'SHOW FULL COLUMNS
FROM `jos_publications`SHOW FULL COLUMNS
FROM `jos_publications`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=1017
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-30 03:38:41')
AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-30 03:38:41')
AND V.state != 2
AND (V.access != 2)
GROUP BY C.id, V.id SHOW FULL COLUMNS
FROM `jos_publication_logs`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='3') 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='3') 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='3') 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='1017'
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-30 03:38:41'
GROUP BY V.publication_id
ORDER BY V.title ASC SHOW FULL COLUMNS
FROM `jos_publication_logs`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='3') 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='3') 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='3') 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='1017'
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-30 03:38:41'
GROUP BY V.publication_id
ORDER BY V.title ASC SELECT *
FROM `jos_xgroups_inviteemails`
WHERE `jos_xgroups_inviteemails`.`email` = 'ghjensen@uvic.ca'( 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=1017 ) 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=1017 ) 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=1017 ) 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=1017 )SHOW FULL COLUMNS
FROM `jos_projects`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` ASCSELECT count(DISTINCT p.id)
FROM jos_projects AS p
LEFT JOIN jos_project_owners AS o
ON o.projectid=p.id
AND o.userid='1017'
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='1017'
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='1017')))
AND p.provisioned = 0
AND p.private = 0SHOW FULL COLUMNS
FROM `jos_project_owners`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='ghjensen@uvic.ca'SHOW TABLESSHOW FULL COLUMNS
FROM `jos_project_todo`SHOW FULL COLUMNS
FROM `jos_projects`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='1017'
AND p.state !=2))
AND p.provisioned=0
AND o.userid=1017SELECT COUNT(*)
FROM jos_project_todo AS p
WHERE p.projectid IN ('15','18','21','19','53','52','55','60','61','65','66','67','68','69','101','102','103','105','106','107','108','152','113','88','154','249','57','330','331')
AND p.state=''SELECT COUNT(jos_activity_recipients.id) AS count
FROM `jos_activity_recipients`
WHERE `jos_activity_recipients`.`scope` = 'user'
AND `jos_activity_recipients`.`scope_id` = '1017'
AND `jos_activity_recipients`.`state` = '1'
AND `jos_activity_recipients`.`viewed` IS NULLSELECT *
FROM `jos_auth_link`
WHERE `jos_auth_link`.`user_id` = '1017'SELECT *
FROM `jos_xprofiles`
WHERE uidNumber = '1017';SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_search'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_register'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-30 03:38:41'
)
AND (`m`.`publish_down` IS NULL
OR `m`.`publish_down` >= '2025-04-30 03:38:41'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = ''
AND (`mm`.`menuid` = '83'
OR `mm`.`menuid` <= ''
)
AND `m`.`language` IN ('fr-FR','*')
ORDER BY `m`.`position` ASC,`m`.`ordering` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_menus'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_categories'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_events'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_groups'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_forum'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_answers'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_support'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_kb'UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:47;s:19:\"session.timer.start\";i:1745984294;s:18:\"session.timer.last\";i:1745984320;s:17:\"session.timer.now\";i:1745984320;s:24:\"session.client.forwarded\";s:11:\"3.144.48.13\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:1:\"0\";s:7:\"session\";s:4:\"Post\";O:8:\"stdClass\":2:{s:5:\"start\";d:0;s:5:\"
limit\";i:20;}s:10:\"Components\";O:8:\"stdClass\":2:{s:7:\"Members\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Profile\";O:8:\"stdClass\":2:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Option\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}s:4:\"Blog\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Comment\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:3:\"asc\";}}}}}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:\"0966acf38be58c144c8ca3893a4c3c5f\";s:12:\"tracker.ssid\";s:32:\"0966acf38be58c144c8ca3893a4c3c5f\";s:12:\"tracker.rsid\";s:32:\"0966acf38be58c144c8ca3893a4c3c5f\";s:13:\"session.token\";s:32:\"b4a87eaf4a308c340c77578084f6295c\";}',`time` = '1745984321',`ip` = '10.233.94.22'
WHERE `session_id` = '0966acf38be58c144c8ca3893a4c3c5f'
onAfterInitialise — Method — plgSystemLanguageFilter::onAfterInitialise → /app/plugins/system/languagefilter/languagefilter.php:186onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:21onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:20onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:21onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:21onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:113onAfterInitialise — Method — plgSystemReferrerpolicy::onAfterInitialise → /core/plugins/system/referrerpolicy/referrerpolicy.php:21onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:21onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:21onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:21onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:21onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:21onAfterRoute — Method — plgSystemPassword::onAfterRoute → /app/plugins/system/password/password.php:21onMembersAreas — Method — plgMembersDashboard::onMembersAreas → /app/plugins/members/dashboard/dashboard.php:62onMembersAreas — Method — plgMembersProfile::onMembersAreas → /app/plugins/members/profile/profile.php:30onMembersAreas — Method — plgMembersAccount::onMembersAreas → /app/plugins/members/account/account.php:34onMembersAreas — Method — plgMembersResume::onMembersAreas → /app/plugins/members/resume/resume.php:85onMembersAreas — Method — plgMembersMessages::onMembersAreas → /app/plugins/members/messages/messages.php:30onMembersAreas — Method — plgMembersBlog::onMembersAreas → /app/plugins/members/blog/blog.php:30onMembersAreas — Method — plgMembersCollections::onMembersAreas → /app/plugins/members/collections/collections.php:30onMembersAreas — Method — plgMembersContributions::onMembersAreas → /app/plugins/members/contributions/contributions.php:30onMembersAreas — Method — plgMembersRepository::onMembersAreas → /app/plugins/members/repository/repository.php:115onMembersAreas — Method — plgMembersImpact::onMembersAreas → /app/plugins/members/impact/impact.php:105onMembersAreas — Method — plgMembersGroups::onMembersAreas → /app/plugins/members/groups/groups.php:30onMembersAreas — Method — plgMembersProjects::onMembersAreas → /app/plugins/members/projects/projects.php:46onMembersAreas — Method — plgMembersUsage::onMembersAreas → /app/plugins/members/usage/usage.php:30onMembersAreas — Method — plgMembersTodo::onMembersAreas → /app/plugins/members/todo/todo.php:30onMembersAreas — Method — plgMembersActivity::onMembersAreas → /app/plugins/members/activity/activity.php:30onContentPrepare — Method — plgContentLoadmodule::onContentPrepare → /core/plugins/content/loadmodule/loadmodule.php:35onContentPrepare — Method — plgContentEmailcloak::onContentPrepare → /core/plugins/content/emailcloak/emailcloak.php:25onContentPrepare — Method — plgContentPagebreak::onContentPrepare → /core/plugins/content/pagebreak/pagebreak.php:35onContentPrepare — Method — plgContentXhubtags::onContentPrepare → /core/plugins/content/xhubtags/xhubtags.php:25onContentPrepare — Method — plgContentFormatwiki::onContentPrepare → /core/plugins/content/formatwiki/formatwiki.php:63onContentPrepare — Method — plgContentFormathtml::onContentPrepare → /core/plugins/content/formathtml/formathtml.php:105onContentPrepare — Method — plgContentExternalhref::onContentPrepare → /core/plugins/content/externalhref/externalhref.php:41onBlogView — Method — plgBlogOpengraph::onBlogView → /app/plugins/blog/opengraph/opengraph.php:22onBlogView — Method — plgBlogTwitter::onBlogView → /core/plugins/blog/twitter/twitter.php:22onMembersContributionsAreas — Method — plgMembersRepository::onMembersContributionsAreas → /app/plugins/members/repository/repository.php:341onMembersContributionsAreas — Method — plgMembersImpact::onMembersContributionsAreas → /app/plugins/members/impact/impact.php:221onMembersContributions — Method — plgMembersRepository::onMembersContributions → /app/plugins/members/repository/repository.php:387onMembersContributions — Method — plgMembersImpact::onMembersContributions → /app/plugins/members/impact/impact.php:266onMembers — Method — plgMembersDashboard::onMembers → /app/plugins/members/dashboard/dashboard.php:88onMembers — Method — plgMembersProfile::onMembers → /app/plugins/members/profile/profile.php:50onMembers — Method — plgMembersAccount::onMembers → /app/plugins/members/account/account.php:60onMembers — Method — plgMembersResume::onMembers → /app/plugins/members/resume/resume.php:190onMembers — Method — plgMembersMessages::onMembers → /app/plugins/members/messages/messages.php:56onMembers — Method — plgMembersBlog::onMembers → /app/plugins/members/blog/blog.php:50onMembers — Method — plgMembersCollections::onMembers → /app/plugins/members/collections/collections.php:50onMembers — Method — plgMembersContributions::onMembers → /app/plugins/members/contributions/contributions.php:50onMembers — Method — plgMembersRepository::onMembers → /app/plugins/members/repository/repository.php:182onMembers — Method — plgMembersImpact::onMembers → /app/plugins/members/impact/impact.php:138onMembers — Method — plgMembersGroups::onMembers → /app/plugins/members/groups/groups.php:56onMembers — Method — plgMembersProjects::onMembers → /app/plugins/members/projects/projects.php:71onMembers — Method — plgMembersUsage::onMembers → /app/plugins/members/usage/usage.php:50onMembers — Method — plgMembersTodo::onMembers → /app/plugins/members/todo/todo.php:57onMembers — Method — plgMembersActivity::onMembers → /app/plugins/members/activity/activity.php:54onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:22onAfterDispatch — Method — plgSystemLanguageFilter::onAfterDispatch → /app/plugins/system/languagefilter/languagefilter.php:554onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:60onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:25onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:21
