mysql> desc element_sportspage;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| sportspage_id | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| publish_name  | varchar(255)     | NO   |     |         |                |
| element_uid   | int(11)          | NO   |     |         |                |
| element_gid   | int(11)          | NO   |     |         |                |
| navigation_id | int(11) unsigned | NO   | MUL |         |                |
| body          | text             | YES  | MUL | NULL    |                |
| userImage     | int(11) unsigned | YES  |     | NULL    |                |
| school        | int(11) unsigned | YES  |     | NULL    |                |
| sport         | int(11) unsigned | YES  |     | NULL    |                |
| dateStart     | datetime         | YES  |     | NULL    |                |
| dateEnd       | datetime         | YES  |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
11 rows in set (0.01 sec)


I want to select all fields from that table, but only one of each `sport` - namely the one with the highest `dateEnd`

Possible?