s4

changeset 812:31df689bad63 feature-world

find changesets by author, revision, files, or words in the commit message
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 diff
     1.1 --- a/s4-funcs.sh	Mon Jun 15 14:31:57 2020 +0900
     1.2 +++ b/s4-funcs.sh	Mon Jun 15 19:55:07 2020 +0900
     1.3 @@ -3783,14 +3783,14 @@
     1.4  	  SELECT blog.id,val FROM blog JOIN blog_s bs
     1.5  	         ON blog.id=bs.id AND key='owner'
     1.6                WHERE val NOT IN (SELECT gname FROM grp)
     1.7 -                AND val NOT IN (SELECT name FROM user);
     1.8 +                AND val NOT IN (SELECT name FROM user)
     1.9  	) -- Remove them
    1.10  	DELETE FROM blog WHERE id IN (SELECT id FROM orphanedblog);
    1.11  
    1.12  	-- Find articles that have no parent blog
    1.13  	WITH orphanedarticle AS (
    1.14  	  SELECT id FROM article
    1.15 -	  WHERE  blogid NOT IN (SELECT id FROM blog);
    1.16 +	  WHERE  blogid NOT IN (SELECT id FROM blog)
    1.17  	) -- Remove them
    1.18  	DELETE FROM article WHERE id IN (SELECT id FROM orphanedarticle);
    1.19  	EOF