DRaysBay: An SB Nation Community

Navigation: Jump to content areas:


Sports blogs for fans, by fans.
Around SBN: Blogger Q&A - And The Valley Shook

OTTOTD 10/20: My 'Lil Bastard

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

0 recs  |  Comment 109 comments

Story-email Email Printer Print

Comments

Display:

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

100 pitches not 150

Follow Me on Twitter @FreeZorilla

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

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

Oooh, chalkboard editor.

You, on the other hand, are not useless.

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

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   0 recs

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   0 recs

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   0 recs

"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   0 recs

.

Sign lady must die.

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

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   0 recs

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   0 recs

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   0 recs

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   0 recs

Do tell....

Follow Me on Twitter @FreeZorilla

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

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

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   0 recs

What's up bitches?

Officially now the head of the Lobstein bandwagon.

by P Brady on Oct 20, 2009 2:38 PM EDT reply actions   0 recs

Just ate chicken ramen with an egg cracked in, delicious.

Officially now the head of the Lobstein bandwagon.

by P Brady on Oct 20, 2009 2:39 PM EDT up reply actions   0 recs

So damn true.

-and peas. MMMMMMMMMMMMM

by vincesucks on Oct 20, 2009 3:58 PM EDT up reply actions   0 recs

Spit passed in front of Mo Rivera's hand, no cheating, crisis averted

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 2:57 PM EDT reply actions   0 recs

Comments For This Post Are Closed


User Tools

Founded in 2005. DRaysBay is home to "progressive statistical analysis and reasoned argument."
Start posting about the Rays »

Join SB Nation and dive into communities focused on all your favorite teams.

FanShots

Quick hits of video, photos, quotes, chats, links and lists that you find around the web.

Recent FanShots

Desmond Jennings Makes the Tops AA-All-Stars
ABC Coalition to Vote on Draft Report Today.
Fan page for Dick Bosman, Rays minor league pitching coordinator
Upton's Struggles vs Lefties
Evan Longoria wins the Silver Slugger Award
09 Minor Leaguers File for Free Agency
Longoria on the MLB 2k10 cover?
Thank you Tim Marchman.
Longo's Slugcon by Location
Longo wins Silver Slugger

+ New FanShot All FanShots >


VPs of Baseball Operations

Nando_small R.J. Anderson

Raysring1_small Tommy Rancel

Zorilla_small FreeZorilla

Price_small Erik Hahmann

Ticket Account Executive

Rays_small Steve Slowinski