0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

SELECT 
  users.Id,
  users.Reputation,
  users.CreationDate,
  users.DisplayName,
  users.LastAccessDate,
  users.WebsiteUrl,
  users.Location,
  users.AboutMe,
  users.Views,
  users.UpVotes,
  users.DownVotes,
  users.ProfileImageUrl,
  users.EmailHash,
  users.AccountId
FROM users
LEFT JOIN posts 
  ON posts.OwnerUserId = users.Id
WHERE location LIKE '%Latvia%'
  AND users.views > 100
  AND posts.CreationDate > 2021
ORDER BY views DESC

fork query

edited apr 12

created apr 12 anonymous