select * from ( select id, creationdate, displayname, acc...

0

Please login or register to vote for this query.

(click on this box to dismiss)

User Experience Meta

Q&A about the site for user experience researchers and experts

select *
from (
select id, creationdate, displayname, accountid
     , datediff(s, lag(creationdate) over(order by creationdate), creationdate) [diff]
     , id [User Link]
     , concat('https://stackexchange.com/users/', accountid, '|network profile') [Link]
from users
where year(creationdate) = 2023
and reputation = 1
and creationdate = lastaccessdate
and location is null 
and aboutme is null
and views < 3
and websiteurl is null
) data
where diff < 120
order by creationdate

Enter Parameters

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