(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 407 WHERE `RP`.`player` = 407 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125247,126346,128196,130045,204178,206084,209458,209701,280755,280757,280764,280767,280770,280776,338328,338334,338337,338342,338345,338347,10398237,10398239,10398246,10398249,10398252,10398258,10440273,10479151,10479153,10479160,10479163,10479166,10479172,10542205,10542207,10542214,10542217,10542220,10542226,10604653,10604655,10604662,10604665,10604668,10604674,10662904,10662907,10662910,10662913,10662920,10662923,10726414,10726417,10726420,10726423,10726430,10726433,10796584,10796587,10796590,10796593,10796600,10796603,10876508,10876514,10876517,10876522,10876525,10876527,10919810,10919813,10919816,10919819,10919826,10919829,10964220,10964223,10964226,10964229,10964236,10964239,11014942,11014947,11014952,11014953,11014960,11014963,11069726,11069731,11069736,11069737,11069744,11069747,11122036,11122041,11122046,11122047,11122054,11122057,11170598,11170603,11170608,11170609,11170616,11170619,11186262,11213918,11213919,11213925,11213929,11213932,11213938,11266526,11266527,11266533,11266537,11266540,11266546,11323310,11323311,11323317,11323321,11323324,11323330,11375006,11375007,11375013,11375017,11375020,11375026,11418594,11418595,11418601,11418605,11418608,11418614,11433514,11464781,11464786,11464789,11464794,11464797,11464802,11513751,11513756,11513759,11513764,11513767,11513772,11556997,11557002,11557005,11557010,11557013,11557018,11600629,11600634,11600637,11600642,11600645,11600650,11649625,11649630,11649633,11649638,11649641,11649646,11666277,11671485,11671490,11671492,11671498,11671501,11671503,11711132,11739384,11739389,11739392,11739397,11739400,11739405,11756964,11787004,11787009,11787011,11787017,11787020,11787022,11837098,11837103,11837105,11837111,11837114,11837116,11868822,11868827,11868830,11868835,11868838,11868843,11895849,11923942,11923947,11923950,11923955,11923958,11923963,11940008,11964144,11964149,11964152,11964157,11964160,11964165,12004414,12004419,12004421,12004427,12004430,12004432,12045592,12045597,12045600,12045605,12045608,12045613,12084690,12084695,12084698,12084703,12084706,12084711,20353,20358,20361,20366,20369,20374,71609,71614,71617,71622,71625,71630,111819,111824,111826,111832,111835,111837,158551,158556,158558,158564,158567,158569,192773,192778,192781,192786,192789,192794,210102,232301,232306,232309,232314,232317,232322,273305,273310,273313,273318,273321,273326,312625,312630,312632,312638,312641,312643,357335,357340,357343,357348,357351,357356) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 407 WHERE `RP`.`player` = 407 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125247,126346,128196,130045,204178,206084,209458,209701,280755,280757,280764,280767,280770,280776,338328,338334,338337,338342,338345,338347,10398237,10398239,10398246,10398249,10398252,10398258,10440273,10479151,10479153,10479160,10479163,10479166,10479172,10542205,10542207,10542214,10542217,10542220,10542226,10604653,10604655,10604662,10604665,10604668,10604674,10662904,10662907,10662910,10662913,10662920,10662923,10726414,10726417,10726420,10726423,10726430,10726433,10796584,10796587,10796590,10796593,10796600,10796603,10876508,10876514,10876517,10876522,10876525,10876527,10919810,10919813,10919816,10919819,10919826,10919829,10964220,10964223,10964226,10964229,10964236,10964239,11014942,11014947,11014952,11014953,11014960,11014963,11069726,11069731,11069736,11069737,11069744,11069747,11122036,11122041,11122046,11122047,11122054,11122057,11170598,11170603,11170608,11170609,11170616,11170619,11186262,11213918,11213919,11213925,11213929,11213932,11213938,11266526,11266527,11266533,11266537,11266540,11266546,11323310,11323311,11323317,11323321,11323324,11323330,11375006,11375007,11375013,11375017,11375020,11375026,11418594,11418595,11418601,11418605,11418608,11418614,11433514,11464781,11464786,11464789,11464794,11464797,11464802,11513751,11513756,11513759,11513764,11513767,11513772,11556997,11557002,11557005,11557010,11557013,11557018,11600629,11600634,11600637,11600642,11600645,11600650,11649625,11649630,11649633,11649638,11649641,11649646,11666277,11671485,11671490,11671492,11671498,11671501,11671503,11711132,11739384,11739389,11739392,11739397,11739400,11739405,11756964,11787004,11787009,11787011,11787017,11787020,11787022,11837098,11837103,11837105,11837111,11837114,11837116,11868822,11868827,11868830,11868835,11868838,11868843,11895849,11923942,11923947,11923950,11923955,11923958,11923963,11940008,11964144,11964149,11964152,11964157,11964160,11964165,12004414,12004419,12004421,12004427,12004430,12004432,12045592,12045597,12045600,12045605,12045608,12045613,12084690,12084695,12084698,12084703,12084706,12084711,20353,20358,20361,20366,20369,20374,71609,71614,71617,71622,71625,71630,111819,111824,111826,111832,111835,111837,158551,158556,158558,158564,158567,158569,192773,192778,192781,192786,192789,192794,210102,232301,232306,232309,232314,232317,232322,273305,273310,273313,273318,273321,273326,312625,312630,312632,312638,312641,312643,357335,357340,357343,357348,357351,357356) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: