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

Пьер Бенгтсон

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных100004005.5061
Национальная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
Молодежная сборная100004005.5061
     Отборочный турнир100004005.5061
     Финальный турнир000000000.000
ТОВЫ сборных000000000.000
Всего за сборные100004005.5061
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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` = 45412 WHERE `RP`.`player` = 45412 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125249,128198,129015,130044,204180,209460,209613,209702,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,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,10796678,10796684,10796687,10796692,10796695,10796697,10876412,10876418,10876421,10876426,10876429,10876431,10919930,10919933,10919936,10919939,10919946,10919949,10964170,10964176,10964179,10964184,10964187,10964189,11014848,11014849,11014855,11014859,11014862,11014868,11036243,11069655,11069660,11069662,11069668,11069671,11069673,11122059,11122064,11122067,11122072,11122075,11122080,11170549,11170554,11170557,11170562,11170565,11170570,11213867,11213872,11213875,11213880,11213883,11213888,11266523,11266528,11266531,11266536,11266539,11266544,11323235,11323240,11323243,11323248,11323251,11323256,11337849,11374787,11374792,11374795,11374800,11374803,11374808,11418735,11418740,11418743,11418748,11418751,11418756,11464589,11464594,11464597,11464602,11464605,11464610,11479169,11513969,11513974,11513976,11513982,11513985,11513987,11530201,11556831,11556836,11556838,11556844,11556847,11556849,11573294,11600607,11600612,11600614,11600620,11600623,11600625,11649628,11649629,11649635,11649639,11649642,11649648,11671484,11671489,11671494,11671495,11671502,11671505,11739387,11739388,11739394,11739398,11739401,11739407,11786957,11786958,11786964,11786968,11786971,11786977,11837123,11837124,11837130,11837134,11837137,11837143,11868823,11868828,11868833,11868834,11868841,11868844,11924158,11924163,11924166,11924171,11924174,11924179,11964026,11964031,11964033,11964039,11964042,11964044,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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 45412 WHERE `RP`.`player` = 45412 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125249,128198,129015,130044,204180,209460,209613,209702,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,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,10796678,10796684,10796687,10796692,10796695,10796697,10876412,10876418,10876421,10876426,10876429,10876431,10919930,10919933,10919936,10919939,10919946,10919949,10964170,10964176,10964179,10964184,10964187,10964189,11014848,11014849,11014855,11014859,11014862,11014868,11036243,11069655,11069660,11069662,11069668,11069671,11069673,11122059,11122064,11122067,11122072,11122075,11122080,11170549,11170554,11170557,11170562,11170565,11170570,11213867,11213872,11213875,11213880,11213883,11213888,11266523,11266528,11266531,11266536,11266539,11266544,11323235,11323240,11323243,11323248,11323251,11323256,11337849,11374787,11374792,11374795,11374800,11374803,11374808,11418735,11418740,11418743,11418748,11418751,11418756,11464589,11464594,11464597,11464602,11464605,11464610,11479169,11513969,11513974,11513976,11513982,11513985,11513987,11530201,11556831,11556836,11556838,11556844,11556847,11556849,11573294,11600607,11600612,11600614,11600620,11600623,11600625,11649628,11649629,11649635,11649639,11649642,11649648,11671484,11671489,11671494,11671495,11671502,11671505,11739387,11739388,11739394,11739398,11739401,11739407,11786957,11786958,11786964,11786968,11786971,11786977,11837123,11837124,11837130,11837134,11837137,11837143,11868823,11868828,11868833,11868834,11868841,11868844,11924158,11924163,11924166,11924171,11924174,11924179,11964026,11964031,11964033,11964039,11964042,11964044,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.114 сек (4)
Size=(58711)