Delete orphaned media #12

New Issue

Closed

opened 2020-10-21 22:46:29 +00:00 by pendulum · 0 comments

pendulum commented

2020-10-21 22:46:29 +00:00

delete from p where not exists (select from (select p_id from c1 union select p_id from c2 union ...) s where s.p_id = p.id);

`delete from p where not exists (select from (select p_id from c1 union select p_id from c2 union ...) s where s.p_id = p.id);`

pendulum closed this issue

2020-10-24 23:49:03 +00:00

Sign in to join this conversation.

No Label

No Milestone

No Assignees

1 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: DebaucheryLibrarian/traxxx#12

No description provided.