(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` = 17151 WHERE `RP`.`player` = 17151 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125187,126377,128138,129045,130290,204116,206113,209400,209643,209730,280586,280592,280595,280600,280603,280605,338425,338427,338434,338437,338440,338446,10369080,10370569,10370770,10370775,10370780,10398408,10398414,10398417,10398422,10398425,10398427,10479415,10479417,10479424,10479427,10479430,10479436,10541965,10541967,10541974,10541977,10541980,10541986,10569163,10569168,10569170,10570036,10604892,10604898,10604901,10604906,10604909,10604911,10639513,10639518,10639520,10663214,10663220,10663223,10663228,10663231,10663233,10691405,10691410,10691413,10726339,10726344,10726347,10726352,10726355,10726360,10758432,10758433,10758439,10796871,10796873,10796880,10796883,10796886,10796892,10876581,10876583,10876590,10876593,10876596,10876602,10919762,10919765,10919768,10919771,10919778,10919781,10936989,10937982,10937987,10937992,10964461,10964463,10964470,10964473,10964476,10964482,11014990,11014995,11015000,11015001,11015008,11015011,11036235,11069440,11069441,11069447,11069451,11069454,11069460,11122348,11122353,11122358,11122359,11122366,11122369,11140239,11140244,11140246,11141176,11170335,11170340,11170342,11170348,11170351,11170353,11186275,11214109,11214114,11214116,11214122,11214125,11214127,11266980,11266985,11266990,11266991,11266998,11267001,11322948,11322953,11322958,11322959,11322966,11322969,11337862,11339750,11339755,11339760,11374597,11374602,11374604,11374610,11374613,11374615,11418426,11418427,11418433,11418437,11418440,11418446,11433506,11434142,11434147,11434152,11435327,11435978,11436206,11464399,11464404,11464406,11464412,11464415,11464417,11513490,11513491,11513497,11513501,11513504,11513510,11556784,11556785,11556791,11556795,11556798,11556804,11574718,11574719,11574725,11600463,11600468,11600470,11600476,11600479,11600481,11649147,11649152,11649154,11649160,11649163,11649165,11671294,11671295,11671301,11671305,11671308,11671314,11711965,11711966,11711972,11739026,11739031,11739033,11739039,11739042,11739044,11786717,11786718,11786724,11786728,11786731,11786737,11805206,11836811,11836812,11836818,11836822,11836825,11836831,11852598,11868729,11868730,11868736,11868740,11868743,11868749,11923777,11923778,11923784,11923788,11923791,11923797,11963737,11963742,11963747,11963748,11963755,11963758,12004101,12004106,12004111,12004112,12004119,12004122,12021435,12021436,12021442,12021988,12045355,12045356,12045362,12045366,12045369,12045375,12084549,12084550,12084556,12084560,12084563,12084569,19850,19855,19860,19861,19868,19871,71466,71471,71476,71477,71484,71487,85595,86420,86425,86430,111650,111655,111660,111661,111668,111671,158334,158339,158344,158345,158352,158355,173614,173615,173621,192464,192465,192471,192475,192478,192484,232712,232713,232719,232723,232726,232732,272996,272997,273003,273007,273010,273016,312434,312435,312441,312445,312448,312454,357074,357075,357081,357085,357088,357094,371988) ) 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` = 17151 WHERE `RP`.`player` = 17151 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125187,126377,128138,129045,130290,204116,206113,209400,209643,209730,280586,280592,280595,280600,280603,280605,338425,338427,338434,338437,338440,338446,10369080,10370569,10370770,10370775,10370780,10398408,10398414,10398417,10398422,10398425,10398427,10479415,10479417,10479424,10479427,10479430,10479436,10541965,10541967,10541974,10541977,10541980,10541986,10569163,10569168,10569170,10570036,10604892,10604898,10604901,10604906,10604909,10604911,10639513,10639518,10639520,10663214,10663220,10663223,10663228,10663231,10663233,10691405,10691410,10691413,10726339,10726344,10726347,10726352,10726355,10726360,10758432,10758433,10758439,10796871,10796873,10796880,10796883,10796886,10796892,10876581,10876583,10876590,10876593,10876596,10876602,10919762,10919765,10919768,10919771,10919778,10919781,10936989,10937982,10937987,10937992,10964461,10964463,10964470,10964473,10964476,10964482,11014990,11014995,11015000,11015001,11015008,11015011,11036235,11069440,11069441,11069447,11069451,11069454,11069460,11122348,11122353,11122358,11122359,11122366,11122369,11140239,11140244,11140246,11141176,11170335,11170340,11170342,11170348,11170351,11170353,11186275,11214109,11214114,11214116,11214122,11214125,11214127,11266980,11266985,11266990,11266991,11266998,11267001,11322948,11322953,11322958,11322959,11322966,11322969,11337862,11339750,11339755,11339760,11374597,11374602,11374604,11374610,11374613,11374615,11418426,11418427,11418433,11418437,11418440,11418446,11433506,11434142,11434147,11434152,11435327,11435978,11436206,11464399,11464404,11464406,11464412,11464415,11464417,11513490,11513491,11513497,11513501,11513504,11513510,11556784,11556785,11556791,11556795,11556798,11556804,11574718,11574719,11574725,11600463,11600468,11600470,11600476,11600479,11600481,11649147,11649152,11649154,11649160,11649163,11649165,11671294,11671295,11671301,11671305,11671308,11671314,11711965,11711966,11711972,11739026,11739031,11739033,11739039,11739042,11739044,11786717,11786718,11786724,11786728,11786731,11786737,11805206,11836811,11836812,11836818,11836822,11836825,11836831,11852598,11868729,11868730,11868736,11868740,11868743,11868749,11923777,11923778,11923784,11923788,11923791,11923797,11963737,11963742,11963747,11963748,11963755,11963758,12004101,12004106,12004111,12004112,12004119,12004122,12021435,12021436,12021442,12021988,12045355,12045356,12045362,12045366,12045369,12045375,12084549,12084550,12084556,12084560,12084563,12084569,19850,19855,19860,19861,19868,19871,71466,71471,71476,71477,71484,71487,85595,86420,86425,86430,111650,111655,111660,111661,111668,111671,158334,158339,158344,158345,158352,158355,173614,173615,173621,192464,192465,192471,192475,192478,192484,232712,232713,232719,232723,232726,232732,272996,272997,273003,273007,273010,273016,312434,312435,312441,312445,312448,312454,357074,357075,357081,357085,357088,357094,371988) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: