1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

DECLARE @Tag NVARCHAR(50) = ##Tag:string##
SELECT TOP 15000 q.Id AS [Post Link],
    q.ViewCount,
    q.Tags
FROM Posts AS q
LEFT JOIN Posts AS pq ON q.ParentId = pq.Id
WHERE q.PostTypeId = 1 -- Only retrieve questions
    AND q.Tags LIKE '%' + @Tag + '%' -- Filter by the provided tag
ORDER BY q.ViewCount DESC

fork query

created jul 2 23 galacticninja