0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers of open-source hardware and software that is compatible with Arduino

SELECT p.Id,  p.Title, COUNT(ptag.TagId) as TagsCount
FROM PostTypes ptype  
		JOIN Posts p ON p.PostTypeId= ptype.Id
		JOIN PostTags ptag ON ptag.PostId = p.Id
	            JOIN Tags t  ON t.Id = ptag.TagId
WHERE ptype.Name = 'question'  AND t.Count >= 5
GROUP BY p.Id, p.Title;

fork query

created jan 20 18 anonymous