SELECT WHO_detection.ID AS ID,WHO_detection.INTDATE AS INTDATE,WHO_detection.DATE AS DATE,
	WHO_detection.NODE AS NODE,	WHO_detection.DB AS DB,WHO_detection.TRIG AS TRIG,WHO_detection.FILE AS FILE,
	WHO_detection.CLASS AS CLASS,WHO_detection.CLASSIFIER AS CLASSIFIER,WHO_detection.CONF AS CONF,
	WHO_detection.COMMENT AS COMMENT,WHO_classified.ORCA AS ORCA, WHO_classified.CALLCOUNT AS CALLCOUNT, 
		WHO_classified.O_COMMENT AS _COMMENT, WHO_classified.SHIP AS SHIP, WHO_classified.S_COMMENT AS S_COMMENT, 
		WHO_classified.BOAT AS BOAT, WHO_classified.B_COMMENT AS B_COMMENT, WHO_classified.OTHER AS OTHER, 
		WHO_classified.OT_COMMENT AS OT_COMMENT, WHO_classified.COMMENTER AS COMMENTER, 
		WHO_classified.EMAIL AS EMAIL, WHO_classified.IP AS IP FROM WHO_detection,WHO_classified WHERE (WHO_detection.CLASS = 'CLASSIFIED')&&(WHO_detection.ID = WHO_classified.ID_DETECTION) && (WHO_classified.SHIP = 'Clattery') ORDER by WHO_detection.DATE desc