Bitte haben Sie einen Moment Geduld...

An error has occurred

SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.TRIM(city) city' in 'field list', query was: SELECT `s`.`TRIM(city) city`, `s`.`zip`, COUNT(supplier_id) AS `cnt` FROM `suppliers` AS `s` INNER JOIN `users` AS `u` ON u.user_id = s.user_id and u.state = 2 GROUP BY `s`.`city` ORDER BY `s`.`city` ASC