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 ?