0

Please login or register to vote for this query.

(click on this box to dismiss)

List of users with rep > 3000 and their last accessed dates

Q&A about the site for serious players and enthusiasts of chess

-- List of users with rep > 3000 and their last accessed dates
-- List of users with rep > 3000 and their last accessed dates

select id [User Link] , Reputation, CONVERT(VARCHAR, lastaccessdate, 106) as DATE
--to_char(,'DD-MON-YYYY')
from users
where reputation > 3000
order by DATE desc

fork query

created sep 9 10 anonymous