Hi all,
> DELETE FROM patchwork_person WHERE id NOT IN (
> SELECT submitter_id FROM patchwork_patch
> UNION
> SELECT submitter_id FROM patchwork_comment
Make that:
DELETE FROM patchwork_person WHERE id NOT IN (
SELECT submitter_id FROM patchwork_patch
UNION
SELECT submitter_id FROM patchwork_comment)
AND user_id IS NULL;
- so we retain linkages for folks that haven't submitted a patch or comment.
Cheers,
Jeremy
_______________________________________________
Patchwork mailing list
[email protected]
https://lists.ozlabs.org/listinfo/patchwork
