Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 15 | 0 | 0 | 97 | 163 | 1 | 21 | 0 | 6.80 | 1173 |
Национальная сборная | 6 | 0 | 0 | 41 | 66 | 0 | 12 | 0 | 7.00 | 476 |
Отборочный турнир | 6 | 0 | 0 | 41 | 66 | 0 | 12 | 0 | 7.00 | 476 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 9 | 0 | 0 | 56 | 97 | 1 | 9 | 0 | 6.67 | 697 |
Отборочный турнир | 9 | 0 | 0 | 56 | 97 | 1 | 9 | 0 | 6.67 | 697 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 25 | 0 | 0 | 191 | 346 | 1 | 31 | 1 | 7.04 | 2047 |
Всего за сборные | 40 | 0 | 0 | 288 | 509 | 2 | 52 | 1 | 6.95 | 3220 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 74329 WHERE `RP`.`player` = 74329 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` = 74329 WHERE `RP`.`player` = 74329 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}: