(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(139, 140, 207, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 75101 WHERE `RP`.`player` = 75101 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125234,125190,126332,126376,128185,128141,128998,129042,130295,130033,204167,204121,206070,206114,209445,209401,209598,209642,209689,209733,280852,280492,280855,280495,280858,280498,280861,280501,280868,280508,280871,280511,338306,338617,338309,338619,338312,338626,338315,338629,338322,338632,338325,338638,10398262,10398505,10398265,10398507,10398268,10398514,10398271,10398517,10398278,10398520,10398281,10398526,10479224,10479487,10479227,10479489,10479230,10479496,10479233,10479499,10479240,10479502,10479243,10479508,10542422,10542038,10542425,10542041,10542428,10542044,10542431,10542047,10542438,10542054,10542441,10542057,10604438,10604846,10604441,10604849,10604444,10604852,10604447,10604855,10604454,10604862,10604457,10604865,10662784,10663168,10662787,10663171,10662790,10663174,10662793,10663177,10662800,10663184,10662803,10663187,10690380,10691358,10691363,10691368,10692380,10726582,10726366,10726585,10726369,10726588,10726372,10726591,10726375,10726598,10726382,10726601,10726385,10796800,10796872,10796803,10796875,10796806,10796878,10796809,10796881,10796816,10796888,10796819,10796891,10825103,10876318,10876558,10876321,10876561,10876324,10876564,10876327,10876567,10876334,10876574,10876337,10876577,10892854,10893698,10893703,10893708,10894000,10894521,10895372,10919953,10919568,10919955,10919574,10919962,10919577,10919965,10919582,10919968,10919585,10919974,10919587,10937957,10937962,10937965,10939495,10940491,10941589,10964385,10964533,10964390,10964535,10964393,10964542,10964398,10964545,10964401,10964548,10964406,10964554,10982953,10982958,10982961,11014725,11015112,11014730,11015113,11014733,11015119,11014738,11015123,11014741,11015126,11014746,11015132,11038330,11038331,11038337,11069533,11069415,11069538,11069420,11069541,11069422,11069546,11069428,11069549,11069431,11069554,11069433,11084882,11122205,11122302,11122210,11122303,11122212,11122309,11122218,11122313,11122221,11122316,11122223,11122322,11139737,11140300,11140301,11140307,11170504,11170431,11170505,11170436,11170511,11170438,11170515,11170444,11170518,11170447,11170524,11170449,11186649,11186654,11186656,11188252,11213893,11214062,11213898,11214063,11213900,11214069,11213906,11214073,11213909,11214076,11213911,11214082,11266524,11266838,11266529,11266839,11266534,11266845,11266535,11266849,11266542,11266852,11266545,11266858,11284031,11323332,11322974,11323337,11322975,11323342,11322981,11323343,11322985,11323350,11322988,11323353,11322994,11337860,11339774,11339779,11339784,11340350,11374836,11374621,11374841,11374626,11374846,11374628,11374847,11374634,11374854,11374637,11374857,11374639,11418762,11418354,11418763,11418355,11418769,11418361,11418773,11418365,11418776,11418368,11418782,11418374,11434216,11434217,11434223,11464783,11464328,11464788,11464329,11464790,11464335,11464796,11464339,11464799,11464342,11464801,11464348,11513777,11513682,11513782,11513683,11513784,11513689,11513790,11513693,11513793,11513696,11513795,11513702,11556952,11556544,11556953,11556545,11556959,11556551,11556963,11556555,11556966,11556558,11556972,11556564,11573280,11574728,11574733,11574738,11600584,11600367,11600585,11600372,11600591,11600374,11600595,11600380,11600598,11600383,11600604,11600385,11618510,11618511,11618517,11649435,11649243,11649440,11649248,11649442,11649250,11649448,11649256,11649451,11649259,11649453,11649261,11666272,11666264,11667156,11667161,11667166,11667368,11668035,11668171,11671675,11671365,11671680,11671370,11671683,11671372,11671688,11671378,11671691,11671381,11671696,11671383,11739314,11739051,11739319,11739052,11739321,11739058,11739327,11739062,11739330,11739065,11739332,11739071,11757789,11757790,11757796,11758744,11787053,11786762,11787054,11786767,11787060,11786770,11787064,11786775,11787067,11786778,11787073,11786783,11805218,11837194,11836808,11837199,11836813,11837201,11836816,11837207,11836821,11837210,11836824,11837212,11836829,11853418,11853467,11853423,11853468,11853425,11853474,11869040,11868584,11869045,11868589,11869047,11868591,11869053,11868597,11869056,11868600,11869058,11868602,11895844,11895841,11896699,11896704,11896709,11924040,11923825,11924045,11923826,11924047,11923832,11924053,11923836,11924056,11923839,11924058,11923845,11964242,11963739,11964247,11963740,11964249,11963746,11964255,11963750,11964258,11963753,11964260,11963759,11980441,11980442,11980448,12004413,12004031,12004418,12004032,12004423,12004038,12004424,12004042,12004431,12004045,12004434,12004051,12045545,12045353,12045550,12045358,12045555,12045363,12045556,12045364,12045563,12045371,12045566,12045374,12084619,12084403,12084624,12084408,12084629,12084413,12084630,12084414,12084637,12084421,12084640,12084424,20234,20018,20239,20023,20244,20028,20245,20029,20252,20036,20255,20039,47386,71826,71564,71831,71565,71836,71571,71837,71575,71844,71578,71847,71584,85594,111866,111652,111871,111653,111876,111659,111877,111663,111884,111666,111887,111672,127020,127056,127021,127057,127027,127063,158576,158143,158577,158148,158583,158150,158587,158156,158590,158159,158596,158161,192942,192536,192947,192537,192952,192543,192953,192547,192960,192550,192963,192556,210108,232208,232470,232209,232475,232215,232480,232219,232481,232222,232488,232228,232491,273452,273066,273453,273071,273459,273076,273463,273077,273466,273084,273472,273087,312528,312312,312533,312317,312538,312322,312539,312323,312546,312330,312549,312333,331797,333268,333269,333275,333582,357338,357000,357339,357005,357345,357010,357349,357011,357352,357018,357358,357021,371998) ) 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(139, 140, 207, 208) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 75101 WHERE `RP`.`player` = 75101 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125234,125190,126332,126376,128185,128141,128998,129042,130295,130033,204167,204121,206070,206114,209445,209401,209598,209642,209689,209733,280852,280492,280855,280495,280858,280498,280861,280501,280868,280508,280871,280511,338306,338617,338309,338619,338312,338626,338315,338629,338322,338632,338325,338638,10398262,10398505,10398265,10398507,10398268,10398514,10398271,10398517,10398278,10398520,10398281,10398526,10479224,10479487,10479227,10479489,10479230,10479496,10479233,10479499,10479240,10479502,10479243,10479508,10542422,10542038,10542425,10542041,10542428,10542044,10542431,10542047,10542438,10542054,10542441,10542057,10604438,10604846,10604441,10604849,10604444,10604852,10604447,10604855,10604454,10604862,10604457,10604865,10662784,10663168,10662787,10663171,10662790,10663174,10662793,10663177,10662800,10663184,10662803,10663187,10690380,10691358,10691363,10691368,10692380,10726582,10726366,10726585,10726369,10726588,10726372,10726591,10726375,10726598,10726382,10726601,10726385,10796800,10796872,10796803,10796875,10796806,10796878,10796809,10796881,10796816,10796888,10796819,10796891,10825103,10876318,10876558,10876321,10876561,10876324,10876564,10876327,10876567,10876334,10876574,10876337,10876577,10892854,10893698,10893703,10893708,10894000,10894521,10895372,10919953,10919568,10919955,10919574,10919962,10919577,10919965,10919582,10919968,10919585,10919974,10919587,10937957,10937962,10937965,10939495,10940491,10941589,10964385,10964533,10964390,10964535,10964393,10964542,10964398,10964545,10964401,10964548,10964406,10964554,10982953,10982958,10982961,11014725,11015112,11014730,11015113,11014733,11015119,11014738,11015123,11014741,11015126,11014746,11015132,11038330,11038331,11038337,11069533,11069415,11069538,11069420,11069541,11069422,11069546,11069428,11069549,11069431,11069554,11069433,11084882,11122205,11122302,11122210,11122303,11122212,11122309,11122218,11122313,11122221,11122316,11122223,11122322,11139737,11140300,11140301,11140307,11170504,11170431,11170505,11170436,11170511,11170438,11170515,11170444,11170518,11170447,11170524,11170449,11186649,11186654,11186656,11188252,11213893,11214062,11213898,11214063,11213900,11214069,11213906,11214073,11213909,11214076,11213911,11214082,11266524,11266838,11266529,11266839,11266534,11266845,11266535,11266849,11266542,11266852,11266545,11266858,11284031,11323332,11322974,11323337,11322975,11323342,11322981,11323343,11322985,11323350,11322988,11323353,11322994,11337860,11339774,11339779,11339784,11340350,11374836,11374621,11374841,11374626,11374846,11374628,11374847,11374634,11374854,11374637,11374857,11374639,11418762,11418354,11418763,11418355,11418769,11418361,11418773,11418365,11418776,11418368,11418782,11418374,11434216,11434217,11434223,11464783,11464328,11464788,11464329,11464790,11464335,11464796,11464339,11464799,11464342,11464801,11464348,11513777,11513682,11513782,11513683,11513784,11513689,11513790,11513693,11513793,11513696,11513795,11513702,11556952,11556544,11556953,11556545,11556959,11556551,11556963,11556555,11556966,11556558,11556972,11556564,11573280,11574728,11574733,11574738,11600584,11600367,11600585,11600372,11600591,11600374,11600595,11600380,11600598,11600383,11600604,11600385,11618510,11618511,11618517,11649435,11649243,11649440,11649248,11649442,11649250,11649448,11649256,11649451,11649259,11649453,11649261,11666272,11666264,11667156,11667161,11667166,11667368,11668035,11668171,11671675,11671365,11671680,11671370,11671683,11671372,11671688,11671378,11671691,11671381,11671696,11671383,11739314,11739051,11739319,11739052,11739321,11739058,11739327,11739062,11739330,11739065,11739332,11739071,11757789,11757790,11757796,11758744,11787053,11786762,11787054,11786767,11787060,11786770,11787064,11786775,11787067,11786778,11787073,11786783,11805218,11837194,11836808,11837199,11836813,11837201,11836816,11837207,11836821,11837210,11836824,11837212,11836829,11853418,11853467,11853423,11853468,11853425,11853474,11869040,11868584,11869045,11868589,11869047,11868591,11869053,11868597,11869056,11868600,11869058,11868602,11895844,11895841,11896699,11896704,11896709,11924040,11923825,11924045,11923826,11924047,11923832,11924053,11923836,11924056,11923839,11924058,11923845,11964242,11963739,11964247,11963740,11964249,11963746,11964255,11963750,11964258,11963753,11964260,11963759,11980441,11980442,11980448,12004413,12004031,12004418,12004032,12004423,12004038,12004424,12004042,12004431,12004045,12004434,12004051,12045545,12045353,12045550,12045358,12045555,12045363,12045556,12045364,12045563,12045371,12045566,12045374,12084619,12084403,12084624,12084408,12084629,12084413,12084630,12084414,12084637,12084421,12084640,12084424,20234,20018,20239,20023,20244,20028,20245,20029,20252,20036,20255,20039,47386,71826,71564,71831,71565,71836,71571,71837,71575,71844,71578,71847,71584,85594,111866,111652,111871,111653,111876,111659,111877,111663,111884,111666,111887,111672,127020,127056,127021,127057,127027,127063,158576,158143,158577,158148,158583,158150,158587,158156,158590,158159,158596,158161,192942,192536,192947,192537,192952,192543,192953,192547,192960,192550,192963,192556,210108,232208,232470,232209,232475,232215,232480,232219,232481,232222,232488,232228,232491,273452,273066,273453,273071,273459,273076,273463,273077,273466,273084,273472,273087,312528,312312,312533,312317,312538,312322,312539,312323,312546,312330,312549,312333,331797,333268,333269,333275,333582,357338,357000,357339,357005,357345,357010,357349,357011,357352,357018,357358,357021,371998) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: