Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин | Официальные матчи сборных | 12 | 0 | 0 | 1 | 95 | 0 | 0 | 57 | 6.58 | 1105 |
Национальная сборная | 5 | 0 | 0 | 0 | 28 | 0 | 0 | 22 | 7.00 | 460 |
Отборочный турнир | 5 | 0 | 0 | 0 | 28 | 0 | 0 | 22 | 7.00 | 460 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 7 | 0 | 0 | 1 | 67 | 0 | 0 | 35 | 6.29 | 645 |
Отборочный турнир | 7 | 0 | 0 | 1 | 67 | 0 | 0 | 35 | 6.29 | 645 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 8 | 0 | 0 | 0 | 54 | 0 | 0 | 35 | 7.38 | 737 |
Всего за сборные | 20 | 0 | 0 | 1 | 149 | 0 | 0 | 92 | 6.90 | 1842 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин |
(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` = 75432 WHERE `RP`.`player` = 75432 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107444,107563,122170,122183,122134,122184,122172,122189,122190,122244,213664,213656,213998,213895,214595,235514,235640,235515,235715,247074,247177,247529,248779,257395,257425,259929,261938,262798,265400,277916,278425,281331,281379,283315,283909,299411,299750,300897,301811,302955,301813,302958,303396,337665,337744,342033,342273,345797,347503,372060,372238,373217,373599,10368391,10369716,10369933,10369943,10370590,10370599,10385842,10386639,10399840,10400061,10402960,10403581,10406246,10406267,10436929,10436981,10440297,10440299,10441282,10441330,10441283,10441332,10441299,10441333,10442105,10442171,10442664,10443063,10443756,10443759,10466071,10477460,10466060,10477524,10481478,10481719,10483620,10484777,10510304,10510725,10512659,10512751,10513569,10513564,10514109,10514390,10514504,10540714,10541116,10543171,10543282,10567943,10567971,10569877,10569880,10570091,10570162,10570200,10570791,10570857,10583605,10583711,10605139,10605583,10608153,10608203,10637893,10640850,10640857,10640966,10640970,10641042,10641064,10647877,10647902,10661146,10662164,10664834,10664849,10690411,10691722,10691724,10691832,10692419,10692446,10692629,10692715,10693207,10693265,10708211,10708605,10710200,10710235,10727721,10728560,10730211,10730380,10757395,10757437,10758529,10758580,10758537,10760402,10760433,10760902,10760915,10762038,10762253,10770410,10771426,10773861,10773882,10777886,10777993,10779674,10779869,10795188,10795009,10798179,10798396,10825134,10825148,10826287,10826289,10826510,10826291,10826485,10826595,10826621,10827021,10827052,10827816,10827820,10839537,10839832,10841000,10841020,10843140,10843215,10892884,10892906,10893883,10893962,10893868,10893964,10893854,10893960,10894165,10894244,10894554,10894581,10895659,10895920,10904971,10905147,10906641,10906643,10921069,10921772,10937485,10938222,10938195,10938140,10939560,10939578,10941087,10941096,10941622,10941641,10948695,10949491,10963600,10965479,10981528,10983156,10983252,10983160,10983254,10983158,10983270,10983681,10983994,10984064,10984109,10985674,10985775,10999503,10999656,11015921,11016579,11036567,11038468,11038491,11038477,11038479,11038481,11038487,11038792,11038824,11038936,11039303,11039380,11055529,11055907,11067459,11067623,11070841,11070847,11084893,11084900,11086255,11086480,11086254,11086481,11086371,11086513,11087275,11087365,11087499,11087573,11088275,11088437,11106649,11108474,11109585,11120852,11121203,11121855,11139761,11139771,11140918,11140958,11140702,11140961,11140916,11140969,11141425,11142049,11157998,11158274,11186299,11186443,11195260,11195310,11198646,11198664,11213337,11213451,11229170,11229681,11229694,11229691,11230873,11232245,11232798,11238274,11238640,11240813,11242417,11243229,11243352,11246864,11247763,11253800,11254114,11267027,11267199,11284074,11286220,11286409,11286218,11286639,11287540,11303042,11303250,11305387,11305662,11320509,11321116,11337872,11337873,11339935,11339945,11339866,11340386,11340398,11341416,11341896,11343005,11343440,11359706,11361168,11361625,11361654,11374464,11375475,11392014,11392062,11393084,11393087,11393089,11393312,11394309,11394409,11394700,11394787,11394895,11394912,11395164,11395904,11397246,11397459,11415938,11418974,11433530,11433662,11434474,11434628,11436034,11436144,11436298,11436334,11440839,11441857,11449184,11453180,11449678,11453182,11479202,11479207,11481606,11481676,11481722,11481790,11481845,11481918,11481936,11494133,11494348,11500864,11501761,11501035,11501040,11514146,11515302,11530243,11530236,11532086,11532655,11532669,11532871,11533096,11538421,11538458,11543462,11544583,11557643,11558701,11573308,11573347,11575078,11575030,11575033,11575756,11575895,11575962,11576049,11576056,11578160,11579145,11579802,11580144,11587512,11587959,11601799,11601894,11601896,11602377,11619149,11619208,11618856,11619162,11618858,11619142,11620197,11620243,11620435,11624918,11626676,11635374,11637959,11649911,11650048,11667203,11667210,11667199,11667279,11667201,11667272,11667428,11667726,11668099,11668158,11668200,11668236,11678272,11678335,11679265,11680288,11684280,11684401,11711164,11712071,11712160,11712075,11712168,11712073,11712158,11713200,11713224,11713674,11713768,11738039,11738372,11738041,11738366,11756974,11757895,11757898,11757897,11758770,11758806,11758891,11758901,11758956,11759014,11767741,11767864,11770099,11770205,11805939,11805919,11805967,11807037,11807429,11807927,11816552,11818819,11824057,11825689,11824059,11838126,11854336,11854685,11855261,11865743,11896592,11896817,11896823,11896825,11896961,11897029,11897116,11905849,11907627,11940343,11940823,11941008,11941031,11941010,11942528,11942596,11942697,11942731,11942805,11942813,11952120,11965207,11980350,11980357,11981271,11981265,11981267,11981413,11982358,11982899,11983043,12006113,12006800,12021388,12021641,12021642,12022107,12022121,12022436,12022435,12022530,12022573,12024755,12024791,12031108,12034304,12034382,12046152,12047566,12061210,12062037,12062130,12062039,12062624,12062966,12063043,12063068,12063251,12065155,12065265,12071095,12071128,12085054,12086035,12101128,12101595,12101986,12102056,12101989,12102059,12102006,12102051,12102847,12103580,12103607,12103724,12103794,4280,4373,4281,4375,20592,20606,46525,47397,47445,48134,48246,48135,48244,48131,48242,48369,48390,48896,48900,49131,49193,49304,49361,57288,57494,71883,71964,85614,85656,86516,86526,86514,86546,86517,86547,87313,87317,87463,87481,87532,87804,88796,88911,94151,94182,97674,98613,99565,126641,127097,127092,127111,128655,128807,128886,133788,133907,136153,136167,138430,139122,157184,158679,172874,172875,173712,173859,173741,173857,173740,173861,174579,174584,174879,175254,175399,175446,177372,178223,193447,193466,210125,210124,210997,211006,211003,212537,212710,212750,212781,212911,213745,216375,213887,216633,220306,231585,247371,247390,248255,248254,248399,248258,248398,249119,249116,249218,249522,249928,249966,257543,257842,274343,288548,288752,289280,289283,289287,289828,289833,290548,290612,290666,299114,300853,314061,314103,316564,333606,334978,335123,340595,340598,372671,372743,373451,373556,373466,373558,373467,373595,373759,373775,374523,374544,374598) ) 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` = 75432 WHERE `RP`.`player` = 75432 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107444,107563,122170,122183,122134,122184,122172,122189,122190,122244,213664,213656,213998,213895,214595,235514,235640,235515,235715,247074,247177,247529,248779,257395,257425,259929,261938,262798,265400,277916,278425,281331,281379,283315,283909,299411,299750,300897,301811,302955,301813,302958,303396,337665,337744,342033,342273,345797,347503,372060,372238,373217,373599,10368391,10369716,10369933,10369943,10370590,10370599,10385842,10386639,10399840,10400061,10402960,10403581,10406246,10406267,10436929,10436981,10440297,10440299,10441282,10441330,10441283,10441332,10441299,10441333,10442105,10442171,10442664,10443063,10443756,10443759,10466071,10477460,10466060,10477524,10481478,10481719,10483620,10484777,10510304,10510725,10512659,10512751,10513569,10513564,10514109,10514390,10514504,10540714,10541116,10543171,10543282,10567943,10567971,10569877,10569880,10570091,10570162,10570200,10570791,10570857,10583605,10583711,10605139,10605583,10608153,10608203,10637893,10640850,10640857,10640966,10640970,10641042,10641064,10647877,10647902,10661146,10662164,10664834,10664849,10690411,10691722,10691724,10691832,10692419,10692446,10692629,10692715,10693207,10693265,10708211,10708605,10710200,10710235,10727721,10728560,10730211,10730380,10757395,10757437,10758529,10758580,10758537,10760402,10760433,10760902,10760915,10762038,10762253,10770410,10771426,10773861,10773882,10777886,10777993,10779674,10779869,10795188,10795009,10798179,10798396,10825134,10825148,10826287,10826289,10826510,10826291,10826485,10826595,10826621,10827021,10827052,10827816,10827820,10839537,10839832,10841000,10841020,10843140,10843215,10892884,10892906,10893883,10893962,10893868,10893964,10893854,10893960,10894165,10894244,10894554,10894581,10895659,10895920,10904971,10905147,10906641,10906643,10921069,10921772,10937485,10938222,10938195,10938140,10939560,10939578,10941087,10941096,10941622,10941641,10948695,10949491,10963600,10965479,10981528,10983156,10983252,10983160,10983254,10983158,10983270,10983681,10983994,10984064,10984109,10985674,10985775,10999503,10999656,11015921,11016579,11036567,11038468,11038491,11038477,11038479,11038481,11038487,11038792,11038824,11038936,11039303,11039380,11055529,11055907,11067459,11067623,11070841,11070847,11084893,11084900,11086255,11086480,11086254,11086481,11086371,11086513,11087275,11087365,11087499,11087573,11088275,11088437,11106649,11108474,11109585,11120852,11121203,11121855,11139761,11139771,11140918,11140958,11140702,11140961,11140916,11140969,11141425,11142049,11157998,11158274,11186299,11186443,11195260,11195310,11198646,11198664,11213337,11213451,11229170,11229681,11229694,11229691,11230873,11232245,11232798,11238274,11238640,11240813,11242417,11243229,11243352,11246864,11247763,11253800,11254114,11267027,11267199,11284074,11286220,11286409,11286218,11286639,11287540,11303042,11303250,11305387,11305662,11320509,11321116,11337872,11337873,11339935,11339945,11339866,11340386,11340398,11341416,11341896,11343005,11343440,11359706,11361168,11361625,11361654,11374464,11375475,11392014,11392062,11393084,11393087,11393089,11393312,11394309,11394409,11394700,11394787,11394895,11394912,11395164,11395904,11397246,11397459,11415938,11418974,11433530,11433662,11434474,11434628,11436034,11436144,11436298,11436334,11440839,11441857,11449184,11453180,11449678,11453182,11479202,11479207,11481606,11481676,11481722,11481790,11481845,11481918,11481936,11494133,11494348,11500864,11501761,11501035,11501040,11514146,11515302,11530243,11530236,11532086,11532655,11532669,11532871,11533096,11538421,11538458,11543462,11544583,11557643,11558701,11573308,11573347,11575078,11575030,11575033,11575756,11575895,11575962,11576049,11576056,11578160,11579145,11579802,11580144,11587512,11587959,11601799,11601894,11601896,11602377,11619149,11619208,11618856,11619162,11618858,11619142,11620197,11620243,11620435,11624918,11626676,11635374,11637959,11649911,11650048,11667203,11667210,11667199,11667279,11667201,11667272,11667428,11667726,11668099,11668158,11668200,11668236,11678272,11678335,11679265,11680288,11684280,11684401,11711164,11712071,11712160,11712075,11712168,11712073,11712158,11713200,11713224,11713674,11713768,11738039,11738372,11738041,11738366,11756974,11757895,11757898,11757897,11758770,11758806,11758891,11758901,11758956,11759014,11767741,11767864,11770099,11770205,11805939,11805919,11805967,11807037,11807429,11807927,11816552,11818819,11824057,11825689,11824059,11838126,11854336,11854685,11855261,11865743,11896592,11896817,11896823,11896825,11896961,11897029,11897116,11905849,11907627,11940343,11940823,11941008,11941031,11941010,11942528,11942596,11942697,11942731,11942805,11942813,11952120,11965207,11980350,11980357,11981271,11981265,11981267,11981413,11982358,11982899,11983043,12006113,12006800,12021388,12021641,12021642,12022107,12022121,12022436,12022435,12022530,12022573,12024755,12024791,12031108,12034304,12034382,12046152,12047566,12061210,12062037,12062130,12062039,12062624,12062966,12063043,12063068,12063251,12065155,12065265,12071095,12071128,12085054,12086035,12101128,12101595,12101986,12102056,12101989,12102059,12102006,12102051,12102847,12103580,12103607,12103724,12103794,4280,4373,4281,4375,20592,20606,46525,47397,47445,48134,48246,48135,48244,48131,48242,48369,48390,48896,48900,49131,49193,49304,49361,57288,57494,71883,71964,85614,85656,86516,86526,86514,86546,86517,86547,87313,87317,87463,87481,87532,87804,88796,88911,94151,94182,97674,98613,99565,126641,127097,127092,127111,128655,128807,128886,133788,133907,136153,136167,138430,139122,157184,158679,172874,172875,173712,173859,173741,173857,173740,173861,174579,174584,174879,175254,175399,175446,177372,178223,193447,193466,210125,210124,210997,211006,211003,212537,212710,212750,212781,212911,213745,216375,213887,216633,220306,231585,247371,247390,248255,248254,248399,248258,248398,249119,249116,249218,249522,249928,249966,257543,257842,274343,288548,288752,289280,289283,289287,289828,289833,290548,290612,290666,299114,300853,314061,314103,316564,333606,334978,335123,340595,340598,372671,372743,373451,373556,373466,373558,373467,373595,373759,373775,374523,374544,374598) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: