(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` = 23296 WHERE `RP`.`player` = 23296 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107442,107581,121991,122095,122005,122686,122008,122713,122703,123427,214833,215044,214837,215068,214841,215290,234854,235274,234855,235293,247048,246597,248901,257683,259651,259673,261985,261992,264305,264594,277519,277603,281065,282185,283278,283305,299145,299539,300864,300983,301829,301833,301827,301837,303403,303438,337089,337450,342117,342291,345681,345721,371857,372011,373223,373549,10368957,10369180,10370007,10370670,10370702,10386079,10386115,10400478,10400722,10402902,10403697,10406204,10407243,10436813,10437595,10440360,10441375,10441470,10441358,10441423,10441361,10441417,10442152,10442165,10442305,10443341,10465493,10465791,10465661,10465794,10481255,10481562,10482574,10482602,10510805,10511120,10512474,10512605,10513651,10514236,10514292,10514453,10514489,10514523,10514547,10541031,10541171,10544143,10545816,10568598,10570067,10570149,10570229,10570573,10570947,10583893,10602939,10605247,10605909,10608146,10608613,10637720,10637739,10639821,10639847,10639647,10639823,10639825,10639911,10640874,10640877,10640963,10640996,10641040,10641088,10647840,10648153,10661121,10661253,10665241,10665251,10690417,10691520,10691522,10691524,10692444,10692568,10692698,10694004,10693289,10708786,10710192,10710216,10727501,10728098,10730862,10731008,10757433,10757466,10758505,10758501,10758516,10760535,10760570,10760898,10760965,10762341,10762346,10770360,10770408,10773384,10774547,10777320,10777749,10779284,10779870,10794842,10795010,10797876,10798138,10825168,10825260,10826310,10826354,10826311,10826400,10826308,10826486,10826558,10826592,10826643,10827016,10827604,10827976,10839328,10839603,10840949,10841004,10843148,10843216,10892894,10892898,10893910,10893950,10893847,10893951,10893840,10893946,10894347,10894553,10894631,10895462,10895467,10904528,10905112,10906601,10906716,10920786,10921266,10937590,10938184,10938563,10938188,10938501,10938185,10938588,10939554,10939592,10940496,10941097,10941607,10941707,10948682,10949400,10962393,10965122,10981508,10981529,10983051,10983054,10983050,10983556,10983613,10984053,10984130,10985888,10985913,10998763,11000080,11015427,11016407,11038870,11038901,11039324,11055455,11055629,11067587,11067658,11070825,11070837,11085147,11085149,11085918,11085920,11085943,11087204,11087546,11087815,11107054,11107217,11108870,11109368,11121204,11121249,11139769,11139826,11140710,11140885,11140370,11140894,11140858,11140896,11141333,11141620,11141880,11141882,11142002,11142027,11158190,11186455,11187274,11187561,11187309,11187303,11187735,11188289,11188350,11188380,11188395,11189151,11189329,11195624,11196391,11198693,11198780,11213334,11213345,11229117,11229203,11230104,11230099,11230102,11230917,11230939,11232371,11232738,11232829,11238315,11238307,11242140,11242177,11243266,11244489,11246800,11253515,11254055,11267435,11267440,11284066,11284075,11286360,11286501,11286374,11286503,11286375,11286491,11286659,11286670,11286813,11287348,11287936,11288057,11303155,11303416,11306272,11306642,11320856,11323597,11338789,11339845,11339842,11339843,11340391,11341411,11341678,11341904,11342020,11342732,11344788,11359588,11361075,11361671,11361697,11374408,11374500,11392026,11394460,11394704,11394827,11394877,11394966,11396096,11396347,11397328,11397381,11417398,11417430,11433589,11433579,11435998,11436017,11436253,11436288,11440025,11441172,11449706,11451916,11449725,11451501,11479189,11479607,11481648,11481814,11481808,11481905,11481926,11494374,11494459,11500961,11500894,11500892,11514665,11515069,11530239,11531757,11531755,11531765,11532085,11532604,11532616,11532953,11533294,11538573,11540015,11544768,11545013,11557787,11558627,11573314,11573350,11574956,11574952,11574954,11575614,11575787,11575915,11575923,11576087,11576104,11577059,11578462,11579770,11579952,11587830,11588852,11601600,11602699,11602283,11602626,11618704,11618708,11618706,11620024,11620263,11625712,11626166,11634963,11635370,11637689,11637826,11650118,11650168,11666455,11666600,11667169,11667168,11667171,11667492,11667905,11668053,11668119,11668186,11678168,11678182,11680175,11680235,11682329,11683113,11711165,11712037,11712039,11712035,11713225,11713401,11713678,11713725,11713786,11737908,11738037,11737910,11740954,11756970,11756989,11757870,11757873,11757875,11758824,11758864,11758893,11758981,11758984,11767504,11769028,11770884,11771128,11806029,11806027,11805966,11807011,11807554,11807861,11817092,11818229,11823605,11824603,11823606,11824605,11852613,11852644,11853964,11853992,11854020,11854465,11854458,11854696,11855046,11865237,11865509,11896014,11896785,11896786,11896789,11896950,11896981,11896994,11897041,11897109,11897115,11905696,11906415,11907626,11908088,11940730,11941001,11941560,11941003,11941559,11941007,11941603,11942527,11942545,11942656,11942717,11942756,11942804,11949200,11951401,11963440,11965197,11980334,11980347,11981245,11981055,11981249,11981401,11981418,11982273,11982618,11982836,11982891,11982991,11983002,12006082,12006119,12021344,12021347,12021597,12021598,12021601,12022243,12022467,12022519,12024692,12031104,12031359,12033474,12034072,12046864,12047567,12061247,12062989,12063126,12065283,12071069,12085148,12101173,12101179,12102057,12102100,12102058,12102102,12102072,12102104,12102725,12103145,12103656,12103744,12103789,4289,4291,5197,21278,21471,47089,47416,47427,48326,48331,48341,48658,48947,49197,49236,70684,70699,85619,86616,86617,86620,87391,87420,87468,87912,87998,88989,89036,94161,95350,98546,126643,126734,127235,127245,127233,128583,128750,128826,133872,136939,139057,156568,173542,173834,173842,173871,173846,173873,174623,175159,175355,177602,179254,194423,210159,211030,211033,211032,212545,220350,247412,247798,248312,248367,248309,248365,248322,248363,249197,249270,249275,257841,259193,260013,274338,288289,288510,289444,289495,289445,289561,289564,289550,289848,290171,290383,290653,299056,313888,315743,332838,333120,333490,333509,333491,333505,333494,333507,333585,333620,334811,335030,337315,340211,340209,343149,358131,372021,372351,372923,372925,373053,373791,374508,374570,374645) ) 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` = 23296 WHERE `RP`.`player` = 23296 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107442,107581,121991,122095,122005,122686,122008,122713,122703,123427,214833,215044,214837,215068,214841,215290,234854,235274,234855,235293,247048,246597,248901,257683,259651,259673,261985,261992,264305,264594,277519,277603,281065,282185,283278,283305,299145,299539,300864,300983,301829,301833,301827,301837,303403,303438,337089,337450,342117,342291,345681,345721,371857,372011,373223,373549,10368957,10369180,10370007,10370670,10370702,10386079,10386115,10400478,10400722,10402902,10403697,10406204,10407243,10436813,10437595,10440360,10441375,10441470,10441358,10441423,10441361,10441417,10442152,10442165,10442305,10443341,10465493,10465791,10465661,10465794,10481255,10481562,10482574,10482602,10510805,10511120,10512474,10512605,10513651,10514236,10514292,10514453,10514489,10514523,10514547,10541031,10541171,10544143,10545816,10568598,10570067,10570149,10570229,10570573,10570947,10583893,10602939,10605247,10605909,10608146,10608613,10637720,10637739,10639821,10639847,10639647,10639823,10639825,10639911,10640874,10640877,10640963,10640996,10641040,10641088,10647840,10648153,10661121,10661253,10665241,10665251,10690417,10691520,10691522,10691524,10692444,10692568,10692698,10694004,10693289,10708786,10710192,10710216,10727501,10728098,10730862,10731008,10757433,10757466,10758505,10758501,10758516,10760535,10760570,10760898,10760965,10762341,10762346,10770360,10770408,10773384,10774547,10777320,10777749,10779284,10779870,10794842,10795010,10797876,10798138,10825168,10825260,10826310,10826354,10826311,10826400,10826308,10826486,10826558,10826592,10826643,10827016,10827604,10827976,10839328,10839603,10840949,10841004,10843148,10843216,10892894,10892898,10893910,10893950,10893847,10893951,10893840,10893946,10894347,10894553,10894631,10895462,10895467,10904528,10905112,10906601,10906716,10920786,10921266,10937590,10938184,10938563,10938188,10938501,10938185,10938588,10939554,10939592,10940496,10941097,10941607,10941707,10948682,10949400,10962393,10965122,10981508,10981529,10983051,10983054,10983050,10983556,10983613,10984053,10984130,10985888,10985913,10998763,11000080,11015427,11016407,11038870,11038901,11039324,11055455,11055629,11067587,11067658,11070825,11070837,11085147,11085149,11085918,11085920,11085943,11087204,11087546,11087815,11107054,11107217,11108870,11109368,11121204,11121249,11139769,11139826,11140710,11140885,11140370,11140894,11140858,11140896,11141333,11141620,11141880,11141882,11142002,11142027,11158190,11186455,11187274,11187561,11187309,11187303,11187735,11188289,11188350,11188380,11188395,11189151,11189329,11195624,11196391,11198693,11198780,11213334,11213345,11229117,11229203,11230104,11230099,11230102,11230917,11230939,11232371,11232738,11232829,11238315,11238307,11242140,11242177,11243266,11244489,11246800,11253515,11254055,11267435,11267440,11284066,11284075,11286360,11286501,11286374,11286503,11286375,11286491,11286659,11286670,11286813,11287348,11287936,11288057,11303155,11303416,11306272,11306642,11320856,11323597,11338789,11339845,11339842,11339843,11340391,11341411,11341678,11341904,11342020,11342732,11344788,11359588,11361075,11361671,11361697,11374408,11374500,11392026,11394460,11394704,11394827,11394877,11394966,11396096,11396347,11397328,11397381,11417398,11417430,11433589,11433579,11435998,11436017,11436253,11436288,11440025,11441172,11449706,11451916,11449725,11451501,11479189,11479607,11481648,11481814,11481808,11481905,11481926,11494374,11494459,11500961,11500894,11500892,11514665,11515069,11530239,11531757,11531755,11531765,11532085,11532604,11532616,11532953,11533294,11538573,11540015,11544768,11545013,11557787,11558627,11573314,11573350,11574956,11574952,11574954,11575614,11575787,11575915,11575923,11576087,11576104,11577059,11578462,11579770,11579952,11587830,11588852,11601600,11602699,11602283,11602626,11618704,11618708,11618706,11620024,11620263,11625712,11626166,11634963,11635370,11637689,11637826,11650118,11650168,11666455,11666600,11667169,11667168,11667171,11667492,11667905,11668053,11668119,11668186,11678168,11678182,11680175,11680235,11682329,11683113,11711165,11712037,11712039,11712035,11713225,11713401,11713678,11713725,11713786,11737908,11738037,11737910,11740954,11756970,11756989,11757870,11757873,11757875,11758824,11758864,11758893,11758981,11758984,11767504,11769028,11770884,11771128,11806029,11806027,11805966,11807011,11807554,11807861,11817092,11818229,11823605,11824603,11823606,11824605,11852613,11852644,11853964,11853992,11854020,11854465,11854458,11854696,11855046,11865237,11865509,11896014,11896785,11896786,11896789,11896950,11896981,11896994,11897041,11897109,11897115,11905696,11906415,11907626,11908088,11940730,11941001,11941560,11941003,11941559,11941007,11941603,11942527,11942545,11942656,11942717,11942756,11942804,11949200,11951401,11963440,11965197,11980334,11980347,11981245,11981055,11981249,11981401,11981418,11982273,11982618,11982836,11982891,11982991,11983002,12006082,12006119,12021344,12021347,12021597,12021598,12021601,12022243,12022467,12022519,12024692,12031104,12031359,12033474,12034072,12046864,12047567,12061247,12062989,12063126,12065283,12071069,12085148,12101173,12101179,12102057,12102100,12102058,12102102,12102072,12102104,12102725,12103145,12103656,12103744,12103789,4289,4291,5197,21278,21471,47089,47416,47427,48326,48331,48341,48658,48947,49197,49236,70684,70699,85619,86616,86617,86620,87391,87420,87468,87912,87998,88989,89036,94161,95350,98546,126643,126734,127235,127245,127233,128583,128750,128826,133872,136939,139057,156568,173542,173834,173842,173871,173846,173873,174623,175159,175355,177602,179254,194423,210159,211030,211033,211032,212545,220350,247412,247798,248312,248367,248309,248365,248322,248363,249197,249270,249275,257841,259193,260013,274338,288289,288510,289444,289495,289445,289561,289564,289550,289848,290171,290383,290653,299056,313888,315743,332838,333120,333490,333509,333491,333505,333494,333507,333585,333620,334811,335030,337315,340211,340209,343149,358131,372021,372351,372923,372925,373053,373791,374508,374570,374645) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: