select from hosts where status in (0,1)

select * from hosts where status in (0,1);

status explanation:

 0, HOST_STATUS_MONITORED - Host is monitored
 1, HOST_STATUS_NOT_MONITORED - Host is not monitored
 3, HOST_STATUS_TEMPLATE - The record is template
 5, HOST_STATUS_PROXY_ACTIVE - The record is active proxy
 6, HOST_STATUS_PROXY_PASSIVE - The record is passive proxy