Counting actual number of posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

--select count(*) from Posts
--where posttypeid = 1
--where Title = 'open banking' or Body = 'open banking' or Tags = 'open-banking';

SELECT
COUNT(DISTINCT Posts.Id)
FROM Posts
 --LEFT JOIN PostTags ON PostTags.PostId = Posts.Id
 --LEFT JOIN Tags ON Tags.Id = PostTags.TagId
WHERE
 Posts.Tags = '%open-banking%'

Enter Parameters

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