0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT 'https://travel.stackexchange.com/questions/' + CONVERT(VARCHAR, Posts.Id) as url,
TagName as region,
Title,
ViewCount,
Score
FROM Posts
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
WHERE TagName IN ('india', 'china', 'japan', 'europe', 'usa')
AND Posts.PostTypeId = 1
AND Score > 5
ORDER BY ViewCount DESC;

fork query

edited dec 12

created dec 12 anonymous