(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` = 36097 WHERE `RP`.`player` = 36097 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125207,126392,129065,130312,132009,132004,204136,206130,209574,209663,210931,209752,246867,246872,246874,280515,280517,280524,280527,280530,280536,338377,338379,338386,338389,338392,338398,10398529,10398531,10398538,10398541,10398544,10398550,10479271,10479273,10479280,10479283,10479286,10479292,10542086,10542089,10542092,10542095,10542102,10542105,10604725,10604727,10604734,10604737,10604740,10604746,10639514,10639515,10639521,10662975,10662977,10662984,10662987,10662990,10662996,10726173,10726175,10726182,10726185,10726188,10726194,10758443,10758448,10758450,10796918,10796924,10796927,10796932,10796935,10796937,10876773,10876775,10876782,10876785,10876788,10876794,10919569,10919571,10919578,10919581,10919584,10919590,10964629,10964631,10964638,10964641,10964644,10964650,11015208,11015209,11015215,11015219,11015222,11015228,11036230,11069248,11069249,11069255,11069259,11069262,11069268,11122468,11122473,11122478,11122479,11122486,11122489,11170358,11170363,11170368,11170369,11170376,11170379,11214060,11214065,11214070,11214071,11214078,11214081,11229099,11266764,11266769,11266774,11266775,11266782,11266785,11284034,11322996,11323001,11323006,11323007,11323014,11323017,11374742,11374743,11374749,11374753,11374756,11374762,11418450,11418451,11418457,11418461,11418464,11418470,11464326,11464331,11464336,11464337,11464344,11464347,11513584,11513589,11513594,11513595,11513602,11513605,11531530,11531531,11531537,11531953,11556568,11556569,11556575,11556579,11556582,11556588,11600343,11600348,11600350,11600356,11600359,11600361,11649292,11649293,11649299,11649303,11649306,11649312,11666259,11671366,11671367,11671373,11671377,11671380,11671386,11711129,11739122,11739127,11739129,11739135,11739138,11739140,11756951,11757811,11757816,11757821,11786644,11786649,11786651,11786657,11786660,11786662,11805230,11805235,11805237,11806997,11807246,11807851,11836856,11836861,11836864,11836869,11836872,11836877,11868656,11868661,11868663,11868669,11868672,11868674,11895835,11896665,11896666,11896672,11923680,11923685,11923687,11923693,11923696,11923698,11940866,11940871,11940873,11963808,11963813,11963816,11963821,11963824,11963829,11980416,11980421,11980423,11981351,12004028,12004033,12004036,12004041,12004044,12004049,12021444,12021449,12021452,12045160,12045165,12045168,12045173,12045176,12045181,12061179,12061915,12061920,12061925,12062549,12084356,12084361,12084363,12084369,12084372,12084374,19947,19952,19954,19960,19963,19965,71372,71373,71379,71383,71386,71392,111628,111629,111635,111639,111642,111648,158168,158169,158175,158179,158182,158188,192654,192659,192664,192665,192672,192675,232518,232523,232528,232529,232536,232539,273042,273047,273052,273053,273060,273063,288816,288817,288823,312362,312363,312369,312373,312376,312382,357026,357027,357033,357037,357040,357046) ) 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` = 36097 WHERE `RP`.`player` = 36097 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125207,126392,129065,130312,132009,132004,204136,206130,209574,209663,210931,209752,246867,246872,246874,280515,280517,280524,280527,280530,280536,338377,338379,338386,338389,338392,338398,10398529,10398531,10398538,10398541,10398544,10398550,10479271,10479273,10479280,10479283,10479286,10479292,10542086,10542089,10542092,10542095,10542102,10542105,10604725,10604727,10604734,10604737,10604740,10604746,10639514,10639515,10639521,10662975,10662977,10662984,10662987,10662990,10662996,10726173,10726175,10726182,10726185,10726188,10726194,10758443,10758448,10758450,10796918,10796924,10796927,10796932,10796935,10796937,10876773,10876775,10876782,10876785,10876788,10876794,10919569,10919571,10919578,10919581,10919584,10919590,10964629,10964631,10964638,10964641,10964644,10964650,11015208,11015209,11015215,11015219,11015222,11015228,11036230,11069248,11069249,11069255,11069259,11069262,11069268,11122468,11122473,11122478,11122479,11122486,11122489,11170358,11170363,11170368,11170369,11170376,11170379,11214060,11214065,11214070,11214071,11214078,11214081,11229099,11266764,11266769,11266774,11266775,11266782,11266785,11284034,11322996,11323001,11323006,11323007,11323014,11323017,11374742,11374743,11374749,11374753,11374756,11374762,11418450,11418451,11418457,11418461,11418464,11418470,11464326,11464331,11464336,11464337,11464344,11464347,11513584,11513589,11513594,11513595,11513602,11513605,11531530,11531531,11531537,11531953,11556568,11556569,11556575,11556579,11556582,11556588,11600343,11600348,11600350,11600356,11600359,11600361,11649292,11649293,11649299,11649303,11649306,11649312,11666259,11671366,11671367,11671373,11671377,11671380,11671386,11711129,11739122,11739127,11739129,11739135,11739138,11739140,11756951,11757811,11757816,11757821,11786644,11786649,11786651,11786657,11786660,11786662,11805230,11805235,11805237,11806997,11807246,11807851,11836856,11836861,11836864,11836869,11836872,11836877,11868656,11868661,11868663,11868669,11868672,11868674,11895835,11896665,11896666,11896672,11923680,11923685,11923687,11923693,11923696,11923698,11940866,11940871,11940873,11963808,11963813,11963816,11963821,11963824,11963829,11980416,11980421,11980423,11981351,12004028,12004033,12004036,12004041,12004044,12004049,12021444,12021449,12021452,12045160,12045165,12045168,12045173,12045176,12045181,12061179,12061915,12061920,12061925,12062549,12084356,12084361,12084363,12084369,12084372,12084374,19947,19952,19954,19960,19963,19965,71372,71373,71379,71383,71386,71392,111628,111629,111635,111639,111642,111648,158168,158169,158175,158179,158182,158188,192654,192659,192664,192665,192672,192675,232518,232523,232528,232529,232536,232539,273042,273047,273052,273053,273060,273063,288816,288817,288823,312362,312363,312369,312373,312376,312382,357026,357027,357033,357037,357040,357046) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: