Questions tagged aircraft-physics

0

Please login or register to vote for this query.

(click on this box to dismiss)

Aviation

Q&A for aircraft pilots, mechanics, and enthusiasts

select p.id as [Post Link],
tags,
c.countTags
from posts p
inner join posttags pt
  on p.id = pt.postid
inner join tags t
  on pt.tagid=t.id
inner join (select p.id, count(*) as countTags from posts p inner join posttags pt on p.id=pt.postid group by p.id) c
  on p.id=c.id
where posttypeid=1
and t.tagName = 'aircraft-physics'
order by c.countTags

Enter Parameters

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