Ein Datenbankfehler ist aufgetreten

Error Number: 1054Unknown column 'translates.name' in 'field list'SELECT DISTINCT name as value, producer_id as value_id, flox_products_producers.*, COALESCE(translates.`name`, flox_products_producers.`name`) AS `name`, COALESCE(translates.`link`, flox_products_producers.`link`) AS `link`, COALESCE(translates.`url`, flox_products_producers.`url`) AS `url`, COALESCE(translates.`text`, flox_products_producers.`text`) AS `text`, COALESCE(translates.`bottom_text`, flox_products_producers.`bottom_text`) AS `bottom_text`, COALESCE(translates.`logo`, flox_products_producers.`logo`) AS `logo`, COALESCE(translates.`title_tag`, flox_products_producers.`title_tag`) AS `title_tag`, COALESCE(translates.`description`, flox_products_producers.`description`) AS `description` FROM (flox_products_producers) JOIN `flox_products` P ON `P`.`producer` = `flox_products_producers`.`producer_id` WHERE `P`.`active` = '1' ORDER BY `name`