Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 14 | 0 | 0 | 75 | 162 | 2 | 16 | 2 | 6.50 | 1213 |
Национальная сборная | 6 | 0 | 0 | 35 | 88 | 1 | 12 | 0 | 6.17 | 558 |
Отборочный турнир | 6 | 0 | 0 | 35 | 88 | 1 | 12 | 0 | 6.17 | 558 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 8 | 0 | 0 | 40 | 74 | 1 | 4 | 2 | 6.75 | 655 |
Отборочный турнир | 6 | 0 | 0 | 35 | 62 | 0 | 4 | 2 | 7.00 | 497 |
Финальный турнир | 2 | 0 | 0 | 5 | 12 | 1 | 0 | 0 | 6.00 | 158 |
ТОВЫ сборных | 7 | 0 | 0 | 57 | 99 | 0 | 1 | 2 | 6.79 | 593 |
Всего за сборные | 21 | 0 | 0 | 132 | 261 | 2 | 17 | 4 | 6.60 | 1806 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 68032 WHERE `RP`.`player` = 68032 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,10662952,10662955,10662958,10662961,10662968,10662971,10690381,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,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,11213821,11213826,11213828,11213834,11213837,11213839,11266619,11266624,11266627,11266632,11266635,11266640,11323403,11323408,11323411,11323416,11323419,11323424,11374859,11374864,11374867,11374872,11374875,11374880,11418663,11418668,11418671,11418676,11418679,11418684,11464565,11464570,11464573,11464578,11464581,11464586,11513775,11513780,11513783,11513788,11513791,11513796,11556829,11556834,11556837,11556842,11556845,11556850,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,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,158503,158508,158510,158516,158519,158521,192848,192849,192855,192859,192862,192868,232279,232284,232286,232292,232295,232297,273355,273360,273362,273368,273371,273373,312458,312459,312465,312469,312472,312478,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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 68032 WHERE `RP`.`player` = 68032 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,10662952,10662955,10662958,10662961,10662968,10662971,10690381,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,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,11213821,11213826,11213828,11213834,11213837,11213839,11266619,11266624,11266627,11266632,11266635,11266640,11323403,11323408,11323411,11323416,11323419,11323424,11374859,11374864,11374867,11374872,11374875,11374880,11418663,11418668,11418671,11418676,11418679,11418684,11464565,11464570,11464573,11464578,11464581,11464586,11513775,11513780,11513783,11513788,11513791,11513796,11556829,11556834,11556837,11556842,11556845,11556850,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,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,158503,158508,158510,158516,158519,158521,192848,192849,192855,192859,192862,192868,232279,232284,232286,232292,232295,232297,273355,273360,273362,273368,273371,273373,312458,312459,312465,312469,312472,312478,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}: