(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, 140, 207, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 55027 WHERE `RP`.`player` = 55027 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125218,125170,126317,126361,128120,128989,129027,130010,130273,130650,204101,204149,206053,206097,209382,209585,209625,210910,209668,209713,246952,246953,246959,250362,250965,251096,280801,280465,280806,280470,280809,280473,280814,280478,280817,280481,280822,280486,303573,303578,303581,338111,338520,338116,338526,338119,338529,338124,338534,338127,338537,338132,338539,10370771,10370776,10370778,10371780,10398139,10398503,10398144,10398508,10398147,10398511,10398152,10398516,10398155,10398519,10398160,10398524,10479102,10479367,10479108,10479369,10479111,10479376,10479116,10479379,10479119,10479382,10479121,10479388,10513329,10513334,10513337,10514095,10542251,10541966,10542256,10541969,10542259,10541972,10542264,10541975,10542267,10541982,10542272,10541985,10567342,10604411,10604893,10604416,10604895,10604419,10604902,10604424,10604905,10604427,10604908,10604432,10604914,10637418,10637426,10639524,10639562,10639529,10639563,10639534,10639569,10640819,10640807,10662853,10663141,10662858,10663146,10662861,10663149,10662866,10663154,10662869,10663157,10662874,10663162,10691381,10691386,10691389,10692375,10692491,10693163,10726435,10726243,10726440,10726248,10726443,10726251,10726448,10726256,10726451,10726259,10726456,10726264,10758407,10758412,10758414,10760381,10796725,10797013,10796730,10797018,10796733,10797021,10796738,10797026,10796741,10797029,10796746,10797034,10826217,10826268,10826222,10826269,10826225,10826275,10826539,10826547,10826632,10827308,10876411,10876579,10876416,10876584,10876419,10876587,10876424,10876592,10876427,10876595,10876432,10876600,10892866,10893721,10893748,10893726,10893749,10893729,10893755,10893995,10894523,10895367,10919903,10919735,10919908,10919740,10919911,10919743,10919916,10919748,10919919,10919751,10919924,10919756,10938017,10938022,10938025,10939491,10940485,10941594,10964337,10964459,10964342,10964464,10964345,10964467,10964350,10964472,10964353,10964475,10964358,10964480,10981502,10982941,10982992,10982946,10982993,10982949,10982999,10983326,10983334,10984027,10985553,11014701,11015109,11014706,11015114,11014709,11015117,11014714,11015122,11014717,11015125,11014722,11015130,11036244,11036233,11038342,11038343,11038349,11069487,11069293,11069492,11069298,11069494,11069301,11069500,11069306,11069503,11069309,11069505,11069314,11084869,11085735,11085740,11085743,11122155,11122371,11122160,11122376,11122163,11122379,11122168,11122384,11122171,11122387,11122176,11122392,11140288,11140289,11140295,11141171,11170621,11170453,11170626,11170458,11170629,11170461,11170634,11170466,11170637,11170469,11170642,11170474,11186266,11186601,11186648,11186606,11186653,11186608,11186658,11213963,11214107,11213968,11214112,11213971,11214115,11213976,11214120,11213979,11214123,11213984,11214128,11266525,11266907,11266530,11266912,11266532,11266915,11266538,11266920,11266541,11266923,11266543,11266928,11284035,11286165,11286170,11286172,11323285,11322947,11323290,11322952,11323292,11322955,11323298,11322960,11323301,11322963,11323303,11322968,11339775,11339780,11339782,11374982,11374691,11374983,11374696,11374989,11374699,11374993,11374704,11374996,11374707,11375002,11374712,11391972,11391966,11392958,11392959,11392965,11418786,11418447,11418787,11418452,11418793,11418455,11418797,11418460,11418800,11418463,11418806,11418468,11464688,11464471,11464689,11464476,11464695,11464478,11464699,11464484,11464702,11464487,11464708,11464489,11481163,11481168,11481170,11481627,11513896,11513583,11513901,11513588,11513906,11513591,11513907,11513596,11513914,11513599,11513917,11513604,11530204,11531576,11531581,11531586,11556998,11556759,11557003,11556764,11557008,11556766,11557009,11556772,11557016,11556775,11557019,11556777,11574705,11574710,11574712,11575579,11575876,11576017,11600558,11600269,11600563,11600274,11600568,11600277,11600569,11600282,11600576,11600285,11600579,11600290,11618459,11618464,11618467,11619488,11620216,11620373,11649626,11649193,11649631,11649198,11649636,11649201,11649637,11649206,11649644,11649209,11649647,11649214,11667095,11667134,11667100,11667135,11667103,11667141,11671725,11671219,11671730,11671224,11671732,11671227,11671738,11671232,11671741,11671235,11671743,11671240,11739145,11738904,11739150,11738909,11739155,11738912,11739156,11738917,11739163,11738920,11739166,11738925,11756949,11786979,11786738,11786984,11786743,11786989,11786746,11786990,11786751,11786997,11786754,11787000,11786759,11837217,11836906,11837222,11836911,11837227,11836913,11837228,11836919,11837235,11836922,11837238,11836924,11852592,11868919,11868704,11868924,11868709,11868929,11868711,11868930,11868717,11868937,11868720,11868940,11868722,11895843,11896675,11896680,11896685,11924183,11923848,11924188,11923853,11924193,11923855,11924194,11923861,11924201,11923864,11924204,11923866,11940843,11940844,11940850,11964241,11963762,11964246,11963767,11963769,11964251,11964252,11963775,11964259,11963778,11964262,11963780,12004173,12004054,12004178,12004059,12004183,12004061,12004184,12004067,12004191,12004070,12004194,12004072,12021327,12021482,12021487,12021489,12045618,12045235,12045623,12045236,12045625,12045242,12045631,12045246,12045634,12045249,12045636,12045255,12084811,12084573,12084816,12084574,12084821,12084580,12084822,12084584,12084829,12084587,12084832,12084593,12101103,12101913,12101963,12101918,12101964,12101923,12101970,12102548,12103520,12103696,20116,19921,20117,19926,20123,19929,20127,19934,20130,19937,20136,19942,71660,71561,71661,71566,71667,71569,71671,71574,71674,71577,71680,71582,85608,111868,111411,111869,111416,111875,111418,111879,111424,111882,111427,111888,111429,126206,127042,127047,127052,158431,158336,158436,158337,158438,158343,158444,158347,158447,158350,158449,158356,172818,192798,192680,192803,192681,192808,192687,192809,192691,192816,192694,192819,192700,210106,210984,210989,210994,232304,232664,232305,232665,232311,232671,232315,232675,232318,232678,232324,232684,247349,248200,248205,248210,249075,249213,249768,273233,273116,273238,273117,273241,273123,273246,273127,273249,273130,273254,273136,288803,288808,288810,289790,290017,290580,312649,312287,312654,312292,312656,312295,312662,312300,312665,312303,312667,312308,331804,333217,333222,333225,333567,357217,356999,357222,357004,357224,357007,357230,357012,357233,357015,357235,357020,372006,372807,372844,372812,372849,372815,372854,373741) ) 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, 140, 207, 208) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 55027 WHERE `RP`.`player` = 55027 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125218,125170,126317,126361,128120,128989,129027,130010,130273,130650,204101,204149,206053,206097,209382,209585,209625,210910,209668,209713,246952,246953,246959,250362,250965,251096,280801,280465,280806,280470,280809,280473,280814,280478,280817,280481,280822,280486,303573,303578,303581,338111,338520,338116,338526,338119,338529,338124,338534,338127,338537,338132,338539,10370771,10370776,10370778,10371780,10398139,10398503,10398144,10398508,10398147,10398511,10398152,10398516,10398155,10398519,10398160,10398524,10479102,10479367,10479108,10479369,10479111,10479376,10479116,10479379,10479119,10479382,10479121,10479388,10513329,10513334,10513337,10514095,10542251,10541966,10542256,10541969,10542259,10541972,10542264,10541975,10542267,10541982,10542272,10541985,10567342,10604411,10604893,10604416,10604895,10604419,10604902,10604424,10604905,10604427,10604908,10604432,10604914,10637418,10637426,10639524,10639562,10639529,10639563,10639534,10639569,10640819,10640807,10662853,10663141,10662858,10663146,10662861,10663149,10662866,10663154,10662869,10663157,10662874,10663162,10691381,10691386,10691389,10692375,10692491,10693163,10726435,10726243,10726440,10726248,10726443,10726251,10726448,10726256,10726451,10726259,10726456,10726264,10758407,10758412,10758414,10760381,10796725,10797013,10796730,10797018,10796733,10797021,10796738,10797026,10796741,10797029,10796746,10797034,10826217,10826268,10826222,10826269,10826225,10826275,10826539,10826547,10826632,10827308,10876411,10876579,10876416,10876584,10876419,10876587,10876424,10876592,10876427,10876595,10876432,10876600,10892866,10893721,10893748,10893726,10893749,10893729,10893755,10893995,10894523,10895367,10919903,10919735,10919908,10919740,10919911,10919743,10919916,10919748,10919919,10919751,10919924,10919756,10938017,10938022,10938025,10939491,10940485,10941594,10964337,10964459,10964342,10964464,10964345,10964467,10964350,10964472,10964353,10964475,10964358,10964480,10981502,10982941,10982992,10982946,10982993,10982949,10982999,10983326,10983334,10984027,10985553,11014701,11015109,11014706,11015114,11014709,11015117,11014714,11015122,11014717,11015125,11014722,11015130,11036244,11036233,11038342,11038343,11038349,11069487,11069293,11069492,11069298,11069494,11069301,11069500,11069306,11069503,11069309,11069505,11069314,11084869,11085735,11085740,11085743,11122155,11122371,11122160,11122376,11122163,11122379,11122168,11122384,11122171,11122387,11122176,11122392,11140288,11140289,11140295,11141171,11170621,11170453,11170626,11170458,11170629,11170461,11170634,11170466,11170637,11170469,11170642,11170474,11186266,11186601,11186648,11186606,11186653,11186608,11186658,11213963,11214107,11213968,11214112,11213971,11214115,11213976,11214120,11213979,11214123,11213984,11214128,11266525,11266907,11266530,11266912,11266532,11266915,11266538,11266920,11266541,11266923,11266543,11266928,11284035,11286165,11286170,11286172,11323285,11322947,11323290,11322952,11323292,11322955,11323298,11322960,11323301,11322963,11323303,11322968,11339775,11339780,11339782,11374982,11374691,11374983,11374696,11374989,11374699,11374993,11374704,11374996,11374707,11375002,11374712,11391972,11391966,11392958,11392959,11392965,11418786,11418447,11418787,11418452,11418793,11418455,11418797,11418460,11418800,11418463,11418806,11418468,11464688,11464471,11464689,11464476,11464695,11464478,11464699,11464484,11464702,11464487,11464708,11464489,11481163,11481168,11481170,11481627,11513896,11513583,11513901,11513588,11513906,11513591,11513907,11513596,11513914,11513599,11513917,11513604,11530204,11531576,11531581,11531586,11556998,11556759,11557003,11556764,11557008,11556766,11557009,11556772,11557016,11556775,11557019,11556777,11574705,11574710,11574712,11575579,11575876,11576017,11600558,11600269,11600563,11600274,11600568,11600277,11600569,11600282,11600576,11600285,11600579,11600290,11618459,11618464,11618467,11619488,11620216,11620373,11649626,11649193,11649631,11649198,11649636,11649201,11649637,11649206,11649644,11649209,11649647,11649214,11667095,11667134,11667100,11667135,11667103,11667141,11671725,11671219,11671730,11671224,11671732,11671227,11671738,11671232,11671741,11671235,11671743,11671240,11739145,11738904,11739150,11738909,11739155,11738912,11739156,11738917,11739163,11738920,11739166,11738925,11756949,11786979,11786738,11786984,11786743,11786989,11786746,11786990,11786751,11786997,11786754,11787000,11786759,11837217,11836906,11837222,11836911,11837227,11836913,11837228,11836919,11837235,11836922,11837238,11836924,11852592,11868919,11868704,11868924,11868709,11868929,11868711,11868930,11868717,11868937,11868720,11868940,11868722,11895843,11896675,11896680,11896685,11924183,11923848,11924188,11923853,11924193,11923855,11924194,11923861,11924201,11923864,11924204,11923866,11940843,11940844,11940850,11964241,11963762,11964246,11963767,11963769,11964251,11964252,11963775,11964259,11963778,11964262,11963780,12004173,12004054,12004178,12004059,12004183,12004061,12004184,12004067,12004191,12004070,12004194,12004072,12021327,12021482,12021487,12021489,12045618,12045235,12045623,12045236,12045625,12045242,12045631,12045246,12045634,12045249,12045636,12045255,12084811,12084573,12084816,12084574,12084821,12084580,12084822,12084584,12084829,12084587,12084832,12084593,12101103,12101913,12101963,12101918,12101964,12101923,12101970,12102548,12103520,12103696,20116,19921,20117,19926,20123,19929,20127,19934,20130,19937,20136,19942,71660,71561,71661,71566,71667,71569,71671,71574,71674,71577,71680,71582,85608,111868,111411,111869,111416,111875,111418,111879,111424,111882,111427,111888,111429,126206,127042,127047,127052,158431,158336,158436,158337,158438,158343,158444,158347,158447,158350,158449,158356,172818,192798,192680,192803,192681,192808,192687,192809,192691,192816,192694,192819,192700,210106,210984,210989,210994,232304,232664,232305,232665,232311,232671,232315,232675,232318,232678,232324,232684,247349,248200,248205,248210,249075,249213,249768,273233,273116,273238,273117,273241,273123,273246,273127,273249,273130,273254,273136,288803,288808,288810,289790,290017,290580,312649,312287,312654,312292,312656,312295,312662,312300,312665,312303,312667,312308,331804,333217,333222,333225,333567,357217,356999,357222,357004,357224,357007,357230,357012,357233,357015,357235,357020,372006,372807,372844,372812,372849,372815,372854,373741) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: