0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain

SELECT 
    '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 TagName = 'expedia'
ORDER BY ViewCount DESC, Score DESC;

fork query

edited dec 6

created dec 6 anonymous