Low quality PHP questions with delete vote count


Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- Low quality PHP questions with delete vote count


CONCAT('https://stackoverflow.com/q/', Posts.Id), MIN(Posts.CreationDate), 
MIN(Posts.Score), MIN(Posts.ViewCount), COUNT(Votes.Id)

FROM Posts
LEFT JOIN Votes ON Votes.PostId = Posts.Id AND Votes.VoteTypeId IN (10)

WHERE Posts.Id > 20000000
AND Posts.Score < -2
AND Posts.Tags LIKE '%<php>%'
AND Posts.AcceptedAnswerId IS NULL
AND Posts.PostTypeId = 1
AND Posts.ClosedDate IS NOT NULL
AND Posts.DeletionDate IS NULL

GROUP BY Posts.Id, Posts.CreationDate, Posts.Score, Posts.ViewCount

ORDER BY COUNT(Votes.Id) DESC, Posts.CreationDate DESC, Posts.Score

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results