48 сезон
Чемпионат Европы
Вход в систему
Вход через VK
ПБ-ВИКИ

Никос Иорданидис

    Игрок   Статистика   История   Травмы   Достижения   Сборные   Трансферы
 

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных1070013201206.9527
Национальная сборная110012017.5027
     Отборочный турнир110012017.5027
     Финальный турнир000000000.000
Молодежная сборная960012181196.890
     Отборочный турнир660010131117.420
     Финальный турнир300025085.830
ТОВЫ сборных101002320105.9547
Всего за сборные2080015521306.4574
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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}:
(c) 2002-2025 Дмитрий Язынин
Время создания страницы: 0.082 сек (3)
Size=(60624)