0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people looking to bypass life's everyday problems with simple tricks

SELECT TOP 1
    'https://travel.stackexchange.com/questions/' + CAST(Posts.Id AS VARCHAR) AS url,
    Posts.Title, Posts.ViewCount, Posts.Score
FROM Posts
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
WHERE Tags.TagName = 'travel' -- Replace 'travel' with the relevant tag
ORDER BY Posts.ViewCount DESC, Posts.Score DESC;

fork query

edited dec 6

created dec 6 anonymous