quick overview of the coop push status

coop-push-status.sql

select 
    pcd.push_date, pci.priority, pci.content_automediaid, sum(pcir.started) run_started, sum(pcir.completed) run_completed, 
    pci.max_runs, stats_base, sum(pcir.stats_billed) stats_billed
from 
                    push_cycle_day pcd inner 
    join            push_cycle_item pci on (pcd.id=pci.push_cycle_day_id) 
    left outer join push_cycle_item_run pcir on (pci.id=pcir.push_cycle_item_id) 
where
    pcd.push_date=date(now()) 
group by pci.id 
order by priority;