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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles

Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

select *
from (
select id, creationdate, displayname, accountid
     , datediff(s, lag(creationdate) over(order by creationdate), creationdate) [seconds after previous]
     , 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 [seconds after previous] < 120
order by creationdate

Enter Parameters

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