(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(140, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 72499 WHERE `RP`.`player` = 72499 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126381,128142,129048,130297,130663,132006,206117,209404,209576,209648,210921,209735,246880,246881,246887,280658,280664,280667,280672,280675,280677,303513,303518,303521,303660,304766,305237,338447,338452,338455,338460,338463,338468,10370805,10370810,10370813,10398359,10398364,10398367,10398372,10398375,10398380,10440288,10479317,10479322,10479325,10479330,10479333,10479338,10542060,10542066,10542069,10542074,10542077,10542079,10567350,10569162,10569167,10569172,10570029,10570144,10570553,10604771,10604776,10604779,10604784,10604787,10604792,10637424,10663189,10663194,10663197,10663202,10663205,10663210,10691431,10691436,10691438,10692386,10726195,10726200,10726203,10726208,10726211,10726216,10758417,10758422,10758425,10760382,10760874,10761815,10797037,10797042,10797045,10797050,10797053,10797058,10826205,10826210,10826213,10826538,10826638,10827305,10876699,10876704,10876707,10876712,10876715,10876720,10892855,10919543,10919548,10919551,10919556,10919559,10919564,10937981,10937986,10937989,10939492,10964651,10964656,10964659,10964664,10964667,10964672,10982905,10982910,10982913,10983330,10984025,10985560,11015013,11015018,11015021,11015026,11015029,11015034,11038351,11038356,11038359,11038761,11038879,11038974,11069245,11069250,11069253,11069258,11069261,11069266,11085771,11085776,11085779,11087193,11122323,11122328,11122331,11122336,11122339,11122344,11170333,11170338,11170341,11170346,11170349,11170354,11186611,11186616,11186619,11188238,11214059,11214064,11214067,11214072,11214075,11214080,11229565,11229570,11229573,11266835,11266840,11266843,11266848,11266851,11266856,11286177,11286182,11286184,11323165,11323170,11323172,11323178,11323181,11323183,11374620,11374625,11374630,11374631,11374638,11374641,11418377,11418382,11418384,11418390,11418393,11418395,11464350,11464355,11464360,11464361,11464368,11464371,11479158,11481186,11481191,11481196,11481632,11513681,11513686,11513688,11513694,11513697,11513699,11556736,11556737,11556743,11556747,11556750,11556756,11600296,11600297,11600303,11600307,11600310,11600316,11649291,11649296,11649298,11649304,11649307,11649309,11667110,11667111,11667117,11667363,11671317,11671322,11671324,11671330,11671333,11671335,11711976,11711981,11711983,11713167,11739074,11739079,11739081,11739087,11739090,11739092,11786645,11786646,11786652,11786656,11786659,11786665,11836953,11836958,11836963,11836964,11836971,11836974,11868703,11868708,11868713,11868714,11868721,11868724,11923751,11923756,11923761,11923762,11923769,11923772,11940000,11963979,11963980,11963986,11963990,11963993,11963999,12003909,12003914,12003919,12003920,12003927,12003930,12021325,12021445,12021450,12021455,12021989,12022384,12022498,12045352,12045357,12045360,12045365,12045368,12045373,12084380,12084385,12084387,12084393,12084396,12084398,20043,20048,20050,20056,20059,20061,71587,71592,71594,71600,71603,71605,111556,111557,111563,111567,111570,111576,158190,158195,158200,158201,158208,158211,192630,192635,192640,192641,192648,192651,232688,232689,232695,232699,232702,232708,248118,248119,248125,273092,273093,273099,273103,273106,273112,312408,312413,312418,312419,312426,312429,356976,356981,356986,356987,356994,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(140, 207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 72499 WHERE `RP`.`player` = 72499 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126381,128142,129048,130297,130663,132006,206117,209404,209576,209648,210921,209735,246880,246881,246887,280658,280664,280667,280672,280675,280677,303513,303518,303521,303660,304766,305237,338447,338452,338455,338460,338463,338468,10370805,10370810,10370813,10398359,10398364,10398367,10398372,10398375,10398380,10440288,10479317,10479322,10479325,10479330,10479333,10479338,10542060,10542066,10542069,10542074,10542077,10542079,10567350,10569162,10569167,10569172,10570029,10570144,10570553,10604771,10604776,10604779,10604784,10604787,10604792,10637424,10663189,10663194,10663197,10663202,10663205,10663210,10691431,10691436,10691438,10692386,10726195,10726200,10726203,10726208,10726211,10726216,10758417,10758422,10758425,10760382,10760874,10761815,10797037,10797042,10797045,10797050,10797053,10797058,10826205,10826210,10826213,10826538,10826638,10827305,10876699,10876704,10876707,10876712,10876715,10876720,10892855,10919543,10919548,10919551,10919556,10919559,10919564,10937981,10937986,10937989,10939492,10964651,10964656,10964659,10964664,10964667,10964672,10982905,10982910,10982913,10983330,10984025,10985560,11015013,11015018,11015021,11015026,11015029,11015034,11038351,11038356,11038359,11038761,11038879,11038974,11069245,11069250,11069253,11069258,11069261,11069266,11085771,11085776,11085779,11087193,11122323,11122328,11122331,11122336,11122339,11122344,11170333,11170338,11170341,11170346,11170349,11170354,11186611,11186616,11186619,11188238,11214059,11214064,11214067,11214072,11214075,11214080,11229565,11229570,11229573,11266835,11266840,11266843,11266848,11266851,11266856,11286177,11286182,11286184,11323165,11323170,11323172,11323178,11323181,11323183,11374620,11374625,11374630,11374631,11374638,11374641,11418377,11418382,11418384,11418390,11418393,11418395,11464350,11464355,11464360,11464361,11464368,11464371,11479158,11481186,11481191,11481196,11481632,11513681,11513686,11513688,11513694,11513697,11513699,11556736,11556737,11556743,11556747,11556750,11556756,11600296,11600297,11600303,11600307,11600310,11600316,11649291,11649296,11649298,11649304,11649307,11649309,11667110,11667111,11667117,11667363,11671317,11671322,11671324,11671330,11671333,11671335,11711976,11711981,11711983,11713167,11739074,11739079,11739081,11739087,11739090,11739092,11786645,11786646,11786652,11786656,11786659,11786665,11836953,11836958,11836963,11836964,11836971,11836974,11868703,11868708,11868713,11868714,11868721,11868724,11923751,11923756,11923761,11923762,11923769,11923772,11940000,11963979,11963980,11963986,11963990,11963993,11963999,12003909,12003914,12003919,12003920,12003927,12003930,12021325,12021445,12021450,12021455,12021989,12022384,12022498,12045352,12045357,12045360,12045365,12045368,12045373,12084380,12084385,12084387,12084393,12084396,12084398,20043,20048,20050,20056,20059,20061,71587,71592,71594,71600,71603,71605,111556,111557,111563,111567,111570,111576,158190,158195,158200,158201,158208,158211,192630,192635,192640,192641,192648,192651,232688,232689,232695,232699,232702,232708,248118,248119,248125,273092,273093,273099,273103,273106,273112,312408,312413,312418,312419,312426,312429,356976,356981,356986,356987,356994,356997) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: