(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` = 11608 WHERE `RP`.`player` = 11608 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107452,107454,122012,122872,121984,123190,121987,123147,121989,122017,212728,213077,212739,213080,212733,214594,235907,237466,246505,247707,257367,259678,259778,261967,262099,264386,265634,277039,281144,282052,283273,283903,299103,299470,300873,300982,301776,302215,301777,303439,303457,337251,337449,342034,345693,345909,371923,372121,373218,373308,10368387,10369927,10369882,10370077,10370588,10370593,10386080,10386246,10399817,10399853,10402958,10403371,10406271,10406323,10436950,10437126,10464242,10464899,10464397,10464902,10481038,10481318,10482815,10482780,10510344,10510357,10512472,10512485,10513604,10513601,10514108,10514381,10514388,10514518,10514519,10540709,10540919,10542674,10543146,10568480,10568609,10570175,10570407,10570697,10570936,10602832,10602954,10605126,10605244,10608196,10608601,10637894,10637934,10639608,10639907,10639610,10639832,10639746,10639910,10640858,10640919,10640955,10641013,10641089,10641516,10647891,10647985,10661277,10662435,10664852,10664973,10692462,10692482,10692567,10692744,10693213,10694401,10708606,10709000,10710386,10710930,10728637,10728787,10730041,10730423,10757394,10757441,10758661,10758729,10758665,10760484,10760528,10760914,10760982,10762342,10762684,10770933,10770869,10773862,10774524,10778667,10779119,10779916,10782317,10795028,10795539,10798562,10799144,10825192,10826288,10826290,10826509,10826292,10826584,10826597,10826663,10826814,10827899,10839274,10839389,10840886,10841095,10842539,10842832,10893394,10893688,10894024,10894105,10894561,10894600,10895394,10895660,10905018,10905488,10906563,10906608,10921297,10921476,10937064,10938103,10938131,10938109,10939523,10939557,10940819,10941110,10941637,10941694,10949192,10950567,10963987,10965230,10981532,10981902,10983060,10983069,10983062,10983505,10983531,10984124,10985321,10985822,10985840,10999481,10999864,11015451,11017302,11036468,11037330,11038492,11038623,11038490,11038777,11038789,11038948,11038961,11039433,11039440,11055536,11056041,11067168,11068660,11070805,11072252,11085100,11085380,11086100,11086390,11086102,11086391,11086394,11086457,11087270,11087272,11087512,11087538,11087623,11089521,11107218,11107552,11109580,11120637,11121123,11121448,11140066,11140392,11140492,11140393,11140490,11140425,11140488,11141516,11141848,11141872,11141981,11142038,11158524,11186350,11186357,11187273,11187214,11187216,11188293,11188322,11188425,11188998,11189225,11196072,11198822,11199174,11213382,11229168,11229196,11229976,11230343,11230279,11230434,11229991,11230285,11230841,11231129,11232121,11232464,11232760,11232935,11239341,11239572,11241948,11242711,11243742,11244337,11246851,11247838,11253752,11253826,11267793,11268205,11284089,11284100,11286307,11286448,11286320,11286439,11286349,11286442,11286627,11286677,11287062,11287156,11287810,11287862,11303076,11303236,11305398,11305479,11320920,11320988,11337917,11338163,11339853,11339858,11339867,11340375,11341613,11341597,11341945,11343674,11344084,11360109,11361005,11361632,11361640,11374493,11374514,11392009,11392057,11393138,11393147,11393232,11394305,11394765,11394938,11395380,11395599,11397339,11397824,11416058,11416878,11433620,11434384,11434402,11434543,11436025,11436033,11436223,11436259,11440459,11441095,11449120,11449218,11449121,11449726,11479212,11479228,11481830,11481912,11494001,11494115,11500384,11500534,11500531,11500641,11514174,11515077,11530225,11532142,11532666,11532668,11533065,11533365,11538433,11538574,11543921,11544008,11557498,11557612,11573315,11574862,11574864,11574860,11575630,11575954,11576048,11577957,11578205,11579869,11580022,11587540,11587768,11601410,11601494,11602496,11602770,11616960,11616981,11619626,11620306,11620324,11620444,11620460,11624890,11626126,11635202,11636443,11637811,11648986,11650248,11650469,11666551,11666590,11667311,11667304,11667318,11667605,11667633,11668082,11668134,11668207,11668271,11678246,11678226,11679244,11680085,11683478,11684707,11711180,11712161,11712132,11712165,11712159,11712162,11713277,11713543,11713667,11713722,11713799,11713831,11738429,11739709,11738427,11739705,11756997,11758772,11758919,11758924,11758990,11759012,11767811,11768041,11771240,11771285,11805601,11806249,11805580,11806250,11805534,11805582,11807068,11807071,11807366,11807665,11807887,11818434,11818824,11824276,11836753,11824274,11838764,11852603,11852891,11853598,11853780,11853761,11853778,11853788,11854464,11854471,11854986,11855291,11866342,11896223,11896319,11896747,11896806,11896764,11896808,11896763,11896887,11896930,11896980,11897010,11897096,11905044,11906258,11907520,11907834,11940290,11942558,11942657,11942670,11942790,11942821,11949524,11963462,11964286,11980374,11980893,11981244,11980619,11980886,11980621,11980888,11981394,11981818,11982878,11982914,11982993,12006096,12006807,12021368,12021540,12021562,12021543,12021578,12021544,12021586,12022118,12022150,12022392,12022408,12022534,12022554,12024343,12024568,12031139,12031772,12033504,12034044,12046150,12047562,12061225,12062079,12062107,12062076,12062739,12062746,12062998,12063010,12063100,12063110,12065163,12065264,12071140,12071145,12085127,12087451,12101178,12102125,12102016,12102122,12102018,12102121,12103073,12103296,12103544,12103602,12103763,12103792,4427,4418,5865,20579,21363,47184,47396,47449,48128,48125,48129,48405,48825,49203,49231,70633,85668,87326,87446,87530,88359,88928,94173,94177,97558,98980,99586,127147,127130,127141,128681,128836,128850,128916,128926,133914,134582,136757,136856,138470,139097,156459,158680,172852,172958,174620,174810,175436,178028,178962,194246,194308,210127,210158,211131,211154,211134,212702,212772,213330,214353,213521,213704,213691,216435,220408,233052,247384,248225,248228,248229,249262,249947,257463,257578,261228,274337,288257,288333,290149,299138,313928,316359,316437,331818,333341,333343,333345,333598,334875,335164,337316,339233,340273,340961,340275,340967,344447,345192,358141,358367,372100,373803,374331,374440) ) 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` = 11608 WHERE `RP`.`player` = 11608 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107452,107454,122012,122872,121984,123190,121987,123147,121989,122017,212728,213077,212739,213080,212733,214594,235907,237466,246505,247707,257367,259678,259778,261967,262099,264386,265634,277039,281144,282052,283273,283903,299103,299470,300873,300982,301776,302215,301777,303439,303457,337251,337449,342034,345693,345909,371923,372121,373218,373308,10368387,10369927,10369882,10370077,10370588,10370593,10386080,10386246,10399817,10399853,10402958,10403371,10406271,10406323,10436950,10437126,10464242,10464899,10464397,10464902,10481038,10481318,10482815,10482780,10510344,10510357,10512472,10512485,10513604,10513601,10514108,10514381,10514388,10514518,10514519,10540709,10540919,10542674,10543146,10568480,10568609,10570175,10570407,10570697,10570936,10602832,10602954,10605126,10605244,10608196,10608601,10637894,10637934,10639608,10639907,10639610,10639832,10639746,10639910,10640858,10640919,10640955,10641013,10641089,10641516,10647891,10647985,10661277,10662435,10664852,10664973,10692462,10692482,10692567,10692744,10693213,10694401,10708606,10709000,10710386,10710930,10728637,10728787,10730041,10730423,10757394,10757441,10758661,10758729,10758665,10760484,10760528,10760914,10760982,10762342,10762684,10770933,10770869,10773862,10774524,10778667,10779119,10779916,10782317,10795028,10795539,10798562,10799144,10825192,10826288,10826290,10826509,10826292,10826584,10826597,10826663,10826814,10827899,10839274,10839389,10840886,10841095,10842539,10842832,10893394,10893688,10894024,10894105,10894561,10894600,10895394,10895660,10905018,10905488,10906563,10906608,10921297,10921476,10937064,10938103,10938131,10938109,10939523,10939557,10940819,10941110,10941637,10941694,10949192,10950567,10963987,10965230,10981532,10981902,10983060,10983069,10983062,10983505,10983531,10984124,10985321,10985822,10985840,10999481,10999864,11015451,11017302,11036468,11037330,11038492,11038623,11038490,11038777,11038789,11038948,11038961,11039433,11039440,11055536,11056041,11067168,11068660,11070805,11072252,11085100,11085380,11086100,11086390,11086102,11086391,11086394,11086457,11087270,11087272,11087512,11087538,11087623,11089521,11107218,11107552,11109580,11120637,11121123,11121448,11140066,11140392,11140492,11140393,11140490,11140425,11140488,11141516,11141848,11141872,11141981,11142038,11158524,11186350,11186357,11187273,11187214,11187216,11188293,11188322,11188425,11188998,11189225,11196072,11198822,11199174,11213382,11229168,11229196,11229976,11230343,11230279,11230434,11229991,11230285,11230841,11231129,11232121,11232464,11232760,11232935,11239341,11239572,11241948,11242711,11243742,11244337,11246851,11247838,11253752,11253826,11267793,11268205,11284089,11284100,11286307,11286448,11286320,11286439,11286349,11286442,11286627,11286677,11287062,11287156,11287810,11287862,11303076,11303236,11305398,11305479,11320920,11320988,11337917,11338163,11339853,11339858,11339867,11340375,11341613,11341597,11341945,11343674,11344084,11360109,11361005,11361632,11361640,11374493,11374514,11392009,11392057,11393138,11393147,11393232,11394305,11394765,11394938,11395380,11395599,11397339,11397824,11416058,11416878,11433620,11434384,11434402,11434543,11436025,11436033,11436223,11436259,11440459,11441095,11449120,11449218,11449121,11449726,11479212,11479228,11481830,11481912,11494001,11494115,11500384,11500534,11500531,11500641,11514174,11515077,11530225,11532142,11532666,11532668,11533065,11533365,11538433,11538574,11543921,11544008,11557498,11557612,11573315,11574862,11574864,11574860,11575630,11575954,11576048,11577957,11578205,11579869,11580022,11587540,11587768,11601410,11601494,11602496,11602770,11616960,11616981,11619626,11620306,11620324,11620444,11620460,11624890,11626126,11635202,11636443,11637811,11648986,11650248,11650469,11666551,11666590,11667311,11667304,11667318,11667605,11667633,11668082,11668134,11668207,11668271,11678246,11678226,11679244,11680085,11683478,11684707,11711180,11712161,11712132,11712165,11712159,11712162,11713277,11713543,11713667,11713722,11713799,11713831,11738429,11739709,11738427,11739705,11756997,11758772,11758919,11758924,11758990,11759012,11767811,11768041,11771240,11771285,11805601,11806249,11805580,11806250,11805534,11805582,11807068,11807071,11807366,11807665,11807887,11818434,11818824,11824276,11836753,11824274,11838764,11852603,11852891,11853598,11853780,11853761,11853778,11853788,11854464,11854471,11854986,11855291,11866342,11896223,11896319,11896747,11896806,11896764,11896808,11896763,11896887,11896930,11896980,11897010,11897096,11905044,11906258,11907520,11907834,11940290,11942558,11942657,11942670,11942790,11942821,11949524,11963462,11964286,11980374,11980893,11981244,11980619,11980886,11980621,11980888,11981394,11981818,11982878,11982914,11982993,12006096,12006807,12021368,12021540,12021562,12021543,12021578,12021544,12021586,12022118,12022150,12022392,12022408,12022534,12022554,12024343,12024568,12031139,12031772,12033504,12034044,12046150,12047562,12061225,12062079,12062107,12062076,12062739,12062746,12062998,12063010,12063100,12063110,12065163,12065264,12071140,12071145,12085127,12087451,12101178,12102125,12102016,12102122,12102018,12102121,12103073,12103296,12103544,12103602,12103763,12103792,4427,4418,5865,20579,21363,47184,47396,47449,48128,48125,48129,48405,48825,49203,49231,70633,85668,87326,87446,87530,88359,88928,94173,94177,97558,98980,99586,127147,127130,127141,128681,128836,128850,128916,128926,133914,134582,136757,136856,138470,139097,156459,158680,172852,172958,174620,174810,175436,178028,178962,194246,194308,210127,210158,211131,211154,211134,212702,212772,213330,214353,213521,213704,213691,216435,220408,233052,247384,248225,248228,248229,249262,249947,257463,257578,261228,274337,288257,288333,290149,299138,313928,316359,316437,331818,333341,333343,333345,333598,334875,335164,337316,339233,340273,340961,340275,340967,344447,345192,358141,358367,372100,373803,374331,374440) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: