Ended Official BYC Contest - Guess When We'll Reach 400,000 Members!

[Kiki]

THANKS!!!

I'll need to adjust the query!

This is valid and not-banned registrations per hour for the first half of April

SELECT count(*) AS total, HOUR(FROM_UNIXTIME(`register_date`)) AS hour
FROM xf_user
WHERE  `user_state` = 'valid'
AND  `is_banned` = 0
AND DATE(from_unixtime(register_date)) BETWEEN '2020-04-01' AND '2020-04-15'
GROUP BY HOUR(FROM_UNIXTIME(`register_date`))

Registrations	Hour
168	0
160	1
131	2
140	3
93	4
82	5
39	6
44	7
34	8
41	9
52	10
77	11
83	12
155	13
159	14
169	15
169	16
168	17
162	18
163	19
179	20
159	21
167	22
148	23
TOTAL: 2942

Can you compare it to last year's April?
For some reason I feel like this year there have been a lot more joining daily.

 

[ShrekDawg]

Oh why thank you! I forgot who chose 10pm today and I chose 2am today so I wonder what will happen if we hit 400k at exactly midnight. Too many variables. Today is definitely the longest day.

I chose 11pm tonight cause 10 was already taken. At this rate though, I should have chosen 9 or even 8!!

 

[ShrekDawg]

Can you compare it to last year's April?
For some reason I feel like this year there have been a lot more joining daily.

What was April last year?

A LOT less... like at least 1/2

 

[Kiki]

So, last night when I ran the numbers, I got to this date/time:

4/16/2020 8 PM EASTERN TIME

... I just ran the numbers again and got
4/16/2020 8 PM EASTERN TIME

I'm very surprised it was the same!

That's my newest best-guess, but that's based on 270 peeps joining every 24 hours at a consistent rate... which isn't really accurate.

... so, we'll just have to see what happens

Your guess does not count.
You cheated.

 

[Kiki]

Died laughing.

I haven't stopped laughing.

 

[ShrekDawg]

I haven't stopped laughing.

Me neither!!!

 

[Kiki]

I'm still playing catch up.

 

[ShrekDawg]

I'm still playing catch up.

Catch up faster!

 

[007Sean]

Catch up faster!

I don't have any tomatoes....I can't ketchup!

 

[AgnesGray]

PM me....

I like @Myshire Farm Quail

They're great people, too!