SELECT tags.tagname, Count(PQ.id) AS QuestionCount, Count...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT 
       tags.tagname,
       Count(PQ.id) AS QuestionCount,
       Count(PQ.acceptedanswerid) AS AcceptedAnswerCount,
       Sum(PQ.viewcount) AS ViewCount,
       Sum(PQ.answercount) AS AnswerCount
       
FROM   tags

JOIN posttags
              ON posttags.tagid = tags.id
JOIN posts PQ
              ON PQ.id = posttags.postid
              
WHERE  tags.tagname in( 'vhdl' , 'verilog','system-verilog','fpga')

Group By tags.tagname

Enter Parameters

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