(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` = 1723 WHERE `RP`.`player` = 1723 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125163,126353,128114,129021,130264,204092,206089,209376,209619,209706,280585,280590,280593,280598,280601,280606,301761,303372,338615,338620,338623,338628,338631,338636,10369071,10398528,10398534,10398537,10398542,10398545,10398547,10479389,10479394,10479397,10479402,10479405,10479410,10542084,10542090,10542093,10542098,10542101,10542103,10604917,10604919,10604926,10604929,10604932,10604938,10637430,10663093,10663098,10663101,10663106,10663109,10663114,10726219,10726224,10726227,10726232,10726235,10726240,10797061,10797066,10797069,10797074,10797077,10797082,10825098,10876603,10876608,10876611,10876616,10876619,10876624,10919615,10919620,10919623,10919628,10919631,10919636,10964555,10964560,10964563,10964568,10964571,10964576,10981487,11015061,11015066,11015069,11015074,11015077,11015082,11069223,11069228,11069230,11069236,11069239,11069241,11122446,11122447,11122453,11122457,11122460,11122466,11170407,11170412,11170414,11170420,11170423,11170425,11214229,11214234,11214236,11214242,11214245,11214247,11266812,11266817,11266822,11266823,11266830,11266833,11284028,11323094,11323095,11323101,11323105,11323108,11323114,11374740,11374745,11374750,11374751,11374758,11374761,11391963,11418474,11418475,11418481,11418485,11418488,11418494,11433503,11464376,11464377,11464383,11464387,11464390,11464396,11513610,11513611,11513617,11513621,11513624,11513630,11556712,11556713,11556719,11556723,11556726,11556732,11573284,11600485,11600490,11600493,11600498,11600501,11600506,11649219,11649224,11649226,11649232,11649235,11649237,11666263,11671339,11671344,11671347,11671352,11671355,11671360,11738880,11738885,11738888,11738893,11738896,11738901,11756955,11786690,11786695,11786698,11786703,11786706,11786711,11836904,11836909,11836912,11836917,11836920,11836925,11868654,11868659,11868662,11868667,11868670,11868675,11923678,11923683,11923686,11923691,11923694,11923699,11940005,11963832,11963837,11963840,11963845,11963848,11963853,12003932,12003937,12003940,12003945,12003948,12003953,12045280,12045285,12045288,12045293,12045296,12045301,12084522,12084527,12084530,12084535,12084538,12084543,19945,19950,19953,19958,19961,19966,71489,71494,71497,71502,71505,71510,111529,111534,111537,111542,111545,111550,158165,158170,158173,158178,158181,158186,192461,192466,192469,192474,192477,192482,232685,232690,232693,232698,232701,232706,273019,273024,273026,273032,273035,273037,312385,312390,312392,312398,312401,312403,356927,356932,356935,356940,356943,356948) ) 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` = 1723 WHERE `RP`.`player` = 1723 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125163,126353,128114,129021,130264,204092,206089,209376,209619,209706,280585,280590,280593,280598,280601,280606,301761,303372,338615,338620,338623,338628,338631,338636,10369071,10398528,10398534,10398537,10398542,10398545,10398547,10479389,10479394,10479397,10479402,10479405,10479410,10542084,10542090,10542093,10542098,10542101,10542103,10604917,10604919,10604926,10604929,10604932,10604938,10637430,10663093,10663098,10663101,10663106,10663109,10663114,10726219,10726224,10726227,10726232,10726235,10726240,10797061,10797066,10797069,10797074,10797077,10797082,10825098,10876603,10876608,10876611,10876616,10876619,10876624,10919615,10919620,10919623,10919628,10919631,10919636,10964555,10964560,10964563,10964568,10964571,10964576,10981487,11015061,11015066,11015069,11015074,11015077,11015082,11069223,11069228,11069230,11069236,11069239,11069241,11122446,11122447,11122453,11122457,11122460,11122466,11170407,11170412,11170414,11170420,11170423,11170425,11214229,11214234,11214236,11214242,11214245,11214247,11266812,11266817,11266822,11266823,11266830,11266833,11284028,11323094,11323095,11323101,11323105,11323108,11323114,11374740,11374745,11374750,11374751,11374758,11374761,11391963,11418474,11418475,11418481,11418485,11418488,11418494,11433503,11464376,11464377,11464383,11464387,11464390,11464396,11513610,11513611,11513617,11513621,11513624,11513630,11556712,11556713,11556719,11556723,11556726,11556732,11573284,11600485,11600490,11600493,11600498,11600501,11600506,11649219,11649224,11649226,11649232,11649235,11649237,11666263,11671339,11671344,11671347,11671352,11671355,11671360,11738880,11738885,11738888,11738893,11738896,11738901,11756955,11786690,11786695,11786698,11786703,11786706,11786711,11836904,11836909,11836912,11836917,11836920,11836925,11868654,11868659,11868662,11868667,11868670,11868675,11923678,11923683,11923686,11923691,11923694,11923699,11940005,11963832,11963837,11963840,11963845,11963848,11963853,12003932,12003937,12003940,12003945,12003948,12003953,12045280,12045285,12045288,12045293,12045296,12045301,12084522,12084527,12084530,12084535,12084538,12084543,19945,19950,19953,19958,19961,19966,71489,71494,71497,71502,71505,71510,111529,111534,111537,111542,111545,111550,158165,158170,158173,158178,158181,158186,192461,192466,192469,192474,192477,192482,232685,232690,232693,232698,232701,232706,273019,273024,273026,273032,273035,273037,312385,312390,312392,312398,312401,312403,356927,356932,356935,356940,356943,356948) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: