Skip to content

Instantly share code, notes, and snippets.

@Ladsgroup

Ladsgroup/DELETE statement.sql

Created May 6, 2016 21:56
Show Gist options
  • Save Ladsgroup/55f0b5fa1736aa40200c77c4656573ac to your computer and use it in GitHub Desktop.
Save Ladsgroup/55f0b5fa1736aa40200c77c4656573ac to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DELETE statement.sql
delete from workset_task
using workset_task as wt
join workset on workset.id = wt.workset_id left outer join label on label.task_id = wt.task_id
WHERE
workset_task.workset_id = wt.workset_id AND
workset_task.task_id = wt.task_id AND
label.data is NULL
AND workset.expires < NOW();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment