A Database Error Occurred

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.`url`, flox_products_producers.`url`) AS `url`, COALESCE(translates.`logo`, flox_products_producers.`logo`) AS `logo`, translates.`link` AS `link`, translates.`text` AS `text`, translates.`bottom_text` AS `bottom_text`, translates.`title_tag` AS `title_tag`, translates.`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`