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