Table: gitlab_branch

select
  *
from
  gitlab_branch
where
  project_id = 1;

select
  p.name as project_name,
  p.full_path as project_path,
  b.name as branch_name,
  b.default as is_default_branch,
  b.commit_short_id as commit_hash
from
  gitlab_branch b
  inner join gitlab_my_project p on b.project_id = p.id
where
  b.project_id in (
    select
      id
    from
      gitlab_my_project
    where
      full_path like '%service%'
  );