0

Please login or register to vote for this query.

(click on this box to dismiss)

"Answers" that are likely questions Modification of: http://data.stackexchange.com/stackoverflow/s/927

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- Questions as answers
-- "Answers" that are likely questions
-- Modification of: http://data.stackexchange.com/stackoverflow/s/927

SELECT A.Id AS [Post Link], U.Id AS [User Link]
FROM Posts AS Q, Posts AS A, Users AS U
WHERE A.ParentId = Q.Id
AND A.OwnerUserId = U.Id
AND A.Score <= 0
--AND A.Body LIKE '%?%'
AND A.Body LIKE '%help me%'
AND U.Reputation <= 250
AND datediff(month, Q.CreationDate, A.CreationDate) > 3
AND (SELECT COUNT(*) FROM Posts WHERE Posts.ParentId = Q.Id) >= 1;

fork query

created jan 5 12 thkala