Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 10 | 7 | 0 | 0 | 13 | 20 | 1 | 20 | 6.95 | 27 |
Национальная сборная | 1 | 1 | 0 | 0 | 1 | 2 | 0 | 1 | 7.50 | 27 |
Отборочный турнир | 1 | 1 | 0 | 0 | 1 | 2 | 0 | 1 | 7.50 | 27 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 9 | 6 | 0 | 0 | 12 | 18 | 1 | 19 | 6.89 | 0 |
Отборочный турнир | 6 | 6 | 0 | 0 | 10 | 13 | 1 | 11 | 7.42 | 0 |
Финальный турнир | 3 | 0 | 0 | 0 | 2 | 5 | 0 | 8 | 5.83 | 0 |
ТОВЫ сборных | 10 | 1 | 0 | 0 | 2 | 32 | 0 | 10 | 5.95 | 47 |
Всего за сборные | 20 | 8 | 0 | 0 | 15 | 52 | 1 | 30 | 6.45 | 74 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 38976 WHERE `RP`.`player` = 38976 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125229,126328,128175,128996,130023,204160,206066,209435,209596,209679,280948,280951,280954,280957,280964,280967,301752,338209,338211,338218,338221,338224,338230,10398333,10398335,10398342,10398345,10398348,10398354,10479079,10479081,10479088,10479091,10479094,10479100,10513368,10513369,10513375,10542229,10542231,10542238,10542241,10542244,10542250,10569151,10569156,10569158,10570042,10570147,10570551,10604556,10604562,10604565,10604570,10604573,10604575,10639547,10639552,10639555,10640806,10662709,10662714,10662717,10662722,10662725,10662730,10691369,10691374,10691377,10726483,10726488,10726491,10726496,10726499,10726504,10758453,10758458,10758461,10796581,10796586,10796589,10796594,10796597,10796602,10876436,10876442,10876445,10876450,10876453,10876455,10919880,10919886,10919889,10919894,10919897,10919899,10937947,10937952,10937954,10964362,10964368,10964371,10964376,10964379,10964381,10981493,11014919,11014924,11014926,11014932,11014935,11014937,11036240,11038268,11038273,11038278,11069559,11069564,11069566,11069572,11069575,11069577,11084883,11121990,11121991,11121997,11122001,11122004,11122010,11139732,11170575,11170580,11170582,11170588,11170591,11170593,11186261,11186672,11186677,11186682,11213939,11213944,11213947,11213952,11213955,11213960,11229109,11229628,11229629,11229635,11230830,11266571,11266576,11266579,11266584,11266587,11266592,11284041,11323355,11323360,11323363,11323368,11323371,11323376,11374957,11374962,11374964,11374970,11374973,11374975,11418569,11418574,11418576,11418582,11418585,11418587,11434215,11434220,11434222,11435314,11435983,11436207,11464711,11464716,11464718,11464724,11464727,11464729,11513946,11513947,11513953,11513957,11513960,11513966,11530206,11531588,11531593,11531598,11531959,11532591,11532793,11556805,11556810,11556813,11556818,11556821,11556826,11573288,11574754,11574755,11574761,11575594,11575877,11576022,11600749,11600754,11600757,11600762,11600765,11600770,11616932,11618498,11618499,11618505,11619504,11620217,11620376,11649601,11649606,11649609,11649614,11649617,11649622,11667143,11667148,11667151,11671605,11671610,11671612,11671618,11671621,11671623,11739288,11739293,11739296,11739301,11739304,11739309,11757829,11757831,11757824,11758755,11786858,11786863,11786866,11786871,11786874,11786879,11805312,11805317,11805320,11806985,11837168,11837173,11837176,11837181,11837184,11837189,11852583,11868894,11868899,11868902,11868907,11868910,11868915,11923968,11923973,11923975,11923981,11923984,11923986,11964098,11964103,11964105,11964111,11964114,11964116,12004199,12004200,12004206,12004210,12004213,12004219,12021483,12021484,12021490,12045451,12045452,12045458,12045462,12045465,12045471,12061192,12061951,12061956,12061961,12084621,12084622,12084628,12084632,12084635,12084641,20356,20357,20363,20367,20370,20376,47388,71732,71733,71739,71743,71746,71752,85610,111724,111725,111731,111735,111738,111744,158432,158433,158439,158443,158446,158452,192944,192945,192951,192955,192958,192964,210974,210975,210981,232327,232332,232334,232340,232343,232345,248189,248194,248196,273451,273456,273458,273464,273467,273469,312673,312678,312680,312686,312689,312691,357361,357366,357368,357374,357377,357379) ) 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` = 38976 WHERE `RP`.`player` = 38976 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125229,126328,128175,128996,130023,204160,206066,209435,209596,209679,280948,280951,280954,280957,280964,280967,301752,338209,338211,338218,338221,338224,338230,10398333,10398335,10398342,10398345,10398348,10398354,10479079,10479081,10479088,10479091,10479094,10479100,10513368,10513369,10513375,10542229,10542231,10542238,10542241,10542244,10542250,10569151,10569156,10569158,10570042,10570147,10570551,10604556,10604562,10604565,10604570,10604573,10604575,10639547,10639552,10639555,10640806,10662709,10662714,10662717,10662722,10662725,10662730,10691369,10691374,10691377,10726483,10726488,10726491,10726496,10726499,10726504,10758453,10758458,10758461,10796581,10796586,10796589,10796594,10796597,10796602,10876436,10876442,10876445,10876450,10876453,10876455,10919880,10919886,10919889,10919894,10919897,10919899,10937947,10937952,10937954,10964362,10964368,10964371,10964376,10964379,10964381,10981493,11014919,11014924,11014926,11014932,11014935,11014937,11036240,11038268,11038273,11038278,11069559,11069564,11069566,11069572,11069575,11069577,11084883,11121990,11121991,11121997,11122001,11122004,11122010,11139732,11170575,11170580,11170582,11170588,11170591,11170593,11186261,11186672,11186677,11186682,11213939,11213944,11213947,11213952,11213955,11213960,11229109,11229628,11229629,11229635,11230830,11266571,11266576,11266579,11266584,11266587,11266592,11284041,11323355,11323360,11323363,11323368,11323371,11323376,11374957,11374962,11374964,11374970,11374973,11374975,11418569,11418574,11418576,11418582,11418585,11418587,11434215,11434220,11434222,11435314,11435983,11436207,11464711,11464716,11464718,11464724,11464727,11464729,11513946,11513947,11513953,11513957,11513960,11513966,11530206,11531588,11531593,11531598,11531959,11532591,11532793,11556805,11556810,11556813,11556818,11556821,11556826,11573288,11574754,11574755,11574761,11575594,11575877,11576022,11600749,11600754,11600757,11600762,11600765,11600770,11616932,11618498,11618499,11618505,11619504,11620217,11620376,11649601,11649606,11649609,11649614,11649617,11649622,11667143,11667148,11667151,11671605,11671610,11671612,11671618,11671621,11671623,11739288,11739293,11739296,11739301,11739304,11739309,11757829,11757831,11757824,11758755,11786858,11786863,11786866,11786871,11786874,11786879,11805312,11805317,11805320,11806985,11837168,11837173,11837176,11837181,11837184,11837189,11852583,11868894,11868899,11868902,11868907,11868910,11868915,11923968,11923973,11923975,11923981,11923984,11923986,11964098,11964103,11964105,11964111,11964114,11964116,12004199,12004200,12004206,12004210,12004213,12004219,12021483,12021484,12021490,12045451,12045452,12045458,12045462,12045465,12045471,12061192,12061951,12061956,12061961,12084621,12084622,12084628,12084632,12084635,12084641,20356,20357,20363,20367,20370,20376,47388,71732,71733,71739,71743,71746,71752,85610,111724,111725,111731,111735,111738,111744,158432,158433,158439,158443,158446,158452,192944,192945,192951,192955,192958,192964,210974,210975,210981,232327,232332,232334,232340,232343,232345,248189,248194,248196,273451,273456,273458,273464,273467,273469,312673,312678,312680,312686,312689,312691,357361,357366,357368,357374,357377,357379) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: