0

Please login or register to vote for this query.

(click on this box to dismiss)

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 
Id,
Id AS [Post Link],
Title,
AnswerCount, 
ViewCount,
FavoriteCount, 
Score,
LastActivityDate,
Tags

FROM Posts
where DeletionDate is null and
  ClosedDate is null and AnswerCount < 8

ORDER BY ViewCount DESC offset 0 rows fetch next 10 rows only

fork query

created jul 16 19 jon.doe28781