SELECT A.*, B.*, C.*, D.*, E.*, F.*, A.BallotStyle As OrigBallotStyle, F.Precinct As LogPrecinct, F.grp As LogGroup, B.BallotStyle As LogBallotStyle FROM BallotLog B left join VoterLookupDetail As A on A.StateVoterID = B.StateVoterID LEFT JOIN EthnicityDesc As C ON A.EthnicityCode = C.Code LEFT JOIN DIST_CityDesc As D ON A.CityCode = D.Code LEFT JOIN DIST_PartyDesc As E ON A.PartyCode = E.Code LEFT JOIN DIST_Precincts As F ON B.`PrecinctID` = F.`precinct_id`  Where LastName Like 'HORT%' And B.PrecinctComboID = '101' Order By LastName, FirstName, EndTranTS desc