[lms] Re: problem z mailingien

Waldi wrote:

  Zapytanie: SELECT customers.id AS id, email, CONCAT(lastname, '

', customers.name) AS customername, pin, COALESCE(SUM((type * -2 + 7)

• value),

0.00) AS balance FROM customers LEFT JOIN cash ON (customers.id=cash.customerid AND (type=3 OR type=4)) LEFT JOIN customerassignments ON (customers.id=customerassignments.customerid) WHERE deleted = 0 AND email != '' AND customergroupid=4 GROUP BY email, lastname, customers.name, customers.id, pin ORDER BY customername Błąd: Unknown column 'type' in 'field list'

pobierz poprawiony modules/mailing.php z cvsu