Beginners Questions-2


Please login or register to vote for this query.

(click on this box to dismiss)

Health Meta

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.Title,p.Body,p.Tags,p.score, 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 = 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 =
WHERE p.PostTypeId = 1
and p.tags like '%python%'
and p.OwnerUserId in 
(Select Id from Users where 
reputation <= ##reputation1## 

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results