Etiquetas: open scholarship policy observatory

Resources (1-20 de 313)

  1. Politique des trois organismes sur le libre accès aux publications

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    La politique des trois organismes sur le libre accès aux publications est l’une des plus importantes politiques sur le libre accès au Canada. Comment cela s’inscrit-elle dans le mouvement plus...

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3134/?v=1

  2. Tri-Agency Open Access Policy on Publications

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    The Tri-Agency OA Policy is one of the single most important open access policies in Canada. How does it fit in the broader movement towards open scholarship?

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3133/?v=1

  3. L’Examen du soutien fédéral aux sciences

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    Le panneau de David Naylor appele pour “des améliorations substantielles au niveau de la gouvernance, de la supervision et de la formulation de conseils” de financement de la recherche au Canada.

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3132/?v=1

  4. Canada’s Fundamental Science Review

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    Naylor Report calls for “substantial improvements in governance, oversight, and advice” of federal funding for extramural research.

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3131/?v=1

  5. Access Copyright c. Université York

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    Quelles seront les répercussions de la récente décision de la Cour fédérale dans le procès Access Copyright c. L’Université York sur l’utilisation équitable au Canada?

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3130/?v=1

  6. Access Copyright v. York University

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    How does the recent Federal Court ruling in Access Copyright v. York University affect fair dealing in Canada?

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3129/?v=1

  7. Feuille de route sur la communication savante de l’ABRC

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    La feuille de route de l’ABRC décrit un plan pour un système de communication savante ouvert, durable et innovant.

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3128/?v=1

  8. CARL Scholarly Communications Roadmap

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    CARL Roadmap lays out plan for open, sustainable, effective scholarly communication.

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3127/?v=1

  9. Recommandations politiques pour le libre accès aux données de recherche en Europe (RECODE)

    11 Apr 2024 | Report | Contributor(s):

    By Alyssa Arbuckle

    Comment les recommandations politiques publiées par le projet européen RECODE se comparent-elles aux efforts semblables au Canada?

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3126/?v=1

  10. Policy Recommendations for Open Access to Research Data in Europe

    11 Apr 2024 | Report | Contributor(s):

    By Alyssa Arbuckle

    How do the policy recommendations released by the European RECODE Project compare to similar Canadian efforts?

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3125/?v=1

  11. Groupe de travail sur la science ouverte du G7

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    Recommandations du Groupe de travail du G7 sur la science ouverte visant à accélérer et à assurer la cohérence de la transition vers la science ouverte.

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3124/?v=1

  12. G7 Expert Group on Open Science

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    Recommendations from the G7 Open Science Working Group designed to help the speed and coherence of the transition towards Open Science.

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3123/?v=1

  13. Partner Response to Canada’s Fundamental Science Review

    11 Apr 2024 | Report | Contributor(s):

    By Brian Owen

    Brian Owen, Associate Dean of Libraries at SFU and Managing Director of PKP, shares observations from the perspective of a past and present participant in CFI-funded projects.

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3122/?v=1

  14. Tri-Agency Statement of Principles on Digital Data Management

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    The Tri-Agency outlines expectations of best practice with regards to data management, and responsibilities of researchers, research communities, research institutions and research funders.

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3121/?v=1

  15. Déclaration de principes des trois organismes sur la gestion des données numériques

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    Les trois organismes presentent les attentes de meilleurs pratiques concernant la gestion des données et les responsabilités des chercheurs, communautés de recherche, des institutions de recherche...

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3120/?v=1

  16. Appel de Jussieu pour la Science ouverte et la bibliodiversité

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    L’Appel de Jussieu pour la science ouverte et le bibliodiversité a été signé par des douzaines d’institutions recherche, organismes professionnels de l’information scientifique et technique,...

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3119/?v=1

  17. Jussieu Call for Open science and bibliodiversity

    11 Apr 2024 | Report | Contributor(s):

    By Sarah Milligan

    The Jussieu Call for Open Science and bibliodiversity has been signed by dozens of research institutions, societies, associations and journals.

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3118/?v=1

  18. Érudit et PKP appuient l’Appel de Jussieu pour la Science ouverte et la bibliodiversité

    11 Apr 2024 | Report | Contributor(s):

    By Tanja Niemann, Brian Owen

    L’équipe de la plateforme Érudit et les membres du Public Knowledge Project veulent signifier, par la présente, leur appui formel et enthousiaste à l’Appel de Jussieu pour la science ouverte et la...

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3117/?v=1

  19. Érudit and PKP support the Jussieu Call for Open Science and Bibliodiversity

    11 Apr 2024 | Report | Contributor(s):

    By Tanja Niemann, Brian Owen

    The Érudit and Public Knowledge Project team members want to affirm their formal and enthusiastic support for the Jussieu Call for Open Science and Bibliodiversity. The two organizations, which...

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3116/?v=1

  20. Integrated Digital Scholarship Ecosystem

    11 Apr 2024 | Report | Contributor(s):

    By Lisa Goddard

    In December 2017, Clare Appavoo, Executive Director of the Canadian Research Knowledge Network (CRKN) agreed to talk with Sarah Milligan about the Integrated Digital Scholarship Ecosystem (IDSE), a...

    https://hsscommons.rs-dev.uvic.ca/fr/publications/3115/?v=1

