(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` = 47734 WHERE `RP`.`player` = 47734 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107429,122124,122719,123717,122118,123346,123330,123363,212922,213900,212885,213901,213125,213904,234862,235291,234863,235294,246620,247092,247642,248780,257644,257651,259794,259822,261972,262069,265234,265468,277249,277923,281306,281616,283291,283910,299461,299601,300915,300960,301779,302157,302156,303401,317112,339229,342208,342255,345949,347504,371935,372158,373323,373563,10369199,10369649,10370372,10370612,10385927,10398691,10399854,10400865,10403096,10403582,10406314,10406636,10436778,10437097,10441078,10441286,10441287,10441448,10442107,10443064,10443865,10466198,10477234,10466196,10477429,10481364,10481641,10483349,10483523,10510458,10510821,10512667,10514210,10514302,10514403,10514417,10514512,10514514,10540798,10541376,10543145,10545177,10568437,10570112,10570198,10570205,10570907,10602831,10603097,10605274,10605416,10608242,10608552,10637865,10638270,10639607,10639648,10639606,10640844,10640910,10640947,10641056,10647774,10648111,10661222,10661420,10664830,10665252,10690442,10690570,10691646,10691648,10691658,10692410,10692548,10693203,10693257,10708836,10708174,10710187,10710322,10727694,10727792,10729752,10730861,10757905,10759210,10759303,10758652,10760510,10760946,10762345,10762835,10770870,10771513,10773158,10774483,10777644,10777682,10779321,10780422,10794989,10795247,10798409,10799531,10825156,10826376,10826373,10826402,10826578,10826648,10827187,10827627,10827975,10839204,10839306,10841005,10841071,10843324,10875951,10892895,10893400,10893976,10893974,10893971,10894258,10894714,10894739,10895464,10905400,10905447,10906678,10906698,10921026,10921928,10938613,10939144,10938504,10939175,10938419,10939173,10939571,10939590,10940840,10941121,10941616,10941683,10948556,10963806,10963376,10963808,10981517,10981551,10983027,10983088,10983024,10983018,10983015,10983026,10983445,10983669,10984068,10984075,10985621,10985637,10998992,10999331,11015452,11015510,11036430,11038893,11039152,11055475,11055483,11067254,11068160,11070791,11070839,11084906,11085117,11085899,11085927,11085896,11087251,11087497,11087542,11087825,11088181,11106650,11106689,11109273,11109730,11121142,11121150,11139779,11140019,11140397,11140444,11140417,11141200,11141347,11141847,11141855,11142024,11142061,11157462,11157714,11186303,11186324,11188268,11188394,11188419,11188484,11188661,11195112,11195864,11198738,11198770,11213359,11213457,11229194,11230894,11232137,11232262,11232740,11232915,11238579,11239386,11241038,11242139,11243575,11243746,11246881,11246885,11253526,11254079,11267436,11269051,11284072,11286793,11288010,11303003,11303347,11305363,11306239,11320300,11322665,11337887,11337913,11341786,11342019,11343091,11344036,11359744,11360306,11361633,11361972,11374465,11374483,11391983,11392058,11394476,11394770,11394968,11395099,11395988,11396731,11397052,11416287,11416513,11433610,11440006,11440221,11449443,11451465,11449445,11450570,11479201,11479203,11481680,11481836,11481933,11493993,11494106,11500431,11501221,11500430,11501198,11514310,11514694,11530232,11531790,11531849,11531839,11532190,11532703,11533117,11538477,11539567,11544669,11557115,11557681,11558013,11573317,11573328,11577677,11578949,11580277,11580454,11586873,11587539,11601232,11601423,11602147,11602338,11616977,11619921,11620312,11620332,11620403,11620441,11625472,11625522,11635770,11636060,11637279,11637518,11649974,11650454,11666283,11667297,11667295,11667299,11667668,11668074,11668203,11668222,11678225,11678292,11679333,11679464,11683379,11683392,11711166,11711366,11713442,11713650,11713732,11713776,11713814,11738428,11739488,11738426,11739532,11757018,11757020,11758818,11758920,11759010,11767628,11767781,11769820,11770660,11807759,11807409,11807870,11807930,11817461,11817551,11823353,11825761,11823374,11838765,11852635,11852649,11853497,11853655,11853499,11853656,11853526,11853684,11854447,11854459,11854812,11855233,11865282,11896897,11896895,11896900,11896929,11897026,11897044,11897084,11897097,11904241,11905153,11907385,11907416,11940105,11940360,11942567,11942691,11942752,11949721,11951147,11963444,11965240,11980339,11980725,11980726,11980688,11981397,11981403,11981878,11982373,11982831,11982909,11983010,12006095,12006799,12021398,12022370,12022460,12022559,12024235,12024693,12031117,12031621,12033466,12034281,12046835,12046894,12061234,12061241,12062081,12062086,12062084,12062720,12062961,12063109,12065245,12065289,12071072,12071075,12085909,12085941,12101165,12102147,12102145,12103101,12103531,12103695,12103721,4468,4480,5866,21370,21522,46526,47136,47426,47428,48402,48941,48938,49154,49186,49372,49489,57286,57316,59766,70526,85660,85674,87366,87496,87911,88570,88844,94999,95228,97560,98614,98634,126598,126809,128630,128915,133776,133916,136154,136178,139160,157205,173816,173818,173819,174753,174999,175432,175440,177320,179329,194202,194424,210378,212732,212795,213087,213249,214174,214682,214564,214797,220352,220570,247387,247391,248379,248339,248338,249099,249172,249245,249606,249824,250025,257128,257623,261124,261301,272694,273692,288448,289578,289511,289510,289853,289862,290082,290325,290622,299065,299115,313997,316035,316326,333622,333627,334754,334955,335005,335165,337330,337398,341606,341644,342904,341658,344479,345131,358159,372603,372635,373006,373007,373003,373818,374456,374444,374569,374641) ) 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` = 47734 WHERE `RP`.`player` = 47734 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107429,122124,122719,123717,122118,123346,123330,123363,212922,213900,212885,213901,213125,213904,234862,235291,234863,235294,246620,247092,247642,248780,257644,257651,259794,259822,261972,262069,265234,265468,277249,277923,281306,281616,283291,283910,299461,299601,300915,300960,301779,302157,302156,303401,317112,339229,342208,342255,345949,347504,371935,372158,373323,373563,10369199,10369649,10370372,10370612,10385927,10398691,10399854,10400865,10403096,10403582,10406314,10406636,10436778,10437097,10441078,10441286,10441287,10441448,10442107,10443064,10443865,10466198,10477234,10466196,10477429,10481364,10481641,10483349,10483523,10510458,10510821,10512667,10514210,10514302,10514403,10514417,10514512,10514514,10540798,10541376,10543145,10545177,10568437,10570112,10570198,10570205,10570907,10602831,10603097,10605274,10605416,10608242,10608552,10637865,10638270,10639607,10639648,10639606,10640844,10640910,10640947,10641056,10647774,10648111,10661222,10661420,10664830,10665252,10690442,10690570,10691646,10691648,10691658,10692410,10692548,10693203,10693257,10708836,10708174,10710187,10710322,10727694,10727792,10729752,10730861,10757905,10759210,10759303,10758652,10760510,10760946,10762345,10762835,10770870,10771513,10773158,10774483,10777644,10777682,10779321,10780422,10794989,10795247,10798409,10799531,10825156,10826376,10826373,10826402,10826578,10826648,10827187,10827627,10827975,10839204,10839306,10841005,10841071,10843324,10875951,10892895,10893400,10893976,10893974,10893971,10894258,10894714,10894739,10895464,10905400,10905447,10906678,10906698,10921026,10921928,10938613,10939144,10938504,10939175,10938419,10939173,10939571,10939590,10940840,10941121,10941616,10941683,10948556,10963806,10963376,10963808,10981517,10981551,10983027,10983088,10983024,10983018,10983015,10983026,10983445,10983669,10984068,10984075,10985621,10985637,10998992,10999331,11015452,11015510,11036430,11038893,11039152,11055475,11055483,11067254,11068160,11070791,11070839,11084906,11085117,11085899,11085927,11085896,11087251,11087497,11087542,11087825,11088181,11106650,11106689,11109273,11109730,11121142,11121150,11139779,11140019,11140397,11140444,11140417,11141200,11141347,11141847,11141855,11142024,11142061,11157462,11157714,11186303,11186324,11188268,11188394,11188419,11188484,11188661,11195112,11195864,11198738,11198770,11213359,11213457,11229194,11230894,11232137,11232262,11232740,11232915,11238579,11239386,11241038,11242139,11243575,11243746,11246881,11246885,11253526,11254079,11267436,11269051,11284072,11286793,11288010,11303003,11303347,11305363,11306239,11320300,11322665,11337887,11337913,11341786,11342019,11343091,11344036,11359744,11360306,11361633,11361972,11374465,11374483,11391983,11392058,11394476,11394770,11394968,11395099,11395988,11396731,11397052,11416287,11416513,11433610,11440006,11440221,11449443,11451465,11449445,11450570,11479201,11479203,11481680,11481836,11481933,11493993,11494106,11500431,11501221,11500430,11501198,11514310,11514694,11530232,11531790,11531849,11531839,11532190,11532703,11533117,11538477,11539567,11544669,11557115,11557681,11558013,11573317,11573328,11577677,11578949,11580277,11580454,11586873,11587539,11601232,11601423,11602147,11602338,11616977,11619921,11620312,11620332,11620403,11620441,11625472,11625522,11635770,11636060,11637279,11637518,11649974,11650454,11666283,11667297,11667295,11667299,11667668,11668074,11668203,11668222,11678225,11678292,11679333,11679464,11683379,11683392,11711166,11711366,11713442,11713650,11713732,11713776,11713814,11738428,11739488,11738426,11739532,11757018,11757020,11758818,11758920,11759010,11767628,11767781,11769820,11770660,11807759,11807409,11807870,11807930,11817461,11817551,11823353,11825761,11823374,11838765,11852635,11852649,11853497,11853655,11853499,11853656,11853526,11853684,11854447,11854459,11854812,11855233,11865282,11896897,11896895,11896900,11896929,11897026,11897044,11897084,11897097,11904241,11905153,11907385,11907416,11940105,11940360,11942567,11942691,11942752,11949721,11951147,11963444,11965240,11980339,11980725,11980726,11980688,11981397,11981403,11981878,11982373,11982831,11982909,11983010,12006095,12006799,12021398,12022370,12022460,12022559,12024235,12024693,12031117,12031621,12033466,12034281,12046835,12046894,12061234,12061241,12062081,12062086,12062084,12062720,12062961,12063109,12065245,12065289,12071072,12071075,12085909,12085941,12101165,12102147,12102145,12103101,12103531,12103695,12103721,4468,4480,5866,21370,21522,46526,47136,47426,47428,48402,48941,48938,49154,49186,49372,49489,57286,57316,59766,70526,85660,85674,87366,87496,87911,88570,88844,94999,95228,97560,98614,98634,126598,126809,128630,128915,133776,133916,136154,136178,139160,157205,173816,173818,173819,174753,174999,175432,175440,177320,179329,194202,194424,210378,212732,212795,213087,213249,214174,214682,214564,214797,220352,220570,247387,247391,248379,248339,248338,249099,249172,249245,249606,249824,250025,257128,257623,261124,261301,272694,273692,288448,289578,289511,289510,289853,289862,290082,290325,290622,299065,299115,313997,316035,316326,333622,333627,334754,334955,335005,335165,337330,337398,341606,341644,342904,341658,344479,345131,358159,372603,372635,373006,373007,373003,373818,374456,374444,374569,374641) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: