Mercurial > sci

view sql/job-todo.sql @ 3:215c0c3b3609

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc: use JSON everywhere (scictl/sciwebd)
author David Demelier <markand@malikania.fr>
date Mon, 14 Jun 2021 22:08:24 +0200
parents sql/job-result-todo.sql@5fa3d2f479b2
children 9c4fea43803c
line wrap: on
line source

     SELECT job.id
          , job.tag
          , job.project_id
       FROM job
      WHERE job.id
     NOT IN (
            SELECT job_result.job_id
              FROM job_result
             WHERE job_result.worker_id = ?
     )
      LIMIT ?