Q&A about the site for expert genealogists and people interested in genealogy or family history
SELECT TOP 10* 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