To celebrate the birth of a new query...
-
Continuing the discussion from Can we have a Hanzo badger?:
Ewww...
WITH auto_closed_topics AS ( /* this clause will change */ SELECT 1923 topic_id UNION ALL SELECT 2825 topic_id ), closing_post AS ( SELECT MAX(post_number), id post_id, topic_id, created_at FROM posts p WHERE topic_id IN ( SELECT topic_id FROM auto_closed_topics ) AND post_type=2 AND raw ILIKE 'This topic was automatically closed after %' GROUP BY id, topic_id, created_at ), nate_posts AS ( SELECT p.user_id, p.post_number, p.id post_id, p.topic_id, p.created_at, p.raw, row_number() OVER (PARTITION BY p.topic_id ORDER BY p.created_at DESC) as rank FROM posts p JOIN closing_post cp ON p.topic_id=cp.topic_id AND p.created_at > cp.created_at - INTERVAL '1 minute' AND p.id != cp.post_id ) SELECT user_id, post_id, created_at granted_at FROM nate_posts WHERE rank=1 ```</blockquote> ... another competition. <!-- c0a906d0-be88-11e4-bb52-0800200c9a66 -->
-
-
Well I want to see how the query copes with an open topic...
-
Wait… a topic in which it's not just appropriate, but encouraged to spam?
Well then! Let's get started!
*runs out of things to say*
-
Well the spamming usually happens closer to when the topic is set to close, not when it first opens (unless the two are close together of course..)
-
Well I didn't see the Disconotification about auto-closing before I posted here, so I was just taking precautions in case you set it to a minute or something... :P
-
-
Penultimate-
Yeah,
nate_posts
doesn't make sense
-
Don't worry, he's just the cousin of
snoop_posts
-
Unless he meant to write
mate_posts
and simply @accalia'd…
-
Unless he meant to write mate_posts and simply @accalia'd…
This. Ultimate, penultimate, antepenultimate.
-
That makes sense. It really caught my eye, because it's my son's name, and I'm pretty sure he isn't posting here, though I think he'd like to.
-
But would he spam as much as
youme?
-
Would anyone other than @accalia ?
-
Does looking up the closing date/time count as cheating?
-
Does looking up the closing date/time count as cheating?
It's not even the only avenue for (potential) cheating either....
-
-
-
Yeah - but you said
spam
and not
post
[ insert shot through the heart image / sad hedgehog clown below ]
-
-
Amended.
-
-
With the hat. Always with the hat.
-
but without the hat means that the user can ad-hoc hat the image to suit the occasion.
:-P
-
But with the hat, it looks a little more 'street'…
Hm.
How about a variety of them, all with different hats? I'm sure between you, me, and @abarker, we can create a veritable collection
-
But with the hat, it looks a little more 'street'…
Hm.
How about a variety of them, all with different hats? I'm sure between you, me, and @abarker, we can create a veritable collection
This hat thing is turning into a hobby.
-
-
This topic will automatically close in 5 days.
5 days! Come one! Who has a memory span that long!
-
Well, @PJH could make it a pinned topic…
-
Or we could just spam it tot the top fort 5 days
-
-
That vixen sure loves to pass that 'skill' on
hmm ... forgot to switch the keyboard from dutch to english on mobile ... no spelling errors it just got Belgium-ed
-
Right.... I'll have to remember that excuse. :-P
-
Your keyboard has a Dutch setting?
-
Why not? My mobile keyboard has an Arabic setting!
-
Why not? My mobile keyboard has an Arabic setting!
Comrades, we'd better watch this one. Might run to Syria soon.
-
-
-
Comrades, we'd better watch this one. Might run to Syria soon.
I was born the day Hezbollah was founded, so……nah; I'm too busy doing far more important things, like posting on WTDWTF
-
Neo? Does that one provide a keyboard containing only characters needed to spell WOAH! ?
-
There needs to be a WTDWTF layout; it'd have keys for
Filed Under
,TDEMSYR
, and stuff like that
-
Neo? Does that one provide a keyboard containing only characters needed to spell WOAH! ?
No idea.
-
-
I think @accalia's way past excuses now anyway.
-
Won't stop her using them though ;)
-
-
I type Dutch very well on a standard US configuration, thank you very much.
Not US/International. US/International is an abominatioon that needs to burn in hell.
-
-
-
Topic: What time UTC is this topic going to close? Given the international clientele of this forum, it's going to be past bedtime for someone.
Filed under: this topic is racist against timezones