0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

WITH PPosts AS
(
SELECT   Posts.ID, Posts.PostTypeId, Posts.CreationDate, Posts.Score, Posts.ViewCount, Posts.OwnerUserId, Posts.LastActivityDate,Posts.AnswerCount, Posts.CommentCount, Posts.FavoriteCount FROM Posts
WHERE (Posts.CreationDate between '2012-03-01 10:00' and '2012-03-01 10:01')
)

select Users.ID, Users.Reputation, Users.CreationDate, Users.DisplayName, Users.LastAccessDate, Users.Location, Users.UpVotes, Users.DownVotes, Users.Age
FROM Users
where users.id in 
(select PPosts.OwnerUserId from PPosts)

fork query

created may 7 12 anonymous