6 select count(*) from cust_main where
7 0 < ( SELECT COUNT(*) FROM cust_pkg
8 WHERE cust_pkg.custnum = cust_main.custnum
9 AND ( cust_pkg.cancel IS NULL
10 OR cust_pkg.cancel = 0
13 OR 0 = ( SELECT COUNT(*) FROM cust_pkg
14 WHERE cust_pkg.custnum = cust_main.custnum
16 " | psql -U freeside -q $domain | head -1