SELECT efis_film.id as Id, title_proper AS Label, efis_film_festival.id  
   FROM efis_film, efis_film_type_rel, efis_film_festival, efis_film_translation
  WHERE efis_film_type_rel.film_id=efis_film.id 
 AND efis_film_festival.film_id=efis_film.id
 AND efis_film_type_rel.film_type_id=33;
 
 
SELECT efis_film.id as Id, COUNT(efis_film_festival.id)  
   FROM efis_film, efis_film_type_rel, efis_film_festival
  WHERE efis_film_type_rel.film_id=efis_film.id 
 AND efis_film_type_rel.film_type_id=33
 AND efis_film_festival.film_id=efis_film.id
  GROUP BY efis_film.id;
 

 SELECT efis_film.id as Id, COUNT(efis_film_festival.id) as fkogus,
  (SELECT title_proper from efis_film_translation WHERE film_id=efis_film.id AND language='en') AS pealkiri 
   FROM efis_film, efis_film_type_rel, efis_film_festival
  WHERE efis_film_type_rel.film_id=efis_film.id 
 AND efis_film_type_rel.film_type_id=33
 AND efis_film_festival.film_id=efis_film.id
  GROUP BY efis_film.id;


 SELECT concat('f', efis_festival.id) as Id, COUNT(efis_film.id) as fikogus,
  (SELECT name from efis_festival WHERE film_id=efis_film.id AND language='en') AS Label 
   FROM efis_film, efis_film_type_rel, efis_film_festival, efis_festival_translation
  WHERE efis_film_type_rel.film_id=efis_film.id 
 AND efis_film_type_rel.film_type_id=33
 AND efis_film_festival.film_id=efis_film.id
  GROUP BY efis_film.id;


 SELECT concat('fe',efis_festival.id) as Id, (SELECT name from efis_festival_translation where festival_id=efis_festival.id and language='en') AS Label, COUNT(efis_film.id) as filme_festivalil
   FROM efis_film, efis_film_type_rel, efis_film_festival, efis_festival
  WHERE efis_film_type_rel.film_id=efis_film.id 
 AND efis_film_type_rel.film_type_id=33
 AND efis_film_festival.film_id=efis_film.id
 AND efis_film_festival.festival_id=efis_festival.id
  GROUP BY efis_festival.id;

SELECT efis_film_type_rel.film_id, efis_film_type_rel.festival_id FROM efis_film_type_rel, efis_film_festival, 
  WHERE efis_film_type_rel.film_id=efis_film.id 
   AND efis_film_type_rel.film_type_id=33
   AND efis_film_festival.film_id=efis_film_type_rel.film_id;


https://ouestware.gitlab.io/retina/beta/#/graph/?url=https://gist.githubusercontent.com/jaagup/01efddd705008eb1fd5a245c4bf6ed00/raw/6bf487d83d9ae7bb28bc5ad1ecd52947709c8388/network-ab680b93-952.gexf


https://minitorn.tlu.ee/~jaagup/oma/too/24/11/tudengifilmid/paigutus1.gexf

https://ouestware.gitlab.io/retina/beta/#/graph/?url=https://minitorn.tlu.ee/~jaagup/oma/too/24/11/tudengifilmid/paigutus1.gexf

https://minitorn.tlu.ee/~jaagup/oma/too/24/11/tudengifilmid/filmid_mitmel_suurel_festivalil.gexf

https://ouestware.gitlab.io/retina/beta/#/graph/?url=https://minitorn.tlu.ee/~jaagup/oma/too/24/11/tudengifilmid/filmid_mitmel_suurel_festivalil.gexf



 SELECT concat('fe',efis_festival.id) as Id, (SELECT name from efis_festival_translation where festival_id=efis_festival.id and language='en') AS Label, COUNT(efis_film.id) as filme_festivalil
   FROM efis_film, efis_film_type_rel, efis_film_festival, efis_festival
  WHERE efis_film_type_rel.film_id=efis_film.id 
 AND efis_film_type_rel.film_type_id=33
 AND efis_film_festival.film_id=efis_film.id
 AND efis_film_festival.festival_id=efis_festival.id
  GROUP BY efis_festival.id
  ORDER BY filme_festivalil DESC;
  
SELECT group_concat(id) from (  
 SELECT efis_festival.id as Id, (SELECT name from efis_festival_translation where festival_id=efis_festival.id and language='en') AS Label, COUNT(efis_film.id) as filme_festivalil
   FROM efis_film, efis_film_type_rel, efis_film_festival, efis_festival
  WHERE efis_film_type_rel.film_id=efis_film.id 
 AND efis_film_type_rel.film_type_id=33
 AND efis_film_festival.film_id=efis_film.id
 AND efis_film_festival.festival_id=efis_festival.id
  GROUP BY efis_festival.id
 HAVING COUNT(efis_film.id) >=10
  ORDER BY filme_festivalil 
  DESC) as tabel1;
  
2562,3281,1196,2982,1544,1381,1390,1422,1209,1195,2679,1884,1140

SET SESSION group_concat_max_len = 1000000;
SELECT group_concat(film_id) from efis_film_type_rel 
  WHERE film_type_id=33;

