(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(140, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 74300 WHERE `RP`.`player` = 74300 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125195,126380,129053,130300,130665,131998,204124,206118,209568,209651,210923,209740,280513,280518,280521,280526,280529,280534,301758,338543,338548,338551,338556,338559,338564,10398456,10398462,10398465,10398470,10398473,10398475,10479247,10479249,10479256,10479259,10479262,10479268,10512413,10542014,10542017,10542020,10542023,10542030,10542033,10604774,10604777,10604780,10604783,10604790,10604793,10663048,10663051,10663054,10663057,10663064,10663067,10691420,10691421,10691427,10726198,10726201,10726204,10726207,10726214,10726217,10796919,10796921,10796928,10796931,10796934,10796940,10825104,10826218,10826223,10826228,10876725,10876727,10876734,10876737,10876740,10876746,10919641,10919643,10919650,10919653,10919656,10919662,10964557,10964559,10964566,10964569,10964572,10964578,11015014,11015019,11015024,11015025,11015032,11015035,11069344,11069345,11069351,11069355,11069358,11069364,11084874,11085748,11085753,11085758,11087198,11122422,11122423,11122429,11122433,11122436,11122442,11139727,11140250,11140255,11140260,11170360,11170361,11170367,11170371,11170374,11170380,11214084,11214089,11214094,11214095,11214102,11214105,11229579,11229584,11229586,11266909,11266914,11266916,11266922,11266925,11266927,11323092,11323097,11323102,11323103,11323110,11323113,11339776,11339777,11339783,11340353,11340451,11341830,11374643,11374648,11374651,11374656,11374659,11374664,11418329,11418334,11418336,11418342,11418345,11418347,11464423,11464428,11464430,11464436,11464439,11464441,11479154,11513729,11513734,11513736,11513742,11513745,11513747,11531553,11531558,11531560,11531955,11532585,11532798,11556541,11556546,11556549,11556554,11556557,11556562,11600415,11600420,11600422,11600428,11600431,11600433,11616919,11618460,11618465,11618470,11619491,11620214,11620374,11649361,11649366,11649369,11649374,11649377,11649382,11666265,11667072,11667077,11667082,11667364,11668029,11668174,11671411,11671416,11671419,11671424,11671427,11671432,11738882,11738887,11738889,11738895,11738898,11738900,11786740,11786745,11786747,11786753,11786756,11786758,11805213,11805241,11805246,11805251,11806991,11836882,11836887,11836889,11836895,11836898,11836900,11853406,11853411,11853413,11854426,11854677,11855208,11868752,11868757,11868759,11868765,11868768,11868770,11896664,11896669,11896671,11923800,11923805,11923807,11923813,11923816,11923818,11963858,11963863,11963865,11963871,11963874,11963876,12004007,12004008,12004014,12004018,12004021,12004027,12045185,12045190,12045195,12045196,12045203,12045206,12061175,12084501,12084502,12084508,12084512,12084515,12084521,19898,19903,19908,19909,19916,19919,71468,71469,71475,71479,71482,71488,111460,111461,111467,111471,111474,111480,158120,158121,158127,158131,158134,158140,192656,192657,192663,192667,192670,192676,210097,232544,232545,232551,232555,232558,232564,272970,272975,272980,272981,272988,272991,312384,312389,312394,312395,312402,312405,356928,356933,356938,356939,356946,356949) ) 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(140, 207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 74300 WHERE `RP`.`player` = 74300 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125195,126380,129053,130300,130665,131998,204124,206118,209568,209651,210923,209740,280513,280518,280521,280526,280529,280534,301758,338543,338548,338551,338556,338559,338564,10398456,10398462,10398465,10398470,10398473,10398475,10479247,10479249,10479256,10479259,10479262,10479268,10512413,10542014,10542017,10542020,10542023,10542030,10542033,10604774,10604777,10604780,10604783,10604790,10604793,10663048,10663051,10663054,10663057,10663064,10663067,10691420,10691421,10691427,10726198,10726201,10726204,10726207,10726214,10726217,10796919,10796921,10796928,10796931,10796934,10796940,10825104,10826218,10826223,10826228,10876725,10876727,10876734,10876737,10876740,10876746,10919641,10919643,10919650,10919653,10919656,10919662,10964557,10964559,10964566,10964569,10964572,10964578,11015014,11015019,11015024,11015025,11015032,11015035,11069344,11069345,11069351,11069355,11069358,11069364,11084874,11085748,11085753,11085758,11087198,11122422,11122423,11122429,11122433,11122436,11122442,11139727,11140250,11140255,11140260,11170360,11170361,11170367,11170371,11170374,11170380,11214084,11214089,11214094,11214095,11214102,11214105,11229579,11229584,11229586,11266909,11266914,11266916,11266922,11266925,11266927,11323092,11323097,11323102,11323103,11323110,11323113,11339776,11339777,11339783,11340353,11340451,11341830,11374643,11374648,11374651,11374656,11374659,11374664,11418329,11418334,11418336,11418342,11418345,11418347,11464423,11464428,11464430,11464436,11464439,11464441,11479154,11513729,11513734,11513736,11513742,11513745,11513747,11531553,11531558,11531560,11531955,11532585,11532798,11556541,11556546,11556549,11556554,11556557,11556562,11600415,11600420,11600422,11600428,11600431,11600433,11616919,11618460,11618465,11618470,11619491,11620214,11620374,11649361,11649366,11649369,11649374,11649377,11649382,11666265,11667072,11667077,11667082,11667364,11668029,11668174,11671411,11671416,11671419,11671424,11671427,11671432,11738882,11738887,11738889,11738895,11738898,11738900,11786740,11786745,11786747,11786753,11786756,11786758,11805213,11805241,11805246,11805251,11806991,11836882,11836887,11836889,11836895,11836898,11836900,11853406,11853411,11853413,11854426,11854677,11855208,11868752,11868757,11868759,11868765,11868768,11868770,11896664,11896669,11896671,11923800,11923805,11923807,11923813,11923816,11923818,11963858,11963863,11963865,11963871,11963874,11963876,12004007,12004008,12004014,12004018,12004021,12004027,12045185,12045190,12045195,12045196,12045203,12045206,12061175,12084501,12084502,12084508,12084512,12084515,12084521,19898,19903,19908,19909,19916,19919,71468,71469,71475,71479,71482,71488,111460,111461,111467,111471,111474,111480,158120,158121,158127,158131,158134,158140,192656,192657,192663,192667,192670,192676,210097,232544,232545,232551,232555,232558,232564,272970,272975,272980,272981,272988,272991,312384,312389,312394,312395,312402,312405,356928,356933,356938,356939,356946,356949) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: