SELECT ID,INTDATE,DATE,NODE,DB,TRIG,FILE,CLASS,CLASSIFIER,CONF,COMMENT FROM WHO_detection WHERE (TIMESTAMP(DATE(DATE),TIME(DATE)) >= TIMESTAMP(DATE('2010/11/23'),TIME('08:30:00'))) && ( TIMESTAMP(DATE(DATE),TIME(DATE)) <= TIMESTAMP(DATE('2010/12/23'),TIME('18:00:00')))&& ((TRIG = 'PKT')||(TRIG = 'PWR')||(TRIG = 'PKTPWR')||(TRIG = 'HMN')) ORDER by DATE desc