with a as ( select count(v.Id) numVotes from Votes v inne...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Esperanto Language

Q&A for teachers and students of the Esperanto language

with a as (
   select count(v.Id) numVotes
   from Votes v inner join Posts p on
   v.postId = p.id
   where p.PostTypeId in (1,2)
     and v.VoteTypeId in (2,3)
), 
b as (
   select count(v.Id) numVotes
   from Votes v inner join PostsWithDeleted p on
   v.postId = p.id
   where p.PostTypeId in (1,2)
     and v.VoteTypeId in (2,3)
)

select a.numVotes
from a

Enter Parameters

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