# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1592218507 -32400
# Node ID 31df689bad632c367d816e65c69c2101e318027f
# Parent  52c249ab4ca600e1e1a5f21218f72b56c6039b22
Oops, WITH clause error.

diff -r 52c249ab4ca6 -r 31df689bad63 s4-funcs.sh
--- 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