• Ever wanted an RSS feed of all your favorite gaming news sites? Go check out our new Gaming Headlines feed! Read more about it here.

Strafer

The Flagpole is Wider
Member
Oct 25, 2017
29,355
Sweden
I want to play the game in the game.

hqdefault.jpg
 

Cat

Member
Oct 25, 2017
1,126
US
"Why do we need a start of the community"

Let the community happen organically.
 

ilium

Member
Oct 25, 2017
477
Vienna
The one time to get a Switch on tinder. What do I need to say?

I have a new Super Mario Daddy


Do Republicans Try (Spoilers)

President Trump games announced by the Russia investigation

Don DLC announced for Trump and Russia
 

Deleted member 42686

User requested account closure
Banned
Apr 26, 2018
1,847
Best ones:

-The community now a problem + ResetERA shit to the next level
This is so true that I wonder if we gonna see some kind of Skynet in terms of AI lmao

-Sonic The Sheeperder + My Sonic The Hedgehog Refused to Pay $3.29 on PS4

-What is the point of Dark Souls to the Christ Thread
 

smuguire

Member
Oct 27, 2017
591
I think I want to play Super Likes
ResetERA shit to the next level
My PS4 didn't get a reply
I want to be a trailer to be a catfish
I have a new Super Mario Daddy


This stretch killed me
 

plusaflag

User requested ban
Banned
Jan 7, 2019
625
ResetERA shit to the next level easily takes the cake.

Another wonderful experiment. Thanks a ton !
 

mute

â–˛ Legend â–˛
Member
Oct 25, 2017
25,062
This is like when I used to pass text through babelfish translate into a few different languages then back to english.
 

StereoVSN

Member
Nov 1, 2017
13,620
Eastern US
- "Resident Evil Memes are better than the PS4 and your life" - as if there was ever a doubt :P
- "When you get a single player for the senate" - clearly MP Senate is not working. Time to take it offline.

These ones were pretty good.
 

RedDevil

Member
Dec 25, 2017
4,121
Hillarious, I laughed out loud at some of those.

It seems "Switch", "Senate" and "Mario" are fairly commong topics.

And some look like legit ResetERA threads.

What do you think that the character is designed in my pants

Interesting.
 
OP
OP
May 9, 2018
3,600
Hi minimaxir,

How did you get the dump for the reddit titles? I'm interested in doing one for a subreddit.

Thanks
All the Reddit data is extracted from BigQuery, with maybe a few data range tweaks depending on what I'm doing.

Example:
SQL:
#standardSQL
SELECT
title
FROM (
SELECT
REGEXP_REPLACE(title, '&', '&') as title,
score
FROM
`fh-bigquery.reddit_posts.*`
WHERE
(_TABLE_SUFFIX BETWEEN "2016_01" AND "2018_10")
AND LOWER(subreddit) IN ('legaladvice')
AND score >= 5
AND LENGTH(title) >= 20
)
ORDER BY score DESC

(TIL Resetera has code embedding)
 

DukeBlueBall

Banned
Oct 27, 2017
9,059
Seattle, WA
All the Reddit data is extracted from BigQuery, with maybe a few data range tweaks depending on what I'm doing.

Example:
SQL:
#standardSQL
SELECT
title
FROM (
SELECT
REGEXP_REPLACE(title, '&', '&') as title,
score
FROM
`fh-bigquery.reddit_posts.*`
WHERE
(_TABLE_SUFFIX BETWEEN "2016_01" AND "2018_10")
AND LOWER(subreddit) IN ('legaladvice')
AND score >= 5
AND LENGTH(title) >= 20
)
ORDER BY score DESC

(TIL Resetera has code embedding)

NVM thanks!
 
Last edited:

Morrigan

Spear of the Metal Church
Member
Oct 24, 2017
34,299
Should I get a lawyer for the Switch?
Trump Rumble for President Announced
LTTP: Horizon Zero Party Consent Laws?
ResetEra Lord of the Deep
Is man the best game boss
My PS4 didn't get a reply
I want to be a trailer to be a catfish
Digital Foundry: I love this shit
Don DLC announced for Trump and Russia
What is the best way to respond to your characters in games
There are no sexual singleplayer games that are warm and more than 10 years?

fucking lol
 

qq more

Member
Oct 25, 2017
3,781
"Why does my Switch always really exist?"

This is a good question. Why hasn't my Switch periodically blink out of existence yet. Defective unit tbh