0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional and academic economists and analysts

select userid as [User Link], name, format(date,'yyyy-MM-dd') as dateAwarded ,format(date,'HH:mm:ss') as timeAwarded ,
displayname, location, upvotes, downvotes, reputation as Rep, creationdate as UserJoined, lastaccessdate
from badges b join users u on u.id = b.userid
where name like '%Not a Robot%' and date >= '2018-5-16'
order by  date

view current version

edited jul 16 18

created jul 16 18 ashleedawg