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

Сёрен Фредериксен

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных2000187126.750
Национальная сборная2000187126.750
     Отборочный турнир2000187126.750
     Финальный турнир000000000.000
Молодежная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
ТОВЫ сборных2000208037.500
Всего за сборные40003815157.120
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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(140) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 3152 WHERE `RP`.`player` = 3152 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125208,126394,128159,129062,130313,132001,204139,206132,209419,209569,209662,209751,280442,280448,280451,280456,280459,280461,301765,338568,338574,338577,338582,338585,338587,10398360,10398366,10398369,10398374,10398377,10398379,10479245,10479250,10479253,10479258,10479261,10479266,10541988,10541994,10541997,10542002,10542005,10542007,10604867,10604872,10604875,10604880,10604883,10604888,10662997,10663002,10663005,10663010,10663013,10663018,10726171,10726176,10726179,10726184,10726187,10726192,10757374,10796942,10796948,10796951,10796956,10796959,10796961,10876580,10876586,10876589,10876594,10876597,10876599,10919665,10919667,10919674,10919677,10919680,10919686,10964437,10964439,10964446,10964449,10964452,10964458,11014965,11014970,11014973,11014978,11014981,11014986,11069341,11069346,11069349,11069354,11069357,11069362,11122373,11122378,11122380,11122386,11122389,11122391,11139723,11170215,11170220,11170222,11170228,11170231,11170233,11186271,11214061,11214066,11214068,11214074,11214077,11214079,11266788,11266793,11266798,11266799,11266806,11266809,11323021,11323026,11323028,11323034,11323037,11323039,11337861,11374525,11374530,11374532,11374538,11374541,11374543,11418449,11418454,11418456,11418462,11418465,11418467,11464327,11464332,11464334,11464340,11464343,11464345,11479161,11513513,11513518,11513520,11513526,11513529,11513531,11530192,11556543,11556548,11556550,11556556,11556559,11556561,11600464,11600465,11600471,11600475,11600478,11600484,11649244,11649245,11649251,11649255,11649258,11649264,11671390,11671391,11671397,11671401,11671404,11671410,11739003,11739004,11739010,11739014,11739017,11739023,11786765,11786766,11786772,11786776,11786779,11786785,11805212,11836979,11836980,11836986,11836990,11836993,11836999,11852601,11868776,11868781,11868783,11868789,11868792,11868794,11895838,11923774,11923779,11923782,11923787,11923790,11923795,11963930,11963935,11963937,11963943,11963946,11963948,11980314,12004126,12004131,12004133,12004139,12004142,12004144,12045234,12045239,12045241,12045247,12045250,12045252,12061182,12084426,12084431,12084434,12084439,12084442,12084447,20089,20094,20097,20102,20105,20110,71347,71352,71354,71360,71363,71365,111580,111581,111587,111591,111594,111600,158240,158241,158247,158251,158254,158260,192560,192561,192567,192571,192574,192580,232640,232641,232647,232651,232654,232660,273138,273143,273148,273149,273156,273159,312192,312197,312202,312203,312210,312213,357048,357053,357058,357059,357066,357069) ) 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(140) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 3152 WHERE `RP`.`player` = 3152 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125208,126394,128159,129062,130313,132001,204139,206132,209419,209569,209662,209751,280442,280448,280451,280456,280459,280461,301765,338568,338574,338577,338582,338585,338587,10398360,10398366,10398369,10398374,10398377,10398379,10479245,10479250,10479253,10479258,10479261,10479266,10541988,10541994,10541997,10542002,10542005,10542007,10604867,10604872,10604875,10604880,10604883,10604888,10662997,10663002,10663005,10663010,10663013,10663018,10726171,10726176,10726179,10726184,10726187,10726192,10757374,10796942,10796948,10796951,10796956,10796959,10796961,10876580,10876586,10876589,10876594,10876597,10876599,10919665,10919667,10919674,10919677,10919680,10919686,10964437,10964439,10964446,10964449,10964452,10964458,11014965,11014970,11014973,11014978,11014981,11014986,11069341,11069346,11069349,11069354,11069357,11069362,11122373,11122378,11122380,11122386,11122389,11122391,11139723,11170215,11170220,11170222,11170228,11170231,11170233,11186271,11214061,11214066,11214068,11214074,11214077,11214079,11266788,11266793,11266798,11266799,11266806,11266809,11323021,11323026,11323028,11323034,11323037,11323039,11337861,11374525,11374530,11374532,11374538,11374541,11374543,11418449,11418454,11418456,11418462,11418465,11418467,11464327,11464332,11464334,11464340,11464343,11464345,11479161,11513513,11513518,11513520,11513526,11513529,11513531,11530192,11556543,11556548,11556550,11556556,11556559,11556561,11600464,11600465,11600471,11600475,11600478,11600484,11649244,11649245,11649251,11649255,11649258,11649264,11671390,11671391,11671397,11671401,11671404,11671410,11739003,11739004,11739010,11739014,11739017,11739023,11786765,11786766,11786772,11786776,11786779,11786785,11805212,11836979,11836980,11836986,11836990,11836993,11836999,11852601,11868776,11868781,11868783,11868789,11868792,11868794,11895838,11923774,11923779,11923782,11923787,11923790,11923795,11963930,11963935,11963937,11963943,11963946,11963948,11980314,12004126,12004131,12004133,12004139,12004142,12004144,12045234,12045239,12045241,12045247,12045250,12045252,12061182,12084426,12084431,12084434,12084439,12084442,12084447,20089,20094,20097,20102,20105,20110,71347,71352,71354,71360,71363,71365,111580,111581,111587,111591,111594,111600,158240,158241,158247,158251,158254,158260,192560,192561,192567,192571,192574,192580,232640,232641,232647,232651,232654,232660,273138,273143,273148,273149,273156,273159,312192,312197,312202,312203,312210,312213,357048,357053,357058,357059,357066,357069) ) 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.048 сек (4)
Size=(58826)