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

Йеспер Шульц

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыСэйвыОцМин
Официальные матчи сборных90006000527.67368
Национальная сборная40002800347.75368
     Отборочный турнир40002800347.75368
     Финальный турнир000000000.000
Молодежная сборная50003200187.600
     Отборочный турнир50003200187.600
     Финальный турнир000000000.000
ТОВЫ сборных70002400186.71338
Всего за сборные160008400707.25706
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыСэйвыОцМин
(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` = 41115 WHERE `RP`.`player` = 41115 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125249,128198,129015,130044,204180,209460,209613,209702,246926,246931,246936,280756,280759,280762,280765,280772,280775,338090,338093,338096,338099,338106,338109,10398286,10398289,10398292,10398295,10398302,10398305,10479200,10479203,10479206,10479209,10479216,10479219,10512402,10513342,10513347,10513352,10542373,10542375,10542382,10542385,10542388,10542394,10604486,10604489,10604492,10604495,10604502,10604505,10662736,10662739,10662742,10662745,10662752,10662755,10726605,10726607,10726614,10726617,10726620,10726626,10757392,10758490,10758495,10758500,10760392,10796678,10796684,10796687,10796692,10796695,10796697,10876412,10876418,10876421,10876426,10876429,10876431,10919930,10919933,10919936,10919939,10919946,10919949,10937972,10937973,10937979,10939496,10964170,10964176,10964179,10964184,10964187,10964189,11014848,11014849,11014855,11014859,11014862,11014868,11036243,11038280,11038285,11038290,11038748,11069655,11069660,11069662,11069668,11069671,11069673,11085723,11085728,11085731,11087183,11122059,11122064,11122067,11122072,11122075,11122080,11140297,11140302,11140305,11141169,11141807,11141975,11170549,11170554,11170557,11170562,11170565,11170570,11186659,11186664,11186667,11188246,11213867,11213872,11213875,11213880,11213883,11213888,11266523,11266528,11266531,11266536,11266539,11266544,11286115,11286120,11286123,11286601,11286697,11287739,11323235,11323240,11323243,11323248,11323251,11323256,11337849,11339788,11339789,11339795,11374787,11374792,11374795,11374800,11374803,11374808,11392979,11392984,11392987,11418735,11418740,11418743,11418748,11418751,11418756,11464589,11464594,11464597,11464602,11464605,11464610,11479169,11481246,11481251,11481256,11481638,11481773,11481863,11513969,11513974,11513976,11513982,11513985,11513987,11530201,11531564,11531569,11531574,11556831,11556836,11556838,11556844,11556847,11556849,11573294,11574764,11574769,11574774,11600607,11600612,11600614,11600620,11600623,11600625,11649628,11649629,11649635,11649639,11649642,11649648,11671484,11671489,11671494,11671495,11671502,11671505,11712025,11712026,11712032,11713177,11739387,11739388,11739394,11739398,11739401,11739407,11786957,11786958,11786964,11786968,11786971,11786977,11837123,11837124,11837130,11837134,11837137,11837143,11868823,11868828,11868833,11868834,11868841,11868844,11896701,11896702,11896708,11896914,11924158,11924163,11924166,11924171,11924174,11924179,11964026,11964031,11964033,11964039,11964042,11964044,11980452,11980457,11980459,11981342,12004292,12004297,12004300,12004305,12004308,12004313,12045402,12045407,12045409,12045415,12045418,12045420,12084595,12084600,12084605,12084606,12084613,12084616,20330,20335,20340,20341,20348,20351,47390,71612,71613,71619,71623,71626,71632,111892,111893,111899,111903,111906,111912,158480,158481,158487,158491,158494,158500,192896,192897,192903,192907,192910,192916,232230,232235,232240,232241,232248,232251,273258,273263,273268,273269,273276,273279,312480,312485,312490,312491,312498,312501,357216,357221,357226,357227,357234,357237) ) 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` = 41115 WHERE `RP`.`player` = 41115 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125249,128198,129015,130044,204180,209460,209613,209702,246926,246931,246936,280756,280759,280762,280765,280772,280775,338090,338093,338096,338099,338106,338109,10398286,10398289,10398292,10398295,10398302,10398305,10479200,10479203,10479206,10479209,10479216,10479219,10512402,10513342,10513347,10513352,10542373,10542375,10542382,10542385,10542388,10542394,10604486,10604489,10604492,10604495,10604502,10604505,10662736,10662739,10662742,10662745,10662752,10662755,10726605,10726607,10726614,10726617,10726620,10726626,10757392,10758490,10758495,10758500,10760392,10796678,10796684,10796687,10796692,10796695,10796697,10876412,10876418,10876421,10876426,10876429,10876431,10919930,10919933,10919936,10919939,10919946,10919949,10937972,10937973,10937979,10939496,10964170,10964176,10964179,10964184,10964187,10964189,11014848,11014849,11014855,11014859,11014862,11014868,11036243,11038280,11038285,11038290,11038748,11069655,11069660,11069662,11069668,11069671,11069673,11085723,11085728,11085731,11087183,11122059,11122064,11122067,11122072,11122075,11122080,11140297,11140302,11140305,11141169,11141807,11141975,11170549,11170554,11170557,11170562,11170565,11170570,11186659,11186664,11186667,11188246,11213867,11213872,11213875,11213880,11213883,11213888,11266523,11266528,11266531,11266536,11266539,11266544,11286115,11286120,11286123,11286601,11286697,11287739,11323235,11323240,11323243,11323248,11323251,11323256,11337849,11339788,11339789,11339795,11374787,11374792,11374795,11374800,11374803,11374808,11392979,11392984,11392987,11418735,11418740,11418743,11418748,11418751,11418756,11464589,11464594,11464597,11464602,11464605,11464610,11479169,11481246,11481251,11481256,11481638,11481773,11481863,11513969,11513974,11513976,11513982,11513985,11513987,11530201,11531564,11531569,11531574,11556831,11556836,11556838,11556844,11556847,11556849,11573294,11574764,11574769,11574774,11600607,11600612,11600614,11600620,11600623,11600625,11649628,11649629,11649635,11649639,11649642,11649648,11671484,11671489,11671494,11671495,11671502,11671505,11712025,11712026,11712032,11713177,11739387,11739388,11739394,11739398,11739401,11739407,11786957,11786958,11786964,11786968,11786971,11786977,11837123,11837124,11837130,11837134,11837137,11837143,11868823,11868828,11868833,11868834,11868841,11868844,11896701,11896702,11896708,11896914,11924158,11924163,11924166,11924171,11924174,11924179,11964026,11964031,11964033,11964039,11964042,11964044,11980452,11980457,11980459,11981342,12004292,12004297,12004300,12004305,12004308,12004313,12045402,12045407,12045409,12045415,12045418,12045420,12084595,12084600,12084605,12084606,12084613,12084616,20330,20335,20340,20341,20348,20351,47390,71612,71613,71619,71623,71626,71632,111892,111893,111899,111903,111906,111912,158480,158481,158487,158491,158494,158500,192896,192897,192903,192907,192910,192916,232230,232235,232240,232241,232248,232251,273258,273263,273268,273269,273276,273279,312480,312485,312490,312491,312498,312501,357216,357221,357226,357227,357234,357237) ) 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.101 сек (5)
Size=(59721)