(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` = 5013 WHERE `RP`.`player` = 5013 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126369,128130,129036,130283,130657,131990,206105,209392,209560,209636,210915,209721,246889,246894,246897,250353,250961,251092,280705,280710,280713,280718,280721,280726,338423,338428,338431,338436,338439,338444,10370769,10370774,10370777,10371771,10398575,10398580,10398583,10398588,10398591,10398596,10441269,10441274,10441277,10442091,10442243,10443328,10479413,10479418,10479421,10479426,10479429,10479434,10542179,10542184,10542187,10542192,10542195,10542200,10604843,10604848,10604851,10604856,10604859,10604864,10639511,10639516,10639519,10640815,10663021,10663026,10663029,10663034,10663037,10663042,10691429,10691434,10691437,10726147,10726152,10726155,10726160,10726163,10726168,10796894,10796900,10796903,10796908,10796911,10796913,10826183,10826188,10826190,10826533,10826636,10827306,10876627,10876632,10876635,10876640,10876643,10876648,10919544,10919550,10919553,10919558,10919561,10919563,10936990,10964675,10964680,10964683,10964688,10964691,10964696,10981485,10982918,10982923,10982928,11015157,11015162,11015165,11015170,11015173,11015178,11038329,11038334,11038336,11038759,11038880,11038978,11069437,11069442,11069445,11069450,11069453,11069458,11122395,11122400,11122403,11122408,11122411,11122416,11140249,11140254,11140257,11141180,11141800,11141972,11170357,11170362,11170365,11170370,11170373,11170378,11186599,11186604,11186607,11188237,11188364,11188467,11214083,11214088,11214091,11214096,11214099,11214104,11229106,11266763,11266768,11266771,11266776,11266779,11266784,11286151,11286156,11286159,11286592,11323019,11323024,11323027,11323032,11323035,11323040,11339773,11339778,11339781,11374571,11374576,11374579,11374584,11374587,11374592,11392931,11392936,11392939,11394285,11418495,11418500,11418503,11418508,11418511,11418516,11433512,11464469,11464474,11464477,11464482,11464485,11464490,11479153,11481174,11481179,11481184,11513657,11513662,11513664,11513670,11513673,11513675,11530193,11556711,11556716,11556718,11556724,11556727,11556729,11600488,11600489,11600495,11600499,11600502,11600508,11649340,11649341,11649347,11649351,11649354,11649360,11671388,11671393,11671398,11671399,11671406,11671409,11738929,11738934,11738939,11738940,11738947,11738950,11786619,11786624,11786629,11786630,11786637,11786640,11805255,11805256,11805262,11806995,11836858,11836863,11836865,11836871,11836874,11836876,11868681,11868682,11868688,11868692,11868695,11868701,11895840,11896651,11896656,11896661,11896913,11923896,11923901,11923903,11923909,11923912,11923914,11940003,11940841,11940846,11940851,11942508,11963856,11963861,11963864,11963869,11963872,11963877,11980319,11980439,11980444,11980449,11981353,12004004,12004009,12004012,12004017,12004020,12004025,12021420,12021425,12021428,12045184,12045189,12045192,12045197,12045200,12045205,12061914,12061919,12061922,12062552,12062941,12063053,12084378,12084383,12084386,12084391,12084394,12084399,12101890,12101895,12101897,12102553,12103518,12103697,19993,19998,20001,20006,20009,20014,71393,71398,71401,71406,71409,71414,86407,86412,86415,111625,111630,111633,111638,111641,111646,127007,127012,127014,158117,158122,158125,158130,158133,158138,173647,173652,173655,192653,192658,192661,192666,192669,192674,210925,210930,210932,232493,232498,232501,232506,232509,232514,248129,248134,248136,273187,273192,273194,273200,273203,273205,288827,288832,288834,312193,312198,312200,312206,312209,312211,333243,333248,333250,356977,356982,356984,356990,356993,356995,372785,372790,372792) ) 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` = 5013 WHERE `RP`.`player` = 5013 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126369,128130,129036,130283,130657,131990,206105,209392,209560,209636,210915,209721,246889,246894,246897,250353,250961,251092,280705,280710,280713,280718,280721,280726,338423,338428,338431,338436,338439,338444,10370769,10370774,10370777,10371771,10398575,10398580,10398583,10398588,10398591,10398596,10441269,10441274,10441277,10442091,10442243,10443328,10479413,10479418,10479421,10479426,10479429,10479434,10542179,10542184,10542187,10542192,10542195,10542200,10604843,10604848,10604851,10604856,10604859,10604864,10639511,10639516,10639519,10640815,10663021,10663026,10663029,10663034,10663037,10663042,10691429,10691434,10691437,10726147,10726152,10726155,10726160,10726163,10726168,10796894,10796900,10796903,10796908,10796911,10796913,10826183,10826188,10826190,10826533,10826636,10827306,10876627,10876632,10876635,10876640,10876643,10876648,10919544,10919550,10919553,10919558,10919561,10919563,10936990,10964675,10964680,10964683,10964688,10964691,10964696,10981485,10982918,10982923,10982928,11015157,11015162,11015165,11015170,11015173,11015178,11038329,11038334,11038336,11038759,11038880,11038978,11069437,11069442,11069445,11069450,11069453,11069458,11122395,11122400,11122403,11122408,11122411,11122416,11140249,11140254,11140257,11141180,11141800,11141972,11170357,11170362,11170365,11170370,11170373,11170378,11186599,11186604,11186607,11188237,11188364,11188467,11214083,11214088,11214091,11214096,11214099,11214104,11229106,11266763,11266768,11266771,11266776,11266779,11266784,11286151,11286156,11286159,11286592,11323019,11323024,11323027,11323032,11323035,11323040,11339773,11339778,11339781,11374571,11374576,11374579,11374584,11374587,11374592,11392931,11392936,11392939,11394285,11418495,11418500,11418503,11418508,11418511,11418516,11433512,11464469,11464474,11464477,11464482,11464485,11464490,11479153,11481174,11481179,11481184,11513657,11513662,11513664,11513670,11513673,11513675,11530193,11556711,11556716,11556718,11556724,11556727,11556729,11600488,11600489,11600495,11600499,11600502,11600508,11649340,11649341,11649347,11649351,11649354,11649360,11671388,11671393,11671398,11671399,11671406,11671409,11738929,11738934,11738939,11738940,11738947,11738950,11786619,11786624,11786629,11786630,11786637,11786640,11805255,11805256,11805262,11806995,11836858,11836863,11836865,11836871,11836874,11836876,11868681,11868682,11868688,11868692,11868695,11868701,11895840,11896651,11896656,11896661,11896913,11923896,11923901,11923903,11923909,11923912,11923914,11940003,11940841,11940846,11940851,11942508,11963856,11963861,11963864,11963869,11963872,11963877,11980319,11980439,11980444,11980449,11981353,12004004,12004009,12004012,12004017,12004020,12004025,12021420,12021425,12021428,12045184,12045189,12045192,12045197,12045200,12045205,12061914,12061919,12061922,12062552,12062941,12063053,12084378,12084383,12084386,12084391,12084394,12084399,12101890,12101895,12101897,12102553,12103518,12103697,19993,19998,20001,20006,20009,20014,71393,71398,71401,71406,71409,71414,86407,86412,86415,111625,111630,111633,111638,111641,111646,127007,127012,127014,158117,158122,158125,158130,158133,158138,173647,173652,173655,192653,192658,192661,192666,192669,192674,210925,210930,210932,232493,232498,232501,232506,232509,232514,248129,248134,248136,273187,273192,273194,273200,273203,273205,288827,288832,288834,312193,312198,312200,312206,312209,312211,333243,333248,333250,356977,356982,356984,356990,356993,356995,372785,372790,372792) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: