Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 12 | 0 | 0 | 162 | 352 | 7 | 42 | 0 | 7.75 | 1138 |
Национальная сборная | 4 | 0 | 0 | 57 | 118 | 5 | 31 | 0 | 8.00 | 369 |
Отборочный турнир | 4 | 0 | 0 | 57 | 118 | 5 | 31 | 0 | 8.00 | 369 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 8 | 0 | 0 | 105 | 234 | 2 | 11 | 0 | 7.62 | 769 |
Отборочный турнир | 5 | 0 | 0 | 46 | 122 | 1 | 4 | 0 | 7.00 | 462 |
Финальный турнир | 3 | 0 | 0 | 59 | 112 | 1 | 7 | 0 | 8.67 | 307 |
ТОВЫ сборных | 4 | 0 | 0 | 39 | 100 | 3 | 28 | 0 | 7.75 | 369 |
Всего за сборные | 16 | 0 | 0 | 201 | 452 | 10 | 70 | 0 | 7.75 | 1507 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 68433 WHERE `RP`.`player` = 68433 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107436,107438,122125,122794,122129,122711,122130,122712,122796,123412,214038,214039,215276,215277,246561,246841,247525,248502,257423,257455,259684,259819,261932,261995,264309,264868,277174,277207,281445,281533,283283,283409,299344,299430,300924,301878,303004,301881,303454,337488,337684,342203,342234,346083,346996,371869,372139,374175,10368445,10369026,10370621,10386536,10386873,10400000,10400246,10403518,10403780,10406340,10407245,10436648,10436771,10440310,10441388,10441488,10441491,10441386,10441490,10442093,10442197,10442663,10442808,10443337,10443967,10464871,10466230,10465186,10477258,10481033,10481642,10483462,10483432,10510303,10510538,10512421,10512447,10513580,10513581,10513653,10514131,10514461,10514709,10541029,10541576,10543281,10545702,10568406,10568479,10570005,10570110,10570138,10570202,10570318,10570605,10570753,10570862,10570954,10583731,10583831,10604949,10605240,10608181,10608192,10638198,10638285,10639819,10640429,10640572,10639807,10640597,10640888,10640890,10640954,10641091,10641102,10647787,10661554,10662551,10664829,10665083,10690428,10690455,10691839,10692044,10691608,10692046,10691755,10692041,10692390,10692474,10692669,10692889,10693185,10694003,10708535,10710199,10710241,10727857,10729729,10729999,10757425,10757482,10758586,10758657,10758587,10758654,10758583,10758659,10760401,10760763,10760884,10760904,10762166,10762413,10770395,10772583,10773883,10777256,10777643,10779741,10780692,10796458,10795101,10798006,10799746,10825229,10825442,10826309,10826362,10826284,10826417,10826285,10826364,10826623,10826626,10827040,10827813,10828069,10839379,10839604,10840919,10841237,10843054,10875766,10892919,10893219,10893878,10893922,10893876,10893931,10893879,10893933,10894140,10894158,10894602,10894713,10896558,10896130,10905111,10905291,10906571,10906692,10921241,10921863,10937008,10937278,10938039,10938134,10938042,10938132,10938043,10938129,10939509,10939593,10940780,10941036,10941684,10948250,10949492,10962655,10963346,10981538,10983064,10983066,10983143,10983749,10984054,10984104,10985679,10985839,10999616,11000240,11015576,11016408,11036328,11036775,11038414,11038507,11038423,11038434,11038431,11038513,11038807,11038845,11038897,11038911,11039279,11039381,11055495,11056011,11068000,11068319,11070814,11070843,11085013,11085368,11086144,11086258,11085910,11086267,11085907,11086265,11087224,11087331,11087513,11087543,11087640,11088438,11106959,11108564,11109586,11120638,11121410,11121418,11139797,11139947,11140496,11140662,11140505,11140663,11140507,11140660,11141353,11141426,11141838,11141879,11142041,11158500,11186330,11186343,11187647,11187480,11187484,11188321,11188340,11188373,11188416,11189013,11188997,11195745,11196496,11198860,11199191,11213410,11213538,11229825,11230008,11229828,11230450,11229860,11230006,11230914,11231006,11232166,11233090,11238278,11240074,11241411,11242245,11243497,11244189,11246827,11248127,11254408,11254745,11268509,11284969,11286401,11286444,11286509,11286679,11286668,11287680,11288117,11303039,11303069,11305756,11306497,11321094,11322727,11337894,11339950,11339946,11339951,11340421,11341747,11342065,11343439,11344331,11360938,11361561,11361647,11362781,11374433,11375476,11392554,11392871,11393188,11393190,11393231,11394393,11394527,11394821,11395949,11397475,11418013,11433640,11434412,11434502,11434415,11434556,11434429,11434558,11436000,11436024,11436241,11440525,11440971,11449705,11451437,11449677,11451439,11479185,11479223,11481308,11481310,11481306,11481311,11481314,11481350,11481662,11481737,11481793,11481797,11481870,11481891,11493994,11494443,11500559,11502378,11500545,11502427,11514147,11514319,11530221,11530254,11531691,11531830,11531684,11531828,11531682,11531832,11532010,11532137,11532658,11532705,11532803,11532943,11538423,11538485,11544503,11545200,11557892,11558061,11573305,11573539,11574922,11575105,11574923,11575055,11575011,11575075,11575631,11575649,11575921,11575952,11576083,11576097,11577561,11578653,11580499,11581495,11587077,11587747,11601414,11601745,11602169,11602838,11616948,11616952,11618739,11618723,11619465,11618726,11619467,11619869,11619985,11620314,11620355,11620433,11625469,11626639,11635029,11635547,11637400,11637392,11651411,11651784,11666425,11666963,11667263,11667321,11667261,11667259,11667325,11667505,11667919,11668052,11668089,11668265,11678213,11678413,11680101,11680594,11682857,11683993,11711192,11713564,11713703,11713800,11740068,11741146,11756984,11757878,11757903,11757881,11757900,11757882,11757905,11758778,11758883,11758936,11758988,11759022,11767180,11767228,11770030,11771129,11805695,11805822,11805697,11805885,11805699,11805825,11807066,11807064,11807615,11807601,11807880,11807913,11816592,11818228,11823766,11824422,11823812,11824424,11852624,11854456,11854830,11854974,11855230,11855254,11865354,11865445,11896162,11896818,11896826,11896820,11896924,11897008,11897092,11904374,11906253,11907578,11907956,11940751,11942732,11942827,11951248,11952403,11965104,11980388,11981028,11981054,11981248,11981376,11981384,11981970,11982372,11982950,11982964,11983009,12006118,12021352,12021533,12021624,12021535,12021635,12021537,12021632,12022192,12022480,12022486,12022516,12022568,12024360,12024555,12031114,12031450,12034198,12034385,12046117,12046138,12061206,12061226,12062110,12062204,12062207,12062604,12062965,12063014,12063094,12063493,12065157,12065204,12071147,12071166,12085124,12085287,12101163,12102606,12103598,12103720,4285,4437,4287,4431,20607,20841,46585,47233,47393,47415,48137,48259,48147,48262,48159,48266,48388,48500,48823,49013,49161,49167,49445,49599,57499,57529,59749,59783,85627,86573,86575,86565,87392,87422,87455,87477,87505,87513,88245,88289,94209,95024,98689,98691,126322,127238,127231,127242,128632,128634,128775,128796,128900,133825,133924,136160,136750,139131,139058,157193,172843,172884,173827,173839,173835,174637,175197,175435,178771,179193,193443,193474,210137,210308,211159,212145,212144,212542,212700,212824,214354,214895,214358,214891,214798,214887,220278,231382,249206,249278,249879,257238,259194,260226,260494,272686,274342,288476,288517,289665,289671,289663,290081,290326,290625,290654,300474,300963,314104,331824,331865,333367,333366,333375,334856,334914,335031,335167,337402,338867,340357,340610,340346,343150,344098,344524,358138,358162,372153,373821,374498,374628) ) 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` = 68433 WHERE `RP`.`player` = 68433 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107436,107438,122125,122794,122129,122711,122130,122712,122796,123412,214038,214039,215276,215277,246561,246841,247525,248502,257423,257455,259684,259819,261932,261995,264309,264868,277174,277207,281445,281533,283283,283409,299344,299430,300924,301878,303004,301881,303454,337488,337684,342203,342234,346083,346996,371869,372139,374175,10368445,10369026,10370621,10386536,10386873,10400000,10400246,10403518,10403780,10406340,10407245,10436648,10436771,10440310,10441388,10441488,10441491,10441386,10441490,10442093,10442197,10442663,10442808,10443337,10443967,10464871,10466230,10465186,10477258,10481033,10481642,10483462,10483432,10510303,10510538,10512421,10512447,10513580,10513581,10513653,10514131,10514461,10514709,10541029,10541576,10543281,10545702,10568406,10568479,10570005,10570110,10570138,10570202,10570318,10570605,10570753,10570862,10570954,10583731,10583831,10604949,10605240,10608181,10608192,10638198,10638285,10639819,10640429,10640572,10639807,10640597,10640888,10640890,10640954,10641091,10641102,10647787,10661554,10662551,10664829,10665083,10690428,10690455,10691839,10692044,10691608,10692046,10691755,10692041,10692390,10692474,10692669,10692889,10693185,10694003,10708535,10710199,10710241,10727857,10729729,10729999,10757425,10757482,10758586,10758657,10758587,10758654,10758583,10758659,10760401,10760763,10760884,10760904,10762166,10762413,10770395,10772583,10773883,10777256,10777643,10779741,10780692,10796458,10795101,10798006,10799746,10825229,10825442,10826309,10826362,10826284,10826417,10826285,10826364,10826623,10826626,10827040,10827813,10828069,10839379,10839604,10840919,10841237,10843054,10875766,10892919,10893219,10893878,10893922,10893876,10893931,10893879,10893933,10894140,10894158,10894602,10894713,10896558,10896130,10905111,10905291,10906571,10906692,10921241,10921863,10937008,10937278,10938039,10938134,10938042,10938132,10938043,10938129,10939509,10939593,10940780,10941036,10941684,10948250,10949492,10962655,10963346,10981538,10983064,10983066,10983143,10983749,10984054,10984104,10985679,10985839,10999616,11000240,11015576,11016408,11036328,11036775,11038414,11038507,11038423,11038434,11038431,11038513,11038807,11038845,11038897,11038911,11039279,11039381,11055495,11056011,11068000,11068319,11070814,11070843,11085013,11085368,11086144,11086258,11085910,11086267,11085907,11086265,11087224,11087331,11087513,11087543,11087640,11088438,11106959,11108564,11109586,11120638,11121410,11121418,11139797,11139947,11140496,11140662,11140505,11140663,11140507,11140660,11141353,11141426,11141838,11141879,11142041,11158500,11186330,11186343,11187647,11187480,11187484,11188321,11188340,11188373,11188416,11189013,11188997,11195745,11196496,11198860,11199191,11213410,11213538,11229825,11230008,11229828,11230450,11229860,11230006,11230914,11231006,11232166,11233090,11238278,11240074,11241411,11242245,11243497,11244189,11246827,11248127,11254408,11254745,11268509,11284969,11286401,11286444,11286509,11286679,11286668,11287680,11288117,11303039,11303069,11305756,11306497,11321094,11322727,11337894,11339950,11339946,11339951,11340421,11341747,11342065,11343439,11344331,11360938,11361561,11361647,11362781,11374433,11375476,11392554,11392871,11393188,11393190,11393231,11394393,11394527,11394821,11395949,11397475,11418013,11433640,11434412,11434502,11434415,11434556,11434429,11434558,11436000,11436024,11436241,11440525,11440971,11449705,11451437,11449677,11451439,11479185,11479223,11481308,11481310,11481306,11481311,11481314,11481350,11481662,11481737,11481793,11481797,11481870,11481891,11493994,11494443,11500559,11502378,11500545,11502427,11514147,11514319,11530221,11530254,11531691,11531830,11531684,11531828,11531682,11531832,11532010,11532137,11532658,11532705,11532803,11532943,11538423,11538485,11544503,11545200,11557892,11558061,11573305,11573539,11574922,11575105,11574923,11575055,11575011,11575075,11575631,11575649,11575921,11575952,11576083,11576097,11577561,11578653,11580499,11581495,11587077,11587747,11601414,11601745,11602169,11602838,11616948,11616952,11618739,11618723,11619465,11618726,11619467,11619869,11619985,11620314,11620355,11620433,11625469,11626639,11635029,11635547,11637400,11637392,11651411,11651784,11666425,11666963,11667263,11667321,11667261,11667259,11667325,11667505,11667919,11668052,11668089,11668265,11678213,11678413,11680101,11680594,11682857,11683993,11711192,11713564,11713703,11713800,11740068,11741146,11756984,11757878,11757903,11757881,11757900,11757882,11757905,11758778,11758883,11758936,11758988,11759022,11767180,11767228,11770030,11771129,11805695,11805822,11805697,11805885,11805699,11805825,11807066,11807064,11807615,11807601,11807880,11807913,11816592,11818228,11823766,11824422,11823812,11824424,11852624,11854456,11854830,11854974,11855230,11855254,11865354,11865445,11896162,11896818,11896826,11896820,11896924,11897008,11897092,11904374,11906253,11907578,11907956,11940751,11942732,11942827,11951248,11952403,11965104,11980388,11981028,11981054,11981248,11981376,11981384,11981970,11982372,11982950,11982964,11983009,12006118,12021352,12021533,12021624,12021535,12021635,12021537,12021632,12022192,12022480,12022486,12022516,12022568,12024360,12024555,12031114,12031450,12034198,12034385,12046117,12046138,12061206,12061226,12062110,12062204,12062207,12062604,12062965,12063014,12063094,12063493,12065157,12065204,12071147,12071166,12085124,12085287,12101163,12102606,12103598,12103720,4285,4437,4287,4431,20607,20841,46585,47233,47393,47415,48137,48259,48147,48262,48159,48266,48388,48500,48823,49013,49161,49167,49445,49599,57499,57529,59749,59783,85627,86573,86575,86565,87392,87422,87455,87477,87505,87513,88245,88289,94209,95024,98689,98691,126322,127238,127231,127242,128632,128634,128775,128796,128900,133825,133924,136160,136750,139131,139058,157193,172843,172884,173827,173839,173835,174637,175197,175435,178771,179193,193443,193474,210137,210308,211159,212145,212144,212542,212700,212824,214354,214895,214358,214891,214798,214887,220278,231382,249206,249278,249879,257238,259194,260226,260494,272686,274342,288476,288517,289665,289671,289663,290081,290326,290625,290654,300474,300963,314104,331824,331865,333367,333366,333375,334856,334914,335031,335167,337402,338867,340357,340610,340346,343150,344098,344524,358138,358162,372153,373821,374498,374628) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: