Mercurial > sci
view sql/job-todo.sql @ 3:215c0c3b3609
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 |
line wrap: on
line source
SELECT job.id , job.tag , job.project_id FROM job WHERE job.id NOT IN ( SELECT job_result.job_id FROM job_result WHERE job_result.worker_id = ? ) LIMIT ?