Mysql Error 1064

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Stack Overflow questions with outstanding close votes
-- A list of Stack Overflow questions with outstanding close votes, sorted by number of votes.
-- This variant displays only those questions with four or more closevotes
-- based on: http://data.stackexchange.com/stackoverflow/query/110574/
-- Only include questions that have no answers

select * FROM
(select
  Posts.Id as [Post Link],
  max(Posts.AnswerCount) as [Answer Count],
  max(Posts.AcceptedAnswerId) as [Accepted Answer],
  avg(Posts.Score) as [Score],
  count(*) as [Close Votes],
  max(Votes.CreationDate) as [Last Vote],
  min(Votes.CreationDate) as [First Vote]  
from Posts
inner join Votes on Posts.Id=Votes.PostId
where 
  Votes.VoteTypeId = 6 
  and Posts.Tags LIKE '%<mysql>%'
  and Posts.AcceptedAnswerId is NULL
group by Posts.Id
) AS Myview 
where
  [Close Votes] < 3
  and [Score] < 0
order by 
  [Score] asc, 
  [Answer Count] asc,
  [Close Votes] desc, 
  [Last Vote] asc,
  1

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results