(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` = 72415 WHERE `RP`.`player` = 72415 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107569,107578,122682,122691,123339,122696,122650,123861,212741,212851,212744,212853,212856,213587,235257,235273,235260,235954,246755,247091,247410,248825,257561,259686,262100,264385,277386,277825,281102,281530,283279,283331,299353,299448,300877,300927,301839,301874,301838,303415,303445,337339,337487,342186,342268,345710,371881,373616,373769,10368885,10370017,10369944,10370289,10370666,10370682,10386305,10387274,10399796,10399892,10402987,10403404,10406593,10407244,10436702,10437264,10440289,10440314,10441289,10441284,10441292,10442215,10442278,10442312,10443506,10443753,10465218,10466199,10465215,10466160,10481021,10481162,10482560,10482572,10510366,10510576,10512437,10513570,10513574,10514153,10514389,10514525,10540768,10540800,10542555,10543172,10568475,10568597,10569950,10569951,10570102,10570192,10570203,10570724,10570883,10602797,10603174,10605082,10605960,10608198,10608553,10638012,10638264,10639584,10639814,10639585,10639629,10639587,10639632,10640829,10640832,10640985,10641084,10647766,10647806,10661333,10662504,10664951,10665243,10690414,10690422,10691454,10691598,10691544,10691567,10691553,10691559,10692423,10692473,10692736,10692759,10693176,10693247,10708567,10708536,10710229,10710244,10727758,10727967,10730212,10730289,10757399,10757676,10758511,10758502,10758503,10760536,10760883,10762420,10770764,10770934,10772824,10773157,10777104,10777105,10779512,10779915,10795027,10795540,10798005,10798905,10825279,10825289,10826318,10826463,10826316,10826467,10826343,10826460,10826572,10826573,10826685,10826710,10827315,10827712,10839190,10839255,10840878,10840953,10842551,10842667,10892916,10893809,10893812,10893807,10894176,10894475,10894707,10895460,10895578,10904292,10904563,10906547,10906659,10920101,10920976,10937176,10937417,10938118,10938469,10938123,10938503,10938441,10938543,10939521,10939553,10940744,10940958,10941638,10941640,10948347,10950389,10962786,10962875,10981507,10981555,10983056,10983065,10983058,10983361,10983638,10984082,10984086,10985683,10986178,10999000,10999588,11015753,11016839,11038141,11038437,11038515,11038440,11038497,11038441,11038509,11038782,11038830,11038910,11038922,11039331,11039616,11055934,11056254,11067175,11067427,11070809,11071531,11085300,11086006,11086207,11086021,11086210,11086008,11086183,11087345,11087338,11087537,11087563,11088368,11088596,11107114,11107862,11109391,11120937,11121166,11121284,11139756,11140073,11140333,11140957,11140389,11140962,11140387,11141064,11141288,11141720,11141814,11141961,11141983,11142238,11158807,11159154,11186409,11187045,11187306,11186987,11187361,11186997,11187308,11188295,11188291,11188431,11188855,11189519,11195361,11196071,11199158,11199192,11213381,11213447,11229179,11229717,11229961,11229693,11229965,11229692,11229963,11230940,11231046,11231965,11232188,11232779,11232969,11238792,11239735,11241421,11241947,11244115,11244490,11247498,11247861,11254113,11254308,11268331,11268918,11284091,11285625,11286192,11286197,11286190,11286200,11286188,11286243,11286616,11286651,11286746,11286958,11287866,11288058,11302986,11305640,11306640,11320688,11338941,11339155,11339856,11340025,11339849,11340027,11339870,11340029,11340372,11340395,11341470,11341724,11341836,11342040,11343534,11344818,11361458,11361562,11361941,11362821,11374438,11391995,11392047,11393106,11393193,11393108,11393189,11393110,11393184,11394362,11394558,11394713,11394773,11394864,11394911,11395508,11395772,11397359,11397596,11416443,11417854,11433597,11433604,11434231,11434512,11434246,11434537,11434233,11434510,11436070,11436079,11436308,11436333,11441171,11441555,11452118,11451393,11451392,11452116,11479197,11479195,11481371,11481392,11481370,11481394,11481349,11481390,11481663,11481681,11481823,11481849,11481908,11481921,11493985,11494136,11501222,11501819,11501224,11501786,11514281,11514529,11530238,11530247,11531640,11531703,11531647,11531705,11531653,11531707,11532155,11532247,11532609,11532683,11532863,11533191,11538404,11539053,11544690,11544858,11557184,11558279,11573300,11574823,11574833,11574835,11575603,11575741,11575920,11575913,11576039,11576101,11577118,11578919,11580468,11580663,11587027,11587235,11601187,11601249,11601978,11602170,11616964,11618629,11618740,11618634,11618744,11618641,11618742,11619685,11619919,11620242,11620304,11620437,11626165,11626853,11634795,11635512,11637180,11637997,11651276,11651407,11666413,11667180,11667193,11667178,11667375,11668050,11668189,11678240,11678271,11678761,11679835,11682300,11682378,11711174,11712050,11712116,11712048,11712101,11712046,11712114,11713202,11713357,11713656,11713671,11713790,11713804,11738311,11738469,11738303,11738471,11757008,11757879,11758017,11757880,11757967,11757883,11758095,11758796,11758792,11758869,11758918,11758954,11759015,11767429,11767780,11769408,11770982,11806998,11807040,11807286,11807737,11807875,11816809,11824168,11824498,11824374,11824434,11852920,11854164,11854162,11854170,11854484,11855193,11855249,11865280,11866478,11896360,11896784,11896828,11896781,11896898,11896783,11896821,11896931,11897024,11897072,11904212,11905392,11908557,11908918,11940281,11941358,11941361,11941381,11942534,11942698,11942716,11942794,11951626,11951623,11965059,11965109,11980341,11980356,11980649,11980653,11980655,11981393,11982037,11982931,11982969,11983025,12006114,12006683,12021350,12021377,12021546,12021581,12021542,12021579,12021545,12021611,12022161,12022265,12022452,12022476,12022535,12022549,12024232,12024269,12031103,12031135,12034054,12046136,12046863,12062065,12062067,12062069,12062749,12062982,12063045,12063076,12063112,12065240,12065252,12071103,12071098,12085445,12085518,12101148,12102041,12102065,12102039,12102052,12102037,12102055,12102699,12102788,12103533,12103606,12103740,12103798,4383,5185,4352,5134,20597,20714,47111,47134,47446,47450,48320,48322,48323,48729,49007,49010,49162,49202,49362,49766,57497,70599,70872,85655,86493,86629,86496,86625,86506,86627,87363,87437,87975,88419,89038,97833,99583,126523,127213,127217,127211,128760,128835,128937,133927,136741,138428,139155,145323,157401,172853,173733,173769,173730,173772,173731,173773,174596,174659,174731,174855,175394,175439,177812,178495,193421,193429,210121,211042,211120,211026,211105,211028,211117,212548,212661,212692,212699,212770,212831,212916,213034,213418,215763,213411,215784,219847,220623,247363,247403,248265,248368,248268,248358,248257,248355,249085,249225,249228,249785,249829,257003,257739,260225,260513,261971,261978,288234,289253,289372,289255,289813,289821,290172,290335,290616,290668,299061,299117,313381,313468,315701,331814,333584,333603,334676,335034,337305,339315,339799,339836,339731,339943,344319,344495,358148,358370,372086,372352,373555,373557,373621,373765,373763,374335,374431,374542,374550) ) 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` = 72415 WHERE `RP`.`player` = 72415 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107569,107578,122682,122691,123339,122696,122650,123861,212741,212851,212744,212853,212856,213587,235257,235273,235260,235954,246755,247091,247410,248825,257561,259686,262100,264385,277386,277825,281102,281530,283279,283331,299353,299448,300877,300927,301839,301874,301838,303415,303445,337339,337487,342186,342268,345710,371881,373616,373769,10368885,10370017,10369944,10370289,10370666,10370682,10386305,10387274,10399796,10399892,10402987,10403404,10406593,10407244,10436702,10437264,10440289,10440314,10441289,10441284,10441292,10442215,10442278,10442312,10443506,10443753,10465218,10466199,10465215,10466160,10481021,10481162,10482560,10482572,10510366,10510576,10512437,10513570,10513574,10514153,10514389,10514525,10540768,10540800,10542555,10543172,10568475,10568597,10569950,10569951,10570102,10570192,10570203,10570724,10570883,10602797,10603174,10605082,10605960,10608198,10608553,10638012,10638264,10639584,10639814,10639585,10639629,10639587,10639632,10640829,10640832,10640985,10641084,10647766,10647806,10661333,10662504,10664951,10665243,10690414,10690422,10691454,10691598,10691544,10691567,10691553,10691559,10692423,10692473,10692736,10692759,10693176,10693247,10708567,10708536,10710229,10710244,10727758,10727967,10730212,10730289,10757399,10757676,10758511,10758502,10758503,10760536,10760883,10762420,10770764,10770934,10772824,10773157,10777104,10777105,10779512,10779915,10795027,10795540,10798005,10798905,10825279,10825289,10826318,10826463,10826316,10826467,10826343,10826460,10826572,10826573,10826685,10826710,10827315,10827712,10839190,10839255,10840878,10840953,10842551,10842667,10892916,10893809,10893812,10893807,10894176,10894475,10894707,10895460,10895578,10904292,10904563,10906547,10906659,10920101,10920976,10937176,10937417,10938118,10938469,10938123,10938503,10938441,10938543,10939521,10939553,10940744,10940958,10941638,10941640,10948347,10950389,10962786,10962875,10981507,10981555,10983056,10983065,10983058,10983361,10983638,10984082,10984086,10985683,10986178,10999000,10999588,11015753,11016839,11038141,11038437,11038515,11038440,11038497,11038441,11038509,11038782,11038830,11038910,11038922,11039331,11039616,11055934,11056254,11067175,11067427,11070809,11071531,11085300,11086006,11086207,11086021,11086210,11086008,11086183,11087345,11087338,11087537,11087563,11088368,11088596,11107114,11107862,11109391,11120937,11121166,11121284,11139756,11140073,11140333,11140957,11140389,11140962,11140387,11141064,11141288,11141720,11141814,11141961,11141983,11142238,11158807,11159154,11186409,11187045,11187306,11186987,11187361,11186997,11187308,11188295,11188291,11188431,11188855,11189519,11195361,11196071,11199158,11199192,11213381,11213447,11229179,11229717,11229961,11229693,11229965,11229692,11229963,11230940,11231046,11231965,11232188,11232779,11232969,11238792,11239735,11241421,11241947,11244115,11244490,11247498,11247861,11254113,11254308,11268331,11268918,11284091,11285625,11286192,11286197,11286190,11286200,11286188,11286243,11286616,11286651,11286746,11286958,11287866,11288058,11302986,11305640,11306640,11320688,11338941,11339155,11339856,11340025,11339849,11340027,11339870,11340029,11340372,11340395,11341470,11341724,11341836,11342040,11343534,11344818,11361458,11361562,11361941,11362821,11374438,11391995,11392047,11393106,11393193,11393108,11393189,11393110,11393184,11394362,11394558,11394713,11394773,11394864,11394911,11395508,11395772,11397359,11397596,11416443,11417854,11433597,11433604,11434231,11434512,11434246,11434537,11434233,11434510,11436070,11436079,11436308,11436333,11441171,11441555,11452118,11451393,11451392,11452116,11479197,11479195,11481371,11481392,11481370,11481394,11481349,11481390,11481663,11481681,11481823,11481849,11481908,11481921,11493985,11494136,11501222,11501819,11501224,11501786,11514281,11514529,11530238,11530247,11531640,11531703,11531647,11531705,11531653,11531707,11532155,11532247,11532609,11532683,11532863,11533191,11538404,11539053,11544690,11544858,11557184,11558279,11573300,11574823,11574833,11574835,11575603,11575741,11575920,11575913,11576039,11576101,11577118,11578919,11580468,11580663,11587027,11587235,11601187,11601249,11601978,11602170,11616964,11618629,11618740,11618634,11618744,11618641,11618742,11619685,11619919,11620242,11620304,11620437,11626165,11626853,11634795,11635512,11637180,11637997,11651276,11651407,11666413,11667180,11667193,11667178,11667375,11668050,11668189,11678240,11678271,11678761,11679835,11682300,11682378,11711174,11712050,11712116,11712048,11712101,11712046,11712114,11713202,11713357,11713656,11713671,11713790,11713804,11738311,11738469,11738303,11738471,11757008,11757879,11758017,11757880,11757967,11757883,11758095,11758796,11758792,11758869,11758918,11758954,11759015,11767429,11767780,11769408,11770982,11806998,11807040,11807286,11807737,11807875,11816809,11824168,11824498,11824374,11824434,11852920,11854164,11854162,11854170,11854484,11855193,11855249,11865280,11866478,11896360,11896784,11896828,11896781,11896898,11896783,11896821,11896931,11897024,11897072,11904212,11905392,11908557,11908918,11940281,11941358,11941361,11941381,11942534,11942698,11942716,11942794,11951626,11951623,11965059,11965109,11980341,11980356,11980649,11980653,11980655,11981393,11982037,11982931,11982969,11983025,12006114,12006683,12021350,12021377,12021546,12021581,12021542,12021579,12021545,12021611,12022161,12022265,12022452,12022476,12022535,12022549,12024232,12024269,12031103,12031135,12034054,12046136,12046863,12062065,12062067,12062069,12062749,12062982,12063045,12063076,12063112,12065240,12065252,12071103,12071098,12085445,12085518,12101148,12102041,12102065,12102039,12102052,12102037,12102055,12102699,12102788,12103533,12103606,12103740,12103798,4383,5185,4352,5134,20597,20714,47111,47134,47446,47450,48320,48322,48323,48729,49007,49010,49162,49202,49362,49766,57497,70599,70872,85655,86493,86629,86496,86625,86506,86627,87363,87437,87975,88419,89038,97833,99583,126523,127213,127217,127211,128760,128835,128937,133927,136741,138428,139155,145323,157401,172853,173733,173769,173730,173772,173731,173773,174596,174659,174731,174855,175394,175439,177812,178495,193421,193429,210121,211042,211120,211026,211105,211028,211117,212548,212661,212692,212699,212770,212831,212916,213034,213418,215763,213411,215784,219847,220623,247363,247403,248265,248368,248268,248358,248257,248355,249085,249225,249228,249785,249829,257003,257739,260225,260513,261971,261978,288234,289253,289372,289255,289813,289821,290172,290335,290616,290668,299061,299117,313381,313468,315701,331814,333584,333603,334676,335034,337305,339315,339799,339836,339731,339943,344319,344495,358148,358370,372086,372352,373555,373557,373621,373765,373763,374335,374431,374542,374550) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: