Mercurial > sci
view 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 source
SELECT job.id , job.tag , job.project_id FROM job WHERE job.id NOT IN ( SELECT jobresult.job_id FROM jobresult WHERE jobresult.worker_id = ? ) LIMIT ?