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
[TEP STOP]