- push @sql,
- "NOT EXISTS( ".
- "SELECT 1 FROM cust_bill JOIN cust_bill_pkg USING (invnum) ".
- "JOIN cust_pkg USING (pkgnum) JOIN part_pkg USING (pkgpart) ".
- "WHERE cust_bill.custnum = cust_main.custnum ".
- "AND cust_bill._date >= $age ".
- "AND COALESCE(part_pkg.classnum, -1) != $ignore_pkgclass ".
- ")";
+ push @sql, "
+ NOT EXISTS(
+ SELECT 1 FROM cust_bill JOIN cust_bill_pkg USING (invnum)
+ JOIN cust_pkg USING (pkgnum) JOIN part_pkg USING (pkgpart)
+ WHERE cust_bill.custnum = cust_main.custnum
+ AND cust_bill._date >= $age
+ AND COALESCE(part_pkg.classnum, -1) != $ignore_pkgclass
+ LIMIT 1
+ )
+ ";