Query – One of each colour, highest ID of each – ‘Group By’ and ‘Order By’

This selected one of each colour, showing the highest id of each, where the website was called Codehaven.

SELECT * FROM (SELECT * FROM table1 WHERE website LIKE '%Codehaven%' ORDER BY id DESC) AS t GROUP BY colour