Problem: I want to display the newest instead of the oldest entry in `hits` as the information in the resulting table Currently: SELECT * FROM `ip2countries` AS `Ip2country`, `hits` AS `Hit` WHERE `Hit`.`ip2country_id` = `Ip2country`.`id` GROUP BY `Hit`.`countryCode` ORDER BY `Ip2country`.`country` ASC, `Hit`.`id` DESC 73368 204.212.120.0 204.212.127.255 3436476416 3436478463 AW Aruba 176 3436477019 204-212-122-91.setardsl.aw 73368 AW 2008-04-03 16:27:55 Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13 http://www.example.com/index.php?cat=773 www.example.com HTTP/1.1 GET /company_redirect.php?c=723 17193 69.73.209.0 69.73.229.255 1162465536 1162470911 BB Barbados 89 1162469907 69.73.226.19 17193 BB 2008-04-03 16:14:12 Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13 http://www.google.com/search?q=recompensa+park+example&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a www.example.com HTTP/1.1 GET /index.php?cat=381