REDIRECT_HTTPS => on, REDIRECT_SCRIPT_URL => /es/tags/policyanalysis/publications, REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/es/tags/policyanalysis/publications, REDIRECT_STATUS => 200, HTTPS => on, SCRIPT_URL => /es/tags/policyanalysis/publications, SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/es/tags/policyanalysis/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_COOKIE => cookie=43a25f71035b89b5; 8512ae7d57b1396273f76fe6ed341a23=es; d482552ea4a74f85af0bb3d73890dabc=%205%20E%2045E43105E%20E%202444543%207406F5D%2011B%2037E%20B4A%203%2005F41134B514059%204%20951135F765817%203%20B5C1243%20B5612%20F16%203%20B%202%20A1B%20A%20A%2035A53%209%20057%20F%2015755%20953%20D50%2025A%20E52%20852505052%20C52%20A%20C%203%2035C1B%203165952%202164044%20C%20016%20A17%2025056%2031A55%202565B%207%201%200%200%2015C%20351%201%20E%20D56%205%205%20E%200%20A5557%20656%20953%20B5757%20A5D44%20B4358%206%20A16164A515412%2024A%20256515C1A%207%200515C51%205%205%201%200%2075758%20051%205%203%20451%206%2005D5B%20A5252%201%20E%20B5150555D16%2094A; 81f30cf708470b974874c8a96a6bcdb2=32f9514e8d3a8753fc648b2bb873433e, HTTP_X_FORWARDED_FOR => 18.219.165.19, 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.219.165.19, 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 => 43224, REDIRECT_URL => /es/tags/policyanalysis/publications, GATEWAY_INTERFACE => CGI/1.1, SERVER_PROTOCOL => HTTP/1.1, REQUEST_METHOD => GET, QUERY_STRING => REQUEST_URI => /es/tags/policyanalysis/publications, SCRIPT_NAME => /index.php, PHP_SELF => /index.php, REQUEST_TIME_FLOAT => 1745101169.1029, REQUEST_TIME => 1745101169session.client.forwarded ⇒ 18.219.165.19
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
always ⇒
0 ⇒ registerDate
1 ⇒ registerIP
2 ⇒ access
renew ⇒
tracker.sid ⇒ 32f9514e8d3a8753fc648b2bb873433e
tracker.ssid ⇒ 32f9514e8d3a8753fc648b2bb873433e
tracker.rsid ⇒ 32f9514e8d3a8753fc648b2bb873433e
site 0.067 seconds (+0.067); 16.00 MB (+16.000) - afterInitialisesite 0.086 seconds (+0.020); 16.00 MB (0.000) - afterRoutesite 1.218 seconds (+1.132); 16.00 MB (0.000) - afterDispatchsite 1.241 seconds (+0.023); 16.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)site 1.264 seconds (+0.023); 16.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)site 1.264 seconds (+0.001); 16.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer (Spanish))site 1.265 seconds (+0.000); 16.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer (Spanish))site 1.265 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)site 1.265 seconds (+0.000); 16.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)site 1.265 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_wrapper (Wrapper)site 1.265 seconds (+0.000); 16.00 MB (0.000) - afterRenderModule mod_wrapper (Wrapper)site 1.265 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)site 1.266 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)site 1.266 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_collect (Collect)site 1.267 seconds (+0.000); 16.00 MB (0.000) - afterRenderModule mod_collect (Collect)site 1.267 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)site 1.309 seconds (+0.042); 16.00 MB (0.000) - afterRenderModule mod_menu (Main Menu)site 1.309 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)site 1.310 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)site 1.310 seconds (+0.001); 16.00 MB (0.000) - onAfterRendersite 1.319 seconds (+0.009); 16.00 MB (0.000) - sessionStoreSELECT data
FROM `jos_session`
WHERE `session_id` = '32f9514e8d3a8753fc648b2bb873433e'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_members'SELECT b.id, b.title
FROM `jos_usergroups` AS `a`
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE `a`.`id` = '1'SELECT *
FROM `jos_viewlevels`SELECT folder AS type,element AS name,protected,params
FROM `jos_extensions`
WHERE `enabled` >= '1'
AND `type` = 'plugin'
AND `state` >= ''
AND `access` IN ('1','1','4')
ORDER BY `ordering` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT *
FROM `jos_languages`
WHERE `published` = '1'
ORDER BY `ordering` ASCSELECT language,id
FROM `jos_menu`
WHERE `home` = '1'
AND `published` = '1'
AND `client_id` = ''SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
FROM `jos_menu` AS `m`
LEFT JOIN jos_extensions AS e
ON e.extension_id = m.component_id
WHERE `m`.`published` = '1'
AND `m`.`parent_id` > ''
AND `m`.`client_id` = ''
ORDER BY `m`.`lft` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tags'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` DESCSELECT *
FROM `jos_tags`
WHERE `jos_tags`.`tag` = 'policyanalysis'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_publications'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 (397)
GROUP BY page_id
HAVING uniques=1 ) AS fSELECT 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 (397)
GROUP BY a.id, b.profile_value
HAVING uniques=1) AS fSELECT 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 (397)
GROUP BY e.id
HAVING uniques=1) AS fSELECT 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 (397)
GROUP BY a.gidNumber
HAVING uniques=1) AS fSELECT 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 (397)
AND a.state!=2
GROUP BY a.id
HAVING uniques=1) AS fSELECT DISTINCT gidNumber
FROM `jos_xgroups_members`
WHERE uidNumber=0SELECT a.rules
FROM `jos_assets` AS `a`
WHERE `a`.`id` = '1'
GROUP BY a.id, a.rules, a.lftSELECT b.rules
FROM `jos_assets` AS `a`
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE `a`.`name` = 'com_forum'
GROUP BY b.id, b.rules, b.lft
ORDER BY `b`.`lft` ASCSELECT 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 (397)
WHERE e.state=1
AND e.parent=0
AND e.scope_id IN (0)
GROUP BY e.id
HAVING uniques=1) AS fSELECT 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 (397)
AND e.state=1
AND (e.publish_up IS NULL OR e.publish_up <= '2025-04-19 22:19:29')
AND (e.publish_down IS NULL OR e.publish_down >= '2025-04-19 22:19:29')
GROUP BY e.id
HAVING uniques=1) AS fSELECT 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 (397)
WHERE e.state=1
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`SELECT *
FROM jos_publication_categories as C
WHERE C.state=1
ORDER BY C.name ASCSHOW FULL COLUMNS
FROM `jos_publications`( 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 )SHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=13
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=14
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=15
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=16
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=17
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=18
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=19
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=20
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=21
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=22
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=1
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=44
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=24
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=23
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=45
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=25
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=26
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=27
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=28
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=29
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=46
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=30
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=31
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=47
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=32
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=33
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=34
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=48
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=35
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=36
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=37
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=38
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=39
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=40
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=41
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=42
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
AND r.category=43
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS fSHOW FULL COLUMNS
FROM `jos_publication_categories`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 (397)
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1
ORDER BY publish_up DESC
LIMIT 0,20SELECT 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 (397)
AND i.access=0
AND c.access=0
GROUP BY p.id
HAVING uniques=1) AS fSELECT 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 (397)
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1) AS fSHOW FULL COLUMNS
FROM `jos_publication_authors`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 SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = ''SELECT *
FROM `jos_user_profiles`
WHERE `jos_user_profiles`.`user_id` = NULLSHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = '1012'SELECT *
FROM `jos_user_profiles`
WHERE `jos_user_profiles`.`user_id` = '1012'SELECT *
FROM `jos_xprofiles`
WHERE uidNumber = '1012';SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SHOW FULL COLUMNS
FROM `jos_publication_authors`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 SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = '1048'SELECT *
FROM `jos_user_profiles`
WHERE `jos_user_profiles`.`user_id` = '1048'SELECT *
FROM `jos_xprofiles`
WHERE uidNumber = '1048';SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_search'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_register'SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
FROM `jos_modules` AS `m`
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE `m`.`published` = '1'
AND `e`.`enabled` = '1'
AND (`m`.`publish_up` IS NULL
OR `m`.`publish_up` <= '2025-04-19 22:19:30'
)
AND (`m`.`publish_down` IS NULL
OR `m`.`publish_down` >= '2025-04-19 22:19:30'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = ''
AND (`mm`.`menuid` = '89'
OR `mm`.`menuid` <= ''
)
AND `m`.`language` IN ('es','*')
ORDER BY `m`.`position` ASC,`m`.`ordering` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_menus'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_categories'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_collections'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_events'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_blog'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_groups'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_projects'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_forum'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_answers'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_support'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_kb'UPDATE `jos_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1745101158;s:18:\"session.timer.last\";i:1745101168;s:17:\"session.timer.now\";i:1745101169;s:24:\"session.client.forwarded\";s:13:\"18.219.165.19\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:4:\"Post\";O:8:\"stdClass\":2:{s:5:\"start\";d:0;s:5:\"
limit\";i:20;}}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:\"32f9514e8d3a8753fc648b2bb873433e\";s:12:\"tracker.ssid\";s:32:\"32f9514e8d3a8753fc648b2bb873433e\";s:12:\"tracker.rsid\";s:32:\"32f9514e8d3a8753fc648b2bb873433e\";}',`time` = '1745101170',`ip` = '10.233.94.22'
WHERE `session_id` = '32f9514e8d3a8753fc648b2bb873433e'onAfterInitialise — Method — plgSystemLanguageFilter::onAfterInitialise → /app/plugins/system/languagefilter/languagefilter.php:186onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:21onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:20onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:21onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:21onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:113onAfterInitialise — Method — plgSystemReferrerpolicy::onAfterInitialise → /core/plugins/system/referrerpolicy/referrerpolicy.php:21onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:21onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:21onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:21onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:21onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:21onAfterRoute — Method — plgSystemPassword::onAfterRoute → /app/plugins/system/password/password.php:21onTagView — Method — plgTagsWiki::onTagView → /core/plugins/tags/wiki/wiki.php:33onTagView — Method — plgTagsMembers::onTagView → /core/plugins/tags/members/members.php:33onTagView — Method — plgTagsEvents::onTagView → /core/plugins/tags/events/events.php:33onTagView — Method — plgTagsGroups::onTagView → /core/plugins/tags/groups/groups.php:33onTagView — Method — plgTagsAnswers::onTagView → /core/plugins/tags/answers/answers.php:33onTagView — Method — plgTagsForum::onTagView → /core/plugins/tags/forum/forum.php:48onTagView — Method — plgTagsBlogs::onTagView → /core/plugins/tags/blogs/blogs.php:33onTagView — Method — plgTagsKb::onTagView → /core/plugins/tags/kb/kb.php:33onTagView — Method — plgTagsPublications::onTagView → /core/plugins/tags/publications/publications.php:48onTagView — Method — plgTagsCollections::onTagView → /core/plugins/tags/collections/collections.php:33onTagView — Method — plgTagsCourses::onTagView → /core/plugins/tags/courses/courses.php:33onGetMultiEntry — Method — plgHubzeroAutocompleter::onGetMultiEntry → /core/plugins/hubzero/autocompleter/autocompleter.php:139onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:22onAfterDispatch — Method — plgSystemLanguageFilter::onAfterDispatch → /app/plugins/system/languagefilter/languagefilter.php:554onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:60onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:25onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:21