Query: project_access_request_table

select
  p.full_path as "Project",
  r.username as "User",
  r.access_level_description as "Requested Access",
  now() :: date - r.requested_at :: date as "Age in Days",
  p.web_url
from
  gitlab_my_project p
  join gitlab_project_access_request r on p.id = r.project_id
where
  r.state = 'active'
order by
  "Age in Days" desc;