Just how badly are W3Schools answers treated?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT TOP(50)
  Posts.Id AS [Post Link],
  COUNT(Upvotes.Id) AS UpvoteCount,
  COUNT(Downvotes.Id) AS DownvoteCount
FROM Posts
LEFT JOIN Votes AS Upvotes ON Upvotes.PostId = Posts.Id
LEFT JOIN Votes AS Downvotes ON Downvotes.PostId = Posts.Id
  WHERE Upvotes.VoteTypeId = 2
    AND Downvotes.VoteTypeId = 3
    AND Posts.PostTypeId = 2
    AND Posts.Body LIKE '%w3schools%'
GROUP BY Posts.Id
ORDER BY DownvoteCount DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached