SELECT users.name, comment_stat.zametka, comment_stat.otkaz, comment_stat.zvonok
FROM users
          LEFT JOIN (SELECT customer.iduser
                      FROM customer
                      WHERE customer.iduser in (72)  AND Customer.datecr BETWEEN  '23.06.2011' AND '23.06.2012'
                      GROUP BY iduser ) AS company_stat ON Users.iduser = company_stat.iduser
          LEFT JOIN ( SELECT idcreator, SUM(idhisttype=0) zametka, SUM( idhisttype=47 OR idhisttype=57) otkaz, SUM( idhisttype=45 OR idhisttype=54) zvonok
                      FROM History
                      WHERE History.idcreator in (72) AND History.datecr BETWEEN '23.06.2011' AND '23.06.2012'
                      GROUP BY idcreator ) AS comment_stat ON Users.iduser = comment_stat.idcreator
          WHERE users.iduser IN (72)

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 3, char 22.
SELECT.