(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` = 38898 WHERE `RP`.`player` = 38898 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125226,125184,126329,126370,128178,128135,128994,129038,130287,130025,131991,204159,204115,206065,206108,209440,209395,209559,209594,209638,209681,209725,280732,280491,280735,280493,280738,280500,280741,280503,280748,280506,280751,280512,301762,338137,338498,338139,338501,338146,338504,338149,338507,338152,338514,338158,338517,10369073,10398166,10398530,10398169,10398533,10398172,10398536,10398175,10398539,10398182,10398546,10398185,10398549,10441200,10441201,10441207,10479078,10479272,10479084,10479275,10479087,10479278,10479092,10479281,10479095,10479288,10479097,10479291,10542420,10542062,10542426,10542065,10542429,10542068,10542434,10542071,10542437,10542078,10542439,10542081,10604436,10604678,10604442,10604681,10604445,10604684,10604450,10604687,10604453,10604694,10604455,10604697,10662950,10663000,10662956,10663003,10662959,10663006,10662964,10663009,10662967,10663016,10662969,10663019,10726485,10726222,10726487,10726225,10726494,10726228,10726497,10726231,10726500,10726238,10726506,10726241,10796680,10797016,10796683,10797019,10796686,10797022,10796689,10797025,10796696,10797032,10796699,10797035,10876414,10876750,10876417,10876753,10876420,10876756,10876423,10876759,10876430,10876766,10876433,10876769,10919857,10919594,10919859,10919597,10919866,10919600,10919869,10919603,10919872,10919610,10919878,10919613,10964196,10964630,10964199,10964633,10964202,10964636,10964205,10964639,10964212,10964646,10964215,10964649,10982944,10982945,10982951,11014894,11015062,11014899,11015067,11014904,11015072,11014905,11015073,11014912,11015080,11014915,11015083,11069534,11069438,11069539,11069443,11069544,11069448,11069545,11069449,11069552,11069456,11069555,11069459,11085773,11085778,11085780,11122012,11122470,11122017,11122471,11122022,11122477,11122023,11122481,11122030,11122484,11122033,11122490,11170622,11170336,11170627,11170337,11170632,11170343,11170633,11170347,11170640,11170350,11170643,11170356,11213940,11214182,11213945,11214183,11213950,11214189,11213951,11214193,11213958,11214196,11213961,11214202,11229098,11229566,11229571,11229576,11230828,11266644,11266787,11266649,11266792,11266654,11266795,11266655,11266800,11266662,11266803,11266665,11266808,11284025,11323236,11322949,11323241,11322954,11323246,11322956,11323247,11322962,11323254,11322965,11323257,11322967,11374980,11374596,11374985,11374601,11374990,11374606,11374991,11374607,11374998,11374614,11375001,11374617,11418592,11418376,11418597,11418381,11418602,11418386,11418603,11418387,11418610,11418394,11418613,11418397,11464614,11464446,11464619,11464451,11464624,11464456,11464625,11464457,11464632,11464464,11464635,11464467,11513968,11513656,11513973,11513661,11513978,11513666,11513979,11513667,11513986,11513674,11513989,11513677,11556878,11556590,11556883,11556595,11556888,11556600,11556889,11556601,11556896,11556608,11556899,11556611,11573283,11600774,11600510,11600779,11600515,11600784,11600520,11600785,11600521,11600792,11600528,11600795,11600531,11649602,11649362,11649607,11649367,11649612,11649372,11649613,11649373,11649620,11649380,11649623,11649383,11671508,11671364,11671513,11671369,11671518,11671374,11671519,11671375,11671526,11671382,11671529,11671385,11711140,11739241,11739001,11739246,11739006,11739251,11739011,11739252,11739012,11739259,11739019,11739262,11739022,11787099,11786763,11787104,11786768,11787109,11786773,11787110,11786774,11787117,11786781,11787120,11786784,11837121,11836809,11837126,11836814,11837131,11836819,11837132,11836820,11837139,11836827,11837142,11836830,11868967,11868631,11868972,11868636,11868977,11868641,11868978,11868642,11868985,11868649,11868988,11868652,11924015,11923727,11924020,11923732,11924025,11923737,11924026,11923738,11924033,11923745,11924036,11923748,11940879,11940915,11940880,11940916,11940886,11940922,11942505,11942653,11942749,11964195,11963907,11964196,11963908,11964202,11963914,11964206,11963918,11964209,11963921,11964215,11963927,12004367,12003983,12004368,12003984,12004374,12003990,12004378,12003994,12004381,12003997,12004387,12004003,12021471,12021472,12021478,12045499,12045329,12045500,12045334,12045506,12045339,12045510,12045340,12045513,12045347,12045519,12045350,12061188,12084596,12084547,12084601,12084552,12084603,12084557,12084609,12084558,12084612,12084565,12084614,12084568,12101951,12101952,12101958,12102566,20137,19874,20142,19879,20145,19884,20150,19885,20153,19892,20158,19895,71708,71442,71709,71447,71715,71452,71719,71453,71722,71460,71728,71463,111770,111506,111775,111511,111780,111516,111781,111517,111788,111524,111791,111527,158526,158094,158531,158099,158536,158104,158537,158105,158544,158112,158547,158115,192894,192462,192899,192467,192904,192472,192905,192473,192912,192480,192915,192483,210101,210096,210936,210941,210946,232422,232472,232427,232473,232432,232479,232433,232483,232440,232486,232443,232492,247339,273404,273020,273405,273021,273411,273027,273415,273031,273418,273034,273424,273040,288005,312504,312242,312509,312243,312514,312249,312515,312253,312522,312256,312525,312262,357384,357170,357389,357171,357394,357177,357395,357181,357402,357184,357405,357190,371989) ) 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` = 38898 WHERE `RP`.`player` = 38898 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125226,125184,126329,126370,128178,128135,128994,129038,130287,130025,131991,204159,204115,206065,206108,209440,209395,209559,209594,209638,209681,209725,280732,280491,280735,280493,280738,280500,280741,280503,280748,280506,280751,280512,301762,338137,338498,338139,338501,338146,338504,338149,338507,338152,338514,338158,338517,10369073,10398166,10398530,10398169,10398533,10398172,10398536,10398175,10398539,10398182,10398546,10398185,10398549,10441200,10441201,10441207,10479078,10479272,10479084,10479275,10479087,10479278,10479092,10479281,10479095,10479288,10479097,10479291,10542420,10542062,10542426,10542065,10542429,10542068,10542434,10542071,10542437,10542078,10542439,10542081,10604436,10604678,10604442,10604681,10604445,10604684,10604450,10604687,10604453,10604694,10604455,10604697,10662950,10663000,10662956,10663003,10662959,10663006,10662964,10663009,10662967,10663016,10662969,10663019,10726485,10726222,10726487,10726225,10726494,10726228,10726497,10726231,10726500,10726238,10726506,10726241,10796680,10797016,10796683,10797019,10796686,10797022,10796689,10797025,10796696,10797032,10796699,10797035,10876414,10876750,10876417,10876753,10876420,10876756,10876423,10876759,10876430,10876766,10876433,10876769,10919857,10919594,10919859,10919597,10919866,10919600,10919869,10919603,10919872,10919610,10919878,10919613,10964196,10964630,10964199,10964633,10964202,10964636,10964205,10964639,10964212,10964646,10964215,10964649,10982944,10982945,10982951,11014894,11015062,11014899,11015067,11014904,11015072,11014905,11015073,11014912,11015080,11014915,11015083,11069534,11069438,11069539,11069443,11069544,11069448,11069545,11069449,11069552,11069456,11069555,11069459,11085773,11085778,11085780,11122012,11122470,11122017,11122471,11122022,11122477,11122023,11122481,11122030,11122484,11122033,11122490,11170622,11170336,11170627,11170337,11170632,11170343,11170633,11170347,11170640,11170350,11170643,11170356,11213940,11214182,11213945,11214183,11213950,11214189,11213951,11214193,11213958,11214196,11213961,11214202,11229098,11229566,11229571,11229576,11230828,11266644,11266787,11266649,11266792,11266654,11266795,11266655,11266800,11266662,11266803,11266665,11266808,11284025,11323236,11322949,11323241,11322954,11323246,11322956,11323247,11322962,11323254,11322965,11323257,11322967,11374980,11374596,11374985,11374601,11374990,11374606,11374991,11374607,11374998,11374614,11375001,11374617,11418592,11418376,11418597,11418381,11418602,11418386,11418603,11418387,11418610,11418394,11418613,11418397,11464614,11464446,11464619,11464451,11464624,11464456,11464625,11464457,11464632,11464464,11464635,11464467,11513968,11513656,11513973,11513661,11513978,11513666,11513979,11513667,11513986,11513674,11513989,11513677,11556878,11556590,11556883,11556595,11556888,11556600,11556889,11556601,11556896,11556608,11556899,11556611,11573283,11600774,11600510,11600779,11600515,11600784,11600520,11600785,11600521,11600792,11600528,11600795,11600531,11649602,11649362,11649607,11649367,11649612,11649372,11649613,11649373,11649620,11649380,11649623,11649383,11671508,11671364,11671513,11671369,11671518,11671374,11671519,11671375,11671526,11671382,11671529,11671385,11711140,11739241,11739001,11739246,11739006,11739251,11739011,11739252,11739012,11739259,11739019,11739262,11739022,11787099,11786763,11787104,11786768,11787109,11786773,11787110,11786774,11787117,11786781,11787120,11786784,11837121,11836809,11837126,11836814,11837131,11836819,11837132,11836820,11837139,11836827,11837142,11836830,11868967,11868631,11868972,11868636,11868977,11868641,11868978,11868642,11868985,11868649,11868988,11868652,11924015,11923727,11924020,11923732,11924025,11923737,11924026,11923738,11924033,11923745,11924036,11923748,11940879,11940915,11940880,11940916,11940886,11940922,11942505,11942653,11942749,11964195,11963907,11964196,11963908,11964202,11963914,11964206,11963918,11964209,11963921,11964215,11963927,12004367,12003983,12004368,12003984,12004374,12003990,12004378,12003994,12004381,12003997,12004387,12004003,12021471,12021472,12021478,12045499,12045329,12045500,12045334,12045506,12045339,12045510,12045340,12045513,12045347,12045519,12045350,12061188,12084596,12084547,12084601,12084552,12084603,12084557,12084609,12084558,12084612,12084565,12084614,12084568,12101951,12101952,12101958,12102566,20137,19874,20142,19879,20145,19884,20150,19885,20153,19892,20158,19895,71708,71442,71709,71447,71715,71452,71719,71453,71722,71460,71728,71463,111770,111506,111775,111511,111780,111516,111781,111517,111788,111524,111791,111527,158526,158094,158531,158099,158536,158104,158537,158105,158544,158112,158547,158115,192894,192462,192899,192467,192904,192472,192905,192473,192912,192480,192915,192483,210101,210096,210936,210941,210946,232422,232472,232427,232473,232432,232479,232433,232483,232440,232486,232443,232492,247339,273404,273020,273405,273021,273411,273027,273415,273031,273418,273034,273424,273040,288005,312504,312242,312509,312243,312514,312249,312515,312253,312522,312256,312525,312262,357384,357170,357389,357171,357394,357177,357395,357181,357402,357184,357405,357190,371989) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: