MySQL,MYSQLi: Select DISTINCT but return all columns with MAX(field)?

I am trying to create a SELECT statement that selects all (*) the fields from a table that meet the following: