(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 47736 WHERE `RP`.`player` = 47736 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125164,126355,128116,129020,130267,204095,206091,209378,209620,209707,280707,280709,280716,280719,280722,280728,301755,303371,338449,338451,338458,338461,338464,338470,10398601,10398603,10398610,10398613,10398616,10398622,10479295,10479297,10479304,10479307,10479310,10479316,10542110,10542113,10542116,10542119,10542126,10542129,10604726,10604729,10604732,10604735,10604742,10604745,10663072,10663075,10663078,10663081,10663088,10663091,10726342,10726345,10726348,10726351,10726358,10726361,10796943,10796945,10796952,10796955,10796958,10796964,10825095,10876557,10876559,10876566,10876569,10876572,10876578,10919617,10919619,10919626,10919629,10919632,10919638,10964678,10964681,10964684,10964687,10964694,10964697,11015064,11015065,11015071,11015075,11015078,11015084,11069462,11069467,11069472,11069473,11069480,11069483,11122300,11122305,11122310,11122311,11122318,11122321,11170408,11170409,11170415,11170419,11170422,11170428,11186273,11214013,11214018,11214020,11214026,11214029,11214031,11266934,11266935,11266941,11266945,11266948,11266954,11323117,11323122,11323124,11323130,11323133,11323135,11374693,11374698,11374700,11374706,11374709,11374711,11418282,11418283,11418289,11418293,11418296,11418302,11464496,11464497,11464503,11464507,11464510,11464516,11513536,11513541,11513546,11513547,11513554,11513557,11556782,11556787,11556792,11556793,11556800,11556803,11600294,11600299,11600304,11600305,11600312,11600315,11649194,11649199,11649204,11649205,11649212,11649215,11671412,11671417,11671422,11671423,11671430,11671433,11739121,11739126,11739131,11739132,11739139,11739142,11786715,11786720,11786725,11786726,11786733,11786736,11836977,11836982,11836987,11836988,11836995,11836998,11868583,11868588,11868593,11868594,11868601,11868604,11923871,11923876,11923881,11923882,11923889,11923892,11963977,11963982,11963987,11963988,11963995,11963998,12004125,12004130,12004135,12004136,12004143,12004146,12045209,12045214,12045219,12045220,12045227,12045230,12084427,12084432,12084437,12084438,12084445,12084448,19946,19951,19956,19957,19964,19967,71562,71567,71572,71573,71580,71583,111434,111439,111444,111445,111452,111455,158214,158219,158224,158225,158232,158235,192534,192539,192544,192545,192552,192555,232614,232619,232624,232625,232632,232635,273090,273095,273100,273101,273108,273111,312216,312221,312226,312227,312234,312237,331800,357122,357123,357129,357133,357136,357142) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 47736 WHERE `RP`.`player` = 47736 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125164,126355,128116,129020,130267,204095,206091,209378,209620,209707,280707,280709,280716,280719,280722,280728,301755,303371,338449,338451,338458,338461,338464,338470,10398601,10398603,10398610,10398613,10398616,10398622,10479295,10479297,10479304,10479307,10479310,10479316,10542110,10542113,10542116,10542119,10542126,10542129,10604726,10604729,10604732,10604735,10604742,10604745,10663072,10663075,10663078,10663081,10663088,10663091,10726342,10726345,10726348,10726351,10726358,10726361,10796943,10796945,10796952,10796955,10796958,10796964,10825095,10876557,10876559,10876566,10876569,10876572,10876578,10919617,10919619,10919626,10919629,10919632,10919638,10964678,10964681,10964684,10964687,10964694,10964697,11015064,11015065,11015071,11015075,11015078,11015084,11069462,11069467,11069472,11069473,11069480,11069483,11122300,11122305,11122310,11122311,11122318,11122321,11170408,11170409,11170415,11170419,11170422,11170428,11186273,11214013,11214018,11214020,11214026,11214029,11214031,11266934,11266935,11266941,11266945,11266948,11266954,11323117,11323122,11323124,11323130,11323133,11323135,11374693,11374698,11374700,11374706,11374709,11374711,11418282,11418283,11418289,11418293,11418296,11418302,11464496,11464497,11464503,11464507,11464510,11464516,11513536,11513541,11513546,11513547,11513554,11513557,11556782,11556787,11556792,11556793,11556800,11556803,11600294,11600299,11600304,11600305,11600312,11600315,11649194,11649199,11649204,11649205,11649212,11649215,11671412,11671417,11671422,11671423,11671430,11671433,11739121,11739126,11739131,11739132,11739139,11739142,11786715,11786720,11786725,11786726,11786733,11786736,11836977,11836982,11836987,11836988,11836995,11836998,11868583,11868588,11868593,11868594,11868601,11868604,11923871,11923876,11923881,11923882,11923889,11923892,11963977,11963982,11963987,11963988,11963995,11963998,12004125,12004130,12004135,12004136,12004143,12004146,12045209,12045214,12045219,12045220,12045227,12045230,12084427,12084432,12084437,12084438,12084445,12084448,19946,19951,19956,19957,19964,19967,71562,71567,71572,71573,71580,71583,111434,111439,111444,111445,111452,111455,158214,158219,158224,158225,158232,158235,192534,192539,192544,192545,192552,192555,232614,232619,232624,232625,232632,232635,273090,273095,273100,273101,273108,273111,312216,312221,312226,312227,312234,312237,331800,357122,357123,357129,357133,357136,357142) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: