SELECT not_deleted,not_closed,total FROM (SELECT Count(1)...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Worldbuilding

Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings

SELECT not_deleted,not_closed,total FROM 
(SELECT Count(1)as not_deleted, 'hello'as joinner from Posts WHERE DeletionDate IS NULL AND ParentId IS NULL) del
JOIN (SELECT Count(1)as not_closed, 'hello'as joinner from Posts WHERE ClosedDate IS NULL AND ParentId IS NULL) clo ON del.joinner = clo.joinner
 JOIN (SELECT Count(1)as total, 'hello'as joinner from Posts WHERE ParentId IS NULL)tot ON tot.joinner = del.joinner;

Enter Parameters

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