select p.id, p.PostTypeId, p.AcceptedAnswerId, p.ParentId...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Home Improvement Meta

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;

Enter Parameters

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