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