48 сезон
Чемпионат Европы
Вход в систему
Вход через VK
ПБ-ВИКИ

Джейми Брэндон

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных2003144127.2550
Национальная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
Молодежная сборная2003144127.2550
     Отборочный турнир2003144127.2550
     Финальный турнир000000000.000
ТОВЫ сборных800211637155.81448
Всего за сборные1000513041276.10498
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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(139, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 68627 WHERE `RP`.`player` = 68627 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125212,126315,128164,128978,130019,204143,206051,209426,209580,209675,280899,280901,280908,280911,280914,280920,338305,338307,338314,338317,338320,338326,10398309,10398311,10398318,10398321,10398324,10398330,10441187,10441192,10441194,10442084,10479174,10479180,10479183,10479188,10479191,10479193,10542326,10542329,10542332,10542335,10542342,10542345,10604581,10604583,10604590,10604593,10604596,10604602,10662903,10662905,10662912,10662915,10662918,10662924,10726390,10726393,10726396,10726399,10726406,10726409,10796775,10796777,10796784,10796787,10796790,10796796,10876509,10876511,10876518,10876521,10876524,10876530,10892869,10919977,10919979,10919986,10919989,10919992,10919998,10936981,10937946,10937951,10937956,10939494,10940492,10941591,10964338,10964344,10964347,10964352,10964355,10964357,10982991,10982996,10982998,11014845,11014850,11014853,11014858,11014861,11014866,11038303,11038308,11038311,11069632,11069633,11069639,11069643,11069646,11069652,11122134,11122135,11122141,11122145,11122148,11122154,11139733,11140286,11140291,11140296,11170600,11170601,11170607,11170611,11170614,11170620,11213870,11213871,11213877,11213881,11213884,11213890,11266596,11266601,11266606,11266607,11266614,11266617,11286118,11286119,11286125,11323358,11323359,11323365,11323369,11323372,11323378,11374790,11374791,11374797,11374801,11374804,11374810,11418690,11418691,11418697,11418701,11418704,11418710,11464784,11464785,11464791,11464795,11464798,11464804,11479170,11513850,11513851,11513857,11513861,11513864,11513870,11556950,11556955,11556960,11556961,11556968,11556971,11600654,11600659,11600664,11600665,11600672,11600675,11649530,11649535,11649540,11649541,11649548,11649551,11671676,11671681,11671686,11671687,11671694,11671697,11711989,11711990,11711996,11739363,11739364,11739370,11739374,11739377,11739383,11757838,11757844,11757837,11787028,11787033,11787035,11787041,11787044,11787046,11837026,11837031,11837033,11837039,11837042,11837044,11869065,11869066,11869072,11869076,11869079,11869085,11923993,11923994,11924000,11924004,11924007,11924013,11940017,11940889,11940894,11940899,11964169,11964174,11964179,11964180,11964187,11964190,12004221,12004226,12004231,12004232,12004239,12004242,12045593,12045598,12045603,12045604,12045611,12045614,12061989,12061990,12061996,12084765,12084766,12084772,12084776,12084779,12084785,12101950,12101955,12101957,20115,20120,20122,20128,20131,20133,71683,71688,71690,71696,71699,71701,86458,86459,86465,111772,111773,111779,111783,111786,111792,126200,158408,158409,158415,158419,158422,158428,192968,192969,192975,192979,192982,192988,232326,232331,232336,232337,232344,232347,273332,273333,273339,273343,273346,273352,288864,288865,288871,289792,312506,312507,312513,312517,312520,312526,333265,333270,333273,357359,357364,357367,357372,357375,357380,372833,372838,372840) ) 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(139, 208) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 68627 WHERE `RP`.`player` = 68627 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125212,126315,128164,128978,130019,204143,206051,209426,209580,209675,280899,280901,280908,280911,280914,280920,338305,338307,338314,338317,338320,338326,10398309,10398311,10398318,10398321,10398324,10398330,10441187,10441192,10441194,10442084,10479174,10479180,10479183,10479188,10479191,10479193,10542326,10542329,10542332,10542335,10542342,10542345,10604581,10604583,10604590,10604593,10604596,10604602,10662903,10662905,10662912,10662915,10662918,10662924,10726390,10726393,10726396,10726399,10726406,10726409,10796775,10796777,10796784,10796787,10796790,10796796,10876509,10876511,10876518,10876521,10876524,10876530,10892869,10919977,10919979,10919986,10919989,10919992,10919998,10936981,10937946,10937951,10937956,10939494,10940492,10941591,10964338,10964344,10964347,10964352,10964355,10964357,10982991,10982996,10982998,11014845,11014850,11014853,11014858,11014861,11014866,11038303,11038308,11038311,11069632,11069633,11069639,11069643,11069646,11069652,11122134,11122135,11122141,11122145,11122148,11122154,11139733,11140286,11140291,11140296,11170600,11170601,11170607,11170611,11170614,11170620,11213870,11213871,11213877,11213881,11213884,11213890,11266596,11266601,11266606,11266607,11266614,11266617,11286118,11286119,11286125,11323358,11323359,11323365,11323369,11323372,11323378,11374790,11374791,11374797,11374801,11374804,11374810,11418690,11418691,11418697,11418701,11418704,11418710,11464784,11464785,11464791,11464795,11464798,11464804,11479170,11513850,11513851,11513857,11513861,11513864,11513870,11556950,11556955,11556960,11556961,11556968,11556971,11600654,11600659,11600664,11600665,11600672,11600675,11649530,11649535,11649540,11649541,11649548,11649551,11671676,11671681,11671686,11671687,11671694,11671697,11711989,11711990,11711996,11739363,11739364,11739370,11739374,11739377,11739383,11757838,11757844,11757837,11787028,11787033,11787035,11787041,11787044,11787046,11837026,11837031,11837033,11837039,11837042,11837044,11869065,11869066,11869072,11869076,11869079,11869085,11923993,11923994,11924000,11924004,11924007,11924013,11940017,11940889,11940894,11940899,11964169,11964174,11964179,11964180,11964187,11964190,12004221,12004226,12004231,12004232,12004239,12004242,12045593,12045598,12045603,12045604,12045611,12045614,12061989,12061990,12061996,12084765,12084766,12084772,12084776,12084779,12084785,12101950,12101955,12101957,20115,20120,20122,20128,20131,20133,71683,71688,71690,71696,71699,71701,86458,86459,86465,111772,111773,111779,111783,111786,111792,126200,158408,158409,158415,158419,158422,158428,192968,192969,192975,192979,192982,192988,232326,232331,232336,232337,232344,232347,273332,273333,273339,273343,273346,273352,288864,288865,288871,289792,312506,312507,312513,312517,312520,312526,333265,333270,333273,357359,357364,357367,357372,357375,357380,372833,372838,372840) ) 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.056 сек (4)
Size=(59567)