Q&A about the site for anime and manga fans
SELECT TOP(50) Users.Id AS [User Link], Badges.Id FROM Users LEFT JOIN Badges ON Users.Id = Badges.ID WHERE Users.Reputation = 1 AND Badges.ID = 7 AND WebsiteUrl <> '' AND WebsiteUrl IS NOT NULL AND WebsiteUrl NOT LIKE '%linkedin%' AND WebsiteUrl NOT LIKE '%wordpress%' AND WebsiteUrl NOT LIKE '%blog%' ORDER BY CreationDate DESC;