0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select p.Id as post_id, p.Title as title, p.Body as body, p.Score as score, p. CreationDate as creation_date, p.Tags as tags
from Posts p 
join PostTags pt on pt.PostId = p.Id  
join Tags t on t.Id = pt.TagId
where p.Id in (select p.Id
                    from Posts p
                      join PostTags pt2 on pt2.PostId = p.Id
                      join Tags t2 on t2.Id = pt2.TagId
                    where t2.TagName like 'python-requests')
                    and t.TagName like 'python%'
                    and p.Score > 0
                    
order by p.Score desc

fork query

created dec 5 23 AfiyaSarah