Q&A for contractors and serious DIYers
SELECT U.Id AS [User Link] , U.Displayname AS 'Display' , U.Location AS 'Location' , U.WebsiteUrl AS 'URL' , U.Creationdate AS 'Created' , U.Lastaccessdate AS 'Accessed' , datediff(hour, U.Creationdate, U.Lastaccessdate) AS 'Duration' , U.Views AS 'Views' , U.Aboutme AS 'About Me' , U.ProfileImageUrl AS 'Profile Img' FROM users U WHERE U.Reputation = 1 AND (U.Aboutme <> '' OR U.WebsiteUrl <> '' ) AND datediff(hour, U.Creationdate, U.Lastaccessdate) < 1440 ORDER BY Creationdate desc