(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` = 69759 WHERE `RP`.`player` = 69759 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107565,107592,122014,122182,122185,122235,122659,122101,122102,122836,213899,213902,214832,214596,215289,235403,235406,246730,247065,247716,248542,257383,258682,259649,259697,261936,262010,264270,265653,277031,277297,281128,282010,283332,283367,299404,299540,300892,300923,301902,302216,301836,303034,303421,303477,326370,326377,342013,342113,345694,345862,372016,372062,373397,373425,10368614,10368857,10369984,10370377,10370653,10370691,10387085,10387259,10399749,10399795,10403478,10403517,10406627,10407402,10436676,10437122,10440362,10440498,10441430,10441460,10441424,10441461,10441431,10441489,10442099,10442230,10442302,10443394,10443991,10464554,10477659,10466159,10477523,10481469,10481494,10483431,10483478,10510684,10510726,10512471,10512523,10513639,10513645,10513644,10513642,10514204,10514464,10514488,10514517,10514568,10540783,10541447,10543722,10545489,10567944,10570124,10570151,10570188,10570564,10583938,10602998,10605093,10605798,10608131,10608654,10637719,10639667,10639742,10639670,10639660,10640836,10640837,10640969,10641087,10647887,10661122,10662553,10665206,10665306,10690478,10691480,10691483,10691486,10692399,10692630,10693205,10708568,10708842,10710242,10710584,10727671,10728240,10730130,10730148,10757465,10758554,10758555,10758558,10760648,10760945,10762348,10770917,10771649,10773109,10773987,10777532,10778498,10779884,10780429,10794926,10795974,10797942,10798288,10825124,10826306,10826456,10826304,10826471,10826307,10826458,10826568,10826586,10826690,10826934,10827331,10827342,10839178,10839392,10840910,10841001,10842421,10842908,10892915,10893877,10893902,10893873,10893903,10893880,10893913,10894044,10894122,10894545,10894624,10895381,10895416,10904884,10905467,10906551,10906564,10920343,10921114,10937358,10939547,10940934,10941620,10948423,10949338,10962635,10962790,10981530,10981554,10983526,10983993,10984034,10984102,10985891,10985952,10998991,10999052,11015737,11017550,11036473,11038573,11038569,11038567,11038767,11038778,11038884,11038909,11039432,11039475,11055502,11055871,11067139,11067358,11070789,11070849,11085545,11085804,11085806,11085801,11087245,11087335,11087495,11087500,11087622,11087625,11107240,11108234,11108837,11108881,11121191,11121616,11139792,11140043,11140351,11140491,11140353,11140469,11140342,11140481,11141287,11141470,11141895,11141937,11141986,11142007,11157575,11158101,11186861,11186863,11186840,11188307,11188315,11188378,11188451,11189152,11189309,11195179,11195680,11198697,11199143,11213390,11213433,11229790,11229863,11229792,11230903,11231005,11231895,11232450,11232739,11232977,11237993,11238987,11241037,11241683,11243195,11243611,11246804,11246834,11253611,11253909,11267167,11267411,11284052,11286191,11286402,11286189,11286400,11286187,11286404,11286622,11286673,11286708,11287007,11287757,11287952,11302955,11303135,11305318,11305749,11320103,11322404,11340374,11340426,11341327,11341713,11341880,11341964,11342839,11343541,11359561,11360248,11361622,11361870,11374407,11374445,11394390,11394699,11394934,11395058,11395639,11396647,11397109,11415933,11417297,11433570,11434431,11434416,11434417,11435986,11436078,11436222,11436255,11440005,11440372,11448985,11449216,11449011,11449289,11479183,11481667,11481789,11481878,11493986,11494381,11500349,11500874,11500352,11500876,11514724,11515832,11530233,11531181,11531614,11531758,11531619,11531922,11531621,11531750,11532021,11532118,11532670,11532672,11532801,11533192,11538380,11538478,11543816,11544403,11557183,11558964,11574143,11575597,11575917,11575925,11576031,11576042,11576819,11576878,11580143,11580654,11587097,11587155,11601188,11601197,11601924,11602233,11616933,11619098,11619096,11619100,11619593,11620232,11620288,11620410,11620427,11624889,11626212,11636353,11636561,11637157,11637878,11649912,11652118,11666279,11667174,11667175,11667195,11667373,11667394,11668120,11668146,11668176,11668247,11678361,11678382,11680478,11680885,11682468,11683081,11711184,11712118,11712183,11712103,11712180,11712112,11712185,11713214,11713247,11713688,11713796,11713810,11738273,11738384,11738269,11738386,11756975,11757921,11757928,11757924,11758759,11758849,11758890,11758940,11758976,11758983,11767482,11769464,11769832,11805875,11805876,11805865,11807020,11807346,11807860,11817604,11818084,11824169,11824440,11824142,11838127,11852647,11854690,11855099,11855289,11866598,11896304,11896589,11896890,11896893,11896889,11896922,11896995,11897030,11897087,11897107,11905634,11905811,11907295,11908690,11942569,11942675,11942735,11942757,11942791,11949097,11949717,11964707,11964761,11980351,11980503,11980507,11980509,11981417,11981898,11982879,11983011,11982962,12006072,12006259,12021363,12021407,12021510,12021563,12021539,12021569,12021509,12021567,12022024,12022365,12022401,12022418,12022506,12022547,12024178,12024455,12031120,12031451,12033479,12034394,12046128,12046133,12061199,12061213,12062057,12062117,12062061,12062125,12062063,12062126,12062664,12062876,12062949,12063021,12063069,12063250,12065241,12065218,12071158,12085519,12085983,12101129,12101171,12102026,12102071,12102035,12102069,12102031,12102073,12102846,12102958,12103619,12103704,12103782,4485,5132,4483,5172,20629,21572,46540,46997,47395,47421,48276,48277,48280,48366,48400,48824,48961,49120,49179,49371,49394,57502,57525,70582,70853,85635,86527,86535,86532,87370,87400,87467,87483,87519,87556,88401,88727,94174,95411,97506,97666,98656,99585,126426,126567,127184,127249,127186,127251,127188,127253,128671,128708,128784,128804,128904,128931,133823,136871,136933,139026,139184,157330,157788,172862,173708,173709,173727,174597,174592,174678,174754,175400,175413,177467,177510,193422,193423,210112,210138,211119,211122,211118,212540,212651,212728,212753,212790,212805,212989,213303,213378,214001,214074,214560,220202,231474,247373,247392,248291,248289,248293,249115,249159,249266,249267,249889,249927,257187,258192,260417,260498,261980,273688,289327,289366,289329,289371,289331,289424,289861,289876,290336,290460,290602,290667,299185,313234,313251,316068,316561,331847,333592,334840,334977,335066,335069,337397,338460,340667,340821,340672,340824,344089,344368,358346,358369,372076,373371,373499,373465,373374,373375,373468,374432,374466,374596,374618) ) 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` = 69759 WHERE `RP`.`player` = 69759 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107565,107592,122014,122182,122185,122235,122659,122101,122102,122836,213899,213902,214832,214596,215289,235403,235406,246730,247065,247716,248542,257383,258682,259649,259697,261936,262010,264270,265653,277031,277297,281128,282010,283332,283367,299404,299540,300892,300923,301902,302216,301836,303034,303421,303477,326370,326377,342013,342113,345694,345862,372016,372062,373397,373425,10368614,10368857,10369984,10370377,10370653,10370691,10387085,10387259,10399749,10399795,10403478,10403517,10406627,10407402,10436676,10437122,10440362,10440498,10441430,10441460,10441424,10441461,10441431,10441489,10442099,10442230,10442302,10443394,10443991,10464554,10477659,10466159,10477523,10481469,10481494,10483431,10483478,10510684,10510726,10512471,10512523,10513639,10513645,10513644,10513642,10514204,10514464,10514488,10514517,10514568,10540783,10541447,10543722,10545489,10567944,10570124,10570151,10570188,10570564,10583938,10602998,10605093,10605798,10608131,10608654,10637719,10639667,10639742,10639670,10639660,10640836,10640837,10640969,10641087,10647887,10661122,10662553,10665206,10665306,10690478,10691480,10691483,10691486,10692399,10692630,10693205,10708568,10708842,10710242,10710584,10727671,10728240,10730130,10730148,10757465,10758554,10758555,10758558,10760648,10760945,10762348,10770917,10771649,10773109,10773987,10777532,10778498,10779884,10780429,10794926,10795974,10797942,10798288,10825124,10826306,10826456,10826304,10826471,10826307,10826458,10826568,10826586,10826690,10826934,10827331,10827342,10839178,10839392,10840910,10841001,10842421,10842908,10892915,10893877,10893902,10893873,10893903,10893880,10893913,10894044,10894122,10894545,10894624,10895381,10895416,10904884,10905467,10906551,10906564,10920343,10921114,10937358,10939547,10940934,10941620,10948423,10949338,10962635,10962790,10981530,10981554,10983526,10983993,10984034,10984102,10985891,10985952,10998991,10999052,11015737,11017550,11036473,11038573,11038569,11038567,11038767,11038778,11038884,11038909,11039432,11039475,11055502,11055871,11067139,11067358,11070789,11070849,11085545,11085804,11085806,11085801,11087245,11087335,11087495,11087500,11087622,11087625,11107240,11108234,11108837,11108881,11121191,11121616,11139792,11140043,11140351,11140491,11140353,11140469,11140342,11140481,11141287,11141470,11141895,11141937,11141986,11142007,11157575,11158101,11186861,11186863,11186840,11188307,11188315,11188378,11188451,11189152,11189309,11195179,11195680,11198697,11199143,11213390,11213433,11229790,11229863,11229792,11230903,11231005,11231895,11232450,11232739,11232977,11237993,11238987,11241037,11241683,11243195,11243611,11246804,11246834,11253611,11253909,11267167,11267411,11284052,11286191,11286402,11286189,11286400,11286187,11286404,11286622,11286673,11286708,11287007,11287757,11287952,11302955,11303135,11305318,11305749,11320103,11322404,11340374,11340426,11341327,11341713,11341880,11341964,11342839,11343541,11359561,11360248,11361622,11361870,11374407,11374445,11394390,11394699,11394934,11395058,11395639,11396647,11397109,11415933,11417297,11433570,11434431,11434416,11434417,11435986,11436078,11436222,11436255,11440005,11440372,11448985,11449216,11449011,11449289,11479183,11481667,11481789,11481878,11493986,11494381,11500349,11500874,11500352,11500876,11514724,11515832,11530233,11531181,11531614,11531758,11531619,11531922,11531621,11531750,11532021,11532118,11532670,11532672,11532801,11533192,11538380,11538478,11543816,11544403,11557183,11558964,11574143,11575597,11575917,11575925,11576031,11576042,11576819,11576878,11580143,11580654,11587097,11587155,11601188,11601197,11601924,11602233,11616933,11619098,11619096,11619100,11619593,11620232,11620288,11620410,11620427,11624889,11626212,11636353,11636561,11637157,11637878,11649912,11652118,11666279,11667174,11667175,11667195,11667373,11667394,11668120,11668146,11668176,11668247,11678361,11678382,11680478,11680885,11682468,11683081,11711184,11712118,11712183,11712103,11712180,11712112,11712185,11713214,11713247,11713688,11713796,11713810,11738273,11738384,11738269,11738386,11756975,11757921,11757928,11757924,11758759,11758849,11758890,11758940,11758976,11758983,11767482,11769464,11769832,11805875,11805876,11805865,11807020,11807346,11807860,11817604,11818084,11824169,11824440,11824142,11838127,11852647,11854690,11855099,11855289,11866598,11896304,11896589,11896890,11896893,11896889,11896922,11896995,11897030,11897087,11897107,11905634,11905811,11907295,11908690,11942569,11942675,11942735,11942757,11942791,11949097,11949717,11964707,11964761,11980351,11980503,11980507,11980509,11981417,11981898,11982879,11983011,11982962,12006072,12006259,12021363,12021407,12021510,12021563,12021539,12021569,12021509,12021567,12022024,12022365,12022401,12022418,12022506,12022547,12024178,12024455,12031120,12031451,12033479,12034394,12046128,12046133,12061199,12061213,12062057,12062117,12062061,12062125,12062063,12062126,12062664,12062876,12062949,12063021,12063069,12063250,12065241,12065218,12071158,12085519,12085983,12101129,12101171,12102026,12102071,12102035,12102069,12102031,12102073,12102846,12102958,12103619,12103704,12103782,4485,5132,4483,5172,20629,21572,46540,46997,47395,47421,48276,48277,48280,48366,48400,48824,48961,49120,49179,49371,49394,57502,57525,70582,70853,85635,86527,86535,86532,87370,87400,87467,87483,87519,87556,88401,88727,94174,95411,97506,97666,98656,99585,126426,126567,127184,127249,127186,127251,127188,127253,128671,128708,128784,128804,128904,128931,133823,136871,136933,139026,139184,157330,157788,172862,173708,173709,173727,174597,174592,174678,174754,175400,175413,177467,177510,193422,193423,210112,210138,211119,211122,211118,212540,212651,212728,212753,212790,212805,212989,213303,213378,214001,214074,214560,220202,231474,247373,247392,248291,248289,248293,249115,249159,249266,249267,249889,249927,257187,258192,260417,260498,261980,273688,289327,289366,289329,289371,289331,289424,289861,289876,290336,290460,290602,290667,299185,313234,313251,316068,316561,331847,333592,334840,334977,335066,335069,337397,338460,340667,340821,340672,340824,344089,344368,358346,358369,372076,373371,373499,373465,373374,373375,373468,374432,374466,374596,374618) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: