- $_GET
-
Array(
terms => spanish
)
Array(
terms => spanish
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
)
Array(
)
- $_SERVER
-
Array(
REDIRECT_SCRIPT_URL => /search/,
REDIRECT_SCRIPT_URI => https://www.simiode.org/search...
Array(
REDIRECT_SCRIPT_URL => /search/,
REDIRECT_SCRIPT_URI => https://www.simiode.org/search/,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => www.simiode.org,
REDIRECT_STATUS => 200,
SCRIPT_URL => /search/,
SCRIPT_URI => https://www.simiode.org/search/,
HTTPS => on,
SSL_TLS_SNI => www.simiode.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_IF_MODIFIED_SINCE => Mon, 25 Jan 2021 00:53:41 GMT,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => www.simiode.org,
HTTP_CONNECTION => Keep-Alive,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE =>
SERVER_SOFTWARE => Apache/2.4.10 (Debian),
SERVER_NAME => www.simiode.org,
SERVER_ADDR => 74.208.170.104,
SERVER_PORT => 443,
REMOTE_ADDR => 3.235.175.15,
DOCUMENT_ROOT => /var/www/simiode,
REQUEST_SCHEME => https,
CONTEXT_PREFIX =>
CONTEXT_DOCUMENT_ROOT => /var/www/simiode,
SERVER_ADMIN => [no address given],
SCRIPT_FILENAME => /var/www/simiode/index.php,
REMOTE_PORT => 51148,
REDIRECT_QUERY_STRING => terms=spanish,
REDIRECT_URL => /search/,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => terms=spanish,
REQUEST_URI => /search/?terms=spanish,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1632441226.642,
REQUEST_TIME => 1632441226
)
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ c818e8d3136e018b8f5bad505a026a70
tracker.ssid ⇒ c818e8d3136e018b8f5bad505a026a70
tracker.rsid ⇒ c818e8d3136e018b8f5bad505a026a70
12 MB
59 Queries Logged: 0.41882514953613 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = '2fecf3a1a6ef6deeca5271c0bff40ce1'DELETE
FROM `jos_session`
WHERE `session_id` = '2fecf3a1a6ef6deeca5271c0bff40ce1'SELECT data
FROM `jos_session`
WHERE `session_id` = 'c818e8d3136e018b8f5bad505a026a70'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT session_id
FROM `jos_session`
WHERE `session_id` = 'c818e8d3136e018b8f5bad505a026a70'
LIMIT 1INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('c818e8d3136e018b8f5bad505a026a70','0','1632441226','3.235.175.15')SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_members'SELECT b.id
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` >= '0'
AND `access` IN ('1','1','4')
ORDER BY `ordering` ASCSELECT 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` > '0'
AND `m`.`client_id` = '0'
ORDER BY `m`.`lft` ASCSELECT con.`id`, cat.`alias`, cat.`path`
FROM `jos_content` AS con
LEFT JOIN `jos_categories` AS cat
ON con.catid = cat.id
WHERE con.state=1
AND con.`alias` = 'search'SELECT *
FROM `jos_redirect_links`
WHERE `published`=1
AND (`old_url`='https://www.simiode.org/search/?terms=spanish'
OR `old_url`='/search/?terms=spanish')
LIMIT 1SELECT 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` = '0'
AND `jos_extensions`.`enabled` = '1'
AND `jos_extensions`.`type` = 'template'
AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
ORDER BY `home` DESCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_search'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_tags'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_resources'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_courses'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_publications'SELECT plugin, weight
FROM `jos_ysearch_plugin_weights`SELECT
id,
t.raw_tag AS title,
description,
concat('index.php?option=com_tags&tag=', t.tag) AS link,
match(t.raw_tag, t.description) against ('spanish') AS weight,
NULL AS date,
'Tags' AS section
FROM `jos_tags` t
WHERE
match(t.raw_tag, t.description) against ('spanish') > 0
ORDER BY match(t.raw_tag, t.description) against ('spanish') DESCSELECT objectid, tbl
FROM `jos_tags_object`
WHERE tagid IN (3050)SELECT
u.id,
u.name AS title,
coalesce(p.profile_key, '') AS description,
concat('index.php?option=com_members&id=',
CASE WHEN u.id > 0 THEN u.id ELSE concat('n', abs(u.id)) END) AS link,
NULL AS date,
'Members' AS section,
NULL AS img_href
FROM `jos_users` AS u
LEFT JOIN `jos_user_profiles` AS p
ON u.id = p.user_id
AND p.profile_key = 'bio'
WHERE
u.block=0
AND u.approved>0
AND
u.access IN (1,1,4)
AND (u.name LIKE '%spanish%')SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_citations'SELECT
e.title,
e.content AS description,
e.scope,
e.scope_id,
concat('index.php?option=com_events&task=details&id=', e.id) AS link,
match(e.title, e.content) against('spanish') AS weight,
publish_up AS date,
'Events' AS section
FROM `jos_events` e
WHERE
state = 1
AND
approved
AND match(e.title, e.content) against('spanish') > 0
ORDER BY match(e.title, e.content) against('spanish') DESCSELECT 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_groups'
GROUP BY b.id, b.rules, b.lft
ORDER BY `b`.`lft` ASCSELECT
f.title,
coalesce(f.comment, '') AS description, f.scope_id, s.alias as sect, c.alias as cat,
CASE WHEN f.parent > 0 THEN f.parent ELSE f.id END as `thread`,
(
CASE
WHEN f.scope_id > 0
AND f.scope='
group' THEN concat('index.php?option=com_groups&cn=', g.cn, '&active=forum')
ELSE concat('index.php?option=com_forum§ion=', coalesce(concat(s.alias, '&category=', coalesce(concat(c.alias, '&thread='), ''))),
CASE WHEN f.parent > 0 THEN f.parent ELSE f.id END)
END) AS `link`,
match(f.title, f.comment) against ('spanish') AS `weight`,
f.created AS `date`,
concat(s.alias, ', ', c.alias) AS `section`
FROM `jos_forum_posts` f
LEFT JOIN `jos_forum_categories` AS c
ON c.id = f.category_id
LEFT JOIN `jos_forum_sections` AS s
ON s.id = c.section_id
LEFT JOIN `jos_xgroups` AS g
ON g.gidNumber = f.scope_id
AND f.scope='
group'
WHERE
f.state = 1
AND
f.scope != 'course'
AND
match(f.title, f.comment) against ('spanish') > 0
AND f.scope_id IN (0)
AND (g.gidNumber IS NULL OR (g.plugins LIKE '%forum=anyone%'))
ORDER BY match(f.title, f.comment) against ('spanish') DESCSELECT
q.id AS qid, q.created AS q_created, q.subject, q.question, r.id AS rid, r.answer, r.created AS r_created, match(q.question, q.subject) against('spanish') AS qweight, null AS rweight,
CASE
when q.anonymous > 0 then NULL
else (SELECT name
FROM `jos_users`
WHERE id = q.created_by)
END AS qcontributors,
CASE
when q.anonymous > 0 then null
else (SELECT id
FROM `jos_users`
WHERE id = q.created_by)
END AS qcontributor_ids,
CASE
when r.anonymous > 0 then NULL
else (SELECT name
FROM `jos_users`
WHERE id = r.created_by)
END AS rcontributors,
CASE
when r.anonymous > 0 then null
else (SELECT id
FROM `jos_users`
WHERE id = r.created_by)
END AS rcontributor_ids
FROM `jos_answers_questions` q
LEFT JOIN `jos_answers_responses` r
ON r.question_id = q.id
AND r.state != 2
WHERE match(q.question, q.subject) against('spanish') > 0
AND q.state != 2
UNION
SELECT
q.id AS qid, q.created AS q_created, q.subject, q.question, r.id AS rid, r.answer, r.created AS r_created, null AS qweight, match(r.answer) against('spanish') AS rweight,
CASE
when q.anonymous > 0 then NULL
else (SELECT name
FROM `jos_users`
WHERE id = q.created_by)
END AS qcontributors,
CASE
when q.anonymous > 0 then null
else (SELECT id
FROM `jos_users`
WHERE id = q.created_by)
END AS qcontributor_ids,
CASE
when r.anonymous > 0 then NULL
else (SELECT name
FROM `jos_users`
WHERE id = r.created_by)
END AS rcontributors,
CASE
when r.anonymous > 0 then null
else (SELECT id
FROM `jos_users`
WHERE id = r.created_by)
END AS rcontributor_ids
FROM `jos_answers_responses` r2
INNER JOIN `jos_answers_questions` q
ON q.id = r2.question_id
AND q.state != 2
LEFT JOIN `jos_answers_responses` r
ON r.question_id = q.id
AND r.state != 2
WHERE match(r2.answer) against('spanish') > 0
AND r2.state != 2
ORDER BY q_created, r_createdSELECT
r.id,
r.title,
coalesce(r.`fulltxt`, r.introtext, '') AS description,
concat('index.php?option=com_resources&id=', coalesce(
case when r.alias = '' then null else r.alias end, r.id)) AS link,
match(r.title, r.introtext, r.`fulltxt`) against ('spanish') AS weight,
r.publish_up AS date,
rt.type AS section,
(SELECT group_concat(u1.name
order by anames.ordering separator '\n')
FROM `jos_author_assoc` anames
LEFT JOIN `jos_xprofiles` u1
ON u1.uidNumber = anames.authorid
WHERE subtable = 'resources'
AND subid = r.id)
AS contributors,
(SELECT group_concat(anames.authorid
order by anames.ordering separator '\n')
FROM `jos_author_assoc` anames
WHERE subtable = 'resources'
AND subid = r.id)
AS contributor_ids,
(select group_concat(concat(parent_id, '|', ordering))
from `jos_resource_assoc` ra2
left join `jos_resources` re3
on re3.id = ra2.parent_id
and re3.standalone
where ra2.child_id = r.id) AS parents
FROM `jos_resources` r
LEFT JOIN `jos_resource_types` rt
ON rt.id = r.type
WHERE
r.published = 1
AND r.standalone
AND (access IN (0,1,1,4))
AND (r.publish_up
AND UTC_TIMESTAMP() > r.publish_up)
AND (NOT r.publish_down OR UTC_TIMESTAMP() < r.publish_down)
AND (match(r.title, r.introtext, r.`fulltxt`) against ('spanish') > 0)SELECT
r.id,
r.title,
coalesce(r.`fulltxt`, r.introtext, '') AS description,
concat('index.php?option=com_resources&id=', coalesce(
case when r.alias = '' then null else r.alias end, r.id)) AS link,
r.publish_up AS date,
0.5 as weight,
rt.type AS section,
(SELECT group_concat(u1.name
order by anames.ordering separator '\n')
FROM `jos_author_assoc` anames
LEFT JOIN `jos_xprofiles` u1
ON u1.uidNumber = anames.authorid
WHERE subtable = 'resources'
AND subid = r.id)
AS contributors,
(SELECT group_concat(anames.authorid
order by anames.ordering separator '\n')
FROM `jos_author_assoc` anames
WHERE subtable = 'resources'
AND subid = r.id)
AS contributor_ids,
(select group_concat(concat(parent_id, '|', ordering))
from `jos_resource_assoc` ra2
left join `jos_resources` re3
on re3.id = ra2.parent_id
and re3.standalone
where ra2.child_id = r.id) AS parents
FROM `jos_resources` r
LEFT JOIN `jos_resource_types` rt
ON rt.id = r.type
WHERE
r.published = 1
AND r.standalone
AND (access IN (0,1,1,4))
AND (r.publish_up
AND NOW() > r.publish_up)
AND (NOT r.publish_down OR NOW() < r.publish_down)
AND r.id in (200,198)SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wiki'SELECT
wp.title,
wp.scope,
wp.scope_id,
wv.pagehtml AS description,
CASE
WHEN wp.path != '' THEN concat(wp.path, '/', wp.pagename)
ELSE wp.pagename
END AS link,
(match(wp.title) against ('spanish') + match(wv.pagetext) against ('spanish')) AS weight,
wv.created AS date,
CASE
WHEN wp.scope='project' THEN 'Project Notes'
ELSE 'Wiki'
END AS section
FROM `jos_wiki_versions` wv
INNER JOIN `jos_wiki_pages` wp
ON wp.id = wv.page_id
LEFT JOIN `jos_xgroups` xg
ON xg.gidNumber = wp.scope_id
AND wp.scope='
group'
WHERE
(wp.access IN (0,1,1,4))
AND
(match(wp.title) against ('spanish') + match(wv.pagetext) against ('spanish')) > 0
AND
wp.state < 2
AND
wv.id = (SELECT MAX(wv2.id)
FROM `jos_wiki_versions` wv2
WHERE wv2.page_id = wv.page_id)
AND (xg.gidNumber IS NULL OR (xg.plugins LIKE '%wiki=anyone%'))
ORDER BY (match(wp.title) against ('spanish') + match(wv.pagetext) against ('spanish')) DESCSELECT
wli.subject AS title,
wli.about AS description,
concat('index.php?option=com_wishlist&category=', wl.category, '&rid=', wl.referenceid, '&task=wish&wishid=', wli.id) AS link,
match(wli.subject, wli.about) against('collaboration') AS weight,
wli.proposed AS date,
concat(wl.title) AS section,
CASE
WHEN wli.anonymous THEN NULL
ELSE (SELECT name
FROM `jos_users` ju
WHERE ju.id = wli.proposed_by)
END AS contributors,
CASE
WHEN wli.anonymous THEN NULL
ELSE wli.proposed_by
END AS contributor_ids
FROM `jos_wishlist_item` wli
INNER JOIN `jos_wishlist` wl
ON wl.id = wli.wishlist
AND wl.public = 1
WHERE
NOT wli.private
AND match(wli.subject, wli.about) against('spanish') > 0
AND wli.status != 2
ORDER BY match(wli.subject, wli.about) against('spanish') DESCSELECT
c.id,
c.title,
c.blurb AS description,
concat('index.php?option=com_courses&gid=', c.alias) AS link,
(match(c.alias, c.title, c.blurb) against ('spanish')) AS weight,
'Course' AS section,
c.created AS date
FROM jos_courses c
INNER JOIN jos_users u
ON u.id = c.created_by
WHERE
state = 1
AND
(match(c.alias, c.title, c.blurb) against ('spanish')) > 0SELECT
p.id,
v.publication_id,
v.title,
v.description,
concat('index.php?option=com_publications&id=', coalesce(
case when p.alias = '' then null else p.alias end, p.id)) AS link,
match(v.title, v.description, v.abstract) against ('spanish') AS weight,
v.published_up AS date,
c.alias AS section,
(SELECT group_concat(a.name
order by a.ordering separator '\n')
FROM jos_publication_authors a
WHERE a.publication_version_id = v.id
AND a.status=1)
AS contributors,
(SELECT group_concat(a.user_id
order by a.ordering separator '\n')
FROM jos_publication_authors a
WHERE a.publication_version_id = v.id
AND a.status=1)
AS contributor_ids,
NULL AS parents
FROM jos_publication_versions v
INNER JOIN jos_publications p
ON p.id = v.publication_id
LEFT JOIN jos_publication_categories c
ON c.id = p.category
WHERE
v.state = 1
AND (p.access IN (0, 1,1,4))
AND (v.published_up
AND NOW() > v.published_up)
AND (NOT v.published_down OR NOW() < v.published_down)
AND (match(v.title, v.description, v.abstract) against ('spanish') > 0)UNION
SELECT
p.id,
v.publication_id,
v.title,
v.description,
concat('index.php?option=com_publications&id=', coalesce(
case when p.alias = '' then null else p.alias end, p.id)) AS link,
1 AS weight,
v.published_up AS date,
c.alias AS section,
(SELECT group_concat(a.name
order by a.ordering separator '\n')
FROM jos_publication_authors a
WHERE a.publication_version_id = v.id
AND a.status=1)
AS contributors,
(SELECT group_concat(a.user_id
order by a.ordering separator '\n')
FROM jos_publication_authors a
WHERE a.publication_version_id = v.id
AND a.status=1)
AS contributor_ids,
NULL AS parents
FROM jos_publication_authors a
INNER JOIN jos_publication_versions v
ON v.id = a.publication_version_id
INNER JOIN jos_publications p
ON p.id = v.publication_id
LEFT JOIN jos_publication_categories c
ON c.id = p.category
WHERE
v.state = 1
AND (p.access IN (0, 1,1,4))
AND (v.published_up
AND NOW() > v.published_up)
AND (NOT v.published_down OR NOW() < v.published_down)
AND a.status = 1
AND a.name LIKE '%spanish%'SELECT
c.title AS title,
c.abstract AS description,
concat('/citations/view/', c.id) AS link,
match(c.title, c.isbn, c.doi, c.abstract, c.author, c.publisher) AGAINST ('spanish') AS weight
FROM jos_citations c
WHERE
c.published=1
AND match(c.title, c.isbn, c.doi, c.abstract, c.author, c.publisher) AGAINST ('spanish') > 0
ORDER BY match(c.title, c.isbn, c.doi, c.abstract, c.author, c.publisher) AGAINST ('spanish') DESCSELECT
c.id as id,
c.title as title,
c.abstract as description,
concat('/citations/view/', c.id) AS link
FROM
jos_citations c,
jos_tags as tag,
jos_tags_object as tago
WHERE
tago.objectid=c.id
AND
tago.tagid=tag.id
AND
tago.tbl='citations'
AND
tago.label=''
AND (tag.tag='spanish')
AND c.id NOT IN(SELECT c.id as id
FROM jos_citations c
WHERE c.published=1
AND match(c.title, c.isbn, c.doi, c.abstract, c.author, c.publisher) AGAINST ('spanish') > 0
ORDER BY match(c.title, c.isbn, c.doi, c.abstract, c.author, c.publisher) AGAINST ('spanish') DESC)SELECT
c.title,
concat(coalesce(c.introtext, ''), coalesce(c.`fulltext`, '')) AS description,
CASE
WHEN ca.path != '' OR c.alias != '' THEN
concat(
CASE WHEN ca.path != '' THEN concat('/', ca.path) ELSE '' END,
CASE WHEN c.alias != '' THEN concat('/', c.alias) ELSE '' END
)
ELSE concat('index.php?option=com_content&view=article&id=', c.id)
END AS link,
match(c.title, c.introtext, c.`fulltext`) against ('spanish') AS weight,
publish_up AS date,
ca.title AS section,
(SELECT group_concat(u1.name separator '\n')
FROM `jos_author_assoc` anames
INNER JOIN `jos_xprofiles` u1
ON u1.uidNumber = anames.authorid
WHERE subtable = 'content'
AND subid = c.id
ORDER BY anames.ordering) AS contributors,
(SELECT group_concat(ids.authorid separator '\n')
FROM `jos_author_assoc` ids
WHERE subtable = 'content'
AND subid = c.id
ORDER BY ids.ordering) AS contributor_ids
FROM `jos_content` c
LEFT JOIN `jos_categories` ca
ON ca.id = c.catid
WHERE
state = 1
AND
(publish_up
AND UTC_TIMESTAMP() > publish_up)
AND (NOT publish_down OR UTC_TIMESTAMP() < publish_down)
AND match(c.title, c.introtext, c.`fulltext`) against ('spanish') > 0
AND (c.access IN (1,1,4))
ORDER BY match(c.title, c.introtext, c.`fulltext`) against ('spanish') DESCSELECT
g.description AS title,
coalesce(g.public_desc, '') AS description,
concat('index.php?option=com_groups&cn=', g.cn) AS link,
match(g.cn, g.description, g.public_desc) AGAINST ('spanish') AS weight,
NULL AS date,
'Groups' AS section
FROM `jos_xgroups` g
WHERE
(g.type = 1 OR g.type = 3)
AND g.published=1
AND g.approved=1
AND g.discoverability = 0
AND match(g.cn, g.description, g.public_desc) AGAINST ('spanish') > 0
ORDER BY match(g.cn, g.description, g.public_desc) AGAINST ('spanish') DESCSELECT
f.title,
coalesce(f.`fulltxt`, '') AS description,
concat('index.php?option=com_kb&category=', coalesce(concat(c.alias, '/'), ''), f.alias) AS link,
match(f.title, f.`fulltxt`) against ('spanish') AS weight,
created AS date,
c.path AS section
FROM `jos_kb_articles` f
LEFT JOIN `jos_categories` c
ON c.id = f.category
WHERE
f.state = 1
AND c.published = 1
AND
match(f.title, f.`fulltxt`) against ('spanish') > 0
AND (f.access IN (0,1,1,4))
ORDER BY match(f.title, f.`fulltxt`) against ('spanish') DESCSELECT
u.id,
u.name AS title,
coalesce(p.profile_key, '') AS description,
concat('index.php?option=com_members&id=',
CASE WHEN u.id > 0 THEN u.id ELSE concat('n', abs(u.id)) END) AS link,
(u.name LIKE 'spanish' OR p.profile_value LIKE 'spanish') AS weight,
NULL AS date,
'Members' AS section,
NULL AS img_href
FROM `jos_users` AS u
LEFT JOIN `jos_user_profiles` AS p
ON u.id = p.user_id
AND p.profile_key = 'bio'
WHERE
u.block=0
AND u.approved>0
AND
u.access IN (1,1,4)
AND (u.name LIKE 'spanish' OR p.profile_value LIKE 'spanish') > 0
ORDER BY (u.name LIKE 'spanish' OR p.profile_value LIKE 'spanish') DESCSELECT
title, description, link, match(s.title, s.description) against ('spanish') as weight
FROM
`jos_ysearch_site_map` s
WHERE match(s.title, s.description) against ('spanish') > 0SELECT
i.title,
CASE WHEN (p.description!=''
AND p.description IS NOT NULL) THEN p.description ELSE i.description END AS description,
concat('index.php?option=com_collections&controller=posts&post=', p.id) AS `link`,
(match(p.description) AGAINST ('spanish') + match(i.title, i.description) AGAINST ('spanish')) AS `weight`,
p.created AS `date`,
'Collections' AS `section`,
u.name AS contributors,
p.created_by AS contributor_ids
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_users` u
ON u.id = p.created_by
WHERE
i.state=1
AND i.access=0
AND c.state=1
AND c.access=0
AND (match(p.description) AGAINST ('spanish') + match(i.title, i.description) AGAINST ('spanish')) > 0
ORDER BY (match(p.description) AGAINST ('spanish') + match(i.title, i.description) AGAINST ('spanish')) DESCSELECT
p.title,
p.about AS `description`,
concat('index.php?option=com_projects&alias=', p.alias) AS `link`,
match(p.alias, p.title, p.about) AGAINST ('spanish') AS `weight`,
NULL AS `date`,
'Projects' AS `section`
FROM `jos_projects` AS p JOIN jos_xgroups_members AS m
ON m.gidNumber=p.owned_by_group
AND m.uidNumber=0
WHERE
p.state!=2
AND (p.private=0 OR p.access IN (1,1,4))
AND match(p.alias, p.title, p.about) AGAINST ('spanish') > 0
ORDER BY match(p.alias, p.title, p.about) AGAINST ('spanish') DESCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_users'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` <= '2021-09-23 23:53:47'
)
AND (`m`.`publish_down` IS NULL
OR `m`.`publish_down` >= '2021-09-23 23:53:47'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '0'
OR `mm`.`menuid` <= '0'
)
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_whatsnew'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_newsletter'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_support'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_kb'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_forum'UPDATE `jos_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1632441226;s:18:\"session.timer.last\";i:1632441226;s:17:\"session.timer.now\";i:1632441226;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\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"c818e8d3136e018b8f5bad505a026a70\";s:12:\"tracker.ssid\";s:32:\"c818e8d3136e018b8f5bad505a026a70\";s:12:\"tracker.rsid\";s:32:\"c818e8d3136e018b8f5bad505a026a70\";}',`time` = '1632441227',`ip` = '3.235.175.15'
WHERE `session_id` = 'c818e8d3136e018b8f5bad505a026a70'
onAfterInitialise — 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 → /core/plugins/system/password/password.php:21onSearchExpandTerms — Method — plgSearchSuffixes::onSearchExpandTerms → /core/plugins/search/suffixes/suffixes.php:26onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:22onAfterDispatch — 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