gis algerian อันดับต้น ๆ ใน stackexchange ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top gis algerian on stackexchange.It is not neccessary to use all the tables.
 PostLinks:  Id [ number]  CreationDate [ time]  PostId [ number]  RelatedPostId [ number]  LinkTypeId [ number] 
SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS "#", Id AS "user_link", Reputation, Age, Location, WebsiteUrl AS Wesbite, LastAccessDate AS Seen, CreationDate FROM Users WHERE Reputation >= '##MinimalReputation:int?200##' AND (UPPER(Location) LIKE UPPER('%Algeria%') OR UPPER(Location) LIKE UPPER('%Algerie%') OR UPPER(Location) LIKE UPPER('% %')) ORDER BY Reputation DESC LIMIT 100