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

Йерай Альварес

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных2008200406.75138
Национальная сборная1007160306.5092
     Отборочный турнир1007160306.5092
     Финальный турнир000000000.000
Молодежная сборная100140107.0046
     Отборочный турнир100140107.0046
     Финальный турнир000000000.000
ТОВЫ сборных000000000.000
Всего за сборные2008200406.75138
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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` = 65717 WHERE `RP`.`player` = 65717 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125215,126314,128161,128980,130017,204144,206052,209421,209582,209673,280947,280949,280956,280959,280962,280968,338329,338331,338338,338341,338344,338350,10369069,10398332,10398338,10398341,10398346,10398349,10398351,10479005,10479010,10479013,10479018,10479021,10479026,10512406,10542276,10542282,10542285,10542290,10542293,10542295,10604604,10604610,10604613,10604618,10604621,10604623,10662877,10662882,10662885,10662890,10662893,10662898,10726532,10726538,10726541,10726546,10726549,10726551,10796774,10796780,10796783,10796788,10796791,10796793,10825106,10876316,10876322,10876325,10876330,10876333,10876335,10919904,10919910,10919913,10919918,10919921,10919923,10964194,10964200,10964203,10964208,10964211,10964213,11014871,11014876,11014878,11014884,11014887,11014889,11069680,11069681,11069687,11069691,11069694,11069700,11084880,11121966,11121967,11121973,11121977,11121980,11121986,11170720,11170721,11170727,11170731,11170734,11170740,11213750,11213751,11213757,11213761,11213764,11213770,11229111,11266478,11266479,11266485,11266489,11266492,11266498,11284042,11323333,11323338,11323340,11323346,11323349,11323351,11337850,11374814,11374815,11374821,11374825,11374828,11374834,11418568,11418573,11418578,11418579,11418586,11418589,11433516,11464590,11464595,11464600,11464601,11464608,11464611,11513944,11513949,11513954,11513955,11513962,11513965,11556926,11556931,11556936,11556937,11556944,11556947,11600630,11600635,11600640,11600641,11600648,11600651,11616927,11649604,11649605,11649611,11649615,11649618,11649624,11666275,11671654,11671655,11671661,11671665,11671668,11671674,11711136,11739243,11739244,11739250,11739254,11739257,11739263,11756966,11786861,11786862,11786868,11786872,11786875,11786881,11805222,11837171,11837172,11837178,11837182,11837185,11837191,11869038,11869043,11869046,11869051,11869054,11869059,11924184,11924189,11924191,11924197,11924200,11924202,11940016,11964027,11964028,11964034,11964038,11964041,11964047,11980325,12004268,12004273,12004276,12004281,12004284,12004289,12045498,12045503,12045505,12045511,12045514,12045516,12084738,12084743,12084746,12084751,12084754,12084759,20329,20334,20337,20342,20345,20350,71705,71710,71713,71718,71721,71726,111673,111678,111681,111686,111689,111694,126201,158501,158506,158509,158514,158517,158522,172832,192941,192946,192949,192954,192957,192962,232256,232257,232263,232267,232270,232276,273475,273480,273482,273488,273491,273493,288012,312599,312604,312607,312612,312615,312620,357337,357342,357344,357350,357353,357355) ) 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` = 65717 WHERE `RP`.`player` = 65717 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125215,126314,128161,128980,130017,204144,206052,209421,209582,209673,280947,280949,280956,280959,280962,280968,338329,338331,338338,338341,338344,338350,10369069,10398332,10398338,10398341,10398346,10398349,10398351,10479005,10479010,10479013,10479018,10479021,10479026,10512406,10542276,10542282,10542285,10542290,10542293,10542295,10604604,10604610,10604613,10604618,10604621,10604623,10662877,10662882,10662885,10662890,10662893,10662898,10726532,10726538,10726541,10726546,10726549,10726551,10796774,10796780,10796783,10796788,10796791,10796793,10825106,10876316,10876322,10876325,10876330,10876333,10876335,10919904,10919910,10919913,10919918,10919921,10919923,10964194,10964200,10964203,10964208,10964211,10964213,11014871,11014876,11014878,11014884,11014887,11014889,11069680,11069681,11069687,11069691,11069694,11069700,11084880,11121966,11121967,11121973,11121977,11121980,11121986,11170720,11170721,11170727,11170731,11170734,11170740,11213750,11213751,11213757,11213761,11213764,11213770,11229111,11266478,11266479,11266485,11266489,11266492,11266498,11284042,11323333,11323338,11323340,11323346,11323349,11323351,11337850,11374814,11374815,11374821,11374825,11374828,11374834,11418568,11418573,11418578,11418579,11418586,11418589,11433516,11464590,11464595,11464600,11464601,11464608,11464611,11513944,11513949,11513954,11513955,11513962,11513965,11556926,11556931,11556936,11556937,11556944,11556947,11600630,11600635,11600640,11600641,11600648,11600651,11616927,11649604,11649605,11649611,11649615,11649618,11649624,11666275,11671654,11671655,11671661,11671665,11671668,11671674,11711136,11739243,11739244,11739250,11739254,11739257,11739263,11756966,11786861,11786862,11786868,11786872,11786875,11786881,11805222,11837171,11837172,11837178,11837182,11837185,11837191,11869038,11869043,11869046,11869051,11869054,11869059,11924184,11924189,11924191,11924197,11924200,11924202,11940016,11964027,11964028,11964034,11964038,11964041,11964047,11980325,12004268,12004273,12004276,12004281,12004284,12004289,12045498,12045503,12045505,12045511,12045514,12045516,12084738,12084743,12084746,12084751,12084754,12084759,20329,20334,20337,20342,20345,20350,71705,71710,71713,71718,71721,71726,111673,111678,111681,111686,111689,111694,126201,158501,158506,158509,158514,158517,158522,172832,192941,192946,192949,192954,192957,192962,232256,232257,232263,232267,232270,232276,273475,273480,273482,273488,273491,273493,288012,312599,312604,312607,312612,312615,312620,357337,357342,357344,357350,357353,357355) ) 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.103 сек (4)
Size=(59093)