Mercurial > hgrepos > hgweb.cgi > s4
changeset 812:31df689bad63 feature-world
Oops, WITH clause error.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Mon, 15 Jun 2020 19:55:07 +0900 |
parents | 52c249ab4ca6 |
children | 04034092338d |
files | s4-funcs.sh |
diffstat | 1 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-funcs.sh Mon Jun 15 14:31:57 2020 +0900 +++ b/s4-funcs.sh Mon Jun 15 19:55:07 2020 +0900 @@ -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