1649,1759,1762,1801,1803,1900,1913,1970,1981,1982,2363,2434,2436,2444,2634,2778,2843,3112,3572,3589,3603,3605,3808,3904,4338,4352,4354,5324,5334,5336,5467,5491,6038,6672,6850,7077,7198,7244,7380,7415,7459,161,3668,11530,11577,11571,6684,1656,4286,11448,1977,6358,1938,6671,11592,347,11463,11590,11559,3436,11456,11517,5965,11527,11522,1630,11525,2013,11523,4013,11524,7431,512,2,2645,11526,2695,11528,1601,5,1922,1921,1909,1857,1827,1945,1950,1829,47,1612,11459,11461,1663,11462,1728,1755,1799,11439,1820,1835,2012,2016,88,11468,2543,2546,6376,517,7067,7037,7324,7085,7031,7325,7054,7089,7094,7127,7033,7425,7426,497,7168,7218,7259,503,7284,7101,7149,7150,11452,7151,7152,7410,7402,6630,6613,6525,5906,5911,11587,849,11466,2422,2592,11467,478,2650,2375,2660,2693,2677,2373,2306,2712,2741,2286,2749,2771,72,946,1952,935,1954,1966,1967,1983,1985,58,2026,2030,2037,2070,74,2261,2278,2279,115,2806,2930,2866,2878,2966,2977,3000,3027,3148,3160,3479,3478,3722,3738,3750,3755,3598,6860,6727,6756,439,3204,159,3233,3235,836,3239,3241,7384,532,6841,781,6827,11533,939,6808,6895,451,6686,6685,433,6682,6681,6680,6679,429,6676,6675,6670,6668,426,6662,6667,425,6524,6523,6517,405,415,11450,6260,6364,6345,6171,396,6164,383,6295,6147,6131,6128,6124,6096,938,374,6075,371,6051,6048,6045,6019,6016,6009,5977,5949,362,5928,5916,5856,5853,3258,169,936,3274,3287,3293,3361,3347,3360,3348,11516,3761,3800,942,3872,227,4075,4061,4035,3979,234,3974,11455,4371,4290,3286,4263,3966,4049,4133,4160,4163,4172,5222,4348,4350,4353,7354,5303,5317,5404,5470,5472,5550,5670,5629,5630,5798,345,11457,5724,5608,5669,71,930,5341,5392,314,11477,5291,5530,3932,4100,4323,834,7353,5643,4144,5311,5560,5487,5398,305,5345,5232,3325,11454,1634,5644,5390,4285,3943,527,5463,3513,918,248,266,519,526,338,315,348,358,261,335,11583,11582,11580,11648,11445,6944,1600,11654,11656,11659,11685,6315,11694,11686,4261,3018,2477,5917,3526,11721,6904,6228,11529,11684,11682,11564,11672,11741,839,11562,182,11826,11521,11683,11595,945,11838,11852,11586,11588,11594,11862,11540,11678,11870,11861,6200,11499,11561,11611,11458,11585,11548,6118,3113,11566,11929,11565,11600,2746,11959,11989,11834,11449,11519,11563,5937,2397,1965,2492,11555,11465,11722,11538,11593,11560,11451,12101,12103,23,11856,11855,3940,4265,11690,11663,11860,11660,11859,11552,11661,11858,11857,12062,6377,11662,11691,12068,6683,11581,1951,11830,11831,11976,11824,2022,12247,89,12747,3961,11833,13503,3444,5611,11447,14460,14469,197,14691,14712,14713,14740,14754,14758,14777,14782,14783,14784,14789,4302,15165,15283,15333,15345,11681,3726,11673,11671,2481,11596,11614,2027,2471,2742,2408,5600,11518,7382,16064,11482,11480,11598,11599,11615,3464,11827,11829,268,1624,11670,1651,11578,6635,1937,6674,2051,2042,1758,7367,1816,1817,1823,1831,1832,1834,1848,1884,1943,1949,2131,2311,2419,2440,2501,2577,2588,2657,2750,2772,1888,2783,2786,2807,2814,2996,3515,3560,3477,3595,3684,3715,3736,3771,3819,3888,3908,3924,4259,4277,4112,4309,5286,5235,5692,5572,5717,5619,5729,5804,6108,6077,6047,6209,6210,6243,6392,6404,6623,6673,6677,6678,6869,6851,7394,6931,6932,6953,6994,7078,7083,7098,7099,7142,7160,7174,14478,1780,16114,16115,11492,3652,11620,16140,12741,6397,1607,16048,1632,11549,11617,11688,5673,1655,1661,1694,1720,3399,5238,5726,5810,6240,6619,7390,7065,7091,7166,7283,436,16171,16112,6659,7147,5919,16219,11623,6097,11618,11621,64,927,2532,16277,1650,239,11536,222,175,3468,16305,16310,16324,11547,336,38,2773,435,5575,11567,103,137,16383,16388,16386,16288,16285,940,11864,11557,16400,16427,16398,5482,2500,16430,16440,16441,11568,16399,16446,16402,16450,16049,11446,16455,16445,11612,16454,16457,16458,1972,5948,5814,228,16449,11520,16472,16473,16464,16465,16471,16453,16466,16467,6277,16401,16482,16483,16484,16485,16486,16476,11550,16487,16488,16489,16490,16492,16493,16491,16495,16496,16165,16498,16499,16500,16514,16515,16340,16372,16403,11616,16524,16518,16513,16526,16535,6824,2946,16538,16532,16554,16555,6752,944,16557,16468,4370,16559,297,16560,16534,16404,11619,2146,1924,11603,55,11607,2437,2776,2836,7143,4171,949,16599,16517,11604,16609,11602,11500,11622,16616,6625,16623,16734,16326,16735,16736,16737,16739,16766,14412,16767,16768,16773,2970,7458,16784,16785,16788,16738,16790,16792,16793,16800,16802,16803,16804,16805,16806,16808,16809,16810,16814,16815,16816,16817,16820,16822,16823,16825,16826,16830,16831,16832,16834,16835,16842,16847,16851,16852,16853,16856,16857,16858,156,5986,16958,17017,17031,17035,17038,17052,17046,17051,17045,17041,17047,17042,17048,17043,17049,17044,17050,17058,17059,17072,17074,16548,17097,17098,17056,17107,17108,5518,7319,17117,17122,17124,17131,17141,17142,17152,17157,17158,17178,17170,17172,17165,17164,17167,17160,17179,17181,17161,17159,17162,17174,17153,17163,17156,17166,17168,17173,17177,17176,17180,17175,17169,17132,17187,17188,17189,17190,17193,17194,17195,17196,17197,17199,17200,17210,17211,17212,17171,17214,17215,17219,17221,17226,17234,17242,17243,17268,17283,17388,17398,17432,17514,17515,17519,17521,7460,17526,17527,17528,17532,17533,17544,17545,16497,17576,17577,17583,17592,17593,17594,17597,16564,17609,17614,17617,16424,17643,16563,16585,17755,16859,17252,17820,17821,17656,17826,17827,17121,17830,17833,17834,17835,17836,17843,17634,17844,17657,17659,17658,17660,17846,17851,17852,17853,17854,17856,17857,17858,17860,17861,17863,17864,17865,17869,17870,17876,17877,17891,17899,17906,17907,17912,17913,17923,17939,17940,17956,17968,17969,17970,17974,17977,17979,17980,17981,17995,18016,18042,18064,18066,18079,18096,18097,18119,18120,18122,18123,18125,18126,18127,18134,18135,18137,18188,18211,18223,18228,18224,18246,18281,18325,18121,18340,18376,18391,18402,18409,18419,18453,18471,18492,18499,17848,18509,18510,18511,18513,18515,18516,18517,18518,18520,18533,18534,18535,18536,18537,18541,18543,18544,18546,18561,18568,18570,18548,18549,18554,18552,18551,18555,18550,18557,18553,18560,18559,18702,18714,18715,18716,18717,18718,18719,18720,17118,18733,18734,18735,18745,18791,18798,18808,18829,18830,18836,18839,18841,18842,18843,18845,18846,18847,18848,18849,18860,18810,18863,18864,18865,167,18866,18869,18876,18877,18883,18884,18885,18886,18887,18888,18898,18900,18901,18902,18899,18892,18891,18893,18890,18889,18916,18918,18921,18922,18930,18929,19017,19019,19023,19046,19050,19054,19056,6095,11832,1676,2608,19235,19236,3158,18564,16547,18569,11828,18136,19317,509,19320,19321,19322,6693,16519,18030,16819,17433,2575,11624,11601,19378,7216,18556,19398,19401,19105,19554,19555,19556,19626,19627,19628,19633,19634,19645,19646,19659,19666,19667,19668,18371,19712,19713,19714,19715,16525,19720,19721,19725,19727,19728,19730,19731,19732,19733,19734,19737,19741,19742,19743,19744,19745,19767,19768,19769,19770,19771,19772,19773,19774,19783,19799,19814,19820,19817,19826,19833,19831,19829,19828,19830,19840,19841,19852,19853,19854,19827,19855,19856,19857,19859,19862,19863,19864,19872,19832,19945,19946,19719,19995,20001,20002,20005,20035,20050,20051,3430,20056,20065,20066,20067,20071,20073,20074,20075,20084,20085,20086,20089,16556,5492,15904,15907,5513,5244,20088,20094,20095,20096,20165,20171,20172,20176,20177,20178,20179,20180,20181,20184,20173,20202,20206,20207,20217,20230,20231,20237,20238,20272,20281,20290,20294,20295,20303,2089,20309,20310,20315,5310,20321,20328,20333,20334,20340,20347,20348,20350,20352,20387,20487,20488,20489,20490,20491,20496,20498,20499,20500,20501,20511,20515,20520,20527,20534,20535,20539,20529,20540,20548,20536,20547,20545,20543,20544,20541,20531,20530,20532,20533,20552,20553,19740,20554,20555,20556,20557,20558,20559,20560,20561,20562,20563,20564,20565,20566,20567,20568,20571,20574,20575,20577,20578,20580,20581,20582,20583,20584,20585,20586,20587,20588,20589,20611,20612,20618,20622,20623,20625,20627,20628,20630,20631,20632,20633,20634,20637,20647,20648,20650,20651,20658,20661,20662,20663,20664,20665,20666,20667,20604,20668,20599,20596,20602,20603,20598,20594,20593,20592,20672,20737,20738,20742,20743,20744,20745,20750,20763,20764,20765,20782,20772,20774,20546,20770,20781,20780,20771,20779,20778,20777,20776,20775,20755,20773,20752,20794,20796,20798,20799,20800,20801,20802,20803,20804,20805,20808,20807,20809,20810,20811,20815,20816,20817,20818,20819,20844,20845,20846,20848,20849,20850,20852,20853,20854,20855,20857,20862,20865,20866,20867,20868,20869,20870,20884,20885,20887,20888,20889,20890,20891,20895,20896,20897,20898,20899,20756,20900,20901,20902,20905,20911,20925,20927,20928,20930,20939,20940,20942,20943,20944,20946,20947,20948,20949,20960,20961,20964,20938,20965,18642,21017,21018,21019,21027,21028,21040,21041,21042,21043,21044,21045,21047,21049,21055,21053,21054,21061,21062,21067,21068,21073,21074,21075,21076,21077,21078,21080,21081,21082,21083,21084,21085,21086,21087,21088,21089,21090,21093,21094,21095,21096,21097,21098,21099,21100,21101,21102,21103,21104,21106,21107,21108,21109,21110,21111,21112,21113,21114,21115,21117,21118,21119,21120,21121,21123,21124,21125,21126,21127,21128,21129,21130,21131,21132,21133,21134,21135,21136,21137,21138,21139,21140,21141,21142,21145,21146,21147,21148,21149,21150,21151,20955,20957,21025,21016,21155,21156,21159,21160,21161,21162,21163,2943,11558,5921,21169,1940,21172,21173,21174,21175,21178,21179,21183,21184,21187,21195,21197,21198,21200,21201,21217,21218,21219,21220,21221,21227,21233,21252,21257,21258,21265,21266,21267,21269,21270,21271,6346,21284,3007,21285,21286,21287,21288,21289,21292,21294,21295,21303,21304,21305,21306,21307,21308,21309,21310,21311,21312,21313,21314,21315,21317,21318,21319,21320,21321,21322,21324,21325,21326,21329,21331



SELECT film_id FROM efis_film_festival WHERE
  festival_id IN (2562,3281,1196,2982,1544,1381,1390,1422,1209,1195,2679,1884,1140)
  AND film_id IN (1649,1759,1762,1801,1803,1900,1913,1970,1981,1982,2363,2434,2436,2444,2634,2778,2843,3112,3572,3589,3603,3605,3808,3904,4338,4352,4354,5324,5334,5336,5467,5491,6038,6672,6850,7077,7198,7244,7380,7415,7459,161,3668,11530,11577,11571,6684,1656,4286,11448,1977,6358,1938,6671,11592,347,11463,11590,11559,3436,11456,11517,5965,11527,11522,1630,11525,2013,11523,4013,11524,7431,512,2,2645,11526,2695,11528,1601,5,1922,1921,1909,1857,1827,1945,1950,1829,47,1612,11459,11461,1663,11462,1728,1755,1799,11439,1820,1835,2012,2016,88,11468,2543,2546,6376,517,7067,7037,7324,7085,7031,7325,7054,7089,7094,7127,7033,7425,7426,497,7168,7218,7259,503,7284,7101,7149,7150,11452,7151,7152,7410,7402,6630,6613,6525,5906,5911,11587,849,11466,2422,2592,11467,478,2650,2375,2660,2693,2677,2373,2306,2712,2741,2286,2749,2771,72,946,1952,935,1954,1966,1967,1983,1985,58,2026,2030,2037,2070,74,2261,2278,2279,115,2806,2930,2866,2878,2966,2977,3000,3027,3148,3160,3479,3478,3722,3738,3750,3755,3598,6860,6727,6756,439,3204,159,3233,3235,836,3239,3241,7384,532,6841,781,6827,11533,939,6808,6895,451,6686,6685,433,6682,6681,6680,6679,429,6676,6675,6670,6668,426,6662,6667,425,6524,6523,6517,405,415,11450,6260,6364,6345,6171,396,6164,383,6295,6147,6131,6128,6124,6096,938,374,6075,371,6051,6048,6045,6019,6016,6009,5977,5949,362,5928,5916,5856,5853,3258,169,936,3274,3287,3293,3361,3347,3360,3348,11516,3761,3800,942,3872,227,4075,4061,4035,3979,234,3974,11455,4371,4290,3286,4263,3966,4049,4133,4160,4163,4172,5222,4348,4350,4353,7354,5303,5317,5404,5470,5472,5550,5670,5629,5630,5798,345,11457,5724,5608,5669,71,930,5341,5392,314,11477,5291,5530,3932,4100,4323,834,7353,5643,4144,5311,5560,5487,5398,305,5345,5232,3325,11454,1634,5644,5390,4285,3943,527,5463,3513,918,248,266,519,526,338,315,348,358,261,335,11583,11582,11580,11648,11445,6944,1600,11654,11656,11659,11685,6315,11694,11686,4261,3018,2477,5917,3526,11721,6904,6228,11529,11684,11682,11564,11672,11741,839,11562,182,11826,11521,11683,11595,945,11838,11852,11586,11588,11594,11862,11540,11678,11870,11861,6200,11499,11561,11611,11458,11585,11548,6118,3113,11566,11929,11565,11600,2746,11959,11989,11834,11449,11519,11563,5937,2397,1965,2492,11555,11465,11722,11538,11593,11560,11451,12101,12103,23,11856,11855,3940,4265,11690,11663,11860,11660,11859,11552,11661,11858,11857,12062,6377,11662,11691,12068,6683,11581,1951,11830,11831,11976,11824,2022,12247,89,12747,3961,11833,13503,3444,5611,11447,14460,14469,197,14691,14712,14713,14740,14754,14758,14777,14782,14783,14784,14789,4302,15165,15283,15333,15345,11681,3726,11673,11671,2481,11596,11614,2027,2471,2742,2408,5600,11518,7382,16064,11482,11480,11598,11599,11615,3464,11827,11829,268,1624,11670,1651,11578,6635,1937,6674,2051,2042,1758,7367,1816,1817,1823,1831,1832,1834,1848,1884,1943,1949,2131,2311,2419,2440,2501,2577,2588,2657,2750,2772,1888,2783,2786,2807,2814,2996,3515,3560,3477,3595,3684,3715,3736,3771,3819,3888,3908,3924,4259,4277,4112,4309,5286,5235,5692,5572,5717,5619,5729,5804,6108,6077,6047,6209,6210,6243,6392,6404,6623,6673,6677,6678,6869,6851,7394,6931,6932,6953,6994,7078,7083,7098,7099,7142,7160,7174,14478,1780,16114,16115,11492,3652,11620,16140,12741,6397,1607,16048,1632,11549,11617,11688,5673,1655,1661,1694,1720,3399,5238,5726,5810,6240,6619,7390,7065,7091,7166,7283,436,16171,16112,6659,7147,5919,16219,11623,6097,11618,11621,64,927,2532,16277,1650,239,11536,222,175,3468,16305,16310,16324,11547,336,38,2773,435,5575,11567,103,137,16383,16388,16386,16288,16285,940,11864,11557,16400,16427,16398,5482,2500,16430,16440,16441,11568,16399,16446,16402,16450,16049,11446,16455,16445,11612,16454,16457,16458,1972,5948,5814,228,16449,11520,16472,16473,16464,16465,16471,16453,16466,16467,6277,16401,16482,16483,16484,16485,16486,16476,11550,16487,16488,16489,16490,16492,16493,16491,16495,16496,16165,16498,16499,16500,16514,16515,16340,16372,16403,11616,16524,16518,16513,16526,16535,6824,2946,16538,16532,16554,16555,6752,944,16557,16468,4370,16559,297,16560,16534,16404,11619,2146,1924,11603,55,11607,2437,2776,2836,7143,4171,949,16599,16517,11604,16609,11602,11500,11622,16616,6625,16623,16734,16326,16735,16736,16737,16739,16766,14412,16767,16768,16773,2970,7458,16784,16785,16788,16738,16790,16792,16793,16800,16802,16803,16804,16805,16806,16808,16809,16810,16814,16815,16816,16817,16820,16822,16823,16825,16826,16830,16831,16832,16834,16835,16842,16847,16851,16852,16853,16856,16857,16858,156,5986,16958,17017,17031,17035,17038,17052,17046,17051,17045,17041,17047,17042,17048,17043,17049,17044,17050,17058,17059,17072,17074,16548,17097,17098,17056,17107,17108,5518,7319,17117,17122,17124,17131,17141,17142,17152,17157,17158,17178,17170,17172,17165,17164,17167,17160,17179,17181,17161,17159,17162,17174,17153,17163,17156,17166,17168,17173,17177,17176,17180,17175,17169,17132,17187,17188,17189,17190,17193,17194,17195,17196,17197,17199,17200,17210,17211,17212,17171,17214,17215,17219,17221,17226,17234,17242,17243,17268,17283,17388,17398,17432,17514,17515,17519,17521,7460,17526,17527,17528,17532,17533,17544,17545,16497,17576,17577,17583,17592,17593,17594,17597,16564,17609,17614,17617,16424,17643,16563,16585,17755,16859,17252,17820,17821,17656,17826,17827,17121,17830,17833,17834,17835,17836,17843,17634,17844,17657,17659,17658,17660,17846,17851,17852,17853,17854,17856,17857,17858,17860,17861,17863,17864,17865,17869,17870,17876,17877,17891,17899,17906,17907,17912,17913,17923,17939,17940,17956,17968,17969,17970,17974,17977,17979,17980,17981,17995,18016,18042,18064,18066,18079,18096,18097,18119,18120,18122,18123,18125,18126,18127,18134,18135,18137,18188,18211,18223,18228,18224,18246,18281,18325,18121,18340,18376,18391,18402,18409,18419,18453,18471,18492,18499,17848,18509,18510,18511,18513,18515,18516,18517,18518,18520,18533,18534,18535,18536,18537,18541,18543,18544,18546,18561,18568,18570,18548,18549,18554,18552,18551,18555,18550,18557,18553,18560,18559,18702,18714,18715,18716,18717,18718,18719,18720,17118,18733,18734,18735,18745,18791,18798,18808,18829,18830,18836,18839,18841,18842,18843,18845,18846,18847,18848,18849,18860,18810,18863,18864,18865,167,18866,18869,18876,18877,18883,18884,18885,18886,18887,18888,18898,18900,18901,18902,18899,18892,18891,18893,18890,18889,18916,18918,18921,18922,18930,18929,19017,19019,19023,19046,19050,19054,19056,6095,11832,1676,2608,19235,19236,3158,18564,16547,18569,11828,18136,19317,509,19320,19321,19322,6693,16519,18030,16819,17433,2575,11624,11601,19378,7216,18556,19398,19401,19105,19554,19555,19556,19626,19627,19628,19633,19634,19645,19646,19659,19666,19667,19668,18371,19712,19713,19714,19715,16525,19720,19721,19725,19727,19728,19730,19731,19732,19733,19734,19737,19741,19742,19743,19744,19745,19767,19768,19769,19770,19771,19772,19773,19774,19783,19799,19814,19820,19817,19826,19833,19831,19829,19828,19830,19840,19841,19852,19853,19854,19827,19855,19856,19857,19859,19862,19863,19864,19872,19832,19945,19946,19719,19995,20001,20002,20005,20035,20050,20051,3430,20056,20065,20066,20067,20071,20073,20074,20075,20084,20085,20086,20089,16556,5492,15904,15907,5513,5244,20088,20094,20095,20096,20165,20171,20172,20176,20177,20178,20179,20180,20181,20184,20173,20202,20206,20207,20217,20230,20231,20237,20238,20272,20281,20290,20294,20295,20303,2089,20309,20310,20315,5310,20321,20328,20333,20334,20340,20347,20348,20350,20352,20387,20487,20488,20489,20490,20491,20496,20498,20499,20500,20501,20511,20515,20520,20527,20534,20535,20539,20529,20540,20548,20536,20547,20545,20543,20544,20541,20531,20530,20532,20533,20552,20553,19740,20554,20555,20556,20557,20558,20559,20560,20561,20562,20563,20564,20565,20566,20567,20568,20571,20574,20575,20577,20578,20580,20581,20582,20583,20584,20585,20586,20587,20588,20589,20611,20612,20618,20622,20623,20625,20627,20628,20630,20631,20632,20633,20634,20637,20647,20648,20650,20651,20658,20661,20662,20663,20664,20665,20666,20667,20604,20668,20599,20596,20602,20603,20598,20594,20593,20592,20672,20737,20738,20742,20743,20744,20745,20750,20763,20764,20765,20782,20772,20774,20546,20770,20781,20780,20771,20779,20778,20777,20776,20775,20755,20773,20752,20794,20796,20798,20799,20800,20801,20802,20803,20804,20805,20808,20807,20809,20810,20811,20815,20816,20817,20818,20819,20844,20845,20846,20848,20849,20850,20852,20853,20854,20855,20857,20862,20865,20866,20867,20868,20869,20870,20884,20885,20887,20888,20889,20890,20891,20895,20896,20897,20898,20899,20756,20900,20901,20902,20905,20911,20925,20927,20928,20930,20939,20940,20942,20943,20944,20946,20947,20948,20949,20960,20961,20964,20938,20965,18642,21017,21018,21019,21027,21028,21040,21041,21042,21043,21044,21045,21047,21049,21055,21053,21054,21061,21062,21067,21068,21073,21074,21075,21076,21077,21078,21080,21081,21082,21083,21084,21085,21086,21087,21088,21089,21090,21093,21094,21095,21096,21097,21098,21099,21100,21101,21102,21103,21104,21106,21107,21108,21109,21110,21111,21112,21113,21114,21115,21117,21118,21119,21120,21121,21123,21124,21125,21126,21127,21128,21129,21130,21131,21132,21133,21134,21135,21136,21137,21138,21139,21140,21141,21142,21145,21146,21147,21148,21149,21150,21151,20955,20957,21025,21016,21155,21156,21159,21160,21161,21162,21163,2943,11558,5921,21169,1940,21172,21173,21174,21175,21178,21179,21183,21184,21187,21195,21197,21198,21200,21201,21217,21218,21219,21220,21221,21227,21233,21252,21257,21258,21265,21266,21267,21269,21270,21271,6346,21284,3007,21285,21286,21287,21288,21289,21292,21294,21295,21303,21304,21305,21306,21307,21308,21309,21310,21311,21312,21313,21314,21315,21317,21318,21319,21320,21321,21322,21324,21325,21326,21329,21331);
  
SELECT film_id AS Source, concat('fe', festival_id) AS Target FROM efis_film_festival WHERE
  festival_id IN (2562,3281,1196,2982,1544,1381,1390,1422,1209,1195,2679,1884,1140)
  AND film_id IN (1649,1759,1762,1801,1803,1900,1913,1970,1981,1982,2363,2434,2436,2444,2634,2778,2843,3112,3572,3589,3603,3605,3808,3904,4338,4352,4354,5324,5334,5336,5467,5491,6038,6672,6850,7077,7198,7244,7380,7415,7459,161,3668,11530,11577,11571,6684,1656,4286,11448,1977,6358,1938,6671,11592,347,11463,11590,11559,3436,11456,11517,5965,11527,11522,1630,11525,2013,11523,4013,11524,7431,512,2,2645,11526,2695,11528,1601,5,1922,1921,1909,1857,1827,1945,1950,1829,47,1612,11459,11461,1663,11462,1728,1755,1799,11439,1820,1835,2012,2016,88,11468,2543,2546,6376,517,7067,7037,7324,7085,7031,7325,7054,7089,7094,7127,7033,7425,7426,497,7168,7218,7259,503,7284,7101,7149,7150,11452,7151,7152,7410,7402,6630,6613,6525,5906,5911,11587,849,11466,2422,2592,11467,478,2650,2375,2660,2693,2677,2373,2306,2712,2741,2286,2749,2771,72,946,1952,935,1954,1966,1967,1983,1985,58,2026,2030,2037,2070,74,2261,2278,2279,115,2806,2930,2866,2878,2966,2977,3000,3027,3148,3160,3479,3478,3722,3738,3750,3755,3598,6860,6727,6756,439,3204,159,3233,3235,836,3239,3241,7384,532,6841,781,6827,11533,939,6808,6895,451,6686,6685,433,6682,6681,6680,6679,429,6676,6675,6670,6668,426,6662,6667,425,6524,6523,6517,405,415,11450,6260,6364,6345,6171,396,6164,383,6295,6147,6131,6128,6124,6096,938,374,6075,371,6051,6048,6045,6019,6016,6009,5977,5949,362,5928,5916,5856,5853,3258,169,936,3274,3287,3293,3361,3347,3360,3348,11516,3761,3800,942,3872,227,4075,4061,4035,3979,234,3974,11455,4371,4290,3286,4263,3966,4049,4133,4160,4163,4172,5222,4348,4350,4353,7354,5303,5317,5404,5470,5472,5550,5670,5629,5630,5798,345,11457,5724,5608,5669,71,930,5341,5392,314,11477,5291,5530,3932,4100,4323,834,7353,5643,4144,5311,5560,5487,5398,305,5345,5232,3325,11454,1634,5644,5390,4285,3943,527,5463,3513,918,248,266,519,526,338,315,348,358,261,335,11583,11582,11580,11648,11445,6944,1600,11654,11656,11659,11685,6315,11694,11686,4261,3018,2477,5917,3526,11721,6904,6228,11529,11684,11682,11564,11672,11741,839,11562,182,11826,11521,11683,11595,945,11838,11852,11586,11588,11594,11862,11540,11678,11870,11861,6200,11499,11561,11611,11458,11585,11548,6118,3113,11566,11929,11565,11600,2746,11959,11989,11834,11449,11519,11563,5937,2397,1965,2492,11555,11465,11722,11538,11593,11560,11451,12101,12103,23,11856,11855,3940,4265,11690,11663,11860,11660,11859,11552,11661,11858,11857,12062,6377,11662,11691,12068,6683,11581,1951,11830,11831,11976,11824,2022,12247,89,12747,3961,11833,13503,3444,5611,11447,14460,14469,197,14691,14712,14713,14740,14754,14758,14777,14782,14783,14784,14789,4302,15165,15283,15333,15345,11681,3726,11673,11671,2481,11596,11614,2027,2471,2742,2408,5600,11518,7382,16064,11482,11480,11598,11599,11615,3464,11827,11829,268,1624,11670,1651,11578,6635,1937,6674,2051,2042,1758,7367,1816,1817,1823,1831,1832,1834,1848,1884,1943,1949,2131,2311,2419,2440,2501,2577,2588,2657,2750,2772,1888,2783,2786,2807,2814,2996,3515,3560,3477,3595,3684,3715,3736,3771,3819,3888,3908,3924,4259,4277,4112,4309,5286,5235,5692,5572,5717,5619,5729,5804,6108,6077,6047,6209,6210,6243,6392,6404,6623,6673,6677,6678,6869,6851,7394,6931,6932,6953,6994,7078,7083,7098,7099,7142,7160,7174,14478,1780,16114,16115,11492,3652,11620,16140,12741,6397,1607,16048,1632,11549,11617,11688,5673,1655,1661,1694,1720,3399,5238,5726,5810,6240,6619,7390,7065,7091,7166,7283,436,16171,16112,6659,7147,5919,16219,11623,6097,11618,11621,64,927,2532,16277,1650,239,11536,222,175,3468,16305,16310,16324,11547,336,38,2773,435,5575,11567,103,137,16383,16388,16386,16288,16285,940,11864,11557,16400,16427,16398,5482,2500,16430,16440,16441,11568,16399,16446,16402,16450,16049,11446,16455,16445,11612,16454,16457,16458,1972,5948,5814,228,16449,11520,16472,16473,16464,16465,16471,16453,16466,16467,6277,16401,16482,16483,16484,16485,16486,16476,11550,16487,16488,16489,16490,16492,16493,16491,16495,16496,16165,16498,16499,16500,16514,16515,16340,16372,16403,11616,16524,16518,16513,16526,16535,6824,2946,16538,16532,16554,16555,6752,944,16557,16468,4370,16559,297,16560,16534,16404,11619,2146,1924,11603,55,11607,2437,2776,2836,7143,4171,949,16599,16517,11604,16609,11602,11500,11622,16616,6625,16623,16734,16326,16735,16736,16737,16739,16766,14412,16767,16768,16773,2970,7458,16784,16785,16788,16738,16790,16792,16793,16800,16802,16803,16804,16805,16806,16808,16809,16810,16814,16815,16816,16817,16820,16822,16823,16825,16826,16830,16831,16832,16834,16835,16842,16847,16851,16852,16853,16856,16857,16858,156,5986,16958,17017,17031,17035,17038,17052,17046,17051,17045,17041,17047,17042,17048,17043,17049,17044,17050,17058,17059,17072,17074,16548,17097,17098,17056,17107,17108,5518,7319,17117,17122,17124,17131,17141,17142,17152,17157,17158,17178,17170,17172,17165,17164,17167,17160,17179,17181,17161,17159,17162,17174,17153,17163,17156,17166,17168,17173,17177,17176,17180,17175,17169,17132,17187,17188,17189,17190,17193,17194,17195,17196,17197,17199,17200,17210,17211,17212,17171,17214,17215,17219,17221,17226,17234,17242,17243,17268,17283,17388,17398,17432,17514,17515,17519,17521,7460,17526,17527,17528,17532,17533,17544,17545,16497,17576,17577,17583,17592,17593,17594,17597,16564,17609,17614,17617,16424,17643,16563,16585,17755,16859,17252,17820,17821,17656,17826,17827,17121,17830,17833,17834,17835,17836,17843,17634,17844,17657,17659,17658,17660,17846,17851,17852,17853,17854,17856,17857,17858,17860,17861,17863,17864,17865,17869,17870,17876,17877,17891,17899,17906,17907,17912,17913,17923,17939,17940,17956,17968,17969,17970,17974,17977,17979,17980,17981,17995,18016,18042,18064,18066,18079,18096,18097,18119,18120,18122,18123,18125,18126,18127,18134,18135,18137,18188,18211,18223,18228,18224,18246,18281,18325,18121,18340,18376,18391,18402,18409,18419,18453,18471,18492,18499,17848,18509,18510,18511,18513,18515,18516,18517,18518,18520,18533,18534,18535,18536,18537,18541,18543,18544,18546,18561,18568,18570,18548,18549,18554,18552,18551,18555,18550,18557,18553,18560,18559,18702,18714,18715,18716,18717,18718,18719,18720,17118,18733,18734,18735,18745,18791,18798,18808,18829,18830,18836,18839,18841,18842,18843,18845,18846,18847,18848,18849,18860,18810,18863,18864,18865,167,18866,18869,18876,18877,18883,18884,18885,18886,18887,18888,18898,18900,18901,18902,18899,18892,18891,18893,18890,18889,18916,18918,18921,18922,18930,18929,19017,19019,19023,19046,19050,19054,19056,6095,11832,1676,2608,19235,19236,3158,18564,16547,18569,11828,18136,19317,509,19320,19321,19322,6693,16519,18030,16819,17433,2575,11624,11601,19378,7216,18556,19398,19401,19105,19554,19555,19556,19626,19627,19628,19633,19634,19645,19646,19659,19666,19667,19668,18371,19712,19713,19714,19715,16525,19720,19721,19725,19727,19728,19730,19731,19732,19733,19734,19737,19741,19742,19743,19744,19745,19767,19768,19769,19770,19771,19772,19773,19774,19783,19799,19814,19820,19817,19826,19833,19831,19829,19828,19830,19840,19841,19852,19853,19854,19827,19855,19856,19857,19859,19862,19863,19864,19872,19832,19945,19946,19719,19995,20001,20002,20005,20035,20050,20051,3430,20056,20065,20066,20067,20071,20073,20074,20075,20084,20085,20086,20089,16556,5492,15904,15907,5513,5244,20088,20094,20095,20096,20165,20171,20172,20176,20177,20178,20179,20180,20181,20184,20173,20202,20206,20207,20217,20230,20231,20237,20238,20272,20281,20290,20294,20295,20303,2089,20309,20310,20315,5310,20321,20328,20333,20334,20340,20347,20348,20350,20352,20387,20487,20488,20489,20490,20491,20496,20498,20499,20500,20501,20511,20515,20520,20527,20534,20535,20539,20529,20540,20548,20536,20547,20545,20543,20544,20541,20531,20530,20532,20533,20552,20553,19740,20554,20555,20556,20557,20558,20559,20560,20561,20562,20563,20564,20565,20566,20567,20568,20571,20574,20575,20577,20578,20580,20581,20582,20583,20584,20585,20586,20587,20588,20589,20611,20612,20618,20622,20623,20625,20627,20628,20630,20631,20632,20633,20634,20637,20647,20648,20650,20651,20658,20661,20662,20663,20664,20665,20666,20667,20604,20668,20599,20596,20602,20603,20598,20594,20593,20592,20672,20737,20738,20742,20743,20744,20745,20750,20763,20764,20765,20782,20772,20774,20546,20770,20781,20780,20771,20779,20778,20777,20776,20775,20755,20773,20752,20794,20796,20798,20799,20800,20801,20802,20803,20804,20805,20808,20807,20809,20810,20811,20815,20816,20817,20818,20819,20844,20845,20846,20848,20849,20850,20852,20853,20854,20855,20857,20862,20865,20866,20867,20868,20869,20870,20884,20885,20887,20888,20889,20890,20891,20895,20896,20897,20898,20899,20756,20900,20901,20902,20905,20911,20925,20927,20928,20930,20939,20940,20942,20943,20944,20946,20947,20948,20949,20960,20961,20964,20938,20965,18642,21017,21018,21019,21027,21028,21040,21041,21042,21043,21044,21045,21047,21049,21055,21053,21054,21061,21062,21067,21068,21073,21074,21075,21076,21077,21078,21080,21081,21082,21083,21084,21085,21086,21087,21088,21089,21090,21093,21094,21095,21096,21097,21098,21099,21100,21101,21102,21103,21104,21106,21107,21108,21109,21110,21111,21112,21113,21114,21115,21117,21118,21119,21120,21121,21123,21124,21125,21126,21127,21128,21129,21130,21131,21132,21133,21134,21135,21136,21137,21138,21139,21140,21141,21142,21145,21146,21147,21148,21149,21150,21151,20955,20957,21025,21016,21155,21156,21159,21160,21161,21162,21163,2943,11558,5921,21169,1940,21172,21173,21174,21175,21178,21179,21183,21184,21187,21195,21197,21198,21200,21201,21217,21218,21219,21220,21221,21227,21233,21252,21257,21258,21265,21266,21267,21269,21270,21271,6346,21284,3007,21285,21286,21287,21288,21289,21292,21294,21295,21303,21304,21305,21306,21307,21308,21309,21310,21311,21312,21313,21314,21315,21317,21318,21319,21320,21321,21322,21324,21325,21326,21329,21331);
  
  
tudengifilmid suurtel festivalidel
  23,38,103,156,167,182,228,305,315,433,436,497,512,526,527,849,930,936,939,1600,1630,1632,1817,2013,2037,2146,2286,2373,2608,2645,2660,2771,2866,2878,3027,3160,3325,3347,3348,3360,3726,3924,3961,4049,4075,4144,4160,4261,4302,4353,4370,4371,5235,5611,5630,5669,5670,5921,6019,6051,6097,6118,6260,6277,6345,6376,6625,6635,6676,6693,6727,6752,6860,6932,6944,7083,7098,7127,7142,7166,7244,7431,11462,11480,11482,11492,11522,11558,11681,11682,11683,11929,11959,11976,14412,14460,14712,14713,15165,15904,16112,16114,16165,16171,16277,16326,16372,16398,16399,16404,16427,16430,16445,16446,16453,16454,16457,16467,16492,16519,16547,16548,16559,16737,16766,16790,16800,16805,16806,16809,16810,17121,17242,17576,17634,17755,17830,17846,17923,17969,17974,17979,17995,18371,18499,18509,18534,18548,18549,18550,18557,18570,18791,18836,18839,18863,18864,18869,18900,19321,19659,19666,19668,19732,19855,19862,20005,20035,20065,20066,20067,20084,20085,20086,20089,20176,20202,20281,20290,20328,20488,20489,20499,20501,20527,20529,20533,20534

