Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 14 | 0 | 3 | 122 | 356 | 7 | 74 | 1 | 7.14 | 996 |
Национальная сборная | 7 | 0 | 3 | 42 | 156 | 5 | 49 | 1 | 7.43 | 422 |
Отборочный турнир | 7 | 0 | 3 | 42 | 156 | 5 | 49 | 1 | 7.43 | 422 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 7 | 0 | 0 | 80 | 200 | 2 | 25 | 0 | 6.86 | 574 |
Отборочный турнир | 3 | 0 | 0 | 29 | 76 | 2 | 15 | 0 | 6.83 | 224 |
Финальный турнир | 4 | 0 | 0 | 51 | 124 | 0 | 10 | 0 | 6.88 | 350 |
ТОВЫ сборных | 8 | 0 | 1 | 50 | 186 | 2 | 24 | 0 | 6.56 | 513 |
Всего за сборные | 22 | 0 | 4 | 172 | 542 | 9 | 98 | 1 | 6.93 | 1509 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 64039 WHERE `RP`.`player` = 64039 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125232,126335,128184,129000,130031,204165,206071,209446,209600,209687,280898,280904,280907,280912,280915,280917,338232,338238,338241,338246,338249,338251,10369065,10398331,10398336,10398339,10398344,10398347,10398352,10440277,10479173,10479178,10479181,10479186,10479189,10479194,10542395,10542400,10542403,10542408,10542411,10542416,10604435,10604440,10604443,10604448,10604451,10604456,10637417,10662805,10662810,10662813,10662818,10662821,10662826,10690378,10726555,10726560,10726563,10726568,10726571,10726576,10796773,10796778,10796781,10796786,10796789,10796794,10876340,10876346,10876349,10876354,10876357,10876359,10919808,10919814,10919817,10919822,10919825,10919827,10964412,10964415,10964418,10964421,10964428,10964431,11014895,11014900,11014902,11014908,11014911,11014913,11069629,11069634,11069637,11069642,11069645,11069650,11122083,11122088,11122091,11122096,11122099,11122104,11170573,11170578,11170581,11170586,11170589,11170594,11213795,11213800,11213803,11213808,11213811,11213816,11266715,11266720,11266723,11266728,11266731,11266736,11323259,11323264,11323267,11323272,11323275,11323280,11374835,11374840,11374843,11374848,11374851,11374856,11391975,11418543,11418548,11418551,11418556,11418559,11418564,11464733,11464738,11464741,11464746,11464749,11464754,11513943,11513948,11513951,11513956,11513959,11513964,11556973,11556978,11556981,11556986,11556989,11556994,11573291,11600677,11600682,11600685,11600690,11600693,11600698,11649529,11649534,11649537,11649542,11649545,11649550,11671603,11671608,11671611,11671616,11671619,11671624,11739240,11739245,11739248,11739253,11739256,11739261,11787098,11787103,11787106,11787111,11787114,11787119,11805220,11837072,11837077,11837080,11837085,11837088,11837093,11868918,11868923,11868926,11868931,11868934,11868939,11923966,11923971,11923974,11923979,11923982,11923987,11964072,11964077,11964080,11964085,11964088,11964093,11980332,12004412,12004417,12004420,12004425,12004428,12004433,12045496,12045501,12045504,12045509,12045512,12045517,12084716,12084721,12084723,12084729,12084732,12084734,12101118,20233,20238,20241,20246,20249,20254,71657,71662,71665,71670,71673,71678,111745,111750,111753,111758,111761,111766,158381,158386,158389,158394,158397,158402,192823,192828,192830,192836,192839,192841,210104,232349,232354,232357,232362,232365,232370,247355,273401,273406,273409,273414,273417,273422,312647,312652,312655,312660,312663,312668,357311,357316,357319,357324,357327,357332,372004) ) 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` = 64039 WHERE `RP`.`player` = 64039 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125232,126335,128184,129000,130031,204165,206071,209446,209600,209687,280898,280904,280907,280912,280915,280917,338232,338238,338241,338246,338249,338251,10369065,10398331,10398336,10398339,10398344,10398347,10398352,10440277,10479173,10479178,10479181,10479186,10479189,10479194,10542395,10542400,10542403,10542408,10542411,10542416,10604435,10604440,10604443,10604448,10604451,10604456,10637417,10662805,10662810,10662813,10662818,10662821,10662826,10690378,10726555,10726560,10726563,10726568,10726571,10726576,10796773,10796778,10796781,10796786,10796789,10796794,10876340,10876346,10876349,10876354,10876357,10876359,10919808,10919814,10919817,10919822,10919825,10919827,10964412,10964415,10964418,10964421,10964428,10964431,11014895,11014900,11014902,11014908,11014911,11014913,11069629,11069634,11069637,11069642,11069645,11069650,11122083,11122088,11122091,11122096,11122099,11122104,11170573,11170578,11170581,11170586,11170589,11170594,11213795,11213800,11213803,11213808,11213811,11213816,11266715,11266720,11266723,11266728,11266731,11266736,11323259,11323264,11323267,11323272,11323275,11323280,11374835,11374840,11374843,11374848,11374851,11374856,11391975,11418543,11418548,11418551,11418556,11418559,11418564,11464733,11464738,11464741,11464746,11464749,11464754,11513943,11513948,11513951,11513956,11513959,11513964,11556973,11556978,11556981,11556986,11556989,11556994,11573291,11600677,11600682,11600685,11600690,11600693,11600698,11649529,11649534,11649537,11649542,11649545,11649550,11671603,11671608,11671611,11671616,11671619,11671624,11739240,11739245,11739248,11739253,11739256,11739261,11787098,11787103,11787106,11787111,11787114,11787119,11805220,11837072,11837077,11837080,11837085,11837088,11837093,11868918,11868923,11868926,11868931,11868934,11868939,11923966,11923971,11923974,11923979,11923982,11923987,11964072,11964077,11964080,11964085,11964088,11964093,11980332,12004412,12004417,12004420,12004425,12004428,12004433,12045496,12045501,12045504,12045509,12045512,12045517,12084716,12084721,12084723,12084729,12084732,12084734,12101118,20233,20238,20241,20246,20249,20254,71657,71662,71665,71670,71673,71678,111745,111750,111753,111758,111761,111766,158381,158386,158389,158394,158397,158402,192823,192828,192830,192836,192839,192841,210104,232349,232354,232357,232362,232365,232370,247355,273401,273406,273409,273414,273417,273422,312647,312652,312655,312660,312663,312668,357311,357316,357319,357324,357327,357332,372004) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: