0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for ebook publishers and readers

SELECT TOP 100
    'https://travel.stackexchange.com/questions/' + CONVERT(VARCHAR, Posts.Id) as url,
    Title,
    ViewCount,
    Score,
    CreationDate
FROM Posts 
LEFT JOIN PostTags ON Posts.Id = PostTags.PostId
LEFT JOIN Tags ON PostTags.TagId = Tags.Id
WHERE Posts.PostTypeId = 1
    AND (
        TagName IN ('insurance', 'transportation', 'local-services', 'activities')
        OR Title LIKE '%travel insurance%'
        OR Title LIKE '%local guide%'
        OR Title LIKE '%tour package%'
    )
    AND Score > 0
ORDER BY ViewCount DESC;

fork query

edited dec 7

created dec 7 anonymous