0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

/*Neřeším nevyplněné p.owneruserid= uzivatel byl smazan
Neřeším smazané posty
*/

SELECT
  count(1)
from users u
where not exists(
SELECT 1
FROM POSTS P
WHERE PostTypeId in (1,2)
and  p.ownerUserId =u.id)
;
--vysledek: 20864072
--co je post? https://meta.stackexchange.com/questions/40353/stack-exchange-glossary-dictionary-of-commonly-used-terms/256420#256420
-->Answer or Question -> PostTypeId in 1,2

view current version

edited sep 20

created sep 20 jon.doe45742