Changes between Version 8 and Version 9 of DatabaseCleanup

Timestamp:

Aug 4, 2016, 1:20:39 PM (8 years ago)

Author:

casties

Comment:

--

DatabaseCleanup

@@ -99 +99 @@
 group by node_type
 }}}
+
+The number of REFERENCEs without attributes but with relations grouped by date.
+{{{
+select count(*), from_unixtime(modification_time/1000, '%Y-%m-%d')
+from node e
+where 
+e.object_class = 'REFERENCE'
+and system_status = 'CURRENT_VERSION'
+and e.id not in (
+select source_id from node
+where node_type = 'ATTRIBUTE'
+)
+and e.id in (
+select source_id from node
+where node_type = 'RELATION'
+)
+group by from_unixtime(modification_time/1000, '%Y-%m-%d')
+order by 2
+}}}