YAHOO ELIGIBILITY - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

YAHOO ELIGIBILITY

Moderator: Baseball Moderators

Postby Bloody Nipples » Wed Feb 02, 2005 8:37 pm

Thanks Amazinz! Coming to the rescue yet again with the Lahman Database! ;-D
Image
aka enderwiggin
Bloody Nipples
General Manager
General Manager


Posts: 3745
Joined: 28 Feb 2004
Home Cafe: Baseball
Location: doing my laundry...

Postby Amazinz » Wed Feb 02, 2005 8:39 pm

Yeah I love it. I really need to get around to donating as much as I use it. :-]

Here are DHs:

Allen Chad DH
Alomar Roberto DH
Anderson Garret DH
Baldelli Rocco DH
Berg Dave DH
Bloomquist Willie DH
Bonds Barry DH
Burks Ellis DH
Catalanotto Frank DH
Crawford Carl DH
Crisp Coco DH
Crozier Eric DH
Cummings Midre DH
Davanon Jeff DH
Delgado Carlos DH
Dellucci David DH
Durazo Erubiel DH
Everett Carl DH
Fick Robert DH
Ford Lew DH
Fullmer Brad DH
Giambi Jason DH
Gibbons Jay DH
Glaus Troy DH
Gload Ross DH
Gross Gabe DH
Guerrero Vladimir DH
Guillen Jose DH
Hafner Travis DH
Hairston Jerry DH
Hansen Dave DH
Harvey Ken DH
Higginson Bobby DH
Huff Aubrey DH
Hunter Torii DH
Jacobsen Bucky DH
Jones Chipper DH
Jordan Brian DH
Karros Eric DH
Kielty Bobby DH
Konerko Paul DH
Kubel Jason DH
LeCroy Matt DH
Lee Carlos DH
Leon Jose DH
Lopez Javy DH
Lopez Luis DH
Lugo Julio DH
Martinez Victor DH
Martinez Edgar DH
Martinez Tino DH
McCracken Quinton DH
McDonald John DH
McGriff Fred DH
McMillon Billy DH
Mench Kevin DH
Menechino Frank DH
Millar Kevin DH
Molina Ben DH
Morneau Justin DH
Munson Eric DH
Newhan David DH
Norton Greg DH
Offerman Jose DH
Ordonez Magglio DH
Ortiz David DH
Palmeiro Rafael DH
Pena Carlos DH
Perez Timo DH
Perry Herb DH
Phelps Josh DH
Piazza Mike DH
Pickering Calvin DH
Pond Simon DH
Ramirez Manny DH
Randa Joe DH
Restovich Michael DH
Roberts Brian DH
Rodriguez Ivan DH
Ryan Michael DH
Salmon Tim DH
Segui David DH
Sheffield Gary DH
Shelton Chris DH
Sierra Ruben DH
Simon Randall DH
Stairs Matt DH
Stewart Shannon DH
Surhoff B.J. DH
Sweeney Mike DH
Thames Marcus DH
Thomas Frank DH
Thome Jim DH
Upton B.J. DH
White Rondell DH
Williams Bernie DH
Young Dmitri DH
Young Eric DH
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby ironman » Wed Feb 02, 2005 8:48 pm

Awesome, thanks Amazinz! ;-D
ironman
General Manager
General Manager

User avatar
CafeholicCafe WriterCafe RankerEagle EyeWeb Supporter
Posts: 4901
(Past Year: 94)
Joined: 28 Jan 2003
Home Cafe: Baseball
Location: Dubuque

Postby ensanimal » Wed Feb 02, 2005 8:51 pm

wow, good stuff amazinz, this will come in handy ;-D
ensanimal
Moderator
Moderator

User avatar
CafeholicFantasy ExpertMock(ing) DrafterEagle EyeHockey ModPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 10622
(Past Year: 112)
Joined: 14 Dec 2003
Home Cafe: Baseball
Location: Tim Horton's

Postby RynMan » Wed Feb 02, 2005 9:29 pm

Amazinz, just curious....does the Lahman database have a position column?
Image
RynMan
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerAward-Winning Graphics ExpertMock(ing) DrafterEagle Eye
Posts: 8891
Joined: 4 Feb 2004
Home Cafe: Baseball
Location: Oztailia

Postby Bloody Nipples » Wed Feb 02, 2005 9:34 pm

RynMan wrote:Amazinz, just curious....does the Lahman database have a position column?


It has a separate record/row for each position a player had experience at for each year. There is a "# of games played" column, too. So what Amazinz must have done was to extract all the records for one player that had at least 5 games played, and then combine them into one record (the last part is a bit complicated).
Image
aka enderwiggin
Bloody Nipples
General Manager
General Manager


