(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` = 85615 WHERE `RP`.`player` = 85615 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125211,125163,126313,126353,128162,128114,128979,129021,130016,130264,204140,204092,206049,206089,209424,209376,209579,209619,209674,209706,246891,246940,246896,246941,246898,246947,250356,280802,280585,280808,280590,280811,280593,280816,280598,280819,280601,280821,280606,301761,303372,303514,303519,303524,338208,338615,338214,338620,338217,338623,338222,338628,338225,338631,338227,338636,10369071,10398261,10398528,10398263,10398534,10398270,10398537,10398273,10398542,10398276,10398545,10398282,10398547,10441271,10441276,10441278,10479128,10479389,10479131,10479394,10479134,10479397,10479137,10479402,10479144,10479405,10479147,10479410,10513281,10513286,10513289,10542398,10542084,10542401,10542090,10542404,10542093,10542407,10542098,10542414,10542101,10542417,10542103,10604462,10604917,10604465,10604919,10604468,10604926,10604471,10604929,10604478,10604932,10604481,10604938,10637430,10639488,10639574,10639493,10639575,10639498,10639581,10640813,10662832,10663093,10662835,10663098,10662838,10663101,10662841,10663106,10662848,10663109,10662851,10663114,10691441,10691446,10691449,10692384,10726558,10726219,10726561,10726224,10726564,10726227,10726567,10726232,10726574,10726235,10726577,10726240,10758429,10758434,10758437,10760383,10796655,10797061,10796657,10797066,10796664,10797069,10796667,10797074,10796670,10797077,10796676,10797082,10825109,10825098,10826208,10826230,10826209,10826235,10826215,10826240,10876389,10876603,10876391,10876608,10876398,10876611,10876401,10876616,10876404,10876619,10876410,10876624,10919833,10919615,10919835,10919620,10919842,10919623,10919845,10919628,10919848,10919631,10919854,10919636,10938007,10937936,10938012,10937937,10938014,10937943,10939490,10939500,10940489,10941590,10964313,10964555,10964318,10964560,10964321,10964563,10964326,10964568,10964329,10964571,10964334,10964576,10981487,10982967,10982972,10982974,10983335,11014797,11015061,11014802,11015066,11014805,11015069,11014810,11015074,11014813,11015077,11014818,11015082,11036238,11038317,11038322,11038324,11069605,11069223,11069610,11069228,11069613,11069230,11069618,11069236,11069621,11069239,11069626,11069241,11122181,11122446,11122186,11122447,11122188,11122453,11122194,11122457,11122197,11122460,11122199,11122466,11140227,11140232,11140234,11141182,11141799,11141978,11170648,11170407,11170649,11170412,11170655,11170414,11170659,11170420,11170662,11170423,11170668,11170425,11213964,11214229,11213969,11214234,11213974,11214236,11213975,11214242,11213982,11214245,11213985,11214247,11229652,11229653,11229659,11266500,11266812,11266505,11266817,11266510,11266822,11266511,11266823,11266518,11266830,11266521,11266833,11284028,11286094,11286095,11286101,11286606,11323260,11323094,11323265,11323095,11323270,11323101,11323271,11323105,11323278,11323108,11323281,11323114,11374860,11374740,11374865,11374745,11374870,11374750,11374871,11374751,11374878,11374758,11374881,11374761,11391978,11391963,11392968,11392973,11392978,11418714,11418474,11418715,11418475,11418721,11418481,11418725,11418485,11418728,11418488,11418734,11418494,11433503,11434166,11434171,11434176,11464566,11464376,11464571,11464377,11464576,11464383,11464577,11464387,11464584,11464390,11464587,11464396,11513848,11513610,11513853,11513611,11513858,11513617,11513859,11513621,11513866,11513624,11513869,11513630,11556806,11556712,11556811,11556713,11556816,11556719,11556817,11556723,11556824,11556726,11556827,11556732,11573284,11574740,11574766,11574745,11574767,11574750,11574773,11575585,11575588,11575873,11576018,11600536,11600485,11600537,11600490,11600543,11600493,11600547,11600498,11600550,11600501,11600556,11600506,11616924,11618461,11618532,11618466,11618537,11618468,11618542,11619500,11649579,11649219,11649584,11649224,11649586,11649226,11649592,11649232,11649595,11649235,11649597,11649237,11666263,11667086,11667087,11667093,11667361,11668030,11668168,11671726,11671339,11671727,11671344,11671733,11671347,11671737,11671352,11671740,11671355,11671746,11671360,11711974,11711979,11711982,11713172,11739339,11738880,11739340,11738885,11739346,11738888,11739350,11738893,11739353,11738896,11739359,11738901,11756955,11757813,11757814,11757820,11786931,11786690,11786936,11786695,11786941,11786698,11786942,11786703,11786949,11786706,11786952,11786711,11805240,11805245,11805248,11837169,11836904,11837174,11836909,11837179,11836912,11837180,11836917,11837187,11836920,11837190,11836925,11853416,11853421,11853424,11868895,11868654,11868900,11868659,11868905,11868662,11868906,11868667,11868913,11868670,11868916,11868675,11896676,11896681,11896683,11896908,11924159,11923678,11924164,11923683,11924169,11923686,11924170,11923691,11924177,11923694,11924180,11923699,11940005,11940865,11940927,11940870,11940928,11940875,11940934,11964123,11963832,11964124,11963837,11964130,11963840,11964134,11963845,11964137,11963848,11964143,11963853,11980414,11980419,11980422,11981354,11981679,11982827,12004247,12003932,12004248,12003937,12004254,12003940,12004258,12003945,12004261,12003948,12004267,12003953,12021342,12045379,12045280,12045380,12045285,12045386,12045288,12045390,12045293,12045393,12045296,12045399,12045301,12084739,12084522,12084744,12084527,12084749,12084530,12084750,12084535,12084757,12084538,12084760,12084543,12101912,12101917,12101920,20282,19945,20287,19950,20292,19953,20293,19958,20300,19961,20303,19966,48085,48064,48090,48065,48093,48071,48352,48360,48819,49099,71827,71489,71832,71494,71834,71497,71840,71502,71843,71505,71845,71510,86397,86457,86402,86462,86404,86464,87280,87288,87425,87432,87500,87501,111721,111529,111726,111534,111729,111537,111734,111542,111737,111545,111742,111550,127031,127036,127038,128616,158575,158165,158580,158170,158582,158173,158588,158178,158591,158181,158593,158186,192871,192461,192876,192466,192878,192469,192884,192474,192887,192477,192889,192482,210913,210918,210920,232278,232685,232283,232690,232288,232693,232289,232698,232296,232701,232299,232706,273282,273019,273287,273024,273292,273026,273293,273032,273300,273035,273303,273037,312456,312385,312461,312390,312466,312392,312467,312398,312474,312401,312477,312403,333244,333245,333251,333572,334618,334998,357192,356927,357197,356932,357202,356935,357203,356940,357210,356943,357213,356948) ) 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` = 85615 WHERE `RP`.`player` = 85615 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125211,125163,126313,126353,128162,128114,128979,129021,130016,130264,204140,204092,206049,206089,209424,209376,209579,209619,209674,209706,246891,246940,246896,246941,246898,246947,250356,280802,280585,280808,280590,280811,280593,280816,280598,280819,280601,280821,280606,301761,303372,303514,303519,303524,338208,338615,338214,338620,338217,338623,338222,338628,338225,338631,338227,338636,10369071,10398261,10398528,10398263,10398534,10398270,10398537,10398273,10398542,10398276,10398545,10398282,10398547,10441271,10441276,10441278,10479128,10479389,10479131,10479394,10479134,10479397,10479137,10479402,10479144,10479405,10479147,10479410,10513281,10513286,10513289,10542398,10542084,10542401,10542090,10542404,10542093,10542407,10542098,10542414,10542101,10542417,10542103,10604462,10604917,10604465,10604919,10604468,10604926,10604471,10604929,10604478,10604932,10604481,10604938,10637430,10639488,10639574,10639493,10639575,10639498,10639581,10640813,10662832,10663093,10662835,10663098,10662838,10663101,10662841,10663106,10662848,10663109,10662851,10663114,10691441,10691446,10691449,10692384,10726558,10726219,10726561,10726224,10726564,10726227,10726567,10726232,10726574,10726235,10726577,10726240,10758429,10758434,10758437,10760383,10796655,10797061,10796657,10797066,10796664,10797069,10796667,10797074,10796670,10797077,10796676,10797082,10825109,10825098,10826208,10826230,10826209,10826235,10826215,10826240,10876389,10876603,10876391,10876608,10876398,10876611,10876401,10876616,10876404,10876619,10876410,10876624,10919833,10919615,10919835,10919620,10919842,10919623,10919845,10919628,10919848,10919631,10919854,10919636,10938007,10937936,10938012,10937937,10938014,10937943,10939490,10939500,10940489,10941590,10964313,10964555,10964318,10964560,10964321,10964563,10964326,10964568,10964329,10964571,10964334,10964576,10981487,10982967,10982972,10982974,10983335,11014797,11015061,11014802,11015066,11014805,11015069,11014810,11015074,11014813,11015077,11014818,11015082,11036238,11038317,11038322,11038324,11069605,11069223,11069610,11069228,11069613,11069230,11069618,11069236,11069621,11069239,11069626,11069241,11122181,11122446,11122186,11122447,11122188,11122453,11122194,11122457,11122197,11122460,11122199,11122466,11140227,11140232,11140234,11141182,11141799,11141978,11170648,11170407,11170649,11170412,11170655,11170414,11170659,11170420,11170662,11170423,11170668,11170425,11213964,11214229,11213969,11214234,11213974,11214236,11213975,11214242,11213982,11214245,11213985,11214247,11229652,11229653,11229659,11266500,11266812,11266505,11266817,11266510,11266822,11266511,11266823,11266518,11266830,11266521,11266833,11284028,11286094,11286095,11286101,11286606,11323260,11323094,11323265,11323095,11323270,11323101,11323271,11323105,11323278,11323108,11323281,11323114,11374860,11374740,11374865,11374745,11374870,11374750,11374871,11374751,11374878,11374758,11374881,11374761,11391978,11391963,11392968,11392973,11392978,11418714,11418474,11418715,11418475,11418721,11418481,11418725,11418485,11418728,11418488,11418734,11418494,11433503,11434166,11434171,11434176,11464566,11464376,11464571,11464377,11464576,11464383,11464577,11464387,11464584,11464390,11464587,11464396,11513848,11513610,11513853,11513611,11513858,11513617,11513859,11513621,11513866,11513624,11513869,11513630,11556806,11556712,11556811,11556713,11556816,11556719,11556817,11556723,11556824,11556726,11556827,11556732,11573284,11574740,11574766,11574745,11574767,11574750,11574773,11575585,11575588,11575873,11576018,11600536,11600485,11600537,11600490,11600543,11600493,11600547,11600498,11600550,11600501,11600556,11600506,11616924,11618461,11618532,11618466,11618537,11618468,11618542,11619500,11649579,11649219,11649584,11649224,11649586,11649226,11649592,11649232,11649595,11649235,11649597,11649237,11666263,11667086,11667087,11667093,11667361,11668030,11668168,11671726,11671339,11671727,11671344,11671733,11671347,11671737,11671352,11671740,11671355,11671746,11671360,11711974,11711979,11711982,11713172,11739339,11738880,11739340,11738885,11739346,11738888,11739350,11738893,11739353,11738896,11739359,11738901,11756955,11757813,11757814,11757820,11786931,11786690,11786936,11786695,11786941,11786698,11786942,11786703,11786949,11786706,11786952,11786711,11805240,11805245,11805248,11837169,11836904,11837174,11836909,11837179,11836912,11837180,11836917,11837187,11836920,11837190,11836925,11853416,11853421,11853424,11868895,11868654,11868900,11868659,11868905,11868662,11868906,11868667,11868913,11868670,11868916,11868675,11896676,11896681,11896683,11896908,11924159,11923678,11924164,11923683,11924169,11923686,11924170,11923691,11924177,11923694,11924180,11923699,11940005,11940865,11940927,11940870,11940928,11940875,11940934,11964123,11963832,11964124,11963837,11964130,11963840,11964134,11963845,11964137,11963848,11964143,11963853,11980414,11980419,11980422,11981354,11981679,11982827,12004247,12003932,12004248,12003937,12004254,12003940,12004258,12003945,12004261,12003948,12004267,12003953,12021342,12045379,12045280,12045380,12045285,12045386,12045288,12045390,12045293,12045393,12045296,12045399,12045301,12084739,12084522,12084744,12084527,12084749,12084530,12084750,12084535,12084757,12084538,12084760,12084543,12101912,12101917,12101920,20282,19945,20287,19950,20292,19953,20293,19958,20300,19961,20303,19966,48085,48064,48090,48065,48093,48071,48352,48360,48819,49099,71827,71489,71832,71494,71834,71497,71840,71502,71843,71505,71845,71510,86397,86457,86402,86462,86404,86464,87280,87288,87425,87432,87500,87501,111721,111529,111726,111534,111729,111537,111734,111542,111737,111545,111742,111550,127031,127036,127038,128616,158575,158165,158580,158170,158582,158173,158588,158178,158591,158181,158593,158186,192871,192461,192876,192466,192878,192469,192884,192474,192887,192477,192889,192482,210913,210918,210920,232278,232685,232283,232690,232288,232693,232289,232698,232296,232701,232299,232706,273282,273019,273287,273024,273292,273026,273293,273032,273300,273035,273303,273037,312456,312385,312461,312390,312466,312392,312467,312398,312474,312401,312477,312403,333244,333245,333251,333572,334618,334998,357192,356927,357197,356932,357202,356935,357203,356940,357210,356943,357213,356948) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: