(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` = 43196 WHERE `RP`.`player` = 43196 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125225,126327,126369,128176,128130,128995,129036,130022,130283,130657,131990,204156,206063,206105,209438,209392,209560,209593,209636,210915,209680,209721,246889,246894,246897,250353,250961,251092,280969,280705,280974,280710,280977,280713,280982,280718,280985,280721,280990,280726,301747,303550,303555,303560,303674,304767,305252,338183,338423,338188,338428,338191,338431,338196,338436,338199,338439,338204,338444,10370769,10370721,10370774,10370726,10370777,10370729,10371771,10371764,10398307,10398575,10398312,10398580,10398315,10398583,10398320,10398588,10398323,10398591,10398328,10398596,10441269,10441274,10441277,10442091,10442243,10443328,10479126,10479413,10479132,10479418,10479135,10479421,10479140,10479426,10479143,10479429,10479145,10479434,10513367,10513372,10513374,10514098,10514365,10514497,10542371,10542179,10542376,10542184,10542379,10542187,10542384,10542192,10542387,10542195,10542392,10542200,10569137,10569142,10569145,10570044,10570146,10570552,10604531,10604843,10604536,10604848,10604539,10604851,10604544,10604856,10604547,10604859,10604552,10604864,10639511,10639535,10639516,10639540,10639519,10639543,10640815,10662757,10663021,10662762,10663026,10662765,10663029,10662770,10663034,10662773,10663037,10662778,10663042,10691429,10691434,10691437,10726459,10726147,10726464,10726152,10726467,10726155,10726472,10726160,10726475,10726163,10726480,10726168,10757384,10758454,10758459,10758464,10760398,10796797,10796894,10796802,10796900,10796805,10796903,10796810,10796908,10796813,10796911,10796818,10796913,10826183,10826188,10826190,10826533,10826636,10827306,10876461,10876627,10876463,10876632,10876470,10876635,10876473,10876640,10876476,10876643,10876482,10876648,10893772,10893773,10893779,10893987,10894519,10895373,10919856,10919544,10919862,10919550,10919865,10919553,10919870,10919558,10919873,10919561,10919875,10919563,10936979,10936990,10964314,10964675,10964320,10964680,10964323,10964683,10964328,10964688,10964331,10964691,10964333,10964696,10981485,10982918,10982923,10982928,11014704,11015157,11014705,11015162,11014711,11015165,11014715,11015170,11014718,11015173,11014724,11015178,11038329,11038334,11038336,11038759,11038880,11038978,11069728,11069437,11069729,11069442,11069735,11069445,11069739,11069450,11069742,11069453,11069748,11069458,11084888,11085712,11085717,11085722,11122206,11122395,11122207,11122400,11122213,11122403,11122217,11122408,11122220,11122411,11122226,11122416,11140249,11140276,11140254,11140277,11140257,11140283,11141180,11141167,11141800,11141972,11170597,11170357,11170602,11170362,11170605,11170365,11170610,11170370,11170613,11170373,11170618,11170378,11186599,11186604,11186607,11188237,11188364,11188467,11213894,11214083,11213895,11214088,11213901,11214091,11213905,11214096,11213908,11214099,11213914,11214104,11229106,11266598,11266763,11266599,11266768,11266605,11266771,11266609,11266776,11266612,11266779,11266618,11266784,11286151,11286156,11286159,11286592,11323214,11323019,11323215,11323024,11323221,11323027,11323225,11323032,11323228,11323035,11323234,11323040,11339773,11339778,11339781,11374908,11374571,11374913,11374576,11374918,11374579,11374919,11374584,11374926,11374587,11374929,11374592,11392931,11392994,11392936,11392995,11392939,11393001,11394285,11394297,11418570,11418495,11418571,11418500,11418577,11418503,11418581,11418508,11418584,11418511,11418590,11418516,11433512,11464686,11464469,11464691,11464474,11464696,11464477,11464697,11464482,11464704,11464485,11464707,11464490,11479153,11479174,11481174,11481179,11481184,11513826,11513657,11513827,11513662,11513833,11513664,11513837,11513670,11513840,11513673,11513846,11513675,11530193,11556976,11556711,11556977,11556716,11556983,11556718,11556987,11556724,11556990,11556727,11556996,11556729,11574790,11574791,11574797,11600631,11600488,11600636,11600489,11600638,11600495,11600644,11600499,11600647,11600502,11600649,11600508,11649484,11649340,11649485,11649341,11649491,11649347,11649495,11649351,11649498,11649354,11649504,11649360,11666274,11671653,11671388,11671658,11671393,11671660,11671398,11671666,11671399,11671669,11671406,11671671,11671409,11739267,11738929,11739268,11738934,11739274,11738939,11739278,11738940,11739281,11738947,11739287,11738950,11787077,11786619,11787078,11786624,11787084,11786629,11787088,11786630,11787091,11786637,11787097,11786640,11805255,11805256,11805262,11806995,11837051,11836858,11837052,11836863,11837058,11836865,11837062,11836871,11837065,11836874,11837071,11836876,11853443,11853444,11853450,11854413,11854680,11855212,11868920,11868681,11868925,11868682,11868927,11868688,11868933,11868692,11868936,11868695,11868938,11868701,11895850,11895840,11896651,11896711,11896656,11896716,11896661,11896721,11896913,11923990,11923896,11923995,11923901,11923998,11923903,11924003,11923909,11924006,11923912,11924011,11923914,11940003,11940841,11940846,11940851,11942508,11964000,11963856,11964005,11963861,11964008,11963864,11964013,11963869,11964016,11963872,11964021,11963877,11980319,11980439,11980444,11980449,11981353,12004389,12004004,12004394,12004009,12004399,12004012,12004400,12004017,12004407,12004020,12004410,12004025,12021420,12021425,12021428,12045617,12045184,12045622,12045189,12045627,12045192,12045628,12045197,12045635,12045200,12045638,12045205,12061914,12061977,12061919,12061978,12061922,12061984,12062552,12062543,12062941,12063053,12084620,12084378,12084625,12084383,12084627,12084386,12084633,12084391,12084636,12084394,12084638,12084399,12101890,12101936,12101895,12101941,12101897,12101944,12102558,12102553,12103518,12103525,12103697,12103700,20281,19993,20286,19998,20289,20001,20294,20006,20297,20009,20302,20014,47384,71681,71393,71686,71398,71689,71401,71694,71406,71697,71409,71702,71414,85609,86407,86480,86412,86485,86415,86490,87293,111769,111625,111774,111630,111777,111633,111782,111638,111785,111641,111790,111646,127007,127077,127012,127082,127014,127085,128624,128773,128859,158405,158117,158410,158122,158413,158125,158418,158130,158421,158133,158426,158138,172824,173647,173652,173655,192869,192653,192874,192658,192877,192661,192882,192666,192885,192669,192890,192674,210109,210925,210960,210930,210965,210932,210970,232373,232493,232378,232498,232381,232501,232386,232506,232389,232509,232394,232514,247352,248129,248134,248136,273427,273187,273432,273192,273434,273194,273440,273200,273443,273203,273445,273205,288827,288849,288832,288854,288834,288857,312695,312193,312700,312198,312703,312200,312708,312206,312711,312209,312716,312211,331810,333243,333266,333248,333271,333250,333276,357433,356977,357438,356982,357440,356984,357446,356990,357449,356993,357451,356995,372785,372790,372792) ) 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` = 43196 WHERE `RP`.`player` = 43196 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125225,126327,126369,128176,128130,128995,129036,130022,130283,130657,131990,204156,206063,206105,209438,209392,209560,209593,209636,210915,209680,209721,246889,246894,246897,250353,250961,251092,280969,280705,280974,280710,280977,280713,280982,280718,280985,280721,280990,280726,301747,303550,303555,303560,303674,304767,305252,338183,338423,338188,338428,338191,338431,338196,338436,338199,338439,338204,338444,10370769,10370721,10370774,10370726,10370777,10370729,10371771,10371764,10398307,10398575,10398312,10398580,10398315,10398583,10398320,10398588,10398323,10398591,10398328,10398596,10441269,10441274,10441277,10442091,10442243,10443328,10479126,10479413,10479132,10479418,10479135,10479421,10479140,10479426,10479143,10479429,10479145,10479434,10513367,10513372,10513374,10514098,10514365,10514497,10542371,10542179,10542376,10542184,10542379,10542187,10542384,10542192,10542387,10542195,10542392,10542200,10569137,10569142,10569145,10570044,10570146,10570552,10604531,10604843,10604536,10604848,10604539,10604851,10604544,10604856,10604547,10604859,10604552,10604864,10639511,10639535,10639516,10639540,10639519,10639543,10640815,10662757,10663021,10662762,10663026,10662765,10663029,10662770,10663034,10662773,10663037,10662778,10663042,10691429,10691434,10691437,10726459,10726147,10726464,10726152,10726467,10726155,10726472,10726160,10726475,10726163,10726480,10726168,10757384,10758454,10758459,10758464,10760398,10796797,10796894,10796802,10796900,10796805,10796903,10796810,10796908,10796813,10796911,10796818,10796913,10826183,10826188,10826190,10826533,10826636,10827306,10876461,10876627,10876463,10876632,10876470,10876635,10876473,10876640,10876476,10876643,10876482,10876648,10893772,10893773,10893779,10893987,10894519,10895373,10919856,10919544,10919862,10919550,10919865,10919553,10919870,10919558,10919873,10919561,10919875,10919563,10936979,10936990,10964314,10964675,10964320,10964680,10964323,10964683,10964328,10964688,10964331,10964691,10964333,10964696,10981485,10982918,10982923,10982928,11014704,11015157,11014705,11015162,11014711,11015165,11014715,11015170,11014718,11015173,11014724,11015178,11038329,11038334,11038336,11038759,11038880,11038978,11069728,11069437,11069729,11069442,11069735,11069445,11069739,11069450,11069742,11069453,11069748,11069458,11084888,11085712,11085717,11085722,11122206,11122395,11122207,11122400,11122213,11122403,11122217,11122408,11122220,11122411,11122226,11122416,11140249,11140276,11140254,11140277,11140257,11140283,11141180,11141167,11141800,11141972,11170597,11170357,11170602,11170362,11170605,11170365,11170610,11170370,11170613,11170373,11170618,11170378,11186599,11186604,11186607,11188237,11188364,11188467,11213894,11214083,11213895,11214088,11213901,11214091,11213905,11214096,11213908,11214099,11213914,11214104,11229106,11266598,11266763,11266599,11266768,11266605,11266771,11266609,11266776,11266612,11266779,11266618,11266784,11286151,11286156,11286159,11286592,11323214,11323019,11323215,11323024,11323221,11323027,11323225,11323032,11323228,11323035,11323234,11323040,11339773,11339778,11339781,11374908,11374571,11374913,11374576,11374918,11374579,11374919,11374584,11374926,11374587,11374929,11374592,11392931,11392994,11392936,11392995,11392939,11393001,11394285,11394297,11418570,11418495,11418571,11418500,11418577,11418503,11418581,11418508,11418584,11418511,11418590,11418516,11433512,11464686,11464469,11464691,11464474,11464696,11464477,11464697,11464482,11464704,11464485,11464707,11464490,11479153,11479174,11481174,11481179,11481184,11513826,11513657,11513827,11513662,11513833,11513664,11513837,11513670,11513840,11513673,11513846,11513675,11530193,11556976,11556711,11556977,11556716,11556983,11556718,11556987,11556724,11556990,11556727,11556996,11556729,11574790,11574791,11574797,11600631,11600488,11600636,11600489,11600638,11600495,11600644,11600499,11600647,11600502,11600649,11600508,11649484,11649340,11649485,11649341,11649491,11649347,11649495,11649351,11649498,11649354,11649504,11649360,11666274,11671653,11671388,11671658,11671393,11671660,11671398,11671666,11671399,11671669,11671406,11671671,11671409,11739267,11738929,11739268,11738934,11739274,11738939,11739278,11738940,11739281,11738947,11739287,11738950,11787077,11786619,11787078,11786624,11787084,11786629,11787088,11786630,11787091,11786637,11787097,11786640,11805255,11805256,11805262,11806995,11837051,11836858,11837052,11836863,11837058,11836865,11837062,11836871,11837065,11836874,11837071,11836876,11853443,11853444,11853450,11854413,11854680,11855212,11868920,11868681,11868925,11868682,11868927,11868688,11868933,11868692,11868936,11868695,11868938,11868701,11895850,11895840,11896651,11896711,11896656,11896716,11896661,11896721,11896913,11923990,11923896,11923995,11923901,11923998,11923903,11924003,11923909,11924006,11923912,11924011,11923914,11940003,11940841,11940846,11940851,11942508,11964000,11963856,11964005,11963861,11964008,11963864,11964013,11963869,11964016,11963872,11964021,11963877,11980319,11980439,11980444,11980449,11981353,12004389,12004004,12004394,12004009,12004399,12004012,12004400,12004017,12004407,12004020,12004410,12004025,12021420,12021425,12021428,12045617,12045184,12045622,12045189,12045627,12045192,12045628,12045197,12045635,12045200,12045638,12045205,12061914,12061977,12061919,12061978,12061922,12061984,12062552,12062543,12062941,12063053,12084620,12084378,12084625,12084383,12084627,12084386,12084633,12084391,12084636,12084394,12084638,12084399,12101890,12101936,12101895,12101941,12101897,12101944,12102558,12102553,12103518,12103525,12103697,12103700,20281,19993,20286,19998,20289,20001,20294,20006,20297,20009,20302,20014,47384,71681,71393,71686,71398,71689,71401,71694,71406,71697,71409,71702,71414,85609,86407,86480,86412,86485,86415,86490,87293,111769,111625,111774,111630,111777,111633,111782,111638,111785,111641,111790,111646,127007,127077,127012,127082,127014,127085,128624,128773,128859,158405,158117,158410,158122,158413,158125,158418,158130,158421,158133,158426,158138,172824,173647,173652,173655,192869,192653,192874,192658,192877,192661,192882,192666,192885,192669,192890,192674,210109,210925,210960,210930,210965,210932,210970,232373,232493,232378,232498,232381,232501,232386,232506,232389,232509,232394,232514,247352,248129,248134,248136,273427,273187,273432,273192,273434,273194,273440,273200,273443,273203,273445,273205,288827,288849,288832,288854,288834,288857,312695,312193,312700,312198,312703,312200,312708,312206,312711,312209,312716,312211,331810,333243,333266,333248,333271,333250,333276,357433,356977,357438,356982,357440,356984,357446,356990,357449,356993,357451,356995,372785,372790,372792) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: