Changes between Version 6 and Version 7 of DatabaseCleanup


Ignore:
Timestamp:
Aug 3, 2016, 9:51:53 AM (8 years ago)
Author:
casties
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DatabaseCleanup

    v6 v7  
    8989group by source_obj_class
    9090}}}
     91
     92The number of entries modified in a date range.
     93{{{
     94select count(*), node_type from node
     95where
     96modification_time > unix_timestamp('2016-07-27')*1000
     97and
     98modification_time < unix_timestamp('2016-07-28')*1000
     99group by node_type
     100}}}