(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` = 24312 WHERE `RP`.`player` = 24312 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107419,107579,123063,123716,123377,124022,124027,213579,214053,213685,214049,213903,214052,234850,235179,234851,235182,244126,246709,247255,247530,257327,257645,259766,259807,261935,261950,264380,265654,277576,278426,282051,282143,283439,283904,299304,299776,300906,300919,301905,302496,301904,303400,303451,317048,338965,342069,342096,345840,346130,371974,372237,373574,373968,10368925,10369301,10369963,10370371,10370627,10370633,10386999,10387019,10400062,10400352,10403354,10403965,10406362,10406489,10437056,10437066,10440368,10440403,10441285,10441308,10441288,10441313,10441309,10441362,10442139,10442150,10442287,10442289,10443340,10443662,10464060,10464331,10464045,10464598,10481219,10481363,10482816,10483498,10510430,10510575,10512448,10540964,10541375,10542503,10542630,10569059,10570163,10570183,10570671,10570955,10583732,10602772,10605248,10605495,10608187,10608220,10638263,10641479,10647888,10647969,10661644,10665254,10665325,10690496,10690569,10691702,10692051,10691705,10692030,10692032,10692227,10692451,10692483,10692572,10692760,10693204,10693209,10708222,10708240,10710593,10710660,10727573,10727820,10729842,10730634,10757502,10757642,10758640,10759583,10758642,10760481,10760556,10760955,10760977,10761824,10762235,10771324,10771405,10772510,10772949,10777293,10777963,10780162,10780430,10795340,10795973,10799844,10825191,10825441,10826296,10826299,10826297,10826554,10826571,10826709,10826853,10827341,10827819,10839231,10839595,10840875,10840999,10842423,10842914,10892873,10892878,10893795,10893798,10893799,10894041,10894601,10894613,10895479,10895577,10904972,10905490,10906642,10906656,10920514,10920571,10937277,10937548,10938203,10939183,10938196,10939398,10938205,10939346,10939514,10939542,10940807,10940828,10941680,10941708,10949153,10964774,10962516,10963295,10983262,10983162,10983263,10983578,10983670,10984090,10984122,10985619,10985892,10999942,11000908,11016020,11017026,11036568,11038520,11038557,11038537,11038810,11038935,11039302,11055556,11055822,11067433,11069759,11070803,11071298,11085164,11085394,11086076,11086389,11086074,11086392,11086085,11086393,11087222,11087226,11087508,11087517,11087634,11089528,11106703,11108233,11108882,11109078,11121365,11121659,11139791,11139899,11140325,11140804,11140328,11140877,11140341,11140857,11141198,11141322,11141868,11141938,11142045,11142282,11157576,11158134,11186385,11187648,11187693,11187692,11188257,11188393,11189127,11195528,11195802,11198755,11198903,11213360,11213458,11229175,11229220,11229685,11229796,11229726,11229768,11229727,11229777,11230845,11230874,11232122,11232140,11232811,11232936,11239252,11239763,11241208,11242418,11243525,11243587,11247172,11253706,11254176,11267363,11267987,11284082,11284095,11286246,11286371,11286249,11286399,11286260,11286368,11286608,11286657,11286865,11287293,11287838,11288080,11303026,11303361,11306104,11306376,11320447,11321093,11337895,11337910,11339895,11339997,11339893,11339980,11339891,11339996,11340387,11340416,11341614,11341637,11341845,11341858,11342680,11344651,11359930,11360811,11361635,11362285,11375808,11376063,11391991,11392223,11393076,11393119,11393077,11393125,11393093,11393122,11394410,11394434,11394761,11394780,11394871,11394957,11395305,11396366,11397160,11397775,11417397,11417864,11434298,11434526,11434355,11434605,11434361,11434544,11435992,11435993,11436225,11436248,11440166,11441180,11449575,11451035,11449573,11450926,11479179,11481329,11481406,11481317,11481404,11481319,11481412,11481694,11481750,11481795,11481807,11481900,11481935,11494299,11494331,11501703,11501872,11501706,11501876,11514613,11514663,11530273,11531729,11531879,11531737,11531882,11531728,11531885,11531980,11532007,11532638,11532699,11532911,11533020,11538415,11538454,11543502,11544504,11557497,11557813,11573338,11574853,11574852,11574848,11575644,11575683,11575918,11575931,11576059,11576082,11577849,11578654,11580278,11580453,11586869,11587046,11601267,11601469,11601977,11602345,11616936,11616966,11618809,11618831,11618830,11619528,11620282,11620459,11624875,11625588,11634781,11635645,11637205,11637252,11650052,11650313,11678164,11678170,11679203,11679973,11682330,11683114,11711148,11711198,11713223,11713246,11713669,11713677,11713802,11713807,11737944,11738074,11737998,11738080,11757214,11757662,11758809,11758895,11758923,11759001,11767265,11767599,11769416,11769618,11805740,11805743,11805744,11807013,11807055,11807489,11807777,11807903,11807911,11816737,11816866,11823391,11823470,11823388,11823468,11853654,11853657,11853649,11854430,11854759,11855226,11865479,11866379,11895862,11896104,11896805,11896816,11896775,11896837,11896779,11896838,11896928,11896944,11897007,11897014,11897070,11897078,11905045,11905496,11907806,11908218,11940213,11940958,11941260,11940961,11941245,11940962,11941427,11942539,11942642,11942673,11942701,11942782,11942815,11949148,11965165,11964934,11965105,11981362,11981369,11981789,11982551,11982846,11983004,11983069,12006105,12021397,12022364,12022466,12022572,12024233,12024420,12031137,12031307,12034055,12034045,12046093,12046111,12061198,12061239,12062020,12062022,12062029,12062665,12062783,12062963,12063006,12063101,12063113,12065211,12065286,12071175,12071179,12085055,12085831,12101143,12101158,12101987,12101988,12101996,12102642,12103603,12103622,12103731,12103791,4314,5063,4315,4479,20564,21509,46582,46998,48177,48176,48185,48386,48928,48962,49164,49206,49556,49878,57296,57322,59851,70706,85618,86534,86530,86531,87308,87350,87439,87490,87520,87522,88246,88726,94143,95293,97677,97836,98690,99593,126224,126383,128643,128670,128791,128840,128872,134654,134670,136858,136840,139076,155985,156592,172960,174598,174746,175356,175401,175406,178428,193457,194359,210117,211018,211020,211039,212556,212549,212724,212754,212779,212800,212990,213304,215003,216452,215149,216453,220129,231902,247369,248277,248276,248246,249166,249261,249948,257268,257437,260576,261290,272693,273691,288409,290196,290669,300790,300798,314054,314174,315697,315846,331852,332837,333392,333394,333388,333626,334686,335102,335130,337327,337409,339702,341756,339732,341411,345191,358357,372451,372744,373583,373792,374407,374497,374604,374627) ) 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` = 24312 WHERE `RP`.`player` = 24312 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107419,107579,123063,123716,123377,124022,124027,213579,214053,213685,214049,213903,214052,234850,235179,234851,235182,244126,246709,247255,247530,257327,257645,259766,259807,261935,261950,264380,265654,277576,278426,282051,282143,283439,283904,299304,299776,300906,300919,301905,302496,301904,303400,303451,317048,338965,342069,342096,345840,346130,371974,372237,373574,373968,10368925,10369301,10369963,10370371,10370627,10370633,10386999,10387019,10400062,10400352,10403354,10403965,10406362,10406489,10437056,10437066,10440368,10440403,10441285,10441308,10441288,10441313,10441309,10441362,10442139,10442150,10442287,10442289,10443340,10443662,10464060,10464331,10464045,10464598,10481219,10481363,10482816,10483498,10510430,10510575,10512448,10540964,10541375,10542503,10542630,10569059,10570163,10570183,10570671,10570955,10583732,10602772,10605248,10605495,10608187,10608220,10638263,10641479,10647888,10647969,10661644,10665254,10665325,10690496,10690569,10691702,10692051,10691705,10692030,10692032,10692227,10692451,10692483,10692572,10692760,10693204,10693209,10708222,10708240,10710593,10710660,10727573,10727820,10729842,10730634,10757502,10757642,10758640,10759583,10758642,10760481,10760556,10760955,10760977,10761824,10762235,10771324,10771405,10772510,10772949,10777293,10777963,10780162,10780430,10795340,10795973,10799844,10825191,10825441,10826296,10826299,10826297,10826554,10826571,10826709,10826853,10827341,10827819,10839231,10839595,10840875,10840999,10842423,10842914,10892873,10892878,10893795,10893798,10893799,10894041,10894601,10894613,10895479,10895577,10904972,10905490,10906642,10906656,10920514,10920571,10937277,10937548,10938203,10939183,10938196,10939398,10938205,10939346,10939514,10939542,10940807,10940828,10941680,10941708,10949153,10964774,10962516,10963295,10983262,10983162,10983263,10983578,10983670,10984090,10984122,10985619,10985892,10999942,11000908,11016020,11017026,11036568,11038520,11038557,11038537,11038810,11038935,11039302,11055556,11055822,11067433,11069759,11070803,11071298,11085164,11085394,11086076,11086389,11086074,11086392,11086085,11086393,11087222,11087226,11087508,11087517,11087634,11089528,11106703,11108233,11108882,11109078,11121365,11121659,11139791,11139899,11140325,11140804,11140328,11140877,11140341,11140857,11141198,11141322,11141868,11141938,11142045,11142282,11157576,11158134,11186385,11187648,11187693,11187692,11188257,11188393,11189127,11195528,11195802,11198755,11198903,11213360,11213458,11229175,11229220,11229685,11229796,11229726,11229768,11229727,11229777,11230845,11230874,11232122,11232140,11232811,11232936,11239252,11239763,11241208,11242418,11243525,11243587,11247172,11253706,11254176,11267363,11267987,11284082,11284095,11286246,11286371,11286249,11286399,11286260,11286368,11286608,11286657,11286865,11287293,11287838,11288080,11303026,11303361,11306104,11306376,11320447,11321093,11337895,11337910,11339895,11339997,11339893,11339980,11339891,11339996,11340387,11340416,11341614,11341637,11341845,11341858,11342680,11344651,11359930,11360811,11361635,11362285,11375808,11376063,11391991,11392223,11393076,11393119,11393077,11393125,11393093,11393122,11394410,11394434,11394761,11394780,11394871,11394957,11395305,11396366,11397160,11397775,11417397,11417864,11434298,11434526,11434355,11434605,11434361,11434544,11435992,11435993,11436225,11436248,11440166,11441180,11449575,11451035,11449573,11450926,11479179,11481329,11481406,11481317,11481404,11481319,11481412,11481694,11481750,11481795,11481807,11481900,11481935,11494299,11494331,11501703,11501872,11501706,11501876,11514613,11514663,11530273,11531729,11531879,11531737,11531882,11531728,11531885,11531980,11532007,11532638,11532699,11532911,11533020,11538415,11538454,11543502,11544504,11557497,11557813,11573338,11574853,11574852,11574848,11575644,11575683,11575918,11575931,11576059,11576082,11577849,11578654,11580278,11580453,11586869,11587046,11601267,11601469,11601977,11602345,11616936,11616966,11618809,11618831,11618830,11619528,11620282,11620459,11624875,11625588,11634781,11635645,11637205,11637252,11650052,11650313,11678164,11678170,11679203,11679973,11682330,11683114,11711148,11711198,11713223,11713246,11713669,11713677,11713802,11713807,11737944,11738074,11737998,11738080,11757214,11757662,11758809,11758895,11758923,11759001,11767265,11767599,11769416,11769618,11805740,11805743,11805744,11807013,11807055,11807489,11807777,11807903,11807911,11816737,11816866,11823391,11823470,11823388,11823468,11853654,11853657,11853649,11854430,11854759,11855226,11865479,11866379,11895862,11896104,11896805,11896816,11896775,11896837,11896779,11896838,11896928,11896944,11897007,11897014,11897070,11897078,11905045,11905496,11907806,11908218,11940213,11940958,11941260,11940961,11941245,11940962,11941427,11942539,11942642,11942673,11942701,11942782,11942815,11949148,11965165,11964934,11965105,11981362,11981369,11981789,11982551,11982846,11983004,11983069,12006105,12021397,12022364,12022466,12022572,12024233,12024420,12031137,12031307,12034055,12034045,12046093,12046111,12061198,12061239,12062020,12062022,12062029,12062665,12062783,12062963,12063006,12063101,12063113,12065211,12065286,12071175,12071179,12085055,12085831,12101143,12101158,12101987,12101988,12101996,12102642,12103603,12103622,12103731,12103791,4314,5063,4315,4479,20564,21509,46582,46998,48177,48176,48185,48386,48928,48962,49164,49206,49556,49878,57296,57322,59851,70706,85618,86534,86530,86531,87308,87350,87439,87490,87520,87522,88246,88726,94143,95293,97677,97836,98690,99593,126224,126383,128643,128670,128791,128840,128872,134654,134670,136858,136840,139076,155985,156592,172960,174598,174746,175356,175401,175406,178428,193457,194359,210117,211018,211020,211039,212556,212549,212724,212754,212779,212800,212990,213304,215003,216452,215149,216453,220129,231902,247369,248277,248276,248246,249166,249261,249948,257268,257437,260576,261290,272693,273691,288409,290196,290669,300790,300798,314054,314174,315697,315846,331852,332837,333392,333394,333388,333626,334686,335102,335130,337327,337409,339702,341756,339732,341411,345191,358357,372451,372744,373583,373792,374407,374497,374604,374627) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: