Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 8 | 1 | 0 | 47 | 110 | 0 | 10 | 6 | 7.50 | 685 |
Национальная сборная | 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 |
Молодежная сборная | 8 | 1 | 0 | 47 | 110 | 0 | 10 | 6 | 7.50 | 685 |
Отборочный турнир | 5 | 1 | 0 | 21 | 66 | 0 | 7 | 5 | 7.40 | 409 |
Финальный турнир | 3 | 0 | 0 | 26 | 44 | 0 | 3 | 1 | 7.67 | 276 |
ТОВЫ сборных | 6 | 0 | 0 | 55 | 122 | 2 | 9 | 2 | 8.00 | 551 |
Всего за сборные | 14 | 1 | 0 | 102 | 232 | 2 | 19 | 8 | 7.71 | 1236 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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, 140, 207, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 83239 WHERE `RP`.`player` = 83239 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125233,125189,126330,126374,128183,128139,129003,129047,130294,130032,204164,204118,206068,206112,209443,209399,209601,209645,209690,209734,246866,246871,246876,250351,250962,251094,280850,280489,280856,280494,280859,280497,280864,280502,280867,280505,280869,280510,303537,303563,303542,303568,303545,303570,303662,304765,305271,338255,338519,338260,338524,338263,338527,338268,338532,338271,338535,338276,338540,10369079,10398141,10398551,10398143,10398556,10398150,10398559,10398153,10398564,10398156,10398567,10398162,10398572,10479007,10479366,10479009,10479372,10479016,10479375,10479019,10479380,10479022,10479383,10479028,10479385,10512410,10513282,10513287,10513292,10514094,10542254,10541940,10542257,10541946,10542260,10541949,10542263,10541954,10542270,10541957,10542273,10541959,10569187,10569152,10569192,10569153,10569194,10569159,10604557,10604748,10604559,10604754,10604566,10604757,10604569,10604762,10604572,10604765,10604578,10604767,10637419,10639525,10639548,10639530,10639553,10639532,10639558,10662854,10663094,10662860,10663100,10662863,10663103,10662868,10663108,10662871,10663111,10662873,10663113,10726436,10726148,10726442,10726154,10726445,10726157,10726450,10726162,10726453,10726165,10726455,10726167,10757378,10758430,10758491,10758435,10758496,10758440,10758498,10760397,10760867,10761818,10796629,10796846,10796634,10796852,10796637,10796855,10796642,10796860,10796645,10796863,10796650,10796865,10826256,10826257,10826263,10826543,10876364,10876748,10876370,10876754,10876373,10876757,10876378,10876762,10876381,10876765,10876383,10876767,10892865,10892858,10920025,10919712,10920027,10919718,10920034,10919721,10920037,10919726,10920040,10919729,10920046,10919731,10964411,10964653,10964413,10964655,10964420,10964662,10964423,10964665,10964426,10964668,10964432,10964674,11014702,11015182,11014707,11015187,11014712,11015192,11014713,11015193,11014720,11015200,11014723,11015203,11069558,11069416,11069563,11069417,11069568,11069423,11069569,11069427,11069576,11069430,11069579,11069436,11085747,11085752,11085755,11122084,11122229,11122089,11122234,11122094,11122236,11122095,11122242,11122102,11122245,11122105,11122247,11139724,11140226,11140231,11140236,11141175,11141802,11141971,11170550,11170429,11170555,11170434,11170560,11170437,11170561,11170442,11170568,11170445,11170571,11170450,11186638,11186639,11186645,11188243,11213892,11214035,11213897,11214040,11213902,11214043,11213903,11214048,11213910,11214051,11213913,11214056,11229100,11229604,11229616,11229605,11229617,11229611,11229623,11266622,11266813,11266623,11266818,11266629,11266820,11266633,11266826,11266636,11266829,11266642,11266831,11286141,11286146,11286148,11323308,11323139,11323313,11323144,11323318,11323147,11323319,11323152,11323326,11323155,11323329,11323160,11339739,11339812,11339744,11339813,11339746,11339819,11374837,11374645,11374842,11374650,11374844,11374652,11374850,11374658,11374853,11374661,11374855,11374663,11391961,11392981,11392986,11392988,11394293,11394692,11394855,11418617,11418521,11418622,11418526,11418624,11418528,11418630,11418534,11418633,11418537,11418635,11418539,11434180,11434181,11434187,11464591,11464302,11464596,11464307,11464598,11464312,11464604,11464313,11464607,11464320,11464609,11464323,11481224,11481225,11481231,11513993,11513728,11513998,11513733,11514000,11513738,11514006,11513739,11514009,11513746,11514011,11513749,11530203,11557047,11556710,11557052,11556715,11557054,11556720,11557060,11556721,11557063,11556728,11557065,11556731,11573290,11600632,11600318,11600633,11600323,11600639,11600328,11600643,11600329,11600646,11600336,11600652,11600339,11616914,11649436,11649170,11649437,11649175,11649443,11649180,11649447,11649181,11649450,11649188,11649456,11649191,11671606,11671316,11671607,11671321,11671613,11671326,11671617,11671327,11671620,11671334,11671626,11671337,11739289,11739073,11739294,11739078,11739299,11739083,11739300,11739084,11739307,11739091,11739310,11739094,11756960,11787075,11786667,11787080,11786672,11787085,11786677,11787086,11786678,11787093,11786685,11787096,11786688,11837049,11836857,11837054,11836862,11837059,11836867,11837060,11836868,11837067,11836875,11837070,11836878,11868847,11868561,11868852,11868562,11868857,11868568,11868858,11868572,11868865,11868575,11868868,11868581,11924111,11923705,11924116,11923706,11924121,11923712,11924122,11923716,11924129,11923719,11924132,11923725,11964073,11963785,11964078,11963790,11964083,11963795,11964084,11963796,11964091,11963803,11964094,11963806,12004341,12003957,12004346,12003962,12004351,12003967,12004352,12003968,12004359,12003975,12004362,12003978,12045449,12045305,12045454,12045310,12045459,12045315,12045460,12045316,12045467,12045323,12045470,12045326,12084715,12084331,12084720,12084336,12084725,12084341,12084726,12084342,12084733,12084349,12084736,12084352,12101108,12101889,12101894,12101899,20210,19922,20215,19927,20220,19932,20221,19933,20228,19940,20231,19943,47378,48086,48091,48096,71730,71540,71735,71541,71740,71547,71741,71551,71748,71554,71751,71560,85598,86446,86447,86453,87294,87429,87502,111675,111507,111680,111512,111682,111514,111688,111520,111691,111523,111693,111525,127067,127072,127074,128623,158597,158215,158602,158220,158605,158222,158610,158228,158613,158231,158618,158233,173671,173676,173679,174575,174670,175366,192797,192704,192802,192705,192805,192711,192810,192715,192813,192718,192818,192724,210983,210988,210991,212517,232397,232710,232402,232715,232405,232720,232410,232721,232413,232728,232418,232731,247346,248199,248204,248207,249072,273473,272994,273478,272999,273481,273004,273486,273005,273489,273012,273494,273015,288873,288878,288881,312503,312288,312508,312293,312511,312298,312516,312299,312519,312306,312524,312309,357289,356978,357294,356979,357296,356985,357302,356989,357305,356992,357307,356998) ) 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, 140, 207, 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` = 83239 WHERE `RP`.`player` = 83239 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125233,125189,126330,126374,128183,128139,129003,129047,130294,130032,204164,204118,206068,206112,209443,209399,209601,209645,209690,209734,246866,246871,246876,250351,250962,251094,280850,280489,280856,280494,280859,280497,280864,280502,280867,280505,280869,280510,303537,303563,303542,303568,303545,303570,303662,304765,305271,338255,338519,338260,338524,338263,338527,338268,338532,338271,338535,338276,338540,10369079,10398141,10398551,10398143,10398556,10398150,10398559,10398153,10398564,10398156,10398567,10398162,10398572,10479007,10479366,10479009,10479372,10479016,10479375,10479019,10479380,10479022,10479383,10479028,10479385,10512410,10513282,10513287,10513292,10514094,10542254,10541940,10542257,10541946,10542260,10541949,10542263,10541954,10542270,10541957,10542273,10541959,10569187,10569152,10569192,10569153,10569194,10569159,10604557,10604748,10604559,10604754,10604566,10604757,10604569,10604762,10604572,10604765,10604578,10604767,10637419,10639525,10639548,10639530,10639553,10639532,10639558,10662854,10663094,10662860,10663100,10662863,10663103,10662868,10663108,10662871,10663111,10662873,10663113,10726436,10726148,10726442,10726154,10726445,10726157,10726450,10726162,10726453,10726165,10726455,10726167,10757378,10758430,10758491,10758435,10758496,10758440,10758498,10760397,10760867,10761818,10796629,10796846,10796634,10796852,10796637,10796855,10796642,10796860,10796645,10796863,10796650,10796865,10826256,10826257,10826263,10826543,10876364,10876748,10876370,10876754,10876373,10876757,10876378,10876762,10876381,10876765,10876383,10876767,10892865,10892858,10920025,10919712,10920027,10919718,10920034,10919721,10920037,10919726,10920040,10919729,10920046,10919731,10964411,10964653,10964413,10964655,10964420,10964662,10964423,10964665,10964426,10964668,10964432,10964674,11014702,11015182,11014707,11015187,11014712,11015192,11014713,11015193,11014720,11015200,11014723,11015203,11069558,11069416,11069563,11069417,11069568,11069423,11069569,11069427,11069576,11069430,11069579,11069436,11085747,11085752,11085755,11122084,11122229,11122089,11122234,11122094,11122236,11122095,11122242,11122102,11122245,11122105,11122247,11139724,11140226,11140231,11140236,11141175,11141802,11141971,11170550,11170429,11170555,11170434,11170560,11170437,11170561,11170442,11170568,11170445,11170571,11170450,11186638,11186639,11186645,11188243,11213892,11214035,11213897,11214040,11213902,11214043,11213903,11214048,11213910,11214051,11213913,11214056,11229100,11229604,11229616,11229605,11229617,11229611,11229623,11266622,11266813,11266623,11266818,11266629,11266820,11266633,11266826,11266636,11266829,11266642,11266831,11286141,11286146,11286148,11323308,11323139,11323313,11323144,11323318,11323147,11323319,11323152,11323326,11323155,11323329,11323160,11339739,11339812,11339744,11339813,11339746,11339819,11374837,11374645,11374842,11374650,11374844,11374652,11374850,11374658,11374853,11374661,11374855,11374663,11391961,11392981,11392986,11392988,11394293,11394692,11394855,11418617,11418521,11418622,11418526,11418624,11418528,11418630,11418534,11418633,11418537,11418635,11418539,11434180,11434181,11434187,11464591,11464302,11464596,11464307,11464598,11464312,11464604,11464313,11464607,11464320,11464609,11464323,11481224,11481225,11481231,11513993,11513728,11513998,11513733,11514000,11513738,11514006,11513739,11514009,11513746,11514011,11513749,11530203,11557047,11556710,11557052,11556715,11557054,11556720,11557060,11556721,11557063,11556728,11557065,11556731,11573290,11600632,11600318,11600633,11600323,11600639,11600328,11600643,11600329,11600646,11600336,11600652,11600339,11616914,11649436,11649170,11649437,11649175,11649443,11649180,11649447,11649181,11649450,11649188,11649456,11649191,11671606,11671316,11671607,11671321,11671613,11671326,11671617,11671327,11671620,11671334,11671626,11671337,11739289,11739073,11739294,11739078,11739299,11739083,11739300,11739084,11739307,11739091,11739310,11739094,11756960,11787075,11786667,11787080,11786672,11787085,11786677,11787086,11786678,11787093,11786685,11787096,11786688,11837049,11836857,11837054,11836862,11837059,11836867,11837060,11836868,11837067,11836875,11837070,11836878,11868847,11868561,11868852,11868562,11868857,11868568,11868858,11868572,11868865,11868575,11868868,11868581,11924111,11923705,11924116,11923706,11924121,11923712,11924122,11923716,11924129,11923719,11924132,11923725,11964073,11963785,11964078,11963790,11964083,11963795,11964084,11963796,11964091,11963803,11964094,11963806,12004341,12003957,12004346,12003962,12004351,12003967,12004352,12003968,12004359,12003975,12004362,12003978,12045449,12045305,12045454,12045310,12045459,12045315,12045460,12045316,12045467,12045323,12045470,12045326,12084715,12084331,12084720,12084336,12084725,12084341,12084726,12084342,12084733,12084349,12084736,12084352,12101108,12101889,12101894,12101899,20210,19922,20215,19927,20220,19932,20221,19933,20228,19940,20231,19943,47378,48086,48091,48096,71730,71540,71735,71541,71740,71547,71741,71551,71748,71554,71751,71560,85598,86446,86447,86453,87294,87429,87502,111675,111507,111680,111512,111682,111514,111688,111520,111691,111523,111693,111525,127067,127072,127074,128623,158597,158215,158602,158220,158605,158222,158610,158228,158613,158231,158618,158233,173671,173676,173679,174575,174670,175366,192797,192704,192802,192705,192805,192711,192810,192715,192813,192718,192818,192724,210983,210988,210991,212517,232397,232710,232402,232715,232405,232720,232410,232721,232413,232728,232418,232731,247346,248199,248204,248207,249072,273473,272994,273478,272999,273481,273004,273486,273005,273489,273012,273494,273015,288873,288878,288881,312503,312288,312508,312293,312511,312298,312516,312299,312519,312306,312524,312309,357289,356978,357294,356979,357296,356985,357302,356989,357305,356992,357307,356998) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: