All games, sorted by date - Page 1

1433 games total. Showing 1 - 20
object(PDOException)#14 (8) { ["message":protected]=> string(195) "SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'league.games.added' which is not in SELECT list; this is incompatible with DISTINCT" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "HY000" ["file":protected]=> string(34) "/var/www/lolplay/Source/browse.php" ["line":protected]=> int(278) ["trace":"Exception":private]=> array(2) { [0]=> array(6) { ["file"]=> string(34) "/var/www/lolplay/Source/browse.php" ["line"]=> int(278) ["function"]=> string(7) "prepare" ["class"]=> string(3) "PDO" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(324) "SELECT DISTINCT games.id, games.videoloc FROM games LEFT JOIN matches ON matches.id = games.match LEFT JOIN rounds ON rounds.id = matches.roundid LEFT JOIN tournaments ON tournaments.id = matches.tournament WHERE (games.published=1) ORDER BY added DESC LIMIT :perpage OFFSET :offset" } } [1]=> array(4) { ["file"]=> string(36) "/var/www/lolplay/Source/fallback.php" ["line"]=> int(23) ["args"]=> array(1) { [0]=> string(34) "/var/www/lolplay/Source/browse.php" } ["function"]=> string(7) "include" } } ["previous":"Exception":private]=> NULL ["errorInfo"]=> array(3) { [0]=> string(5) "HY000" [1]=> int(3065) [2]=> string(158) "Expression #1 of ORDER BY clause is not in SELECT list, references column 'league.games.added' which is not in SELECT list; this is incompatible with DISTINCT" } } SELECT DISTINCT games.id, games.videoloc FROM games LEFT JOIN matches ON matches.id = games.match LEFT JOIN rounds ON rounds.id = matches.roundid LEFT JOIN tournaments ON tournaments.id = matches.tournament WHERE (games.published=1) ORDER BY added DESC LIMIT :perpage OFFSET :offset
Notice: Undefined offset: 0 in /var/www/lolplay/protected/lib/google-api/src/Google/Collection.php on line 95

Notice: Undefined offset: 0 in /var/www/lolplay/protected/lib/google-api/src/Google/Collection.php on line 98

Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'views_cached' cannot be null in /var/www/lolplay/Source/functions/getVideoViews.php:34 Stack trace: #0 /var/www/lolplay/Source/functions/getVideoViews.php(34): PDOStatement->execute(Array) #1 /var/www/lolplay/Source/genrow.php(43): getVideoViews(218) #2 /var/www/lolplay/Source/browse.php(287): genrow(218) #3 /var/www/lolplay/Source/fallback.php(23): include('/var/www/lolpla...') #4 {main} thrown in /var/www/lolplay/Source/functions/getVideoViews.php on line 34
Tournament Round Teams
LoL Champion Series European QualifierQuarter FinalFNCMYM252,528Feb 1, 2013
LoL Champion Series European QualifierQuarter FinalFNCMYM252,521Feb 1, 2013
LoL Champion Series European QualifierQuarter FinalFNCMYM252,533Feb 1, 2013
LoL Champion Series European QualifierQuarter FinalaAaDB252,518Feb 1, 2013
LoL Champion Series European QualifierQuarter FinalGiantsMOUZ252,533Feb 1, 2013
LoL Champion Series European QualifierQuarter FinalGiantsMOUZ252,518Feb 1, 2013
LoL Champion Series European QualifierQuarter FinalGiantsMOUZ252,522Feb 1, 2013
LoL Champion Series European QualifierQuarter FinalaAaDB252,517Feb 1, 2013
LoL Champion Series European QualifierQuarter FinalaAaDB252,518Feb 1, 2013
LoL Champion Series European QualifierQuarter Final[M]CW252,525Feb 1, 2013
LoL Champion Series European QualifierQuarter Final[M]CW252,521Feb 1, 2013
LoL Champion Series European QualifierQuarter Final[M]CW252,538Feb 1, 2013
LoL Champion Series European QualifierSemi Final[M]MYM259,510Feb 1, 2013
LoL Champion Series European QualifierSemi Final[M]MYM259,509Feb 1, 2013
LoL Champion Series European QualifierSemi Final[M]MYM259,517Feb 1, 2013
LoL Champion Series European QualifierSemi FinalDBMOUZ259,508Feb 1, 2013
LoL Champion Series European QualifierSemi FinalDBMOUZ259,507Feb 1, 2013
LoL Champion Series European QualifierSemi FinalDBMOUZ259,524Feb 1, 2013
LoL Champion Series European QualifierPlacement MatchDBMYM259,514Feb 1, 2013
LoL Champion Series European QualifierPlacement MatchDBMYM259,511Feb 1, 2013
LoL Champion Series European QualifierPlacement MatchDBMYM259,518Feb 1, 2013
LoL Championship Series North American QualifierSemi FinalMPMRN14,850Feb 1, 2013
LoL Championship Series North American QualifierSemi FinalMPMRN12,7935.0Feb 5, 2013
LoL Championship Series North American QualifierSemi FinalMPMRN14,9523.0Feb 1, 2013
LoL Championship Series North American QualifierSemi FinalAGDNG16,262Feb 1, 2013
LoL Championship Series North American QualifierSemi FinalAGDNG13,327Feb 1, 2013
LoL Championship Series North American QualifierSemi FinalAGDNG29,092Feb 1, 2013
LoL Championship Series North American QualifierPlacement MatchDNGMRN31,645Feb 1, 2013
LoL Championship Series North American QualifierPlacement MatchDNGMRN28,110Feb 1, 2013
LoL Championship Series North American QualifierPlacement MatchDNGMRN31,662Feb 1, 2013
Intel Extreme Masters - São PauloGroup ApaiNNEX5,577Feb 3, 2013
Intel Extreme Masters - São PauloGrand FinalsAnxIM24Feb 6, 2013
Intel Extreme Masters - São PauloGrand FinalsAnxIM78Feb 6, 2013
Intel Extreme Masters - São PauloGroup A[M]MYM4,162Feb 5, 2013
Intel Extreme Masters - São PauloGrand FinalsAnxIM26Feb 6, 2013
Intel Extreme Masters - São PauloSemifinalsIMMYM2,973Feb 6, 2013
Intel Extreme Masters - São PauloSemifinalsIMMYM4,145Feb 6, 2013
Intel Extreme Masters - São PauloSemifinalsIMMYM2,979Feb 6, 2013
Intel Extreme Masters - São PauloGroup A[M]NEX2,455Feb 6, 2013
Intel Extreme Masters - São PauloGroup ApaiNMYM5,179Feb 6, 2013
Intel Extreme Masters - São PauloGroup ApaiN[M]4,587Feb 6, 2013
Intel Extreme Masters - São PauloGroup BInsightKeyd2,380Feb 6, 2013
Intel Extreme Masters - São PauloGroup BIMAnx2,598Feb 6, 2013
Intel Extreme Masters - São PauloGroup BIMKeyd23,256Feb 6, 2013
Intel Extreme Masters - São PauloGroup BInsightAnx1,390Feb 6, 2013
Intel Extreme Masters - São PauloGroup BKeydAnx1,682Feb 6, 2013
Intel Extreme Masters - São PauloSemifinals[M]Anx2,068Feb 6, 2013
Intel Extreme Masters - São PauloSemifinals[M]Anx1,608Feb 6, 2013
Intel Extreme Masters - São PauloSemifinals[M]Anx1,680Feb 6, 2013
League of Legends Championship Series North AmericaWeek 1GGUCRS102,536Feb 9, 2013
League of Legends Championship Series North AmericaWeek 1CRSDIG188,861Feb 7, 2013
League of Legends Championship Series North AmericaWeek 1CRSCLG209,902Feb 9, 2013
League of Legends Championship Series North AmericaWeek 1TSMDIG157,497Feb 9, 2013
League of Legends Championship Series North AmericaWeek 1CLGGGU105,149Feb 8, 2013
League of Legends Championship Series North AmericaWeek 1TSMVulcun112,885Feb 8, 2013
League of Legends Championship Series North AmericaWeek 1CLGTSM339,028Feb 8, 2013
League of Legends Championship Series North AmericaWeek 1DIGVulcun45,536Feb 9, 2013
League of Legends Championship Series EuropeWeek 1FNCSK909,890Feb 10, 2013
League of Legends Championship Series EuropeWeek 1EGGG909,9975.0Feb 10, 2013
League of Legends Championship Series EuropeWeek 1FNCGiants909,808Feb 10, 2013
League of Legends Championship Series EuropeWeek 1SKCW909,791Feb 10, 2013
League of Legends Championship Series EuropeWeek 1GGFNC497,225Feb 10, 2013
League of Legends Championship Series EuropeWeek 1CWEG497,164Feb 10, 2013
League of Legends Championship Series EuropeWeek 1GGGiants497,171Feb 10, 2013
League of Legends Championship Series EuropeWeek 1EGSK497,123Feb 10, 2013
League of Legends Championship Series North AmericaWeek 2DIGMRN207,314Feb 15, 2013
League of Legends Championship Series North AmericaWeek 2VulcunTSM207,329Feb 15, 2013
League of Legends Championship Series North AmericaWeek 2CLXCRS207,370Feb 15, 2013
League of Legends Championship Series North AmericaWeek 2DIGTSM207,444Feb 15, 2013
League of Legends Championship Series North AmericaWeek 2CRSVulcun120,031Feb 16, 2013
League of Legends Championship Series North AmericaWeek 2DIGGGU119,970Feb 16, 2013
League of Legends Championship Series North AmericaWeek 2TSMMRN120,186Feb 16, 2013
League of Legends Championship Series North AmericaWeek 2GGUVulcun119,980Feb 16, 2013
League of Legends Championship Series EuropeWeek 2EGGiants251,088Feb 17, 2013
League of Legends Championship Series EuropeWeek 2SKDB251,076Feb 17, 2013
League of Legends Championship Series EuropeWeek 2GGCW251,077Feb 17, 2013
League of Legends Championship Series EuropeWeek 2GiantsCW250,973Feb 17, 2013
League of Legends Championship Series North AmericaWeek 3CRSGGU272,525Feb 22, 2013
League of Legends Championship Series North AmericaWeek 3VulcunCLG272,407Feb 21, 2013
League of Legends Championship Series North AmericaWeek 3CLGDIG272,762Feb 22, 2013
League of Legends Championship Series North AmericaWeek 3CLXVulcun272,137Feb 22, 2013
League of Legends Championship Series North AmericaWeek 3MRNGGU213,805Feb 23, 2013
League of Legends Championship Series North AmericaWeek 3CLGCLX214,111Feb 23, 2013
League of Legends Championship Series North AmericaWeek 3MRNVulcun213,873Feb 23, 2013
League of Legends Championship Series North AmericaWeek 3GGUCLX213,766Feb 23, 2013
League of Legends Championship Series EuropeWeek 3CWFNC329,068Feb 23, 2013
League of Legends Championship Series EuropeWeek 3GGGiants329,276Feb 23, 2013
League of Legends Championship Series EuropeWeek 3aAaCW328,956Feb 23, 2013
League of Legends Championship Series EuropeWeek 3EGFNC329,7494.0Feb 23, 2013
League of Legends Championship Series EuropeWeek 3DBGiants293,647Feb 24, 2013
League of Legends Championship Series EuropeWeek 3FNCaAa293,741Feb 24, 2013
League of Legends Championship Series EuropeWeek 3DBCW293,640Feb 24, 2013
League of Legends Championship Series EuropeWeek 3GiantsaAa293,622Feb 24, 2013
League of Legends Championship Series North AmericaWeek 4CLGVulcun42,099Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4CRSMRN318,8564.5Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4TSMCLX318,835Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4GGUCLG318,680Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4CRSCLX318,686Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4DIGVulcun318,672Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4GGUTSM318,801Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4CRSDIG319,3815.0Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4CLGMRN318,9115.0Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4CLXVulcun318,5863.0Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4TSMVulcun163,7264.0Feb 28, 2013
League of Legends Championship Series North AmericaWeek 4CLXDIG163,3764.5Feb 28, 2013
League of Legends Championship Series EuropeWeek 4GGDB362,800Mar 1, 2013
League of Legends Championship Series EuropeWeek 4SKaAa362,607Mar 1, 2013
League of Legends Championship Series EuropeWeek 4GiantsFNC362,613Mar 1, 2013
League of Legends Championship Series EuropeWeek 4EGCW362,706Mar 1, 2013
League of Legends Championship Series EuropeWeek 4GiantsSK186Mar 1, 2013
League of Legends Championship Series EuropeWeek 4DBFNC362,663Mar 1, 2013
League of Legends Championship Series EuropeWeek 4EGGG363,096Mar 1, 2013
League of Legends Championship Series EuropeWeek 4aAaCW362,595Mar 1, 2013
League of Legends Championship Series North AmericaWeek 4GGUMRN163,205Mar 2, 2013
League of Legends Championship Series North AmericaWeek 4CLGCRS163,7164.0Mar 2, 2013
League of Legends Championship Series North AmericaWeek 4CRSTSM236,4594.0Mar 2, 2013
League of Legends Championship Series North AmericaWeek 4CLXCLG235,771Mar 2, 2013
League of Legends Championship Series North AmericaWeek 4DIGMRN235,8353.5Mar 2, 2013
League of Legends Championship Series North AmericaWeek 4GGUVulcun235,657Mar 2, 2013
League of Legends Championship Series EuropeWeek 4FNCCW394,9714.2Mar 2, 2013
League of Legends Championship Series EuropeWeek 4aAaEG394,6573.0Mar 2, 2013
League of Legends Championship Series EuropeWeek 4GGFNC394,4694.5Mar 2, 2013
League of Legends Championship Series EuropeWeek 4FNCaAa437,9932.5Mar 3, 2013
League of Legends Championship Series EuropeWeek 4DBGiants394,5564.0Mar 3, 2013
League of Legends Championship Series EuropeWeek 4SKCW394,6124.0Mar 3, 2013
League of Legends Championship Series EuropeWeek 4aAaGG394,7163.0Mar 3, 2013
League of Legends Championship Series EuropeWeek 4SKGG438,2663.8Mar 3, 2013
League of Legends Championship Series EuropeWeek 4DBEG438,2464.0Mar 3, 2013
League of Legends Championship Series EuropeWeek 4CWGiants438,0103.0Mar 3, 2013
League of Legends Championship Series EuropeWeek 4DBSK438,0884.0Mar 3, 2013
League of Legends Championship Series EuropeWeek 4GiantsEG438,1693.0Mar 3, 2013
IEM World Championship - Hanover, GermanyGroup ApaiNGG25,443Mar 6, 2013
IEM World Championship - Hanover, GermanyGroup ACJ BlazeIM2,511Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup A[M]FNC2,2553.8Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup ACJ BlazeFNC2,754Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup A[M]GG5,987Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup ApaiN[M]3,043Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup ACJ BlazeGG7,2094.0Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup ApaiNCJ Blaze4,338Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup AFNCIM1,711Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup AFNCGG10,9644.0Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup AIM[M]2,9194.0Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup AIMGG1,553Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup ACJ Blaze[M]1,325Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup ApaiNFNC42,6745.0Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup BCJ FSKT T12,4113.8Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup BAnxSK1,8773.0Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup BMYMEG2,5673.0Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup BAnxSKT T114,9354.0Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup BMYMSK1,2903.3Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup BCJ FEG4,2943.0Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup BCJ FSK6,577Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup BMYMAnx1,7824.0Mar 7, 2013
IEM World Championship - Hanover, GermanyGroup BEGSKT T12,314Mar 8, 2013
IEM World Championship - Hanover, GermanyGroup BAnxCJ F1,9074.3Mar 8, 2013
IEM World Championship - Hanover, GermanyGroup BEGSK3,4802.0Mar 8, 2013
IEM World Championship - Hanover, GermanyGroup BSKT T1MYM9293.5Mar 8, 2013
IEM World Championship - Hanover, GermanyGroup BCJ FMYM3,0843.0Mar 8, 2013
IEM World Championship - Hanover, GermanyQuarterfinals[M]CJ F5,8215.0Mar 8, 2013
IEM World Championship - Hanover, GermanyQuarterfinals[M]CJ F4,295Mar 8, 2013
IEM World Championship - Hanover, GermanyQuarterfinals[M]CJ F5,6065.0Mar 8, 2013
IEM World Championship - Hanover, GermanySemifinalsGGCJ F8,6794.0Mar 8, 2013
IEM World Championship - Hanover, GermanySemifinalsGGCJ F8,0574.0Mar 8, 2013
IEM World Championship - Hanover, GermanySemifinalsGGCJ F7,815Mar 8, 2013
IEM World Championship - Hanover, GermanyQuarterfinalsCJ BlazeAnx2,908Mar 8, 2013
IEM World Championship - Hanover, GermanyQuarterfinalsCJ BlazeAnx3,044Mar 8, 2013
IEM World Championship - Hanover, GermanySemifinalsSKT T1CJ Blaze92,434Mar 10, 2013
IEM World Championship - Hanover, GermanySemifinalsSKT T1CJ Blaze92,276Mar 10, 2013
IEM World Championship - Hanover, GermanySemifinalsSKT T1CJ Blaze41,127Mar 10, 2013
IEM World Championship - Hanover, GermanyFinalsCJ BlazeCJ F414,7513.5Mar 10, 2013
IEM World Championship - Hanover, GermanyFinalsCJ BlazeCJ F415,450Mar 10, 2013
IEM World Championship - Hanover, GermanyFinalsCJ BlazeCJ F199,4863.5Mar 10, 2013
IEM World Championship - Hanover, GermanyFinalsCJ BlazeCJ F253,961Mar 10, 2013
IEM World Championship - Hanover, GermanyFinalsCJ BlazeCJ F164,020Mar 10, 2013
League of Legends Championship Series EuropeWeek 5EGDB347,5624.0Mar 16, 2013
League of Legends Championship Series EuropeWeek 5SKaAa347,5344.8Mar 16, 2013