SELECT distinct(code) as code, product as vertaling, count(*) as aantal, min(id) as id FROM vertalingen GROUP BY code ORDER BY id - Unknown column 'product' in 'field list'