(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` = 74150 WHERE `RP`.`player` = 74150 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107405,107423,122683,122892,122709,122890,122693,123077,122694,123078,214355,214985,214358,215085,214359,214901,235676,235677,246475,247178,247955,249144,257328,257562,259746,259668,261961,262085,264593,265569,277575,277826,281446,281862,283284,283900,299332,299546,300976,301780,301804,303411,337198,337252,342031,342264,345709,346678,372027,373222,10369179,10370018,10369869,10370020,10370594,10370692,10385880,10386245,10399818,10400263,10403386,10406205,10406243,10436704,10436928,10440304,10440326,10441390,10441372,10441369,10442162,10442807,10443393,10464611,10465380,10464710,10465381,10481196,10481595,10482651,10483311,10510423,10510704,10512543,10514146,10514379,10514516,10540755,10541637,10542693,10544184,10568297,10570156,10570189,10602732,10602878,10605081,10605297,10608132,10608156,10637866,10637933,10639628,10639820,10639630,10639827,10639631,10639830,10640821,10640867,10640949,10640983,10641744,10641860,10647734,10647810,10661871,10662645,10665305,10665495,10690427,10690434,10691775,10691960,10691883,10691968,10691831,10692031,10692434,10692475,10692547,10692890,10693190,10693222,10708438,10708639,10710181,10710223,10728239,10728342,10729751,10730437,10757483,10758569,10758622,10758573,10758624,10758566,10758637,10760525,10760832,10760918,10760968,10761823,10762231,10770749,10771425,10772823,10773795,10779342,10780094,10780388,10796346,10796067,10798530,10799431,10825176,10825185,10826368,10826377,10826369,10826372,10826365,10826395,10826564,10826565,10826926,10827181,10827824,10827825,10839171,10839233,10840954,10840979,10843208,10876084,10892876,10892911,10894455,10894533,10894546,10895376,10895908,10904593,10905103,10906655,10906663,10920842,10921386,10937234,10937579,10938050,10938117,10938051,10938124,10938078,10938139,10939538,10939572,10940754,10940805,10941602,10941611,10948360,10949337,10963104,10963455,10981518,10983022,10983151,10983011,10983150,10983025,10983153,10983374,10983628,10984076,10984117,10985734,10985776,10998750,11000239,11016148,11016420,11036476,11036725,11038448,11038446,11038451,11038771,11038933,11038953,11039434,11039674,11055661,11055955,11067588,11068399,11070815,11070844,11085123,11087248,11087250,11087529,11087554,11088168,11088228,11106648,11107533,11109102,11109599,11121242,11121356,11139762,11139828,11140534,11140701,11140677,11141435,11141896,11142017,11157780,11158423,11186327,11186796,11187358,11186799,11187356,11186811,11187399,11188256,11188317,11188376,11188445,11188662,11189464,11195606,11196341,11198815,11198821,11213515,11213572,11229186,11229962,11229966,11229964,11230352,11230837,11230968,11232007,11232463,11232827,11232832,11238107,11238277,11241320,11241766,11243686,11243745,11246877,11246879,11253483,11254144,11267200,11269129,11284069,11286308,11286299,11286298,11286607,11286991,11287008,11287914,11288048,11303004,11303051,11305317,11305538,11320582,11320970,11337878,11337914,11339887,11339917,11339931,11339916,11339847,11339910,11340363,11340400,11341520,11341564,11341857,11341930,11343317,11343906,11359562,11360199,11361672,11361693,11374449,11374506,11392064,11392111,11393092,11393120,11393116,11393117,11393094,11393124,11394333,11394568,11394720,11394727,11394879,11394881,11395182,11395483,11397015,11397579,11416444,11418069,11433593,11433663,11434232,11434511,11434379,11434500,11434328,11434497,11436047,11436117,11436246,11436256,11440552,11441635,11450015,11452823,11449972,11452828,11479182,11479188,11481323,11481497,11481322,11481536,11481344,11481554,11481683,11481693,11481796,11481846,11481895,11481929,11494016,11494303,11500611,11501604,11500610,11501208,11514240,11514664,11530242,11530250,11531651,11531642,11531659,11532064,11532603,11532680,11532802,11533216,11539201,11540018,11544949,11544875,11557796,11558516,11573297,11573304,11574802,11574921,11574803,11574924,11574809,11574917,11575606,11575608,11575897,11575929,11576068,11576092,11577242,11578731,11580653,11582005,11586923,11587695,11601289,11601485,11602034,11602252,11616973,11618916,11618929,11618950,11619594,11620023,11620262,11620268,11620380,11620428,11624823,11625708,11634909,11635697,11637096,11637340,11650933,11650983,11666281,11666512,11667242,11667253,11667255,11667244,11667252,11667258,11667377,11667634,11668075,11668129,11668193,11668196,11678155,11678274,11678671,11678762,11683477,11684299,11711151,11711177,11712065,11712089,11712067,11712093,11712091,11712099,11713215,11713233,11713666,11713700,11713779,11713782,11738036,11738075,11737999,11738081,11757012,11757016,11757902,11757995,11757901,11757996,11757893,11757999,11758784,11758798,11758905,11758935,11758978,11758992,11767448,11769336,11769465,11770376,11805613,11805741,11805639,11805742,11805635,11805745,11807001,11807057,11807488,11807824,11807891,11807908,11817183,11817633,11824602,11823908,11824572,11852623,11852637,11853792,11853760,11853748,11854452,11854454,11854779,11854906,11855242,11855255,11865265,11865418,11895882,11896318,11896749,11896777,11896750,11896765,11896753,11896762,11896923,11896974,11897005,11897034,11897069,11897088,11904376,11906057,11907957,11909156,11940212,11940320,11941009,11941224,11941159,11941228,11941138,11941226,11942559,11942572,11942704,11942711,11942767,11942800,11949720,11951242,11965140,11966710,11980813,11980881,11980817,11981386,11981798,11982146,11982833,11982830,11982990,11982992,12006108,12006116,12021361,12021353,12021506,12021552,12021505,12021555,12021508,12021556,12022130,12022120,12022414,12022431,12022513,12022507,12024486,12024675,12031308,12031705,12034013,12034043,12046090,12046759,12061207,12061244,12062046,12062121,12062044,12062143,12062043,12062128,12062561,12062670,12062974,12063042,12063115,12063128,12065153,12065154,12071102,12071090,12085053,12085149,12101130,12101144,12102046,12102083,12102053,12102081,12102043,12102079,12102670,12102899,12103581,12103669,12103705,12103746,4190,4321,4241,4324,20595,20638,46496,47060,47394,47423,48150,48142,48152,48365,48380,48831,48956,49127,49201,49296,49566,57301,57306,59720,70656,85645,85648,86637,86640,86641,87306,87318,87438,87472,87535,87543,88546,88775,94916,95412,97829,98561,99235,126392,127121,127124,127125,128704,128792,128831,128890,128912,133819,134620,136774,136920,139062,139171,155983,156620,172838,172854,173724,173793,173725,173791,173728,173790,174586,174634,174677,174960,175379,175398,177868,178687,193411,193435,210154,211035,211060,211038,211058,211021,211056,212529,212701,212740,212776,212782,213022,213197,214622,214681,214559,214778,220096,220305,247367,247400,248226,248247,248227,248251,248230,248250,249087,249253,249795,249847,257004,257301,260650,261974,273683,288221,289084,289081,289195,289801,290143,290166,290604,290647,299137,300776,313233,315853,316530,331833,331853,333320,333412,333321,333408,333326,333409,333601,333619,334669,334757,335004,335129,338425,338459,340212,341558,340210,341580,344298,345254,358136,358351,372085,372963,372907,372966,373767,374311,374344,374540,374578) ) 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` = 74150 WHERE `RP`.`player` = 74150 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107405,107423,122683,122892,122709,122890,122693,123077,122694,123078,214355,214985,214358,215085,214359,214901,235676,235677,246475,247178,247955,249144,257328,257562,259746,259668,261961,262085,264593,265569,277575,277826,281446,281862,283284,283900,299332,299546,300976,301780,301804,303411,337198,337252,342031,342264,345709,346678,372027,373222,10369179,10370018,10369869,10370020,10370594,10370692,10385880,10386245,10399818,10400263,10403386,10406205,10406243,10436704,10436928,10440304,10440326,10441390,10441372,10441369,10442162,10442807,10443393,10464611,10465380,10464710,10465381,10481196,10481595,10482651,10483311,10510423,10510704,10512543,10514146,10514379,10514516,10540755,10541637,10542693,10544184,10568297,10570156,10570189,10602732,10602878,10605081,10605297,10608132,10608156,10637866,10637933,10639628,10639820,10639630,10639827,10639631,10639830,10640821,10640867,10640949,10640983,10641744,10641860,10647734,10647810,10661871,10662645,10665305,10665495,10690427,10690434,10691775,10691960,10691883,10691968,10691831,10692031,10692434,10692475,10692547,10692890,10693190,10693222,10708438,10708639,10710181,10710223,10728239,10728342,10729751,10730437,10757483,10758569,10758622,10758573,10758624,10758566,10758637,10760525,10760832,10760918,10760968,10761823,10762231,10770749,10771425,10772823,10773795,10779342,10780094,10780388,10796346,10796067,10798530,10799431,10825176,10825185,10826368,10826377,10826369,10826372,10826365,10826395,10826564,10826565,10826926,10827181,10827824,10827825,10839171,10839233,10840954,10840979,10843208,10876084,10892876,10892911,10894455,10894533,10894546,10895376,10895908,10904593,10905103,10906655,10906663,10920842,10921386,10937234,10937579,10938050,10938117,10938051,10938124,10938078,10938139,10939538,10939572,10940754,10940805,10941602,10941611,10948360,10949337,10963104,10963455,10981518,10983022,10983151,10983011,10983150,10983025,10983153,10983374,10983628,10984076,10984117,10985734,10985776,10998750,11000239,11016148,11016420,11036476,11036725,11038448,11038446,11038451,11038771,11038933,11038953,11039434,11039674,11055661,11055955,11067588,11068399,11070815,11070844,11085123,11087248,11087250,11087529,11087554,11088168,11088228,11106648,11107533,11109102,11109599,11121242,11121356,11139762,11139828,11140534,11140701,11140677,11141435,11141896,11142017,11157780,11158423,11186327,11186796,11187358,11186799,11187356,11186811,11187399,11188256,11188317,11188376,11188445,11188662,11189464,11195606,11196341,11198815,11198821,11213515,11213572,11229186,11229962,11229966,11229964,11230352,11230837,11230968,11232007,11232463,11232827,11232832,11238107,11238277,11241320,11241766,11243686,11243745,11246877,11246879,11253483,11254144,11267200,11269129,11284069,11286308,11286299,11286298,11286607,11286991,11287008,11287914,11288048,11303004,11303051,11305317,11305538,11320582,11320970,11337878,11337914,11339887,11339917,11339931,11339916,11339847,11339910,11340363,11340400,11341520,11341564,11341857,11341930,11343317,11343906,11359562,11360199,11361672,11361693,11374449,11374506,11392064,11392111,11393092,11393120,11393116,11393117,11393094,11393124,11394333,11394568,11394720,11394727,11394879,11394881,11395182,11395483,11397015,11397579,11416444,11418069,11433593,11433663,11434232,11434511,11434379,11434500,11434328,11434497,11436047,11436117,11436246,11436256,11440552,11441635,11450015,11452823,11449972,11452828,11479182,11479188,11481323,11481497,11481322,11481536,11481344,11481554,11481683,11481693,11481796,11481846,11481895,11481929,11494016,11494303,11500611,11501604,11500610,11501208,11514240,11514664,11530242,11530250,11531651,11531642,11531659,11532064,11532603,11532680,11532802,11533216,11539201,11540018,11544949,11544875,11557796,11558516,11573297,11573304,11574802,11574921,11574803,11574924,11574809,11574917,11575606,11575608,11575897,11575929,11576068,11576092,11577242,11578731,11580653,11582005,11586923,11587695,11601289,11601485,11602034,11602252,11616973,11618916,11618929,11618950,11619594,11620023,11620262,11620268,11620380,11620428,11624823,11625708,11634909,11635697,11637096,11637340,11650933,11650983,11666281,11666512,11667242,11667253,11667255,11667244,11667252,11667258,11667377,11667634,11668075,11668129,11668193,11668196,11678155,11678274,11678671,11678762,11683477,11684299,11711151,11711177,11712065,11712089,11712067,11712093,11712091,11712099,11713215,11713233,11713666,11713700,11713779,11713782,11738036,11738075,11737999,11738081,11757012,11757016,11757902,11757995,11757901,11757996,11757893,11757999,11758784,11758798,11758905,11758935,11758978,11758992,11767448,11769336,11769465,11770376,11805613,11805741,11805639,11805742,11805635,11805745,11807001,11807057,11807488,11807824,11807891,11807908,11817183,11817633,11824602,11823908,11824572,11852623,11852637,11853792,11853760,11853748,11854452,11854454,11854779,11854906,11855242,11855255,11865265,11865418,11895882,11896318,11896749,11896777,11896750,11896765,11896753,11896762,11896923,11896974,11897005,11897034,11897069,11897088,11904376,11906057,11907957,11909156,11940212,11940320,11941009,11941224,11941159,11941228,11941138,11941226,11942559,11942572,11942704,11942711,11942767,11942800,11949720,11951242,11965140,11966710,11980813,11980881,11980817,11981386,11981798,11982146,11982833,11982830,11982990,11982992,12006108,12006116,12021361,12021353,12021506,12021552,12021505,12021555,12021508,12021556,12022130,12022120,12022414,12022431,12022513,12022507,12024486,12024675,12031308,12031705,12034013,12034043,12046090,12046759,12061207,12061244,12062046,12062121,12062044,12062143,12062043,12062128,12062561,12062670,12062974,12063042,12063115,12063128,12065153,12065154,12071102,12071090,12085053,12085149,12101130,12101144,12102046,12102083,12102053,12102081,12102043,12102079,12102670,12102899,12103581,12103669,12103705,12103746,4190,4321,4241,4324,20595,20638,46496,47060,47394,47423,48150,48142,48152,48365,48380,48831,48956,49127,49201,49296,49566,57301,57306,59720,70656,85645,85648,86637,86640,86641,87306,87318,87438,87472,87535,87543,88546,88775,94916,95412,97829,98561,99235,126392,127121,127124,127125,128704,128792,128831,128890,128912,133819,134620,136774,136920,139062,139171,155983,156620,172838,172854,173724,173793,173725,173791,173728,173790,174586,174634,174677,174960,175379,175398,177868,178687,193411,193435,210154,211035,211060,211038,211058,211021,211056,212529,212701,212740,212776,212782,213022,213197,214622,214681,214559,214778,220096,220305,247367,247400,248226,248247,248227,248251,248230,248250,249087,249253,249795,249847,257004,257301,260650,261974,273683,288221,289084,289081,289195,289801,290143,290166,290604,290647,299137,300776,313233,315853,316530,331833,331853,333320,333412,333321,333408,333326,333409,333601,333619,334669,334757,335004,335129,338425,338459,340212,341558,340210,341580,344298,345254,358136,358351,372085,372963,372907,372966,373767,374311,374344,374540,374578) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: