49 сезон
Межсезонье
Вход в систему
Вход через VK
ПБ-ВИКИ

Джейсон Дэйр

    Игрок   Статистика   История   Травмы   Достижения   Сборные   Трансферы
 

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных2900793301714806.330
Национальная сборная190058220127006.470
     Отборочный турнир190058220127006.470
     Финальный турнир000000000.000
Молодежная сборная10002111057806.050
     Отборочный турнир10002111057806.050
     Финальный турнир000000000.000
ТОВЫ сборных30101083892715126.930
Всего за сборные59101877194429926.640
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(SELECT `RP`.*, 0 as `sezon`, `PG`.*, 0 as `sezon`, `PG`.`id` as `gid`, `PG`.`lastchangetable` as `sort`, `PT`.`pl_time` FROM `p_roster_pl` `RP` LEFT JOIN `p_rosters` `PR` ON `PR`.`id` = `RP`.`roster` RIGHT JOIN `p_games` `PG` ON `PG`.`id` = `PR`.`game` AND `PG`.`tournament` IN(141, 1406) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 2255 WHERE `RP`.`player` = 2255 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107409,107418,122698,123062,123192,123527,123347,123528,122797,124755,213580,213906,213123,213908,213582,213910,235449,235642,235452,235644,246780,246999,248475,247580,257467,257669,259683,259930,261990,264372,265045,277751,278489,281268,281662,283346,284490,299303,299425,300888,301821,302956,302957,303412,337848,342011,345792,346102,372389,372814,373600,373952,10368926,10370078,10370079,10370625,10370701,10386116,10386488,10400019,10401522,10403044,10403083,10406680,10407434,10436698,10436991,10440300,10440331,10441502,10442146,10442257,10442298,10443815,10443845,10464059,10466200,10464167,10466203,10481122,10481648,10482571,10483756,10510440,10512444,10512477,10513550,10513552,10513553,10514187,10514459,10514553,10540991,10541443,10542924,10544257,10568042,10568996,10569790,10569791,10570089,10570152,10570585,10583780,10603059,10605797,10605969,10608171,10608236,10637872,10637984,10639595,10639757,10639597,10639760,10639613,10639745,10640830,10640956,10641105,10647764,10647846,10662102,10662157,10664984,10665202,10690477,10690543,10691971,10691967,10692053,10692432,10692485,10692826,10693270,10694000,10708194,10708691,10710188,10710215,10727757,10727551,10730545,10730872,10757435,10757456,10758589,10758621,10758592,10758623,10758593,10758617,10760423,10760442,10760878,10760909,10761913,10762432,10770750,10770820,10772449,10773195,10777684,10777837,10779337,10780421,10794894,10796280,10799284,10825238,10826342,10826345,10826334,10826589,10827039,10827205,10827814,10827831,10839172,10839831,10840977,10841159,10842722,10877399,10892905,10893802,10893975,10893804,10893973,10893800,10893972,10894367,10894526,10895456,10904527,10905715,10906700,10907993,10920841,10922855,10937418,10938814,10938851,10938681,10939531,10940808,10941601,10948281,10948867,10963268,10965480,10981537,10981533,10983067,10983041,10983047,10983413,10983573,10984055,10984059,10985671,10986162,10999162,10999983,11015507,11015523,11036279,11036420,11038638,11038649,11038640,11038823,11038898,11039305,11039615,11055484,11055695,11067326,11067871,11070792,11070818,11085071,11085326,11085890,11086453,11085891,11086456,11085894,11086372,11087475,11087503,11087551,11087628,11088860,11106947,11107451,11109088,11109657,11121417,11121579,11139796,11141363,11141463,11141915,11141948,11142062,11142104,11158532,11158973,11186480,11187416,11187923,11187479,11187814,11187414,11187816,11188260,11188320,11188398,11188446,11188477,11189128,11196342,11198647,11198698,11213341,11213587,11229158,11229187,11229795,11229896,11229815,11229750,11229798,11230842,11231071,11231968,11232356,11232735,11233084,11238208,11239879,11240812,11240817,11243351,11244183,11246796,11246867,11254042,11254202,11267404,11284104,11284970,11287116,11287358,11287802,11288138,11303088,11303224,11305458,11305661,11322728,11337926,11339156,11339949,11340090,11339938,11340092,11339952,11340099,11340382,11340401,11341342,11342035,11342077,11342677,11343990,11361167,11361327,11361653,11362089,11375670,11376651,11392031,11392553,11393285,11393296,11393225,11393301,11393227,11393311,11394331,11394522,11394716,11394735,11394876,11394959,11395507,11395569,11396732,11397595,11417693,11418204,11433606,11433619,11434265,11434302,11434253,11434263,11434258,11434304,11435990,11436080,11436312,11436327,11440638,11441483,11450346,11450944,11450344,11450942,11479895,11481307,11481561,11481305,11481558,11481304,11481553,11481661,11481668,11481777,11481791,11481879,11481896,11494022,11494046,11500751,11500839,11500753,11500838,11514061,11514723,11530211,11530264,11531637,11531628,11531630,11531739,11531632,11531753,11532129,11532241,11532660,11532684,11533107,11533155,11538572,11539568,11544584,11545199,11557270,11557910,11573341,11574830,11574969,11574832,11574978,11574847,11574973,11575677,11575885,11575934,11576034,11576071,11577783,11578920,11579769,11581086,11587275,11588276,11601570,11601778,11602072,11602409,11616956,11616967,11619006,11619207,11619007,11619186,11619154,11619188,11619878,11620252,11620275,11620404,11620453,11625759,11627035,11635698,11636562,11637697,11649108,11650848,11651880,11666289,11666483,11667246,11667298,11667249,11667296,11667248,11667300,11667725,11667832,11668090,11668234,11678339,11678381,11679497,11680477,11682304,11684151,11711170,11712194,11712192,11712197,11713232,11713330,11713711,11713712,11713815,11713817,11738626,11739604,11738618,11739796,11756983,11757331,11757986,11758002,11757983,11758800,11758810,11758906,11758943,11758959,11759004,11767861,11768965,11770435,11770983,11805688,11805903,11805777,11805918,11805763,11806070,11807008,11807072,11807328,11807655,11807881,11807898,11817176,11818818,11823924,11823922,11852602,11854165,11853985,11853986,11854163,11854021,11853989,11854445,11854473,11854939,11855098,11855234,11855290,11865236,11865350,11896089,11896314,11896891,11896892,11896888,11896945,11897039,11897110,11904585,11906755,11907238,11909007,11940259,11941468,11941470,11941380,11942537,11942535,11942733,11949518,11949771,11965108,11965196,11980371,11981107,11981111,11981112,11981383,11982173,11982848,11982997,11983016,12006673,12006802,12021396,12022175,12022491,12022527,12024729,12031112,12033449,12046092,12061200,12061218,12062151,12062147,12062149,12062701,12062807,12062976,12063038,12063078,12063125,12065207,12065237,12071111,12071120,12085805,12086068,12101157,12103141,12103624,12103743,4374,4441,4372,4445,20580,21574,47047,47189,47402,47424,48226,48270,48272,48274,48336,48399,48853,49116,49635,49877,57304,59834,70821,85616,88429,89035,94179,98979,126875,127165,127168,127163,128584,128675,128803,128805,128894,128919,133879,134572,136163,136175,138426,139081,157173,157457,172841,172877,173751,173754,173802,173755,173799,174643,174664,174728,174944,175453,177456,178381,193409,193412,210126,210133,211157,211156,211235,211153,211227,211152,212603,212667,212691,212755,216215,215898,215825,231812,247359,247716,248336,248341,248340,248344,248337,248345,249138,249205,249223,249233,249853,249997,257035,258191,260381,260703,261968,274069,288352,288509,289717,290049,290588,299179,300789,313339,315837,331848,333489,333492,333493,333630,334956,337360,337374,340330,340500,340327,340492,344481,358353,358359,372130,372329,374395,374560) ) UNION (SELECT `RP`.*, `PG`.*, `PG`.`id` as `gid`, `PG`.`lastchangetable` as `sort`, `PT`.`pl_time` FROM `p_roster_pl_arch` `RP` LEFT JOIN `p_rosters_arch` `PR` ON `PR`.`id` = `RP`.`roster` RIGHT JOIN `p_games_arch` `PG` ON `PG`.`id` = `PR`.`game` AND `PG`.`tournament` IN(141, 1406) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 2255 WHERE `RP`.`player` = 2255 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107409,107418,122698,123062,123192,123527,123347,123528,122797,124755,213580,213906,213123,213908,213582,213910,235449,235642,235452,235644,246780,246999,248475,247580,257467,257669,259683,259930,261990,264372,265045,277751,278489,281268,281662,283346,284490,299303,299425,300888,301821,302956,302957,303412,337848,342011,345792,346102,372389,372814,373600,373952,10368926,10370078,10370079,10370625,10370701,10386116,10386488,10400019,10401522,10403044,10403083,10406680,10407434,10436698,10436991,10440300,10440331,10441502,10442146,10442257,10442298,10443815,10443845,10464059,10466200,10464167,10466203,10481122,10481648,10482571,10483756,10510440,10512444,10512477,10513550,10513552,10513553,10514187,10514459,10514553,10540991,10541443,10542924,10544257,10568042,10568996,10569790,10569791,10570089,10570152,10570585,10583780,10603059,10605797,10605969,10608171,10608236,10637872,10637984,10639595,10639757,10639597,10639760,10639613,10639745,10640830,10640956,10641105,10647764,10647846,10662102,10662157,10664984,10665202,10690477,10690543,10691971,10691967,10692053,10692432,10692485,10692826,10693270,10694000,10708194,10708691,10710188,10710215,10727757,10727551,10730545,10730872,10757435,10757456,10758589,10758621,10758592,10758623,10758593,10758617,10760423,10760442,10760878,10760909,10761913,10762432,10770750,10770820,10772449,10773195,10777684,10777837,10779337,10780421,10794894,10796280,10799284,10825238,10826342,10826345,10826334,10826589,10827039,10827205,10827814,10827831,10839172,10839831,10840977,10841159,10842722,10877399,10892905,10893802,10893975,10893804,10893973,10893800,10893972,10894367,10894526,10895456,10904527,10905715,10906700,10907993,10920841,10922855,10937418,10938814,10938851,10938681,10939531,10940808,10941601,10948281,10948867,10963268,10965480,10981537,10981533,10983067,10983041,10983047,10983413,10983573,10984055,10984059,10985671,10986162,10999162,10999983,11015507,11015523,11036279,11036420,11038638,11038649,11038640,11038823,11038898,11039305,11039615,11055484,11055695,11067326,11067871,11070792,11070818,11085071,11085326,11085890,11086453,11085891,11086456,11085894,11086372,11087475,11087503,11087551,11087628,11088860,11106947,11107451,11109088,11109657,11121417,11121579,11139796,11141363,11141463,11141915,11141948,11142062,11142104,11158532,11158973,11186480,11187416,11187923,11187479,11187814,11187414,11187816,11188260,11188320,11188398,11188446,11188477,11189128,11196342,11198647,11198698,11213341,11213587,11229158,11229187,11229795,11229896,11229815,11229750,11229798,11230842,11231071,11231968,11232356,11232735,11233084,11238208,11239879,11240812,11240817,11243351,11244183,11246796,11246867,11254042,11254202,11267404,11284104,11284970,11287116,11287358,11287802,11288138,11303088,11303224,11305458,11305661,11322728,11337926,11339156,11339949,11340090,11339938,11340092,11339952,11340099,11340382,11340401,11341342,11342035,11342077,11342677,11343990,11361167,11361327,11361653,11362089,11375670,11376651,11392031,11392553,11393285,11393296,11393225,11393301,11393227,11393311,11394331,11394522,11394716,11394735,11394876,11394959,11395507,11395569,11396732,11397595,11417693,11418204,11433606,11433619,11434265,11434302,11434253,11434263,11434258,11434304,11435990,11436080,11436312,11436327,11440638,11441483,11450346,11450944,11450344,11450942,11479895,11481307,11481561,11481305,11481558,11481304,11481553,11481661,11481668,11481777,11481791,11481879,11481896,11494022,11494046,11500751,11500839,11500753,11500838,11514061,11514723,11530211,11530264,11531637,11531628,11531630,11531739,11531632,11531753,11532129,11532241,11532660,11532684,11533107,11533155,11538572,11539568,11544584,11545199,11557270,11557910,11573341,11574830,11574969,11574832,11574978,11574847,11574973,11575677,11575885,11575934,11576034,11576071,11577783,11578920,11579769,11581086,11587275,11588276,11601570,11601778,11602072,11602409,11616956,11616967,11619006,11619207,11619007,11619186,11619154,11619188,11619878,11620252,11620275,11620404,11620453,11625759,11627035,11635698,11636562,11637697,11649108,11650848,11651880,11666289,11666483,11667246,11667298,11667249,11667296,11667248,11667300,11667725,11667832,11668090,11668234,11678339,11678381,11679497,11680477,11682304,11684151,11711170,11712194,11712192,11712197,11713232,11713330,11713711,11713712,11713815,11713817,11738626,11739604,11738618,11739796,11756983,11757331,11757986,11758002,11757983,11758800,11758810,11758906,11758943,11758959,11759004,11767861,11768965,11770435,11770983,11805688,11805903,11805777,11805918,11805763,11806070,11807008,11807072,11807328,11807655,11807881,11807898,11817176,11818818,11823924,11823922,11852602,11854165,11853985,11853986,11854163,11854021,11853989,11854445,11854473,11854939,11855098,11855234,11855290,11865236,11865350,11896089,11896314,11896891,11896892,11896888,11896945,11897039,11897110,11904585,11906755,11907238,11909007,11940259,11941468,11941470,11941380,11942537,11942535,11942733,11949518,11949771,11965108,11965196,11980371,11981107,11981111,11981112,11981383,11982173,11982848,11982997,11983016,12006673,12006802,12021396,12022175,12022491,12022527,12024729,12031112,12033449,12046092,12061200,12061218,12062151,12062147,12062149,12062701,12062807,12062976,12063038,12063078,12063125,12065207,12065237,12071111,12071120,12085805,12086068,12101157,12103141,12103624,12103743,4374,4441,4372,4445,20580,21574,47047,47189,47402,47424,48226,48270,48272,48274,48336,48399,48853,49116,49635,49877,57304,59834,70821,85616,88429,89035,94179,98979,126875,127165,127168,127163,128584,128675,128803,128805,128894,128919,133879,134572,136163,136175,138426,139081,157173,157457,172841,172877,173751,173754,173802,173755,173799,174643,174664,174728,174944,175453,177456,178381,193409,193412,210126,210133,211157,211156,211235,211153,211227,211152,212603,212667,212691,212755,216215,215898,215825,231812,247359,247716,248336,248341,248340,248344,248337,248345,249138,249205,249223,249233,249853,249997,257035,258191,260381,260703,261968,274069,288352,288509,289717,290049,290588,299179,300789,313339,315837,331848,333489,333492,333493,333630,334956,337360,337374,340330,340500,340327,340492,344481,358353,358359,372130,372329,374395,374560) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}:
(c) 2002-2025 Дмитрий Язынин
Время создания страницы: 0.059 сек (2)
Size=(66573)