select count (*) from posts where posttypeid = 1 and id ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things

Q&A for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

select count (*) from posts where
posttypeid = 1

and id not in
(select id from posts 
where Tags like '%smart-home%' OR
Tags like '%smart-home%' OR
Tags like '%alexa%' OR
Tags like '%google-home%' OR
Tags like '%amazon-echo%' OR
Tags like '%samsung-smarththings%')

and  id not in
(select id from posts 
where Tags like '%google-home%' OR
Tags like '%amazon-echo%' OR
Tags like '%samsung-smarththings%')

and  id not in
(select id from posts 
where Tags like '%security%')

and  id not in
(select id from posts 
where Tags like '%privacy%')

and  id not in
(select id from posts 
where Tags like '%networking%' OR
Tags like '%mqtt%' OR
Tags like '%communication%' OR
Tags like '%wifi%' OR
Tags like '%protocols%' OR
Tags like '%zigbee%' OR
Tags like '%bluetooth%' OR
Tags like '%wireless%')

and  id not in
(select id from posts 
where Tags like '%hardware%' OR
Tags like '%raspberry-pi%' OR
Tags like '%sensors%' OR
Tags like '%microcontrollers%' OR
Tags like '%mosquitto%' OR
Tags like '%esp8266%' OR
Tags like '%digital-cameras%')

and  id not in
(select id from posts 
where Tags like '%definitions%' OR
Tags like '%standards%' OR
Tags like '%power-consumption%')

Enter Parameters

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