SELECT Distinct Posts.id AS [Post Link], Posts.PostTypeId...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language and Usage Meta

Q&A about the site for linguists, etymologists, and serious English language enthusiasts

SELECT Distinct
    Posts.id AS [Post Link],
    Posts.PostTypeId,
    Posts.Tags AS [Tagged With],
    Posts.CreationDate,
    Posts.Title,
    Posts.Body,
    u.DisplayName,
    u.Location,
    u.Views,
    u.UpVotes,
    u.DownVotes,
    u.Reputation,
    Posts.ClosedDate,
    Posts.AnswerCount,
    Posts.ViewCount,
    Posts.Score,
    Posts.DeletionDate,
    Posts.AcceptedAnswerID
FROM Users u, Posts
WHERE
     (u.Id=Posts.OwnerUserId) And
     Upper(Posts.Tags) LIKE Upper('%virtual-reality%')
Order By Posts.Score DESC;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results