OTTOTD 10/20: My 'Lil Bastard

by kericr on Oct 20, 2009 10:34 AM EDT

SELECT 	Items.ItemID
	, Items.ListingID
	, Items.Quantity
	, Items.QuantityAvailable
	, (Items.QuantityAvailable - (		SELECT COUNT(*) 
						FROM ordShipmentItems_XREF OSI 
						WHERE Items.ItemID = OSI.ItemID)) 
						AS QtyToShip
	, Items.isQuantityVerified
	, items.NetPrice
	, Listings.Name

FROM ordItems Items

INNER JOIN prodListings Listings
ON Listings.ListingID = Items.ListingID

INNER JOIN usrUsers Users
ON Users.UserID = Listings.UserID

WHERE Users.UserID = (A coldfusion element that Pre tags won't render)
AND Items.orderID = (A coldfusion element that Pre tags won't render)
AND (	SELECT ItemID 
	FROM ordItems 
	WHERE ItemID = Items.ItemID 
	AND QuantityAvailable = 0 AND isQuantityVerified = 1) IS NULL 
AND (	SELECT COUNT(*) 
	FROM ordShipmentItems_XREF OSI 
	WHERE OSI.ItemID = Items.ItemID
	HAVING COUNT(*) >= items.QuantityAvailable AND COUNT(*) != 0) IS NULL

ORDER BY Items.OrderID

This post was written by a member of the DRaysBay community and does not necessarily express the views or opinions of DRaysBay staff.

Tweet Comment 109 comments | 0 recs |

Do you like this story?

Comments

Furry people check it

http://www.youtube.com/watch?v=6efDVkmI5pc

by SRQman on Oct 20, 2009 10:41 AM EDT reply actions

Also my history professor is annoying

by SRQman on Oct 20, 2009 10:41 AM EDT reply actions

Two OTTOTD

Who will win?

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 10:48 AM EDT reply actions

What?

Lead singer, songwriter, and caterer for the band Suicide Phoenix. We play sitar-based anthems on real estate law. Available for weddings, birthdays (13+, please), and LAN parties.

by PlayOnWords on Oct 20, 2009 10:54 AM EDT up reply actions

There were two OTTOTD

I wondered which one we were using.

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 10:55 AM EDT up reply actions

No there weren't.

Lead singer, songwriter, and caterer for the band Suicide Phoenix. We play sitar-based anthems on real estate law. Available for weddings, birthdays (13+, please), and LAN parties.

by PlayOnWords on Oct 20, 2009 10:56 AM EDT up reply actions

Didn't matter to me; good chance that this is my only post in it.

I can't wait until we trade him for a reliever.

by kericr on Oct 20, 2009 10:56 AM EDT up reply actions

All right folks, we've got three hours until P Brady arrives, let's get the real talk out of the way.

by R.J. Anderson on Oct 20, 2009 10:58 AM EDT reply actions

Hear back from your girl yet?

Lead singer, songwriter, and caterer for the band Suicide Phoenix. We play sitar-based anthems on real estate law. Available for weddings, birthdays (13+, please), and LAN parties.

by PlayOnWords on Oct 20, 2009 11:00 AM EDT up reply actions

Did you miss that subthread?

by R.J. Anderson on Oct 20, 2009 11:00 AM EDT up reply actions

Yes?

Lead singer, songwriter, and caterer for the band Suicide Phoenix. We play sitar-based anthems on real estate law. Available for weddings, birthdays (13+, please), and LAN parties.

by PlayOnWords on Oct 20, 2009 11:02 AM EDT up reply actions

Got a piece going in the next BA issue.

by R.J. Anderson on Oct 20, 2009 11:03 AM EDT up reply actions

Nice. Congrats.

It’s no SpyTech Weekly, but…

Lead singer, songwriter, and caterer for the band Suicide Phoenix. We play sitar-based anthems on real estate law. Available for weddings, birthdays (13+, please), and LAN parties.

by PlayOnWords on Oct 20, 2009 11:06 AM EDT up reply actions

Nevin Ashley 2-4 with a 2B

Follow Me on Twitter @FreeZorilla

by FreeZorilla on Oct 20, 2009 11:00 AM EDT reply actions

But did he call a great game?

by Suttree on Oct 20, 2009 11:35 AM EDT up reply actions

ALWAYS

Follow Me on Twitter @FreeZorilla

by FreeZorilla on Oct 20, 2009 11:44 AM EDT up reply actions

Irrelavant. Strasburg didn't pitch.

Tools Whore

by Tyler on Oct 20, 2009 3:20 PM EDT up reply actions

You'll be saying this a lot after his arm falls off.

by R.J. Anderson on Oct 20, 2009 3:25 PM EDT up reply actions

Jason Hammel had a very good year

Best curveball RAA/150 in all of MLB. Out of nowhere.

Follow Me on Twitter @FreeZorilla

by FreeZorilla on Oct 20, 2009 11:01 AM EDT reply actions

100 pitches not 150

Follow Me on Twitter @FreeZorilla

by FreeZorilla on Oct 20, 2009 11:02 AM EDT up reply actions

We were discussing movies the other day, figured this would be appropriate

Rotten Tomatoes Worst 100 movies of the decade

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 11:09 AM EDT reply actions

I've only seen 1 of the 100 worst. Down to You

by RaysTheRoof on Oct 20, 2009 6:04 PM EDT up reply actions

Psh. I've seen 5

In Ascending order from best to worst on list:

Serving Sarah (Didn’t think it was patently horrible when I saw it, paid to see it)
BloodRayne (Knew it was going to be bad, refused to watch it in theaters, d/l’d a telesync and didn’t finish it before deleting it off my HD)
The Whole 10 Yards (fooled into thinking it would be a good movie, paid to see it)

Fear Dot Com. This is my favorite on so many levels. First, when I saw it at the theater with my then-at-the-time GF, I walked out of the theater and proceeded to promptly burn my ticket stub and credit card reciept to destroy any evidence that I had seen the movie. I then spent the entire time on the way back to her place complaining about how universally stupid the movie was, then started breaking down the technical details, ie. how ghosts managed to acquire a web server, set up hosting, and build a site, and spread the word around.

At the end, I proclaimed it the worst movie I had ever seen, and every time I’ve seen a bad movie since, it’s been held up to the standard set by Fear dot com. I’ve never seen a movie that I thought was worse then it, and now I have statistical evidence to back up my claim.

I can't wait until we trade him for a reliever.

by kericr on Oct 20, 2009 6:16 PM EDT up reply actions

Such bull that "The New Guy" is on there.

by SRQman on Oct 20, 2009 6:53 PM EDT up reply actions

I've seen 2

1) Gigli (HIlarious)
2) Battlefield Earth (Part of my ongoing scientology research)

