Changes between Version 1 and Version 2 of DatabaseCleanup

Timestamp:

Apr 9, 2015, 2:04:59 PM (9 years ago)

Author:

casties

Comment:

--

DatabaseCleanup

@@ -9 +9 @@
 having cnt > 1
 order by cnt desc;
+}}}
+
+All entities with more than one node_type:
+{{{
+select count(distinct node_type) as cnt, id from openmind.node
+group by id
+having cnt > 1
+order by 1 desc;
 }}}