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

Александр Шваб

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных7009724284908.07640
Национальная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
Молодежная сборная7009724284908.07640
     Отборочный турнир5007817612808.20456
     Финальный турнир200196672107.75184
ТОВЫ сборных7007019583417.36647
Всего за сборные1400167437168317.711287
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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` = 83668 WHERE `RP`.`player` = 83668 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125240,126338,128191,129004,130039,204173,206076,209451,209604,209695,280778,280784,280787,280792,280795,280797,338161,338163,338170,338173,338176,338182,10398093,10398095,10398102,10398105,10398108,10398114,10441224,10441225,10441231,10442080,10479175,10479177,10479184,10479187,10479190,10479196,10542372,10542378,10542381,10542386,10542389,10542391,10604485,10604487,10604494,10604497,10604500,10604506,10662807,10662809,10662816,10662819,10662822,10662828,10726462,10726465,10726468,10726471,10726478,10726481,10796656,10796659,10796662,10796665,10796672,10796675,10876342,10876345,10876348,10876351,10876358,10876361,10919929,10919931,10919938,10919941,10919944,10919950,10964171,10964173,10964180,10964183,10964186,10964192,10982979,10982984,10982986,11014751,11014756,11014758,11014764,11014767,11014769,11069560,11069561,11069567,11069571,11069574,11069580,11122156,11122161,11122166,11122167,11122174,11122177,11170526,11170531,11170536,11170537,11170544,11170547,11213772,11213777,11213782,11213783,11213790,11213793,11266476,11266481,11266486,11266487,11266494,11266497,11323380,11323385,11323390,11323391,11323398,11323401,11374932,11374937,11374942,11374943,11374950,11374953,11418616,11418621,11418626,11418627,11418634,11418637,11464710,11464715,11464720,11464721,11464728,11464731,11513872,11513877,11513882,11513883,11513890,11513893,11557022,11557027,11557032,11557033,11557040,11557043,11600726,11600731,11600736,11600737,11600744,11600747,11649650,11649655,11649660,11649661,11649668,11649671,11671724,11671729,11671734,11671735,11671742,11671745,11711133,11739217,11739222,11739227,11739228,11739235,11739238,11756958,11786909,11786910,11786916,11786920,11786923,11786929,11805315,11805316,11805322,11837050,11837055,11837057,11837063,11837066,11837068,11868945,11868946,11868952,11868956,11868959,11868965,11895852,11924017,11924018,11924024,11924028,11924031,11924037,11940009,11940903,11940904,11940910,11964074,11964079,11964081,11964087,11964090,11964092,12004270,12004275,12004277,12004283,12004286,12004288,12045475,12045476,12045482,12045486,12045489,12045495,12061191,12061987,12061992,12061997,12084835,12084840,12084845,12084846,12084853,12084856,20162,20167,20172,20173,20180,20183,71850,71855,71860,71861,71868,71871,111674,111679,111684,111685,111692,111695,158574,158579,158584,158585,158592,158595,172829,192726,192731,192736,192737,192744,192747,232328,232329,232335,232339,232342,232348,273450,273455,273460,273461,273468,273471,288013,312530,312531,312537,312541,312544,312550,331803,333302,333307,333312,357266,357267,357273,357277,357280,357286,372857,372862,372864) ) 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` = 83668 WHERE `RP`.`player` = 83668 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125240,126338,128191,129004,130039,204173,206076,209451,209604,209695,280778,280784,280787,280792,280795,280797,338161,338163,338170,338173,338176,338182,10398093,10398095,10398102,10398105,10398108,10398114,10441224,10441225,10441231,10442080,10479175,10479177,10479184,10479187,10479190,10479196,10542372,10542378,10542381,10542386,10542389,10542391,10604485,10604487,10604494,10604497,10604500,10604506,10662807,10662809,10662816,10662819,10662822,10662828,10726462,10726465,10726468,10726471,10726478,10726481,10796656,10796659,10796662,10796665,10796672,10796675,10876342,10876345,10876348,10876351,10876358,10876361,10919929,10919931,10919938,10919941,10919944,10919950,10964171,10964173,10964180,10964183,10964186,10964192,10982979,10982984,10982986,11014751,11014756,11014758,11014764,11014767,11014769,11069560,11069561,11069567,11069571,11069574,11069580,11122156,11122161,11122166,11122167,11122174,11122177,11170526,11170531,11170536,11170537,11170544,11170547,11213772,11213777,11213782,11213783,11213790,11213793,11266476,11266481,11266486,11266487,11266494,11266497,11323380,11323385,11323390,11323391,11323398,11323401,11374932,11374937,11374942,11374943,11374950,11374953,11418616,11418621,11418626,11418627,11418634,11418637,11464710,11464715,11464720,11464721,11464728,11464731,11513872,11513877,11513882,11513883,11513890,11513893,11557022,11557027,11557032,11557033,11557040,11557043,11600726,11600731,11600736,11600737,11600744,11600747,11649650,11649655,11649660,11649661,11649668,11649671,11671724,11671729,11671734,11671735,11671742,11671745,11711133,11739217,11739222,11739227,11739228,11739235,11739238,11756958,11786909,11786910,11786916,11786920,11786923,11786929,11805315,11805316,11805322,11837050,11837055,11837057,11837063,11837066,11837068,11868945,11868946,11868952,11868956,11868959,11868965,11895852,11924017,11924018,11924024,11924028,11924031,11924037,11940009,11940903,11940904,11940910,11964074,11964079,11964081,11964087,11964090,11964092,12004270,12004275,12004277,12004283,12004286,12004288,12045475,12045476,12045482,12045486,12045489,12045495,12061191,12061987,12061992,12061997,12084835,12084840,12084845,12084846,12084853,12084856,20162,20167,20172,20173,20180,20183,71850,71855,71860,71861,71868,71871,111674,111679,111684,111685,111692,111695,158574,158579,158584,158585,158592,158595,172829,192726,192731,192736,192737,192744,192747,232328,232329,232335,232339,232342,232348,273450,273455,273460,273461,273468,273471,288013,312530,312531,312537,312541,312544,312550,331803,333302,333307,333312,357266,357267,357273,357277,357280,357286,372857,372862,372864) ) 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.051 сек (4)
Size=(58847)