Pozdrawiam
Michał Korzeniowski

Media Telekom Sp. z o.o.
ul. Berka Joselewicza 3
08-110 Siedlce
tel:+48 25 7948484
mob:+48 533733249
NIP:821-264-03-46
REGON:147113865
KRS 0000499286
Sąd Rejonowy dla m.st. Warszawy w Warszawie,
XIV Wydział Gospodarczy Krajowego Rejestru Sądowego

diff --git a/bin/lms-sendinvoices b/bin/lms-sendinvoices
index e67fc77..736788b 100755
--- a/bin/lms-sendinvoices
+++ b/bin/lms-sendinvoices
@@ -235,7 +235,7 @@ $dbq = $dbase->prepare("SELECT d.id, d.number, d.cdate, d.name, d.customerid, n.
                        LEFT JOIN customers c ON (c.id = d.customerid)
                        LEFT JOIN numberplans n ON (n.id = d.numberplanid)
                        $groupjoin
-                       WHERE c.deleted = 0 AND d.type = 1 AND EXISTS (SELECT COUNT(contact) FROM customercontacts WHERE customerid = c.id AND (type & 16 > 0))
+                       WHERE c.deleted = 0 AND d.type = 1 AND EXISTS (SELECT id FROM customercontacts WHERE customerid = c.id AND (type & 16 > 0))
                                AND d.cdate >= $daystart AND d.cdate <= $dayend AND c.invoicenotice = 1
                                $groupwhere");
 $dbq->execute();