Find information on common issues.
Ask questions and find answers from other users.
Suggest a new site feature or improvement.
Check on status of your tickets.
REDIRECT_SCRIPT_URL
=>
/tags/unitedkingdomrubberusbflashdrivemarket
, REDIRECT_SCRIPT_URI
=>
https://itmig.curie.fr/tags/unitedkingdomrubberusbflashdrivemarket
, REDIRECT_HTTPS
=>
on
, REDIRECT_SSL_TLS_SNI
=>
itmig.curie.fr
, REDIRECT_STATUS
=>
200
, SCRIPT_URL
=>
/tags/unitedkingdomrubberusbflashdrivemarket
, SCRIPT_URI
=>
https://itmig.curie.fr/tags/unitedkingdomrubberusbflashdrivemarket
, HTTPS
=>
on
, SSL_TLS_SNI
=>
itmig.curie.fr
, HTTP_ACCEPT
=>
*/*
, HTTP_USER_AGENT
=>
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
, HTTP_COOKIE
=>
81f30cf708470b974874c8a96a6bcdb2=804dc64cac0c88ac8ac2706b755517ec; d482552ea4a74f85af0bb3d73890dabc=+5+E+45E43105E+E+2444543+7406F5D+11B+37E+B4A+3+05F41134B514059+4+951135F765817+3+B5C1243+B5612+F16+3+B+2+A1B+1+851+7+5+E+05156+65457+95C59+05C585B54+7+05450+7+150+C+9+7555A1B+3165952+2164044+C+016+A17+25056+31A5E+0+4+651+6+0+6585B+053+1+159+65B+75B+6+5+753+6+3+451+D52535C5B44+B4358+6+A16164A515412+24A+256515C1A+C+2+3+1+7+2+5+759+0545A+05E51535A5353+652+9+E52+7+C+C+D5454+35B16+94A
, HTTP_ACCEPT_ENCODING
=>
gzip, br, zstd, deflate
, HTTP_HOST
=>
itmig.curie.fr
, PATH
=>
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
, SERVER_SIGNATURE
=>
, SERVER_SOFTWARE
=>
Apache/2.4.10 (Debian)
, SERVER_NAME
=>
itmig.curie.fr
, SERVER_ADDR
=>
192.168.25.26
, SERVER_PORT
=>
443
, REMOTE_ADDR
=>
3.144.29.148
, DOCUMENT_ROOT
=>
/var/www/itmig
, REQUEST_SCHEME
=>
https
, CONTEXT_PREFIX
=>
, CONTEXT_DOCUMENT_ROOT
=>
/var/www/itmig
, SERVER_ADMIN
=>
[no address given]
, SCRIPT_FILENAME
=>
/var/www/itmig/index.php
, REMOTE_PORT
=>
56823
, REDIRECT_URL
=>
/tags/unitedkingdomrubberusbflashdrivemarket
, GATEWAY_INTERFACE
=>
CGI/1.1
, SERVER_PROTOCOL
=>
HTTP/1.1
, REQUEST_METHOD
=>
GET
, QUERY_STRING
=>
, REQUEST_URI
=>
/tags/unitedkingdomrubberusbflashdrivemarket
, SCRIPT_NAME
=>
/index.php
, PHP_SELF
=>
/index.php
, REQUEST_TIME_FLOAT
=>
1717839187.569
, REQUEST_TIME
=>
1717839187
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 804dc64cac0c88ac8ac2706b755517ec
tracker.ssid ⇒ 804dc64cac0c88ac8ac2706b755517ec
tracker.rsid ⇒ 804dc64cac0c88ac8ac2706b755517ec
session.token ⇒ d0708663664964f41b34a4fef0a822d1
site 0.011 seconds (+0.011); 3.50 MB (+3.500) - afterInitialise
site 0.019 seconds (+0.008); 4.25 MB (+0.750) - afterRoute
site 0.081 seconds (+0.062); 7.75 MB (+3.500) - afterDispatch
site 0.086 seconds (+0.005); 8.00 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
site 0.087 seconds (+0.001); 8.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
site 0.087 seconds (+0.000); 8.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
site 0.089 seconds (+0.002); 8.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
site 0.089 seconds (+0.000); 8.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
site 0.094 seconds (+0.005); 8.00 MB (0.000) - afterRenderModule mod_menu (Main Menu)
site 0.094 seconds (+0.000); 8.00 MB (0.000) - beforeRenderModule mod_search (Search)
site 0.095 seconds (+0.001); 8.25 MB (+0.250) - afterRenderModule mod_search (Search)
site 0.095 seconds (+0.000); 8.25 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
site 0.099 seconds (+0.004); 8.25 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
site 0.101 seconds (+0.002); 8.25 MB (0.000) - onAfterRender
site 0.102 seconds (+0.002); 8.25 MB (0.000) - sessionStore
SELECT data
FROM `jos_session`
WHERE `session_id` = '804dc64cac0c88ac8ac2706b755517ec'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_languages'
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` ASC
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` > '0'
AND `m`.`client_id` = '0'
ORDER BY `m`.`lft` ASC
SELECT 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` = '0'
AND `jos_extensions`.`enabled` = '1'
AND `jos_extensions`.`type` = 'template'
AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
ORDER BY `home` DESC
SELECT *
FROM `jos_tags`
WHERE `jos_tags`.`tag` = 'unitedkingdomrubberusbflashdrivemarket'
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_publications'
SELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`category` = '27'
ORDER BY `type` ASC
( 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 )
SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_resources` AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , `jos_tags_object` AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (34982)
AND r.type=9
GROUP BY r.id
HAVING uniques=1 ) AS f
SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_resources` AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , `jos_tags_object` AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (34982)
AND r.type=3
GROUP BY r.id
HAVING uniques=1 ) AS f
SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_resources` AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , `jos_tags_object` AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (34982)
AND r.type=1
GROUP BY r.id
HAVING uniques=1 ) AS f
SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_resources` AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , `jos_tags_object` AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (34982)
AND r.type=31
GROUP BY r.id
HAVING uniques=1 ) AS f
SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_resources` AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , `jos_tags_object` AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (34982)
AND r.type=39
GROUP BY r.id
HAVING uniques=1 ) AS f
SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_resources` AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , `jos_tags_object` AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (34982)
AND r.type=7
GROUP BY r.id
HAVING uniques=1 ) AS f
SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_resources` AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , `jos_tags_object` AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (34982)
AND r.type=64
GROUP BY r.id
HAVING uniques=1 ) AS f
SELECT count(f.id)
FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_resources` AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , `jos_tags_object` AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (34982)
AND r.type=2
GROUP BY r.id
HAVING uniques=1 ) AS f
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 (34982)
GROUP BY page_id
HAVING uniques=1 ) AS f
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 (34982)
GROUP BY a.id, b.profile_value
HAVING uniques=1) AS f
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 (34982)
GROUP BY e.id
HAVING uniques=1) AS f
SELECT a.rules
FROM `jos_assets` AS `a`
WHERE `a`.`id` = '1'
GROUP BY a.id, a.rules, a.lft
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_groups'
GROUP BY b.id, b.rules, b.lft
ORDER BY `b`.`lft` ASC
SELECT COUNT(f.gidNumber)
FROM (SELECT a.gidNumber, COUNT(DISTINCT t.tagid) AS uniques
FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
ON m.gidNumber=a.gidNumber
AND m.uidNumber=0
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 (34982)
GROUP BY a.gidNumber
HAVING uniques=1) AS f
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 (34982)
AND a.state!=2
GROUP BY a.id
HAVING uniques=1) AS f
SELECT DISTINCT gidNumber
FROM `jos_xgroups_members`
WHERE uidNumber=0
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
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 (34982)
WHERE e.state=1
AND e.parent=0
AND e.scope_id IN (0)
GROUP BY e.id
HAVING uniques=1) AS f
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 (34982)
AND e.state=1
AND (e.publish_up IS NULL OR e.publish_up <= '2024-06-08 09:33:07')
AND (e.publish_down IS NULL OR e.publish_down >= '2024-06-08 09:33:07')
GROUP BY e.id
HAVING uniques=1) AS f
SELECT COUNT(f.id)
FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
FROM `jos_citations` AS e, `jos_tags_object` AS t
WHERE t.objectid=e.id
AND t.tbl='citations'
AND t.tagid IN (34982)
AND e.published=1
AND e.id!=''
GROUP BY e.id
HAVING uniques=1) AS f
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 (34982)
WHERE e.state=1
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1) AS f
SHOW FULL COLUMNS
FROM `jos_publication_categories`
SELECT *
FROM jos_publication_categories as C
WHERE C.state=1
ORDER BY C.name ASC
SHOW 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 )
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=r.id
AND t.tbl='publications'
AND t.tagid IN (34982)
AND r.category=1
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS f
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=r.id
AND t.tbl='publications'
AND t.tagid IN (34982)
AND r.category=7
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1 ) AS f
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 (34982)
AND i.access=0
AND c.access=0
GROUP BY p.id
HAVING uniques=1) AS f
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 (34982)
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1) AS f
(SELECT DISTINCT r.id, r.title, r.alias, r.introtext AS itext, r.fulltxt AS ftext, r.published AS state, r.created, r.created_by, r.modified, r.publish_up, r.publish_down,
CONCAT('index.php?option=com_resources&id=', r.id) AS href, 'resources' AS section , COUNT(DISTINCT t.tagid) AS uniques , r.params, r.rating AS rcount, r.type AS data1, r.access AS data2, r.ranking data3
FROM `jos_resources` AS r
LEFT JOIN jos_resource_types AS rt
ON r.type=rt.id , `jos_tags_object` AS t
WHERE r.standalone=1
AND r.published=1
AND r.access<4
AND t.objectid=r.id
AND t.tbl='resources'
AND t.tagid IN (34982)
GROUP BY r.id
HAVING uniques=1
ORDER BY publish_up DESC) UNION (SELECT v.page_id AS id, w.title, w.pagename AS alias, v.pagetext AS itext, v.pagehtml AS ftext, w.state, v.created, v.created_by,
v.created AS modified, v.created AS publish_up, NULL AS publish_down,
CASE
WHEN w.scope = 'project' THEN concat('index.php?option=com_projects&alias=', xp.alias, '&active=notes&pagename=', w.path, '/', w.pagename)
WHEN w.scope = '
group' THEN CONCAT('index.php?option=com_groups&cn=', xg.cn, '&active=wiki&pagename=', w.path, '/', w.pagename)
ELSE CONCAT('index.php?option=com_wiki&pagename=', w.pagename)
END AS href,
'wiki' AS section , COUNT(DISTINCT t.tagid) AS uniques , w.params, NULL AS rcount, w.scope AS data1, NULL AS data2, NULL AS data3
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 (34982)
GROUP BY page_id
HAVING uniques=1
ORDER BY created DESC) UNION (SELECT a.id, a.name AS title, a.username as alias, NULL AS itext, b.profile_value AS ftext, a.activation AS state, a.registerDate AS created,
a.id AS created_by, NULL AS modified, a.registerDate AS publish_up, NULL AS publish_down,
CONCAT('index.php?option=com_members&id=', a.id) AS href, 'members' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.params, NULL AS rcount,
NULL AS data1, NULL AS data2, NULL AS data3
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 (34982)
GROUP BY a.id, b.profile_value
HAVING uniques=1) UNION (SELECT e.id, e.title, NULL AS alias, NULL AS itext, e.content AS ftext, e.state, e.created, e.created_by,
NULL AS modified, e.publish_up, e.publish_down, CONCAT('index.php?option=com_events&task=details&id=', e.id) AS href,
'events' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, NULL AS rcount, NULL AS data1,
NULL AS data2, NULL AS data3
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 (34982)
GROUP BY e.id
HAVING uniques=1) UNION (SELECT a.gidNumber AS id, a.description AS title, a.cn AS alias, NULL AS itext, a.public_desc AS ftext, a.type AS state, a.created,
a.created_by, NULL AS modified, NULL AS publish_up,
NULL AS publish_down, CONCAT('index.php?option=com_groups&cn=', a.cn) AS href, 'groups' AS section, COUNT(DISTINCT t.tagid) AS uniques,
a.params, NULL AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
ON m.gidNumber=a.gidNumber
AND m.uidNumber=0
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 (34982)
GROUP BY a.gidNumber
HAVING uniques=1) UNION (SELECT a.id, a.subject AS title, NULL AS alias, NULL AS itext, a.question AS ftext, a.state, a.created, a.created_by,
NULL AS modified, a.created AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_answers&task=question&id=', a.id) AS href,
'answers' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.anonymous AS params,
(SELECT COUNT(*)
FROM `jos_answers_responses` AS r
WHERE r.question_id=a.id) AS rcount,
NULL AS data1, NULL AS data2, NULL AS data3
FROM `jos_answers_questions` AS a, `jos_tags_object` AS t
WHERE a.id=t.objectid
AND t.tbl='answers'
AND t.tagid IN (34982)
AND a.state!=2
GROUP BY a.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.id AS alias, e.comment AS itext, e.comment AS ftext, e.state, e.created, e.created_by, e.modified, e.created AS publish_up, NULL AS publish_down,
(
CASE WHEN e.scope_id > 0
AND e.scope='
group' THEN
concat('/groups/', g.cn, concat('/forum/', coalesce(concat(s.alias, '/', coalesce(concat(c.alias, '/'), ''))),
CASE WHEN e.parent > 0 THEN e.parent ELSE e.id END))
ELSE
concat('/forum/', coalesce(concat(s.alias, '/', coalesce(concat(c.alias, '/'), ''))),
CASE WHEN e.parent > 0 THEN e.parent ELSE e.id END)
END) AS href,
'forum' AS section, COUNT(DISTINCT t.tagid) AS uniques, CONCAT(e.thread, ':', e.parent) AS params, e.scope AS rcount, c.alias AS data1, s.alias AS data2, e.scope_id AS data3
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 (34982)
WHERE e.state=1
AND e.parent=0
AND e.scope_id IN (0)
GROUP BY e.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, NULL AS itext, e.content AS ftext, e.state, e.created, e.created_by,
NULL AS modified, e.publish_up, e.publish_down, CONCAT('index.php?option=com_blog&task=view&id=', e.id) AS href,
'blogs' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, e.scope AS rcount, u.name AS data1,
e.scope_id AS data2, NULL AS data3
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 (34982)
AND e.state=1
AND (e.publish_up IS NULL OR e.publish_up <= '2024-06-08 09:33:07')
AND (e.publish_down IS NULL OR e.publish_down >= '2024-06-08 09:33:07')
GROUP BY e.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.author, e.booktitle, e.doi, e.published, e.created, e.year, e.month, e.isbn, e.journal, e.url as href,
'citations' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.volume, e.number, e.type, e.pages, e.publisher
FROM `jos_citations` AS e, `jos_tags_object` AS t
WHERE t.objectid=e.id
AND t.tbl='citations'
AND t.tagid IN (34982)
AND e.published=1
AND e.id!=''
GROUP BY e.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, e.fulltxt AS itext, e.fulltxt AS ftext, e.state, e.created, e.created_by, e.modified, e.created AS publish_up,
NULL AS publish_down, CONCAT('index.php?option=com_kb&category=&alias=', e.alias) AS href, 'kb' AS section, COUNT(DISTINCT t.tagid) AS uniques,
NULL AS params, e.helpful AS rcount, cc.alias AS data1, NULL AS data2, NULL AS data3
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 (34982)
WHERE e.state=1
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1) UNION (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=r.id
AND t.tbl='publications'
AND t.tagid IN (34982)
GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
HAVING uniques=1
ORDER BY publish_up DESC) UNION (SELECT p.id, i.title, c.alias, NULL AS itext,
CASE WHEN (p.description!=''
AND p.description IS NOT NULL) THEN p.description ELSE i.description END AS ftext,
i.state,
p.created,
p.created_by,
NULL AS modified,
p.created AS publish_up,
NULL AS publish_down,
concat('index.php?option=com_collections&controller=posts&post=', p.id) AS href,
'collections' AS section,
COUNT(DISTINCT t.tagid) AS uniques,
c.object_type AS params,
c.object_id AS rcount,
i.type AS data1,
i.object_id AS data2,
NULL AS data3
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 (34982)
AND i.access=0
AND c.access=0
GROUP BY p.id
HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, e.blurb AS itext, e.description AS ftext, e.state, e.created, e.created_by,
NULL AS modified, NULL AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_courses&gid=', e.alias) AS href,
'courses' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, 0 AS rcount, u.name AS data1,
NULL AS data2, NULL AS data3
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 (34982)
AND e.access IN (1,1,4)
GROUP BY e.id
HAVING uniques=1)
ORDER BY publish_up DESC, title
LIMIT 0,20
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_blog'
SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = '2317'
SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = '2317'
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 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` <= '2024-06-08 09:33:07'
)
AND (`m`.`publish_down` IS NULL
OR `m`.`publish_down` >= '2024-06-08 09:33:07'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '89'
OR `mm`.`menuid` <= '0'
)
ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
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_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_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_kb'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wishlist'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_media'
SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_answers'
UPDATE `jos_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1717839169;s:18:\"session.timer.last\";i:1717839169;s:17:\"session.timer.now\";i:1717839187;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}s:5:\"Entry\";O:8:\"stdClass\":2:{s:5:\"start\";d:0;s:5:\"
limit\";i:20;}}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:\"804dc64cac0c88ac8ac2706b755517ec\";s:12:\"tracker.ssid\";s:32:\"804dc64cac0c88ac8ac2706b755517ec\";s:12:\"tracker.rsid\";s:32:\"804dc64cac0c88ac8ac2706b755517ec\";s:13:\"session.token\";s:32:\"d0708663664964f41b34a4fef0a822d1\";}',`time` = '1717839187',`ip` = '3.144.29.148'
WHERE `session_id` = '804dc64cac0c88ac8ac2706b755517ec'
onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:45
onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:44
onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:46
onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:46
onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:138
onAfterInitialise — Method — plgSystemReferrerpolicy::onAfterInitialise → /core/plugins/system/referrerpolicy/referrerpolicy.php:21
onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:46
onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:46
onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:46
onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:46
onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:46
onAfterRoute — Method — plgSystemPassword::onAfterRoute → /core/plugins/system/password/password.php:46
onTagView — Method — plgTagsResources::onTagView → /core/plugins/tags/resources/resources.php:72
onTagView — Method — plgTagsWiki::onTagView → /core/plugins/tags/wiki/wiki.php:58
onTagView — Method — plgTagsMembers::onTagView → /core/plugins/tags/members/members.php:58
onTagView — Method — plgTagsEvents::onTagView → /core/plugins/tags/events/events.php:58
onTagView — Method — plgTagsGroups::onTagView → /core/plugins/tags/groups/groups.php:58
onTagView — Method — plgTagsAnswers::onTagView → /core/plugins/tags/answers/answers.php:58
onTagView — Method — plgTagsForum::onTagView → /core/plugins/tags/forum/forum.php:73
onTagView — Method — plgTagsBlogs::onTagView → /core/plugins/tags/blogs/blogs.php:58
onTagView — Method — plgTagsCitations::onTagView → /core/plugins/tags/citations/citations.php:58
onTagView — Method — plgTagsKb::onTagView → /core/plugins/tags/kb/kb.php:58
onTagView — Method — plgTagsPublications::onTagView → /core/plugins/tags/publications/publications.php:73
onTagView — Method — plgTagsCollections::onTagView → /core/plugins/tags/collections/collections.php:58
onTagView — Method — plgTagsCourses::onTagView → /core/plugins/tags/courses/courses.php:58
onGetMultiEntry — Method — plgHubzeroAutocompleter::onGetMultiEntry → /core/plugins/hubzero/autocompleter/autocompleter.php:164
onContentPrepare — Method — plgContentLoadmodule::onContentPrepare → /core/plugins/content/loadmodule/loadmodule.php:60
onContentPrepare — Method — plgContentEmailcloak::onContentPrepare → /core/plugins/content/emailcloak/emailcloak.php:49
onContentPrepare — Method — plgContentPagebreak::onContentPrepare → /core/plugins/content/pagebreak/pagebreak.php:59
onContentPrepare — Method — plgContentXhubtags::onContentPrepare → /core/plugins/content/xhubtags/xhubtags.php:50
onContentPrepare — Method — plgContentFormatwiki::onContentPrepare → /core/plugins/content/formatwiki/formatwiki.php:88
onContentPrepare — Method — plgContentFormathtml::onContentPrepare → /core/plugins/content/formathtml/formathtml.php:130
onContentPrepare — Method — plgContentExternalhref::onContentPrepare → /core/plugins/content/externalhref/externalhref.php:65
onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:47
onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:85
onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:49
onDisplay — Method — plgCaptchaImage::onDisplay → /core/plugins/captcha/image/image.php:80
onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:45