ค้นหาภาษาบราซิลด้วยแท็กเทคโนโลยี (โหมดการจ้างงาน) ไม่จำเป็นต้องใช้ตารางทั้งหมด
Search Brazilian By Tech Tag (Hiring Mode).It is not neccessary to use all the tables.
 Posts:  Id [ number]  PostTypeId [ number]  AcceptedAnswerId [ number]  ParentId [ number]  CreationDate [ time]  DeletionDate [ time]  Score [ number]  ViewCount [ number]  Body [ text]  OwnerUserId [ number]  OwnerDisplayName [ text]  LastEditorUserId [ number]  LastEditorDisplayName [ text]  LastEditDate [ time]  LastActivityDate [ time]  Title [ text]  Tags [ text]  AnswerCount [ number]  CommentCount [ number]  FavoriteCount [ number]  ClosedDate [ time]  CommunityOwnedDate [ time]  ContentLicense [ text] 
SELECT SUM(p.Score) AS TotalScore, u.Id AS "user_link", u.Reputation, u.Location FROM Users AS u, Posts AS p, PostTags AS pt, Tags AS t WHERE t.TagName = @tag AND pt.TagId = t.Id AND pt.PostId = p.ParentId AND p.PostTypeId = 2 AND u.Id = p.OwnerUserId AND (LOWER(u.Location) LIKE '%brazil%' OR LOWER(u.Location) LIKE '%brasil%' OR LOWER(u.Location) LIKE '%br' OR LOWER(u.AboutMe) LIKE '%brasil%' OR LOWER(u.AboutMe) LIKE '%brazil%' OR LOWER(u.WebsiteUrl) LIKE '%.br' OR LOWER(u.WebsiteUrl) LIKE '%.br/%') GROUP BY u.Id, u.DisplayName, u.Reputation, u.Location ORDER BY TotalScore DESC