projects
/
Pman.Core
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Prune.php
[Pman.Core]
/
Prune.php
diff --git
a/Prune.php
b/Prune.php
index
c0a6c29
..
c4642f6
100644
(file)
--- a/
Prune.php
+++ b/
Prune.php
@@
-71,9
+71,9
@@
class Pman_Core_Prune extends Pman
$f = DB_DataObject::Factory('Events');
$f->selectAdd();
$f = DB_DataObject::Factory('Events');
$f->selectAdd();
- $f->selectAdd("on_id, min(id) as min_id, max(id) as max_id, count(*) as mm");
+ $f->selectAdd("on_id,
on_table,
min(id) as min_id, max(id) as max_id, count(*) as mm");
$f->whereAdd("action = 'NOTIFY' and event_when < NOW() - INTERVAL 1 WEEK");
$f->whereAdd("action = 'NOTIFY' and event_when < NOW() - INTERVAL 1 WEEK");
- $f->groupBy('on_id');
+ $f->groupBy('on_id
, on_table
');
$f->having("mm > 2");
$f->orderBy('mm desc') ;
$f->limit(1000);
$f->having("mm > 2");
$f->orderBy('mm desc') ;
$f->limit(1000);