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

Скюли Йон Фридгейрссон

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных100271105.5046
Национальная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
Молодежная сборная100271105.5046
     Отборочный турнир100271105.5046
     Финальный турнир000000000.000
ТОВЫ сборных2000131306.0090
Всего за сборные3002202405.83136
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 46783 WHERE `RP`.`player` = 46783 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126344,128193,129010,130043,206082,209453,209610,209699,280972,280975,280978,280981,280988,280991,338162,338165,338168,338171,338178,338181,10398094,10398097,10398100,10398103,10398110,10398113,10478984,10478987,10478990,10478993,10479000,10479003,10542374,10542377,10542380,10542383,10542390,10542393,10567344,10604437,10604439,10604446,10604449,10604452,10604458,10662902,10662908,10662911,10662916,10662919,10662921,10690375,10726388,10726394,10726397,10726402,10726405,10726407,10796703,10796705,10796712,10796715,10796718,10796724,10825113,10876388,10876394,10876397,10876402,10876405,10876407,10892863,10920024,10920030,10920033,10920038,10920041,10920043,10964266,10964272,10964275,10964280,10964283,10964285,11014869,11014874,11014877,11014882,11014885,11014890,11036237,11069581,11069586,11069589,11069594,11069597,11069602,11122107,11122112,11122115,11122120,11122123,11122128,11139734,11170501,11170506,11170509,11170514,11170517,11170522,11213725,11213730,11213732,11213738,11213741,11213743,11229110,11266645,11266650,11266652,11266658,11266661,11266663,11284037,11323334,11323335,11323341,11323345,11323348,11323354,11375030,11375031,11375037,11375041,11375044,11375050,11418689,11418694,11418696,11418702,11418705,11418707,11433517,11464687,11464692,11464694,11464700,11464703,11464705,11513921,11513926,11513928,11513934,11513937,11513939,11557000,11557001,11557007,11557011,11557014,11557020,11573289,11600727,11600732,11600734,11600740,11600743,11600745,11649460,11649461,11649467,11649471,11649474,11649480,11671556,11671561,11671566,11671567,11671574,11671577,11711141,11739362,11739367,11739369,11739375,11739378,11739380,11786980,11786985,11786987,11786993,11786996,11786998,11805216,11837243,11837244,11837250,11837254,11837257,11837263,11852591,11868921,11868922,11868928,11868932,11868935,11868941,11924089,11924090,11924096,11924100,11924103,11924109,11964003,11964004,11964010,11964014,11964017,11964023,11980333,12004415,12004416,12004422,12004426,12004429,12004435,12021341,12045523,12045524,12045530,12045534,12045537,12045543,12061189,12084812,12084817,12084819,12084825,12084828,12084830,12101120,20187,20192,20194,20200,20203,20205,47387,71849,71854,71857,71862,71865,71870,111913,111918,111921,111926,111929,111934,158359,158364,158366,158372,158375,158377,192847,192852,192854,192860,192863,192865,232376,232377,232383,232387,232390,232396,273474,273479,273484,273485,273492,273495,312698,312699,312705,312709,312712,312718,357194,357195,357201,357205,357208,357214) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 46783 WHERE `RP`.`player` = 46783 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126344,128193,129010,130043,206082,209453,209610,209699,280972,280975,280978,280981,280988,280991,338162,338165,338168,338171,338178,338181,10398094,10398097,10398100,10398103,10398110,10398113,10478984,10478987,10478990,10478993,10479000,10479003,10542374,10542377,10542380,10542383,10542390,10542393,10567344,10604437,10604439,10604446,10604449,10604452,10604458,10662902,10662908,10662911,10662916,10662919,10662921,10690375,10726388,10726394,10726397,10726402,10726405,10726407,10796703,10796705,10796712,10796715,10796718,10796724,10825113,10876388,10876394,10876397,10876402,10876405,10876407,10892863,10920024,10920030,10920033,10920038,10920041,10920043,10964266,10964272,10964275,10964280,10964283,10964285,11014869,11014874,11014877,11014882,11014885,11014890,11036237,11069581,11069586,11069589,11069594,11069597,11069602,11122107,11122112,11122115,11122120,11122123,11122128,11139734,11170501,11170506,11170509,11170514,11170517,11170522,11213725,11213730,11213732,11213738,11213741,11213743,11229110,11266645,11266650,11266652,11266658,11266661,11266663,11284037,11323334,11323335,11323341,11323345,11323348,11323354,11375030,11375031,11375037,11375041,11375044,11375050,11418689,11418694,11418696,11418702,11418705,11418707,11433517,11464687,11464692,11464694,11464700,11464703,11464705,11513921,11513926,11513928,11513934,11513937,11513939,11557000,11557001,11557007,11557011,11557014,11557020,11573289,11600727,11600732,11600734,11600740,11600743,11600745,11649460,11649461,11649467,11649471,11649474,11649480,11671556,11671561,11671566,11671567,11671574,11671577,11711141,11739362,11739367,11739369,11739375,11739378,11739380,11786980,11786985,11786987,11786993,11786996,11786998,11805216,11837243,11837244,11837250,11837254,11837257,11837263,11852591,11868921,11868922,11868928,11868932,11868935,11868941,11924089,11924090,11924096,11924100,11924103,11924109,11964003,11964004,11964010,11964014,11964017,11964023,11980333,12004415,12004416,12004422,12004426,12004429,12004435,12021341,12045523,12045524,12045530,12045534,12045537,12045543,12061189,12084812,12084817,12084819,12084825,12084828,12084830,12101120,20187,20192,20194,20200,20203,20205,47387,71849,71854,71857,71862,71865,71870,111913,111918,111921,111926,111929,111934,158359,158364,158366,158372,158375,158377,192847,192852,192854,192860,192863,192865,232376,232377,232383,232387,232390,232396,273474,273479,273484,273485,273492,273495,312698,312699,312705,312709,312712,312718,357194,357195,357201,357205,357208,357214) ) 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.075 сек (3)
Size=(58899)