0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for contractors and serious DIYers

SELECT TOP 10 
    p.Title as QuestionTitle,
    p.Body as QuestionBody,
    t.TagName as Topic,
    p.ViewCount,
    u.Location as UserLocation
FROM Posts p
LEFT JOIN PostTags pt ON p.Id = pt.PostId
LEFT JOIN Tags t ON pt.TagId = t.Id
LEFT JOIN Users u ON p.OwnerUserId = u.Id
WHERE u.Location LIKE '%USA%'
  AND t.TagName IN ('trains', 'france', 'italy', 'germany', 'uk')
  AND p.PostTypeId = 1 -- Questions only
ORDER BY p.ViewCount DESC;

fork query

edited dec 12

created dec 12 anonymous