/*results.asp case=Country u=*/ SELECT Markers.MarkerID, Marker, Memorial, [The-Prefix] INTO #R8320743Country1726977 FROM Markers LEFT JOIN Countries ON Markers.Country=Countries.Country WHERE Markers.Country COLLATE Latin1_General_CI_AI ='United%20Kingdom' AND Accepted Is Not Null AND Rejected Is Null AND Withdrawn Is Null AND ReplacedByID Is Null