1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

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

fork query

edited apr 16

created jan 15 23 BMitch