Minh To

The profile picture for Minh To

Blog written in French site

Entrada #8
0 comentarios

This blog was written in French site

Comentarios en esta entrada

Actualmente no hay comentarios.

Agregar un comentario

Por favor mantén los comentarios relevantes al tema de esta entrada.

Los saltos de línea y los párrafos se convierten automáticamente. Las URL (que comienzan con http://) o las direcciones de correo electrónico se vincularán automáticamente.

Debug Console

Close18 MBRequestSessionTimelineDatabase80Events61
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( 8512ae7d57b1396273f76fe6ed341a23 => en-GB, 81f30cf708470b974874c8a96a6bcdb2 => 1c6b7ba... Array(
8512ae7d57b1396273f76fe6ed341a23 => en-GB,
81f30cf708470b974874c8a96a6bcdb2 => 1c6b7ba04229b1b6600ff607f2788b21,
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B 85B53 1515A55 2 35756 D53555A5552 9 8 056 652 556 652 1 052 2 81B 3165952 2164044 C 016 A17 25056 31A5753 6 0 5525555 D A 2 95B 85A535556 85254 1555352 353 05B 6 B 944 B4358 6 A16164A515412 24A 256515C1A 551 1 753565054 C5156 05A5752 654 2 052 3 F 8 756 B E 05D 154 916 94A,
cookie => 43a25f71035b89b5
)
$_SERVER
Array( REDIRECT_HTTPS => on, REDIRECT_SCRIPT_URL => /es/members/1044/blog/2023/10/blog-writte... Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /es/members/1044/blog/2023/10/blog-written-in-french-site,
REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/es/members/1044/blog/2023/10/blog-written-in-french-site,
REDIRECT_STATUS => 200,
HTTPS => on,
SCRIPT_URL => /es/members/1044/blog/2023/10/blog-written-in-french-site,
SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/es/members/1044/blog/2023/10/blog-written-in-french-site,
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=en-GB; 81f30cf708470b974874c8a96a6bcdb2=1c6b7ba04229b1b6600ff607f2788b21; d482552ea4a74f85af0bb3d73890dabc=%205%20E%2045E43105E%20E%202444543%207406F5D%2011B%2037E%20B4A%203%2005F41134B514059%204%20951135F765817%203%20B5C1243%20B5612%20F16%203%20B%202%20A1B%2085B53%201515A55%202%2035756%20D53555A5552%209%208%20056%20652%20556%20652%201%20052%202%2081B%203165952%202164044%20C%20016%20A17%2025056%2031A5753%206%200%205525555%20D%20A%202%2095B%2085A535556%2085254%201555352%20353%2005B%206%20B%20944%20B4358%206%20A16164A515412%2024A%20256515C1A%20551%201%20753565054%20C5156%2005A5752%20654%202%20052%203%20F%208%20756%20B%20E%2005D%20154%20916%2094A; cookie=43a25f71035b89b5,
HTTP_X_FORWARDED_FOR => 18.220.236.72,
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 => 18.220.236.72,
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 => 51828,
REDIRECT_URL => /es/members/1044/blog/2023/10/blog-written-in-french-site,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /es/members/1044/blog/2023/10/blog-written-in-french-site,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745171865.6562,
REQUEST_TIME => 1745171865
)
session.client.forwarded ⇒ 18.220.236.72
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
always ⇒
0 ⇒ registerDate
1 ⇒ registerIP
2 ⇒ access
renew ⇒
tracker.sid ⇒ 1c6b7ba04229b1b6600ff607f2788b21
tracker.ssid ⇒ 1c6b7ba04229b1b6600ff607f2788b21
tracker.rsid ⇒ 1c6b7ba04229b1b6600ff607f2788b21
session.token ⇒ 19a38b8db4547e1693655ec3bdae0090
  • site 0.063 seconds (+0.063); 18.00 MB (+18.000) - afterInitialise
  • site 0.087 seconds (+0.024); 18.00 MB (0.000) - afterRoute
  • site 0.661 seconds (+0.574); 18.00 MB (0.000) - afterDispatch
  • site 0.685 seconds (+0.025); 18.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.696 seconds (+0.011); 18.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.697 seconds (+0.001); 18.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer (Spanish))
  • site 0.697 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer (Spanish))
  • site 0.697 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.698 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.698 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_wrapper (Wrapper)
  • site 0.698 seconds (+0.000); 18.00 MB (0.000) - afterRenderModule mod_wrapper (Wrapper)
  • site 0.698 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.699 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.699 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.700 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.700 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.724 seconds (+0.025); 18.00 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.724 seconds (+0.000); 18.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.725 seconds (+0.001); 18.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.726 seconds (+0.001); 18.00 MB (0.000) - onAfterRender
  • site 0.755 seconds (+0.029); 18.00 MB (0.000) - sessionStore
18 MB

