KillerDrew

From Halo Esports Wiki
Jump to: navigation, search

Lua error: bad argument #2 to 'formatDate' (not a valid timestamp).

Lua error: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT `RC`.`Date_Sort` AS `Date_Sort`,`RC`.`Player` AS `Player`,`PR`.`_pageName` AS `PlayerLink`,`RC`.`Team` AS `Team`,`RC`.`Role` AS `Role`,`RC`.`RoleModifier` AS `RoleModifier`,`RC`.`Source` AS `Source`,`RC`.`IsGCD` AS `IsGCD`,`RC`.`Preload` AS `Preload`,`RC`.`Direction` AS `Direction`,`RC`.`Status` AS `Status`,`RC`.`_pageName` AS `RCPage`,`RC`.`RosterChangeId` AS `RosterChangeId`,`News`.`Date_Display` AS `Date_Display`,`News`.`Region` AS `Region`,`News`.`Sentence` AS `Sentence`,`News`.`_pageName` AS `_pageName`,`News`.`NewsId` AS `NewsId`,`News`.`IsApproxDate` AS `IsApproxDate`,`RN`.`OriginalName` AS `NameOld`,`ResChange`.`ResidencyOld` AS `ResidencyOld`,`News`.`_pageName` AS `ResPageName`,`cargo__Contracts`.`ContractEnd` AS `ContractEnd`,`cargo__Contracts`.`Team` AS `ContractTeam`,`TRed`.`_pageName` AS `TeamPage`,COALESCE(ST1._pageName, ST2._pageName, `cargo__Contracts`.`Team`, RC.Team) AS `SisterTeamPage`,`RC`.`Date_Sort__precision` AS `Date_Sort__precision`,`cargo__Contracts`.`ContractEnd__precision` AS `ContractEnd__precision` FROM `cargo__NewsItems__Players` LEFT OUTER JOIN `cargo__NewsItems` `News` ON ((`cargo__NewsItems__Players`.`_rowID`=`News`.`_ID`)) LEFT OUTER JOIN `cargo__PlayerRedirects` `PR` ON ((`cargo__NewsItems__Players`.`_value`=`PR`.`AllName`)) LEFT OUTER JOIN `cargo__RosterChanges` `RC` ON ((`News`.`NewsId`=`RC`.`NewsId`)) LEFT OUTER JOIN `cargo__PlayerRenames` `RN` ON ((`News`.`NewsId`=`RN`.`NewsId`)) LEFT OUTER JOIN `cargo__ResidencyChanges` `ResChange` ON ((`News`.`NewsId`=`ResChange`.`NewsId`)) LEFT OUTER JOIN `cargo__Contracts` ON ((`News`.`NewsId`=`cargo__Contracts`.`NewsId`)) LEFT OUTER JOIN `cargo__TeamRedirects` `TRed` ON ((`RC`.`Team`=`TRed`.`AllName`)) LEFT OUTER JOIN `cargo__SisterTeams` `ST1` ON ((`cargo__Contracts`.`Team`=`ST1`.`Team`)) LEFT OUTER JOIN `cargo__SisterTeams` `ST2` ON ((`RC`.`Team`=`ST2`.`Team`)) WHERE ((PR._pageName="KillerDrew") AND (((COALESCE(RC.Preload, News.Preload, "") != "extended" AND COALESCE(RC.Preload, News.Preload, "") != "gcd_extended" AND COALESCE(RC.Preload, News.Preload, "") != "remain" AND COALESCE(RC.Preload, News.Preload, "") != "expire_notleave" AND COALESCE(RC.Preload, News.Preload, "") != "set_to_leave" AND COALESCE(RC.Preload, News.Preload, "") != "opportunities" AND COALESCE(RC.Preload, News.Preload, "") != "set_to_leave_already_joined" AND COALESCE(RC.Preload, News.Preload, "") != "gcd_expire_notleave" AND COALESCE(RC.Preload, News.Preload, "") != "to_main_also_stay" AND COALESCE(RC.Preload, News.Preload, "") != "loan_end_and_join" AND COALESCE(RC.Preload, News.Preload, "") != "loan_return" AND COALESCE(RC.Preload, News.Preload, "") != "loaned_to") AND (RC.Direction!="Join" OR (COALESCE(RC.Preload, News.Preload, "") != "gcd_expire_notleave_yet")) AND (RC.Direction!="Leave" OR (COALESCE(RC.Preload, News.Preload, "") != "retirement_no_team" AND COALESCE(RC.Preload, News.Preload, "") != "confirm_role_swap" AND COALESCE(RC.Preload, News.Preload, "") != "gcd_to_sub" AND COALESCE(RC.Preload, News.Preload, "") != "role_swap" AND COALESCE(RC.Preload, News.Preload, "") != "sub_to_trainee" AND COALESCE(RC.Preload, News.Preload, "") != "to_active" AND COALESCE(RC.Preload, News.Preload, "") != "to_inactive" AND COALESCE(RC.Preload, News.Preload, "") != "to_starting" AND COALESCE(RC.Preload, News.Preload, "") != "to_sub" AND COALESCE(RC.Preload, News.Preload, "") != "to_trainee" AND COALESCE(RC.Preload, News.Preload, "") != "team_rename_same_page")))) AND (RC.Player=`cargo__NewsItems__Players`.`_value` OR RC.Player IS NULL) AND (`cargo__Contracts`.`Player`=`cargo__NewsItems__Players`.`_value` OR `cargo__Contracts`.`Player` IS NULL)) GROUP BY News.NewsId, COALESCE(RC.Direction, News.NewsId) ORDER BY News.Date_Sort,News.N_LineInDate,RC.N_LineInNews LIMIT 5000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'News.Preload' in 'where clause' (db2_cluster.aurora.local.curse.us:3306) .

