So, now that I've got a full SQL setup with a full PostgreSQL industry standard database with fully cleaned data, I'm doing some preliminary non-algorithmic queries on reviews of media from the dataset I posted earlier, and I wanted to share some illuminating things I found

And by "illuminating," I mean, "my god, media consumers are terrible and you cannot claim that I am caricaturing or making sh*t up. These people are real individuals, not bots, and they are writing this sh*t.

Let me share some purely numeric data first

So again, I have looked at a total of 21 media, 4 movies and 17 video games, all released since 2010. I selected PS4 exclusives that aren't remakes, plus very prominent PS4 titles that aren't new or exclusive strictly (RDR2 and Final Fantasy 7 Remake)

The dataset contains three "flash points" that were review bombed and are primary areas for deep learning modeling (Captain Marvel, The Last Jedi, and The Last of Us Part II) and a bunch of "controls" that should be expected to behave normally, more or less

So, anyway, I decided to query the database for each game or movie and find out some things about one word: "lesbian". First, just a count of how many times it was used in any of the (about 500K) reviews, if it was used.

Second, if it was used, the date when it was used. (I had a hypothesis, and it was wrong.) Third, the review score and the actual text.

For everything except TLOU2 and - interestingly - The Last Jedi, there were few enough instances that I could review the text manually

So, here's the numbers:
Captain Marvel: 9 uses
Days Gone: 2 uses
Ghost of Tsushima: 9 uses
The Last of Us Part II: 743 uses
Order 1886: 1 uses
TLJ: 29 uses

Now, this surprised me a little, and increased my hunch that there were some "late reviews" influencing the dataset. As in: Days Gone, I had been told, was itself a sort of "anti-SJW" game, why would lesbians be mentioned? I figured,probably reviews from after TLOU2,spilling over

But when I queried the dates, every mention of the word "lesbian" was in line with the release date of the game/movie. No one in the dataset went back and posted something like "oh thank god Spiderman PS4 doesn't have lesbians, unlike that Naughty Dog trash"

So, I ran a query to get the review score and the text of the reviews for everything except the ones with a f*ckton of instances of "lesbian" (TLOU2 and TLJ) which I'll have to use ML to find stuff out about

And I am starting to develop a new theory about how not to deal w chuds

So, Days Gone is an interesting place to start. (I'm saving Captain Marvel for last bc it's a weird anomaly and for that reason extremely informative.) Turns out there's some lesbian NPCs, and one guy gave it a 4 bc that annoyed him. >

But the other reviewer was annoyed that a lesbian had reviewed the game, and gave it a 10 to spite her (bc she had criticized her.) He had things to say about Anita Sarkeesian. The usual. I'll come back to this pattern, which seems normal and expected, but there's... a thing.

Ghost of Tsushima had 7 reviews that were saying, well, here's one verbatim, the most succinct of more or less identical content:
"This is great game with out lesbian and gay. Recomended all to bay. Baying this game you support normal people"

There were then two other reviews that noticed that Ghost of Tsushima in fact did not lack lesbian and gay characters, and were extremely pissed because as We All* Know** Japan*** Did Not Have Any Of That In Samurai Times ****

You might be noticing a pattern emerging by now? I'll try to state it plainly before I get into Captain Marvel (I'm not sure what's up with TLJ, probably Holdo? and obviously there's a completely mundane reason for the word appearing so much for TLOU2)

The pattern is that these guys do not necessarily see the absence of LGBT content as a plus, and they don't necessarily notice if it is in there (several reviewers of Ghost of Tsushima & Days Gone who were very homophobic didn't notice the gay people). It's about spiting the libs

So anyway, Captain Marvel. I was really confused, and still am, why it only got 9 references to "lesbian" and TLJ got 29. Holdo's a minor character (assuming she's the reason) and has about the same amount of wink wink nudge as Carol, the main character of CM. So.

So this is where I start to expand my hunch that might actually be right:

Captain Marvel's reviews that mention "lesbian" are mostly negative or mixed

AND

They're saying the filmmakers/studio are cowardly for not making it text

So, the hunch: (cont'd)

The people who mostly on their own notice media representation of LGBT people, *at least when it's _mostly_ a secondary element, I'm not sure if this would apply to TLOU2*, are not homophobes but LGBT people. And we notice more when it's absent. >

Meanwhile, my theory that the homophobes are being riled up to even talk about this stuff by YouTubers and ch*ns is absolutely vindicated by what I've found so far (I'll need to run sentiment analysis on a wide spectrum of LGBT words to be sure)

Like, when you could screw people of the same sex in Fallout 2, I highly doubt it caused more than one surprised or possibly irate Usenet thread (I could check, Usenet archives are public!)

It isn't actually normal for people to pop in a video game and ask "are there gays, anywhere, in this game?" (Unless they're me, then it's very normal.) And the people who do have a predisposition to do that are going to be the folks in the community, not our enemies

So anyway, I think all of this is good news for the possibility that I can find computational evidence that a lot of outraged video game reviews are artificially produced not by inherent prejudice (which reviewers may or may not have) but by outside influences causing them >

> to leave reviews at all, or to think about these issues when they write the reviews.

I mean these people had more to say about a couple of minor questgivers in Days Gone & Ghost of Tsushima than I did about the entire gayness of Gideon the Ninth. That's weird.

OK, let's dig in and find out the context for "lesbian" in 29 reviews of The Last Jedi! You excited! I'm excited*

*want to puke already

"The heroes are *almost* entirely women\\, a lesbian\\, an asian\\, and a black man\\, while the antagonists are all white males. Trying to say something there Kathleen Kennedy and Rian Johnson...?" standard pattern, check

"Why didn't Admiral Lesbian Purple-Hair tell Poe of her plans? Just to watch him risk his life and the lives of everyone else in the rebellion? FFS\\" normal, check

(from someone who identifies himself as a white supremacist in the review text) "share a big interracial smooch with Finn and spend the remainder of her life dominating Finn to make the lesbian feminist viewers of the movie have wet panties and fulfill their anti-male agenda."

