Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 4 | 0 | 0 | 0 | 20 | 5 | 1 | 2 | 5.38 | 258 |
Национальная сборная | 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 |
Молодежная сборная | 4 | 0 | 0 | 0 | 20 | 5 | 1 | 2 | 5.38 | 258 |
Отборочный турнир | 4 | 0 | 0 | 0 | 20 | 5 | 1 | 2 | 5.38 | 258 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 6 | 2 | 1 | 1 | 76 | 33 | 0 | 7 | 6.42 | 399 |
Всего за сборные | 10 | 2 | 1 | 1 | 96 | 38 | 1 | 9 | 6.00 | 657 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 63532 WHERE `RP`.`player` = 63532 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126348,128197,129014,130047,206086,209457,209614,209703,280851,280853,280860,280863,280866,280872,338089,338091,338098,338101,338104,338110,10398190,10398193,10398196,10398199,10398206,10398209,10479080,10479083,10479086,10479089,10479096,10479099,10542302,10542305,10542308,10542311,10542318,10542321,10604630,10604633,10604636,10604639,10604646,10604649,10637414,10639572,10639577,10639582,10662952,10662955,10662958,10662961,10662968,10662971,10690381,10691394,10691399,10691404,10726580,10726586,10726589,10726594,10726597,10726599,10796751,10796753,10796760,10796763,10796766,10796772,10876293,10876295,10876302,10876305,10876308,10876314,10920001,10920003,10920010,10920013,10920016,10920022,10936973,10937970,10937975,10937980,10964290,10964296,10964299,10964304,10964307,10964309,10981498,11014896,11014897,11014903,11014907,11014910,11014916,11069582,11069587,11069592,11069593,11069600,11069603,11121964,11121969,11121974,11121975,11121982,11121985,11170670,11170675,11170680,11170681,11170688,11170691,11186674,11186675,11186681,11188247,11188367,11188471,11213821,11213826,11213828,11213834,11213837,11213839,11229625,11229630,11229633,11230833,11231880,11232728,11266619,11266624,11266627,11266632,11266635,11266640,11286103,11286108,11286111,11286603,11286696,11287738,11323403,11323408,11323411,11323416,11323419,11323424,11339785,11339790,11339793,11374859,11374864,11374867,11374872,11374875,11374880,11418663,11418668,11418671,11418676,11418679,11418684,11434189,11434194,11434197,11464565,11464570,11464573,11464578,11464581,11464586,11481247,11481252,11481254,11513775,11513780,11513783,11513788,11513791,11513796,11531565,11531570,11531572,11556829,11556834,11556837,11556842,11556845,11556850,11574787,11574792,11574795,11575590,11600773,11600778,11600781,11600786,11600789,11600794,11616930,11649651,11649656,11649658,11649664,11649667,11649669,11666271,11671629,11671634,11671636,11671642,11671645,11671647,11739194,11739199,11739201,11739207,11739210,11739212,11786908,11786913,11786915,11786921,11786924,11786926,11837075,11837076,11837082,11837086,11837089,11837095,11852582,11853441,11853446,11853451,11854406,11868992,11868997,11868999,11869005,11869008,11869010,11923944,11923949,11923951,11923957,11923960,11923962,11964219,11964220,11964226,11964230,11964233,11964239,12004319,12004320,12004326,12004330,12004333,12004339,12021339,12045594,12045599,12045601,12045607,12045610,12045612,12084597,12084598,12084604,12084608,12084611,12084617,20236,20237,20243,20247,20250,20256,71778,71783,71788,71789,71796,71799,111914,111919,111924,111925,111932,111935,126199,127066,127071,127076,128626,128772,128860,158503,158508,158510,158516,158519,158521,192848,192849,192855,192859,192862,192868,210973,210978,210980,212516,232279,232284,232286,232292,232295,232297,273355,273360,273362,273368,273371,273373,312458,312459,312465,312469,312472,312478,333292,333293,333299,357408,357413,357418,357419,357426,357429) ) 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` = 63532 WHERE `RP`.`player` = 63532 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126348,128197,129014,130047,206086,209457,209614,209703,280851,280853,280860,280863,280866,280872,338089,338091,338098,338101,338104,338110,10398190,10398193,10398196,10398199,10398206,10398209,10479080,10479083,10479086,10479089,10479096,10479099,10542302,10542305,10542308,10542311,10542318,10542321,10604630,10604633,10604636,10604639,10604646,10604649,10637414,10639572,10639577,10639582,10662952,10662955,10662958,10662961,10662968,10662971,10690381,10691394,10691399,10691404,10726580,10726586,10726589,10726594,10726597,10726599,10796751,10796753,10796760,10796763,10796766,10796772,10876293,10876295,10876302,10876305,10876308,10876314,10920001,10920003,10920010,10920013,10920016,10920022,10936973,10937970,10937975,10937980,10964290,10964296,10964299,10964304,10964307,10964309,10981498,11014896,11014897,11014903,11014907,11014910,11014916,11069582,11069587,11069592,11069593,11069600,11069603,11121964,11121969,11121974,11121975,11121982,11121985,11170670,11170675,11170680,11170681,11170688,11170691,11186674,11186675,11186681,11188247,11188367,11188471,11213821,11213826,11213828,11213834,11213837,11213839,11229625,11229630,11229633,11230833,11231880,11232728,11266619,11266624,11266627,11266632,11266635,11266640,11286103,11286108,11286111,11286603,11286696,11287738,11323403,11323408,11323411,11323416,11323419,11323424,11339785,11339790,11339793,11374859,11374864,11374867,11374872,11374875,11374880,11418663,11418668,11418671,11418676,11418679,11418684,11434189,11434194,11434197,11464565,11464570,11464573,11464578,11464581,11464586,11481247,11481252,11481254,11513775,11513780,11513783,11513788,11513791,11513796,11531565,11531570,11531572,11556829,11556834,11556837,11556842,11556845,11556850,11574787,11574792,11574795,11575590,11600773,11600778,11600781,11600786,11600789,11600794,11616930,11649651,11649656,11649658,11649664,11649667,11649669,11666271,11671629,11671634,11671636,11671642,11671645,11671647,11739194,11739199,11739201,11739207,11739210,11739212,11786908,11786913,11786915,11786921,11786924,11786926,11837075,11837076,11837082,11837086,11837089,11837095,11852582,11853441,11853446,11853451,11854406,11868992,11868997,11868999,11869005,11869008,11869010,11923944,11923949,11923951,11923957,11923960,11923962,11964219,11964220,11964226,11964230,11964233,11964239,12004319,12004320,12004326,12004330,12004333,12004339,12021339,12045594,12045599,12045601,12045607,12045610,12045612,12084597,12084598,12084604,12084608,12084611,12084617,20236,20237,20243,20247,20250,20256,71778,71783,71788,71789,71796,71799,111914,111919,111924,111925,111932,111935,126199,127066,127071,127076,128626,128772,128860,158503,158508,158510,158516,158519,158521,192848,192849,192855,192859,192862,192868,210973,210978,210980,212516,232279,232284,232286,232292,232295,232297,273355,273360,273362,273368,273371,273373,312458,312459,312465,312469,312472,312478,333292,333293,333299,357408,357413,357418,357419,357426,357429) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: