Mercurial > sci
diff 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 |
line wrap: on
line diff
--- a/sql/job-todo.sql Mon Jun 14 22:08:24 2021 +0200 +++ b/sql/job-todo.sql Tue Jun 15 20:42:55 2021 +0200 @@ -4,8 +4,8 @@ FROM job WHERE job.id NOT IN ( - SELECT job_result.job_id - FROM job_result - WHERE job_result.worker_id = ? + SELECT jobresult.job_id + FROM jobresult + WHERE jobresult.worker_id = ? ) LIMIT ?