Official TWOTY 2011 question thread

Original post by LIWeddings

Nov 23, 2010 11:51 AM

Any questions or concerns?
This is where to post them!

DCgirl82 Posted: Nov 23, 2010 01:01 PM

Re: Official TWOTY 2011 question thread

Patiently Stalking here lol!!

futurestevens Posted: Nov 23, 2010 01:03 PM

Re: Official TWOTY 2011 question thread

Posted by kedra5

Posted by KristynLeigh

I hope your back feels better!

I'm for 24 hours!

And can I can tap dance to 'Going to the Chapel' instead of sing?

TOTALLY thought this said LAP dance at first

can we arrange for this performance at TWOTY?

VCanizalez Posted: Nov 23, 2010 01:05 PM

Re: Official TWOTY 2011 question thread

Ron,

Where will the Link for registration be?

Will you post a NEW thread about it? Or it will be next to TWOTY announcement?

Just checking to know where I will be looking.

Gracias!!!!

JennylovesStephen Posted: Nov 23, 2010 01:08 PM

Re: Official TWOTY 2011 question thread

Posted by LIWeddings NYCityWeddings

FYI - I am considering the 24 hour registration.
This was my first thoughts on it.
Everyone has been waiting for this so maybe, just maybe I'll close it tomorrow afternoon.

Yesss Do it

RFutureBegins2day Posted: Nov 23, 2010 01:09 PM

Re: Official TWOTY 2011 question thread

Ron - will the registration link be posted as its own thread?

AwaitingAugust Posted: Nov 23, 2010 01:09 PM

Re: Official TWOTY 2011 question thread

Posted by LIWeddings NYCityWeddings

Posted by dianeb888

What about the 9,000,000 post??

still have to run the program for that.
it's CPU intensive and with everyone on stalking TWOTY posts I'm going to run that script later today or tonight

i'll fix it for you if you send it over :-P

KristynLeigh Posted: Nov 23, 2010 01:11 PM

Re: Official TWOTY 2011 question thread

Posted by futurestevens

Posted by kedra5

Posted by KristynLeigh

I hope your back feels better!

I'm for 24 hours!

And can I can tap dance to 'Going to the Chapel' instead of sing?

TOTALLY thought this said LAP dance at first

can we arrange for this performance at TWOTY?

I'd be down for it....

Anyone have a dress I can borrow? I haven't bought mine yet!

LIWeddings Posted: Nov 23, 2010 01:16 PM

Re: Official TWOTY 2011 question thread

Posted by kedra5

Posted by KristynLeigh

I hope your back feels better!

I'm for 24 hours!

And can I can tap dance to 'Going to the Chapel' instead of sing?

TOTALLY thought this said LAP dance at first

that could get a ticket too!

LIWeddings Posted: Nov 23, 2010 01:17 PM

Re: Official TWOTY 2011 question thread

Posted by VCanizalez

Ron,

Where will the Link for registration be?

Will you post a NEW thread about it? Or it will be next to TWOTY announcement?

Just checking to know where I will be looking.

Gracias!!!!

new thread
be patient just finishing some programming

kim will post it

kedra5 Posted: Nov 23, 2010 01:18 PM

Re: Official TWOTY 2011 question thread

Posted by LIWeddings NYCityWeddings

Posted by kedra5

Posted by KristynLeigh

I hope your back feels better!

I'm for 24 hours!

And can I can tap dance to 'Going to the Chapel' instead of sing?

TOTALLY thought this said LAP dance at first

that could get a ticket too!

Awkward song to dance too though hahaha

VCanizalez Posted: Nov 23, 2010 01:18 PM

Re: Official TWOTY 2011 question thread

Posted by LIWeddings NYCityWeddings

Posted by VCanizalez

Ron,

Where will the Link for registration be?

Will you post a NEW thread about it? Or it will be next to TWOTY announcement?

Just checking to know where I will be looking.

Gracias!!!!

new thread
be patient just finishing some programming

kim will post it

Than You Ron...
I am being patient...
I was just asking....
Thanks

DCgirl82 Posted: Nov 23, 2010 01:18 PM

Re: Official TWOTY 2011 question thread

Posted by LIWeddings NYCityWeddings

Posted by kedra5

Posted by KristynLeigh

I hope your back feels better!

I'm for 24 hours!

And can I can tap dance to 'Going to the Chapel' instead of sing?

TOTALLY thought this said LAP dance at first

that could get a ticket too!

LIWeddings Posted: Nov 23, 2010 01:20 PM

Re: Official TWOTY 2011 question thread

Posted by AwaitingAugust

Posted by LIWeddings NYCityWeddings

Posted by dianeb888

What about the 9,000,000 post??

