0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP 256
  Id AS [User Link], Reputation, DisplayName, AboutMe
FROM
  Users
WHERE
  LOWER(AboutMe) LIKE '%great firewall%' OR
  LOWER(DisplayName) LIKE '%great firewall%' OR
  AboutMe LIKE N'%防火长城%' OR
  DisplayName LIKE N'%防火长城%' OR
  
  LOWER(AboutMe) LIKE '%tian an men%' OR
  LOWER(DisplayName) LIKE '%tian an men%' OR
  LOWER(AboutMe) LIKE '%tiananmen%' OR
  LOWER(DisplayName) LIKE '%tiananmen%' OR
  AboutMe LIKE N'%六四%' OR
  DisplayName LIKE N'%六四%' OR
  
  LOWER(AboutMe) LIKE '%falun gong%' OR
  LOWER(DisplayName) LIKE '%falun gong%' OR
  LOWER(AboutMe) LIKE '%falun dafa%' OR
  LOWER(DisplayName) LIKE '%falun dafa%' OR
  AboutMe LIKE N'%法轮%' OR
  DisplayName LIKE N'%法轮%' OR
  
  LOWER(AboutMe) LIKE '%liu xiaobo%' OR
  LOWER(DisplayName) LIKE '%liu xiaobo%' OR
  AboutMe LIKE N'%刘晓波%' OR
  DisplayName LIKE N'%刘晓波%' OR
  
  LOWER(AboutMe) LIKE '%censor%chin%' OR
  LOWER(DisplayName) LIKE '%censor%chin%' OR
  LOWER(AboutMe) LIKE '%censor%chin%' OR
  LOWER(DisplayName) LIKE '%censor%chin%' OR
  AboutMe LIKE N'%审查%' OR
  DisplayName LIKE N'%审查%'
ORDER BY Reputation DESC

fork query

edited sep 20 17 cirosantilli

created mar 19 13 anonymous