Q&A about the site for contractors and serious DIYers
select p.id, p.PostTypeId, p.AcceptedAnswerId, p.ParentId, p.CreationDate, p.LastEditDate, p.Score, p.ViewCount, p.Title, p.Body, p.tags, p2.CreationDate, p2.LastEditDate, p2.Score, p2.Body from Posts p join Posts p2 on p.PostTypeId = 1 and p2.PostTypeId = 2 and p.AcceptedAnswerId = p2.id where p.tags like '%tensorflow%' and p.AcceptedAnswerId != '' and p.Score >= 0 order by p.ViewCount DESC;