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

yatex.org