All Events in the City of Springfield, Georgia

S: SELECT TOP 200 E.EventID, E.EventDate, E.EventHeading, E.EventDesc, E.EventDatePosted, E.EventOrgType, E.EventOrgID, CASE WHEN (E.EventCityActive='Y' AND CO.COCityID IS NOT NULL) THEN 1 WHEN (E.EventStateActive='Y' AND SO.SOStateID IS NOT NULL) THEN 2 WHEN (E.EventRegionActive='Y' AND RO.RORegionID IS NOT NULL) THEN 3 WHEN (E.EventNationActive='Y' AND NAO.NONationID IS NOT NULL) THEN 4 ELSE 99 END AS Priority, CASE WHEN E.EventOrgType='E' THEN ENT.EntityName WHEN E.EventOrgType='C' THEN C.CityDesc WHEN E.EventOrgType='T' THEN T.CountyDesc WHEN E.EventOrgType='S' THEN S.StateDesc WHEN E.EventOrgType='R' THEN R.RegionDesc WHEN E.EventOrgType='N' THEN NAT.NationDesc END AS OrgName FROM Event E LEFT JOIN Entitys ENT ON E.EventOrgType='E' AND E.EventOrgID=ENT.EntityID LEFT JOIN Citys C ON E.EventOrgType='C' AND E.EventOrgID=C.CityID LEFT JOIN Countys T ON E.EventOrgType='T' AND E.EventOrgID=T.CountyID LEFT JOIN States S ON E.EventOrgType='S' AND E.EventOrgID=S.StateID LEFT JOIN Regions R ON E.EventOrgType='R' AND E.EventOrgID=R.RegionID LEFT JOIN Nations NAT ON E.EventOrgType='N' AND E.EventOrgID=NAT.NationID LEFT JOIN CityOrgs CO ON CO.COOrgType=E.EventOrgType AND CO.COOrgID=E.EventOrgID AND CO.COCityID=4686 LEFT JOIN StateOrgs SO ON SO.SOOrgType=E.EventOrgType AND SO.SOOrgID=E.EventOrgID AND SO.SOStateID=15 LEFT JOIN RegionOrgs RO ON RO.ROOrgType=E.EventOrgType AND RO.ROOrgID=E.EventOrgID AND RO.RORegionID=8 LEFT JOIN NationOrgs NAO ON NAO.NOOrgType=E.EventOrgType AND NAO.NOOrgID=E.EventOrgID AND NAO.NONationID=3 WHERE E.EventActive='Y' AND DatePart(yy,EventDate) = 2026 AND DatePart(mm,EventDate) = 5 AND EventDate >= CONVERT(VARCHAR(8),getdate(),112) AND EventAgricultureActive = 'Y' ORDER BY DatePart(dd,EventDate),EventID