Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- DISTINCT ON (job_tasks.target_uuid) target_uuid,
- job_tasks.id,
- job_tasks.completed_by_actor_id,
- job_tasks.scheduled,
- job_tasks.task_type_id,
- job_task_types.name AS task_type_name
- FROM job_tasks
- LEFT JOIN job_task_types ON job_task_types.id = job_tasks.task_type_id
- WHERE job_tasks.scheduled IS NOT TRUE
- AND job_tasks.target_uuid NOT IN(
- SELECT target_uuid
- FROM job_tasks
- WHERE completed_by_actor_id = 1
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement