/* results.asp Keyword U=*/ SELECT Markers.MarkerID, Rank, CAST (CASE WHEN Country='United States of America' THEN 1 ELSE 0 END AS bit) as USA, ReplacedByID, Markers.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, County, Neighborhood, Markers.CreatedBy, Markers.Accepted, Markers.Changed, Markers.Withdrawn, Markers.Rejected, Marker, Memorial, YearErected, Tag1, Tag2, Tag3, Tag4, Tag5 FROM (Markers INNER JOIN CONTAINSTABLE(Markers ,(Title, Subtitle, Subtitle2, Text, Comments, SubjectComments, Organization,Keywords),'FORMSOF (INFLECTIONAL, "portsmouth%2c va")') AS Result1 ON Markers.MarkerID=Result1.[Key]) LEFT JOIN Tags ON Tags.MarkerID=Markers.MarkerID AND UserID=0 WHERE Markers.Accepted Is Not Null AND Markers.Withdrawn Is Null AND Markers.ReplacedByID Is Null AND Markers.Rejected Is Null ORDER BY Rank DESC, USA, Country, State, County, Town, Neighborhood, Markers.Title