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 100
    'https://stackoverflow.com/questions/' + CONVERT(VARCHAR, Posts.Id) as url,
    Title,
    ViewCount,
    Score
FROM Posts 
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
WHERE TagName = 'travelport-api'
    OR TagName = 'booking.com-api'
ORDER BY Score DESC;

fork query

edited dec 6

created dec 4 anonymous