create table oscar_film(id int(11)  ,ev int(11)  ,nyert boolean  ,magyar varchar(100)  ,cim varchar(100)  ,bemutato date  );
 
ALTER TABLE oscar_film ADD PRIMARY KEY(id);

 INSERT INTO oscar_film VALUES
( 179,1928,1,"Szárnyak","Wings",null),
( 330,1928,0,"A hetedik mennyország","7th Heaven",null),
( 468,1928,0,"A bűnbanda","The Racket",null),
( 236,1929,0,null,"In Old Arizona",null),
( 302,1929,0,"Alibi","Alibi",null),
( 419,1929,1,"Broadway Melody","The Broadway Melody","1930-02-20"),
( 446,1929,0,"Ez Hollywood","The Hollywood Revue of 1929","1930-01-21"),
( 536,1929,0,null,"The Patriot",null),
( 1,1930,0,"Örök szerelem","The Love Parade","1930-10-03"),
( 170,1930,1,"Nyugaton a helyzet változatlan","All Quiet on the Western Front",null),
( 318,1930,0,null,"The Big House",null),
( 473,1930,0,null,"The Divorcee","1932-01-01"),
( 477,1930,0,null,"Disraeli",null),
( 88,1931,0,"Címlapsztori","The Front Page",null),
( 217,1931,0,null,"Skippy",null),
( 229,1931,0,null,"East Lynne",null),
( 344,1931,0,null,"Trader Horn",null),
( 533,1931,1,null,"Cimarron",null),
( 108,1932,0,"A mosolygó hadnagy","The Smiling Lieutenant","1931-10-10"),
( 118,1932,1,"Grand Hotel","Grand Hotel",null),
( 156,1932,0,"Shanghai Express","Shanghai Express","1932-03-11"),
( 163,1932,0,"A bajnok","The Champ",null),
( 281,1932,0,null,"Five Star Final",null),
( 399,1932,0,"Édes pásztoróra","One Hour with You","1932-04-21"),
( 470,1932,0,"Rossz lány","Bad Girl",null),
( 512,1932,0,null,"Arrowsmith","1934-04-26"),
( 19,1933,0,"VIII. Henrik magánélete","The Private Life of Henry VIII","1934-02-14"),
( 44,1933,0,"Fiatal asszonyok","Little Women","1934-02-14"),
( 143,1933,0,null,"State Fair",null),
( 159,1933,0,null,"Smilin' Through","1933-12-11"),
( 215,1933,0,"Lady egy napra","Lady for a Day","1934-03-18"),
( 336,1933,0,"Búcsú a fegyverektől","A Farewell to Arms","1933-08-26"),
( 338,1933,0,"42. utca foglya","42nd Street",null),
( 411,1933,0,null,"She Done Him Wrong",null),
( 424,1933,0,"Szökevény vagyok","I Am a Fugitive from a Chain Gang","1933-04-15"),
( 457,1933,1,"Kavalkád","Cavalcade","1933-11-29"),
( 31,1934,0,"Látszatélet","Imitation of Life","1935-03-04"),
( 95,1934,0,"Jönnek a tengerészek","Here Comes The Navy","1935-04-11"),
( 102,1934,0,"Csak nekem dalolj","One Night of Love","1934-11-09"),
( 136,1934,1,"Ez történt egy éjszaka","It Happened One Night","1935-01-10"),
( 226,1934,0,"Cleopatra","Cleopatra","1934-11-22"),
( 306,1934,0,null,"Flirtation Walk","1935-04-18"),
( 312,1934,0,"A cingár férfi/Tetemrehívás","The Thin Man","1935-03-19"),
( 345,1934,0,"Continental","The Gay Divorcee","1935-10-03"),
( 369,1934,0,"Asszonyok fehérben","The White Parade","1935-05-08"),
( 414,1934,0,"A Wimpole Street-i Barrettek","The Barretts of Wimpole Street","1935-04-04"),
( 499,1934,0,null,"The House of Rothschild",null),
( 527,1934,0,"Viva Villa","Viva Villa!","1934-12-25"),
( 3,1935,0,"A hindu lándzsás","The Lives of a Bengal Lancer","1935-04-05"),
( 24,1935,0,"Blood kapitány","Captain Blood","1936-02-27"),
( 25,1935,0,"A besúgó","The Informer",null),
( 132,1935,0,"Broadway Melody","Broadway Melody of 1936","1936-01-10"),
( 153,1935,1,"Lázadás a Bountyn","Mutiny on the Bounty","1936-03-05"),
( 172,1935,0,null,"Ruggles of Red Gap","1935-10-10"),
( 181,1935,0,"Frakkban és klakkban","Top Hat","1936-09-28"),
( 189,1935,0,"A gályarab","Great Expectations","1935-08-01"),
( 277,1935,0,"Szentivánéji álom","A Midsummer Night's Dream","1935-11-27"),
( 314,1935,0,"Pajkos hercegnő","Naughty Marietta","1935-09-25"),
( 376,1935,0,"Copperfield Dávid","David Copperfield","1935-12-23"),
( 427,1935,0,null,"Alice Adams","1936-03-28"),
( 17,1936,0,"Louis Pasteur története","The Story of Louis Pasteur","1936-09-03"),
( 43,1936,1,"A nagy Ziegfeld","The Great Ziegfeld","1936-10-21"),
( 134,1936,0,"Rómeó és Júlia","Romeo and Juliet","1937-01-02"),
( 165,1936,0,"Három kis ördög","Three Smart Girls","1937-04-03"),
( 182,1936,0,"Két város meséje","A Tale of Two Cities","1936-09-08"),
( 321,1936,0,"Bulvár románc","Libeled Lady","1937-03-25"),
( 384,1936,0,"Váratlan örökség","Mr. Deeds Goes to Town","1937-12-22"),
( 454,1936,0,"Anthony Adverse","Anthony Adverse","1937-01-20"),
( 493,1936,0,"San Francisco","San Francisco","1936-11-18"),
( 557,1936,0,"Az élnivágyó asszony","Dodsworth","1937-03-24"),
( 15,1937,1,"Zola élete","The Life of Emile Zola","1945-04-26"),
( 92,1937,0,"Édes anyaföld","The Good Earth",null),
( 160,1937,0,"Chicago, a bűnös város","In Old Chicago","1938-08-31"),
( 207,1937,0,"A bátrak kapitánya","Captains Courageous","1937-11-25"),
( 273,1937,0,"Csillag születik","A Star is Born","1937-12-02"),
( 275,1937,0,"Kár volt hazudni","The Awful Truth","1940-04-16"),
( 377,1937,0,"Száz férfi és egy kislány","One Hundred Men and a Girl","1937-11-23"),
( 393,1937,0,"A Kék Hold völgye","Lost Horizon","1941-05-02"),
( 506,1937,0,"Álomkapu","Stage Door","1939-12-22"),
( 515,1937,0,"Zsákutca","Dead End","1937-08-27"),
( 47,1938,0,"Pygmalion","Pygmalion","1939-11-16"),
( 210,1938,0,"Jezabel","Jezebel","1939-03-20"),
( 221,1938,0,"Új bálványok","Test Pilot","1938-09-02"),
( 256,1938,0,"Robin Hood kalandjai","The Adventures of Robin Hood","1938-10-11"),
( 262,1938,0,"A nagy ábránd","La Grande Illusion",null),
( 307,1938,0,"Réztábla a kapu alatt","The Citadel",null),
( 327,1938,0,"Négy lány","Four Daughters",null),
( 367,1938,0,"Alexander’s Ragtime Band","Alexander’s Ragtime Band",null),
( 428,1938,0,"Fiúk városa","Boys Town","1939-02-20"),
( 450,1938,1,"Így élni jó","You Can't Take It With You","1941-04-02"),
( 40,1939,0,"Óz, a csodák csodája","The Wizard of Oz","1940-03-21"),
( 72,1939,0,"Későn jött boldogság","Dark Victory","1939-08-28"),
( 103,1939,0,"Becsületből elégtelen","Mr. Smith Goes to Washington","1941-09-24"),
( 190,1939,0,"Üvöltő szelek","Wuthering Heights","1940-04-18"),
( 216,1939,0,"Ninocska","Ninotchka","1941-12-22"),
( 224,1939,0,"Egerek és emberek","Of Mice and Men","1947-11-27"),
( 481,1939,1,"Elfújta a szél","Gone With the Wind",null),
( 494,1939,0,"Isten vele, tanár úr!","Goodbye, Mr. Chips","1939-08-31"),
( 524,1939,0,"Várlak.../Szerelmi történet","Love Affair","1939-10-20"),
( 545,1939,0,"Hatosfogat","Stagecoach","1941-02-20"),
( 119,1940,0,"Boszorkánykonyha","Foreign Correspondent","1948-05-27"),
( 258,1940,0,"Minden és ráadásul az ég","All This and Heaven Too","1941-01-03"),
( 365,1940,0,"Philadelphiai történet","The Philadelphia Story",null),
( 408,1940,0,"Leánysors","Kitty Foyle","1947-08-07"),
( 409,1940,0,"A diktátor","The Great Dictator","1947-12-19"),
( 445,1940,0,"A levél","The Letter","1947-11-13"),
( 489,1940,1,"A Manderley-ház asszonya","Rebecca","1941-02-18"),
( 495,1940,0,"A mi kis városunk","Our Town",null),
( 543,1940,0,"Érik a gyümölcs","The Grapes of Wrath","1941-05-27"),
( 548,1940,0,"Hosszú út hazáig","The Long Voyage Home",null),
( 41,1941,0,"Aranypolgár","Citizen Kane","1947-07-28"),
( 101,1941,0,"A kis rókák","The Little Foxes",null),
( 144,1941,0,"Gyanakvó szerelem","Suspicion","1947-03-15"),
( 173,1941,0,"Virágok a porban","Blossoms in the Dust",null),
( 176,1941,1,"Hová lettél, drága völgyünk?","How Green Was My Valley","1947-01-17"),
( 329,1941,0,"York őrmester","Sergeant York","1947-01-29"),
( 366,1941,0,"A máltai sólyom","The Maltese Falcon",null),
( 458,1941,0,null,"Hold Back the Dawn","1945-12-27"),
( 469,1941,0,"Zűrzavar a mennyországban","Here Comes Mr. Jordan","1945-11-10"),
( 556,1941,0,null,"One Foot in Heaven",null),
( 23,1942,0,null,"Yankee Doodle Dandy","1947-03-14"),
( 70,1942,0,"A Yankee-k dicsősége","The Pride of the Yankees",null),
( 121,1942,1,"Mrs. Miniver","Mrs. Miniver","1947-01-31"),
( 232,1942,0,"A negyvenkilences szélességi fok/A 49. szélességi fok","49th Parallel",null),
( 250,1942,0,null,"Wake Island",null),
( 254,1942,0,"Megtalált évek","Random Harvest","1947-09-04"),
( 287,1942,0,null,"The Pied Piper",null),
( 361,1942,0,"A vádlott közbeszól","The Talk of the Town","1947-04-30"),
( 461,1942,0,"Királyok sora","Kings Row",null),
( 552,1942,0,"Az Ambersonok tündöklése és bukása","The Magnificent Ambersons",null),
( 130,1943,0,"Az élet komédiája","The Human Comedy","1945-11-01"),
( 164,1943,1,"Casablanca","Casablanca","1947-01-30"),
( 183,1943,0,"Rendületlenül","In Which We Serve","1945-11-28"),
( 261,1943,0,"Akiért a harang szól","For Whom the Bell Tolls",null),
( 356,1943,0,"Társbérlet","The More the Merrier","1946-12-04"),
( 392,1943,0,"Különös eset","The Ox-Bow Incident",null),
( 426,1943,0,"Ép testben épp, hogy élek","Heaven Can Wait",null),
( 435,1943,0,"Őrség a Rajnán","Watch on the Rhine",null),
( 455,1943,0,"Bernadette","The Song of Bernadette","1947-12-22"),
( 500,1943,0,"Madame Curie","Madame Curie","1948-02-03"),
( 46,1944,1,"A magam útját járom","Going My Way","1947-09-08"),
( 142,1944,0,"Gázláng","Gaslight","1947-08-14"),
( 339,1944,0,"Wilson","Wilson",null),
( 391,1944,0,"Gyilkos vagyok","Double Indemnity","1947-05-29"),
( 442,1944,0,"Mióta távol vagy","Since You Went Away",null),
( 131,1945,0,"Szent Mary harangjai","The Bells of St. Mary's",null),
( 298,1945,0,"Elbűvölve","Spellbound",null),
( 331,1945,0,"Horgonyt fel!","Anchors Aweigh",null),
( 332,1945,0,"Mildred Pierce","Mildred Pierce",null),
( 480,1945,1,"Férfiszenvedély","The Lost Weekend","1947-06-12"),
( 138,1946,0,"Az őzgida","The Yearling",null),
( 223,1946,0,"Az élet csodaszép","It's a Wonderful Life",null),
( 374,1946,0,"V. Henrik","Henry V","1948-04-22"),
( 379,1946,1,"Életünk legszebb évei","The Best Years of Our Lives",null),
( 416,1946,0,"A borotva éle","The Razor’s Edge",null),
( 22,1947,0,"A püspök felesége","The Bishop’s Wife",null),
( 147,1947,0,"Szép remények","Great Expectations",null),
( 269,1947,1,"Úri becsületszó","Gentleman’s Agreement",null),
( 359,1947,0,"Kereszttűz","Crossfire",null),
( 551,1947,0,"Csoda a 34. utcában","Miracle on 34th Street",null),
( 247,1948,0,null,"The Snake Pit",null),
( 274,1948,0,"Johnny Belinda","Johnny Belinda",null),
( 363,1948,1,"Hamlet","Hamlet","1949-01-06"),
( 433,1948,0,"Piros cipellők","The Red Shoes",null),
( 449,1948,0,"A Sierra Madre kincse","The Treasure of the Sierra Madre",null),
( 67,1949,0,"Az örökösnő","The Heiress",null),
( 105,1949,0,"Szárnyaló bátorság","Twelve O’Clock High",null),
( 129,1949,0,null,"A Letter to Three Wives",null),
( 267,1949,0,"Csatatér","Battleground",null),
( 268,1949,1,"A király összes embere","All the King’s Men",null),
( 8,1950,1,"Mindent Éváról","All About Eve",null),
( 272,1950,0,null,"Father of the Bride",null),
( 328,1950,0,"Alkony sugárút","Sunset Blvd.",null),
( 348,1950,0,"Salamon király kincse","King Solomon’s Mines",null),
( 523,1950,0,null,"Born Yesterday",null),
( 4,1951,0,null,"A Place in the Sun",null),
( 42,1951,1,"Egy amerikai Párizsban","An American in Paris","1965-06-17"),
( 234,1951,0,null,"Decision Before Dawn",null),
( 482,1951,0,"Quo Vadis?","Quo Vadis?",null),
( 542,1951,0,"A vágy villamosa","A Streetcar Named Desire",null),
( 69,1952,0,"A nyugodt férfi","The Quiet Man",null),
( 116,1952,0,"Ivanhoe","Ivanhoe",null),
( 280,1952,0,"Moulin Rouge","Moulin Rouge","1957-09-12"),
( 358,1952,1,"A földkerekség legnagyobb show-ja","The Greatest Show on Earth",null),
( 529,1952,0,"Délidő","High Noon","2020-11-01"),
( 127,1953,0,"Idegen a vadnyugaton","Shane",null),
( 320,1953,0,"Julius Caesar","Julius Caesar","1961-12-14"),
( 436,1953,0,"A palást","The Robe",null),
( 541,1953,0,"Római vakáció","Roman Holiday","1958-07-31"),
( 549,1953,1,"Most és mindörökké","From Here to Eternity","1987-09-17"),
( 252,1954,0,"A vidéki lány","The Country Girl","1960-05-12"),
( 396,1954,1,"A rakparton","On the Waterfront",null),
( 430,1954,0,"Hét menyasszony hét fivérnek","Seven Brides for Seven Brothers",null),
( 443,1954,0,"Három pénzdarab a szökőkútban","Three Coins in the Fountain",null),
( 492,1954,0,"Zendülés a Caine hadihajón","The Caine Mutiny",null),
( 10,1955,0,null,"Love Is a Many-Splendored Thing",null),
( 91,1955,1,"Marty","Marty","1958-01-23"),
( 140,1955,0,"Mr. Roberts","Mr. Roberts",null),
( 353,1955,0,"Piknik","Picnic",null),
( 460,1955,0,null,"The Rose Tattoo",null),
( 55,1956,1,"80 nap alatt a Föld körül","Around the World in 80 Days","1961-06-29"),
( 271,1956,0,"Anna és a sziámi király","The King and I",null),
( 343,1956,0,"Az óriás","Giant",null),
( 372,1956,0,"Szemben az erőszakkal","Friendly Persuasion",null),
( 431,1956,0,"Tízparancsolat","The Ten Commandments",null),
( 177,1957,0,"Szajonara","Sayonara",null),
( 265,1957,1,"Híd a Kwai folyón","The Bridge on the River Kwai","1988-08-18"),
( 467,1957,0,"A vád tanúja","Witness for the Prosecution","1962-01-22"),
( 539,1957,0,null,"Peyton Place",null),
( 555,1957,0,"Tizenkét dühös ember","12 Angry Men","1960-01-28"),
( 82,1958,0,"Külön asztalok","Separate Tables","1964-03-26"),
( 192,1958,1,"Gigi","Gigi",null),
( 347,1958,0,"A megbilincseltek","The Defiant Ones","1960-10-06"),
( 498,1958,0,null,"Auntie Mame",null),
( 535,1958,0,"Macska a forró bádogtetőn","Cat on a Hot Tin Roof",null),
( 21,1959,1,"Ben-Hur","Ben-Hur","1982-08-26"),
( 244,1959,0,"Anne Frank naplója","The Diary of Anne Frank","1965-04-08"),
( 351,1959,0,"Egy gyilkosság anatómiája","Anatomy of a Murder",null),
( 373,1959,0,"Egy apáca története","The Nun’s Story",null),
( 382,1959,0,"Hely a tetőn","Room at the Top","1960-06-02"),
( 76,1960,0,"Alamo","The Alamo",null),
( 202,1960,0,"Elmer Gantry","Elmer Gantry",null),
( 342,1960,0,"Csavargók","The Sundowners",null),
( 364,1960,0,null,"Sons and Lovers",null),
( 401,1960,1,"Legénylakás","The Apartment","1961-07-27"),
( 30,1961,0,"Fanny","Fanny",null),
( 86,1961,0,"A svindler","The Hustler",null),
( 125,1961,1,"West Side Story","West Side Story","1973-01-18"),
( 415,1961,0,"Navarone ágyúi","The Guns of Navarone",null),
( 491,1961,0,"Ítélet Nürnbergben","Judgment at Nuremberg","1966-01-27"),
( 6,1962,0,"A leghosszabb nap","The Longest Day",null),
( 32,1962,0,"A muzsikus","The Music Man",null),
( 295,1962,1,"Arábiai Lawrence","Lawrence of Arabia",null),
( 400,1962,0,"Ne bántsátok a feketerigót!","To Kill a Mockingbird",null),
( 471,1962,0,"Lázadás a Bountyn","Mutiny on the Bounty","1973-02-15"),
( 29,1963,0,"A vadnyugat hőskora","How the West Was Won","1979-07-12"),
( 150,1963,0,"Amerika, Amerika","America, America","1965-11-11"),
( 208,1963,0,"Nézzétek a mező liliomait!","Lilies of the Field",null),
( 360,1963,0,"Kleopátra","Cleopatra","1968-04-18"),
( 425,1963,1,"Tom Jones","Tom Jones","1966-12-08"),
( 12,1964,0,"Becket","Becket",null),
( 100,1964,0,"Dr. Strangelove, avagy rájöttem, hogy nem kell félni a bombától, meg is lehet szeretni","Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb",null),
( 155,1964,0,"Mary Poppins","Mary Poppins","1986-11-04"),
( 285,1964,0,"Zorba, a görög","Alexis Zorbas","1966-12-15"),
( 398,1964,1,"My Fair Lady","My Fair Lady","1968-08-01"),
( 133,1965,0,"Doktor Zsivágó","Doctor Zhivago",null),
( 193,1965,0,"Ezer bohóc","A Thousand Clowns",null),
( 257,1965,0,null,"Darling",null),
( 260,1965,1,"A muzsika hangja","The Sound of Music",null),
( 317,1965,0,"Bolondok hajója","Ship of Fools","1969-12-04"),
( 52,1966,1,"Egy ember az örökkévalóságnak","A Man For All Seasons","1968-09-26"),
( 61,1966,0,"Nem félünk a farkastól","Who’s Afraid of Virginia Woolf?","1969-01-30"),
( 78,1966,0,"A kavicsos homok","The Sand Pebbles",null),
( 168,1966,0,"Alfie – Szívtelen szívtipró","Alfie",null),
( 316,1966,0,"Jönnek az oroszok! Jönnek az oroszok!","The Russians Are Coming, the Russians Are Coming",null),
( 20,1967,0,"Doctor Dolittle","Doctor Dolittle",null),
( 34,1967,0,"Diploma előtt","The Graduate","1971-07-08"),
( 310,1967,1,"Forró éjszakában","In the Heat of the Night","1971-06-17"),
( 439,1967,0,"Találd ki, ki jön vacsorára!","Guess Who’s Coming to Dinner",null),
( 554,1967,0,"Bonnie és Clyde","Bonnie and Clyde",null),
( 113,1968,0,"Funny Girl","Funny Girl","1971-01-07"),
( 135,1968,0,"Az oroszlán télen","The Lion in Winter","1972-08-24"),
( 154,1968,1,"Oliver!","Oliver!","1971-12-09"),
( 205,1968,0,"Rachel, Rachel","Rachel, Rachel","1970-11-12"),
( 387,1968,0,"Rómeó és Júlia","Romeo and Juliet","1970-11-05"),
( 63,1969,0,"Butch Cassidy és a Sundance kölyök","Butch Cassidy and the Sundance Kid",null),
( 206,1969,0,"Anna ezer napja","Anne of the Thousand Days","1972-11-23"),
( 266,1969,1,"Éjféli cowboy","Midnight Cowboy","1975-03-06"),
( 308,1969,0,"Hello, Dolly!","Hello, Dolly!","1972-06-01"),
( 553,1969,0,"Z, avagy egy politikai gyilkosság anatómiája","Z","1969-11-06"),
( 11,1970,1,"A tábornok","Patton",null),
( 362,1970,0,"MASH","MASH",null),
( 452,1970,0,"Airport '69","Airport",null),
( 463,1970,0,"Love Story","Love Story",null),
( 560,1970,0,"Öt könnyű darab","Five Easy Pieces","1973-08-30"),
( 89,1971,0,"Az utolsó mozielőadás","The Last Picture Show",null),
( 122,1971,1,"Francia kapcsolat","The French Connection","1974-07-11"),
( 186,1971,0,"Cárok végnapjai","Nicholas and Alexandra",null),
( 453,1971,0,"Hegedűs a háztetőn","Fiddler on the Roof",null),
( 490,1971,0,"Mechanikus narancs","A Clockwork Orange",null),
( 146,1972,0,"Kivándorlók","Utvandrarna","1975-08-14"),
( 149,1972,1,"A Keresztapa","The Godfather","1982-03-25"),
( 238,1972,0,"Csibész","Sounder",null),
( 381,1972,0,"Kabaré","Cabaret","1974-02-28"),
( 496,1972,0,"Gyilkos túra","Deliverance",null),
( 35,1973,0,"Amerikai graffiti","American Graffiti",null),
( 106,1973,0,"Az ördögűző","The Exorcist","1989-01-05"),
( 199,1973,1,"A nagy balhé","The Sting","1978-10-19"),
( 388,1973,0,"Egy kis előkelőség","A Touch of Class","1975-04-22"),
( 525,1973,0,"Suttogások és sikolyok","Viskningar och rop",null),
( 54,1974,0,"Lenny","Lenny",null),
( 114,1974,1,"A Keresztapa II.","The Godfather: Part II","1983-04-21"),
( 209,1974,0,"Magánbeszélgetés","The Conversation","1975-07-17"),
( 253,1974,0,"Pokoli torony","The Towering Inferno","1978-09-21"),
( 502,1974,0,"Kínai negyed","Chinatown","1979-09-27"),
( 180,1975,1,"Száll a kakukk fészkére","One Flew Over the Cuckoo’s Nest","1977-05-19"),
( 220,1975,0,"Barry Lyndon","Barry Lyndon",null),
( 335,1975,0,"Nashville","Nashville",null),
( 390,1975,0,"Kánikulai délután","Dog Day Afternoon",null),
( 476,1975,0,"A cápa","Jaws","1985-06-20"),
( 48,1976,0,"Taxisofőr","Taxi Driver","1988-05-08"),
( 49,1976,0,"Hálózat","Network","1980-09-11"),
( 50,1976,0,"Dicsőségre ítélve","Bound for Glory","1980-07-10"),
( 245,1976,0,"Az elnök emberei","All the President’s Men",null),
( 421,1976,1,"Rocky","Rocky","1978-12-28"),
( 39,1977,0,"Hölgyem, Isten áldja!","The Goodbye Girl","1980-12-18"),
( 73,1977,0,"A fordulópont","The Turning Point",null),
( 263,1977,1,"Annie Hall","Annie Hall","1980-05-22"),
( 378,1977,0,"Júlia","Julia","1979-09-20"),
( 410,1977,0,"Csillagok háborúja","Star Wars","1979-08-16"),
( 85,1978,0,"Éjféli expressz","Midnight Express",null),
( 188,1978,0,"Hazatérés","Coming Home","1980-05-15"),
( 222,1978,1,"A szarvasvadász","The Deer Hunter","1990-03-01"),
( 243,1978,0,"Asszony férj nélkül","An Unmarried Woman","1980-02-07"),
( 289,1978,0,"Ép testben épp hogy élek","Heaven Can Wait",null),
( 84,1979,0,"Mindhalálig zene","All That Jazz","1981-06-04"),
( 162,1979,0,"Apokalipszis most","Apocalypse Now","1980-04-24"),
( 434,1979,0,"Norma Rae","Norma Rae","1980-10-16"),
( 479,1979,1,"Kramer kontra Kramer","Kramer vs. Kramer","1981-03-12"),
( 518,1979,0,"Az utolsó gyönyörű nyár","Breaking Away","1981-01-29"),
( 203,1980,0,"Egy tiszta nő","Tess","1984-08-23"),
( 291,1980,0,"A szénbányász lánya","Coal Miner’s Daughter","1983-05-26"),
( 296,1980,0,"Dühöngő bika","Raging Bull","1984-02-09"),
( 337,1980,1,"Átlagemberek","Ordinary People","1985-06-13"),
( 429,1980,0,"Az elefántember","The Elephant Man","1985-12-19"),
( 16,1981,0,"Az elveszett frigyláda fosztogatói","Raiders of the Lost Ark","1985-10-24"),
( 167,1981,0,"Az aranytó","On Golden Pond",null),
( 472,1981,1,"Tűzszekerek","Chariots of Fire","1982-06-10"),
( 510,1981,0,"Atlantic City","Atlantic City","1983-06-16"),
( 530,1981,0,"Vörösök","Reds",null),
( 26,1982,0,"Az ítélet","The Verdict",null),
( 74,1982,0,"Eltűntnek nyilvánítva","Missing","1983-09-22"),
( 158,1982,1,"Gandhi","Gandhi","1984-09-27"),
( 346,1982,0,"Aranyoskám","Tootsie","1985-02-21"),
( 423,1982,0,"E. T., a földönkívüli","E.T. the Extra-Terrestrial","1983-12-22"),
( 59,1983,0,"A nagy borzongás","The Big Chill",null),
( 385,1983,0,"Az igazak","The Right Stuff",null),
( 412,1983,0,"Az öltöztető","The Dresser","1985-11-07"),
( 488,1983,0,"Az Úr kegyelmébe","Tender Mercies",null),
( 505,1983,1,"Becéző szavak","Terms of Endearment","1987-04-02"),
( 60,1984,0,"Hely a szívemben","Places in the Heart",null),
( 139,1984,1,"Amadeus","Amadeus","1990-03-22"),
( 225,1984,0,"Út Indiába","A Passage to India",null),
( 325,1984,0,"Gyilkos mezők","The Killing Fields",null),
( 380,1984,0,"Katonatörténet","A Soldier’s Story",null),
( 36,1985,0,"Bíborszín","The Color Purple","1988-02-03"),
( 53,1985,0,"A pókasszony csókja","Kiss of the Spider Woman","1987-11-19"),
( 171,1985,0,"A kis szemtanú","Witness","1988-10-20"),
( 333,1985,1,"Távol Afrikától","Out of Africa","1987-05-14"),
( 422,1985,0,"A Prizzik becsülete","Prizzi’s Honor","1994-10-13"),
( 18,1986,0,"A misszió","The Mission","1987-12-24"),
( 241,1986,0,"Egy kisebb isten gyermekei","Children of a Lesser God","1989-09-28"),
( 352,1986,0,"Szoba kilátással","A Room with a View","1993-05-21"),
( 386,1986,1,"A szakasz","Platoon","1988-09-01"),
( 544,1986,0,"Hannah és nővérei","Hannah and Her Sisters","1988-08-18"),
( 219,1987,0,"Holdkórosok","Moonstruck",null),
( 246,1987,0,"Remény és dicsőség","Hope and Glory",null),
( 270,1987,0,"Végzetes vonzerő","Fatal Attraction",null),
( 276,1987,0,"A híradó sztárjai","Broadcast News","1989-09-28"),
( 521,1987,1,"Az utolsó császár","The Last Emperor",null),
( 79,1988,1,"Esőember","Rain Man","1989-03-23"),
( 110,1988,0,"Dolgozó lány","Working Girl","1990-03-08"),
( 123,1988,0,"Veszedelmes viszonyok","Dangerous Liaisons",null),
( 201,1988,0,"Az alkalmi turista","The Accidental Tourist",null),
( 558,1988,0,"Lángoló Mississippi","Mississippi Burning","1990-08-09"),
( 7,1989,0,"Baseball álmok","Field of Dreams",null),
( 90,1989,1,"Miss Daisy sofőrje","Driving Miss Daisy","1990-12-13"),
( 355,1989,0,"Született július 4-én","Born on the Fourth of July","1990-04-19"),
( 432,1989,0,"A bal lábam","My Left Foot","1991-02-07"),
( 563,1989,0,"Holt költők társasága","Dead Poets Society","1990-03-15"),
( 38,1990,0,"Ébredések","Awakenings","1991-04-26"),
( 96,1990,0,"Ghost","Ghost","1990-12-06"),
( 128,1990,0,"Nagymenők","Goodfellas","1991-02-14"),
( 349,1990,0,"A Keresztapa III.","The Godfather Part III","1991-05-03"),
( 403,1990,1,"Farkasokkal táncoló","Dances with Wolves","1991-04-26"),
( 66,1991,0,"Szépség és a szörnyeteg","Beauty and the Beast","1992-12-04"),
( 334,1991,0,"JFK – A nyitott dosszié","JFK","1992-05-15"),
( 456,1991,0,"Bugsy","Bugsy","1992-09-11"),
( 466,1991,0,"Hullámok hercege","The Prince of Tides","1992-03-06"),
( 485,1991,1,"A bárányok hallgatnak","The Silence of the Lambs","1992-03-27"),
( 228,1992,0,"Síró játék","The Crying Game","1993-09-10"),
( 293,1992,0,"Egy asszony illata","Scent of a Woman","1993-03-26"),
( 324,1992,0,"Egy becsületbeli ügy","A Few Good Men","1993-02-12"),
( 484,1992,0,"Szellem a házban","Howards End","1993-04-02"),
( 537,1992,1,"Nincs bocsánat","Unforgiven","1993-02-19"),
( 58,1993,0,"Napok romjai","The Remains of the Day","1994-04-14"),
( 98,1993,0,"A szökevény","The Fugitive","1994-01-27"),
( 413,1993,1,"Schindler listája","Schindler’s List","1994-03-10"),
( 474,1993,0,"Zongoralecke","The Piano","1994-06-02"),
( 504,1993,0,"Apám nevében","In the Name of the Father","1994-04-07"),
( 157,1994,0,"Ponyvaregény","Pulp Fiction","1995-04-13"),
( 405,1994,0,"Kvíz show","Quiz Show","1995-03-02"),
( 514,1994,0,"A remény rabjai","The Shawshank Redemption","1995-05-25"),
( 546,1994,0,"Négy esküvő és egy temetés","Four Weddings and a Funeral","1995-02-16"),
( 562,1994,1,"Forrest Gump","Forrest Gump","1994-12-08"),
( 9,1995,0,"Neruda postása","The Postman/Il Postino","1995-10-19"),
( 13,1995,0,"Értelem és érzelem","Sense and Sensibility","1996-04-11"),
( 37,1995,0,"Babe","Babe","1995-12-21"),
( 248,1995,1,"A rettenthetetlen","Braveheart","1995-10-26"),
( 444,1995,0,"Apolló 13","Apollo 13","1995-11-02"),
( 104,1996,0,"Jerry Maguire – A nagy hátraarc","Jerry Maguire","1997-05-22"),
( 111,1996,0,"Fargo","Fargo","1997-02-27"),
( 175,1996,1,"Az angol beteg","The English Patient","1997-05-01"),
( 194,1996,0,"Titkok és hazugságok","Secrets & Lies","1996-12-12"),
( 465,1996,0,"Ragyogj!","Shine","1997-10-02"),
( 87,1997,0,"Good Will Hunting","Good Will Hunting","1999-02-25"),
( 214,1997,1,"Titanic","Titanic","1998-01-22"),
( 459,1997,0,"Szigorúan bizalmas","L.A. Confidential","1998-01-29"),
( 532,1997,0,"Lesz ez még így se","As Good as It Gets","1998-03-12"),
( 547,1997,0,"Alul semmi","The Full Monty","1998-01-01"),
( 94,1998,0,"Ryan közlegény megmentése","Saving Private Ryan","1998-09-17"),
( 115,1998,1,"Szerelmes Shakespeare","Shakespeare in Love","1999-03-04"),
( 279,1998,0,"Elizabeth","Elizabeth","1999-05-06"),
( 371,1998,0,"Az őrület határán","The Thin Red Line","1999-03-18"),
( 509,1998,0,"Az élet szép","Life Is Beautiful","1999-04-08"),
( 141,1999,1,"Amerikai szépség","American Beauty","2000-02-17"),
( 239,1999,0,"Halálsoron","The Green Mile","2000-04-27"),
( 370,1999,0,"A bennfentes","The Insider","2000-03-09"),
( 508,1999,0,"Hatodik érzék","The Sixth Sense","2000-01-06"),
( 538,1999,0,"Árvák hercege","The Cider House Rules","2000-02-24"),
( 14,2000,1,"Gladiátor","Gladiator","2000-05-18"),
( 57,2000,0,"Traffic","Traffic","2002-05-30"),
( 107,2000,0,"Csokoládé","Chocolat","2001-03-15"),
( 197,2000,0,"Tigris és sárkány","Crouching Tiger, Hidden Dragon","2001-02-08"),
( 375,2000,0,"Erin Brockovich – Zűrös természet","Erin Brockovich","2000-04-20"),
( 178,2001,0,"A Gyűrűk Ura: A Gyűrű szövetsége","The Lord of the Rings: The Fellowship of the Ring","2002-01-10"),
( 184,2001,1,"Egy csodálatos elme","A Beautiful Mind","2002-02-28"),
( 395,2001,0,"Gosford Park","Gosford Park","2002-08-29"),
( 522,2001,0,"A hálószobában","In the Bedroom","2002-05-09"),
( 526,2001,0,"Moulin Rouge!","Moulin Rouge!","2001-10-18"),
( 51,2002,1,"Chicago","Chicago","2003-03-13"),
( 56,2002,0,"A Gyűrűk Ura: A két torony","The Lord of the Rings: The Two Towers","2003-01-09"),
( 124,2002,0,"New York bandái","Gangs of New York","2003-05-08"),
( 341,2002,0,"A zongorista","The Pianist","2003-03-20"),
( 507,2002,0,"Az órák","The Hours","2003-03-06"),
( 305,2003,0,"Vágta","Seabiscuit","2004-01-15"),
( 319,2003,1,"A Gyűrűk Ura: A király visszatér","The Lord of the Rings: The Return of the King","2004-01-08"),
( 322,2003,0,"Elveszett jelentés","Lost in Translation","2004-03-11"),
( 478,2003,0,"Titokzatos folyó","Mystic River","2003-11-27"),
( 520,2003,0,"Kapitány és katona: A világ túlsó oldalán","Master and Commander: The Far Side of the World","2003-12-04"),
( 75,2004,0,"Kerülőutak","Sideways","2005-02-03"),
( 185,2004,0,"Ray","Ray","2005-02-03"),
( 187,2004,0,"Aviátor","The Aviator","2005-02-24"),
( 286,2004,1,"Millió dolláros bébi","Million Dollar Baby","2005-03-10"),
( 531,2004,0,"Én, Pán Péter","Finding Neverland","2005-02-24"),
( 68,2005,0,"Jó estét, jó szerencsét!","Good Night, and Good Luck","2006-02-09"),
( 93,2005,0,"Capote","Capote","2006-04-06"),
( 145,2005,1,"Ütközések","Crash","2005-11-10"),
( 230,2005,0,"München","Munich","2006-01-26"),
( 438,2005,0,"Brokeback Mountain – Túl a barátságon","Brokeback Mountain","2006-03-30"),
( 126,2006,1,"A tégla","The Departed","2006-11-09"),
( 169,2006,0,"Bábel","Babel","2007-02-08"),
( 227,2006,0,"A királynő","The Queen","2007-01-18"),
( 397,2006,0,"Levelek Ivo Dzsimáról","Letters from Iwo Jima","2007-03-01"),
( 440,2006,0,"A család kicsi kincse","Little Miss Sunshine","2007-02-22"),
( 152,2007,0,"Michael Clayton","Michael Clayton","2008-02-21"),
( 237,2007,0,"Vágy és vezeklés","Atonement","2008-01-24"),
( 240,2007,1,"Nem vénnek való vidék","No Country for Old Men","2008-03-06"),
( 311,2007,0,"Vérző olaj","There Will Be Blood","2008-02-28"),
( 418,2007,0,"Juno","Juno","2008-03-13"),
( 83,2008,0,"Benjamin Button különös élete","The Curious Case of Benjamin Button","2009-02-05"),
( 212,2008,0,"A felolvasó","The Reader","2009-04-23"),
( 235,2008,0,"Milk","Milk","2009-02-26"),
( 404,2008,0,"Frost/Nixon","Frost/Nixon","2009-01-29"),
( 550,2008,1,"Gettómilliomos","Slumdog Millionaire","2009-02-19"),
( 77,2009,0,"Egy lányról","An Education","2010-04-08"),
( 97,2009,0,"A szív bajnokai","The Blind Side","2009-11-20"),
( 166,2009,0,"Fel","Up","2009-10-15"),
( 213,2009,0,"District 9","District 9","2009-09-24"),
( 249,2009,0,"Egy komoly ember","A Serious Man","2010-11-04"),
( 251,2009,1,"A bombák földjén","The Hurt Locker","2010-02-18"),
( 259,2009,0,"Becstelen brigantyk","Inglourious Basterds","2009-08-20"),
( 313,2009,0,"Egek ura","Up in the Air","2010-02-18"),
( 340,2009,0,"Avatar","Avatar","2009-12-17"),
( 383,2009,0,"Precious – A boldogság ára","Precious: Based on the Novel ’Push’ by Sapphire","2011-02-24"),
( 71,2010,0,"A félszemű","True Grit","2011-02-17"),
( 80,2010,0,"Eredet","Inception","2010-07-22"),
( 109,2010,0,"Fekete hattyú","Black Swan","2011-02-17"),
( 174,2010,0,"127 óra","127 Hours","2011-03-03"),
( 264,2010,1,"A király beszéde","The King’s Speech","2011-02-03"),
( 278,2010,0,"Winter's Bone – A hallgatás törvénye","Winter’s Bone","2011-05-19"),
( 420,2010,0,"Toy Story 3.","Toy Story 3.","2010-06-17"),
( 448,2010,0,"The Fighter – A harcos","The Fighter","2011-02-24"),
( 501,2010,0,"A gyerekek jól vannak","The Kids Are All Right","2011-04-14"),
( 517,2010,0,"Social Network – A közösségi háló","The Social Network","2010-11-11"),
( 117,2011,0,"A segítség","The Help","2011-11-03"),
( 204,2011,0,"Utódok","The Descendants","2012-02-16"),
( 231,2011,0,"Rém hangosan és irtó közel","Extremely Loud & Incredibly Close","2012-03-08"),
( 297,2011,1,"The Artist – A némafilmes","The Artist","2012-02-23"),
( 299,2011,0,"A leleményes Hugo","Hugo","2012-03-01"),
( 303,2011,0,"Éjfélkor Párizsban","Midnight in Paris","2011-11-10"),
( 451,2011,0,"Pénzcsináló","Moneyball","2011-12-08"),
( 516,2011,0,"Az élet fája","The Tree of Life","2011-12-15"),
( 559,2011,0,"Hadak útján","War Horse","2012-02-09"),
( 65,2012,0,"A messzi dél vadjai","Beasts of the Southern Wild","2013-01-10"),
( 137,2012,0,"Zero Dark Thirty – A Bin Láden hajsza","Zero Dark Thirty","2013-02-21"),
( 195,2012,0,"A nyomorultak","Les Misérables","2012-12-27"),
( 283,2012,0,"Lincoln","Lincoln","2013-01-31"),
( 301,2012,1,"Az Argo-akció","Argo","2012-11-22"),
( 315,2012,0,"Pi élete","Life of Pi","2012-12-20"),
( 326,2012,0,"Napos oldal","Silver Linings Playbook","2013-01-10"),
( 417,2012,0,"Szerelem","Amour","2012-11-01"),
( 464,2012,0,"Django elszabadul","Django Unchained","2013-01-17"),
( 27,2013,0,"Mielőtt meghaltam","Dallas Buyers Club","2014-03-05"),
( 161,2013,0,"Amerikai botrány","American Hustle","2014-01-23"),
( 211,2013,0,"Philips kapitány","Captain Phillips","2013-11-07"),
( 242,2013,0,"Philomena – Határtalan szeretet","Philomena","2013-12-26"),
( 304,2013,0,"Gravitáció","Gravity","2013-10-03"),
( 368,2013,0,"A nő","Her","2014-02-06"),
( 389,2013,0,"Nebraska","Nebraska","2014-01-24"),
( 407,2013,0,"A Wall Street farkasa","The Wolf of Wall Street","2013-12-26"),
( 441,2013,1,"12 év rabszolgaság","12 Years a Slave","2014-01-02"),
( 45,2014,0,"A Grand Budapest Hotel","The Grand Budapest Hotel","2014-03-20"),
( 191,2014,1,"Birdman avagy (A mellőzés meglepő ereje)","Birdman or (The Unexpected Virtue of Ignorance)","2015-01-15"),
( 218,2014,0,"Sráckor","Boyhood","2014-09-18"),
( 300,2014,0,"Selma","Selma","2015-01-09"),
( 354,2014,0,"Whiplash","Whiplash","2015-02-05"),
( 357,2014,0,"A mindenség elmélete","The Theory of Everything","2015-01-22"),
( 402,2014,0,"Amerikai mesterlövész","American Sniper","2015-02-19"),
( 528,2014,0,"Kódjátszma","The Imitation Game","2015-01-29"),
( 5,2015,0,"Kémek hídja","Bridge of Spies","2015-11-26"),
( 28,2015,0,"Mentőexpedíció","The Martian","2015-10-01"),
( 148,2015,0,"A szoba","Room","2016-01-28"),
( 255,2015,0,"Brooklyn","Brooklyn","2016-02-04"),
( 294,2015,0,"A nagy dobás","The Big Short","2016-02-04"),
( 487,2015,0,"A visszatérő","The Revenant","2016-01-14"),
( 503,2015,0,"Mad Max – A harag útja","Mad Max: Fury Road","2015-05-21"),
( 513,2015,1,"Spotlight – Egy nyomozás részletei","Spotlight","2016-02-18"),
( 81,2016,1,"Holdfény","Moonlight","2017-02-16"),
( 198,2016,0,"Kaliforniai álom","La La Land","2016-12-29"),
( 282,2016,0,"A fegyvertelen katona","Hacksaw Ridge","2016-12-29"),
( 288,2016,0,"Kerítések","Fences","2016-12-25"),
( 309,2016,0,"A préri urai","Hell or High Water",null),
( 323,2016,0,"A régi város","Manchester by the Sea","2017-02-23"),
( 350,2016,0,"A számolás joga","Hidden Figures","2017-01-19"),
( 406,2016,0,"Oroszlán","Lion","2017-02-16"),
( 462,2016,0,"Érkezés","Arrival","2016-11-10"),
( 2,2017,0,"A Pentagon titkai","The Post","2018-02-22"),
( 62,2017,1,"A víz érintése","The Shape of Water","2018-02-22"),
( 99,2017,0,"A legsötétebb óra","Darkest Hour","2018-01-18"),
( 233,2017,0,"Tűnj el!","Get Out","2017-04-20"),
( 284,2017,0,"Lady Bird","Lady Bird","2018-03-01"),
( 292,2017,0,"Három óriásplakát Ebbing határában","Three Billboards Outside Ebbing, Missouri","2018-01-25"),
( 511,2017,0,"Dunkirk","Dunkirk","2017-07-20"),
( 519,2017,0,"Fantomszál","Phantom Thread","2018-02-01"),
( 540,2017,0,"Szólíts a neveden","Call Me by Your Name","2018-02-08"),
( 33,2018,0,"Alelnök","Vice","2019-02-21"),
( 112,2018,0,"Fekete Párduc","Black Panther","2018-02-15"),
( 120,2018,0,"Bohém rapszódia","Bohemian Rhapsody","2018-11-01"),
( 151,2018,1,"Zöld könyv – Útmutató az élethez","Green Book","2019-02-21"),
( 290,2018,0,"Roma","Roma",null),
( 394,2018,0,"Csillag születik","A Star Is Born","2018-10-04"),
( 483,2018,0,"Csuklyások – BlacKkKlansman","BlacKkKlansman","2018-09-27"),
( 534,2018,0,"A kedvenc","The Favourite","2019-02-07"),
( 64,2019,0,"Az ír","The Irishman","2019-11-21"),
( 196,2019,0,"1917","1917","2020-01-23"),
( 200,2019,1,"Élősködők","Gisaengchung","2019-12-05"),
( 437,2019,0,"Kisasszonyok","Little Women","2020-01-30"),
( 447,2019,0,"Jojo Nyuszi","Jojo Rabbit","2020-01-23"),
( 475,2019,0,"Joker","Joker","2019-10-03"),
( 486,2019,0,"Volt egyszer egy Hollywood","Once Upon a Time in Hollywood","2019-08-15"),
( 497,2019,0,"Az aszfalt királyai","Ford v Ferrari","2019-11-14"),
( 561,2019,0,"Házassági történet","Marriage Story","2019-12-06");

create table kapcsolat(filmid int(11)  ,keszitoid int(11)  ) ;
 
ALTER TABLE kapcsolat ADD PRIMARY KEY(filmid,keszitoid);

 INSERT INTO kapcsolat VALUES
( 500,279),
( 270,326),
( 18,176),
( 141,294),
( 526,228),
( 234,457),
( 20,557),
( 115,475),
( 222,167),
( 271,129),
( 97,211),
( 234,351),
( 191,529),
( 374,376),
( 406,173),
( 97,504),
( 25,250),
( 288,216),
( 114,41),
( 137,285),
( 148,347),
( 526,303),
( 161,97),
( 73,96),
( 393,417),
( 281,188),
( 296,209),
( 48,497),
( 441,8),
( 40,279),
( 156,27),
( 303,118),
( 313,342),
( 321,279),
( 169,68),
( 66,434),
( 456,479),
( 492,127),
( 459,517),
( 462,526),
( 332,370),
( 77,304),
( 447,138),
( 242,345),
( 9,274),
( 83,422),
( 354,180),
( 115,410),
( 255,123),
( 28,170),
( 559,335),
( 203,349),
( 435,370),
( 455,397),
( 16,422),
( 511,379),
( 286,116),
( 418,395),
( 291,441),
( 368,381),
( 45,63),
( 347,127),
( 556,370),
( 219,6),
( 5,384),
( 224,287),
( 2,174),
( 196,431),
( 451,547),
( 322,555),
( 248,122),
( 365,279),
( 86,496),
( 104,83),
( 498,413),
( 174,356),
( 441,102),
( 245,343),
( 232,354),
( 540,186),
( 300,121),
( 270,49),
( 161,452),
( 185,275),
( 549,350),
( 483,416),
( 264,482),
( 199,242),
( 509,251),
( 145,107),
( 205,40),
( 256,222),
( 448,292),
( 257,7),
( 512,276),
( 99,561),
( 57,265),
( 456,463),
( 305,422),
( 233,416),
( 201,447),
( 219,314),
( 429,50),
( 513,51),
( 157,548),
( 159,279),
( 198,23),
( 477,370),
( 326,452),
( 211,63),
( 557,276),
( 299,521),
( 405,536),
( 338,370),
( 230,247),
( 315,515),
( 233,532),
( 95,370),
( 463,270),
( 336,54),
( 371,25),
( 195,213),
( 189,262),
( 428,279),
( 10,350),
( 497,90),
( 199,497),
( 423,66),
( 439,127),
( 534,71),
( 301,418),
( 152,103),
( 33,8),
( 509,46),
( 261,54),
( 249,430),
( 354,473),
( 11,351),
( 382,11),
( 325,176),
( 285,115),
( 563,165),
( 117,398),
( 324,307),
( 32,489),
( 196,426),
( 27,456),
( 62,161),
( 341,22),
( 197,435),
( 200,166),
( 515,276),
( 227,77),
( 283,66),
( 19,256),
( 233,473),
( 531,319),
( 279,243),
( 394,311),
( 502,514),
( 430,404),
( 107,495),
( 312,279),
( 447,368),
( 115,265),
( 277,370),
( 144,250),
( 560,424),
( 464,291),
( 237,213),
( 501,483),
( 99,455),
( 375,48),
( 286,474),
( 524,250),
( 280,264),
( 107,278),
( 552,553),
( 49,340),
( 543,397),
( 210,370),
( 340,411),
( 466,194),
( 356,417),
( 315,268),
( 15,370),
( 217,27),
( 475,277),
( 58,516),
( 63,396),
( 93,378),
( 71,430),
( 90,36),
( 529,127),
( 213,334),
( 300,356),
( 474,169),
( 92,279),
( 486,263),
( 534,111),
( 311,362),
( 475,459),
( 194,124),
( 487,68),
( 73,266),
( 434,191),
( 115,511),
( 243,224),
( 152,229),
( 282,82),
( 82,76),
( 237,143),
( 68,418),
( 440,94),
( 36,422),
( 319,334),
( 528,492),
( 71,63),
( 80,379),
( 542,120),
( 350,298),
( 402,485),
( 417,89),
( 222,533),
( 404,101),
( 540,31),
( 541,139),
( 350,214),
( 80,168),
( 533,250),
( 69,394),
( 508,422),
( 79,479),
( 487,225),
( 17,500),
( 1,409),
( 294,324),
( 395,130),
( 288,301),
( 316,314),
( 195,243),
( 301,20),
( 274,370),
( 440,530),
( 292,108),
( 433,254),
( 369,93),
( 61,480),
( 251,552),
( 136,417),
( 445,370),
( 13,313),
( 74,112),
( 508,66),
( 530,543),
( 370,151),
( 358,315),
( 65,109),
( 314,279),
( 517,63),
( 99,243),
( 437,174),
( 238,164),
( 125,525),
( 423,335),
( 381,52),
( 28,30),
( 434,360),
( 507,466),
( 307,279),
( 441,388),
( 216,279),
( 253,545),
( 535,60),
( 292,508),
( 425,399),
( 45,45),
( 354,367),
( 196,539),
( 394,412),
( 405,423),
( 218,189),
( 241,257),
( 111,430),
( 422,396),
( 30,296),
( 460,146),
( 122,187),
( 294,8),
( 204,235),
( 133,79),
( 475,412),
( 64,428),
( 151,26),
( 89,185),
( 77,123),
( 35,383),
( 140,252),
( 64,459),
( 278,465),
( 24,500),
( 85,176),
( 454,370),
( 527,279),
( 128,209),
( 211,142),
( 71,113),
( 94,335),
( 562,446),
( 547,88),
( 233,192),
( 352,190),
( 426,397),
( 153,279),
( 397,335),
( 372,139),
( 495,218),
( 132,279),
( 47,279),
( 404,213),
( 343,201),
( 260,525),
( 166,3),
( 188,239),
( 42,322),
( 353,289),
( 96,371),
( 292,156),
( 413,335),
( 480,54),
( 483,473),
( 391,54),
( 504,18),
( 505,453),
( 561,369),
( 54,9),
( 212,155),
( 523,417),
( 366,370),
( 151,544),
( 70,276),
( 279,213),
( 72,222),
( 190,276),
( 344,279),
( 28,364),
( 287,397),
( 493,279),
( 2,335),
( 35,85),
( 33,84),
( 443,415),
( 516,363),
( 417,320),
( 324,231),
( 198,375),
( 109,338),
( 517,34),
( 7,419),
( 178,432),
( 202,420),
( 346,103),
( 520,73),
( 340,305),
( 21,198),
( 458,54),
( 471,19),
( 462,53),
( 357,243),
( 38,436),
( 494,279),
( 436,10),
( 173,279),
( 519,518),
( 383,42),
( 424,370),
( 520,357),
( 175,141),
( 130,279),
( 401,366),
( 364,24),
( 519,195),
( 65,282),
( 334,58),
( 322,205),
( 546,28),
( 251,285),
( 357,534),
( 237,243),
( 3,54),
( 442,100),
( 313,179),
( 97,421),
( 544,488),
( 350,98),
( 293,74),
( 448,105),
( 330,91),
( 52,478),
( 390,512),
( 520,72),
( 275,417),
( 371,538),
( 231,63),
( 489,100),
( 487,333),
( 560,510),
( 373,206),
( 376,279),
( 266,239),
( 56,558),
( 67,54),
( 311,518),
( 259,548),
( 457,91),
( 251,236),
( 350,152),
( 532,453),
( 438,506),
( 200,280),
( 484,190),
( 537,527),
( 240,63),
( 14,507),
( 385,209),
( 22,276),
( 359,250),
( 75,37),
( 110,193),
( 519,249),
( 526,352),
( 230,335),
( 83,34),
( 370,401),
( 134,279),
( 303,348),
( 407,337),
( 345,250),
( 327,222),
( 58,190),
( 212,103),
( 298,100),
( 163,279),
( 91,76),
( 230,66),
( 289,543),
( 109,391),
( 450,417),
( 384,417),
( 184,406),
( 335,130),
( 228,114),
( 28,283),
( 561,78),
( 197,268),
( 525,365),
( 459,408),
( 311,249),
( 514,210),
( 227,345),
( 367,397),
( 418,487),
( 402,527),
( 446,279),
( 64,56),
( 123,414),
( 343,160),
( 104,546),
( 406,238),
( 399,27),
( 220,309),
( 368,171),
( 528,258),
( 516,323),
( 4,160),
( 251,312),
( 394,437),
( 553,464),
( 491,127),
( 212,152),
( 407,70),
( 487,517),
( 169,402),
( 29,420),
( 294,102),
( 115,152),
( 38,535),
( 139,141),
( 383,199),
( 324,2),
( 331,279),
( 507,63),
( 191,302),
( 162,383),
( 554,543),
( 14,193),
( 164,370),
( 180,154),
( 363,359),
( 169,13),
( 114,361),
( 272,279),
( 158,106),
( 476,245),
( 262,207),
( 161,204),
( 209,383),
( 151,330),
( 124,126),
( 413,498),
( 485,35),
( 411,54),
( 90,245),
( 211,547),
( 309,253),
( 333,103),
( 478,240),
( 497,298),
( 478,527),
( 112,75),
( 532,273),
( 182,279),
( 150,443),
( 419,279),
( 254,279),
( 204,158),
( 186,196),
( 255,304),
( 227,233),
( 155,439),
( 346,147),
( 451,102),
( 178,334),
( 499,262),
( 534,347),
( 191,433),
( 482,198),
( 558,86),
( 33,324),
( 215,417),
( 553,389),
( 196,110),
( 380,29),
( 360,119),
( 26,245),
( 513,460),
( 108,27),
( 453,314),
( 170,259),
( 452,377),
( 368,195),
( 388,62),
( 36,335),
( 222,65),
( 218,145),
( 165,259),
( 146,461),
( 349,383),
( 562,133),
( 326,152),
( 236,91),
( 469,417),
( 46,54),
( 486,369),
( 464,353),
( 361,417),
( 506,250),
( 143,91),
( 438,248),
( 417,310),
( 33,87),
( 444,406),
( 155,59),
( 302,39),
( 397,527),
( 258,370),
( 244,160),
( 120,521),
( 357,213),
( 341,125),
( 267,279),
( 456,543),
( 5,335),
( 6,490),
( 278,260),
( 174,286),
( 58,162),
( 406,95),
( 555,451),
( 517,547),
( 516,324),
( 362,269),
( 341,339),
( 113,43),
( 85,38),
( 441,325),
( 315,421),
( 387,255),
( 123,448),
( 407,459),
( 284,63),
( 319,558),
( 473,279),
( 174,540),
( 563,468),
( 187,151),
( 222,372),
( 241,6),
( 48,242),
( 385,523),
( 521,429),
( 309,153),
( 98,373),
( 55,382),
( 137,312),
( 478,485),
( 297,560),
( 147,140),
( 417,549),
( 59,48),
( 36,440),
( 223,64),
( 448,550),
( 135,403),
( 198,502),
( 540,300),
( 280,134),
( 522,318),
( 265,196),
( 397,485),
( 468,81),
( 486,223),
( 339,397),
( 403,519),
( 318,500),
( 57,390),
( 201,470),
( 106,505),
( 62,386),
( 246,374),
( 39,43),
( 416,397),
( 23,370),
( 323,135),
( 183,376),
( 213,486),
( 248,450),
( 382,134),
( 516,385),
( 476,2),
( 462,503),
( 481,100),
( 357,561),
( 56,432),
( 497,16),
( 387,1),
( 247,397),
( 409,177),
( 264,95),
( 528,405),
( 288,63),
( 181,250),
( 400,299),
( 242,226),
( 41,553),
( 386,373),
( 151,321),
( 109,267),
( 65,172),
( 107,2),
( 466,476),
( 485,246),
( 540,520),
( 145,232),
( 131,148),
( 225,493),
( 180,141),
( 511,168),
( 276,453),
( 37,57),
( 116,234),
( 99,213),
( 355,281),
( 421,523),
( 413,175),
( 195,220),
( 240,113),
( 53,99),
( 78,525),
( 9,346),
( 162,41),
( 545,472),
( 418,551),
( 342,478),
( 313,293),
( 94,387),
( 451,444),
( 551,397),
( 249,113),
( 284,137),
( 534,244),
( 34,513),
( 440,67),
( 207,279),
( 558,327),
( 496,374),
( 300,8),
( 286,527),
( 410,85),
( 283,335),
( 7,181),
( 326,294),
( 226,54),
( 160,397),
( 518,4),
( 441,324),
( 304,117),
( 483,221),
( 513,328),
( 93,227),
( 168,542),
( 538,425),
( 43,279),
( 102,417),
( 154,134),
( 412,4),
( 290,501),
( 2,384),
( 248,407),
( 176,397),
( 214,305),
( 187,521),
( 389,80),
( 383,144),
( 290,117),
( 152,295),
( 405,32),
( 323,308),
( 263,55),
( 229,91),
( 390,44),
( 323,163),
( 402,412),
( 104,537),
( 161,195),
( 389,469),
( 94,316),
( 319,432),
( 501,136),
( 503,317),
( 51,329),
( 193,203),
( 99,534),
( 355,58),
( 273,100),
( 162,361),
( 447,178),
( 178,558),
( 206,146),
( 201,380),
( 129,397),
( 431,315),
( 212,15),
( 137,195),
( 449,370),
( 479,49),
( 522,509),
( 310,69),
( 235,458),
( 74,217),
( 508,559),
( 414,279),
( 192,322),
( 420,241),
( 299,337),
( 264,173),
( 185,197),
( 239,306),
( 45,288),
( 26,2),
( 243,261),
( 284,271),
( 44,250),
( 81,344),
( 93,149),
( 522,205),
( 81,324),
( 467,12),
( 117,477),
( 513,68),
( 300,324),
( 204,321),
( 519,362),
( 328,54),
( 225,1),
( 36,66),
( 395,21),
( 532,150),
( 221,279),
( 149,116),
( 402,284),
( 172,54),
( 94,554),
( 308,480),
( 510,524),
( 472,176),
( 12,146),
( 398,413),
( 305,230),
( 301,200),
( 348,279),
( 407,61),
( 483,562),
( 378,484),
( 60,467),
( 296,523),
( 280,11),
( 184,101),
( 380,314),
( 464,336),
( 351,212),
( 100,309),
( 461,370),
( 69,491),
( 64,337),
( 279,531),
( 470,91),
( 118,279),
( 239,184),
( 269,397),
( 323,393),
( 83,66),
( 185,471),
( 101,276),
( 104,453),
( 252,297),
( 282,442),
( 37,454),
( 268,522),
( 517,142),
( 485,331),
( 31,259),
( 295,196),
( 415,128),
( 18,481),
( 208,17),
( 350,90),
( 138,279),
( 408,250),
( 462,202),
( 396,196),
( 379,276),
( 119,472),
( 9,182),
( 250,54),
( 548,14),
( 337,427),
( 240,430),
( 197,208),
( 421,209),
( 329,370),
( 5,23),
( 392,397),
( 483,192),
( 427,250),
( 8,397),
( 317,127),
( 235,294),
( 375,499),
( 50,541),
( 402,215),
( 177,462),
( 195,272),
( 242,47),
( 488,104),
( 305,66),
( 380,427),
( 550,356),
( 87,548),
( 323,332),
( 214,411),
( 121,279),
( 37,317),
( 57,556),
( 487,302),
( 199,449),
( 432,131),
( 539,24),
( 124,410),
( 536,409),
( 141,458),
( 459,157),
( 531,425),
( 562,219),
( 45,132),
( 56,334),
( 501,33),
( 81,8),
( 465,392),
( 103,417),
( 559,66),
( 395,400),
( 404,406),
( 84,5),
( 563,445),
( 375,336),
( 171,494),
( 105,397),
( 405,358),
( 503,454),
( 179,409),
( 167,290),
( 203,159),
( 117,528),
( 162,237),
( 151,183),
( 76,438),
( 27,92),
( 334,281),
( 126,521),
( 490,309),
( 142,279),
( 14,498),
( 88,81),
( 377,259),
( 127,160),
( 114,383),
( 403,355),
( 306,188),
( 320,341),
( 304,369),
( 371,385);

