(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` = 74739 WHERE `RP`.`player` = 74739 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125167,126354,128113,129022,130265,204096,206092,209373,209622,209705,280466,280472,280475,280480,280483,280485,303515,303520,303522,303663,304764,305238,338567,338572,338575,338580,338583,338588,10369078,10370572,10370782,10370787,10370792,10371772,10372466,10372529,10398383,10398388,10398391,10398396,10398399,10398404,10440281,10479461,10479466,10479469,10479474,10479477,10479482,10512418,10513306,10513311,10513316,10542011,10542016,10542019,10542024,10542027,10542032,10604916,10604922,10604925,10604930,10604933,10604935,10663119,10663121,10663128,10663131,10663134,10663140,10726196,10726202,10726205,10726210,10726213,10726215,10796991,10796993,10797000,10797003,10797006,10797012,10826195,10826200,10826202,10826537,10876531,10876536,10876539,10876544,10876547,10876552,10892859,10893736,10893737,10893743,10893996,10919711,10919716,10919719,10919724,10919727,10919732,10938005,10938010,10938013,10939487,10940487,10941593,10964531,10964536,10964539,10964544,10964547,10964552,10981490,10982942,10982947,10982952,10983329,11015037,11015042,11015045,11015050,11015053,11015058,11038315,11038320,11038323,11038762,11069389,11069394,11069397,11069402,11069405,11069410,11122467,11122472,11122475,11122480,11122483,11122488,11140261,11140266,11140269,11141178,11141801,11141977,11170309,11170314,11170317,11170322,11170325,11170330,11186623,11186628,11186631,11188239,11214203,11214208,11214211,11214216,11214219,11214224,11229577,11229582,11229585,11230822,11266883,11266888,11266891,11266896,11266899,11266904,11323067,11323072,11323075,11323080,11323083,11323088,11374741,11374746,11374748,11374754,11374757,11374759,11418522,11418523,11418529,11418533,11418536,11418542,11434168,11434169,11434175,11464520,11464521,11464527,11464531,11464534,11464540,11479162,11513586,11513587,11513593,11513597,11513600,11513606,11556687,11556692,11556694,11556700,11556703,11556705,11573277,11574716,11574721,11574726,11575580,11600391,11600396,11600398,11600404,11600407,11600409,11618450,11618451,11618457,11619494,11649339,11649344,11649346,11649352,11649355,11649357,11667085,11667090,11667092,11671461,11671466,11671468,11671474,11671477,11671479,11739098,11739103,11739105,11739111,11739114,11739116,11786788,11786793,11786795,11786801,11786804,11786806,11836883,11836884,11836890,11836894,11836897,11836903,11868777,11868778,11868784,11868788,11868791,11868797,11923681,11923682,11923688,11923692,11923695,11923701,11963882,11963887,11963889,11963895,11963898,11963900,12003958,12003963,12003965,12003971,12003974,12003976,12021331,12045307,12045308,12045314,12045318,12045321,12045327,12084357,12084358,12084364,12084368,12084371,12084377,12101109,19876,19877,19883,19887,19890,19896,71563,71568,71570,71576,71579,71581,86422,86423,86429,87278,111603,111608,111610,111616,111619,111621,126189,158167,158172,158174,158180,158183,158185,192463,192468,192470,192476,192479,192481,232568,232569,232575,232579,232582,232588,273139,273144,273146,273152,273155,273157,312241,312246,312248,312254,312257,312259,333256,333257,333263,333570,357145,357150,357152,357158,357161,357163) ) 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` = 74739 WHERE `RP`.`player` = 74739 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125167,126354,128113,129022,130265,204096,206092,209373,209622,209705,280466,280472,280475,280480,280483,280485,303515,303520,303522,303663,304764,305238,338567,338572,338575,338580,338583,338588,10369078,10370572,10370782,10370787,10370792,10371772,10372466,10372529,10398383,10398388,10398391,10398396,10398399,10398404,10440281,10479461,10479466,10479469,10479474,10479477,10479482,10512418,10513306,10513311,10513316,10542011,10542016,10542019,10542024,10542027,10542032,10604916,10604922,10604925,10604930,10604933,10604935,10663119,10663121,10663128,10663131,10663134,10663140,10726196,10726202,10726205,10726210,10726213,10726215,10796991,10796993,10797000,10797003,10797006,10797012,10826195,10826200,10826202,10826537,10876531,10876536,10876539,10876544,10876547,10876552,10892859,10893736,10893737,10893743,10893996,10919711,10919716,10919719,10919724,10919727,10919732,10938005,10938010,10938013,10939487,10940487,10941593,10964531,10964536,10964539,10964544,10964547,10964552,10981490,10982942,10982947,10982952,10983329,11015037,11015042,11015045,11015050,11015053,11015058,11038315,11038320,11038323,11038762,11069389,11069394,11069397,11069402,11069405,11069410,11122467,11122472,11122475,11122480,11122483,11122488,11140261,11140266,11140269,11141178,11141801,11141977,11170309,11170314,11170317,11170322,11170325,11170330,11186623,11186628,11186631,11188239,11214203,11214208,11214211,11214216,11214219,11214224,11229577,11229582,11229585,11230822,11266883,11266888,11266891,11266896,11266899,11266904,11323067,11323072,11323075,11323080,11323083,11323088,11374741,11374746,11374748,11374754,11374757,11374759,11418522,11418523,11418529,11418533,11418536,11418542,11434168,11434169,11434175,11464520,11464521,11464527,11464531,11464534,11464540,11479162,11513586,11513587,11513593,11513597,11513600,11513606,11556687,11556692,11556694,11556700,11556703,11556705,11573277,11574716,11574721,11574726,11575580,11600391,11600396,11600398,11600404,11600407,11600409,11618450,11618451,11618457,11619494,11649339,11649344,11649346,11649352,11649355,11649357,11667085,11667090,11667092,11671461,11671466,11671468,11671474,11671477,11671479,11739098,11739103,11739105,11739111,11739114,11739116,11786788,11786793,11786795,11786801,11786804,11786806,11836883,11836884,11836890,11836894,11836897,11836903,11868777,11868778,11868784,11868788,11868791,11868797,11923681,11923682,11923688,11923692,11923695,11923701,11963882,11963887,11963889,11963895,11963898,11963900,12003958,12003963,12003965,12003971,12003974,12003976,12021331,12045307,12045308,12045314,12045318,12045321,12045327,12084357,12084358,12084364,12084368,12084371,12084377,12101109,19876,19877,19883,19887,19890,19896,71563,71568,71570,71576,71579,71581,86422,86423,86429,87278,111603,111608,111610,111616,111619,111621,126189,158167,158172,158174,158180,158183,158185,192463,192468,192470,192476,192479,192481,232568,232569,232575,232579,232582,232588,273139,273144,273146,273152,273155,273157,312241,312246,312248,312254,312257,312259,333256,333257,333263,333570,357145,357150,357152,357158,357161,357163) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: