Nicholas Michael Angelakis

The profile picture for Nicholas Michael Angelakis

Profile

  • Organization
    BDO EconSearch

  • Employment Status
    Industry / Private Company

  • Website
    https://www.bdo.com.au/en-au/econsearch

  • Reason
    Using simulation tools for research

  • Interests
    (not set)

  • Biography
    (not set)

  • Receive Email Updates
    Yes, send me emails

Debug Console

Close33 MBRequestSessionTimelineDatabase85Events58
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( USER => apache, HOME => /usr/share/httpd, FCGI_ROLE => RESPONDER, REDIRECT_HTTP_AU... Array(
USER => apache,
HOME => /usr/share/httpd,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_UNIQUE_ID => ZRioozeBmjinuCJIt3QPLQAAAAU,
REDIRECT_SCRIPT_URL => /members/1019,
REDIRECT_SCRIPT_URI => https://ielab.info/members/1019,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
UNIQUE_ID => ZRioozeBmjinuCJIt3QPLQAAAAU,
SCRIPT_URL => /members/1019,
SCRIPT_URI => https://ielab.info/members/1019,
HTTPS => on,
HTTP_X_FORWARDED_FOR => 34.239.148.127,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_PORT => 443,
HTTP_HOST => ielab.info,
HTTP_X_AMZN_TRACE_ID => Root=1-6518a8a3-12dd6f195c1d1d7345666780,
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 => Wed, 22 Mar 2023 03:11:48 GMT,
HTTP_ACCEPT_ENCODING => br,gzip,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_python/3.5.0- Python/2.7.5,
SERVER_NAME => ielab.info,
SERVER_ADDR => 10.84.154.253,
SERVER_PORT => 443,
REMOTE_ADDR => 10.84.154.116,
DOCUMENT_ROOT => /var/www/ielab,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/ielab,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/ielab/index.php,
REMOTE_PORT => 19572,
REDIRECT_URL => /members/1019,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/1019,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1696114851.3147,
REQUEST_TIME => 1696114851
)
session.client.forwarded ⇒ 34.239.148.127
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 2414ce76ab83db48ca2cca99729cbbab
tracker.ssid ⇒ 2414ce76ab83db48ca2cca99729cbbab
tracker.rsid ⇒ 2414ce76ab83db48ca2cca99729cbbab
  • site 0.039 seconds (+0.039); 9.50 MB (+9.500) - afterInitialise
  • site 0.059 seconds (+0.020); 11.50 MB (+2.000) - afterRoute
  • site 0.239 seconds (+0.181); 32.00 MB (+20.500) - afterDispatch
  • site 0.245 seconds (+0.006); 32.25 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.247 seconds (+0.002); 32.50 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.248 seconds (+0.000); 32.50 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.249 seconds (+0.001); 32.50 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.250 seconds (+0.000); 32.50 MB (0.000) - beforeRenderModule mod_menu (Community)
  • site 0.251 seconds (+0.002); 32.50 MB (0.000) - afterRenderModule mod_menu (Community)
  • site 0.251 seconds (+0.000); 32.50 MB (0.000) - beforeRenderModule mod_menu (Support)
  • site 0.252 seconds (+0.000); 32.50 MB (0.000) - afterRenderModule mod_menu (Support)
  • site 0.252 seconds (+0.000); 32.50 MB (0.000) - beforeRenderModule mod_menu (Analyse)
  • site 0.252 seconds (+0.000); 32.50 MB (0.000) - afterRenderModule mod_menu (Analyse)
  • site 0.253 seconds (+0.000); 32.50 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.257 seconds (+0.005); 32.75 MB (+0.250) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.258 seconds (+0.000); 32.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.274 seconds (+0.016); 33.00 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.274 seconds (+0.000); 33.00 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.276 seconds (+0.002); 33.25 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.276 seconds (+0.000); 33.25 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.279 seconds (+0.003); 33.25 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.281 seconds (+0.002); 33.25 MB (0.000) - onAfterRender
  • site 0.282 seconds (+0.002); 33.25 MB (0.000) - sessionStore
33 MB

85 Queries Logged: 0.034108877182007 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '5218f50b84087645790e188860a609eb'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '5218f50b84087645790e188860a609eb'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '2414ce76ab83db48ca2cca99729cbbab'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '2414ce76ab83db48ca2cca99729cbbab'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('2414ce76ab83db48ca2cca99729cbbab','0','1696114851','10.84.154.116')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. 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
  12. 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
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  14. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1019'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  17. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  18. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jobs'
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  20. SHOW FULL COLUMNS
      FROM `jos_jobs_employers`
  21. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  22. 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
  23. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  24. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  25. 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 > '2023-09-30 23:00:51'
  26. SELECT *
      FROM `jos_user_profile_fields`
      WHERE `jos_user_profile_fields`.`action_edit` != '0'
      ORDER BY `ordering` ASC
  27. SELECT *
      FROM `jos_user_profile_options`
      WHERE `jos_user_profile_options`.`field_id` IN ('1','2','5','6','11','12','15')
      ORDER BY `ordering` ASC
  28. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1019'
  29. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'xprofiles'
      AND `jos_tags_object`.`objectid` = '1019'
      AND `jos_tags`.`admin` NOT IN ('1')
      GROUP BY jos_tags_object.label,jos_tags.id
  30. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'xprofiles'
      AND `jos_tags_object`.`objectid` = '1019'
      AND `jos_tags`.`admin` NOT IN ('1')
      GROUP BY jos_tags_object.label,jos_tags.id
  31. 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` <= '2023-09-30 23:00:51' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2023-09-30 23:00:51' )
      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
  32. SELECT jos_user_profiles.*,jos_user_profile_options.label
      FROM `jos_user_profiles`
      INNER JOIN jos_user_profile_fields
      ON jos_user_profile_fields.name = jos_user_profiles.profile_key
      LEFT JOIN jos_user_profile_options
      ON jos_user_profile_options.field_id=jos_user_profile_fields.id
      AND jos_user_profile_options.value=jos_user_profiles.profile_value
      WHERE `jos_user_profiles`.`user_id` = '1019'
      AND `jos_user_profiles`.`user_id` = '1019'
      ORDER BY `ordering` ASC
  33. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'xprofiles'
      AND `jos_tags_object`.`objectid` = '1019'
      AND `jos_tags`.`admin` NOT IN ('1')
      GROUP BY jos_tags_object.label,jos_tags.id
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  35. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1019'
      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` <= '2023-09-30 23:00:51' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2023-09-30 23:00:51' )
  36. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  37. SHOW FULL COLUMNS
      FROM `jos_collections`
  38. 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='1019'
      AND b.object_type='member'
  39. 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='1019'
      AND b.object_type='member'
  40. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  41. 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` = '1019'
      AND `jos_author_assoc`.`role` != 'submitter'
      AND `jos_resources`.`access` IN ('0','3')
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  43. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`created_by` = '1019'
      AND `jos_wiki_versions`.`approved` = '1'
      GROUP BY page_id,id
  44. 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 ('')
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  46. SHOW FULL COLUMNS
      FROM `jos_courses`
  47. 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=1019
      AND m.student=0
      AND r.alias='instructor'
      AND c.state=1
  48. SHOW FULL COLUMNS
      FROM `jos_publications`
  49. SELECT *
      FROM `jos_publication_categories`
      WHERE `jos_publication_categories`.`state` = '1'
      ORDER BY `name` ASC
  50. 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` = '1019'
      AND (`jos_publication_authors`.`role` IS NULL OR `jos_publication_authors`.`role` != 'submitter' )
      AND `jos_publication_versions`.`access` IN ('0','3')
  51. SHOW FULL COLUMNS
      FROM `jos_courses_offerings`
  52. SHOW FULL COLUMNS
      FROM `jos_courses_roles`
  53. 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)
  54. 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=1019
      AND m.student=0
      AND r.alias='instructor'
  55. 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=1019
      AND m.student=0
      AND r.alias='manager'
  56. 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=1019
      AND m.student=1
      AND (s.publish_down IS NULL OR s.publish_down='0000-00-00 00:00:00' OR s.publish_down < '2023-09-30 23:00:51')
      AND s.state=1
      AND o.state=1
  57. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'nick.angelakis@bdo.com.au'
  58. ( 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=1019 ) 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=1019 ) 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=1019 ) 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=1019 )
  59. 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=1019
      WHERE `jos_xmessage_recipient`.`uid` = '1019'
      AND `jos_xmessage_recipient`.`state` = '0'
  60. 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` = '1019'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=1019)
  61. SHOW TABLES
  62. SELECT *
      FROM `jos_users_points`
      WHERE `jos_users_points`.`uid` = '1019'
  63. SHOW FULL COLUMNS
      FROM `jos_projects`
  64. 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='1019'
      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='1019'
      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='1019')))
      AND p.provisioned = 0
  65. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  66. 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='nick.angelakis@bdo.com.au'
  67. 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 > '2023-09-30 23:00:51'
  68. 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 > '2023-09-30 23:00:51'
  69. 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 > '2023-09-30 23:00:51'
  70. SHOW TABLES
  71. 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` = '1019'
      AND `jos_citations`.`published` IN ('1')
  72. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '1019'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  73. ( 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 )
  74. ( 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=1019 ) 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=1019 ) 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=1019 ) 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=1019 )
  75. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  76. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  77. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  78. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  79. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  80. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  81. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  82. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  83. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  84. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  85. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1696114851;s:18:\"session.timer.last\";i:1696114851;s:17:\"session.timer.now\";i:1696114851;s:24:\"session.client.forwarded\";s:14:\"34.239.148.127\";s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":2:{s:7:\"Members\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Profile\";O:8:\"stdClass\":4:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Option\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}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: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:\"2414ce76ab83db48ca2cca99729cbbab\";s:12:\"tracker.ssid\";s:32:\"2414ce76ab83db48ca2cca99729cbbab\";s:12:\"tracker.rsid\";s:32:\"2414ce76ab83db48ca2cca99729cbbab\";}',`time` = '1696114851',`ip` = '10.84.154.116'
      WHERE `session_id` = '2414ce76ab83db48ca2cca99729cbbab'
  • onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:20
  • onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise — Method — plgSystemReferrerpolicy::onAfterInitialise → /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:21
  • onAfterRoute — Method — plgSystemPassword::onAfterRoute → /core/plugins/system/password/password.php:21
  • onMembersAreas — Method — plgMembersDashboard::onMembersAreas → /core/plugins/members/dashboard/dashboard.php:62
  • onMembersAreas — Method — plgMembersProfile::onMembersAreas → /core/plugins/members/profile/profile.php:30
  • onMembersAreas — Method — plgMembersAccount::onMembersAreas → /core/plugins/members/account/account.php:34
  • onMembersAreas — Method — plgMembersBlog::onMembersAreas → /core/plugins/members/blog/blog.php:30
  • onMembersAreas — Method — plgMembersCollections::onMembersAreas → /core/plugins/members/collections/collections.php:30
  • onMembersAreas — Method — plgMembersContributions::onMembersAreas → /core/plugins/members/contributions/contributions.php:30
  • onMembersAreas — Method — plgMembersCourses::onMembersAreas → /core/plugins/members/courses/courses.php:30
  • onMembersAreas — Method — plgMembersGroups::onMembersAreas → /core/plugins/members/groups/groups.php:30
  • onMembersAreas — Method — plgMembersImpact::onMembersAreas → /core/plugins/members/impact/impact.php:80
  • onMembersAreas — Method — plgMembersMessages::onMembersAreas → /core/plugins/members/messages/messages.php:30
  • onMembersAreas — Method — plgMembersPoints::onMembersAreas → /core/plugins/members/points/points.php:30
  • onMembersAreas — Method — plgMembersProjects::onMembersAreas → /core/plugins/members/projects/projects.php:46
  • onMembersAreas — Method — plgMembersResume::onMembersAreas → /core/plugins/members/resume/resume.php:60
  • onMembersAreas — Method — plgMembersUsage::onMembersAreas → /core/plugins/members/usage/usage.php:30
  • onMembersAreas — Method — plgMembersCitations::onMembersAreas → /core/plugins/members/citations/citations.php:47
  • onMembersAreas — Method — plgMembersActivity::onMembersAreas → /core/plugins/members/activity/activity.php:30
  • onMembersContributionsAreas — Method — plgMembersResources::onMembersContributionsAreas → /core/plugins/members/resources/resources.php:63
  • onMembersContributionsAreas — Method — plgMembersWiki::onMembersContributionsAreas → /core/plugins/members/wiki/wiki.php:28
  • onMembersContributionsAreas — Method — plgMembersCourses::onMembersContributionsAreas → /core/plugins/members/courses/courses.php:354
  • onMembersContributionsAreas — Method — plgMembersImpact::onMembersContributionsAreas → /core/plugins/members/impact/impact.php:196
  • onMembersContributionsAreas — Method — plgMembersPublications::onMembersContributionsAreas → /core/plugins/members/publications/publications.php:65
  • onMembersContributions — Method — plgMembersResources::onMembersContributions → /core/plugins/members/resources/resources.php:117
  • onMembersContributions — Method — plgMembersWiki::onMembersContributions → /core/plugins/members/wiki/wiki.php:65
  • onMembersContributions — Method — plgMembersCourses::onMembersContributions → /core/plugins/members/courses/courses.php:392
  • onMembersContributions — Method — plgMembersImpact::onMembersContributions → /core/plugins/members/impact/impact.php:241
  • onMembersContributions — Method — plgMembersPublications::onMembersContributions → /core/plugins/members/publications/publications.php:102
  • onMembers — Method — plgMembersDashboard::onMembers → /core/plugins/members/dashboard/dashboard.php:88
  • onMembers — Method — plgMembersProfile::onMembers → /core/plugins/members/profile/profile.php:50
  • onMembers — Method — plgMembersAccount::onMembers → /core/plugins/members/account/account.php:60
  • onMembers — Method — plgMembersBlog::onMembers → /core/plugins/members/blog/blog.php:50
  • onMembers — Method — plgMembersCollections::onMembers → /core/plugins/members/collections/collections.php:50
  • onMembers — Method — plgMembersContributions::onMembers → /core/plugins/members/contributions/contributions.php:50
  • onMembers — Method — plgMembersCourses::onMembers → /core/plugins/members/courses/courses.php:53
  • onMembers — Method — plgMembersGroups::onMembers → /core/plugins/members/groups/groups.php:56
  • onMembers — Method — plgMembersImpact::onMembers → /core/plugins/members/impact/impact.php:113
  • onMembers — Method — plgMembersMessages::onMembers → /core/plugins/members/messages/messages.php:56
  • onMembers — Method — plgMembersPoints::onMembers → /core/plugins/members/points/points.php:56
  • onMembers — Method — plgMembersProjects::onMembers → /core/plugins/members/projects/projects.php:71
  • onMembers — Method — plgMembersResume::onMembers → /core/plugins/members/resume/resume.php:160
  • onMembers — Method — plgMembersUsage::onMembers → /core/plugins/members/usage/usage.php:50
  • onMembers — Method — plgMembersCitations::onMembers → /core/plugins/members/citations/citations.php:67
  • onMembers — Method — plgMembersActivity::onMembers → /core/plugins/members/activity/activity.php:54
  • onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:22
  • onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:60
  • onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:25
  • onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:21