Quantity of Questions Tagged With Specific Christian 'Branches of Faith'

0

Please login or register to vote for this query.

(click on this box to dismiss)

'Denominations' only apply within Protestantism, although they are primarily what is represented within this query. However, since Eastern Orthodoxy and Roman Catholicism are included, I went with 'branches of faith'.

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

select 
  tagname as [Branch], 
  count(p.id) as [#]
from 
  Posts p 
  inner join PostTags pt
    on p.iD = pt.PostId
  inner join Tags t
    on pt.TagID = t.Id
where
  p.PostTypeId = 1
  and p.creationDate > DATEADD(Month, -12, DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0))
  and (
    tagname like 'catholicism'
    or tagname like 'maronite-catholicism'
    or tagname like 'eastern-orthodox'
    or tagname like 'lutheranism'
    or tagname like 'methodist'
    or tagname like 'baptist'
    or tagname like 'southern-baptist'
    or tagname like 'reformed-baptist'
    or tagname like 'baptist'
    or tagname like 'reformed-theology'
    or tagname like 'presbyterianism'
    or tagname like 'amish'
    or tagname like 'mennonite'
    or tagname like 'pentecostalism'
    or tagname like 'oneness-pentecostalism'
    or tagname like 'non-denominational'
    or tagname like 'protestantism'
    or tagname like 'evangelicalism'
    or tagname like 'community-of-christ'
    or tagname like 'lds'
    or tagname like 'calvinism'
    or tagname like 'seventh-day-adventists'
    or tagname like 'anglicanism'
    or tagname like 'episcopal'
    or tagname like 'church-of-england'
    or tagname like 'univeralism'
    or tagname like 'charismatic'
  )
group by tagName

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results