0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT tags.tagname,
       PQ.id,
       PQ.body,
       PQ.viewcount,
       PQ.score,
       CONVERT(date, PQ.creationdate) creationdate,
       CONVERT(date, 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

view current version

edited may 18 21

created may 18 21 anonymous