Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 17 | 12 | 1 | 1 | 99 | 68 | 0 | 41 | 7.21 | 1146 |
Национальная сборная | 7 | 1 | 0 | 0 | 32 | 12 | 0 | 9 | 6.07 | 405 |
Отборочный турнир | 7 | 1 | 0 | 0 | 32 | 12 | 0 | 9 | 6.07 | 405 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 10 | 11 | 1 | 1 | 67 | 56 | 0 | 32 | 8.00 | 741 |
Отборочный турнир | 6 | 7 | 0 | 0 | 28 | 30 | 0 | 17 | 7.67 | 376 |
Финальный турнир | 4 | 4 | 1 | 1 | 39 | 26 | 0 | 15 | 8.50 | 365 |
ТОВЫ сборных | 36 | 17 | 6 | 9 | 323 | 98 | 0 | 53 | 6.97 | 2544 |
Всего за сборные | 53 | 29 | 7 | 10 | 422 | 166 | 0 | 94 | 7.05 | 3690 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 71508 WHERE `RP`.`player` = 71508 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` = 71508 WHERE `RP`.`player` = 71508 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}: