A.L.E.C napisał(a):

odpal w systemie `date -d 2005/07/15 +%s`, a następnie zamień %NOW% na to co zwróciła ta komenda, tam gdzie ? wstaw id klienta.

Oto co zwróciło zapytanie: SELECT MAX( at ) AS at, SUM( value ) AS value

FROM assignments, tariffs

WHERE tariffid = tariffs.id AND period =1 AND suspended =0 AND ( datefrom <=1121378400 OR datefrom =0 ) AND ( dateto >=1121378400 OR dateto =0 ) AND customerid =238 GROUP BY customerid HAVING SUM( value ) >0

"1";"48.80"

KL