Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 12 | 0 | 0 | 75 | 144 | 1 | 13 | 0 | 6.83 | 970 |
Национальная сборная | 9 | 0 | 0 | 56 | 94 | 0 | 6 | 0 | 6.56 | 693 |
Отборочный турнир | 9 | 0 | 0 | 56 | 94 | 0 | 6 | 0 | 6.56 | 693 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 3 | 0 | 0 | 19 | 50 | 1 | 7 | 0 | 7.67 | 277 |
Отборочный турнир | 3 | 0 | 0 | 19 | 50 | 1 | 7 | 0 | 7.67 | 277 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 2 | 0 | 0 | 8 | 16 | 0 | 1 | 0 | 6.00 | 83 |
Всего за сборные | 14 | 0 | 0 | 83 | 160 | 1 | 14 | 0 | 6.71 | 1053 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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(140, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 60130 WHERE `RP`.`player` = 60130 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125199,126389,128150,129057,130302,204128,206125,209412,209655,209742,280660,280663,280666,280669,280676,280679,338642,338645,338648,338651,338658,338661,10398482,10398485,10398488,10398491,10398498,10398501,10479464,10479467,10479470,10479473,10479480,10479483,10542134,10542137,10542140,10542143,10542150,10542153,10604773,10604775,10604782,10604785,10604788,10604794,10639526,10639527,10639533,10662998,10663004,10663007,10663012,10663015,10663017,10690367,10691430,10691435,10691440,10726268,10726274,10726277,10726282,10726285,10726287,10797014,10797020,10797023,10797028,10797031,10797033,10825099,10826194,10826199,10826204,10876700,10876706,10876709,10876714,10876717,10876719,10893735,10893740,10893742,10893999,10919591,10919596,10919599,10919604,10919607,10919612,10937983,10937988,10937990,10964603,10964608,10964611,10964616,10964619,10964624,11015183,11015188,11015190,11015196,11015199,11015201,11069272,11069273,11069279,11069283,11069286,11069292,11085749,11085754,11085756,11087191,11122347,11122352,11122355,11122360,11122363,11122368,11139722,11140252,11140253,11140259,11170213,11170218,11170221,11170226,11170229,11170234,11213989,11213994,11213996,11214002,11214005,11214007,11229103,11266981,11266986,11266988,11266994,11266997,11266999,11323189,11323194,11323196,11323202,11323205,11323207,11339752,11339753,11339759,11374715,11374720,11374723,11374728,11374731,11374736,11392969,11392974,11392976,11394288,11394687,11394851,11418303,11418308,11418311,11418316,11418319,11418324,11464445,11464450,11464453,11464458,11464461,11464466,11479160,11513631,11513636,11513639,11513644,11513647,11513652,11530200,11556661,11556666,11556669,11556674,11556677,11556682,11574703,11574708,11574711,11575586,11600509,11600514,11600517,11600522,11600525,11600530,11618483,11618488,11618491,11619490,11649169,11649174,11649177,11649182,11649185,11649190,11671291,11671296,11671299,11671304,11671307,11671312,11738978,11738983,11738985,11738991,11738994,11738996,11786693,11786694,11786700,11786704,11786707,11786713,11836907,11836908,11836914,11836918,11836921,11836927,11868560,11868565,11868567,11868573,11868576,11868578,11896689,11896690,11896696,11896912,11896984,11897051,11923726,11923731,11923734,11923739,11923742,11923747,11939999,11940877,11940882,11940887,11963904,11963909,11963912,11963917,11963920,11963925,11980315,11980415,11980420,11980425,12004030,12004035,12004037,12004043,12004046,12004048,12021328,12045304,12045309,12045312,12045317,12045320,12045325,12061926,12061931,12061934,12084546,12084551,12084554,12084559,12084562,12084567,12101915,12101916,12101922,12102551,12103519,12103699,20065,20070,20073,20078,20081,20086,48073,48078,48081,71585,71590,71593,71598,71601,71606,86433,86438,86440,111553,111558,111561,111566,111569,111574,126995,127000,127002,158213,158218,158221,158226,158229,158234,172815,173624,173629,173634,192607,192612,192614,192620,192623,192625,210902,210903,210909,212519,212674,212761,232709,232714,232717,232722,232725,232730,248151,248156,248159,273113,273118,273121,273126,273129,273134,288004,312263,312268,312271,312276,312279,312284,357071,357076,357079,357084,357087,357092) ) 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(140, 207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 60130 WHERE `RP`.`player` = 60130 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125199,126389,128150,129057,130302,204128,206125,209412,209655,209742,280660,280663,280666,280669,280676,280679,338642,338645,338648,338651,338658,338661,10398482,10398485,10398488,10398491,10398498,10398501,10479464,10479467,10479470,10479473,10479480,10479483,10542134,10542137,10542140,10542143,10542150,10542153,10604773,10604775,10604782,10604785,10604788,10604794,10639526,10639527,10639533,10662998,10663004,10663007,10663012,10663015,10663017,10690367,10691430,10691435,10691440,10726268,10726274,10726277,10726282,10726285,10726287,10797014,10797020,10797023,10797028,10797031,10797033,10825099,10826194,10826199,10826204,10876700,10876706,10876709,10876714,10876717,10876719,10893735,10893740,10893742,10893999,10919591,10919596,10919599,10919604,10919607,10919612,10937983,10937988,10937990,10964603,10964608,10964611,10964616,10964619,10964624,11015183,11015188,11015190,11015196,11015199,11015201,11069272,11069273,11069279,11069283,11069286,11069292,11085749,11085754,11085756,11087191,11122347,11122352,11122355,11122360,11122363,11122368,11139722,11140252,11140253,11140259,11170213,11170218,11170221,11170226,11170229,11170234,11213989,11213994,11213996,11214002,11214005,11214007,11229103,11266981,11266986,11266988,11266994,11266997,11266999,11323189,11323194,11323196,11323202,11323205,11323207,11339752,11339753,11339759,11374715,11374720,11374723,11374728,11374731,11374736,11392969,11392974,11392976,11394288,11394687,11394851,11418303,11418308,11418311,11418316,11418319,11418324,11464445,11464450,11464453,11464458,11464461,11464466,11479160,11513631,11513636,11513639,11513644,11513647,11513652,11530200,11556661,11556666,11556669,11556674,11556677,11556682,11574703,11574708,11574711,11575586,11600509,11600514,11600517,11600522,11600525,11600530,11618483,11618488,11618491,11619490,11649169,11649174,11649177,11649182,11649185,11649190,11671291,11671296,11671299,11671304,11671307,11671312,11738978,11738983,11738985,11738991,11738994,11738996,11786693,11786694,11786700,11786704,11786707,11786713,11836907,11836908,11836914,11836918,11836921,11836927,11868560,11868565,11868567,11868573,11868576,11868578,11896689,11896690,11896696,11896912,11896984,11897051,11923726,11923731,11923734,11923739,11923742,11923747,11939999,11940877,11940882,11940887,11963904,11963909,11963912,11963917,11963920,11963925,11980315,11980415,11980420,11980425,12004030,12004035,12004037,12004043,12004046,12004048,12021328,12045304,12045309,12045312,12045317,12045320,12045325,12061926,12061931,12061934,12084546,12084551,12084554,12084559,12084562,12084567,12101915,12101916,12101922,12102551,12103519,12103699,20065,20070,20073,20078,20081,20086,48073,48078,48081,71585,71590,71593,71598,71601,71606,86433,86438,86440,111553,111558,111561,111566,111569,111574,126995,127000,127002,158213,158218,158221,158226,158229,158234,172815,173624,173629,173634,192607,192612,192614,192620,192623,192625,210902,210903,210909,212519,212674,212761,232709,232714,232717,232722,232725,232730,248151,248156,248159,273113,273118,273121,273126,273129,273134,288004,312263,312268,312271,312276,312279,312284,357071,357076,357079,357084,357087,357092) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: