SELECT ID,INTDATE,DATE,NODE,DB,TRIG,FILE,CLASS,CLASSIFIER,CONF,COMMENT FROM WHO_detection WHERE && (NODE = 'pt')&&(TIMESTAMP(DATE(DATE),TIME(DATE)) >= TIMESTAMP(DATE('2012/3/26'),TIME('00:00:00'))) && ( TIMESTAMP(DATE(DATE),TIME(DATE)) <= TIMESTAMP(DATE('2012/3/27'),TIME('23:59:59')))&& ((TRIG = 'PKT')) ORDER by DATE desc