0

Please login or register to vote for this query.

(click on this box to dismiss)

Grab all questions with both Android and Arduino tags asked on or after the specified date.

Q&A for professional and enthusiast programmers

DECLARE @AndroidTagId INT = (SELECT Id FROM Tags WHERE TagName = 'android')
DECLARE @ArduinoTagId INT = (SELECT Id FROM Tags WHERE TagName = 'arduino')

SELECT Id as [Post Link], CreationDate
FROM Posts
WHERE 
PostTypeId = 1
AND EXISTS (SELECT 1 FROM PostTags WHERE PostId = Posts.Id AND TagId = @AndroidTagId)
AND EXISTS (SELECT 1 FROM PostTags WHERE PostId = Posts.Id AND TagId = @ArduinoTagId)
AND CreationDate >= '##date##'
ORDER BY CreationDate DESC

fork query

edited feb 13 13

created feb 13 13 Adam Lear