0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

SELECT
count(distinct Posts.Id)
FROM Posts
   INNER JOIN PostTags ON PostTags.PostId = Posts.Id
   INNER JOIN Tags ON PostTags.TagId = Tags.id
WHERE Tags.TagName like '%' + ##TagName:string## + '%' and PostTypeId = 1

fork query

edited may 22 22

created may 22 22 anonymous