(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` = 11998 WHERE `RP`.`player` = 11998 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107430,107580,122627,123160,123163,123145,124258,123164,124263,212738,214342,212854,214043,212726,214343,235397,235400,246477,246729,247480,247550,257435,257661,259650,261984,262901,265230,277030,277604,280998,281156,283330,283368,299305,300921,301910,303459,337090,337225,342012,342038,345695,345897,360774,371959,373503,373596,10368507,10368643,10369910,10369970,10370659,10370675,10386430,10387239,10399649,10401407,10402890,10403501,10406416,10407384,10436930,10440342,10440367,10441420,10441483,10441454,10442098,10464044,10465535,10464046,10465514,10481185,10481299,10483350,10483524,10510439,10510457,10512516,10513618,10513886,10513654,10514248,10514298,10514480,10541086,10541284,10545490,10545492,10567945,10568995,10570184,10602844,10603249,10605285,10605611,10608185,10608708,10637857,10641001,10641063,10647737,10661553,10662419,10665101,10665089,10690433,10690523,10692052,10692069,10692054,10692426,10692595,10692655,10693226,10693253,10708157,10708437,10710164,10710182,10727624,10727870,10729980,10730053,10757480,10757501,10758570,10758567,10759304,10758577,10760148,10760511,10760588,10760924,10762073,10762254,10771023,10771323,10772474,10774615,10777255,10778912,10779283,10779292,10795208,10797124,10798519,10798620,10825259,10826347,10826473,10826335,10826472,10826338,10826475,10826569,10826614,10826664,10826727,10827332,10827713,10839286,10839462,10840931,10841263,10842831,10892886,10892903,10893831,10893943,10893845,10893942,10893828,10893939,10894077,10894456,10894549,10894637,10895384,10895468,10904724,10905716,10906592,10906783,10920968,10921927,10937334,10937589,10939574,10939594,10940817,10941677,10949575,10964773,10963267,10981542,10981544,10983185,10983070,10983178,10983868,10984048,10984049,10985624,10986176,10999084,10999853,11015754,11015990,11036269,11036788,11038392,11038559,11038387,11038556,11038386,11038561,11038804,11038869,11038934,11038956,11039241,11039596,11055630,11056215,11067859,11067872,11070828,11070835,11084984,11085325,11086024,11086025,11086028,11087221,11087293,11087527,11087558,11087626,11088859,11107239,11107863,11108838,11109009,11121494,11121526,11139798,11140813,11140815,11140817,11141719,11141890,11141893,11141993,11142011,11158075,11158189,11186347,11186404,11187415,11187337,11187304,11188258,11188407,11188754,11195634,11196007,11198714,11198859,11213521,11214606,11229188,11229201,11230103,11230270,11230132,11230453,11230085,11230452,11230843,11230883,11231946,11232196,11232757,11232797,11238316,11238437,11240917,11242852,11243190,11243212,11246798,11246829,11253484,11254407,11267988,11269155,11284077,11284088,11286195,11286372,11286194,11286278,11286215,11286403,11286626,11286634,11286784,11287357,11287960,11288067,11303066,11303137,11305364,11305397,11321715,11339896,11339936,11339894,11339937,11339899,11339934,11340433,11341467,11341489,11342145,11343156,11343422,11360200,11360646,11361659,11374175,11374471,11376064,11393041,11393032,11393030,11394418,11394567,11394726,11394807,11394913,11394954,11395240,11395386,11396863,11397736,11416758,11418973,11433544,11434407,11434411,11434403,11434406,11434398,11434436,11436143,11436309,11436307,11440053,11441247,11452622,11452824,11452961,11452827,11479219,11479222,11481273,11481426,11481276,11481424,11481257,11481422,11481664,11481758,11481809,11481854,11481928,11481932,11494353,11496100,11501307,11501368,11513341,11514693,11514884,11530213,11530231,11531663,11531810,11531648,11531866,11531673,11531923,11532164,11532242,11532630,11532643,11533029,11533190,11538468,11538829,11544670,11557095,11557572,11558783,11573336,11573339,11574931,11574937,11574953,11575629,11575638,11575926,11575944,11576041,11576043,11576877,11577287,11580126,11580390,11587511,11588851,11601356,11601647,11602358,11602410,11616938,11616968,11619065,11619110,11619107,11619741,11619752,11620267,11620274,11620381,11620423,11625815,11626006,11634892,11635201,11637269,11637960,11649885,11650737,11666599,11666964,11667179,11667254,11667176,11667256,11667177,11667251,11667378,11667807,11668054,11668088,11668217,11668235,11678257,11678287,11680024,11680026,11683486,11683994,11711182,11711452,11712095,11712195,11712148,11712193,11712121,11712196,11713350,11713409,11713668,11713672,11713773,11713822,11738030,11739577,11739600,11739452,11756969,11756981,11757911,11757944,11758267,11757943,11758268,11758756,11758786,11758899,11758934,11758985,11758993,11767186,11769337,11770031,11770743,11807065,11807287,11807308,11807916,11807933,11817411,11817474,11823688,11823842,11823607,11823869,11852606,11852630,11853965,11853956,11853915,11854453,11854446,11854692,11854907,11855224,11855252,11865241,11865531,11896076,11896285,11896797,11896798,11896801,11896926,11896942,11896992,11897011,11897059,11897076,11904584,11905416,11907463,11908371,11940775,11941730,11941733,11942281,11942520,11942699,11942734,11942762,11949688,11949693,11963426,11966711,11980346,11980583,11980608,11980605,11981364,11981927,11982838,11982989,11983057,12006080,12006109,12021590,12021589,12021594,12022284,12022450,12022548,12024353,12031132,12031428,12033447,12034326,12046137,12061229,12062015,12062120,12062048,12062106,12062050,12062108,12062578,12062988,12063084,12063124,12065205,12065253,12071086,12071164,12085827,12085889,12101162,12101170,12101984,12101990,12101993,12102789,12102838,12103638,12103688,12103714,12103775,4248,4422,4266,4432,20661,21443,46530,47120,47406,47412,48201,48269,48204,48271,48205,48273,48376,48393,48889,48944,49133,49139,49266,49295,57299,70804,70854,85632,86201,86525,86539,86542,87343,87406,87469,87493,87528,87690,88509,88512,94134,94983,97615,97676,98540,98631,126501,126409,127133,127136,127132,128749,128795,128907,133790,134675,136773,136907,138446,156611,158711,172881,173711,173715,173718,174604,174638,174805,174809,175396,175427,177706,179005,193448,194360,210139,210888,211036,211097,211037,211100,211040,211101,212547,212570,212703,212742,212786,212802,213149,213362,214164,214463,214165,214453,220348,220569,247389,248278,248275,248283,249095,249142,249220,249274,249781,249802,257082,257343,261289,260385,274263,274333,288155,288116,289234,289666,289235,289640,289214,289664,290547,299084,299444,313626,313887,316471,331820,331858,333442,333521,333439,333512,333443,333514,333591,333595,334889,334913,335103,337337,337408,340668,341291,340671,341290,344090,344367,358140,358361,372268,373238,373239,373242,373794,374363,374373,374574,374597) ) 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` = 11998 WHERE `RP`.`player` = 11998 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107430,107580,122627,123160,123163,123145,124258,123164,124263,212738,214342,212854,214043,212726,214343,235397,235400,246477,246729,247480,247550,257435,257661,259650,261984,262901,265230,277030,277604,280998,281156,283330,283368,299305,300921,301910,303459,337090,337225,342012,342038,345695,345897,360774,371959,373503,373596,10368507,10368643,10369910,10369970,10370659,10370675,10386430,10387239,10399649,10401407,10402890,10403501,10406416,10407384,10436930,10440342,10440367,10441420,10441483,10441454,10442098,10464044,10465535,10464046,10465514,10481185,10481299,10483350,10483524,10510439,10510457,10512516,10513618,10513886,10513654,10514248,10514298,10514480,10541086,10541284,10545490,10545492,10567945,10568995,10570184,10602844,10603249,10605285,10605611,10608185,10608708,10637857,10641001,10641063,10647737,10661553,10662419,10665101,10665089,10690433,10690523,10692052,10692069,10692054,10692426,10692595,10692655,10693226,10693253,10708157,10708437,10710164,10710182,10727624,10727870,10729980,10730053,10757480,10757501,10758570,10758567,10759304,10758577,10760148,10760511,10760588,10760924,10762073,10762254,10771023,10771323,10772474,10774615,10777255,10778912,10779283,10779292,10795208,10797124,10798519,10798620,10825259,10826347,10826473,10826335,10826472,10826338,10826475,10826569,10826614,10826664,10826727,10827332,10827713,10839286,10839462,10840931,10841263,10842831,10892886,10892903,10893831,10893943,10893845,10893942,10893828,10893939,10894077,10894456,10894549,10894637,10895384,10895468,10904724,10905716,10906592,10906783,10920968,10921927,10937334,10937589,10939574,10939594,10940817,10941677,10949575,10964773,10963267,10981542,10981544,10983185,10983070,10983178,10983868,10984048,10984049,10985624,10986176,10999084,10999853,11015754,11015990,11036269,11036788,11038392,11038559,11038387,11038556,11038386,11038561,11038804,11038869,11038934,11038956,11039241,11039596,11055630,11056215,11067859,11067872,11070828,11070835,11084984,11085325,11086024,11086025,11086028,11087221,11087293,11087527,11087558,11087626,11088859,11107239,11107863,11108838,11109009,11121494,11121526,11139798,11140813,11140815,11140817,11141719,11141890,11141893,11141993,11142011,11158075,11158189,11186347,11186404,11187415,11187337,11187304,11188258,11188407,11188754,11195634,11196007,11198714,11198859,11213521,11214606,11229188,11229201,11230103,11230270,11230132,11230453,11230085,11230452,11230843,11230883,11231946,11232196,11232757,11232797,11238316,11238437,11240917,11242852,11243190,11243212,11246798,11246829,11253484,11254407,11267988,11269155,11284077,11284088,11286195,11286372,11286194,11286278,11286215,11286403,11286626,11286634,11286784,11287357,11287960,11288067,11303066,11303137,11305364,11305397,11321715,11339896,11339936,11339894,11339937,11339899,11339934,11340433,11341467,11341489,11342145,11343156,11343422,11360200,11360646,11361659,11374175,11374471,11376064,11393041,11393032,11393030,11394418,11394567,11394726,11394807,11394913,11394954,11395240,11395386,11396863,11397736,11416758,11418973,11433544,11434407,11434411,11434403,11434406,11434398,11434436,11436143,11436309,11436307,11440053,11441247,11452622,11452824,11452961,11452827,11479219,11479222,11481273,11481426,11481276,11481424,11481257,11481422,11481664,11481758,11481809,11481854,11481928,11481932,11494353,11496100,11501307,11501368,11513341,11514693,11514884,11530213,11530231,11531663,11531810,11531648,11531866,11531673,11531923,11532164,11532242,11532630,11532643,11533029,11533190,11538468,11538829,11544670,11557095,11557572,11558783,11573336,11573339,11574931,11574937,11574953,11575629,11575638,11575926,11575944,11576041,11576043,11576877,11577287,11580126,11580390,11587511,11588851,11601356,11601647,11602358,11602410,11616938,11616968,11619065,11619110,11619107,11619741,11619752,11620267,11620274,11620381,11620423,11625815,11626006,11634892,11635201,11637269,11637960,11649885,11650737,11666599,11666964,11667179,11667254,11667176,11667256,11667177,11667251,11667378,11667807,11668054,11668088,11668217,11668235,11678257,11678287,11680024,11680026,11683486,11683994,11711182,11711452,11712095,11712195,11712148,11712193,11712121,11712196,11713350,11713409,11713668,11713672,11713773,11713822,11738030,11739577,11739600,11739452,11756969,11756981,11757911,11757944,11758267,11757943,11758268,11758756,11758786,11758899,11758934,11758985,11758993,11767186,11769337,11770031,11770743,11807065,11807287,11807308,11807916,11807933,11817411,11817474,11823688,11823842,11823607,11823869,11852606,11852630,11853965,11853956,11853915,11854453,11854446,11854692,11854907,11855224,11855252,11865241,11865531,11896076,11896285,11896797,11896798,11896801,11896926,11896942,11896992,11897011,11897059,11897076,11904584,11905416,11907463,11908371,11940775,11941730,11941733,11942281,11942520,11942699,11942734,11942762,11949688,11949693,11963426,11966711,11980346,11980583,11980608,11980605,11981364,11981927,11982838,11982989,11983057,12006080,12006109,12021590,12021589,12021594,12022284,12022450,12022548,12024353,12031132,12031428,12033447,12034326,12046137,12061229,12062015,12062120,12062048,12062106,12062050,12062108,12062578,12062988,12063084,12063124,12065205,12065253,12071086,12071164,12085827,12085889,12101162,12101170,12101984,12101990,12101993,12102789,12102838,12103638,12103688,12103714,12103775,4248,4422,4266,4432,20661,21443,46530,47120,47406,47412,48201,48269,48204,48271,48205,48273,48376,48393,48889,48944,49133,49139,49266,49295,57299,70804,70854,85632,86201,86525,86539,86542,87343,87406,87469,87493,87528,87690,88509,88512,94134,94983,97615,97676,98540,98631,126501,126409,127133,127136,127132,128749,128795,128907,133790,134675,136773,136907,138446,156611,158711,172881,173711,173715,173718,174604,174638,174805,174809,175396,175427,177706,179005,193448,194360,210139,210888,211036,211097,211037,211100,211040,211101,212547,212570,212703,212742,212786,212802,213149,213362,214164,214463,214165,214453,220348,220569,247389,248278,248275,248283,249095,249142,249220,249274,249781,249802,257082,257343,261289,260385,274263,274333,288155,288116,289234,289666,289235,289640,289214,289664,290547,299084,299444,313626,313887,316471,331820,331858,333442,333521,333439,333512,333443,333514,333591,333595,334889,334913,335103,337337,337408,340668,341291,340671,341290,344090,344367,358140,358361,372268,373238,373239,373242,373794,374363,374373,374574,374597) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: