Low views, high votes 0 answer with tags


Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness

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


SELECT TOP 500 p.Id, p.Id as [Post Link], p.Score, p.ViewCount, t.TagName
, p.AnswerCount, p.CommentCount, p2.Id
FROM Posts p
INNER JOIN PostTags pt ON pt.PostId = p.Id
INNER JOIN Tags t ON t.Id = pt.TagId
left JOIN Posts p2 ON p.Id = p2.ParentID
WHERE p.Score > 2 AND p.ViewCount <> 0 
AND p.ParentId is null 
AND p.AcceptedAnswerId is null
AND p.AnswerCount = 0
AND p.ClosedDate is null
AND t.TagName in ('android', 'c#', 'mysql', 'database', 'php')
ORDER BY p.ViewCount asc

select top 10 * from posts where Id in (6226869, 9794132 ) 
or parentId in (6226869, 9794132 ) ;

select top 10 * from comments where PostId in (6226869, 9794132 ) 


select top 10 * from Posts order by CreationDate desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results