(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` = 73912 WHERE `RP`.`player` = 73912 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125237,126339,126381,128188,128142,129007,129048,130034,130297,130663,132006,204168,206075,206117,209450,209404,209576,209605,209648,210921,209692,209735,246880,246949,246881,246954,246887,246957,250367,280753,280658,280758,280664,280761,280667,280766,280672,280769,280675,280774,280677,301748,303513,303518,303521,303660,304766,305237,338207,338447,338212,338452,338215,338455,338220,338460,338223,338463,338228,338468,10370805,10370735,10370810,10370740,10370813,10370742,10398236,10398359,10398242,10398364,10398245,10398367,10398250,10398372,10398253,10398375,10398255,10398380,10440288,10441209,10441214,10441217,10479029,10479317,10479034,10479322,10479037,10479325,10479042,10479330,10479045,10479333,10479050,10479338,10512404,10542396,10542060,10542402,10542066,10542405,10542069,10542410,10542074,10542413,10542077,10542415,10542079,10567350,10569162,10569167,10569172,10570029,10570144,10570553,10604460,10604771,10604466,10604776,10604469,10604779,10604474,10604784,10604477,10604787,10604479,10604792,10637412,10637424,10662830,10663189,10662836,10663194,10662839,10663197,10662844,10663202,10662847,10663205,10662849,10663210,10691431,10691383,10691436,10691388,10691438,10691390,10692386,10726628,10726195,10726634,10726200,10726637,10726203,10726642,10726208,10726645,10726211,10726647,10726216,10758417,10758465,10758422,10758470,10758425,10758473,10760382,10760393,10760874,10761815,10796653,10797037,10796658,10797042,10796661,10797045,10796666,10797050,10796669,10797053,10796674,10797058,10826205,10826265,10826210,10826270,10826213,10826273,10826538,10826544,10826638,10826634,10827305,10827307,10876435,10876699,10876440,10876704,10876443,10876707,10876448,10876712,10876451,10876715,10876456,10876720,10892870,10892855,10893758,10893763,10893768,10893986,10894520,10895369,10919999,10919543,10920004,10919548,10920007,10919551,10920012,10919556,10920015,10919559,10920020,10919564,10937981,10937986,10937989,10939492,10964265,10964651,10964270,10964656,10964273,10964659,10964278,10964664,10964281,10964667,10964286,10964672,10982905,10982910,10982913,10983330,10984025,10985560,11014941,11015013,11014946,11015018,11014949,11015021,11014954,11015026,11014957,11015029,11014962,11015034,11038351,11038356,11038359,11038761,11038879,11038974,11069631,11069245,11069636,11069250,11069638,11069253,11069644,11069258,11069647,11069261,11069649,11069266,11084887,11085771,11085776,11085779,11087193,11122037,11122323,11122042,11122328,11122044,11122331,11122050,11122336,11122053,11122339,11122055,11122344,11170528,11170333,11170529,11170338,11170535,11170341,11170539,11170346,11170542,11170349,11170548,11170354,11186264,11186611,11186684,11186616,11186689,11186619,11186694,11188238,11213749,11214059,11213754,11214064,11213756,11214067,11213762,11214072,11213765,11214075,11213767,11214080,11229565,11229627,11229570,11229632,11229573,11229634,11266691,11266835,11266696,11266840,11266699,11266843,11266704,11266848,11266707,11266851,11266712,11266856,11286177,11286182,11286184,11323406,11323165,11323407,11323170,11323413,11323172,11323417,11323178,11323420,11323181,11323426,11323183,11375004,11374620,11375009,11374625,11375014,11374630,11375015,11374631,11375022,11374638,11375025,11374641,11393006,11393007,11393013,11418618,11418377,11418619,11418382,11418625,11418384,11418629,11418390,11418632,11418393,11418638,11418395,11433518,11434214,11434219,11434224,11435317,11464567,11464350,11464572,11464355,11464574,11464360,11464580,11464361,11464583,11464368,11464585,11464371,11479165,11479158,11481186,11481222,11481191,11481227,11481196,11481232,11481632,11481639,11481772,11481864,11513871,11513681,11513876,11513686,11513879,11513688,11513884,11513694,11513887,11513697,11513892,11513699,11531601,11531606,11531608,11531963,11556877,11556736,11556882,11556737,11556885,11556743,11556890,11556747,11556893,11556750,11556898,11556756,11600701,11600296,11600706,11600297,11600709,11600303,11600714,11600307,11600717,11600310,11600722,11600316,11649603,11649291,11649608,11649296,11649610,11649298,11649616,11649304,11649619,11649307,11649621,11649309,11667110,11667111,11667117,11667363,11671677,11671317,11671682,11671322,11671684,11671324,11671690,11671330,11671693,11671333,11671695,11671335,11711976,11711981,11711983,11713167,11739147,11739074,11739148,11739079,11739154,11739081,11739158,11739087,11739161,11739090,11739167,11739092,11757841,11757843,11757836,11758749,11758863,11758950,11787074,11786645,11787079,11786646,11787082,11786652,11787087,11786656,11787090,11786659,11787095,11786665,11805300,11805305,11805308,11837192,11836953,11837197,11836958,11837200,11836963,11837205,11836964,11837208,11836971,11837213,11836974,11852584,11869016,11868703,11869021,11868708,11869023,11868713,11869029,11868714,11869032,11868721,11869034,11868724,11896700,11896705,11896707,11924160,11923751,11924165,11923756,11924167,11923761,11924173,11923762,11924176,11923769,11924178,11923772,11940000,11964240,11963979,11964245,11963980,11964248,11963986,11964253,11963990,11964256,11963993,11964261,11963999,11980326,12004222,12003909,12004227,12003914,12004229,12003919,12004235,12003920,12004238,12003927,12004240,12003930,12021325,12021445,12021468,12021450,12021473,12021455,12021476,12021997,12021989,12022384,12022389,12022498,12022502,12045544,12045352,12045549,12045357,12045552,12045360,12045557,12045365,12045560,12045368,12045565,12045373,12061962,12061967,12061970,12084786,12084380,12084791,12084385,12084794,12084387,12084799,12084393,12084802,12084396,12084807,12084398,20355,20043,20360,20048,20362,20050,20368,20056,20371,20059,20373,20061,48052,48053,48059,48362,71731,71587,71736,71592,71738,71594,71744,71600,71747,71603,71749,71605,111795,111556,111800,111557,111802,111563,111808,111567,111811,111570,111813,111576,127043,127048,127050,128621,128774,128861,158477,158190,158482,158195,158485,158200,158490,158201,158493,158208,158498,158211,173683,173688,173691,174573,192821,192630,192826,192635,192829,192640,192834,192641,192837,192648,192842,192651,210947,210952,210955,232253,232688,232258,232689,232261,232695,232266,232699,232269,232702,232274,232708,247356,248118,248119,248125,273331,273092,273336,273093,273338,273099,273344,273103,273347,273106,273349,273112,312505,312408,312510,312413,312512,312418,312518,312419,312521,312426,312523,312429,331809,357265,356976,357270,356981,357272,356986,357278,356987,357281,356994,357283,356997) ) 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` = 73912 WHERE `RP`.`player` = 73912 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125237,126339,126381,128188,128142,129007,129048,130034,130297,130663,132006,204168,206075,206117,209450,209404,209576,209605,209648,210921,209692,209735,246880,246949,246881,246954,246887,246957,250367,280753,280658,280758,280664,280761,280667,280766,280672,280769,280675,280774,280677,301748,303513,303518,303521,303660,304766,305237,338207,338447,338212,338452,338215,338455,338220,338460,338223,338463,338228,338468,10370805,10370735,10370810,10370740,10370813,10370742,10398236,10398359,10398242,10398364,10398245,10398367,10398250,10398372,10398253,10398375,10398255,10398380,10440288,10441209,10441214,10441217,10479029,10479317,10479034,10479322,10479037,10479325,10479042,10479330,10479045,10479333,10479050,10479338,10512404,10542396,10542060,10542402,10542066,10542405,10542069,10542410,10542074,10542413,10542077,10542415,10542079,10567350,10569162,10569167,10569172,10570029,10570144,10570553,10604460,10604771,10604466,10604776,10604469,10604779,10604474,10604784,10604477,10604787,10604479,10604792,10637412,10637424,10662830,10663189,10662836,10663194,10662839,10663197,10662844,10663202,10662847,10663205,10662849,10663210,10691431,10691383,10691436,10691388,10691438,10691390,10692386,10726628,10726195,10726634,10726200,10726637,10726203,10726642,10726208,10726645,10726211,10726647,10726216,10758417,10758465,10758422,10758470,10758425,10758473,10760382,10760393,10760874,10761815,10796653,10797037,10796658,10797042,10796661,10797045,10796666,10797050,10796669,10797053,10796674,10797058,10826205,10826265,10826210,10826270,10826213,10826273,10826538,10826544,10826638,10826634,10827305,10827307,10876435,10876699,10876440,10876704,10876443,10876707,10876448,10876712,10876451,10876715,10876456,10876720,10892870,10892855,10893758,10893763,10893768,10893986,10894520,10895369,10919999,10919543,10920004,10919548,10920007,10919551,10920012,10919556,10920015,10919559,10920020,10919564,10937981,10937986,10937989,10939492,10964265,10964651,10964270,10964656,10964273,10964659,10964278,10964664,10964281,10964667,10964286,10964672,10982905,10982910,10982913,10983330,10984025,10985560,11014941,11015013,11014946,11015018,11014949,11015021,11014954,11015026,11014957,11015029,11014962,11015034,11038351,11038356,11038359,11038761,11038879,11038974,11069631,11069245,11069636,11069250,11069638,11069253,11069644,11069258,11069647,11069261,11069649,11069266,11084887,11085771,11085776,11085779,11087193,11122037,11122323,11122042,11122328,11122044,11122331,11122050,11122336,11122053,11122339,11122055,11122344,11170528,11170333,11170529,11170338,11170535,11170341,11170539,11170346,11170542,11170349,11170548,11170354,11186264,11186611,11186684,11186616,11186689,11186619,11186694,11188238,11213749,11214059,11213754,11214064,11213756,11214067,11213762,11214072,11213765,11214075,11213767,11214080,11229565,11229627,11229570,11229632,11229573,11229634,11266691,11266835,11266696,11266840,11266699,11266843,11266704,11266848,11266707,11266851,11266712,11266856,11286177,11286182,11286184,11323406,11323165,11323407,11323170,11323413,11323172,11323417,11323178,11323420,11323181,11323426,11323183,11375004,11374620,11375009,11374625,11375014,11374630,11375015,11374631,11375022,11374638,11375025,11374641,11393006,11393007,11393013,11418618,11418377,11418619,11418382,11418625,11418384,11418629,11418390,11418632,11418393,11418638,11418395,11433518,11434214,11434219,11434224,11435317,11464567,11464350,11464572,11464355,11464574,11464360,11464580,11464361,11464583,11464368,11464585,11464371,11479165,11479158,11481186,11481222,11481191,11481227,11481196,11481232,11481632,11481639,11481772,11481864,11513871,11513681,11513876,11513686,11513879,11513688,11513884,11513694,11513887,11513697,11513892,11513699,11531601,11531606,11531608,11531963,11556877,11556736,11556882,11556737,11556885,11556743,11556890,11556747,11556893,11556750,11556898,11556756,11600701,11600296,11600706,11600297,11600709,11600303,11600714,11600307,11600717,11600310,11600722,11600316,11649603,11649291,11649608,11649296,11649610,11649298,11649616,11649304,11649619,11649307,11649621,11649309,11667110,11667111,11667117,11667363,11671677,11671317,11671682,11671322,11671684,11671324,11671690,11671330,11671693,11671333,11671695,11671335,11711976,11711981,11711983,11713167,11739147,11739074,11739148,11739079,11739154,11739081,11739158,11739087,11739161,11739090,11739167,11739092,11757841,11757843,11757836,11758749,11758863,11758950,11787074,11786645,11787079,11786646,11787082,11786652,11787087,11786656,11787090,11786659,11787095,11786665,11805300,11805305,11805308,11837192,11836953,11837197,11836958,11837200,11836963,11837205,11836964,11837208,11836971,11837213,11836974,11852584,11869016,11868703,11869021,11868708,11869023,11868713,11869029,11868714,11869032,11868721,11869034,11868724,11896700,11896705,11896707,11924160,11923751,11924165,11923756,11924167,11923761,11924173,11923762,11924176,11923769,11924178,11923772,11940000,11964240,11963979,11964245,11963980,11964248,11963986,11964253,11963990,11964256,11963993,11964261,11963999,11980326,12004222,12003909,12004227,12003914,12004229,12003919,12004235,12003920,12004238,12003927,12004240,12003930,12021325,12021445,12021468,12021450,12021473,12021455,12021476,12021997,12021989,12022384,12022389,12022498,12022502,12045544,12045352,12045549,12045357,12045552,12045360,12045557,12045365,12045560,12045368,12045565,12045373,12061962,12061967,12061970,12084786,12084380,12084791,12084385,12084794,12084387,12084799,12084393,12084802,12084396,12084807,12084398,20355,20043,20360,20048,20362,20050,20368,20056,20371,20059,20373,20061,48052,48053,48059,48362,71731,71587,71736,71592,71738,71594,71744,71600,71747,71603,71749,71605,111795,111556,111800,111557,111802,111563,111808,111567,111811,111570,111813,111576,127043,127048,127050,128621,128774,128861,158477,158190,158482,158195,158485,158200,158490,158201,158493,158208,158498,158211,173683,173688,173691,174573,192821,192630,192826,192635,192829,192640,192834,192641,192837,192648,192842,192651,210947,210952,210955,232253,232688,232258,232689,232261,232695,232266,232699,232269,232702,232274,232708,247356,248118,248119,248125,273331,273092,273336,273093,273338,273099,273344,273103,273347,273106,273349,273112,312505,312408,312510,312413,312512,312418,312518,312419,312521,312426,312523,312429,331809,357265,356976,357270,356981,357272,356986,357278,356987,357281,356994,357283,356997) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: