--
-- Since : 5.8.0
--
-- File    : whathappened.sql
-- Purpose : this file contains the needed SQL commands to 
--           retreive pilot jobs from DB
-- Usage   : mysql < whathappened.sql
--


       select date(arrivaldate),count(*) 
         from works 
	 where not isnull(arrivaldate)
	   and date(arrivaldate)>"2009-07-14" 
	   and not isnull(userproxy)
	 group by date(arrivaldate);