Posts: 3745
Joined: 28 Feb 2004
Home Cafe: Baseball
Location: doing my laundry...

Postby Amazinz » Wed Feb 02, 2005 9:48 pm

Yeah what Nipples said. Here it is for anyone who wants it. You can use it for a non-Yahoo league, just change the number 4 to whatever you need.

Query#1 "04FieldingALL"

SELECT Master.playerID, Master.nameLast, Master.nameFirst, IIf(Sum(IIf(Fielding.POS="C",Fielding.G,0))>14,"C ","") & IIf(Sum(IIf(Fielding.POS="1B",Fielding.GS,0))>4,"1B ","") & IIf(Sum(IIf(Fielding.POS="2B",Fielding.GS,0))>4,"2B ","") & IIf(Sum(IIf(Fielding.POS="3B",Fielding.GS,0))>4,"3B ","") & IIf(Sum(IIf(Fielding.POS="SS",Fielding.GS,0))>4,"SS ","") & IIf(Sum(IIf(Fielding.POS="LF",Fielding.GS,0))>4,"LF ","") & IIf(Sum(IIf(Fielding.POS="CF",Fielding.GS,0))>4,"CF ","") & IIf(Sum(IIf(Fielding.POS="RF",Fielding.GS,0))>4,"RF ","") & IIf(Sum(IIf(Fielding.POS="DH",Fielding.G,0))>4,"DH ","") AS POS
FROM Master INNER JOIN Fielding ON Master.playerID=Fielding.playerID
WHERE (((Fielding.yearID)=2004))
GROUP BY Master.playerID, Master.nameLast, Master.nameFirst
ORDER BY Master.nameLast ASC;

Query#2 "04Fielding"

SELECT * FROM 04FieldingALL WHERE POS<>""

The second query just gets rid of all the pitchers.
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby RynMan » Wed Feb 02, 2005 9:50 pm

Amazinz wrote:Yeah what Nipples said. Here it is for anyone who wants it. You can use it for a non-Yahoo league, just change the number 4 to whatever you need.

Query#1 "04FieldingALL"

SELECT Master.playerID, Master.nameLast, Master.nameFirst, IIf(Sum(IIf(Fielding.POS="C",Fielding.G,0))>14,"C ","") & IIf(Sum(IIf(Fielding.POS="1B",Fielding.GS,0))>4,"1B ","") & IIf(Sum(IIf(Fielding.POS="2B",Fielding.GS,0))>4,"2B ","") & IIf(Sum(IIf(Fielding.POS="3B",Fielding.GS,0))>4,"3B ","") & IIf(Sum(IIf(Fielding.POS="SS",Fielding.GS,0))>4,"SS ","") & IIf(Sum(IIf(Fielding.POS="LF",Fielding.GS,0))>4,"LF ","") & IIf(Sum(IIf(Fielding.POS="CF",Fielding.GS,0))>4,"CF ","") & IIf(Sum(IIf(Fielding.POS="RF",Fielding.GS,0))>4,"RF ","") & IIf(Sum(IIf(Fielding.POS="DH",Fielding.G,0))>4,"DH ","") AS POS
FROM Master INNER JOIN Fielding ON Master.playerID=Fielding.playerID
WHERE (((Fielding.yearID)=2004))
GROUP BY Master.playerID, Master.nameLast, Master.nameFirst
ORDER BY Master.nameLast ASC;

Query#2 "04Fielding"

SELECT * FROM 04FieldingALL WHERE POS<>""

The second query just gets rid of all the pitchers.


:-o :-o :-o
I can use it semi-well in the query design wizard thing....but that scares me. :~(
Image
RynMan
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerAward-Winning Graphics ExpertMock(ing) DrafterEagle Eye
Posts: 8891
Joined: 4 Feb 2004
Home Cafe: Baseball
Location: Oztailia

Postby Amazinz » Wed Feb 02, 2005 9:52 pm

Instead of the designer just flip it over to SQL and then copy and paste what I posted. It looks more complicated than it is all jumbled up like that. ;-D
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Postby RynMan » Wed Feb 02, 2005 10:04 pm

Amazinz wrote:Instead of the designer just flip it over to SQL and then copy and paste what I posted. It looks more complicated than it is all jumbled up like that. ;-D


Yeah, it just doesnt allow me to feel intelligent enough to do it myself. Im a big kid now! !+)
Image
RynMan
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerAward-Winning Graphics ExpertMock(ing) DrafterEagle Eye
Posts: 8891
Joined: 4 Feb 2004
Home Cafe: Baseball
Location: Oztailia

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 6 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Friday, Oct. 24
(All times are EST, weather icons show forecast for game time)

Kansas City at San Francisco
(8:07 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact