spam-like user profiles

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- RCEP profiles
SELECT
  U.CreationDate
  --,U.LastAccessDate -- generally the same as CreationDate
  ,U.Reputation AS REP
  ,U.Id AS [User Link]
  ,U.DisplayName
  ,U.AboutMe
  ,U.Views
  ,U.UpVotes
  ,DownVotes
FROM Users U
WHERE U.AboutMe COLLATE Latin1_General_BIN LIKE '%RCEP[^A-Z]%'
;
-- Creation Dates
-- There's a huge spike near 2022-04-13
SELECT
  CONVERT(DATE, MAX(U.CreationDate), 101) AS DateCreated
  ,COUNT(U.Id) AS CreatedCount
FROM USERS U
WHERE U.AboutMe COLLATE Latin1_General_BIN LIKE '%RCEP[^A-Z]%'
GROUP BY CONVERT(DATE, U.CreationDate, 101)
ORDER BY DateCreated ASC
;




-- AsianInvent2020 profiles
SELECT
  U.CreationDate
  --,U.LastAccessDate -- generally the same as CreationDate
  ,U.Reputation AS REP
  ,U.Id AS [User Link]
  ,U.DisplayName
  ,U.AboutMe
  ,U.Views
  ,U.UpVotes
  ,DownVotes
FROM Users U
WHERE U.AboutMe COLLATE Latin1_General_BIN LIKE '%AsianInvent2020%'
;
-- Creation Dates
-- Small window. Spikes at 2021-12-07
SELECT
  CONVERT(DATE, MAX(U.CreationDate), 101) AS DateCreated
  ,COUNT(U.Id) AS CreatedCount
FROM USERS U
WHERE U.AboutMe COLLATE Latin1_General_BIN LIKE '%AsianInvent2020%'
GROUP BY CONVERT(DATE, U.CreationDate, 101)
ORDER BY DateCreated ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results