+my $cache;
+
+#my $monsterjoin = <<END;
+#cust_main left outer join (
+# ( cust_pkg left outer join part_pkg using(pkgpart)
+# ) left outer join (
+# (
+# (
+# ( cust_svc left outer join part_svc using (svcpart)
+# ) left outer join svc_acct using (svcnum)
+# ) left outer join svc_domain using(svcnum)
+# ) left outer join svc_forward using(svcnum)
+# ) using (pkgnum)
+#) using (custnum)
+#END
+
+my $monsterjoin = <<END;
+cust_main left outer join (
+ ( cust_pkg left outer join part_pkg using(pkgpart)
+ ) left outer join (
+ (
+ (
+ ( cust_svc left outer join part_svc using (svcpart)
+ ) left outer join (
+ svc_acct left outer join (
+ select svcnum, domain, catchall from svc_domain
+ ) as svc_acct_domsvc (
+ svc_acct_svcnum, svc_acct_domain, svc_acct_catchall
+ ) on svc_acct.domsvc = svc_acct_domsvc.svc_acct_svcnum
+ ) using (svcnum)
+ ) left outer join svc_domain using(svcnum)
+ ) left outer join svc_forward using(svcnum)
+ ) using (pkgnum)
+) using (custnum)
+END
+