Regex Questions With Pending Close Votes

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
    pf.PostId as [Post Link],
    COUNT(*) as CVs,
    p.ViewCount as Views,
    p.Score,
    p.AnswerCount as Answers,
    p.CreationDate as Date,
    (COUNT(*) * 5 - p.Score - (p.ViewCount / 100)) as Hatedness,
    AVG(pf.Id) as ids
FROM
    PendingFlags pf
INNER JOIN
    Posts p
ON
    p.Id = pf.PostId
WHERE
    p.Tags LIKE '%regex%'
AND
    ClosedDate IS NULL
GROUP BY
    pf.PostId, p.Score, p.ViewCount, p.AnswerCount, p.CreationDate
ORDER BY
    Hatedness DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results