SELECT ID,INTDATE,DATE,NODE,DB,TRIG,FILE,CLASS,CLASSIFIER,CONF,COMMENT FROM WHO_detection WHERE (NODE = 'os')&&(TIMESTAMP(DATE(DATE),TIME(DATE)) >= TIMESTAMP(DATE(' 2010/02/06'),TIME('08:29:59'))) && ( TIMESTAMP(DATE(DATE),TIME(DATE)) <= TIMESTAMP(DATE(' 2010/02/6'),TIME('20:29:59'))) ORDER by DATE desc