https://linux-mirror-db.storage.googleapis.com/mirror.sl3

syzkaller.sql

select * from (
  select
    syzkaller,
    fixed_commit,
    fixes_commit,
    fixes_tags.tags `fixes_tags`,
    fixed_tags.tags `fixed_tags`
  from (
    select
      syzkaller,
      fixed_commit,
      (
        select
          `commit`
        from
          tags
        where
          `commit` >= fixes_short and
          `commit`<fixes_short||'g'
      ) fixes_commit
    from (
      select
        SUBSTR(fixes_commit, 0, INSTR(fixes_commit, " ")) fixes_short,
        fixed_commit,
        syzkaller 
      from (
        select
          'https://syzkaller.appspot.com//bug?id='||syzkaller syzkaller,
          `commit` fixed_commit,
          (
            select
              fixes
            from
              fixes
            where
              `commit`=syzkaller.`commit`
          ) fixes_commit,
          'id='||syzkaller
        from
          syzkaller
      )
    )
    where
      length(fixes_short)>0
    )
  join
    tags fixes_tags
  on
    fixes_tags.`commit`=fixes_commit
  join
    tags fixed_tags
  on
    fixed_tags.`commit`=fixed_commit
);

https://docs.google.com/spreadsheets/d/1GPU87Um_NTr4-dUsWJXoyZh61A3zg7OEVYhVTEPnmKw/edit#gid=1660945793