Beginners Questions-2

0

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.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## 
)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results