Find SGA Stories in a Specific Genre

Hi looking for the following:

1. Any fics new or old (not on wraithbait) that deal with John becoming a dad? Doesn't have to be a pairing. He can save the kid from a horrible situation in Pegasus or find out he is a dad through old relationships or adopts one on Earth even alien children are fine as well. I'm open to all ideas, even mpreg I love. Pairings I like: John/Teyla, John/Elizabeth, John/Nancy, John/Sam, John/Rodney, John/Cameron. among others. I've read Finding Atlantis, Daddy's Girl, Guardian by rubycaspar and Deadly Intent.

2. Would also love any where John saves the day when SGC is under attack or slowly being invaded and it changes people's minds in the SGC who either hated/disliked him or thought awful of him for his black mark. Like Landry not liking him for disobeying and helping save Atlantis. (This is probably a long shot one, but curious).

3. Also any long one's where John saves Earth and it gets people's attention and the program becomes declassified? I've read almost all the declassified fanfics I could find of Atlantis and SG-1, but don't think I read any like this.

Looking for any fics where John is discharged and sent to prison for being in a relationship with any of the other male characters. Pairings I like: John/McKay, John/Mitchell, John/Lorne, John/Beckett, John/Ronon, ect. I'm open to any pairing. Bonus if the Atlantis crew or Stargate Command or even SG-1 team help get him out of prison. Also one's where his brother find out and helps to get him out or even if his father is alive and helps out. But would love it set when he's at Atlantis. Hurt!Sheppard from the guards that are homophobic or from prisoners are also a plus. I love reading Hurt!Sheppard fics. I read one a few days ago where John was arrested and put in front of a firing squad cause the new president was homophobic and it had the SG-1 team helping a bit and the Daedalus crew helping with SGA to get John, Teal'c and Vala free from the prison and firing squad. Which prompted me wanting more similar to this.

I've been going through the tags, and thus far not finding anything yet. Mostly prisoner fics on other planets in Pegasus. I think I tagged this correctly.


Also any where John and Rodney are together and he I guess deflects to the Canadian side to be together. I just read The Connection and it had Elizabeth getting John to think about switching to Canadian instead of being an American so they could be together. Anything like that would be awesome. Either someone tells John to become a Canadian so they don't loose him on Atlantis or John does it himself, or maybe even Rodney/the team or Jeannie tells him or gives the advice to do so.

Are their any fics where one of or John's old flying squad from back in the day that are still alive or another old one he was with come to Atlantis an find out he's in charge of the group? Bonus if his team now gets jealous. Any pairing is fine. Also big bonus if we see them flying in battle or something similar. Or he is training them to use the jumpers cause they have the gene.