Mercurial > sci
comparison sql/job-todo.sql @ 4:9c4fea43803c
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 ? |