Questions with both [android] and [arduino] tags

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.

Stack Overflow

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results