create table keszito(id int(11)  ,nev varchar(100)  ,producer boolean  ) ;
 
ALTER TABLE keszito ADD PRIMARY KEY(id);

 INSERT INTO keszito VALUES
( 1,"John Brabourne",1),
( 2,"David Brown",1),
( 3,"Jonas Rivera",1),
( 4,"Peter Yates",1),
( 5,"Robert Alan Aurthur",1),
( 6,"Patrick J. Palmer",1),
( 7,"Joseph Janni",1),
( 8,"Jeremy Kleiner",1),
( 9,"Marvin Worth",1),
( 10,"Frank Ross",1),
( 11,"James Woolf",1),
( 12,"Arthur Hornblow Jr.",1),
( 13,"Jon Kilik",1),
( 14,"Argosy-Wanger",0),
( 15,"Anthony Minghella",1),
( 16,"James Mangold",1),
( 17,"Ralph Nelson",1),
( 18,"Jim Sheridan",1),
( 19,"Aaron Rosenberg",1),
( 20,"Ben Affleck",1),
( 21,"Bob Balaban",1),
( 22,"Alain Sarde",1),
( 23,"Marc Platt",1),
( 24,"Jerry Wald",1),
( 25,"John Roberdeau",1),
( 26,"Brian Currie",1),
( 27,"Paramount Publix",0),
( 28,"Duncan Kenworthy",1),
( 29,"Patrick Palmer",1),
( 30,"Michael Schaefer",1),
( 31,"Marco Morabito",1),
( 32,"Michael Jacobs",1),
( 33,"Jeffrey Levy-Hinte",1),
( 34,"Ceán Chaffin",1),
( 35,"Edward Saxon",1),
( 36,"Lili Fini Zanuck",1),
( 37,"Michael London",1),
( 38,"Alan Marshall",1),
( 39,"Feature Productions",0),
( 40,"Paul Newman",1),
( 41,"Gray Frederickson",1),
( 42,"Lee Daniels",1),
( 43,"Ray Stark",1),
( 44,"Martin Bregman",1),
( 45,"Jeremy Dawson",1),
( 46,"Gianluigi Braschi",1),
( 47,"Gabrielle Tana",1),
( 48,"Michael Shamberg",1),
( 49,"Stanley R. Jaffe",1),
( 50,"Jonathan Sanger",1),
( 51,"Michael Sugar",1),
( 52,"Cy Feuer",1),
( 53,"Dan Levine",1),
( 54,"Paramount",0),
( 55,"Charles H. Joffe",1),
( 56,"Robert De Niro",1),
( 57,"Bill Miller",1),
( 58,"Oliver Stone",1),
( 59,"Walt Disney",1),
( 60,"Lawrence Weingarten",1),
( 61,"Joey McFarland",1),
( 62,"Melvin Frank",1),
( 63,"Scott Rudin",1),
( 64,"Liberty Films",0),
( 65,"Barry Spikings",1),
( 66,"Kathleen Kennedy",1),
( 67,"Peter Saraf",1),
( 68,"Steve Golin",1),
( 69,"Walter Mirisch",1),
( 70,"Leonardo DiCaprio",1),
( 71,"Ceci Dempsey",1),
( 72,"Samuel Goldwyn Jr.",1),
( 73,"Duncan Henderson",1),
( 74,"Martin Brest",1),
( 75,"Kevin Feige",1),
( 76,"Harold Hecht",1),
( 77,"Andy Harries",1),
( 78,"Noah Baumbach",1),
( 79,"Carlo Ponti",1),
( 80,"Ron Yerxa",1),
( 81,"The Caddo Company",0),
( 82,"David Permut",1),
( 83,"Richard Sakai",1),
( 84,"Kevin Messick",1),
( 85,"Gary Kurtz",1),
( 86,"Robert F. Colesberry",1),
( 87,"Adam McKay",1),
( 88,"Uberto Pasolini",1),
( 89,"Michael Katz",1),
( 90,"Jenno Topping",1),
( 91,"Fox",0),
( 92,"Rachel Winter",1),
( 93,"Jesse L. Lasky",0),
( 94,"David T. Friendly",1),
( 95,"Emile Sherman",1),
( 96,"Herbert Ross",1),
( 97,"Charles Roven",1),
( 98,"Pharrell Williams",1),
( 99,"David Weisman",1),
( 100,"Selznick International Pictures",0),
( 101,"Ron Howard",1),
( 102,"Brad Pitt",1),
( 103,"Sydney Pollack",1),
( 104,"Philip S. Hobel",1),
( 105,"Mark Wahlberg",1),
( 106,"Richard Attenborough",1),
( 107,"Cathy Schulman",1),
( 108,"Martin McDonagh",1),
( 109,"Dan Janvey",1),
( 110,"Callum McDougall",1),
( 111,"Lee Magiday",1),
( 112,"Edward Lewis",1),
( 113,"Joel Coen",1),
( 114,"Stephen Woolley",1),
( 115,"Mihálisz Kakojánnisz",1),
( 116,"Albert S. Ruddy",1),
( 117,"Alfonso Cuarón",1),
( 118,"Stephen Tenenbaum",1),
( 119,"Walter Wanger",1),
( 120,"Charles K. Feldman",1),
( 121,"Oprah Winfrey",1),
( 122,"Mel Gibson",1),
( 123,"Finola Dwyer",1),
( 124,"Simon Channing-Williams",1),
( 125,"Robert Benmussa",1),
( 126,"Alberto Grimaldi",1),
( 127,"Stanley Kramer",1),
( 128,"Carl Foreman",1),
( 129,"Charles Brackett",1),
( 130,"Robert Altman",1),
( 131,"Noel Pearson",1),
( 132,"Wes Anderson",1),
( 133,"Steve Starkey",1),
( 134,"John Woolf",1),
( 135,"Lauren Beck",1),
( 136,"Gary Gilbert",1),
( 137,"Eli Bush",1),
( 138,"Chelsea Winstanley",1),
( 139,"William Wyler",1),
( 140,"J. Arthur Rank-Cineguild",0),
( 141,"Saul Zaentz",1),
( 142,"Dana Brunetti",1),
( 143,"Paul Webster",1),
( 144,"Gary Magness",1),
( 145,"Cathleen Sutherland",1),
( 146,"Hal B. Wallis",1),
( 147,"Dick Richards",1),
( 148,"Rainbow Productions",0),
( 149,"William Vince",1),
( 150,"Kristi Zea",1),
( 151,"Michael Mann",1),
( 152,"Donna Gigliotti",1),
( 153,"Carla Hacken",1),
( 154,"Michael Douglas",1),
( 155,"Redmond Morris",1),
( 156,"Graham Broadbent",1),
( 157,"Michael Nathanson",1),
( 158,"Jim Taylor",1),
( 159,"Claude Berri",1),
( 160,"George Stevens",1),
( 161,"J. Miles Dale",1),
( 162,"John Calley",1),
( 163,"Kimberly Steward",1),
( 164,"Robert B. Radnitz",1),
( 165,"Paul Junger Witt",1),
( 166,"Kvak Sine",1),
( 167,"Michael Deeley",1),
( 168,"Christopher Nolan",1),
( 169,"Jan Chapman",1),
( 170,"Ridley Scott",1),
( 171,"Spike Jonze",1),
( 172,"Michael Gottwald",1),
( 173,"Iain Canning",1),
( 174,"Amy Pascal",1),
( 175,"Gerald R. Molen",1),
( 176,"David Puttnam",1),
( 177,"Charles Chaplin Productions",0),
( 178,"Taika Waititi",1),
( 179,"Daniel Dubiecki",1),
( 180,"David Lancaster",1),
( 181,"Lawrence Gordon",1),
( 182,"Gaetano Daniele",1),
( 183,"Charles B. Wessler",1),
( 184,"David Valdes",1),
( 185,"Stephen J. Friedman",1),
( 186,"Luca Guadagnino",1),
( 187,"Philip D'Antoni",1),
( 188,"First National",0),
( 189,"Richard Linklater",1),
( 190,"Ismail Merchant",1),
( 191,"Alex Rose",1),
( 192,"Sean McKittrick",1),
( 193,"Douglas Wick",1),
( 194,"Barbra Streisand",1),
( 195,"Megan Ellison",1),
( 196,"Sam Spiegel",1),
( 197,"Stuart Benjamin",1),
( 198,"Sam Zimbalist",1),
( 199,"Sarah Siegel-Magness",1),
( 200,"George Clooney",1),
( 201,"Henry Ginsberg",1),
( 202,"Aaron Ryder",1),
( 203,"Fred Coe",1),
( 204,"Richard Suckle",1),
( 205,"Ross Katz",1),
( 206,"Henry Blanke",1),
( 207,"Realization D'Art Cinematographique",0),
( 208,"Hszü Li-kung",1),
( 209,"Irwin Winkler",1),
( 210,"Niki Marvin",1),
( 211,"Andrew A. Kosove",1),
( 212,"Otto Preminger",1),
( 213,"Eric Fellner",1),
( 214,"Theodore Melfi",1),
( 215,"Andrew Lazar",1),
( 216,"Todd Black",1),
( 217,"Mildred Lewis",1),
( 218,"Sol Lesser (produkciós cég)",0),
( 219,"Wendy Finerman",1),
( 220,"Debra Hayward",1),
( 221,"Raymond Mansfield",1),
( 222,"Warner Bros.-First National",0),
( 223,"Quentin Tarantino",1),
( 224,"Tony Ray",1),
( 225,"Keith Redmon",1),
( 226,"Steve Coogan",1),
( 227,"Caroline Baron",1),
( 228,"Martin Brown",1),
( 229,"Kerry Orent",1),
( 230,"Gary Ross",1),
( 231,"Andrew Scheinman",1),
( 232,"Paul Haggis",1),
( 233,"Christine Langan",1),
( 234,"Pandro S. Berman",1),
( 235,"Alexander Payne",1),
( 236,"Greg Shapiro",1),
( 237,"Tom Sternberg",1),
( 238,"Angie Fielder",1),
( 239,"Jerome Hellman",1),
( 240,"Judie G. Hoyt",1),
( 241,"Darla K. Anderson",1),
( 242,"Michael Phillips",1),
( 243,"Tim Bevan",1),
( 244,"Jórgosz Lánthimosz",1),
( 245,"Richard D. Zanuck",1),
( 246,"Ron Bozman",1),
( 247,"Barry Mendel",1),
( 248,"James Schamus",1),
( 249,"Paul Thomas Anderson",1),
( 250,"RKO Radio",0),
( 251,"Elda Ferri",1),
( 252,"Leland Hayward",1),
( 253,"Julie Yorn",1),
( 254,"J. Arthur Rank-Archers",0),
( 255,"Anthony Havelock-Allan",1),
( 256,"London Films",0),
( 257,"Burt Sugarman",1),
( 258,"Nora Grossman",1),
( 259,"Universal",0),
( 260,"Alix Madigan",1),
( 261,"Paul Mazursky",1),
( 262,"20th Century",0),
( 263,"Shannon McIntosh",1),
( 264,"John Huston",1),
( 265,"Edward Zwick",1),
( 266,"Arthur Laurents",1),
( 267,"Scott Franklin",1),
( 268,"Ang Lee",1),
( 269,"Ingo Preminger",1),
( 270,"Howard G. Minsky",1),
( 271,"Evelyn O'Neill",1),
( 272,"Cameron Mackintosh",1),
( 273,"Bridget Johnson",1),
( 274,"Vittorio Cecchi Gori",1),
( 275,"Taylor Hackford",1),
( 276,"Samuel Goldwyn Productions",0),
( 277,"Todd Phillips",1),
( 278,"Kit Golden",1),
( 279,"Metro-Goldwyn-Mayer",0),
( 280,"Pong Dzsunho",1),
( 281,"A. Kitman Ho",1),
( 282,"Josh Penn",1),
( 283,"Simon Kinberg",1),
( 284,"Peter Morgan",1),
( 285,"Kathryn Bigelow",1),
( 286,"John Smithson",1),
( 287,"Hal Roach (produkciós cég)",0),
( 288,"Steven M. Rales",1),
( 289,"Fred Kohlmar",1),
( 290,"Bruce Gilbert",1),
( 291,"Reginald Hudlin",1),
( 292,"David Hoberman",1),
( 293,"Ivan Reitman",1),
( 294,"Bruce Cohen",1),
( 295,"Jennifer Fox",1),
( 296,"Joshua Logan",1),
( 297,"William Perlberg",1),
( 298,"Peter Chernin",1),
( 299,"Alan J. Pakula",1),
( 300,"Emilie Georges",1),
( 301,"Denzel Washington",1),
( 302,"Alejandro G. Iñárritu",1),
( 303,"Baz Luhrmann",1),
( 304,"Amanda Posey",1),
( 305,"Jon Landau",1),
( 306,"Frank Darabont",1),
( 307,"Rob Reiner",1),
( 308,"Matt Damon",1),
( 309,"Stanley Kubrick",1),
( 310,"Stefan Arndt",1),
( 311,"Bill Gerber",1),
( 312,"Mark Boal",1),
( 313,"Lindsay Doran",1),
( 314,"Norman Jewison",1),
( 315,"Cecil B. DeMille",1),
( 316,"Ian Bryce",1),
( 317,"George Miller",1),
( 318,"Todd Field",1),
( 319,"Nellie Bellflower",1),
( 320,"Margaret Menegoz",1),
( 321,"Jim Burke",1),
( 322,"Arthur Freed",1),
( 323,"Sarah Green",1),
( 324,"Dede Gardner",1),
( 325,"Anthony Katagas",1),
( 326,"Sherry Lansing",1),
( 327,"Frederick Zollo",1),
( 328,"Nicole Rocklin",1),
( 329,"Martin Richards",1),
( 330,"Nick Vallelonga",1),
( 331,"Kenneth Utt",1),
( 332,"Chris Moore",1),
( 333,"Mary Parent",1),
( 334,"Peter Jackson",1),
( 335,"Steven Spielberg",1),
( 336,"Stacey Sher",1),
( 337,"Martin Scorsese",1),
( 338,"Brian Oliver",1),
( 339,"Roman Polański",1),
( 340,"Howard Gottfried",1),
( 341,"John Houseman",1),
( 342,"Jason Reitman",1),
( 343,"Walter Coblenz",1),
( 344,"Adele Romanski",1),
( 345,"Tracey Seaward",1),
( 346,"Mario Cecchi Gori",1),
( 347,"Ed Guiney",1),
( 348,"Letty Aronson",1),
( 349,"Timothy Burrill",1),
( 350,"Buddy Adler",1),
( 351,"Frank McCarthy",1),
( 352,"Fred Baron",1),
( 353,"Pilar Savone",1),
( 354,"Ortus",0),
( 355,"Jim Wilson",1),
( 356,"Christian Colson",1),
( 357,"Peter Weir",1),
( 358,"Julian Krainin",1),
( 359,"J. Arthur Rank-Two Cities Films",0),
( 360,"Tamara Asseyev",1),
( 361,"Fred Roos",1),
( 362,"Daniel Lupi",1),
( 363,"Bill Pohlad",1),
( 364,"Mark Huffam",1),
( 365,"Ingmar Bergman",1),
( 366,"Billy Wilder",1),
( 367,"Helen Estabrook",1),
( 368,"Carthew Neal",1),
( 369,"David Heyman",1),
( 370,"Warner Bros.",0),
( 371,"Lisa Weinstein",1),
( 372,"Michael Cimino",1),
( 373,"Arnold Kopelson",1),
( 374,"John Boorman",1),
( 375,"Fred Berger",1),
( 376,"Two Cities Films",0),
( 377,"Ross Hunter",1),
( 378,"Michael Ohoven",1),
( 379,"Emma Thomas",1),
( 380,"Michael Grillo",1),
( 381,"Vincent Landay",1),
( 382,"Michael Todd",1),
( 383,"Francis Ford Coppola",1),
( 384,"Kristie Macosko Krieger",1),
( 385,"Grant Hill",1),
( 386,"Guillermo del Toro",1),
( 387,"Gary Levinsohn",1),
( 388,"Steve McQueen",1),
( 389,"Ahmed Rachedi",1),
( 390,"Marshall Herskovitz",1),
( 391,"Mike Medavoy",1),
( 392,"Jane Scott",1),
( 393,"Kevin J. Walsh",1),
( 394,"John Ford",1),
( 395,"Lianne Halfon",1),
( 396,"John Foreman",1),
( 397,"20th Century-Fox",0),
( 398,"Chris Columbus",1),
( 399,"Tony Richardson",1),
( 400,"David Levy",1),
( 401,"Pieter Jan Brugge",1),
( 402,"Alejandro González Iñárritu",1),
( 403,"Martin Poll",1),
( 404,"Jack Cummings",1),
( 405,"Teddy Schwarzman",1),
( 406,"Brian Grazer",1),
( 407,"Alan Ladd Jr.",1),
( 408,"Curtis Hanson",1),
( 409,"Paramount Famous Lasky",0),
( 410,"Harvey Weinstein",1),
( 411,"James Cameron",1),
( 412,"Bradley Cooper",1),
( 413,"Jack L. Warner",1),
( 414,"Hank Moonjean",1),
( 415,"Sol C. Siegel",1),
( 416,"Jordan Peele",1),
( 417,"Columbia",0),
( 418,"Grant Heslov",1),
( 419,"Charles Gordon",1),
( 420,"Bernard Smith",1),
( 421,"Gil Netter",1),
( 422,"Frank Marshall",1),
( 423,"Michael Nozik",1),
( 424,"Richard Wechsler",1),
( 425,"Richard N. Gladstein",1),
( 426,"Sam Mendes",1),
( 427,"Ronald L. Schwary",1),
( 428,"Jane Rosenthal",1),
( 429,"Jeremy Thomas",1),
( 430,"Ethan Coen",1),
( 431,"Pippa Harris",1),
( 432,"Fran Walsh",1),
( 433,"James W. Skotchdopole",1),
( 434,"Don Hahn",1),
( 435,"William Kong",1),
( 436,"Lawrence Lasker",1),
( 437,"Lynette Howell Taylor",1),
( 438,"John Wayne",1),
( 439,"Bill Walsh",1),
( 440,"Quincy Jones",1),
( 441,"Bernard Schwartz",1),
( 442,"Bill Mechanic",1),
( 443,"Elia Kazan",1),
( 444,"Rachael Horovitz",1),
( 445,"Tony Thomas",1),
( 446,"Steve Tisch",1),
( 447,"Charles Okun",1),
( 448,"Norma Heyman",1),
( 449,"Tony Bill",1),
( 450,"Bruce Davey",1),
( 451,"Henry Fonda and Reginald Rose",1),
( 452,"Jonathan Gordon",1),
( 453,"James L. Brooks",1),
( 454,"Doug Mitchell",1),
( 455,"Douglas Urbanski",1),
( 456,"Robbie Brenner",1),
( 457,"Anatole Litvak",1),
( 458,"Dan Jinks",1),
( 459,"Emma Tillinger Koskoff",1),
( 460,"Blye Pagon Faust",1),
( 461,"Bengt Forslund",1),
( 462,"William Goetz",1),
( 463,"Barry Levinson",1),
( 464,"Jacques Perrin",1),
( 465,"Anne Rosellini",1),
( 466,"Robert Fox",1),
( 467,"Arlene Donovan",1),
( 468,"Steven Haft",1),
( 469,"Albert Berger",1),
( 470,"Lawrence Kasdan",1),
( 471,"Howard Baldwin",1),
( 472,"Walter Wanger (produkciós cég)",0),
( 473,"Jason Blum",1),
( 474,"Tom Rosenberg",1),
( 475,"Marc Norman",1),
( 476,"Andrew S. Karsch",1),
( 477,"Brunson Green",1),
( 478,"Fred Zinnemann",1),
( 479,"Mark Johnson",1),
( 480,"Ernest Lehman",1),
( 481,"Fernando Ghia",1),
( 482,"Gareth Unwin",1),
( 483,"Celine Rattray",1),
( 484,"Richard Roth",1),
( 485,"Robert Lorenz",1),
( 486,"Carolynne Cunningham",1),
( 487,"Russell Smith",1),
( 488,"Robert Greenhut",1),
( 489,"Morton DaCosta",1),
( 490,"Darryl F. Zanuck",1),
( 491,"Merian C. Cooper",1),
( 492,"Ido Ostrowsky",1),
( 493,"Richard B. Goodwin",1),
( 494,"Edward S. Feldman",1),
( 495,"Leslie Holleran",1),
( 496,"Robert Rossen",1),
( 497,"Julia Phillips",1),
( 498,"Branko Lustig",1),
( 499,"Danny DeVito",1),
( 500,"Cosmopolitan",0),
( 501,"Gabriela Rodríguez",1),
( 502,"Jordan Horowitz",1),
( 503,"Shawn Levy",1),
( 504,"Broderick Johnson",1),
( 505,"William Peter Blatty",1),
( 506,"Diana Ossana",1),
( 507,"David Franzoni",1),
( 508,"Pete Czernin",1),
( 509,"Graham Leader",1),
( 510,"Bob Rafelson",1),
( 511,"David Parfitt",1),
( 512,"Martin Elfand",1),
( 513,"Lawrence Turman",1),
( 514,"Robert Evans",1),
( 515,"David Womark",1),
( 516,"Mike Nichols",1),
( 517,"Arnon Milchan",1),
( 518,"JoAnne Sellar",1),
( 519,"Kevin Costner",1),
( 520,"Peter Spears",1),
( 521,"Graham King",1),
( 522,"Robert Rossen Productions",0),
( 523,"Robert Chartoff",1),
( 524,"Denis Héroux",1),
( 525,"Robert Wise",1),
( 526,"David Linde",1),
( 527,"Clint Eastwood",1),
( 528,"Michael Barnathan",1),
( 529,"John Lesher",1),
( 530,"Marc Turtletaub",1),
( 531,"Alison Owen",1),
( 532,"Edward H. Hamm Jr.",1),
( 533,"John Peverall",1),
( 534,"Anthony McCarten",1),
( 535,"Walter Parkes",1),
( 536,"Robert Redford",1),
( 537,"Laurence Mark",1),
( 538,"Robert Michael Geisler",1),
( 539,"Jayne-Ann Tenggren",1),
( 540,"Danny Boyle",1),
( 541,"Robert F. Blumofe and Harold Leventhal",1),
( 542,"Lewis Gilbert",1),
( 543,"Warren Beatty",1),
( 544,"Peter Farrelly",1),
( 545,"Irwin Allen",1),
( 546,"Cameron Crowe",1),
( 547,"Michael De Luca",1),
( 548,"Lawrence Bender",1),
( 549,"Veit Heiduschka",1),
( 550,"Todd Lieberman",1),
( 551,"Mason Novick",1),
( 552,"Nicolas Chartier",1),
( 553,"Mercury",0),
( 554,"Mark Gordon",1),
( 555,"Sofia Coppola",1),
( 556,"Laura Bickford",1),
( 557,"Arthur P. Jacobs",1),
( 558,"Barrie M. Osborne",1),
( 559,"and Barry Mendel",1),
( 560,"Thomas Langmann",1),
( 561,"Lisa Bruce",1),
( 562,"Spike Lee",1);

ALTER TABLE `kapcsolat` ADD CONSTRAINT `kapcsolat_21`   FOREIGN KEY (`keszitoid`)     REFERENCES `keszito` (`id`);
ALTER TABLE `kapcsolat` ADD CONSTRAINT `kapcsolat_31`   FOREIGN KEY (`filmid`)     REFERENCES `oscar_film` (`id`);
