Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences
SELECT TOP 100000
p.id,p.Title,p.Body,p.Tags,p.score,a.id as "Answer ID",
a.body as "Accepted Answer",u.Reputation as "User Reputation"
,c.Text as "Comment Text",p.AnswerCount as "Answer Count",p.FavoriteCount as "fav count"
FROM Posts p
--INNER JOIN posts answers ON p.id = answers.ParentId
INNER JOIN Posts a ON p.AcceptedAnswerId = a.Id
INNER JOIN Users u ON p.OwnerUserId = u.Id
INNER JOIN Comments c ON c.PostId = p.id
WHERE p.PostTypeId = 1
and p.tags like '%python%'
and p.OwnerUserId in
(Select Id from Users where
reputation <= ##reputation1##