Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин | Официальные матчи сборных | 19 | 0 | 0 | 2 | 116 | 0 | 0 | 81 | 7.79 | 1122 |
Национальная сборная | 2 | 0 | 0 | 0 | 9 | 0 | 0 | 7 | 5.75 | 183 |
Отборочный турнир | 2 | 0 | 0 | 0 | 9 | 0 | 0 | 7 | 5.75 | 183 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 17 | 0 | 0 | 2 | 107 | 0 | 0 | 74 | 8.03 | 939 |
Отборочный турнир | 12 | 0 | 0 | 1 | 75 | 0 | 0 | 50 | 7.83 | 394 |
Финальный турнир | 5 | 0 | 0 | 1 | 32 | 0 | 0 | 24 | 8.50 | 545 |
ТОВЫ сборных | 17 | 0 | 0 | 0 | 94 | 0 | 0 | 55 | 7.12 | 277 |
Всего за сборные | 36 | 0 | 0 | 2 | 210 | 0 | 0 | 136 | 7.47 | 1399 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин |
(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, 140, 207, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 42009 WHERE `RP`.`player` = 42009 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125228,125185,126326,126372,128179,128131,128992,129040,130027,130661,131992,204161,204114,206064,206110,209439,209391,209562,209592,209640,210919,209683,246938,246943,246948,280874,280444,280880,280447,280883,280450,280888,280453,280891,280460,280893,280463,338210,338522,338213,338525,338216,338528,338219,338531,338226,338538,338229,338541,10369068,10398092,10398386,10398098,10398389,10398101,10398392,10398106,10398395,10398109,10398402,10398111,10398405,10479199,10479368,10479201,10479371,10479208,10479374,10479211,10479377,10479214,10479384,10479220,10479387,10542349,10541942,10542351,10541945,10542358,10541948,10542361,10541951,10542364,10541958,10542370,10541961,10567341,10569138,10569143,10569148,10604508,10604822,10604514,10604825,10604517,10604828,10604522,10604831,10604525,10604838,10604527,10604841,10662782,10663096,10662788,10663099,10662791,10663102,10662796,10663105,10662799,10663112,10662801,10663115,10690370,10691395,10691400,10691402,10692376,10726412,10726270,10726418,10726273,10726421,10726276,10726426,10726279,10726429,10726286,10726431,10726289,10758444,10758445,10758451,10796823,10797040,10796825,10797043,10796832,10797046,10796835,10797049,10796838,10797056,10796844,10797059,10876269,10876534,10876271,10876537,10876278,10876540,10876281,10876543,10876284,10876550,10876290,10876553,10919928,10919786,10919934,10919789,10919937,10919792,10919942,10919795,10919945,10919802,10919947,10919805,10936992,10964291,10964606,10964293,10964609,10964300,10964612,10964303,10964615,10964306,10964622,10964312,10964625,10982932,10982933,10982939,11014750,11015040,11014755,11015041,11014760,11015047,11014761,11015051,11014768,11015054,11014771,11015060,11036242,11036236,11038328,11038292,11038333,11038297,11038338,11038302,11038749,11038877,11038975,11069557,11069343,11069562,11069348,11069565,11069350,11069570,11069356,11069573,11069359,11069578,11069361,11085711,11085716,11085719,11087185,11087488,11087614,11122203,11122325,11122208,11122330,11122211,11122332,11122216,11122338,11122219,11122341,11122224,11122343,11170647,11170384,11170652,11170385,11170654,11170391,11170660,11170395,11170663,11170398,11170665,11170404,11186265,11213797,11214158,11213802,11214159,11213804,11214165,11213810,11214169,11213813,11214172,11213815,11214178,11229637,11229642,11229645,11266475,11266790,11266480,11266791,11266483,11266797,11266488,11266801,11266491,11266804,11266496,11266810,11323405,11323164,11323410,11323169,11323412,11323174,11323418,11323175,11323421,11323182,11323423,11323185,11337866,11339738,11339743,11339748,11340354,11374885,11374669,11374890,11374674,11374892,11374676,11374898,11374682,11374901,11374685,11374903,11374687,11391970,11392957,11393016,11392962,11393021,11392964,11393026,11394296,11418687,11418351,11418692,11418356,11418695,11418359,11418700,11418364,11418703,11418367,11418708,11418372,11434167,11434191,11434172,11434196,11434174,11434198,11435326,11435315,11464709,11464301,11464714,11464306,11464717,11464309,11464722,11464314,11464725,11464317,11464730,11464322,11481187,11481235,11481192,11481240,11481194,11481242,11481629,11513799,11513727,11513804,11513732,11513807,11513735,11513812,11513740,11513815,11513743,11513820,11513748,11530195,11531528,11531533,11531538,11557024,11556637,11557025,11556642,11557031,11556645,11557035,11556650,11557038,11556653,11557044,11556658,11574706,11574707,11574713,11600560,11600271,11600561,11600276,11600567,11600278,11600571,11600284,11600574,11600287,11600580,11600289,11616916,11649482,11649267,11649487,11649272,11649492,11649274,11649493,11649280,11649500,11649283,11649503,11649285,11667097,11667102,11667104,11671582,11671389,11671583,11671394,11671589,11671396,11671593,11671402,11671596,11671405,11671602,11671407,11711125,11711951,11711956,11711961,11739361,11738883,11739366,11738884,11739371,11738890,11739372,11738894,11739379,11738897,11739382,11738903,11757776,11757781,11757783,11758747,11786885,11786764,11786886,11786769,11786892,11786771,11786896,11786777,11786899,11786780,11786905,11786782,11805231,11805232,11805238,11806990,11807251,11807850,11837147,11836832,11837148,11836837,11837154,11836840,11837158,11836845,11837161,11836848,11837167,11836853,11853404,11853409,11853412,11869015,11868750,11869020,11868755,11869025,11868758,11869026,11868763,11869033,11868766,11869036,11868771,11895836,11896687,11896692,11896697,11923943,11923776,11923948,11923781,11923953,11923783,11923954,11923789,11923961,11923792,11923964,11923794,11939998,11964243,11963738,11964244,11963743,11963745,11964250,11964254,11963751,11964257,11963754,11964263,11963756,11980465,11980466,11980472,12004318,12004127,12004323,12004128,12004325,12004134,12004331,12004138,12004334,12004141,12004336,12004147,12021470,12021475,12021477,12045520,12045113,12045525,12045118,12045528,12045123,12045533,12045124,12045536,12045131,12045541,12045134,12061928,12061933,12061935,12062553,12084692,12084524,12084697,12084529,12084699,12084531,12084705,12084537,12084708,12084540,12084710,12084542,20258,19924,20263,19925,20268,19931,20269,19935,20276,19938,20279,19944,71802,71490,71807,71495,71812,71500,71813,71501,71820,71508,71823,71511,85606,111842,111532,111847,111533,111852,111539,111853,111543,111860,111546,111863,111552,158382,158286,158387,158291,158392,158296,158393,158297,158400,158304,158403,158307,192774,192632,192779,192633,192784,192639,192785,192643,192792,192646,192795,192652,232254,232494,232259,232499,232264,232504,232265,232505,232272,232512,232275,232515,273426,273186,273431,273191,273436,273196,273437,273197,273444,273204,273447,273207,312552,312314,312557,312315,312562,312321,312563,312325,312570,312328,312573,312334,357240,357024,357245,357029,357250,357034,357251,357035,357258,357042,357261,357045,372798,372799,372805) ) 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, 140, 207, 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` = 42009 WHERE `RP`.`player` = 42009 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125228,125185,126326,126372,128179,128131,128992,129040,130027,130661,131992,204161,204114,206064,206110,209439,209391,209562,209592,209640,210919,209683,246938,246943,246948,280874,280444,280880,280447,280883,280450,280888,280453,280891,280460,280893,280463,338210,338522,338213,338525,338216,338528,338219,338531,338226,338538,338229,338541,10369068,10398092,10398386,10398098,10398389,10398101,10398392,10398106,10398395,10398109,10398402,10398111,10398405,10479199,10479368,10479201,10479371,10479208,10479374,10479211,10479377,10479214,10479384,10479220,10479387,10542349,10541942,10542351,10541945,10542358,10541948,10542361,10541951,10542364,10541958,10542370,10541961,10567341,10569138,10569143,10569148,10604508,10604822,10604514,10604825,10604517,10604828,10604522,10604831,10604525,10604838,10604527,10604841,10662782,10663096,10662788,10663099,10662791,10663102,10662796,10663105,10662799,10663112,10662801,10663115,10690370,10691395,10691400,10691402,10692376,10726412,10726270,10726418,10726273,10726421,10726276,10726426,10726279,10726429,10726286,10726431,10726289,10758444,10758445,10758451,10796823,10797040,10796825,10797043,10796832,10797046,10796835,10797049,10796838,10797056,10796844,10797059,10876269,10876534,10876271,10876537,10876278,10876540,10876281,10876543,10876284,10876550,10876290,10876553,10919928,10919786,10919934,10919789,10919937,10919792,10919942,10919795,10919945,10919802,10919947,10919805,10936992,10964291,10964606,10964293,10964609,10964300,10964612,10964303,10964615,10964306,10964622,10964312,10964625,10982932,10982933,10982939,11014750,11015040,11014755,11015041,11014760,11015047,11014761,11015051,11014768,11015054,11014771,11015060,11036242,11036236,11038328,11038292,11038333,11038297,11038338,11038302,11038749,11038877,11038975,11069557,11069343,11069562,11069348,11069565,11069350,11069570,11069356,11069573,11069359,11069578,11069361,11085711,11085716,11085719,11087185,11087488,11087614,11122203,11122325,11122208,11122330,11122211,11122332,11122216,11122338,11122219,11122341,11122224,11122343,11170647,11170384,11170652,11170385,11170654,11170391,11170660,11170395,11170663,11170398,11170665,11170404,11186265,11213797,11214158,11213802,11214159,11213804,11214165,11213810,11214169,11213813,11214172,11213815,11214178,11229637,11229642,11229645,11266475,11266790,11266480,11266791,11266483,11266797,11266488,11266801,11266491,11266804,11266496,11266810,11323405,11323164,11323410,11323169,11323412,11323174,11323418,11323175,11323421,11323182,11323423,11323185,11337866,11339738,11339743,11339748,11340354,11374885,11374669,11374890,11374674,11374892,11374676,11374898,11374682,11374901,11374685,11374903,11374687,11391970,11392957,11393016,11392962,11393021,11392964,11393026,11394296,11418687,11418351,11418692,11418356,11418695,11418359,11418700,11418364,11418703,11418367,11418708,11418372,11434167,11434191,11434172,11434196,11434174,11434198,11435326,11435315,11464709,11464301,11464714,11464306,11464717,11464309,11464722,11464314,11464725,11464317,11464730,11464322,11481187,11481235,11481192,11481240,11481194,11481242,11481629,11513799,11513727,11513804,11513732,11513807,11513735,11513812,11513740,11513815,11513743,11513820,11513748,11530195,11531528,11531533,11531538,11557024,11556637,11557025,11556642,11557031,11556645,11557035,11556650,11557038,11556653,11557044,11556658,11574706,11574707,11574713,11600560,11600271,11600561,11600276,11600567,11600278,11600571,11600284,11600574,11600287,11600580,11600289,11616916,11649482,11649267,11649487,11649272,11649492,11649274,11649493,11649280,11649500,11649283,11649503,11649285,11667097,11667102,11667104,11671582,11671389,11671583,11671394,11671589,11671396,11671593,11671402,11671596,11671405,11671602,11671407,11711125,11711951,11711956,11711961,11739361,11738883,11739366,11738884,11739371,11738890,11739372,11738894,11739379,11738897,11739382,11738903,11757776,11757781,11757783,11758747,11786885,11786764,11786886,11786769,11786892,11786771,11786896,11786777,11786899,11786780,11786905,11786782,11805231,11805232,11805238,11806990,11807251,11807850,11837147,11836832,11837148,11836837,11837154,11836840,11837158,11836845,11837161,11836848,11837167,11836853,11853404,11853409,11853412,11869015,11868750,11869020,11868755,11869025,11868758,11869026,11868763,11869033,11868766,11869036,11868771,11895836,11896687,11896692,11896697,11923943,11923776,11923948,11923781,11923953,11923783,11923954,11923789,11923961,11923792,11923964,11923794,11939998,11964243,11963738,11964244,11963743,11963745,11964250,11964254,11963751,11964257,11963754,11964263,11963756,11980465,11980466,11980472,12004318,12004127,12004323,12004128,12004325,12004134,12004331,12004138,12004334,12004141,12004336,12004147,12021470,12021475,12021477,12045520,12045113,12045525,12045118,12045528,12045123,12045533,12045124,12045536,12045131,12045541,12045134,12061928,12061933,12061935,12062553,12084692,12084524,12084697,12084529,12084699,12084531,12084705,12084537,12084708,12084540,12084710,12084542,20258,19924,20263,19925,20268,19931,20269,19935,20276,19938,20279,19944,71802,71490,71807,71495,71812,71500,71813,71501,71820,71508,71823,71511,85606,111842,111532,111847,111533,111852,111539,111853,111543,111860,111546,111863,111552,158382,158286,158387,158291,158392,158296,158393,158297,158400,158304,158403,158307,192774,192632,192779,192633,192784,192639,192785,192643,192792,192646,192795,192652,232254,232494,232259,232499,232264,232504,232265,232505,232272,232512,232275,232515,273426,273186,273431,273191,273436,273196,273437,273197,273444,273204,273447,273207,312552,312314,312557,312315,312562,312321,312563,312325,312570,312328,312573,312334,357240,357024,357245,357029,357250,357034,357251,357035,357258,357042,357261,357045,372798,372799,372805) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: