From 9f8fcbc5c678e168327086db8c362c52eb22f74b Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Wed, 25 Aug 2010 23:15:30 +0000
Subject: quick query on desynced bill dates, RT#9733

---
 bin/select-cust-desync_bill_dates.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 bin/select-cust-desync_bill_dates.sql

(limited to 'bin')

diff --git a/bin/select-cust-desync_bill_dates.sql b/bin/select-cust-desync_bill_dates.sql
new file mode 100644
index 000000000..5506f90ed
--- /dev/null
+++ b/bin/select-cust-desync_bill_dates.sql
@@ -0,0 +1,9 @@
+SELECT DISTINCT custnum, agent_custid, first, last, company
+ FROM cust_pkg LEFT JOIN cust_main USING ( custnum )
+ WHERE cancel IS NULL AND 0 < (
+   SELECT COUNT(*) FROM cust_pkg AS others
+    WHERE cust_pkg.custnum = others.custnum
+      AND cust_pkg.pkgnum != others.pkgnum
+      AND cust_pkg.bill != others.bill
+      AND others.cancel IS NULL
+ );
-- 
cgit v1.2.1