0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT TOP 500 u.id AS UserId,
       u.Reputation,
       u.CreationDate AS AcctCreationDate,
       u.LastAccessDate,
       u.Views AS ProfileViews,
       u.downvotes,
       p.id AS PostId,
       p.PostTypeId,
       p.Score,
       p.closeddate
       FROM users u
LEFT JOIN posts p ON u.id = p.owneruserid
ORDER BY RAND();

fork query

edited dec 2

created dec 2 anonymous