Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 7 | 0 | 0 | 97 | 242 | 8 | 49 | 0 | 8.07 | 640 |
Национальная сборная | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Отборочный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 7 | 0 | 0 | 97 | 242 | 8 | 49 | 0 | 8.07 | 640 |
Отборочный турнир | 5 | 0 | 0 | 78 | 176 | 1 | 28 | 0 | 8.20 | 456 |
Финальный турнир | 2 | 0 | 0 | 19 | 66 | 7 | 21 | 0 | 7.75 | 184 |
ТОВЫ сборных | 7 | 0 | 0 | 70 | 195 | 8 | 34 | 1 | 7.36 | 647 |
Всего за сборные | 14 | 0 | 0 | 167 | 437 | 16 | 83 | 1 | 7.71 | 1287 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 83668 WHERE `RP`.`player` = 83668 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125240,126338,128191,129004,130039,204173,206076,209451,209604,209695,280778,280784,280787,280792,280795,280797,338161,338163,338170,338173,338176,338182,10398093,10398095,10398102,10398105,10398108,10398114,10441224,10441225,10441231,10442080,10479175,10479177,10479184,10479187,10479190,10479196,10542372,10542378,10542381,10542386,10542389,10542391,10604485,10604487,10604494,10604497,10604500,10604506,10662807,10662809,10662816,10662819,10662822,10662828,10726462,10726465,10726468,10726471,10726478,10726481,10796656,10796659,10796662,10796665,10796672,10796675,10876342,10876345,10876348,10876351,10876358,10876361,10919929,10919931,10919938,10919941,10919944,10919950,10964171,10964173,10964180,10964183,10964186,10964192,10982979,10982984,10982986,11014751,11014756,11014758,11014764,11014767,11014769,11069560,11069561,11069567,11069571,11069574,11069580,11122156,11122161,11122166,11122167,11122174,11122177,11170526,11170531,11170536,11170537,11170544,11170547,11213772,11213777,11213782,11213783,11213790,11213793,11266476,11266481,11266486,11266487,11266494,11266497,11323380,11323385,11323390,11323391,11323398,11323401,11374932,11374937,11374942,11374943,11374950,11374953,11418616,11418621,11418626,11418627,11418634,11418637,11464710,11464715,11464720,11464721,11464728,11464731,11513872,11513877,11513882,11513883,11513890,11513893,11557022,11557027,11557032,11557033,11557040,11557043,11600726,11600731,11600736,11600737,11600744,11600747,11649650,11649655,11649660,11649661,11649668,11649671,11671724,11671729,11671734,11671735,11671742,11671745,11711133,11739217,11739222,11739227,11739228,11739235,11739238,11756958,11786909,11786910,11786916,11786920,11786923,11786929,11805315,11805316,11805322,11837050,11837055,11837057,11837063,11837066,11837068,11868945,11868946,11868952,11868956,11868959,11868965,11895852,11924017,11924018,11924024,11924028,11924031,11924037,11940009,11940903,11940904,11940910,11964074,11964079,11964081,11964087,11964090,11964092,12004270,12004275,12004277,12004283,12004286,12004288,12045475,12045476,12045482,12045486,12045489,12045495,12061191,12061987,12061992,12061997,12084835,12084840,12084845,12084846,12084853,12084856,20162,20167,20172,20173,20180,20183,71850,71855,71860,71861,71868,71871,111674,111679,111684,111685,111692,111695,158574,158579,158584,158585,158592,158595,172829,192726,192731,192736,192737,192744,192747,232328,232329,232335,232339,232342,232348,273450,273455,273460,273461,273468,273471,288013,312530,312531,312537,312541,312544,312550,331803,333302,333307,333312,357266,357267,357273,357277,357280,357286,372857,372862,372864) ) 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` = 83668 WHERE `RP`.`player` = 83668 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125240,126338,128191,129004,130039,204173,206076,209451,209604,209695,280778,280784,280787,280792,280795,280797,338161,338163,338170,338173,338176,338182,10398093,10398095,10398102,10398105,10398108,10398114,10441224,10441225,10441231,10442080,10479175,10479177,10479184,10479187,10479190,10479196,10542372,10542378,10542381,10542386,10542389,10542391,10604485,10604487,10604494,10604497,10604500,10604506,10662807,10662809,10662816,10662819,10662822,10662828,10726462,10726465,10726468,10726471,10726478,10726481,10796656,10796659,10796662,10796665,10796672,10796675,10876342,10876345,10876348,10876351,10876358,10876361,10919929,10919931,10919938,10919941,10919944,10919950,10964171,10964173,10964180,10964183,10964186,10964192,10982979,10982984,10982986,11014751,11014756,11014758,11014764,11014767,11014769,11069560,11069561,11069567,11069571,11069574,11069580,11122156,11122161,11122166,11122167,11122174,11122177,11170526,11170531,11170536,11170537,11170544,11170547,11213772,11213777,11213782,11213783,11213790,11213793,11266476,11266481,11266486,11266487,11266494,11266497,11323380,11323385,11323390,11323391,11323398,11323401,11374932,11374937,11374942,11374943,11374950,11374953,11418616,11418621,11418626,11418627,11418634,11418637,11464710,11464715,11464720,11464721,11464728,11464731,11513872,11513877,11513882,11513883,11513890,11513893,11557022,11557027,11557032,11557033,11557040,11557043,11600726,11600731,11600736,11600737,11600744,11600747,11649650,11649655,11649660,11649661,11649668,11649671,11671724,11671729,11671734,11671735,11671742,11671745,11711133,11739217,11739222,11739227,11739228,11739235,11739238,11756958,11786909,11786910,11786916,11786920,11786923,11786929,11805315,11805316,11805322,11837050,11837055,11837057,11837063,11837066,11837068,11868945,11868946,11868952,11868956,11868959,11868965,11895852,11924017,11924018,11924024,11924028,11924031,11924037,11940009,11940903,11940904,11940910,11964074,11964079,11964081,11964087,11964090,11964092,12004270,12004275,12004277,12004283,12004286,12004288,12045475,12045476,12045482,12045486,12045489,12045495,12061191,12061987,12061992,12061997,12084835,12084840,12084845,12084846,12084853,12084856,20162,20167,20172,20173,20180,20183,71850,71855,71860,71861,71868,71871,111674,111679,111684,111685,111692,111695,158574,158579,158584,158585,158592,158595,172829,192726,192731,192736,192737,192744,192747,232328,232329,232335,232339,232342,232348,273450,273455,273460,273461,273468,273471,288013,312530,312531,312537,312541,312544,312550,331803,333302,333307,333312,357266,357267,357273,357277,357280,357286,372857,372862,372864) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: