mysql -N -h  --user= --password= -e "select a.idnet_ser, a.hostnm, a.hosted, a.hostdm, a.host_type, a.ip_lan, a.ip_wan from aerion.vw_net_ser as a left join aerion.vw_net_ser_clone as b on a.idnet_ser = b.idnet_ser where host_type = 'client' and b.idnet_ser is null"