Debug Console

Close16 MBRequestSessionTimelineDatabase175Events30
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_HTTPS => on, REDIRECT_SCRIPT_URL => /fr/tags/openscholarshippolicyobservatory... Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /fr/tags/openscholarshippolicyobservatory/publications,
REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/fr/tags/openscholarshippolicyobservatory/publications,
REDIRECT_STATUS => 200,
HTTPS => on,
SCRIPT_URL => /fr/tags/openscholarshippolicyobservatory/publications,
SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/fr/tags/openscholarshippolicyobservatory/publications,
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_X_FORWARDED_FOR => 18.118.209.158,
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.118.209.158,
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 => 54408,
REDIRECT_URL => /fr/tags/openscholarshippolicyobservatory/publications,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /fr/tags/openscholarshippolicyobservatory/publications,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745951981.867,
REQUEST_TIME => 1745951981
)
session.client.forwarded 18.118.209.158
separator .
orderBy id
orderDir asc
always
0 registerDate
1 registerIP
2 access
renew
tracker.sid 1231c3986a708ee683a90c260ab81c3e
tracker.ssid 1231c3986a708ee683a90c260ab81c3e
tracker.rsid 1231c3986a708ee683a90c260ab81c3e
  • site 0.168 seconds (+0.168); 16.00 MB (+16.000) - afterInitialise
  • site 0.199 seconds (+0.031); 16.00 MB (0.000) - afterRoute
  • site 0.604 seconds (+0.405); 16.00 MB (0.000) - afterDispatch
  • site 0.611 seconds (+0.007); 16.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.620 seconds (+0.010); 16.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.622 seconds (+0.001); 16.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.622 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.622 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer (French))
  • site 0.623 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer (French))
  • site 0.623 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_wrapper (Wrapper)
  • site 0.623 seconds (+0.000); 16.00 MB (0.000) - afterRenderModule mod_wrapper (Wrapper)
  • site 0.623 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.624 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.624 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.625 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.625 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.641 seconds (+0.015); 16.00 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.641 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.641 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.642 seconds (+0.001); 16.00 MB (0.000) - onAfterRender
  • site 0.645 seconds (+0.003); 16.00 MB (0.000) - sessionStore
16 MB

