SELECT t.tagname, COUNT(*) FROM Posts p Inner Join post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Great Outdoors

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

-- Enter Query Title
-- Enter Query Description


SELECT t.tagname, COUNT(*) FROM 
Posts p Inner Join posttags pt
on p.id = pt.postId
inner join tags t
on pt.tagid = t.id
where tagname = 'mysql'
group by tagname

Enter Parameters

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