diff --git a/s4-funcs.sh b/s4-funcs.sh index 52e966b..0624922 100755 --- a/s4-funcs.sh +++ b/s4-funcs.sh @@ -3783,14 +3783,14 @@ SELECT blog.id,val FROM blog JOIN blog_s bs ON blog.id=bs.id AND key='owner' WHERE val NOT IN (SELECT gname FROM grp) - AND val NOT IN (SELECT name FROM user); + AND val NOT IN (SELECT name FROM user) ) -- Remove them DELETE FROM blog WHERE id IN (SELECT id FROM orphanedblog); -- Find articles that have no parent blog WITH orphanedarticle AS ( SELECT id FROM article - WHERE blogid NOT IN (SELECT id FROM blog); + WHERE blogid NOT IN (SELECT id FROM blog) ) -- Remove them DELETE FROM article WHERE id IN (SELECT id FROM orphanedarticle); EOF