(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` = 72967 WHERE `RP`.`player` = 72967 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107425,107596,122680,122688,122708,123687,122697,124369,124753,124757,214036,214955,214957,235879,235838,247000,248881,257326,257361,259714,259667,261946,261947,264536,265467,277533,278431,281045,281715,283290,283306,299421,299507,300890,300920,301870,301879,301798,301886,303462,303472,317057,337738,342239,342287,345743,345874,371858,371868,373303,373772,10368400,10368446,10369912,10370019,10370600,10370619,10385852,10385954,10400093,10400272,10403168,10403372,10406296,10406694,10436785,10437065,10440332,10440366,10441389,10441412,10441393,10441414,10441392,10441415,10442151,10442178,10442272,10442297,10443338,10443749,10464043,10464332,10463991,10464334,10481104,10481147,10482488,10482645,10510477,10510484,10512423,10512449,10514437,10514537,10540951,10541014,10542689,10544258,10568175,10569786,10569793,10570140,10570179,10570661,10602900,10602926,10605239,10605354,10608177,10608595,10640990,10641066,10641085,10647963,10647970,10661374,10661731,10665201,10665405,10690456,10690474,10691776,10691796,10691799,10692394,10692602,10693940,10708289,10708387,10710180,10710212,10727762,10727819,10729960,10730453,10757407,10757438,10758512,10758514,10758515,10760687,10760912,10760967,10762092,10762683,10771486,10771588,10772812,10774484,10777202,10777763,10780193,10780522,10795880,10795503,10798766,10799843,10825128,10825278,10839327,10839538,10840942,10841116,10843221,10875784,10892904,10894681,10895556,10904364,10905448,10906626,10906713,10921242,10921636,10937258,10937479,10938183,10938191,10938186,10939511,10940742,10941600,10948989,10950568,10962210,10963296,10981550,10984121,10985638,10998711,11000734,11015562,11015808,11038426,11038433,11038443,11038768,11038806,11038902,11038903,11039242,11039595,11055735,11056042,11067500,11068943,11070796,11070833,11085124,11086132,11086384,11085952,11087249,11087398,11087518,11087565,11087619,11089522,11107692,11109729,11120851,11121184,11121447,11139805,11139815,11140334,11140337,11140361,11141336,11141904,11141936,11142042,11142068,11158102,11158400,11186362,11188279,11188296,11188402,11188437,11189141,11195443,11195740,11198717,11198906,11213452,11229176,11229275,11229862,11230080,11229864,11230100,11230086,11230286,11230865,11231148,11231892,11232916,11239360,11241892,11243432,11244361,11246802,11246811,11253837,11254056,11267228,11268338,11284102,11286276,11286366,11286367,11286617,11286675,11287258,11287402,11287951,11287994,11303022,11303096,11305330,11305574,11320299,11323598,11337886,11337912,11340053,11340051,11340083,11340402,11340423,11341335,11341663,11341937,11342146,11342891,11343932,11360530,11360676,11361680,11361869,11374437,11374443,11393068,11393065,11393070,11394323,11394394,11394698,11394796,11394884,11394943,11395146,11395994,11397823,11397931,11416651,11418072,11433550,11433639,11434312,11434501,11434356,11434495,11434313,11434494,11436018,11436093,11436249,11436320,11440496,11441858,11450066,11451036,11450067,11451034,11479214,11481486,11481488,11481490,11481659,11481776,11481844,11481876,11481946,11494116,11494394,11501118,11501464,11501207,11501264,11514345,11515098,11530258,11531770,11531764,11531768,11532163,11532748,11532902,11533470,11538457,11538540,11544718,11555870,11557558,11558837,11573329,11573344,11575106,11575108,11575119,11575783,11576093,11577477,11578206,11581253,11582060,11588275,11588306,11601800,11602700,11602705,11602794,11616982,11616985,11619150,11619161,11619153,11619671,11620246,11620406,11625760,11627770,11635511,11637998,11648985,11650094,11650661,11666284,11666707,11667960,11668113,11668142,11668204,11668244,11680088,11680086,11680599,11682858,11684708,11711193,11711367,11712136,11712156,11712133,11712164,11712140,11712167,11713514,11713542,11713680,11713689,11713784,11713794,11739451,11740069,11739453,11740071,11756971,11757955,11757960,11757959,11757970,11757956,11757965,11758761,11758808,11758882,11758921,11758972,11758998,11767675,11767943,11769833,11770098,11805489,11805902,11805549,11805940,11805550,11805943,11807003,11807059,11807347,11807450,11807879,11807897,11816593,11816939,11822803,11823333,11823016,11823293,11852614,11853754,11853793,11853773,11853798,11853770,11853795,11854443,11854469,11854821,11854938,11855229,11855253,11865450,11866172,11896395,11896860,11896882,11896881,11896925,11896941,11896998,11897032,11897063,11897082,11905152,11905964,11907789,11908846,11940248,11940291,11941172,11941181,11941194,11942553,11942582,11942671,11942726,11942809,11942810,11949519,11951356,11964303,11965274,11980352,11980389,11980538,11980915,11980561,11980917,11980558,11980918,11981374,11981391,11981819,11981852,11982949,11982951,11982966,11983074,12006201,12006475,12021379,12021606,12021609,12021610,12022020,12022036,12022394,12022420,12022531,12022562,12024352,12031432,12034331,12046105,12046401,12061230,12061237,12062005,12062007,12062211,12062009,12062202,12062708,12062957,12062964,12063086,12071144,12071160,12085286,12101149,12103140,12103579,12103786,5208,20605,20598,46484,47429,47444,48178,48260,48175,48261,48180,48279,48373,48668,48943,49050,49125,49132,49403,49636,57317,70682,70837,85654,86533,86615,86536,86618,86537,86631,87320,87323,87451,87508,87976,88776,88795,94183,95038,98939,112212,126321,127201,127199,127207,128639,128705,128801,128854,128864,128930,134653,136857,136921,138471,156367,156962,173785,173792,173789,174512,174627,174655,174681,174959,175377,175415,177781,177866,193419,194176,210131,211111,211107,211116,212551,212576,212684,212698,212769,213188,213341,214409,214851,214408,214850,220270,220347,247377,248319,248324,248321,249097,249241,249811,257053,257577,260462,260514,272692,273678,288105,288334,289115,289113,289109,289815,290297,290615,299141,300797,313279,313421,315779,315845,331870,333471,333477,333480,333593,334670,334890,335114,335118,337328,337335,340499,341526,340491,341530,358165,358164,372452,373764,374307,374408,374608,374620) ) 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` = 72967 WHERE `RP`.`player` = 72967 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107425,107596,122680,122688,122708,123687,122697,124369,124753,124757,214036,214955,214957,235879,235838,247000,248881,257326,257361,259714,259667,261946,261947,264536,265467,277533,278431,281045,281715,283290,283306,299421,299507,300890,300920,301870,301879,301798,301886,303462,303472,317057,337738,342239,342287,345743,345874,371858,371868,373303,373772,10368400,10368446,10369912,10370019,10370600,10370619,10385852,10385954,10400093,10400272,10403168,10403372,10406296,10406694,10436785,10437065,10440332,10440366,10441389,10441412,10441393,10441414,10441392,10441415,10442151,10442178,10442272,10442297,10443338,10443749,10464043,10464332,10463991,10464334,10481104,10481147,10482488,10482645,10510477,10510484,10512423,10512449,10514437,10514537,10540951,10541014,10542689,10544258,10568175,10569786,10569793,10570140,10570179,10570661,10602900,10602926,10605239,10605354,10608177,10608595,10640990,10641066,10641085,10647963,10647970,10661374,10661731,10665201,10665405,10690456,10690474,10691776,10691796,10691799,10692394,10692602,10693940,10708289,10708387,10710180,10710212,10727762,10727819,10729960,10730453,10757407,10757438,10758512,10758514,10758515,10760687,10760912,10760967,10762092,10762683,10771486,10771588,10772812,10774484,10777202,10777763,10780193,10780522,10795880,10795503,10798766,10799843,10825128,10825278,10839327,10839538,10840942,10841116,10843221,10875784,10892904,10894681,10895556,10904364,10905448,10906626,10906713,10921242,10921636,10937258,10937479,10938183,10938191,10938186,10939511,10940742,10941600,10948989,10950568,10962210,10963296,10981550,10984121,10985638,10998711,11000734,11015562,11015808,11038426,11038433,11038443,11038768,11038806,11038902,11038903,11039242,11039595,11055735,11056042,11067500,11068943,11070796,11070833,11085124,11086132,11086384,11085952,11087249,11087398,11087518,11087565,11087619,11089522,11107692,11109729,11120851,11121184,11121447,11139805,11139815,11140334,11140337,11140361,11141336,11141904,11141936,11142042,11142068,11158102,11158400,11186362,11188279,11188296,11188402,11188437,11189141,11195443,11195740,11198717,11198906,11213452,11229176,11229275,11229862,11230080,11229864,11230100,11230086,11230286,11230865,11231148,11231892,11232916,11239360,11241892,11243432,11244361,11246802,11246811,11253837,11254056,11267228,11268338,11284102,11286276,11286366,11286367,11286617,11286675,11287258,11287402,11287951,11287994,11303022,11303096,11305330,11305574,11320299,11323598,11337886,11337912,11340053,11340051,11340083,11340402,11340423,11341335,11341663,11341937,11342146,11342891,11343932,11360530,11360676,11361680,11361869,11374437,11374443,11393068,11393065,11393070,11394323,11394394,11394698,11394796,11394884,11394943,11395146,11395994,11397823,11397931,11416651,11418072,11433550,11433639,11434312,11434501,11434356,11434495,11434313,11434494,11436018,11436093,11436249,11436320,11440496,11441858,11450066,11451036,11450067,11451034,11479214,11481486,11481488,11481490,11481659,11481776,11481844,11481876,11481946,11494116,11494394,11501118,11501464,11501207,11501264,11514345,11515098,11530258,11531770,11531764,11531768,11532163,11532748,11532902,11533470,11538457,11538540,11544718,11555870,11557558,11558837,11573329,11573344,11575106,11575108,11575119,11575783,11576093,11577477,11578206,11581253,11582060,11588275,11588306,11601800,11602700,11602705,11602794,11616982,11616985,11619150,11619161,11619153,11619671,11620246,11620406,11625760,11627770,11635511,11637998,11648985,11650094,11650661,11666284,11666707,11667960,11668113,11668142,11668204,11668244,11680088,11680086,11680599,11682858,11684708,11711193,11711367,11712136,11712156,11712133,11712164,11712140,11712167,11713514,11713542,11713680,11713689,11713784,11713794,11739451,11740069,11739453,11740071,11756971,11757955,11757960,11757959,11757970,11757956,11757965,11758761,11758808,11758882,11758921,11758972,11758998,11767675,11767943,11769833,11770098,11805489,11805902,11805549,11805940,11805550,11805943,11807003,11807059,11807347,11807450,11807879,11807897,11816593,11816939,11822803,11823333,11823016,11823293,11852614,11853754,11853793,11853773,11853798,11853770,11853795,11854443,11854469,11854821,11854938,11855229,11855253,11865450,11866172,11896395,11896860,11896882,11896881,11896925,11896941,11896998,11897032,11897063,11897082,11905152,11905964,11907789,11908846,11940248,11940291,11941172,11941181,11941194,11942553,11942582,11942671,11942726,11942809,11942810,11949519,11951356,11964303,11965274,11980352,11980389,11980538,11980915,11980561,11980917,11980558,11980918,11981374,11981391,11981819,11981852,11982949,11982951,11982966,11983074,12006201,12006475,12021379,12021606,12021609,12021610,12022020,12022036,12022394,12022420,12022531,12022562,12024352,12031432,12034331,12046105,12046401,12061230,12061237,12062005,12062007,12062211,12062009,12062202,12062708,12062957,12062964,12063086,12071144,12071160,12085286,12101149,12103140,12103579,12103786,5208,20605,20598,46484,47429,47444,48178,48260,48175,48261,48180,48279,48373,48668,48943,49050,49125,49132,49403,49636,57317,70682,70837,85654,86533,86615,86536,86618,86537,86631,87320,87323,87451,87508,87976,88776,88795,94183,95038,98939,112212,126321,127201,127199,127207,128639,128705,128801,128854,128864,128930,134653,136857,136921,138471,156367,156962,173785,173792,173789,174512,174627,174655,174681,174959,175377,175415,177781,177866,193419,194176,210131,211111,211107,211116,212551,212576,212684,212698,212769,213188,213341,214409,214851,214408,214850,220270,220347,247377,248319,248324,248321,249097,249241,249811,257053,257577,260462,260514,272692,273678,288105,288334,289115,289113,289109,289815,290297,290615,299141,300797,313279,313421,315779,315845,331870,333471,333477,333480,333593,334670,334890,335114,335118,337328,337335,340499,341526,340491,341530,358165,358164,372452,373764,374307,374408,374608,374620) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: