(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` = 447 WHERE `RP`.`player` = 447 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107401,107443,122795,123193,123864,123152,124037,123155,123867,215091,215237,215208,234861,234864,246520,246612,247514,247926,257426,257437,259691,259845,261986,262068,264260,264262,277067,278433,280997,281310,283874,283889,299146,299190,300899,300934,301775,302318,301778,303465,326412,342032,342104,345629,345682,371882,371887,373224,373534,10368543,10368958,10369983,10370009,10370581,10370626,10386275,10386325,10399753,10400438,10403045,10403626,10406663,10407303,10436992,10437121,10440515,10441093,10441328,10441352,10441353,10441426,10441416,10441458,10442096,10442169,10442260,10442286,10443333,10443335,10465066,10465068,10481523,10481654,10483293,10483619,10510299,10512614,10513617,10513619,10514277,10514557,10541032,10541090,10542504,10544029,10568139,10568462,10570068,10570153,10570705,10570904,10583925,10602771,10605665,10605853,10608186,10608805,10637696,10638163,10639589,10639615,10639598,10639633,10639588,10639600,10640822,10640854,10640971,10640987,10641045,10641073,10647865,10647903,10661221,10661336,10664889,10664898,10690431,10690521,10691548,10691545,10691742,10692389,10692403,10692656,10692700,10693191,10693261,10708239,10710206,10710170,10727502,10728199,10729841,10729946,10757446,10758670,10758588,10759584,10758667,10760147,10760537,10760576,10760903,10760935,10762421,10762500,10771034,10771859,10772842,10773047,10777964,10778066,10779511,10780341,10795325,10795616,10798287,10798806,10825122,10826435,10826418,10826437,10826553,10826583,10826717,10826751,10827347,10827977,10839483,10839642,10840877,10841293,10842552,10892879,10893399,10893832,10893948,10893836,10893981,10893834,10893953,10894210,10894226,10894590,10894614,10895393,10896107,10904521,10905501,10906607,10906747,10920513,10921222,10937024,10937486,10938632,10939253,10938817,10939255,10938634,10939347,10939503,10939559,10940493,10941176,10941610,10941681,10948629,10963805,10964031,10981520,10981539,10983068,10983114,10983116,10983161,10983184,10983217,10983525,10983840,10984058,10984116,10985627,10985684,10998881,10999534,11015508,11015970,11036248,11036270,11038369,11038390,11038366,11038453,11038367,11038455,11038773,11038896,11038900,11039278,11039520,11055563,11056195,11067604,11068034,11070798,11070806,11087505,11087511,11087630,11087633,11107864,11108225,11108992,11120636,11121416,11121485,11139804,11140822,11140823,11140826,11141369,11141815,11141836,11142037,11142046,11157761,11186296,11186305,11187006,11187108,11187136,11188277,11188282,11188387,11188441,11188513,11188906,11195246,11195362,11198715,11198849,11213362,11213426,11229161,11229204,11229789,11229786,11229814,11230884,11230918,11231934,11232246,11232759,11237952,11238766,11240783,11241319,11243211,11243276,11246908,11246911,11253596,11267830,11284065,11284076,11286213,11286212,11286216,11286624,11286794,11287789,11303040,11303043,11305528,11305840,11320104,11321019,11337918,11340365,11341438,11341959,11342970,11343605,11360529,11361663,11374421,11391992,11393264,11393238,11393224,11394336,11394710,11394874,11395353,11395458,11396592,11397159,11416086,11416288,11433529,11433584,11434374,11434405,11434381,11436056,11436111,11436263,11440941,11441556,11449215,11450576,11449421,11450569,11479229,11481381,11481383,11481387,11481656,11481686,11481818,11481825,11481941,11494044,11500374,11500376,11514547,11530246,11532271,11532667,11532994,11538376,11538539,11544857,11555869,11557173,11558963,11573301,11575015,11575029,11575051,11575685,11575894,11575939,11576077,11576106,11577784,11579344,11580508,11588136,11588156,11601212,11602652,11602837,11616963,11619097,11619050,11619048,11620145,11620364,11627447,11635579,11637698,11651783,11666398,11667265,11667267,11667257,11668017,11668105,11668233,11678221,11678681,11679266,11679906,11682348,11683733,11713745,11713829,11739450,11739688,11757215,11757974,11757941,11757926,11758831,11758942,11758989,11767595,11769405,11769619,11770908,11805874,11805877,11805873,11807010,11807459,11807736,11807883,11816553,11818825,11822871,11822911,11852620,11865756,11865913,11896315,11896847,11896849,11896850,11896959,11896978,11897042,11897047,11897085,11897100,11906436,11907807,11909347,11940342,11940822,11941561,11941478,11941477,11942641,11942718,11942792,11949460,11951249,11965141,11965160,11980342,11980502,11980984,11980506,11981110,11980508,11981113,11981378,11981405,11981765,11981820,11982851,11983024,11983006,12006796,12021360,12021359,12021553,12021554,12021557,12022096,12022424,12022514,12024442,12024686,12031136,12031618,12033446,12034036,12046148,12046888,12061998,12062116,12062000,12062115,12062003,12062112,12062560,12062570,12062967,12063015,12063070,12063104,12065210,12065250,12071118,12085050,12085982,12101154,12101182,12102011,12102014,12101999,12102012,12102000,12102008,12103261,12103618,12103706,4290,4461,4292,4459,20553,20878,46584,47231,47425,47438,48300,48301,48304,48538,48955,49011,49190,49192,49282,49377,70619,70669,85641,85653,86519,86579,86513,86581,86518,86567,87307,87349,87436,87453,87517,87546,88249,88486,94186,94895,98599,112211,126288,126582,127105,127108,127103,128637,128781,128789,128866,128920,133775,133923,136756,136940,139056,139099,156619,172847,172880,173723,173722,173716,173726,173714,173717,174580,174587,174727,174933,175384,175454,177976,178382,194201,194175,210134,211067,211059,211061,211064,211065,211070,212541,212593,212725,212743,212778,212822,212995,213187,213494,215098,213403,215106,219841,231977,247380,247404,248256,248252,248249,249183,249249,249263,249786,249845,256995,257544,261007,261054,262004,273673,288198,289354,289357,289355,289819,289830,290047,290187,290589,290651,299083,300964,313829,314173,316217,316816,331813,333382,333379,333384,333597,333612,334637,334783,335011,335091,337373,339175,340737,341486,340747,341488,344405,358161,358355,372039,372535,373113,373208,373075,373205,373043,373204,373796,373819,374377,374429,374610,374617) ) 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` = 447 WHERE `RP`.`player` = 447 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107401,107443,122795,123193,123864,123152,124037,123155,123867,215091,215237,215208,234861,234864,246520,246612,247514,247926,257426,257437,259691,259845,261986,262068,264260,264262,277067,278433,280997,281310,283874,283889,299146,299190,300899,300934,301775,302318,301778,303465,326412,342032,342104,345629,345682,371882,371887,373224,373534,10368543,10368958,10369983,10370009,10370581,10370626,10386275,10386325,10399753,10400438,10403045,10403626,10406663,10407303,10436992,10437121,10440515,10441093,10441328,10441352,10441353,10441426,10441416,10441458,10442096,10442169,10442260,10442286,10443333,10443335,10465066,10465068,10481523,10481654,10483293,10483619,10510299,10512614,10513617,10513619,10514277,10514557,10541032,10541090,10542504,10544029,10568139,10568462,10570068,10570153,10570705,10570904,10583925,10602771,10605665,10605853,10608186,10608805,10637696,10638163,10639589,10639615,10639598,10639633,10639588,10639600,10640822,10640854,10640971,10640987,10641045,10641073,10647865,10647903,10661221,10661336,10664889,10664898,10690431,10690521,10691548,10691545,10691742,10692389,10692403,10692656,10692700,10693191,10693261,10708239,10710206,10710170,10727502,10728199,10729841,10729946,10757446,10758670,10758588,10759584,10758667,10760147,10760537,10760576,10760903,10760935,10762421,10762500,10771034,10771859,10772842,10773047,10777964,10778066,10779511,10780341,10795325,10795616,10798287,10798806,10825122,10826435,10826418,10826437,10826553,10826583,10826717,10826751,10827347,10827977,10839483,10839642,10840877,10841293,10842552,10892879,10893399,10893832,10893948,10893836,10893981,10893834,10893953,10894210,10894226,10894590,10894614,10895393,10896107,10904521,10905501,10906607,10906747,10920513,10921222,10937024,10937486,10938632,10939253,10938817,10939255,10938634,10939347,10939503,10939559,10940493,10941176,10941610,10941681,10948629,10963805,10964031,10981520,10981539,10983068,10983114,10983116,10983161,10983184,10983217,10983525,10983840,10984058,10984116,10985627,10985684,10998881,10999534,11015508,11015970,11036248,11036270,11038369,11038390,11038366,11038453,11038367,11038455,11038773,11038896,11038900,11039278,11039520,11055563,11056195,11067604,11068034,11070798,11070806,11087505,11087511,11087630,11087633,11107864,11108225,11108992,11120636,11121416,11121485,11139804,11140822,11140823,11140826,11141369,11141815,11141836,11142037,11142046,11157761,11186296,11186305,11187006,11187108,11187136,11188277,11188282,11188387,11188441,11188513,11188906,11195246,11195362,11198715,11198849,11213362,11213426,11229161,11229204,11229789,11229786,11229814,11230884,11230918,11231934,11232246,11232759,11237952,11238766,11240783,11241319,11243211,11243276,11246908,11246911,11253596,11267830,11284065,11284076,11286213,11286212,11286216,11286624,11286794,11287789,11303040,11303043,11305528,11305840,11320104,11321019,11337918,11340365,11341438,11341959,11342970,11343605,11360529,11361663,11374421,11391992,11393264,11393238,11393224,11394336,11394710,11394874,11395353,11395458,11396592,11397159,11416086,11416288,11433529,11433584,11434374,11434405,11434381,11436056,11436111,11436263,11440941,11441556,11449215,11450576,11449421,11450569,11479229,11481381,11481383,11481387,11481656,11481686,11481818,11481825,11481941,11494044,11500374,11500376,11514547,11530246,11532271,11532667,11532994,11538376,11538539,11544857,11555869,11557173,11558963,11573301,11575015,11575029,11575051,11575685,11575894,11575939,11576077,11576106,11577784,11579344,11580508,11588136,11588156,11601212,11602652,11602837,11616963,11619097,11619050,11619048,11620145,11620364,11627447,11635579,11637698,11651783,11666398,11667265,11667267,11667257,11668017,11668105,11668233,11678221,11678681,11679266,11679906,11682348,11683733,11713745,11713829,11739450,11739688,11757215,11757974,11757941,11757926,11758831,11758942,11758989,11767595,11769405,11769619,11770908,11805874,11805877,11805873,11807010,11807459,11807736,11807883,11816553,11818825,11822871,11822911,11852620,11865756,11865913,11896315,11896847,11896849,11896850,11896959,11896978,11897042,11897047,11897085,11897100,11906436,11907807,11909347,11940342,11940822,11941561,11941478,11941477,11942641,11942718,11942792,11949460,11951249,11965141,11965160,11980342,11980502,11980984,11980506,11981110,11980508,11981113,11981378,11981405,11981765,11981820,11982851,11983024,11983006,12006796,12021360,12021359,12021553,12021554,12021557,12022096,12022424,12022514,12024442,12024686,12031136,12031618,12033446,12034036,12046148,12046888,12061998,12062116,12062000,12062115,12062003,12062112,12062560,12062570,12062967,12063015,12063070,12063104,12065210,12065250,12071118,12085050,12085982,12101154,12101182,12102011,12102014,12101999,12102012,12102000,12102008,12103261,12103618,12103706,4290,4461,4292,4459,20553,20878,46584,47231,47425,47438,48300,48301,48304,48538,48955,49011,49190,49192,49282,49377,70619,70669,85641,85653,86519,86579,86513,86581,86518,86567,87307,87349,87436,87453,87517,87546,88249,88486,94186,94895,98599,112211,126288,126582,127105,127108,127103,128637,128781,128789,128866,128920,133775,133923,136756,136940,139056,139099,156619,172847,172880,173723,173722,173716,173726,173714,173717,174580,174587,174727,174933,175384,175454,177976,178382,194201,194175,210134,211067,211059,211061,211064,211065,211070,212541,212593,212725,212743,212778,212822,212995,213187,213494,215098,213403,215106,219841,231977,247380,247404,248256,248252,248249,249183,249249,249263,249786,249845,256995,257544,261007,261054,262004,273673,288198,289354,289357,289355,289819,289830,290047,290187,290589,290651,299083,300964,313829,314173,316217,316816,331813,333382,333379,333384,333597,333612,334637,334783,335011,335091,337373,339175,340737,341486,340747,341488,344405,358161,358355,372039,372535,373113,373208,373075,373205,373043,373204,373796,373819,374377,374429,374610,374617) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: