(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` = 37529 WHERE `RP`.`player` = 37529 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125212,125164,126315,126355,128164,128116,128978,129020,130019,130267,204143,204095,206051,206091,209426,209378,209580,209620,209675,209707,280899,280707,280901,280709,280908,280716,280911,280719,280914,280722,280920,280728,301755,303371,338305,338449,338307,338451,338314,338458,338317,338461,338320,338464,338326,338470,10398309,10398601,10398311,10398603,10398318,10398610,10398321,10398613,10398324,10398616,10398330,10398622,10441187,10441192,10441194,10442084,10479174,10479295,10479180,10479297,10479183,10479304,10479188,10479307,10479191,10479310,10479193,10479316,10542326,10542110,10542329,10542113,10542332,10542116,10542335,10542119,10542342,10542126,10542345,10542129,10604581,10604726,10604583,10604729,10604590,10604732,10604593,10604735,10604596,10604742,10604602,10604745,10662903,10663072,10662905,10663075,10662912,10663078,10662915,10663081,10662918,10663088,10662924,10663091,10691444,10691445,10691451,10726390,10726342,10726393,10726345,10726396,10726348,10726399,10726351,10726406,10726358,10726409,10726361,10796775,10796943,10796777,10796945,10796784,10796952,10796787,10796955,10796790,10796958,10796796,10796964,10825095,10826182,10826187,10826192,10876509,10876557,10876511,10876559,10876518,10876566,10876521,10876569,10876524,10876572,10876530,10876578,10892869,10919977,10919617,10919979,10919619,10919986,10919626,10919989,10919629,10919992,10919632,10919998,10919638,10936981,10937946,10937951,10937956,10939494,10940492,10941591,10964338,10964678,10964344,10964681,10964347,10964684,10964352,10964687,10964355,10964694,10964357,10964697,10982991,10982996,10982998,11014845,11015064,11014850,11015065,11014853,11015071,11014858,11015075,11014861,11015078,11014866,11015084,11038303,11038308,11038311,11069632,11069462,11069633,11069467,11069639,11069472,11069643,11069473,11069646,11069480,11069652,11069483,11122134,11122300,11122135,11122305,11122141,11122310,11122145,11122311,11122148,11122318,11122154,11122321,11139733,11140228,11140286,11140229,11140291,11140235,11140296,11170600,11170408,11170601,11170409,11170607,11170415,11170611,11170419,11170614,11170422,11170620,11170428,11186273,11213870,11214013,11213871,11214018,11213877,11214020,11213881,11214026,11213884,11214029,11213890,11214031,11266596,11266934,11266601,11266935,11266606,11266941,11266607,11266945,11266614,11266948,11266617,11266954,11286166,11286118,11286167,11286119,11286173,11286125,11286593,11323358,11323117,11323359,11323122,11323365,11323124,11323369,11323130,11323372,11323133,11323378,11323135,11374790,11374693,11374791,11374698,11374797,11374700,11374801,11374706,11374804,11374709,11374810,11374711,11418690,11418282,11418691,11418283,11418697,11418289,11418701,11418293,11418704,11418296,11418710,11418302,11464784,11464496,11464785,11464497,11464791,11464503,11464795,11464507,11464798,11464510,11464804,11464516,11479170,11513850,11513536,11513851,11513541,11513857,11513546,11513861,11513547,11513864,11513554,11513870,11513557,11556950,11556782,11556955,11556787,11556960,11556792,11556961,11556793,11556968,11556800,11556971,11556803,11600654,11600294,11600659,11600299,11600664,11600304,11600665,11600305,11600672,11600312,11600675,11600315,11649530,11649194,11649535,11649199,11649540,11649204,11649541,11649205,11649548,11649212,11649551,11649215,11671676,11671412,11671681,11671417,11671686,11671422,11671687,11671423,11671694,11671430,11671697,11671433,11711989,11711990,11711996,11739363,11739121,11739364,11739126,11739370,11739131,11739374,11739132,11739377,11739139,11739383,11739142,11757838,11757844,11757837,11787028,11786715,11787033,11786720,11787035,11786725,11787041,11786726,11787044,11786733,11787046,11786736,11837026,11836977,11837031,11836982,11837033,11836987,11837039,11836988,11837042,11836995,11837044,11836998,11869065,11868583,11869066,11868588,11869072,11868593,11869076,11868594,11869079,11868601,11869085,11868604,11923993,11923871,11923994,11923876,11924000,11923881,11924004,11923882,11924007,11923889,11924013,11923892,11940017,11940889,11940894,11940899,11964169,11963977,11964174,11963982,11964179,11963987,11964180,11963988,11964187,11963995,11964190,11963998,12004221,12004125,12004226,12004130,12004231,12004135,12004232,12004136,12004239,12004143,12004242,12004146,12021411,12021412,12021418,12045593,12045209,12045598,12045214,12045603,12045219,12045604,12045220,12045611,12045227,12045614,12045230,12061989,12061990,12061996,12084765,12084427,12084766,12084432,12084772,12084437,12084776,12084438,12084779,12084445,12084785,12084448,12101950,12101955,12101957,20115,19946,20120,19951,20122,19956,20128,19957,20131,19964,20133,19967,71683,71562,71688,71567,71690,71572,71696,71573,71699,71580,71701,71583,86458,86459,86465,111772,111434,111773,111439,111779,111444,111445,111783,111786,111452,111792,111455,126200,158408,158214,158409,158219,158415,158224,158419,158225,158422,158232,158428,158235,192968,192534,192969,192539,192975,192544,192979,192545,192982,192552,192988,192555,232326,232614,232331,232619,232336,232624,232337,232625,232344,232632,232347,232635,273332,273090,273333,273095,273339,273100,273343,273101,273346,273108,273352,273111,288864,288865,288871,289792,312506,312216,312507,312221,312513,312226,312517,312227,312520,312234,312526,312237,331800,333265,333270,333273,357359,357122,357364,357123,357367,357129,357372,357133,357375,357136,357380,357142,372810,372833,372811,372838,372817,372840,373738,374297,374531) ) 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` = 37529 WHERE `RP`.`player` = 37529 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125212,125164,126315,126355,128164,128116,128978,129020,130019,130267,204143,204095,206051,206091,209426,209378,209580,209620,209675,209707,280899,280707,280901,280709,280908,280716,280911,280719,280914,280722,280920,280728,301755,303371,338305,338449,338307,338451,338314,338458,338317,338461,338320,338464,338326,338470,10398309,10398601,10398311,10398603,10398318,10398610,10398321,10398613,10398324,10398616,10398330,10398622,10441187,10441192,10441194,10442084,10479174,10479295,10479180,10479297,10479183,10479304,10479188,10479307,10479191,10479310,10479193,10479316,10542326,10542110,10542329,10542113,10542332,10542116,10542335,10542119,10542342,10542126,10542345,10542129,10604581,10604726,10604583,10604729,10604590,10604732,10604593,10604735,10604596,10604742,10604602,10604745,10662903,10663072,10662905,10663075,10662912,10663078,10662915,10663081,10662918,10663088,10662924,10663091,10691444,10691445,10691451,10726390,10726342,10726393,10726345,10726396,10726348,10726399,10726351,10726406,10726358,10726409,10726361,10796775,10796943,10796777,10796945,10796784,10796952,10796787,10796955,10796790,10796958,10796796,10796964,10825095,10826182,10826187,10826192,10876509,10876557,10876511,10876559,10876518,10876566,10876521,10876569,10876524,10876572,10876530,10876578,10892869,10919977,10919617,10919979,10919619,10919986,10919626,10919989,10919629,10919992,10919632,10919998,10919638,10936981,10937946,10937951,10937956,10939494,10940492,10941591,10964338,10964678,10964344,10964681,10964347,10964684,10964352,10964687,10964355,10964694,10964357,10964697,10982991,10982996,10982998,11014845,11015064,11014850,11015065,11014853,11015071,11014858,11015075,11014861,11015078,11014866,11015084,11038303,11038308,11038311,11069632,11069462,11069633,11069467,11069639,11069472,11069643,11069473,11069646,11069480,11069652,11069483,11122134,11122300,11122135,11122305,11122141,11122310,11122145,11122311,11122148,11122318,11122154,11122321,11139733,11140228,11140286,11140229,11140291,11140235,11140296,11170600,11170408,11170601,11170409,11170607,11170415,11170611,11170419,11170614,11170422,11170620,11170428,11186273,11213870,11214013,11213871,11214018,11213877,11214020,11213881,11214026,11213884,11214029,11213890,11214031,11266596,11266934,11266601,11266935,11266606,11266941,11266607,11266945,11266614,11266948,11266617,11266954,11286166,11286118,11286167,11286119,11286173,11286125,11286593,11323358,11323117,11323359,11323122,11323365,11323124,11323369,11323130,11323372,11323133,11323378,11323135,11374790,11374693,11374791,11374698,11374797,11374700,11374801,11374706,11374804,11374709,11374810,11374711,11418690,11418282,11418691,11418283,11418697,11418289,11418701,11418293,11418704,11418296,11418710,11418302,11464784,11464496,11464785,11464497,11464791,11464503,11464795,11464507,11464798,11464510,11464804,11464516,11479170,11513850,11513536,11513851,11513541,11513857,11513546,11513861,11513547,11513864,11513554,11513870,11513557,11556950,11556782,11556955,11556787,11556960,11556792,11556961,11556793,11556968,11556800,11556971,11556803,11600654,11600294,11600659,11600299,11600664,11600304,11600665,11600305,11600672,11600312,11600675,11600315,11649530,11649194,11649535,11649199,11649540,11649204,11649541,11649205,11649548,11649212,11649551,11649215,11671676,11671412,11671681,11671417,11671686,11671422,11671687,11671423,11671694,11671430,11671697,11671433,11711989,11711990,11711996,11739363,11739121,11739364,11739126,11739370,11739131,11739374,11739132,11739377,11739139,11739383,11739142,11757838,11757844,11757837,11787028,11786715,11787033,11786720,11787035,11786725,11787041,11786726,11787044,11786733,11787046,11786736,11837026,11836977,11837031,11836982,11837033,11836987,11837039,11836988,11837042,11836995,11837044,11836998,11869065,11868583,11869066,11868588,11869072,11868593,11869076,11868594,11869079,11868601,11869085,11868604,11923993,11923871,11923994,11923876,11924000,11923881,11924004,11923882,11924007,11923889,11924013,11923892,11940017,11940889,11940894,11940899,11964169,11963977,11964174,11963982,11964179,11963987,11964180,11963988,11964187,11963995,11964190,11963998,12004221,12004125,12004226,12004130,12004231,12004135,12004232,12004136,12004239,12004143,12004242,12004146,12021411,12021412,12021418,12045593,12045209,12045598,12045214,12045603,12045219,12045604,12045220,12045611,12045227,12045614,12045230,12061989,12061990,12061996,12084765,12084427,12084766,12084432,12084772,12084437,12084776,12084438,12084779,12084445,12084785,12084448,12101950,12101955,12101957,20115,19946,20120,19951,20122,19956,20128,19957,20131,19964,20133,19967,71683,71562,71688,71567,71690,71572,71696,71573,71699,71580,71701,71583,86458,86459,86465,111772,111434,111773,111439,111779,111444,111445,111783,111786,111452,111792,111455,126200,158408,158214,158409,158219,158415,158224,158419,158225,158422,158232,158428,158235,192968,192534,192969,192539,192975,192544,192979,192545,192982,192552,192988,192555,232326,232614,232331,232619,232336,232624,232337,232625,232344,232632,232347,232635,273332,273090,273333,273095,273339,273100,273343,273101,273346,273108,273352,273111,288864,288865,288871,289792,312506,312216,312507,312221,312513,312226,312517,312227,312520,312234,312526,312237,331800,333265,333270,333273,357359,357122,357364,357123,357367,357129,357372,357133,357375,357136,357380,357142,372810,372833,372811,372838,372817,372840,373738,374297,374531) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: