3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Drupal developers and administrators

SELECT 
  Id AS [User Link], 
  Reputation, 
  Views,  
  CreationDate,
  CASE 
    WHEN Reputation = 1 THEN 'true' 
    ELSE 'false' 
  END AS 'BanHammered'
FROM [Users] 
  WHERE LOWER(AboutMe) LIKE '%freedom.zulipchat.com%' 
  ORDER BY Views DESC;

fork query

edited may 23 19

created may 23 19 KirAntipov