SELECT ID,INTDATE,DATE,NODE,DB,TRIG,FILE,CLASS,CLASSIFIER,CONF,COMMENT FROM WHO_detection WHERE ((CLASS != 'DELETE')&&(CLASS != 'CLASSIFIED'))&&(TIMESTAMP(DATE(DATE),TIME(DATE)) >= TIMESTAMP(DATE('2009/1/9'),TIME('1800:00'))) && ( TIMESTAMP(DATE(DATE),TIME(DATE)) <= TIMESTAMP(DATE('2010/1/9'),TIME('19:59:59'))) ORDER by DATE desc