1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'diamo109_dbo.tm.manufacturers_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT tm . *, Min(p.products_date_available) as min, Max(p.products_date_available) as max, p.products_id FROM manufacturers tm JOIN products p ON ( tm.manufacturers_id = p.manufacturers_id ) GROUP BY tm.manufacturers_name ORDER BY p.products_date_available ASC