Find SGA Stories in a Specific Genre

So just got into the fandom and looking for some John/Rodney fics where: Stargate program is declassified to the public and the military find out about their relationship and giving them a hard time and people rally around them and support them. Also any where they kick them or one of them (most likely John cause he's military) Atlantis and Atlantis don't like it plus everyone supports and gets them or the one that was kicked off back.

I've read a John is a runner story (I think Running for us or with us was the name) and I liked that Todd came to his rescue and was forming an alliance/friendship with his hive ship. So any along the lines where Todd considers John family/kin or is protective of him would be awesome. I also read one where he gets taken on a Dart and is asked by the queen of Todd's ship to help with repairs cause their flight commander died and he is then named flight commander. So anything like those would be welcome, longer the better. Bonus for John/Rodney. Other pairings I also like are: John/Ronon, John/Carson and John/Elizabeth. I also like zelenka/lorne as side pairing.

Another I am looking for I've read a few John is an ancient one. And I'd really love more, maybe he gets memories of his past life when he comes to Atlantis or sits in the chair. The one I've read Rodney woke him up from stasis when they got to Atlantis and John ends up uniting the galaxy and everyone thinks he is a god/king and the IOA kidnap Rodney and Jack comes to the rescue and helps John plus John had adopted Lorne as his and Rodney's son. So any long John is an Ancient is more then welcome.

Any John/Rodney fics where John is presumed dead would be awesome. Plus one's where John's family finds out about Atlantis maybe they see them on TV after being declassified or the family comes to Atlantis and see's John in action and appreciate him more. I've read one where John's brother David comes to Atlantis to give blood to help him survive an accident and see's John and helps him a little bit during the action.

Any Kolya captures John. Where he keeps him for months, he can break or not. Bonus if McKay and the team get back at him. (Just saw the Common Ground episode and that gave me so many ideas for the John/McKay pairing if Kolya tortured him worse then just using Todd).