Zabbix (1.8) - MySQL query to select hosts NOT IN a specific group

gistfile1.sql

# Not in a single group:

SELECT host FROM hosts h
WHERE NOT EXISTS
     (SELECT groupid FROM hosts_groups hg
      WHERE h.hostid = hg.hostid
      AND hg.groupid = 100100000000001);

# Not in multiple groups:

SELECT host FROM hosts h
WHERE NOT EXISTS
     (SELECT groupid FROM hosts_groups hg
      WHERE h.hostid = hg.hostid
      AND hg.groupid IN (100100000000001,100100000000002,100100000000003,100100000000004,100100000000005) );