(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(141, 1406) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 53976 WHERE `RP`.`player` = 53976 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107437,107439,122089,123526,123529,123715,212852,213071,212730,213074,212855,213896,235398,235517,235399,235520,246466,247666,249882,257358,257708,259724,259821,261991,262028,264310,265810,277720,281267,281572,283312,283411,299296,299429,300957,301884,301882,303033,317058,337114,342198,342214,345650,346074,371966,372028,373221,373404,10368536,10368946,10370042,10370080,10370620,10370696,10386842,10386990,10400094,10400728,10403260,10403826,10406324,10406374,10436701,10437193,10440542,10441439,10441446,10441462,10441474,10441436,10441466,10442095,10442174,10442300,10443045,10443992,10464744,10464900,10464753,10465067,10481023,10481557,10482743,10483312,10510577,10510718,10512564,10514183,10514478,10514502,10514567,10540784,10541448,10543434,10543391,10602906,10603173,10605854,10606852,10608158,10608598,10638222,10640112,10640422,10640449,10640892,10640897,10640957,10640980,10641047,10641093,10648087,10661091,10663552,10665071,10665372,10690401,10690553,10691479,10691461,10691464,10692401,10692907,10693273,10710236,10711468,10728015,10728477,10729687,10730438,10757432,10757675,10760458,10760784,10760880,10762236,10771760,10771789,10772537,10774616,10778406,10779094,10779982,10780612,10797131,10795378,10798180,10799614,10825159,10826410,10826421,10826427,10826551,10826604,10826911,10827182,10827317,10827737,10839177,10839303,10840930,10841380,10843207,10892920,10893056,10893949,10893952,10894623,10906699,10920172,10921221,10921717,10937396,10938884,10939397,10938881,10939541,10941035,10941627,10950390,10962195,10983108,10983032,10983124,10983321,10983446,10983532,10984033,10985623,10999161,10999533,11016601,11017117,11036395,11038056,11038380,11038405,11038381,11038400,11038384,11038409,11038815,11038839,11038883,11038927,11039280,11039304,11055662,11055985,11067428,11067954,11070816,11071159,11086369,11086383,11085944,11087220,11087257,11087524,11087544,11088167,11088852,11108101,11109100,11109170,11121118,11121493,11139788,11139978,11158639,11159137,11186329,11186355,11187241,11187714,11187160,11187243,11188288,11188415,11188995,11195801,11199725,11213371,11229180,11229223,11230269,11230280,11230109,11230926,11231024,11232428,11232541,11232775,11232812,11238472,11239350,11240784,11242637,11243300,11243856,11246866,11248092,11253571,11253722,11267300,11268050,11284080,11284086,11286337,11286336,11286345,11287097,11287336,11287775,11287886,11303085,11303362,11305468,11305875,11320498,11322329,11337882,11339888,11339886,11339892,11340335,11340378,11340434,11341638,11341988,11343949,11360260,11361688,11375386,11392110,11393139,11393126,11393123,11394482,11394790,11394922,11394926,11395306,11396365,11396784,11396809,11416122,11433656,11433676,11434244,11434336,11434245,11434337,11434257,11434339,11436006,11436266,11441636,11453211,11453179,11452011,11453231,11479196,11479218,11481498,11481535,11481605,11481559,11481671,11481782,11481832,11481880,11481938,11494121,11496191,11501614,11502141,11501875,11502300,11514346,11515918,11530214,11531182,11531658,11531835,11531661,11531818,11531654,11531840,11532055,11532063,11532651,11532654,11533161,11533602,11538515,11539272,11544560,11544744,11557849,11558784,11573321,11574272,11575007,11575016,11575002,11575014,11575004,11575012,11575668,11575684,11575938,11576000,11576073,11576118,11577872,11578950,11580507,11580664,11586942,11587140,11601211,11601298,11602071,11602251,11616950,11617017,11619279,11619420,11619466,11619468,11619833,11619908,11620337,11620434,11620439,11626854,11627448,11634910,11636354,11637339,11649832,11651197,11651812,11666319,11667346,11667344,11667858,11667863,11668100,11668109,11668224,11668238,11678404,11680894,11681666,11682319,11684152,11711194,11712137,11712205,11712214,11712207,11712216,11713484,11713692,11713708,11713769,11713841,11738627,11739478,11739465,11739476,11756982,11757978,11757977,11758027,11758829,11758939,11758997,11767263,11769376,11770159,11770299,11805729,11805804,11805731,11805961,11805733,11805962,11807046,11807056,11807271,11807528,11807932,11818119,11818650,11823891,11823892,11825786,11852638,11852643,11853755,11854030,11853779,11854251,11853739,11854337,11854472,11854697,11854975,11865508,11867552,11896163,11896284,11896812,11896853,11896810,11896883,11896814,11896880,11896965,11896983,11897000,11897017,11897064,11897071,11904445,11906259,11907419,11908761,11940150,11940249,11941133,11941441,11941114,11941479,11941116,11941363,11942543,11942597,11942678,11942722,11942784,11942811,11949203,11951302,11964432,11965224,11980376,11980396,11980691,11980991,11980692,11980999,11980744,11980995,11981414,11981412,11982116,11982464,11982873,11982908,11983012,11983018,12006077,12006709,12022462,12022538,12024790,12031127,12031616,12033448,12034395,12046124,12046139,12061204,12062170,12062180,12062195,12062806,12063002,12063041,12063062,12063107,12065220,12065284,12071174,12071162,12085830,12086013,12101123,12101155,12102112,12102143,12102094,12102146,12102096,12102154,12102898,12103263,12103596,12103694,12103713,12103728,4462,4475,4460,4484,21472,21521,46587,47441,47447,49717,57521,59719,70655,85613,86598,86599,86611,87335,87475,87533,88295,88725,94160,97672,99236,126983,127090,127177,127091,127180,127093,127181,128645,128729,128783,128893,133165,134665,136816,136879,138467,156961,172849,173215,173770,173771,173774,174615,175056,175198,175375,175430,177319,179109,193453,194049,210147,210163,211008,211000,211002,212568,212714,212809,212996,214129,216376,214133,216308,219848,220460,247409,248320,248323,248288,249149,249264,249951,257246,258471,260032,260704,261994,288238,289302,289673,289304,289688,289306,289676,289875,290560,299148,300383,313315,313387,315854,316834,332248,333368,333362,333363,333616,333861,334643,334859,335036,335073,338626,339764,341261,339768,341264,344091,358137,372376,373476,373477,373489,373788,374398,374592) ) 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(141, 1406) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 53976 WHERE `RP`.`player` = 53976 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107437,107439,122089,123526,123529,123715,212852,213071,212730,213074,212855,213896,235398,235517,235399,235520,246466,247666,249882,257358,257708,259724,259821,261991,262028,264310,265810,277720,281267,281572,283312,283411,299296,299429,300957,301884,301882,303033,317058,337114,342198,342214,345650,346074,371966,372028,373221,373404,10368536,10368946,10370042,10370080,10370620,10370696,10386842,10386990,10400094,10400728,10403260,10403826,10406324,10406374,10436701,10437193,10440542,10441439,10441446,10441462,10441474,10441436,10441466,10442095,10442174,10442300,10443045,10443992,10464744,10464900,10464753,10465067,10481023,10481557,10482743,10483312,10510577,10510718,10512564,10514183,10514478,10514502,10514567,10540784,10541448,10543434,10543391,10602906,10603173,10605854,10606852,10608158,10608598,10638222,10640112,10640422,10640449,10640892,10640897,10640957,10640980,10641047,10641093,10648087,10661091,10663552,10665071,10665372,10690401,10690553,10691479,10691461,10691464,10692401,10692907,10693273,10710236,10711468,10728015,10728477,10729687,10730438,10757432,10757675,10760458,10760784,10760880,10762236,10771760,10771789,10772537,10774616,10778406,10779094,10779982,10780612,10797131,10795378,10798180,10799614,10825159,10826410,10826421,10826427,10826551,10826604,10826911,10827182,10827317,10827737,10839177,10839303,10840930,10841380,10843207,10892920,10893056,10893949,10893952,10894623,10906699,10920172,10921221,10921717,10937396,10938884,10939397,10938881,10939541,10941035,10941627,10950390,10962195,10983108,10983032,10983124,10983321,10983446,10983532,10984033,10985623,10999161,10999533,11016601,11017117,11036395,11038056,11038380,11038405,11038381,11038400,11038384,11038409,11038815,11038839,11038883,11038927,11039280,11039304,11055662,11055985,11067428,11067954,11070816,11071159,11086369,11086383,11085944,11087220,11087257,11087524,11087544,11088167,11088852,11108101,11109100,11109170,11121118,11121493,11139788,11139978,11158639,11159137,11186329,11186355,11187241,11187714,11187160,11187243,11188288,11188415,11188995,11195801,11199725,11213371,11229180,11229223,11230269,11230280,11230109,11230926,11231024,11232428,11232541,11232775,11232812,11238472,11239350,11240784,11242637,11243300,11243856,11246866,11248092,11253571,11253722,11267300,11268050,11284080,11284086,11286337,11286336,11286345,11287097,11287336,11287775,11287886,11303085,11303362,11305468,11305875,11320498,11322329,11337882,11339888,11339886,11339892,11340335,11340378,11340434,11341638,11341988,11343949,11360260,11361688,11375386,11392110,11393139,11393126,11393123,11394482,11394790,11394922,11394926,11395306,11396365,11396784,11396809,11416122,11433656,11433676,11434244,11434336,11434245,11434337,11434257,11434339,11436006,11436266,11441636,11453211,11453179,11452011,11453231,11479196,11479218,11481498,11481535,11481605,11481559,11481671,11481782,11481832,11481880,11481938,11494121,11496191,11501614,11502141,11501875,11502300,11514346,11515918,11530214,11531182,11531658,11531835,11531661,11531818,11531654,11531840,11532055,11532063,11532651,11532654,11533161,11533602,11538515,11539272,11544560,11544744,11557849,11558784,11573321,11574272,11575007,11575016,11575002,11575014,11575004,11575012,11575668,11575684,11575938,11576000,11576073,11576118,11577872,11578950,11580507,11580664,11586942,11587140,11601211,11601298,11602071,11602251,11616950,11617017,11619279,11619420,11619466,11619468,11619833,11619908,11620337,11620434,11620439,11626854,11627448,11634910,11636354,11637339,11649832,11651197,11651812,11666319,11667346,11667344,11667858,11667863,11668100,11668109,11668224,11668238,11678404,11680894,11681666,11682319,11684152,11711194,11712137,11712205,11712214,11712207,11712216,11713484,11713692,11713708,11713769,11713841,11738627,11739478,11739465,11739476,11756982,11757978,11757977,11758027,11758829,11758939,11758997,11767263,11769376,11770159,11770299,11805729,11805804,11805731,11805961,11805733,11805962,11807046,11807056,11807271,11807528,11807932,11818119,11818650,11823891,11823892,11825786,11852638,11852643,11853755,11854030,11853779,11854251,11853739,11854337,11854472,11854697,11854975,11865508,11867552,11896163,11896284,11896812,11896853,11896810,11896883,11896814,11896880,11896965,11896983,11897000,11897017,11897064,11897071,11904445,11906259,11907419,11908761,11940150,11940249,11941133,11941441,11941114,11941479,11941116,11941363,11942543,11942597,11942678,11942722,11942784,11942811,11949203,11951302,11964432,11965224,11980376,11980396,11980691,11980991,11980692,11980999,11980744,11980995,11981414,11981412,11982116,11982464,11982873,11982908,11983012,11983018,12006077,12006709,12022462,12022538,12024790,12031127,12031616,12033448,12034395,12046124,12046139,12061204,12062170,12062180,12062195,12062806,12063002,12063041,12063062,12063107,12065220,12065284,12071174,12071162,12085830,12086013,12101123,12101155,12102112,12102143,12102094,12102146,12102096,12102154,12102898,12103263,12103596,12103694,12103713,12103728,4462,4475,4460,4484,21472,21521,46587,47441,47447,49717,57521,59719,70655,85613,86598,86599,86611,87335,87475,87533,88295,88725,94160,97672,99236,126983,127090,127177,127091,127180,127093,127181,128645,128729,128783,128893,133165,134665,136816,136879,138467,156961,172849,173215,173770,173771,173774,174615,175056,175198,175375,175430,177319,179109,193453,194049,210147,210163,211008,211000,211002,212568,212714,212809,212996,214129,216376,214133,216308,219848,220460,247409,248320,248323,248288,249149,249264,249951,257246,258471,260032,260704,261994,288238,289302,289673,289304,289688,289306,289676,289875,290560,299148,300383,313315,313387,315854,316834,332248,333368,333362,333363,333616,333861,334643,334859,335036,335073,338626,339764,341261,339768,341264,344091,358137,372376,373476,373477,373489,373788,374398,374592) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: