All questions tagged with three tags, formatted for copying out links

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Tag1: All questions tagged with:
-- Tag2: .. and with:
-- Tag3: .. and with:
DECLARE @Tag1 nvarchar(100) = ##Tag1:string##
DECLARE @Tag2 nvarchar(100) = ##Tag2:string##
DECLARE @Tag3 nvarchar(100) = ##Tag3:string##

SELECT --q.Title as 'Name', 
       q.Id as 'Id', 'http://chemistry.stackexchange.com/q/' + CAST(q.Id AS nvarchar(15)) AS 'Link'
       --q.Tags AS 'Tags'

FROM Posts q

WHERE q.PostTypeId = 1 AND q.Tags LIKE '%<' + @Tag1 + '>%'
                       AND q.Tags LIKE '%<' + @Tag2 + '>%'
                       AND q.Tags LIKE '%<' + @Tag3 + '>%'

ORDER BY q.Id ASC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results