175 Queries Logged: 0.44235992431641 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '2f47c33dd93ae81f968bc84e2a3fa727'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '2f47c33dd93ae81f968bc84e2a3fa727'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '1231c3986a708ee683a90c260ab81c3e'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '1231c3986a708ee683a90c260ab81c3e'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('1231c3986a708ee683a90c260ab81c3e','','1745951981','10.233.94.22')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id, 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'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= ''
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT *
      FROM `jos_languages`
      WHERE `published` = '1'
      ORDER BY `ordering` ASC
  12. SELECT language,id
      FROM `jos_menu`
      WHERE `home` = '1'
      AND `published` = '1'
      AND `client_id` = ''
  13. 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
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  15. 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
  16. SELECT *
      FROM `jos_tags`
      WHERE `jos_tags`.`tag` = 'openscholarshippolicyobservatory'
  17. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  18. SELECT COUNT(f.id)
      FROM (SELECT v.page_id AS id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_wiki_pages AS w
      INNER JOIN jos_wiki_versions AS v
      ON v.id=w.version_id
      LEFT JOIN `jos_xgroups` xg
      ON xg.gidNumber = w.scope_id
      AND w.scope='
      group'
      LEFT JOIN `jos_projects` xp
      ON xp.id = w.scope_id
      AND w.scope='project', jos_tags_object AS t
      WHERE w.id=v.page_id
      AND v.approved=1
      AND w.state < 2
      AND (xg.gidNumber IS NULL OR (xg.plugins LIKE '%wiki=anyone%'))
      AND w.id=t.objectid
      AND t.tbl='wiki'
      AND t.tagid IN (396)
      GROUP BY page_id
      HAVING uniques=1 ) AS f
  19. SELECT COUNT(f.id)
      FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_users AS a
      LEFT JOIN jos_user_profiles AS b
      ON a.id=b.user_id
      AND b.profile_key='bio', jos_tags_object AS t
      WHERE a.access IN (1,1,4)
      AND a.block=0
      AND a.activation > 0
      AND a.id=t.objectid
      AND t.tbl='xprofiles'
      AND t.tagid IN (396)
      GROUP BY a.id, b.profile_value
      HAVING uniques=1) AS f
  20. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_events AS e, jos_tags_object AS t
      WHERE e.state=1
      AND t.objectid=e.id
      AND t.tbl='events'
      AND t.tagid IN (396)
      GROUP BY e.id
      HAVING uniques=1) AS f
  21. SELECT COUNT(f.gidNumber)
      FROM (SELECT a.gidNumber, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_xgroups AS a JOIN jos_tags_object AS t
      WHERE (a.type=1 OR a.type=3)
      AND a.discoverability=0
      AND a.gidNumber=t.objectid
      AND t.tbl='groups'
      AND t.tagid IN (396)
      GROUP BY a.gidNumber
      HAVING uniques=1) AS f
  22. SELECT COUNT(f.id)
      FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_answers_questions` AS a, `jos_tags_object` AS t
      WHERE a.id=t.objectid
      AND t.tbl='answers'
      AND t.tagid IN (396)
      AND a.state!=2
      GROUP BY a.id
      HAVING uniques=1) AS f
  23. SELECT DISTINCT gidNumber
      FROM `jos_xgroups_members`
      WHERE uidNumber=0
  24. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  25. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_forum'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  26. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_forum_posts AS e
      LEFT JOIN jos_forum_categories c
      ON c.id = e.category_id
      LEFT JOIN jos_forum_sections s
      ON s.id = c.section_id
      LEFT JOIN jos_xgroups g
      ON g.gidNumber = e.scope_id
      LEFT JOIN jos_tags_object AS t
      ON t.objectid=e.id
      AND t.tbl='forum'
      AND t.tagid IN (396)
      WHERE e.state=1
      AND e.parent=0
      AND e.scope_id IN (0)
      GROUP BY e.id
      HAVING uniques=1) AS f
  27. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_blog_entries AS e, jos_tags_object AS t, jos_users AS u
      WHERE e.created_by=u.id
      AND t.objectid=e.id
      AND t.tbl='blog'
      AND t.tagid IN (396)
      AND e.state=1
      AND (e.publish_up IS NULL OR e.publish_up <= '2025-04-29 18:39:42')
      AND (e.publish_down IS NULL OR e.publish_down >= '2025-04-29 18:39:42')
      GROUP BY e.id
      HAVING uniques=1) AS f
  28. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_kb_articles` AS e
      LEFT JOIN `jos_categories` AS cc
      ON cc.id = e.category
      LEFT JOIN `jos_tags_object` AS t
      ON t.objectid=e.id
      AND t.tbl='kb'
      AND t.tagid IN (396)
      WHERE e.state=1
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  29. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  30. SELECT *
      FROM jos_publication_categories as C
      WHERE C.state=1
      ORDER BY C.name ASC
  31. SHOW FULL COLUMNS
      FROM `jos_publications`
  32. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  33. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  34. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=13
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  35. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  36. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=14
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  37. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  38. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=15
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  39. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  40. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=16
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  41. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  42. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=17
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  43. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  44. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=18
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  45. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  46. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=19
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  47. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  48. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=20
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  49. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  50. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=21
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  51. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  52. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=22
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  53. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  54. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=1
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  55. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  56. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=44
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  57. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  58. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=24
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  59. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  60. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=23
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  61. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  62. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=45
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  63. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  64. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=25
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  65. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  66. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=26
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  67. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  68. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=27
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  69. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  70. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=28
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  71. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  72. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=29
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  73. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  74. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=46
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  75. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  76. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=30
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  77. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  78. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=31
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  79. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  80. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=47
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  81. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  82. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=32
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  83. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  84. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=33
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  85. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  86. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=34
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  87. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  88. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=48
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  89. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  90. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=35
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  91. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  92. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=36
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  93. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  94. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=37
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  95. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  96. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=38
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  97. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  98. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=39
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  99. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  100. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=40
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  101. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  102. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=41
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  103. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  104. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=42
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  105. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  106. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      AND r.category=43
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  107. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  108. SELECT DISTINCT r.id, V.title, V.version_number as alias, V.abstract as itext, V.id as ftext, V.state AS state, V.created, V.created_by, V.modified, V.published_up as publish_up, V.published_down as publish_down, CONCAT('index.php?option=com_publications&id=', r.id) AS href, 'publications' AS section , COUNT(DISTINCT t.tagid) AS uniques , V.params, r.rating AS rcount, r.category AS data1, rt.name AS data2, r.ranking data3
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (396)
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1
      ORDER BY publish_up DESC
      LIMIT 0,20
  109. SELECT COUNT(f.id)
      FROM (SELECT p.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_collections_posts AS p
      INNER JOIN jos_collections AS c
      ON c.id=p.collection_id
      INNER JOIN jos_collections_items AS i
      ON p.item_id=i.id
      INNER JOIN jos_tags_object AS t
      WHERE i.state=1
      AND c.state=1
      AND t.objectid=p.item_id
      AND t.tbl='bulletinboard'
      AND t.tagid IN (396)
      AND i.access=0
      AND c.access=0
      GROUP BY p.id
      HAVING uniques=1) AS f
  110. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_courses` AS e, `jos_tags_object` AS t, `jos_users` AS u
      WHERE e.created_by=u.id
      AND e.state=1
      AND t.objectid=e.id
      AND t.tbl='courses'
      AND t.tagid IN (396)
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  111. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  112. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3166'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  113. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = ''
  114. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = NULL
  115. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  116. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3165'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  117. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  118. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3164'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  119. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  120. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3163'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  121. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  122. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3162'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  123. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  124. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3161'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  125. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  126. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3160'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  127. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  128. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3159'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  129. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  130. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3158'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  131. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1012'
  132. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1012'
  133. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1012';
  134. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  135. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3157'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  136. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  137. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3156'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  138. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  139. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3155'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  140. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  141. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3154'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  142. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  143. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3153'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  144. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  145. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3152'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  146. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  147. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3151'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  148. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  149. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3150'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  150. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  151. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3149'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  152. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  153. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3148'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  154. SHOW FULL COLUMNS
      FROM `jos_publication_authors`
  155. SELECT A.*, PO.invited_name, PO.invited_email
      FROM jos_publication_authors as A JOIN jos_project_owners as PO
      ON PO.id=A.project_owner_id
      WHERE A.publication_version_id='3147'
      AND A.status=1
      AND (A.role != 'submitter' || A.role IS NULL)
      ORDER BY A.ordering ASC
  156. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1048'
  157. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1048'
  158. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1048';
  159. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  160. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  161. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_register'
  162. 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-29 18:39:42' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2025-04-29 18:39:42' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = ''
      AND (`mm`.`menuid` = '89' OR `mm`.`menuid` <= '' )
      AND `m`.`language` IN ('fr-FR','*')
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  163. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_menus'
  164. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  165. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  166. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  167. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  168. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  169. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  170. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  171. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  172. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  173. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  174. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  175. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1745951981;s:18:\"session.timer.last\";i:1745951981;s:17:\"session.timer.now\";i:1745951981;s:24:\"session.client.forwarded\";s:14:\"18.118.209.158\";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:\"1231c3986a708ee683a90c260ab81c3e\";s:12:\"tracker.ssid\";s:32:\"1231c3986a708ee683a90c260ab81c3e\";s:12:\"tracker.rsid\";s:32:\"1231c3986a708ee683a90c260ab81c3e\";}',`time` = '1745951982',`ip` = '10.233.94.22'
      WHERE `session_id` = '1231c3986a708ee683a90c260ab81c3e'
  • 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
  • onTagView Method plgTagsWiki::onTagView /core/plugins/tags/wiki/wiki.php:33
  • onTagView Method plgTagsMembers::onTagView /core/plugins/tags/members/members.php:33
  • onTagView Method plgTagsEvents::onTagView /core/plugins/tags/events/events.php:33
  • onTagView Method plgTagsGroups::onTagView /core/plugins/tags/groups/groups.php:33
  • onTagView Method plgTagsAnswers::onTagView /core/plugins/tags/answers/answers.php:33
  • onTagView Method plgTagsForum::onTagView /core/plugins/tags/forum/forum.php:48
  • onTagView Method plgTagsBlogs::onTagView /core/plugins/tags/blogs/blogs.php:33
  • onTagView Method plgTagsKb::onTagView /core/plugins/tags/kb/kb.php:33
  • onTagView Method plgTagsPublications::onTagView /core/plugins/tags/publications/publications.php:48
  • onTagView Method plgTagsCollections::onTagView /core/plugins/tags/collections/collections.php:33
  • onTagView Method plgTagsCourses::onTagView /core/plugins/tags/courses/courses.php:33
  • onGetMultiEntry Method plgHubzeroAutocompleter::onGetMultiEntry /core/plugins/hubzero/autocompleter/autocompleter.php:139
  • 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