Repeated links on 1ns3rt

select count(*) as Count, group_concat(concat('<a href="/comment.php?id=',id,'">',id,'</a>') SEPARATOR ', ') as Posts, concat('<a href="',link,'">',link,'</a>') as URL from links group by link having Count > 1 order by Count desc

Count Posts URL
5 1320, 1509, 2174, 2307, 2484 http://modulo13.ath.cx/tom/puzzle/
3 286, 313, 577 http://adamcadre.ac/lyttle.html
3 200, 241, 243 http://www.stmargaretschurch-rainham.org.uk/youth/interact/totw.htm
2 1328, 1329 http://cgi.ebay.co.uk/Charity-Auction-Jacobs-real-hair-for-sale-JEWFRO_W0QQitemZ5648635318QQcategoryZ106319QQssPageNameZWDVWQQrdZ1QQcmdZViewItem
2 144, 254 http://modulo13.ath.cx/jlpoq.htm
2 285, 842 http://modulo13.ath.cx/mrhappy/mj/
2 2233, 2247 http://modulo13.ath.cx/tom/Tournament/cricket07.php
2 265, 266 http://www.fasco-csc.com/works/bluechamber/index_e.php
2 1303, 1304 http://www.femalefirst.co.uk/celebrity/60742004.htm
2 838, 1734 http://www.funjunkie.co.uk/the_summer_burn.cfm
2 527, 947 http://www.imdb.com/title/tt0391713/
2 39, 208 http://www.mozilla.org/products/firefox/
2 708, 1380 http://www.stmargaretschurch-rainham.org.uk/youth/index.htm
2 854, 1611 http://www.venganza.org/