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