Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 4 | 0 | 0 | 1 | 46 | 21 | 6 | 0 | 6.75 | 128 |
Национальная сборная | 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 | 1 | 46 | 21 | 6 | 0 | 6.75 | 128 |
Отборочный турнир | 4 | 0 | 0 | 1 | 46 | 21 | 6 | 0 | 6.75 | 128 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 6 | 0 | 0 | 0 | 116 | 51 | 8 | 0 | 6.58 | 268 |
Всего за сборные | 10 | 0 | 0 | 1 | 162 | 72 | 14 | 0 | 6.65 | 396 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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(141, 1406) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 85853 WHERE `RP`.`player` = 85853 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107404,107422,122126,122132,122128,122135,122131,122670,122117,123417,214836,214986,214839,214956,214804,214842,235253,235407,235256,235410,246549,247853,248882,257427,257504,260590,260788,261968,262015,265241,265399,277346,281001,281600,283351,283393,299590,299614,300861,300871,302158,302757,302155,302839,303394,303433,337460,337639,342070,342191,346009,346053,371940,372192,373353,373918,10368419,10369928,10370329,10370638,10387043,10398863,10400783,10403720,10403966,10406215,10407433,10437327,10437596,10440303,10441487,10441484,10441486,10442097,10442301,10443332,10465463,10465452,10481345,10481735,10482528,10483748,10511265,10512492,10513202,10514159,10514438,10514513,10540998,10541725,10543412,10543592,10567936,10568738,10570206,10570574,10583639,10602830,10605229,10605273,10608157,10608212,10637755,10638146,10640856,10640974,10641048,10647828,10647904,10661150,10662158,10664890,10665145,10690406,10690591,10691972,10692210,10691854,10692413,10692486,10692709,10693054,10693241,10693275,10708482,10708841,10710321,10710506,10727468,10727607,10729647,10730537,10757458,10757706,10758730,10759024,10760672,10760894,10762397,10771650,10774523,10777289,10780021,10780163,10794821,10795207,10798217,10799247,10825283,10825761,10826355,10826375,10826350,10826374,10826352,10826387,10826575,10826605,10826720,10827022,10827346,10827983,10839232,10839639,10841096,10841553,10843053,10843147,10892921,10893801,10893844,10893803,10893846,10893805,10893863,10894198,10894423,10894550,10894592,10895389,10895549,10904522,10905064,10906761,10906765,10920889,10921058,10937580,10939011,10938925,10939345,10939562,10939598,10940813,10941175,10941630,10941714,10948854,10949258,10962405,10981504,10981526,10983164,10983261,10983100,10983260,10983235,10983264,10983577,10983807,10984066,10984099,10985625,10985682,10999615,11000676,11016170,11016840,11036776,11038578,11038818,11038895,11039379,11039525,11055576,11067735,11067860,11070810,11070840,11084894,11085264,11086062,11086059,11086058,11087246,11087366,11087522,11087572,11088606,11089228,11107041,11107110,11109579,11120684,11121271,11121307,11139948,11140020,11140821,11140824,11140825,11142066,11157997,11158640,11186312,11187005,11187069,11187095,11188285,11188329,11188396,11188410,11188483,11189142,11195633,11195657,11198831,11199169,11213357,11213554,11229157,11229369,11229763,11230420,11229767,11230382,11229760,11229797,11230838,11230932,11232449,11232828,11232991,11238438,11238639,11241765,11243789,11243987,11246799,11248091,11253565,11253672,11267032,11267605,11284048,11284617,11286408,11286373,11286376,11286658,11287175,11287409,11287959,11288212,11303021,11303235,11305537,11306448,11320661,11322560,11337905,11340013,11340015,11340017,11340396,11340424,11341618,11341837,11343950,11360823,11360937,11361942,11374111,11374446,11375807,11391987,11392639,11393187,11393237,11393183,11394365,11394715,11394937,11395350,11397413,11398416,11417013,11417429,11433564,11434487,11434480,11434509,11436044,11440764,11442051,11450436,11451309,11450434,11450997,11479220,11479608,11481309,11481430,11481312,11481432,11481313,11481428,11481711,11481763,11481783,11481867,11481945,11494225,11495659,11501385,11501871,11501367,11501817,11514381,11515917,11530262,11530715,11531704,11531706,11531905,11531708,11531909,11532366,11532293,11532657,11532730,11533095,11533449,11538482,11538509,11544507,11557096,11557157,11558825,11573322,11574271,11574838,11574840,11574836,11575617,11575686,11575904,11576029,11576058,11577835,11579053,11580164,11582059,11587566,11587766,11601328,11602709,11602314,11602552,11616937,11616958,11618690,11618915,11618692,11618945,11618693,11618927,11619606,11619636,11620247,11620316,11620394,11620462,11625498,11626640,11636653,11637270,11649932,11651489,11666492,11667056,11667187,11667191,11667190,11667354,11667393,11668048,11668198,11678406,11678625,11679474,11679498,11682674,11683485,11711189,11711191,11712157,11712178,11712163,11713253,11713383,11713660,11713749,11713781,11713830,11738610,11740233,11738619,11741519,11756980,11756986,11757908,11757918,11757907,11757913,11757915,11757927,11758799,11758802,11758871,11758887,11758952,11758964,11767960,11769164,11769861,11771600,11805600,11806177,11805604,11806189,11805603,11806191,11807030,11807054,11807292,11807309,11807866,11807894,11817156,11817632,11823043,11824277,11823040,11824275,11852646,11853781,11853767,11853772,11853814,11853771,11853794,11854442,11854481,11854684,11854713,11855235,11855288,11865355,11866343,11896186,11896773,11896791,11896774,11896792,11896770,11896795,11896970,11896979,11897065,11904661,11908760,11940084,11940666,11941326,11941293,11942067,11941322,11942195,11942576,11942587,11942729,11942766,11942763,11949719,11952402,11965202,11965256,11980336,11980383,11980939,11981270,11980794,11981264,11980730,11981266,11981388,11982570,11982864,11983066,12006794,12006803,12021358,12022395,12061209,12061215,12062092,12062198,12062087,12062197,12062085,12062203,12062579,12062737,12062948,12063064,12063111,12065156,12065173,12071068,12071171,12085076,12086150,12101137,12101995,12102021,12101998,12102023,12102001,12102025,12102663,12102926,12103790,4337,4384,4336,5065,20871,21389,46529,46583,48315,48321,48307,48396,48891,49106,49682,57311,57532,59730,70774,85640,86652,86650,87423,87478,87479,87552,87997,88250,88311,94184,95197,97503,98539,98863,126384,126467,127106,127203,127107,127206,127137,127210,128744,128787,128842,128865,133828,134619,136839,139025,139140,145328,145329,172848,172865,173860,173858,173862,174610,174612,174702,175296,175397,175467,179330,179579,193471,194050,210115,210130,212539,212737,212794,215264,215178,215097,215182,215105,215202,220120,220545,247381,247396,248231,248286,248233,248290,248237,248284,249110,249160,249229,249247,249801,249924,257112,257686,260375,260461,261967,272695,288075,288222,288941,289022,289687,288920,289800,289817,290067,290663,290665,299079,299176,315857,316318,331832,331856,333399,333501,333398,333499,333402,333504,333586,333588,334661,334706,335003,335035,337336,337385,339651,341302,339653,341304,344088,344441,358163,358350,373001,372979,373022,373795,373950,374397,374577) ) 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(141, 1406) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 85853 WHERE `RP`.`player` = 85853 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107404,107422,122126,122132,122128,122135,122131,122670,122117,123417,214836,214986,214839,214956,214804,214842,235253,235407,235256,235410,246549,247853,248882,257427,257504,260590,260788,261968,262015,265241,265399,277346,281001,281600,283351,283393,299590,299614,300861,300871,302158,302757,302155,302839,303394,303433,337460,337639,342070,342191,346009,346053,371940,372192,373353,373918,10368419,10369928,10370329,10370638,10387043,10398863,10400783,10403720,10403966,10406215,10407433,10437327,10437596,10440303,10441487,10441484,10441486,10442097,10442301,10443332,10465463,10465452,10481345,10481735,10482528,10483748,10511265,10512492,10513202,10514159,10514438,10514513,10540998,10541725,10543412,10543592,10567936,10568738,10570206,10570574,10583639,10602830,10605229,10605273,10608157,10608212,10637755,10638146,10640856,10640974,10641048,10647828,10647904,10661150,10662158,10664890,10665145,10690406,10690591,10691972,10692210,10691854,10692413,10692486,10692709,10693054,10693241,10693275,10708482,10708841,10710321,10710506,10727468,10727607,10729647,10730537,10757458,10757706,10758730,10759024,10760672,10760894,10762397,10771650,10774523,10777289,10780021,10780163,10794821,10795207,10798217,10799247,10825283,10825761,10826355,10826375,10826350,10826374,10826352,10826387,10826575,10826605,10826720,10827022,10827346,10827983,10839232,10839639,10841096,10841553,10843053,10843147,10892921,10893801,10893844,10893803,10893846,10893805,10893863,10894198,10894423,10894550,10894592,10895389,10895549,10904522,10905064,10906761,10906765,10920889,10921058,10937580,10939011,10938925,10939345,10939562,10939598,10940813,10941175,10941630,10941714,10948854,10949258,10962405,10981504,10981526,10983164,10983261,10983100,10983260,10983235,10983264,10983577,10983807,10984066,10984099,10985625,10985682,10999615,11000676,11016170,11016840,11036776,11038578,11038818,11038895,11039379,11039525,11055576,11067735,11067860,11070810,11070840,11084894,11085264,11086062,11086059,11086058,11087246,11087366,11087522,11087572,11088606,11089228,11107041,11107110,11109579,11120684,11121271,11121307,11139948,11140020,11140821,11140824,11140825,11142066,11157997,11158640,11186312,11187005,11187069,11187095,11188285,11188329,11188396,11188410,11188483,11189142,11195633,11195657,11198831,11199169,11213357,11213554,11229157,11229369,11229763,11230420,11229767,11230382,11229760,11229797,11230838,11230932,11232449,11232828,11232991,11238438,11238639,11241765,11243789,11243987,11246799,11248091,11253565,11253672,11267032,11267605,11284048,11284617,11286408,11286373,11286376,11286658,11287175,11287409,11287959,11288212,11303021,11303235,11305537,11306448,11320661,11322560,11337905,11340013,11340015,11340017,11340396,11340424,11341618,11341837,11343950,11360823,11360937,11361942,11374111,11374446,11375807,11391987,11392639,11393187,11393237,11393183,11394365,11394715,11394937,11395350,11397413,11398416,11417013,11417429,11433564,11434487,11434480,11434509,11436044,11440764,11442051,11450436,11451309,11450434,11450997,11479220,11479608,11481309,11481430,11481312,11481432,11481313,11481428,11481711,11481763,11481783,11481867,11481945,11494225,11495659,11501385,11501871,11501367,11501817,11514381,11515917,11530262,11530715,11531704,11531706,11531905,11531708,11531909,11532366,11532293,11532657,11532730,11533095,11533449,11538482,11538509,11544507,11557096,11557157,11558825,11573322,11574271,11574838,11574840,11574836,11575617,11575686,11575904,11576029,11576058,11577835,11579053,11580164,11582059,11587566,11587766,11601328,11602709,11602314,11602552,11616937,11616958,11618690,11618915,11618692,11618945,11618693,11618927,11619606,11619636,11620247,11620316,11620394,11620462,11625498,11626640,11636653,11637270,11649932,11651489,11666492,11667056,11667187,11667191,11667190,11667354,11667393,11668048,11668198,11678406,11678625,11679474,11679498,11682674,11683485,11711189,11711191,11712157,11712178,11712163,11713253,11713383,11713660,11713749,11713781,11713830,11738610,11740233,11738619,11741519,11756980,11756986,11757908,11757918,11757907,11757913,11757915,11757927,11758799,11758802,11758871,11758887,11758952,11758964,11767960,11769164,11769861,11771600,11805600,11806177,11805604,11806189,11805603,11806191,11807030,11807054,11807292,11807309,11807866,11807894,11817156,11817632,11823043,11824277,11823040,11824275,11852646,11853781,11853767,11853772,11853814,11853771,11853794,11854442,11854481,11854684,11854713,11855235,11855288,11865355,11866343,11896186,11896773,11896791,11896774,11896792,11896770,11896795,11896970,11896979,11897065,11904661,11908760,11940084,11940666,11941326,11941293,11942067,11941322,11942195,11942576,11942587,11942729,11942766,11942763,11949719,11952402,11965202,11965256,11980336,11980383,11980939,11981270,11980794,11981264,11980730,11981266,11981388,11982570,11982864,11983066,12006794,12006803,12021358,12022395,12061209,12061215,12062092,12062198,12062087,12062197,12062085,12062203,12062579,12062737,12062948,12063064,12063111,12065156,12065173,12071068,12071171,12085076,12086150,12101137,12101995,12102021,12101998,12102023,12102001,12102025,12102663,12102926,12103790,4337,4384,4336,5065,20871,21389,46529,46583,48315,48321,48307,48396,48891,49106,49682,57311,57532,59730,70774,85640,86652,86650,87423,87478,87479,87552,87997,88250,88311,94184,95197,97503,98539,98863,126384,126467,127106,127203,127107,127206,127137,127210,128744,128787,128842,128865,133828,134619,136839,139025,139140,145328,145329,172848,172865,173860,173858,173862,174610,174612,174702,175296,175397,175467,179330,179579,193471,194050,210115,210130,212539,212737,212794,215264,215178,215097,215182,215105,215202,220120,220545,247381,247396,248231,248286,248233,248290,248237,248284,249110,249160,249229,249247,249801,249924,257112,257686,260375,260461,261967,272695,288075,288222,288941,289022,289687,288920,289800,289817,290067,290663,290665,299079,299176,315857,316318,331832,331856,333399,333501,333398,333499,333402,333504,333586,333588,334661,334706,335003,335035,337336,337385,339651,341302,339653,341304,344088,344441,358163,358350,373001,372979,373022,373795,373950,374397,374577) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: