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, 140, 207, 208) 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 (125203,126344,126390,128193,128149,129010,129058,130043,130303,204132,206082,206128,209453,209409,209610,209658,209699,209741,246877,246882,246885,250355,250960,251093,280972,280681,280975,280686,280978,280689,280981,280694,280988,280697,280991,280702,303503,303508,303510,303659,338162,338351,338165,338356,338168,338359,338171,338364,338178,338367,338181,338372,10398094,10398553,10398097,10398555,10398100,10398562,10398103,10398565,10398110,10398568,10398113,10398574,10478984,10479391,10478987,10479393,10478990,10479400,10478993,10479403,10479000,10479406,10479003,10479412,10542374,10542061,10542377,10542063,10542380,10542070,10542383,10542073,10542390,10542076,10542393,10542082,10567344,10604437,10604918,10604439,10604921,10604446,10604924,10604449,10604927,10604452,10604934,10604458,10604937,10639502,10639561,10639503,10639566,10639509,10639568,10662902,10663095,10662908,10663097,10662911,10663104,10662916,10663107,10662919,10663110,10662921,10663116,10690375,10726388,10726318,10726394,10726321,10726397,10726324,10726402,10726327,10726405,10726334,10726407,10726337,10758420,10758421,10758427,10760385,10796703,10797063,10796705,10797065,10796712,10797072,10796715,10797075,10796718,10797078,10796724,10797084,10825113,10826220,10826221,10826227,10826536,10826635,10827312,10876388,10876532,10876394,10876538,10876397,10876541,10876402,10876546,10876405,10876549,10876407,10876551,10892863,10893699,10893770,10893704,10893775,10893706,10893780,10920024,10919759,10920030,10919764,10920033,10919767,10920038,10919772,10920041,10919775,10920043,10919780,10964266,10964460,10964272,10964466,10964275,10964469,10964280,10964474,10964283,10964477,10964285,10964479,10982977,10982982,10982985,10983333,10984031,10985555,11014869,11015160,11014874,11015161,11014877,11015167,11014882,11015171,11014885,11015174,11014890,11015180,11036237,11038282,11038283,11038289,11069581,11069294,11069586,11069299,11069589,11069304,11069594,11069305,11069597,11069312,11069602,11069315,11085699,11085704,11085707,11087188,11122107,11122350,11122112,11122351,11122115,11122357,11122120,11122361,11122123,11122364,11122128,11122370,11139734,11170501,11170310,11170506,11170315,11170509,11170320,11170514,11170321,11170517,11170328,11170522,11170331,11213725,11214206,11213730,11214207,11213732,11214213,11213738,11214217,11213741,11214220,11213743,11214226,11229110,11266645,11266933,11266650,11266938,11266652,11266940,11266658,11266946,11266661,11266949,11266663,11266951,11284037,11286104,11286109,11286114,11323334,11323093,11323335,11323098,11323341,11323100,11323345,11323106,11323348,11323109,11323354,11323111,11337867,11339740,11339741,11339747,11375030,11374765,11375031,11374770,11375037,11374772,11375041,11374778,11375044,11374781,11375050,11374783,11391965,11393017,11393022,11393024,11418689,11418497,11418694,11418502,11418696,11418504,11418702,11418510,11418705,11418513,11418707,11418515,11433517,11434129,11434134,11434137,11435323,11464687,11464349,11464692,11464354,11464694,11464357,11464700,11464362,11464703,11464365,11464705,11464370,11481161,11481166,11481169,11513921,11513511,11513926,11513516,11513928,11513519,11513934,11513524,11513937,11513527,11513939,11513532,11531529,11531590,11531534,11531591,11531536,11531597,11557000,11556613,11557001,11556618,11557007,11556621,11557011,11556626,11557014,11556629,11557020,11556634,11573289,11574717,11574776,11574722,11574781,11574724,11574786,11575592,11600727,11600365,11600732,11600370,11600734,11600373,11600740,11600378,11600743,11600381,11600745,11600386,11618474,11618475,11618481,11619492,11649460,11649387,11649461,11649392,11649467,11649394,11649471,11649400,11649474,11649403,11649480,11649405,11666268,11671556,11671341,11671561,11671346,11671566,11671348,11671567,11671354,11671574,11671357,11671577,11671359,11711141,11711999,11712004,11712009,11713178,11739362,11738906,11739367,11738911,11739369,11738913,11739375,11738919,11739378,11738922,11739380,11738924,11786980,11786692,11786985,11786697,11786987,11786699,11786993,11786705,11786996,11786708,11786998,11786710,11805216,11837243,11837001,11837244,11837006,11837250,11837011,11837254,11837012,11837257,11837019,11837263,11837022,11852591,11868921,11868559,11868922,11868564,11868928,11868569,11868932,11868570,11868935,11868577,11868941,11868580,11924089,11923919,11924090,11923924,11924096,11923929,11924100,11923930,11924103,11923937,11924109,11923940,11964003,11963809,11964004,11963814,11964010,11963819,11964014,11963820,11964017,11963827,11964023,11963830,11980333,12004415,12004077,12004416,12004082,12004422,12004087,12004426,12004088,12004429,12004095,12004435,12004098,12021341,12021446,12021451,12021453,12045523,12045306,12045524,12045311,12045530,12045313,12045534,12045319,12045537,12045322,12045543,12045324,12061189,12061178,12061963,12061968,12061973,12084812,12084476,12084817,12084481,12084819,12084483,12084825,12084489,12084828,12084492,12084830,12084494,12101120,20187,19899,20192,19904,20194,19906,20200,19912,20203,19915,20205,19917,47387,47374,48110,48026,48115,48031,48120,48036,48357,48820,49101,71849,71491,71854,71496,71857,71498,71862,71504,71865,71507,71870,71509,111913,111459,111918,111464,111921,111466,111926,111472,111929,111475,111934,111477,158359,158096,158364,158097,158366,158103,158372,158107,158375,158110,158377,158116,173626,173627,173633,174564,174668,175361,192847,192533,192852,192538,192854,192541,192860,192546,192863,192549,192865,192554,210094,232376,232495,232377,232500,232383,232502,232387,232508,232390,232511,232396,232513,247340,248116,248121,248126,273474,273017,273479,273022,273484,273025,273485,273030,273492,273033,273495,273038,288813,288818,288821,289787,290018,290578,312698,312383,312699,312388,312705,312391,312709,312396,312712,312399,312718,312404,331801,333230,333235,333240,333568,334620,334997,357194,356975,357195,356980,357201,356983,357205,356988,357208,356991,357214,356996,371993,372786,372787,372793,373739) ) 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, 140, 207, 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` = 46783 WHERE `RP`.`player` = 46783 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125203,126344,126390,128193,128149,129010,129058,130043,130303,204132,206082,206128,209453,209409,209610,209658,209699,209741,246877,246882,246885,250355,250960,251093,280972,280681,280975,280686,280978,280689,280981,280694,280988,280697,280991,280702,303503,303508,303510,303659,338162,338351,338165,338356,338168,338359,338171,338364,338178,338367,338181,338372,10398094,10398553,10398097,10398555,10398100,10398562,10398103,10398565,10398110,10398568,10398113,10398574,10478984,10479391,10478987,10479393,10478990,10479400,10478993,10479403,10479000,10479406,10479003,10479412,10542374,10542061,10542377,10542063,10542380,10542070,10542383,10542073,10542390,10542076,10542393,10542082,10567344,10604437,10604918,10604439,10604921,10604446,10604924,10604449,10604927,10604452,10604934,10604458,10604937,10639502,10639561,10639503,10639566,10639509,10639568,10662902,10663095,10662908,10663097,10662911,10663104,10662916,10663107,10662919,10663110,10662921,10663116,10690375,10726388,10726318,10726394,10726321,10726397,10726324,10726402,10726327,10726405,10726334,10726407,10726337,10758420,10758421,10758427,10760385,10796703,10797063,10796705,10797065,10796712,10797072,10796715,10797075,10796718,10797078,10796724,10797084,10825113,10826220,10826221,10826227,10826536,10826635,10827312,10876388,10876532,10876394,10876538,10876397,10876541,10876402,10876546,10876405,10876549,10876407,10876551,10892863,10893699,10893770,10893704,10893775,10893706,10893780,10920024,10919759,10920030,10919764,10920033,10919767,10920038,10919772,10920041,10919775,10920043,10919780,10964266,10964460,10964272,10964466,10964275,10964469,10964280,10964474,10964283,10964477,10964285,10964479,10982977,10982982,10982985,10983333,10984031,10985555,11014869,11015160,11014874,11015161,11014877,11015167,11014882,11015171,11014885,11015174,11014890,11015180,11036237,11038282,11038283,11038289,11069581,11069294,11069586,11069299,11069589,11069304,11069594,11069305,11069597,11069312,11069602,11069315,11085699,11085704,11085707,11087188,11122107,11122350,11122112,11122351,11122115,11122357,11122120,11122361,11122123,11122364,11122128,11122370,11139734,11170501,11170310,11170506,11170315,11170509,11170320,11170514,11170321,11170517,11170328,11170522,11170331,11213725,11214206,11213730,11214207,11213732,11214213,11213738,11214217,11213741,11214220,11213743,11214226,11229110,11266645,11266933,11266650,11266938,11266652,11266940,11266658,11266946,11266661,11266949,11266663,11266951,11284037,11286104,11286109,11286114,11323334,11323093,11323335,11323098,11323341,11323100,11323345,11323106,11323348,11323109,11323354,11323111,11337867,11339740,11339741,11339747,11375030,11374765,11375031,11374770,11375037,11374772,11375041,11374778,11375044,11374781,11375050,11374783,11391965,11393017,11393022,11393024,11418689,11418497,11418694,11418502,11418696,11418504,11418702,11418510,11418705,11418513,11418707,11418515,11433517,11434129,11434134,11434137,11435323,11464687,11464349,11464692,11464354,11464694,11464357,11464700,11464362,11464703,11464365,11464705,11464370,11481161,11481166,11481169,11513921,11513511,11513926,11513516,11513928,11513519,11513934,11513524,11513937,11513527,11513939,11513532,11531529,11531590,11531534,11531591,11531536,11531597,11557000,11556613,11557001,11556618,11557007,11556621,11557011,11556626,11557014,11556629,11557020,11556634,11573289,11574717,11574776,11574722,11574781,11574724,11574786,11575592,11600727,11600365,11600732,11600370,11600734,11600373,11600740,11600378,11600743,11600381,11600745,11600386,11618474,11618475,11618481,11619492,11649460,11649387,11649461,11649392,11649467,11649394,11649471,11649400,11649474,11649403,11649480,11649405,11666268,11671556,11671341,11671561,11671346,11671566,11671348,11671567,11671354,11671574,11671357,11671577,11671359,11711141,11711999,11712004,11712009,11713178,11739362,11738906,11739367,11738911,11739369,11738913,11739375,11738919,11739378,11738922,11739380,11738924,11786980,11786692,11786985,11786697,11786987,11786699,11786993,11786705,11786996,11786708,11786998,11786710,11805216,11837243,11837001,11837244,11837006,11837250,11837011,11837254,11837012,11837257,11837019,11837263,11837022,11852591,11868921,11868559,11868922,11868564,11868928,11868569,11868932,11868570,11868935,11868577,11868941,11868580,11924089,11923919,11924090,11923924,11924096,11923929,11924100,11923930,11924103,11923937,11924109,11923940,11964003,11963809,11964004,11963814,11964010,11963819,11964014,11963820,11964017,11963827,11964023,11963830,11980333,12004415,12004077,12004416,12004082,12004422,12004087,12004426,12004088,12004429,12004095,12004435,12004098,12021341,12021446,12021451,12021453,12045523,12045306,12045524,12045311,12045530,12045313,12045534,12045319,12045537,12045322,12045543,12045324,12061189,12061178,12061963,12061968,12061973,12084812,12084476,12084817,12084481,12084819,12084483,12084825,12084489,12084828,12084492,12084830,12084494,12101120,20187,19899,20192,19904,20194,19906,20200,19912,20203,19915,20205,19917,47387,47374,48110,48026,48115,48031,48120,48036,48357,48820,49101,71849,71491,71854,71496,71857,71498,71862,71504,71865,71507,71870,71509,111913,111459,111918,111464,111921,111466,111926,111472,111929,111475,111934,111477,158359,158096,158364,158097,158366,158103,158372,158107,158375,158110,158377,158116,173626,173627,173633,174564,174668,175361,192847,192533,192852,192538,192854,192541,192860,192546,192863,192549,192865,192554,210094,232376,232495,232377,232500,232383,232502,232387,232508,232390,232511,232396,232513,247340,248116,248121,248126,273474,273017,273479,273022,273484,273025,273485,273030,273492,273033,273495,273038,288813,288818,288821,289787,290018,290578,312698,312383,312699,312388,312705,312391,312709,312396,312712,312399,312718,312404,331801,333230,333235,333240,333568,334620,334997,357194,356975,357195,356980,357201,356983,357205,356988,357208,356991,357214,356996,371993,372786,372787,372793,373739) ) 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.104 сек (8)
Size=(65783)