(i don't think he gets how lesbians work)
"fuck you\\, you have to watch the new lesbian admiral\\, and all the minority characters take out the white men and greedy capitalists."

"the creatures on Luke's island\\, the way Luke is written out at end\\, the professional horseback riding by Finn and his female asian associate when she had never ridden before in her life\\, the lesbian-inferred hand holding with Leia\\, >

">the military government industrial complex concept with the casino planet\\, the excessive use of females in combat roles who do not look the part (should be butch rather than effeminate)\\, the list goes on."

oookay
"I also think that Rian Johnson hinted to her being an admiral only because she is the secret lesbian lover of her majesty Princes Leia. ... Pretty clear\\, isn't it? Homosexuals are even worse than women!"

"Laura Dern plays Admiral Holdo\\, who apparently took some time off from selling homemade jewelry at the farmer's market to talk down to Poe Dameron\\, keep pointless secrets\\, be Leia's secret feminist lesbian lover\\, and crash a cruiser at lightspeed." check

"now all the Resistant Commanders are female and led by a purple-hair lesbian (real subtle there Johnson)." check
"Now for Admiral purple hair. Another pointless character. A nod to the Millennial generation\\, feminazi movement\\, and a hint that her and Leia are lesbian lovers"

I think it's kind of awesome that the chuds agree with me that Holdo and Leia have a thing, when most progressive fans are like "eh, Disney wouldn't do that." It's sort of a fascinating dimension to the cowardly little game Disney is playing, and maybe evidence they should stop

This one breaks the mold, and illustrates what I just said: "Also on an unrelated note\\, where were the gays come on just want one space gay in a sci-fi movie as a giant lesbian. Not the worst but no that good. I mean\\, why give the fans what they want?"

Kinda mixed reviewer here.
"He eventually mutanies after Leia does an impression of Mary Poppins and command is turned over to Laura Dern who the internet tells me is a lesbian because she has blue hair\\, because no one else in the Star Wars universe has weird looking hair."

A very sensitive gentleman with some... interesting assumptions:
"I had thought Rose was a lesbian whose lover died in the beginning. It was her sister I guess\\, but who cares."

"I don't want this movie to waste anymore of my time.\\n\\n1 star because I read RT doesn't count 1/2 stars. They are too busy buying off the \\""real\\"" critics it seems.",1
"Leia is now a LESBIAN! (Thats what they were implying when she and that Purple Haired cow held hands.)\\"

Someone clearly understood the tactical situation at the end here:
"Her only point in the movie is to show Poe that Lesbian women are better know his place.. which is odd concerning her plan fails? meaning in an SJW film they conflicted her own meaning. well done."

"The lesbian admiral that kills everybody just to suicide herself at light speed. Witness meeee!!! If anybody should have sacrificed and become a martyr it should have been Leia or even Admiral Ackbar who just fucking died and that's it nobody gave a shit. [hashtag]itsatrap"check

"The movie has zero respect for content that relates to the characters that came before\\, for example Princess Leia now has Lesbian undertones\\," check

"The only people I can imagine likely this is SJW\\, purple headed lesbians\\, younger audiences that like shiny things with no substance\\, and those who can't discern between a good and bad story." not a direct Holdo reference, but clearly alluding

"progressive agenda is too obvious/ takes you out of story and into metaphor land\\, worthless storylines (Fin and Rose)\\, purple haired lesbian (not there to be a hero\\, but to seek light- Leia... fucking cringeworthy dialogue)\\," wut? seek light?

"Btw\\, this opinion is held by my sister\\, a transwoman lesbian liberal\\, so no it wasn't catering to SJW. We also both agree that there is absolutely no way that Rey would not have fallen to the Dark Side\\" mhm. right. your sister. i definitely believe you.

"It is so original that it copies nearly verbatim entire themes and scenes from the movies of the original trilogy. It is so bold that it hints at a lesbian relationship between admiral Holdo and Leia Organa but it does not dare to let them share a passionate kiss as they part."

that last is a good example of some of the Captain Marvel reviews that were sincerely upset with the filmmakers' cowardice

"blatantly diverse cast and a strongly implied lesbian relationship is not \\""bold filmmaking.\\"" It's pandering." check check

"I fear that in the next installment of the saga we will see a handicapped jedi on a wheelchair\\, obviously woman\\, obviously black/[REDACTED BY ME]/[REDACTED BY ME]/aborigen\\, maybe bisexual/transgender/gay/lesbian/metrosexual\\, hopefully with asperger's or ADHD."OBVIOUSLY WOMAN

"feel like I was watching Sesame Street meets \\""The View\\""\\,meets a college student trying to complete his student film\\, just after he completed his sociology and lesbian dance theory class. It's getting old and I will no longer give this franchise my money.",1"

I bet he gave the franchise his money

"This was orchestrated to have Leia become Admiral and her Lesbian lover Holdo as General who no one on the ship knew she existed.\\n5." check

" Poe is dealing with an SJW feminist lesbian who refuses to tell the crew of their ship her \\""big plan\\"" while they all get killed just for the sake of making the men on board look like complete ass hats\\" check

"Leia flies through space like superman. A purple haired lesbian saves the day\\, sort of." check

"And I'm \\""not a true fan\\"" per these soyboys and lesbian dance studies majors." OK see here's where my algorithmic methods should help. Someone, probably a YouTuber, used the phrase "lesbian dance studies" and incited some of these reviews. It should be possible to find >

> other commonalities between them

"What is this thing? A lesbian fantasy film?\\n\\nRemember when Star Wars had strong lady leaders who actually briefed the troops and told them what they were up against?" ah yes, the primary trait of the lesbian, not briefing people on what they are up against

"Total SJW movie! Felt like they alluded to Princess Leia as being a lesbian with the pink hair loser." at least your compatriots were able to tell what her hair color was, Jesus f*ck

"Leia has to join the purple-haired transparently feminist Holdo\\, her apparent lesbian lover\\, in re-educating their star pilot to refrain from his childish obsession with shooting at the enemy." check. OK, that's it. My priors are confirmed

I have some math to do, give me a second. OK, so adjusting for number of reviews sampled, The Last Jedi had roughly 10% as many mentions of the word "lesbian" in user reviews as did The Last of Us Part II.

The Last Jedi did not confirm Holdo as queer in the text, and certainly did not actually confirm her relationship with Leia, even though I totally think the chuds are right and Johnson wanted to imply that.

TLOU2 had two queer relationships and a trans character. >

As a result, they had ten times more use of the term "lesbian" in user reviews, *but since it was text, those uses were at least in significant part neutral or positive*. Meanwhile, the two titles received roughly equal backlash, but if I had to pick one, TLJ was hit harder

This coy bullsh*t isn't protecting companies' bottom line, we have living proof in the form of Once Upon a Deadpool that China isn't the cause of this, and the chuds can read subtext, apparently *better* than progressives.

As much as I feel TLOU2 was treated unfairly, TLJ was ultimately a disaster for Star Wars, not because of what it was but because of how it was treated and how nobody was stood by or protected.

TLOU2 is the most awarded game of all time, which I dearly hope and mostly believe will shield Naughty Dog from "hey, can you do the thing again, but without all the 'controversial stuff'"

TLJ's studio folded under the pressure and became even less progressive.

(I haven't pulled reviews for Rise of Skywalker, but if I had to guess, I would guess that we would find the word "lesbian" was largely associated not with outraged chuds who were mad that they had to see a two second smooch, but progressives who agree that was cheap&not enough)

Also, note how absolutely no one in these reviews has expressed concern "as a parent" for kids being exposed to whatever

And, you know, parents of kids who consume this stuff are my age or a bit older. They do use these sites.

The "moral majority"isn't on this bullsh*t anymore