Mercurial > sci
view sql/job-result-todo.sql @ 2:5fa3d2f479b2
sci: initial upload support
author | David Demelier <markand@malikania.fr> |
---|---|
date | Thu, 10 Jun 2021 10:39:21 +0200 |
parents | |
children |
line wrap: on
line source
SELECT job.id , job.tag , project.name FROM job, project WHERE job.project_id = project.id AND job.id NOT IN ( SELECT job_result.job_id FROM job_result WHERE job_result.worker_id = ? ) LIMIT ?