(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(141, 1406) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 83783 WHERE `RP`.`player` = 83783 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107402,107457,122193,123066,123071,123541,123073,123127,122248,124591,215043,213666,213668,235180,235901,249942,259818,259855,261987,262797,264570,265331,278635,281046,281049,283271,283421,299510,299749,300931,300963,301883,301890,301885,301887,303414,303453,337190,338981,342073,342246,345975,346010,371939,372070,373435,373758,10369047,10369117,10370466,10370634,10370695,10387086,10398698,10400784,10401298,10403240,10403733,10406247,10406286,10436766,10436996,10440290,10441494,10441475,10441497,10442209,10442306,10443863,10464612,10465894,10464610,10465984,10481167,10481226,10482779,10483333,10510570,10512461,10512545,10513628,10514234,10514481,10514552,10541172,10541606,10542719,10545731,10568904,10570230,10583937,10602924,10605496,10605970,10608173,10608558,10638130,10640571,10640450,10640839,10640952,10641278,10647966,10647988,10661238,10662554,10664837,10665090,10690522,10692277,10692356,10692393,10692705,10693189,10708465,10708559,10710335,10710948,10727623,10728164,10730042,10730647,10757396,10759151,10760916,10762419,10771526,10772741,10777201,10779673,10780691,10797564,10796313,10797875,10798449,10825247,10826966,10827345,10841115,10842885,10843195,10876149,10893927,10893926,10893935,10894139,10894531,10894733,10895396,10895493,10904448,10904485,10906709,10906736,10920627,10921864,10937147,10938198,10939254,10938187,10939256,10938274,10938472,10939526,10939591,10940741,10941597,10941698,10949041,10964032,10965229,10981516,10983272,10983273,10983275,10985629,10998706,10998710,11015438,11016169,11036429,11036602,11038416,11038417,11038420,11038812,11038822,11038890,11039159,11055655,11056216,11067167,11070790,11072251,11084943,11085824,11085883,11085830,11087337,11087502,11087624,11107129,11108949,11121384,11139884,11140326,11140327,11140371,11141226,11141823,11141992,11157503,11186317,11186886,11186988,11186752,11188300,11188382,11188793,11195111,11196576,11198752,11198830,11213516,11213544,11229212,11229682,11229839,11229778,11230999,11231042,11231954,11232138,11232998,11238794,11238945,11241741,11242246,11243254,11244190,11246803,11246918,11253925,11254080,11268093,11268337,11284054,11284058,11286618,11287826,11303012,11303172,11305457,11305750,11320510,11320870,11337879,11339835,11339838,11339865,11340370,11341337,11341903,11341926,11342676,11342736,11359953,11360452,11361634,11361664,11374409,11376428,11392048,11393027,11393097,11393031,11393100,11393039,11393102,11394306,11394444,11394712,11394794,11394893,11394898,11395354,11395484,11397302,11398323,11416698,11416863,11434067,11436094,11436219,11439988,11440975,11449119,11451466,11449122,11451678,11479184,11481291,11481352,11481289,11481354,11481284,11481356,11481657,11481660,11481815,11481835,11481899,11481909,11494208,11494393,11502095,11502377,11502299,11502093,11514614,11514742,11530215,11531692,11531756,11531733,11532272,11532632,11532850,11538832,11539054,11544903,11556042,11557222,11558914,11573306,11573343,11574970,11574977,11574974,11575637,11575896,11575983,11576040,11576052,11576851,11579192,11579801,11579817,11587322,11587960,11601409,11601746,11601910,11602164,11616947,11619842,11619920,11620226,11620305,11620398,11625122,11625969,11635568,11636101,11637825,11637910,11650250,11650470,11666280,11666295,11667553,11667831,11668081,11668092,11668175,11668259,11678184,11678654,11681363,11682516,11684621,11711146,11711453,11712147,11712149,11737945,11739653,11737943,11739651,11756977,11757079,11758266,11758269,11758819,11758873,11758911,11758965,11759003,11767323,11769377,11769533,11770277,11805568,11805581,11805602,11807007,11807058,11807355,11807466,11807871,11807882,11816946,11817264,11823095,11824303,11823090,11824309,11853870,11854093,11853869,11854067,11853914,11854065,11854437,11854479,11854917,11855118,11855225,11855250,11865456,11866173,11895863,11896088,11904983,11905497,11907771,11908247,11940361,11941153,11941269,11941195,11942617,11942682,11942695,11942751,11942755,11949515,11951283,11963463,11964279,11980384,11980401,11982963,12006107,12006808,12021351,12021395,12021596,12021618,12021621,12021599,12021600,12021622,12022037,12022131,12022399,12022545,12022563,12024197,12024422,12031116,12031157,12033871,12034383,12046153,12046131,12061201,12062999,12065254,12065288,12071087,12071159,12085059,12085976,12101138,12102015,12102017,12102019,12102867,12103561,12103573,12103717,12103730,4338,5064,4335,5066,20872,46520,47135,47448,49920,49830,57498,70753,70831,85638,86178,88926,94178,97497,99353,111111,126222,128663,128777,128878,133720,133725,136184,136749,138445,139098,157369,158824,172835,172879,173762,173757,173760,174511,174591,174851,175402,175479,178052,178961,193414,210128,212900,213181,214357,215515,214180,214777,219819,220097,247372,247551,248342,248343,248346,249120,249237,249830,257501,260281,262003,288156,289818,290164,290603,299088,313340,315684,331831,331838,333587,334649,335007,337951,339234,339824,339826,340558,344403,344442,358158,372401,373808) ) 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(141, 1406) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 83783 WHERE `RP`.`player` = 83783 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107402,107457,122193,123066,123071,123541,123073,123127,122248,124591,215043,213666,213668,235180,235901,249942,259818,259855,261987,262797,264570,265331,278635,281046,281049,283271,283421,299510,299749,300931,300963,301883,301890,301885,301887,303414,303453,337190,338981,342073,342246,345975,346010,371939,372070,373435,373758,10369047,10369117,10370466,10370634,10370695,10387086,10398698,10400784,10401298,10403240,10403733,10406247,10406286,10436766,10436996,10440290,10441494,10441475,10441497,10442209,10442306,10443863,10464612,10465894,10464610,10465984,10481167,10481226,10482779,10483333,10510570,10512461,10512545,10513628,10514234,10514481,10514552,10541172,10541606,10542719,10545731,10568904,10570230,10583937,10602924,10605496,10605970,10608173,10608558,10638130,10640571,10640450,10640839,10640952,10641278,10647966,10647988,10661238,10662554,10664837,10665090,10690522,10692277,10692356,10692393,10692705,10693189,10708465,10708559,10710335,10710948,10727623,10728164,10730042,10730647,10757396,10759151,10760916,10762419,10771526,10772741,10777201,10779673,10780691,10797564,10796313,10797875,10798449,10825247,10826966,10827345,10841115,10842885,10843195,10876149,10893927,10893926,10893935,10894139,10894531,10894733,10895396,10895493,10904448,10904485,10906709,10906736,10920627,10921864,10937147,10938198,10939254,10938187,10939256,10938274,10938472,10939526,10939591,10940741,10941597,10941698,10949041,10964032,10965229,10981516,10983272,10983273,10983275,10985629,10998706,10998710,11015438,11016169,11036429,11036602,11038416,11038417,11038420,11038812,11038822,11038890,11039159,11055655,11056216,11067167,11070790,11072251,11084943,11085824,11085883,11085830,11087337,11087502,11087624,11107129,11108949,11121384,11139884,11140326,11140327,11140371,11141226,11141823,11141992,11157503,11186317,11186886,11186988,11186752,11188300,11188382,11188793,11195111,11196576,11198752,11198830,11213516,11213544,11229212,11229682,11229839,11229778,11230999,11231042,11231954,11232138,11232998,11238794,11238945,11241741,11242246,11243254,11244190,11246803,11246918,11253925,11254080,11268093,11268337,11284054,11284058,11286618,11287826,11303012,11303172,11305457,11305750,11320510,11320870,11337879,11339835,11339838,11339865,11340370,11341337,11341903,11341926,11342676,11342736,11359953,11360452,11361634,11361664,11374409,11376428,11392048,11393027,11393097,11393031,11393100,11393039,11393102,11394306,11394444,11394712,11394794,11394893,11394898,11395354,11395484,11397302,11398323,11416698,11416863,11434067,11436094,11436219,11439988,11440975,11449119,11451466,11449122,11451678,11479184,11481291,11481352,11481289,11481354,11481284,11481356,11481657,11481660,11481815,11481835,11481899,11481909,11494208,11494393,11502095,11502377,11502299,11502093,11514614,11514742,11530215,11531692,11531756,11531733,11532272,11532632,11532850,11538832,11539054,11544903,11556042,11557222,11558914,11573306,11573343,11574970,11574977,11574974,11575637,11575896,11575983,11576040,11576052,11576851,11579192,11579801,11579817,11587322,11587960,11601409,11601746,11601910,11602164,11616947,11619842,11619920,11620226,11620305,11620398,11625122,11625969,11635568,11636101,11637825,11637910,11650250,11650470,11666280,11666295,11667553,11667831,11668081,11668092,11668175,11668259,11678184,11678654,11681363,11682516,11684621,11711146,11711453,11712147,11712149,11737945,11739653,11737943,11739651,11756977,11757079,11758266,11758269,11758819,11758873,11758911,11758965,11759003,11767323,11769377,11769533,11770277,11805568,11805581,11805602,11807007,11807058,11807355,11807466,11807871,11807882,11816946,11817264,11823095,11824303,11823090,11824309,11853870,11854093,11853869,11854067,11853914,11854065,11854437,11854479,11854917,11855118,11855225,11855250,11865456,11866173,11895863,11896088,11904983,11905497,11907771,11908247,11940361,11941153,11941269,11941195,11942617,11942682,11942695,11942751,11942755,11949515,11951283,11963463,11964279,11980384,11980401,11982963,12006107,12006808,12021351,12021395,12021596,12021618,12021621,12021599,12021600,12021622,12022037,12022131,12022399,12022545,12022563,12024197,12024422,12031116,12031157,12033871,12034383,12046153,12046131,12061201,12062999,12065254,12065288,12071087,12071159,12085059,12085976,12101138,12102015,12102017,12102019,12102867,12103561,12103573,12103717,12103730,4338,5064,4335,5066,20872,46520,47135,47448,49920,49830,57498,70753,70831,85638,86178,88926,94178,97497,99353,111111,126222,128663,128777,128878,133720,133725,136184,136749,138445,139098,157369,158824,172835,172879,173762,173757,173760,174511,174591,174851,175402,175479,178052,178961,193414,210128,212900,213181,214357,215515,214180,214777,219819,220097,247372,247551,248342,248343,248346,249120,249237,249830,257501,260281,262003,288156,289818,290164,290603,299088,313340,315684,331831,331838,333587,334649,335007,337951,339234,339824,339826,340558,344403,344442,358158,372401,373808) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: