Mercurial > sci

comparison 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
comparison
equal deleted inserted replaced
2:5fa3d2f479b2 3:215c0c3b3609
1 SELECT job.id
2 , job.tag
3 , job.project_id
4 FROM job
5 WHERE job.id
6 NOT IN (
7 SELECT job_result.job_id
8 FROM job_result
9 WHERE job_result.worker_id = ?
10 )
11 LIMIT ?