Q&A for those who study, teach, research and apply economics and econometrics
SELECT pf.PostId as [Post Link], COUNT(*) as CVs, p.ViewCount as Views, p.Score, p.AnswerCount as Answers, p.CreationDate as Date FROM PendingFlags pf INNER JOIN Posts p ON p.Id = pf.PostId WHERE FlagTypeId = 14 AND CloseAsOffTopicReasonTypeId = ##CloseAsOffTopicReasonTypeId?4## GROUP BY pf.PostId, p.Score, p.ViewCount, p.AnswerCount, p.CreationDate ORDER BY CVs DESC, p.ViewCount DESC