I'm trying to query out potential profile spam on Blender Stack Exchange using the following query on https://data.stackexchange.com/blender/query/new. It's not perfect since I'm still just testing out this Stack Exchange feature:
This is the query:
SELECT u.Id AS [UserId], u.DisplayName, u.Reputation, u.WebsiteUrl, u.AboutMe, u.Location
FROM Users u
WHERE u.WebsiteUrl != ''
AND u.AboutMe LIKE '%[0-9][0-9][0-9][0-9][0-9]%'
AND u.Reputation = 1
AND u.Location != ''
AND u.DisplayName LIKE '% %' -- Checks if there is at least one space in the DisplayName
GROUP BY u.Id, u.DisplayName, u.Reputation, u.WebsiteUrl, u.AboutMe, u.Location
But I noticed that some profiles don't show up in the query result like this profile with User ID 195420 (I hope nobody edits it just yet)
Here's the query result. What am I doing wrong?
EDIT/UPDATE Just to give some context:
Thanks to @Thomas Owens's answer. So I guess the only way to parse out profile spam on a daily basis is to use client side JavaScript scraping? No other solution?
I want to use these results to populate a Profile Spam Detector chrome extension in real time, check maybe every 5 minutes and populate the list. In this list I can easily click the profile and manage/delete it. This is what I have so far using JavaScript scraping the new users page 1. I'm looking into UserStalker to see if perhaps it's a potential solution to send notification to the chrome extension.
