0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

SELECT 
    'https://travel.stackexchange.com/questions/' + CONVERT(VARCHAR, Posts.Id) AS url,
    Title, Score, ViewCount, CreationDate
FROM Posts
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
WHERE TagName = 'travel'
ORDER BY Score DESC;

fork query

edited dec 6

created dec 6 anonymous