SELECT CI.CITATION_ID, CI.TICKET_NUMBER, CI.CITATION_TYPE_CODE, CTC.DESCRIPTION AS CITATION_TYPE_DESC, CI.FILED_DATE, CI.CITATION_DATE, CI.USER_AGENCY, CI.AGENCY_CODE, CAC.AGENCY_DESC, CI.PLAINTIFF, CI.TWP_RD, CI.STATE_DIST_CODE, SDC.DESCRIPTION AS STATE_DIST_DESC, CI.CITY_CODE, CC.DESCRIPTION AS CITY_DESC, CI.COUNTY_CODE, COC.DESCRIPTION AS COUNTY_DESC, CI.BOND_TYPE, BTC.DESCRIPTION AS BOND_TYPE_DESC, CI.MUST_APPEAR, CI.BOND_AMOUNT, CI.POSTED_SPEED, CI.ACTUAL_SPEED, CI.RACE_KNOWN, CI.STOP_COMMENT, CI.PERCEIVED_RACE_CODE, PRC.DESCRIPTION AS PERCEIVED_RACE_DESC, CI.DURATION_CODE, DC.DESCRIPTION AS DURATION_DESC, V.VEHICLE_ID, V.VIN, VD.LIC_NUMBER, VD.LIC_STATE_CODE, VMA.VEHICLE_MAKE_DESC, VMO.VEHICLE_MODEL_DESC FROM CITATIONS CI INNER JOIN CITATION_TYPE_CODES CTC ON CI.CITATION_TYPE_CODE= CTC.CITATION_TYPE_CODE INNER JOIN AGENCY_CODES CAC ON CI.AGENCY_CODE = CAC.AGENCY_CODE INNER JOIN EJS_CODES COC ON CI.COUNTY_CODE = COC.CODE AND CI.COUNTY_CODE_TYPE = COC.CODE_TYPE INNER JOIN CITATION_VEHICLES CV ON CI.CITATION_ID = CV.CITATION_ID INNER JOIN VEHICLES V ON CV.VEHICLE_ID = V.VEHICLE_ID LEFT OUTER JOIN VEHICLE_DESCRIPTIONS VD ON V.VEHICLE_ID = VD.VEHICLE_ID LEFT OUTER JOIN EJS_CODES CC ON CI.CITY_CODE = CC.CODE AND CI.CITY_CODE_TYPE = CC.CODE_TYPE LEFT OUTER JOIN STATE_DISTRICT_CODES SDC ON CI.STATE_DIST_CODE = SDC.STATE_DIST_CODE LEFT OUTER JOIN BOND_TYPE_CODES BTC ON CI.BOND_TYPE = BTC.BOND_TYPE LEFT OUTER JOIN EJS_CODES PRC ON CI.PERCEIVED_RACE_CODE = PRC.CODE AND CI.PERCEIVED_RACE_CODE_TYPE = PRC.CODE_TYPE LEFT OUTER JOIN EJS_CODES DC ON CI.DURATION_CODE = PRC.CODE AND CI.DURATION_CODE_TYPE = PRC.CODE_TYPE LEFT OUTER JOIN VEHICLE_MAKES VMA ON V.VMA_VEHICLE_MAKE_CODE = VMA.VEHICLE_MAKE_CODE LEFT OUTER JOIN VEHICLE_MODELS VMO ON V.VMA_VEHICLE_MAKE_CODE = VMO.VMA_VEHICLE_MAKE_CODE AND V.VMO_VEHICLE_MODEL_CODE = VMO.VEHICLE_MODEL_CODE WHERE VD.DATE_OF_INFO = (SELECT MAX(DATE_OF_INFO) FROM VEHICLE_DESCRIPTIONS VD2 WHERE VD2.VEHICLE_ID = VD.VEHICLE_ID)