What’s ridiculous is the movies not on there like Underworld, Van Helsing, and various other chattle

FREE SPEACH is a myth. There is no such thing as 100% free speech. You cannot go into a movie theater and say "FIRE"!…"What? I have freedom of speach!" Bull. Doesnt work that way. Any real lawyer will tell you that.

by Top Gun Numba 1 on Oct 20, 2009 7:03 PM EDT up reply actions

I've seen

Envy (Chris Walken made this bearable)
Down to You (GD gf’s)
most of Rollerball (this topped my list for a while for worst film)

Frankly, I’m shocked that Larry the Cable Guy is on there twice.

Get well soon DM

by Sandy Kazmir on Oct 20, 2009 10:00 PM EDT up reply actions

lame

SI_JonHeyman rick peterson has been hired as #brewers pitching coach. team had 27th-best 4.83 ERA last year. best of luck.

by SRQman on Oct 20, 2009 11:19 AM EDT reply actions

Any interesting names on the waiver wire this week?

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 11:20 AM EDT reply actions

Any Pats WR

by SRQman on Oct 20, 2009 11:21 AM EDT up reply actions

Hakeem Nicks, if no one ones him.

I picked him up, knowing the Saints sucked against third wide outs then decided,“You know, I should just stick with Manningham.” Of course Manningham gets hurt part way through and Nicks racks up 100 yards and a td.

by Suttree on Oct 20, 2009 11:36 AM EDT up reply actions

Yea, I've got S Smith (NYG) so two NYG WR's would be tough to start every week.

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 11:38 AM EDT up reply actions

We count TE's as WR's in our league

I’m thinking Heath Miller, though I’m late to that bandwagon.

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 11:39 AM EDT up reply actions

Succaneers is going to need another day.

I forgot how time consuming film so I only finished half of what I wanted to last night before I zonked out. Really fascinating watching how the Panthers design and execute their running game. Also, Ryan Sims is completely, utterly useless.

by Suttree on Oct 20, 2009 11:41 AM EDT reply actions

Fail.

by R.J. Anderson on Oct 20, 2009 11:48 AM EDT up reply actions

SORRY I DON'T HAVE A MASSIVE DATABSE OF STATISTICS AVAILABLE FOR MY EVER WHIM, R.J. SANDERSON.

I CAN’T JUST EXCEL SPREADSHEET DIAGRAMS OUT OF THIN AIR.

by Suttree on Oct 20, 2009 11:49 AM EDT up reply actions

?

by R.J. Anderson on Oct 20, 2009 11:51 AM EDT up reply actions

9 on 7 football?

Sign lady must die.

by EminenceFront on Oct 20, 2009 11:52 AM EDT up reply actions

I don't know what this is.

by Suttree on Oct 20, 2009 11:57 AM EDT up reply actions

It's what Olsen uses to design our offense

Missing players, hence the fail.

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 11:57 AM EDT up reply actions

Dunno, stole it from Field Gulls.

by R.J. Anderson on Oct 20, 2009 11:57 AM EDT up reply actions

You're useless.

by Suttree on Oct 20, 2009 11:59 AM EDT up reply actions

http://www.playmaker.com/utilities.html

Sign lady must die.

by EminenceFront on Oct 20, 2009 12:02 PM EDT up reply actions

Oooh, chalkboard editor.

You, on the other hand, are not useless.

by Suttree on Oct 20, 2009 12:05 PM EDT up reply actions

Awesome, just tried to go there

flagged as a gambling site at work. Hooray

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 12:06 PM EDT up reply actions

This is going to come in handy.

by Suttree on Oct 20, 2009 12:10 PM EDT up reply actions

BucEm doesn't get flagged for anything?

Socialism perhaps?

Sign lady must die.

by EminenceFront on Oct 20, 2009 12:16 PM EDT up reply actions

Nope, Buc Em is accessible.

Some sites, if they have an ad on the side will cause the site to get flagged.

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 12:18 PM EDT up reply actions

lame

by SRQman on Oct 20, 2009 11:54 AM EDT via mobile up reply actions

Shift button.

by R.J. Anderson on Oct 20, 2009 11:55 AM EDT up reply actions

It is annoying on my phone

For some reason in title line it starts uncap’d

by SRQman on Oct 20, 2009 12:50 PM EDT via mobile up reply actions

Didn't notice it was mobile, disregard.

by R.J. Anderson on Oct 20, 2009 12:51 PM EDT up reply actions

So I just joined a telecall, anow every signle one of the women around me decided to start talking loudly and laughing.

So annoying.

by rglass44 on Oct 20, 2009 11:50 AM EDT reply actions

Tell your mom to shut up.

by R.J. Anderson on Oct 20, 2009 12:46 PM EDT up reply actions

Re: Kathleen Ford using the word Negro on radio.

Black people aren’t going to vote anyway.

by Suttree on Oct 20, 2009 12:55 PM EDT reply actions

Meet the new boss...

Sign lady must die.

by EminenceFront on Oct 20, 2009 12:57 PM EDT up reply actions

Context?

by R.J. Anderson on Oct 20, 2009 12:59 PM EDT up reply actions

"Don't trust dem new negros over there."

I can't wait until we trade him for a reliever.

by kericr on Oct 20, 2009 1:14 PM EDT up reply actions

.

Sign lady must die.

by EminenceFront on Oct 20, 2009 1:18 PM EDT up reply actions

Ford was on the Bubba the Love Sponge show and referred to the Head Negro in Charge theory.

She was essentially saying that black people don’t need to rely on having a black beaurcrat in office to have their problems addressed, but she didn’t elaborate particularly well and now black politicans are having a fit over it. Of course, they all supported Ford in the first place.

by Suttree on Oct 20, 2009 1:37 PM EDT up reply actions

Not ford, they supported Foster in the first place.

Anyway, it’s silly because she’s absolutely right, but Gibbons and everyone else making an uproar don’t give a shit what she was saying, just how she said it. Her remarks didn’t even come off derogatory.

by Suttree on Oct 20, 2009 1:38 PM EDT up reply actions

Hay Guise

Looks like a major coup was scored by BE in signing the Sports Guy as a columnist

Follow Me on Twitter @FreeZorilla

by FreeZorilla on Oct 20, 2009 1:20 PM EDT reply actions

I'd reply but my editor will shock me with 248290 bolts of electricity

See what I did there?

www.bucem.com - SBNation's source for all things Buccaneer

by Buc Wild on Oct 20, 2009 1:21 PM EDT up reply actions

Eh, at least it was amusing at points.

by R.J. Anderson on Oct 20, 2009 2:12 PM EDT up reply actions

So I got a girls digits today

by SRQman on Oct 20, 2009 1:24 PM EDT reply actions

Do tell....

Follow Me on Twitter @FreeZorilla

by FreeZorilla on Oct 20, 2009 1:25 PM EDT up reply actions

Just was like "Yo, can I get your # incase I need help on reviewing for the test?"

by SRQman on Oct 20, 2009 1:27 PM EDT up reply actions 6 recs

Wow, did you buy the ring yet?

Follow Me on Twitter @FreeZorilla

by FreeZorilla on Oct 20, 2009 1:27 PM EDT up reply actions

Nah.

by SRQman on Oct 20, 2009 1:29 PM EDT up reply actions

That's a one way ticket to the friend zone.

Sign lady must die.

by EminenceFront on Oct 20, 2009 1:29 PM EDT up reply actions

It was the heat of the moment

by SRQman on Oct 20, 2009 1:30 PM EDT up reply actions

Sounds steamy

Follow Me on Twitter @FreeZorilla

by FreeZorilla on Oct 20, 2009 1:32 PM EDT up reply actions

Pretty clutch there, champ.

by R.J. Anderson on Oct 20, 2009 1:32 PM EDT up reply actions

Now you're quoting Asia songs?

You really are the 40 year old virgin.

Sign lady must die.

by EminenceFront on Oct 20, 2009 1:34 PM EDT up reply actions

Now you're quoting Asia songs?

You really are the 40 year old virgin and Cartman.

Sign lady must die.

by EminenceFront on Oct 20, 2009 1:36 PM EDT up reply actions

How is this not green?

by R.J. Anderson on Oct 20, 2009 1:51 PM EDT up reply actions

I'll do the honors.

by Sam Page on Oct 20, 2009 2:29 PM EDT up reply actions

damn how many does it take

by Sam Page on Oct 20, 2009 2:30 PM EDT up reply actions

5

by R.J. Anderson on Oct 20, 2009 2:32 PM EDT up reply actions

Who says "yo"?

Tools Whore

by Tyler on Oct 20, 2009 3:24 PM EDT up reply actions

Reason to love college football

by SRQman on Oct 20, 2009 1:36 PM EDT reply actions

Huh.

http://www.nypost.com/p/sports/yankees/mlb_investigating_blog_accusation_0tOjVFwIbDTyHq27OseczJ

by R.J. Anderson on Oct 20, 2009 1:54 PM EDT reply actions

Various internet chatter.

Sign lady must die.

by EminenceFront on Oct 20, 2009 1:56 PM EDT up reply actions

PREM TALK: Thomas Vermaleon... signing of the season, no doubt.

Guy could play any position, and he’s the single biggest reason Arsenal is a title contender this year.

by Suttree on Oct 20, 2009 2:01 PM EDT reply actions

Doubt it.

by R.J. Anderson on Oct 20, 2009 2:08 PM EDT up reply actions

Doubt what?

Lead singer, songwriter, and caterer for the band Suicide Phoenix. We play sitar-based anthems on real estate law. Available for weddings, birthdays (13+, please), and LAN parties.

by PlayOnWords on Oct 20, 2009 2:16 PM EDT up reply actions

It.

by R.J. Anderson on Oct 20, 2009 2:17 PM EDT up reply actions

But he made several points.

Lead singer, songwriter, and caterer for the band Suicide Phoenix. We play sitar-based anthems on real estate law. Available for weddings, birthdays (13+, please), and LAN parties.

by PlayOnWords on Oct 20, 2009 2:20 PM EDT up reply actions

Hard to argue, though Adebayor was on his way before curbstomping Robin Van Persie.

I’ll refrain from saying further until Aquilani has a say. I’ve always liked Liverpool, but their fans provide the greatest schadenfreud on the continent.

Lead singer, songwriter, and caterer for the band Suicide Phoenix. We play sitar-based anthems on real estate law. Available for weddings, birthdays (13+, please), and LAN parties.

by PlayOnWords on Oct 20, 2009 2:11 PM EDT up reply actions

No matter how good Aquilani is, I doubt he makes a difference for Pool. Carragher's play has really dropped off this year, Gerrard's out of form and if Torres misses anytime they are completely lacking anyone lethal.

Kranjcar might be the bargain of the season – brilliant, brilliant player. Not quite in Modric’s class – he’s not as dynamic beating people off the dribble – but he’s fantastic. He all ready leads the team in assists and has been here half the year.

by Suttree on Oct 20, 2009 2:43 PM EDT up reply actions

Just visited BE for the first time since the mass troll.

You wrote this in a post…“Greg from the Bears, and maybe…maybe…that wetback Gonzalez.” Wetback is an ethnic slur, and will not be tolerated on Buc’em. This is the only warning, a permanent ban is next. Please refrain from using ethnic or racial slurs on Buc’em. You can read the Community guidelines if you need to brush up on what is acceptable now. Thank You Niko

Lead singer, songwriter, and caterer for the band Suicide Phoenix. We play sitar-based anthems on real estate law. Available for weddings, birthdays (13+, please), and LAN parties.

by PlayOnWords on Oct 20, 2009 2:32 PM EDT reply actions