Support

Support Options

Report a problem

About you
This is a randomly generated image of letters and numbers. Letters not clear? Click to renew CAPTCHA.
About the problem

Dubai Fixers

Usage

Usage is calculated on the last day of every month. For more information on usage data, visit the Usage Overview page.

Table 1: Overview
Item Value
Contributions: 0
Rank by Contributions: -
First Contribution:
Last Contribution:
Citations on Contributions: -
Table 2: Simulation Tool Usage
# Tool Name Users served in last 12 months Simulation Runs in last 12 months Total users served Total Simulation Runs Citations Published On
No data found.
Table 3: "and more" Usage
# Resource Title Users served in last 12 months Total users served Citations Published On
No data found.

* Total only includes versions of the tools this author contributed to.

Debug Console

Close13 MBRequestSessionTimelineDatabase88Events59
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( 81f30cf708470b974874c8a96a6bcdb2 => b6656c23d7095148494f4760cf960643, d482552ea4a74f85... Array(
81f30cf708470b974874c8a96a6bcdb2 => b6656c23d7095148494f4760cf960643,
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B5B E5356505B 6 1535254 D 455 C5B50 0 C 0 4 754 253525C F 8 6 4 A1B 3165952 2164044 C 016 A17 25056 31A 4 6 657 453 6565D F 0 9 C 8 C5D575F C52 6 0535457575D E5352 D B44 B4358 6 A16164A515412 24A 256515C1A56 4 1505257 3575C5454 0 D57 4 856 B 45251 E E 0535F 0 E555552 B16 94A
)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /members/8625/usage, REDIRECT_SCRIPT_URI => https://itmig.curie... Array(
REDIRECT_SCRIPT_URL => /members/8625/usage,
REDIRECT_SCRIPT_URI => https://itmig.curie.fr/members/8625/usage,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => itmig.curie.fr,
REDIRECT_STATUS => 200,
SCRIPT_URL => /members/8625/usage,
SCRIPT_URI => https://itmig.curie.fr/members/8625/usage,
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=b6656c23d7095148494f4760cf960643; d482552ea4a74f85af0bb3d73890dabc=+5+E+45E43105E+E+2444543+7406F5D+11B+37E+B4A+3+05F41134B514059+4+951135F765817+3+B5C1243+B5612+F16+3+B+2+A1B5B+E5356505B+6+1535254+D+455+C5B50+0+C+0+4+754+253525C+F+8+6+4+A1B+3165952+2164044+C+016+A17+25056+31A+4+6+657+453+6565D+F+0+9+C+8+C5D575F+C52+6+0535457575D+E5352+D+B44+B4358+6+A16164A515412+24A+256515C1A56+4+1505257+3575C5454+0+D57+4+856+B+45251+E+E+0535F+0+E555552+B16+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 => 18.216.115.44,
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 => 22934,
REDIRECT_URL => /members/8625/usage,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/8625/usage,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1716078630.596,
REQUEST_TIME => 1716078630
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid b6656c23d7095148494f4760cf960643
tracker.ssid b6656c23d7095148494f4760cf960643
tracker.rsid b6656c23d7095148494f4760cf960643
session.token da2c3f5ad754007031b58ab1ca5e0057
securiy_code0 kdx6p
  • site 0.012 seconds (+0.012); 3.50 MB (+3.500) - afterInitialise
  • site 0.020 seconds (+0.008); 4.25 MB (+0.750) - afterRoute
  • site 0.097 seconds (+0.076); 12.25 MB (+8.000) - afterDispatch
  • site 0.103 seconds (+0.006); 12.25 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.104 seconds (+0.001); 12.50 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.104 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.107 seconds (+0.003); 12.50 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.107 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.113 seconds (+0.005); 12.50 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.113 seconds (+0.000); 12.50 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.114 seconds (+0.001); 12.75 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.114 seconds (+0.000); 12.75 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.120 seconds (+0.005); 12.75 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.122 seconds (+0.002); 12.75 MB (0.000) - onAfterRender
  • site 0.124 seconds (+0.002); 12.75 MB (0.000) - sessionStore
13 MB

88 Queries Logged: 0.016313791275024 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'b6656c23d7095148494f4760cf960643'
  2. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  3. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  4. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  5. SELECT *
      FROM `jos_viewlevels`
  6. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  7. 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
  8. 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
  9. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  10. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '8625'
  11. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jobs'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  16. SHOW FULL COLUMNS
      FROM `jos_jobs_employers`
  17. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  18. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_members.component'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  19. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  20. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  21. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2024-05-19 00:30:30'
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  23. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '8625'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2024-05-19 00:30:30' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2024-05-19 00:30:30' )
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  25. SHOW FULL COLUMNS
      FROM `jos_collections`
  26. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.object_id='8625'
      AND b.object_type='member'
  27. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='8625'
      AND b.object_type='member'
  28. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  29. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      LEFT JOIN jos_author_assoc
      ON jos_author_assoc.subid = jos_resources.id
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` IN ('1')
      AND `jos_author_assoc`.`subtable` = 'resources'
      AND `jos_author_assoc`.`authorid` = '8625'
      AND `jos_author_assoc`.`role` != 'submitter'
      AND `jos_resources`.`access` IN ('0','3')
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  31. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`created_by` = '8625'
      AND `jos_wiki_versions`.`approved` = '1'
      GROUP BY page_id,id
  32. SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`state` = '1'
      AND `jos_wiki_pages`.`scope` = 'site'
      AND `jos_wiki_pages`.`id` IN ('')
  33. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  34. SHOW FULL COLUMNS
      FROM `jos_courses`
  35. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE m.user_id=8625
      AND m.student=0
      AND r.alias='instructor'
      AND c.state=1
  36. SHOW FULL COLUMNS
      FROM `jos_publications`
  37. SELECT *
      FROM `jos_publication_categories`
      WHERE `jos_publication_categories`.`state` = '1'
      ORDER BY `name` ASC
  38. SELECT COUNT(jos_publication_versions.id) AS count
      FROM `jos_publication_versions`
      INNER JOIN jos_publications
      ON jos_publications.id = jos_publication_versions.publication_id
      LEFT JOIN jos_publication_authors
      ON jos_publication_authors.publication_version_id = jos_publication_versions.id
      WHERE `jos_publication_versions`.`state` IN ('1')
      AND `jos_publication_authors`.`user_id` = '8625'
      AND (`jos_publication_authors`.`role` IS NULL OR `jos_publication_authors`.`role` != 'submitter' )
      AND `jos_publication_versions`.`access` IN ('0','3')
  39. SHOW FULL COLUMNS
      FROM `jos_courses_offerings`
  40. SHOW FULL COLUMNS
      FROM `jos_courses_roles`
  41. SELECT r.*, (SELECT COUNT(m.user_id)
      FROM jos_courses_members AS m
      WHERE m.role_id=r.id
      AND m.`offering_id` IN (0,0)) AS total
      FROM jos_courses_roles AS r
      WHERE r.`offering_id` IN (0,0)
  42. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state IN (1, 3)
      AND m.user_id=8625
      AND m.student=0
      AND r.alias='instructor'
  43. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state IN (1, 3)
      AND m.user_id=8625
      AND m.student=0
      AND r.alias='manager'
  44. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state=1
      AND m.user_id=8625
      AND m.student=1
      AND (s.publish_down IS NULL OR s.publish_down='0000-00-00 00:00:00' OR s.publish_down < '2024-05-19 00:30:30')
      AND s.state=1
      AND o.state=1
  45. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'dubiafixers@gmail.com'
  46. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8625 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_members` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8625 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_managers` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8625 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_invitees` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8625 )
  47. SELECT COUNT(jos_xmessage_recipient.id) AS count
      FROM `jos_xmessage_recipient`
      INNER JOIN jos_xmessage
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      LEFT JOIN jos_xmessage_seen
      ON jos_xmessage_seen.mid=jos_xmessage.id
      AND jos_xmessage_seen.uid=8625
      WHERE `jos_xmessage_recipient`.`uid` = '8625'
      AND `jos_xmessage_recipient`.`state` = '0'
  48. SELECT COUNT(jos_xmessage.id) AS count
      FROM `jos_xmessage`
      INNER JOIN jos_xmessage_recipient
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      WHERE `jos_xmessage_recipient`.`uid` = '8625'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=8625)
  49. SHOW TABLES
  50. SELECT *
      FROM `jos_users_points`
      WHERE `jos_users_points`.`uid` = '8625'
  51. SHOW FULL COLUMNS
      FROM `jos_projects`
  52. SELECT count(DISTINCT p.id)
      FROM jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid='8625'
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.owned_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE (o.userid='8625'
      AND o.status!=2
      AND p.state NOT IN (2, 3)
      AND ((p.setup_stage >= '2') OR (o.role = 1
      AND p.owned_by_user='8625')))
      AND p.provisioned = 0
  53. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  54. SELECT p.alias, p.title, o.*
      FROM jos_project_owners AS o
      INNER JOIN `jos_projects` AS p
      ON p.id=o.projectid
      WHERE o.userid=0
      AND o.status=0
      AND o.invited_email='dubiafixers@gmail.com'
  55. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2024-05-19 00:30:30'
  56. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2024-05-19 00:30:30'
  57. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2024-05-19 00:30:30'
  58. SHOW TABLES
  59. SELECT COUNT(DISTINCT aa.subid) as contribs, DATE_FORMAT(MIN(res.publish_up), '%d %b %Y') AS first_contrib, DATE_FORMAT(MAX(res.publish_up), '%d %b %Y') AS last_contrib
      FROM `jos_resources` AS res, `jos_author_assoc` AS aa, `jos_resource_types` AS restypes
      WHERE res.id = aa.subid
      AND res.type = restypes.id
      AND aa.authorid = '8625'
      AND aa.role!='submitter'
      AND res.standalone = 1
      AND res.published = 1
      AND (res.access=0 OR res.access=3)
      AND aa.subtable = 'resources'
  60. SELECT a.id AS aid, COUNT(DISTINCT aa.subid) AS contribs
      FROM `jos_users` a, `jos_resources` res, `jos_author_assoc` aa
      WHERE a.id = aa.authorid
      AND res.id = aa.subid
      AND res.published=1
      AND (res.access=0 OR res.access=3)
      AND aa.subtable = "resources"
      AND res.standalone=1
      GROUP BY aid
      ORDER BY contribs DESC
  61. SELECT tool_users
      FROM `jos_author_stats`
      WHERE authorid = '8625'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  62. SELECT andmore_users
      FROM `jos_author_stats`
      WHERE authorid = '8625'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  63. SELECT COUNT(DISTINCT (c.id))
      FROM `jos_citations` c, `jos_citations_assoc` ca, `jos_author_assoc` aa, `jos_resources` r
      WHERE c.id = ca.cid
      AND r.id = ca.oid
      AND r.id = aa.subid
      AND aa.subtable = 'resources'
      AND ca.tbl = 'resource'
      AND r.published=1
      AND r.standalone=1
      AND aa.authorid = '8625'
  64. SELECT classes
      FROM `jos_metrics_author_cluster`
      WHERE authorid = '8625'
  65. SELECT users
      FROM `jos_metrics_author_cluster`
      WHERE authorid = '8625'
  66. SELECT schools
      FROM `jos_metrics_author_cluster`
      WHERE authorid = '8625'
  67. SELECT DISTINCT r.id, r.type AS type_id, r.title, DATE_FORMAT(r.publish_up, "%d %b %Y") AS publish_up, rt.type
      FROM `jos_resources` AS r
      LEFT JOIN `jos_resource_types` AS rt
      ON r.TYPE=rt.id
      LEFT JOIN `jos_author_assoc` AS aa
      ON aa.subid=r.id
      AND aa.subtable="resources"
      WHERE r.standalone=1
      AND r.published=1
      AND r.type=7
      AND (aa.authorid="8625")
      AND r.access IN (0,3)
      ORDER BY r.publish_up DESC
  68. SELECT tool_users
      FROM `jos_author_stats`
      WHERE authorid = '8625'
      AND period = '12'
      ORDER BY datetime DESC
      LIMIT 1
  69. SELECT tool_users
      FROM `jos_author_stats`
      WHERE authorid = '8625'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  70. SELECT DISTINCT r.id, r.type AS type_id, r.title, DATE_FORMAT(r.publish_up, '%d %b %Y') AS publish_up, rt.type
      FROM `jos_resources` AS r
      LEFT JOIN `jos_resource_types` AS rt
      ON r.TYPE=rt.id
      LEFT JOIN `jos_author_assoc` AS aa
      ON aa.subid=r.id
      AND aa.subtable='resources'
      WHERE r.standalone=1
      AND r.published=1
      AND r.type<>7
      AND aa.authorid='8625'
      AND aa.role!='submitter'
      AND r.access IN (0,3)
      ORDER BY r.publish_up DESC
  71. SELECT andmore_users
      FROM `jos_author_stats`
      WHERE authorid = '8625'
      AND period = '12'
      ORDER BY datetime DESC
      LIMIT 1
  72. SELECT andmore_users
      FROM `jos_author_stats`
      WHERE authorid = '8625'
      AND period = '14'
      ORDER BY datetime DESC
      LIMIT 1
  73. SELECT jos_citations.*,u.username,F.format AS template,CS.sec_cits_cnt AS sec_cnt
      FROM `jos_citations`
      LEFT JOIN jos_users AS u
      ON jos_citations.uid = u.id
      LEFT JOIN jos_citations_secondary AS CS
      ON jos_citations.id = CS.cid
      LEFT JOIN jos_citations_format AS F
      ON jos_citations.format = F.style
      WHERE `jos_citations`.`scope` = 'member'
      AND `jos_citations`.`scope_id` = '8625'
      AND `jos_citations`.`published` IN ('1')
  74. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '8625'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  75. ( 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 (g.type='1' OR g.type='3')
      AND 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 (g.type='1' OR g.type='3')
      AND 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 (g.type='1' OR g.type='3')
      AND 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  76. ( 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8625 ) 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8625 ) 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8625 ) 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 (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=8625 )
  77. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  78. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  79. 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-05-19 00:30:30' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-05-19 00:30:30' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '83' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  80. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  81. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  82. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  83. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  84. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  85. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  86. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  87. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  88. UPDATE `jos_session`
      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:566;s:19:\"session.timer.start\";i:1716078511;s:18:\"session.timer.last\";i:1716078630;s:17:\"session.timer.now\";i:1716078630;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\":2:{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:4:\"Blog\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Comment\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:3:\"asc\";}}}}s: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:\"b6656c23d7095148494f4760cf960643\";s:12:\"tracker.ssid\";s:32:\"b6656c23d7095148494f4760cf960643\";s:12:\"tracker.rsid\";s:32:\"b6656c23d7095148494f4760cf960643\";s:13:\"session.token\";s:32:\"da2c3f5ad754007031b58ab1ca5e0057\";s:13:\"securiy_code0\";s:5:\"kdx6p\";}',`time` = '1716078630',`ip` = '18.216.115.44'
      WHERE `session_id` = 'b6656c23d7095148494f4760cf960643'
  • 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
  • onMembersAreas Method plgMembersDashboard::onMembersAreas /core/plugins/members/dashboard/dashboard.php:87
  • onMembersAreas Method plgMembersProfile::onMembersAreas /core/plugins/members/profile/profile.php:55
  • onMembersAreas Method plgMembersAccount::onMembersAreas /core/plugins/members/account/account.php:59
  • onMembersAreas Method plgMembersBlog::onMembersAreas /core/plugins/members/blog/blog.php:55
  • onMembersAreas Method plgMembersCollections::onMembersAreas /core/plugins/members/collections/collections.php:55
  • onMembersAreas Method plgMembersContributions::onMembersAreas /core/plugins/members/contributions/contributions.php:55
  • onMembersAreas Method plgMembersCourses::onMembersAreas /core/plugins/members/courses/courses.php:55
  • onMembersAreas Method plgMembersGroups::onMembersAreas /core/plugins/members/groups/groups.php:55
  • onMembersAreas Method plgMembersImpact::onMembersAreas /core/plugins/members/impact/impact.php:105
  • onMembersAreas Method plgMembersMessages::onMembersAreas /core/plugins/members/messages/messages.php:55
  • onMembersAreas Method plgMembersPoints::onMembersAreas /core/plugins/members/points/points.php:55
  • onMembersAreas Method plgMembersProjects::onMembersAreas /core/plugins/members/projects/projects.php:71
  • onMembersAreas Method plgMembersResume::onMembersAreas /core/plugins/members/resume/resume.php:85
  • onMembersAreas Method plgMembersUsage::onMembersAreas /core/plugins/members/usage/usage.php:55
  • onMembersAreas Method plgMembersCitations::onMembersAreas /core/plugins/members/citations/citations.php:72
  • onMembersAreas Method plgMembersActivity::onMembersAreas /core/plugins/members/activity/activity.php:54
  • onMembersContributionsAreas Method plgMembersResources::onMembersContributionsAreas /core/plugins/members/resources/resources.php:88
  • onMembersContributionsAreas Method plgMembersWiki::onMembersContributionsAreas /core/plugins/members/wiki/wiki.php:53
  • onMembersContributionsAreas Method plgMembersCourses::onMembersContributionsAreas /core/plugins/members/courses/courses.php:379
  • onMembersContributionsAreas Method plgMembersImpact::onMembersContributionsAreas /core/plugins/members/impact/impact.php:221
  • onMembersContributionsAreas Method plgMembersPublications::onMembersContributionsAreas /core/plugins/members/publications/publications.php:90
  • onMembersContributions Method plgMembersResources::onMembersContributions /core/plugins/members/resources/resources.php:142
  • onMembersContributions Method plgMembersWiki::onMembersContributions /core/plugins/members/wiki/wiki.php:90
  • onMembersContributions Method plgMembersCourses::onMembersContributions /core/plugins/members/courses/courses.php:417
  • onMembersContributions Method plgMembersImpact::onMembersContributions /core/plugins/members/impact/impact.php:266
  • onMembersContributions Method plgMembersPublications::onMembersContributions /core/plugins/members/publications/publications.php:127
  • onMembers Method plgMembersDashboard::onMembers /core/plugins/members/dashboard/dashboard.php:113
  • onMembers Method plgMembersProfile::onMembers /core/plugins/members/profile/profile.php:75
  • onMembers Method plgMembersAccount::onMembers /core/plugins/members/account/account.php:85
  • onMembers Method plgMembersBlog::onMembers /core/plugins/members/blog/blog.php:75
  • onMembers Method plgMembersCollections::onMembers /core/plugins/members/collections/collections.php:75
  • onMembers Method plgMembersContributions::onMembers /core/plugins/members/contributions/contributions.php:75
  • onMembers Method plgMembersCourses::onMembers /core/plugins/members/courses/courses.php:78
  • onMembers Method plgMembersGroups::onMembers /core/plugins/members/groups/groups.php:81
  • onMembers Method plgMembersImpact::onMembers /core/plugins/members/impact/impact.php:138
  • onMembers Method plgMembersMessages::onMembers /core/plugins/members/messages/messages.php:81
  • onMembers Method plgMembersPoints::onMembers /core/plugins/members/points/points.php:81
  • onMembers Method plgMembersProjects::onMembers /core/plugins/members/projects/projects.php:96
  • onMembers Method plgMembersResume::onMembers /core/plugins/members/resume/resume.php:185
  • onMembers Method plgMembersUsage::onMembers /core/plugins/members/usage/usage.php:75
  • onMembers Method plgMembersCitations::onMembers /core/plugins/members/citations/citations.php:92
  • onMembers Method plgMembersActivity::onMembers /core/plugins/members/activity/activity.php:78
  • 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