Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 155 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

http://data.stackexchange.com/stackoverflow/q/92981/

It does not seem to care what the filter is

where v.VoteTypeId = 999 -- question accepted by asker

All v.VoteTypeId still show in the result

share|improve this question
up vote 4 down vote accepted

It's just that the rows found are all matching this part of the WHERE clause:

and p1.id = 4788735 or p1.parentid = 4788735​​

If you comment that out:

where v.VoteTypeId = 999
-- and p1.id = 4788735 or p1.parentid = 4788735​​

you'll see you get nothing that matches just v.VoteTypeId = 999.

Perhaps you intended:

where v.VoteTypeId = 999
and   ( p1.id = 4788735 or p1.parentid = 4788735​​ )
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .