How often each tag is used together with a given tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

select
  t.tagName,
  count(t.tagName) as tagCount
from
  posts p
  inner join posttags pt on pt.postid = p.id
  inner join tags t on t.id = pt.tagid
where
  p.tags like '%<##tag?php##>%'
  and p.posttypeid = 1
  and t.tagName != 'php'
group by
  t.tagName
order by
  tagCount DESC

Enter Parameters

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