I have to agree with what has already been posted, so I'll add some that are different.

Promises Writ in Indelible Ink by Sardonicsmiley
http://smiley.zonezine.net/html/37160.html
It's sort of a everyones Love of Rodney but no sex.

But Never The Night by Lavvyan
When Rodney is culled, John suddenly has to deal with the loss of his best friend. As for Rodney he’s alone on a planet with no way home.
http://www.wraithbait.com/viewstory.php?sid=4627

I Am Your Image Dressed As The World by mirabile_dictu. I just love the Winnebago. John has Rodney's picture on the window of the puddle jumper.
http://mirabile-dictu.livejournal.com/66173.html