Changes between Version 2 and Version 3 of DatabaseCleanup

Timestamp:

Apr 10, 2015, 2:03:31 PM (9 years ago)

Author:

casties

Comment:

--

DatabaseCleanup

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