SELECT tags.tagname, PQ.id, PQ.body, PQ.viewcount, PQ.sco...

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,
       PQ.id,
       PQ.body,
       PQ.viewcount,
       PQ.score,
       PQ.creationdate,
       PACC.creationdate AcceptedAnswerdate
FROM   tags
       INNER JOIN posttags
               ON posttags.tagid = tags.id
       INNER JOIN posts PQ
               ON PQ.id = posttags.postid
       Left outer Join posts PACC on PQ.AcceptedAnswerId = PACC.Id
WHERE  tags.tagname in( 'vhdl' , 'verilog','system-verilog','fpga')
order by tags.tagname,score desc

Enter Parameters

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