From: ivan <ivan>
Date: Wed, 25 Aug 2010 23:15:30 +0000 (+0000)
Subject: quick query on desynced bill dates, RT#9733
X-Git-Tag: TORRUS_1_0_9~341
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=9f8fcbc5c678e168327086db8c362c52eb22f74b

quick query on desynced bill dates, RT#9733
---

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
+ );