select-- p2.owneruserid, v.*, null x, case when v.votety...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

-- Enter Query Title
-- Enter Query Description

select-- p2.owneruserid, 
v.*, null x, case when v.votetypeid=1 then 2 else 0 end y
from votes v
inner join posts p1 on p1.id = v.postid
--inner join posts p2 on p2.id = p1.parentid

where v.VoteTypeId = 999 -- question accepted by asker
           and (p1.id = 4788735 or p1.parentid = 4788735)

Enter Parameters

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