still have to run the program for that.
it's CPU intensive and with everyone on stalking TWOTY posts I'm going to run that script later today or tonight

i'll fix it for you if you send it over :-P

this will blow some minds!

SELECT TOP 21 P.ID AS PostID, T.Subject AS TopicTitle, P.SID AS TopicPostNumber, M.Username, P.Posted, P.Message
FROM (
SELECT TOP 9000010 ID FROM Posts ORDER BY ID
) DERIVEDTBL
INNER JOIN Posts P ON P.ID = DERIVEDTBL.ID
INNER JOIN Topics T ON T.ID = P.Topic
INNER JOIN Members M ON M.ID = P.UserID
ORDER BY P.ID DESC

RFutureBegins2day Posted: Nov 23, 2010 01:21 PM

Re: Official TWOTY 2011 question thread

atitus724 Posted: Nov 23, 2010 01:21 PM

Re: Official TWOTY 2011 question thread

Posted by LIWeddings NYCityWeddings

Posted by AwaitingAugust

Posted by LIWeddings NYCityWeddings

Posted by dianeb888

What about the 9,000,000 post??

still have to run the program for that.
it's CPU intensive and with everyone on stalking TWOTY posts I'm going to run that script later today or tonight

i'll fix it for you if you send it over :-P

this will blow some minds!

SELECT TOP 21 P.ID AS PostID, T.Subject AS TopicTitle, P.SID AS TopicPostNumber, M.Username, P.Posted, P.Message
FROM (
SELECT TOP 9000010 ID FROM Posts ORDER BY ID
) DERIVEDTBL
INNER JOIN Posts P ON P.ID = DERIVEDTBL.ID
INNER JOIN Topics T ON T.ID = P.Topic
INNER JOIN Members M ON M.ID = P.UserID
ORDER BY P.ID DESC

whattttttttttttt

sjr385 Posted: Nov 23, 2010 01:22 PM

.

eternitybride Posted: Nov 23, 2010 01:22 PM

Re: Official TWOTY 2011 question thread

that the code for the programing to pick the winner of the 9,000,000 post?

VCanizalez Posted: Nov 23, 2010 01:23 PM

Re: Official TWOTY 2011 question thread

Posted by LIWeddings NYCityWeddings

this will blow some minds!

SELECT TOP 21 P.ID AS PostID, T.Subject AS TopicTitle, P.SID AS TopicPostNumber, M.Username, P.Posted, P.Message
FROM (
SELECT TOP 9000010 ID FROM Posts ORDER BY ID
) DERIVEDTBL
INNER JOIN Posts P ON P.ID = DERIVEDTBL.ID
INNER JOIN Topics T ON T.ID = P.Topic
INNER JOIN Members M ON M.ID = P.UserID
ORDER BY P.ID DESC

I HAVE NO IDEA WHAT LANGUAGE IS THAT!!!!!!!!!

I only speak English & Spanish,,, But that.. OMG

LoveyDovey Posted: Nov 23, 2010 01:25 PM

Re: Official TWOTY 2011 question thread

Posted by sjr385

Posted by mybabylovesmoi

What's not fair about a 24 hr window? This is a genuine question, I'm not trying to be mean

What if you really weren't going to have internet access for 24+ hours? Perhaps you're traveling for the holiday and don't have internet on your phone?

I'm happy that it's random selection. And I think a 24 hour window could be fair **IF** sufficient notice is given. Changing the rules midway to shorten the time period isn't fair.

what short notice??

this is the first we are hearing of ANY info on TWOTY

LIWeddings Posted: Nov 23, 2010 01:26 PM

Re: Official TWOTY 2011 question thread

Posted by atitus724

Posted by LIWeddings NYCityWeddings

Posted by AwaitingAugust

Posted by LIWeddings NYCityWeddings

Posted by dianeb888

What about the 9,000,000 post??

still have to run the program for that.
it's CPU intensive and with everyone on stalking TWOTY posts I'm going to run that script later today or tonight

i'll fix it for you if you send it over :-P

this will blow some minds!

SELECT TOP 21 P.ID AS PostID, T.Subject AS TopicTitle, P.SID AS TopicPostNumber, M.Username, P.Posted, P.Message
FROM (
SELECT TOP 9000010 ID FROM Posts ORDER BY ID
) DERIVEDTBL
INNER JOIN Posts P ON P.ID = DERIVEDTBL.ID
INNER JOIN Topics T ON T.ID = P.Topic
INNER JOIN Members M ON M.ID = P.UserID
ORDER BY P.ID DESC

whattttttttttttt

she asked for the programming to give me the 9 millionth post
well that's what this does.
it also gives me the 10 posts before and after the 9 millionth
see how easy this is?