Mercurial > sci

comparison sql/job-todo.sql @ 4:9c4fea43803c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
scid: some refactoring in db
author David Demelier <markand@malikania.fr>
date Tue, 15 Jun 2021 20:42:55 +0200
parents 215c0c3b3609
children 8c408176d2b1
comparison
equal deleted inserted replaced
3:215c0c3b3609 4:9c4fea43803c
2 , job.tag 2 , job.tag
3 , job.project_id 3 , job.project_id
4 FROM job 4 FROM job
5 WHERE job.id 5 WHERE job.id
6 NOT IN ( 6 NOT IN (
7 SELECT job_result.job_id 7 SELECT jobresult.job_id
8 FROM job_result 8 FROM jobresult
9 WHERE job_result.worker_id = ? 9 WHERE jobresult.worker_id = ?
10 ) 10 )
11 LIMIT ? 11 LIMIT ?