80 Queries Logged: 0.58123111724854 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '1c6b7ba04229b1b6600ff607f2788b21'
  2. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  3. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  4. 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'
  5. SELECT *
      FROM `jos_viewlevels`
  6. 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
  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` = '1044'
  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='1044'
      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 17:57:45'
      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 17:57:45'
  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=1044
      WHERE `jos_xmessage_recipient`.`uid` = '1044'
      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` = '1044'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=1044)
  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_plugin_params`
      WHERE `jos_plugin_params`.`object_id` = '1044'
      AND `jos_plugin_params`.`folder` = 'members'
      AND `jos_plugin_params`.`element` = 'blog'
  28. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`alias` = 'blog-written-in-french-site'
      AND `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1044'
      AND `jos_blog_entries`.`state` IN ('','1')
      ORDER BY `state` DESC
  29. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '8'
      AND `jos_blog_comments`.`state` IN ('1','3')
  30. 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` = '8'
      AND `jos_tags`.`admin` NOT IN ('1')
      GROUP BY jos_tags_object.label,jos_tags.id
  31. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1044'
      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 17:57:45' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2025-04-20 17:57:45' )
      ORDER BY `hits` DESC
      LIMIT 5
  32. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` IN ('1044')
  33. SELECT id,entry_id
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`entry_id` IN ('8')
  34. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1044'
  35. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '8'
      AND `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`parent` = ''
      ORDER BY `created` ASC
  36. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = ''
  37. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = NULL
  38. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '8'
      AND `jos_blog_comments`.`id` = ''
      AND `jos_blog_comments`.`state` IN ('1','3')
  39. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  40. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1044'
      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 17:57:46' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2025-04-20 17:57:46' )
  41. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  42. SHOW FULL COLUMNS
      FROM `jos_collections`
  43. 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='1044'
      AND b.object_type='member'
  44. SHOW FULL COLUMNS
      FROM `jos_collections`
  45. 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='1044'
      AND b.object_type='member'
  46. SHOW FULL COLUMNS
      FROM `jos_publications`
  47. SHOW FULL COLUMNS
      FROM `jos_publications`
  48. 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=1044
      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 17:57:46')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-20 17:57:46')
      AND V.state != 2
      AND (V.access != 2)
      GROUP BY C.id, V.id
  49. SHOW FULL COLUMNS
      FROM `jos_publication_logs`
  50. 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='1044'
      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 17:57:46'
      GROUP BY V.publication_id
      ORDER BY V.title ASC
  51. SHOW FULL COLUMNS
      FROM `jos_publication_logs`
  52. 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='1044'
      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 17:57:46'
      GROUP BY V.publication_id
      ORDER BY V.title ASC
  53. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'minhto@uvic.ca'
  54. ( 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=1044 ) 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=1044 ) 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=1044 ) 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=1044 )
  55. SHOW FULL COLUMNS
      FROM `jos_projects`
  56. 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
  57. 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='1044'
      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='1044'
      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='1044')))
      AND p.provisioned = 0
      AND p.private = 0
  58. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  59. 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='minhto@uvic.ca'
  60. SHOW TABLES
  61. SHOW FULL COLUMNS
      FROM `jos_project_todo`
  62. SHOW FULL COLUMNS
      FROM `jos_projects`
  63. 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='1044'
      AND p.state !=2))
      AND p.provisioned=0
      AND o.userid=1044
  64. SELECT COUNT(*)
      FROM jos_project_todo AS p
      WHERE p.projectid IN ('105','106','107','108','21','158','215','220','60','244','245')
      AND p.state=''
  65. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '1044'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  66. SELECT *
      FROM `jos_auth_link`
      WHERE `jos_auth_link`.`user_id` = '1044'
  67. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1044';
  68. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  69. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_register'
  70. 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 17:57:46' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2025-04-20 17:57:46' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = ''
      AND (`mm`.`menuid` = '83' OR `mm`.`menuid` <= '' )
      AND `m`.`language` IN ('es','*')
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  71. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_menus'
  72. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  73. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  74. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  75. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  76. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  77. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  78. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  79. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  80. UPDATE `jos_session`
      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:21;s:19:\"session.timer.start\";i:1745171822;s:18:\"session.timer.last\";i:1745171864;s:17:\"session.timer.now\";i:1745171865;s:24:\"session.client.forwarded\";s:13:\"18.220.236.72\";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\":1:{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:\"1c6b7ba04229b1b6600ff607f2788b21\";s:12:\"tracker.ssid\";s:32:\"1c6b7ba04229b1b6600ff607f2788b21\";s:12:\"tracker.rsid\";s:32:\"1c6b7ba04229b1b6600ff607f2788b21\";s:13:\"session.token\";s:32:\"19a38b8db4547e1693655ec3bdae0090\";}',`time` = '1745171866',`ip` = '10.233.94.22'
      WHERE `session_id` = '1c6b7ba04229b1b6600ff607f2788b21'
  • 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
  • onContentPrepare — Method — plgContentLoadmodule::onContentPrepare → /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare — Method — plgContentEmailcloak::onContentPrepare → /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare — Method — plgContentPagebreak::onContentPrepare → /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare — Method — plgContentXhubtags::onContentPrepare → /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare — Method — plgContentFormatwiki::onContentPrepare → /core/plugins/content/formatwiki/formatwiki.php:63
  • onContentPrepare — Method — plgContentFormathtml::onContentPrepare → /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare — Method — plgContentExternalhref::onContentPrepare → /core/plugins/content/externalhref/externalhref.php:41
  • onBlogView — Method — plgBlogOpengraph::onBlogView → /app/plugins/blog/opengraph/opengraph.php:22
  • onBlogView — Method — plgBlogTwitter::onBlogView → /core/plugins/blog/twitter/twitter.php:22
  • 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