/*results.asp case=Country u=*/ SELECT Markers.MarkerID, Marker, Memorial INTO #R4974463County172695964 FROM Markers WHERE County COLLATE Latin1_General_CI_AI ='Bristol County' AND Accepted Is Not Null AND Rejected Is Null AND Withdrawn Is Null AND ReplacedByID Is Null AND ( Markers.State='Massachusetts')<hr>SELECT /* results.asp M-Not-Present U=*/ TOP 401 1 as Rank, Markers.MarkerID, CAST (CASE WHEN Country='United States of America' THEN 1 ELSE 0 END AS bit) as USA, ReplacedByID, Title, Subtitle, Subtitle2, MarkerNo, WantList, Text, Latitude, Longitude, Intown, RoadName, RouteNo, Crossroads, RoadVisible, Milemarker, ROUTEType, RouteAlt, RouteName, NearestCrossRoad, CrossRoadRouteNo, CrossRoadDistance, Miles, CrossRoadDirection, CrossRoadDistance, CrossRoadRouteType, CrossRoadRouteAlt, CrossRoadRouteName, Location, DirectionOfTravel, ReportedMissing, ConfirmedMissing, MissingModifier, Country, State, Town, Neighborhood, County, Markers.CreatedBy, Accepted, Markers.Changed, Withdrawn, Rejected, Marker, Memorial, YearErected, Tag1, Tag2, Tag3, Tag4, Tag5 FROM Markers LEFT JOIN Tags ON Tags.MarkerID=Markers.MarkerID AND UserID=0 WHERE Markers.MarkerID IN ( SELECT MarkerID FROM #R4974463County172695964) ORDER BY USA DESC, Country, State, County, Town, Neighborhood, Title, MarkerNo, Markers.MarkerID<hr>List of MarkerIDs: 0,1614,1615,1616,1617,1626,16723,23178,33075,44921,44924,44925,52379,52383,52405,55656,55658,55662,55671,55679,55680,55681,55682,55683,55684,55685,55686,55904,55905,55911,55912,55913,55917,55918,55989,56214,56215,56216,56217,56243,56244,56246,56247,56249,56302,56459,56462,56627,57021,57023,57390,57747,57926,57928,57929,57933,58124,58178,58179,58182,58183,58192,58196,58197,58199,59281,59938,59939,62358,62364,62387,62389,62410,62411,65896,65897,66248,66250,66252,66255,66256,66341,66342,70335,70336,72444,76980,77465,77467,77468,77505,84070,84071,85866,85875,86653,86657,86677,86680,86731,86733,86759,86766,86768,86782,86786,86796,86901,86947,87253,88055,88084,88105,88106,88205,92195,95016,95017,95382,97070,107413,107415,157801,157813,158283,158290,158669,158687,158696,158968,159211,160009,160348,160350,160351,160353,160355,160357,160358,160359,162499,195790,195792,195793,195794,195796,195797,196875,198154,198211,198215,208829,208830,208876,208878,208881,208883,208884,208886,208888,208889,208891,208893,209696,209711,209712,209713,209885,209888,209894,209896,209898,209900,210019,210020,210021,210025,210030,210031,210033,210035,210036,216388,218829,229607,235790,241655,244691