Andrew "KillerDrew" Noriega is a retired American player well known for his time with teams such as Heaven and Earth and Purgatory.

Biography

Halo 3

Halo: Reach

Trivia

Team and Tournament History

Game End Date Event Place Team Prize Team Teammates (Coach)
Halo reach logo.png November 7, 2010 MLG Dallas Championships 2010 A99 - Logo std.pngPerfect Storm KarmaLegitNaded
Halo 3 logo.png October 15, 2010 MLG Washington, D.C. 2010 B212 I1NQ Logo std.pngPurgatory GilkeyKarmaMimic
Halo 3 logo.png August 29, 2010 MLG Raleigh 2010 A88 $1,600 Logo std.pngPurgatory GilkeyKarmaMimic
Halo 3 logo.png June 6, 2010 MLG Columbus 2010 A99 - Heaven and Earthlogo std.pngHeaven and Earth ClutchStrongSideSypher
Halo 3 logo.png April 18, 2010 MLG Orlando 2010 A99 - Heaven and Earthlogo std.pngHeaven and Earth KarmaNadedClutch
Halo 3 logo.png January 10, 2010 MLG Orlando Championships 2009 B515 - Heaven and Earthlogo std.pngHeaven and Earth KarmaCpt AnarchyPerplexity
Halo 3 logo.png November 8, 2009 MLG Anaheim 2009 A88 $1,600 Heaven and Earthlogo std.pngHeaven and Earth PoWeeZyKarmaCpt Anarchy
Halo 3 logo.png August 30, 2009 MLG Dallas 2009 B414 - Heaven and Earthlogo std.pngHeaven and Earth PoWeeZyHokuMTetra Sh0t
Halo 3 logo.png June 7, 2009 MLG Columbus 2009 B313 - Heaven and Earthlogo std.pngHeaven and Earth PoWeeZyPerplexityHokuM
Halo 3 logo.png April 5, 2009 MLG Meadowlands 2009 A66 $2,800 Heaven and Earthlogo std.pngHeaven and Earth PoWeeZyPerplexityHokuM
Halo 3 logo.png October 5, 2008 MLG Dallas 2008 B6< 15 I1NQ Logo std.pngSick By Definition Joe FriesSeanWayneTheArtOfWar
Halo 3 logo.png August 24, 2008 MLG Toronto 2008 D131 - Logo std.pngSick By Definition Joe FriesSeanWayneTheArtOfWar

External Content

Interviews

Articles

Vlogs

VODs

Other

External Links

References