Mitmel
23,38,103,182,228,315,433,436,497,512,849,936,939,1600,1630,1632,2013,2037,2146,2373,2608,2645,2660,2866,2878,3027,3160,3325,3347,3348,3726,3924,3961,4049,4075,4144,4160,4261,4302,4370,4371,5235,5611,5630,5670,6019,6051,6097,6260,6277,6345,6376,6625,6727,6752,6932,6944,7083,7098,7127,7142,7166,7244,7431,11462,11480,11482,11492,11522,11558,11682,11683,11929,11959,11976,14412,14460,14712,14713,15165,15904,16112,16114,16165,16171,16277,16326,16398,16399,16404,16427,16430,16445,16446,16453,16454,16457,16467,16492,16519,16547,16559,16737,16766,16790,16800,16805,16806,16809,16810,17121,17755,18499,18509,18836,18900,19732,20005,20065,20085,20281,20488,20489,20527,20529,20533,20535,20539,20546,20553,20627,20628,20651,20742,20743,20744,20755,20765,20770,20773,20844,20846,20852,20854,20857,20862,20870,20889,20890,20891,20895,20899,20901,20902,20905,20930,20942,20955,20957,20964,21025,21043,21053,21054,21089,21100,21117,21124,21129,21133,21195,21197,21198,21200,21201,21289



  
SELECT film_id AS Id, title_proper AS Label FROM efis_film_translation WHERE
  language='en'
  AND film_id IN (23,38,103,182,228,315,433,436,497,512,849,936,939,1600,1630,1632,2013,2037,2146,2373,2608,2645,2660,2866,2878,3027,3160,3325,3347,3348,3726,3924,3961,4049,4075,4144,4160,4261,4302,4370,4371,5235,5611,5630,5670,6019,6051,6097,6260,6277,6345,6376,6625,6727,6752,6932,6944,7083,7098,7127,7142,7166,7244,7431,11462,11480,11482,11492,11522,11558,11682,11683,11929,11959,11976,14412,14460,14712,14713,15165,15904,16112,16114,16165,16171,16277,16326,16398,16399,16404,16427,16430,16445,16446,16453,16454,16457,16467,16492,16519,16547,16559,16737,16766,16790,16800,16805,16806,16809,16810,17121,17755,18499,18509,18836,18900,19732,20005,20065,20085,20281,20488,20489,20527,20529,20533,20535,20539,20546,20553,20627,20628,20651,20742,20743,20744,20755,20765,20770,20773,20844,20846,20852,20854,20857,20862,20870,20889,20890,20891,20895,20899,20901,20902,20905,20930,20942,20955,20957,20964,21025,21043,21053,21054,21089,21100,21117,21124,21129,21133,21195,21197,21198,21200,21201,21289);