gistfile1

delete from movie_casts where id in (
 select id from movie_casts where movie_id=5, person_id=63, job='Director' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=67 and job='Original Music Composer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=69 and job='Editor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=71 and job='Executive Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=71 and job='Screenplay' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=78 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=79 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=91 and job='Screenplay' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=92 and job='Director of Photography' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=93 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=94 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=95 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=96 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=97 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=98 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=99 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=100 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=101 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=5 and person_id=102 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=1 and job='Special Effects Coordinator' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=2 and job='Special Effects Coordinator' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=3 and job='Art Direction' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=4 and job='Director' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=4 and job='Screenplay' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=5 and job='Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=6 and job='Original Music Composer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=7 and job='Director of Photography' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=8 and job='Editor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=9 and job='Casting' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=10 and job='Casting' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=11 and job='Production Design' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=12 and job='Director' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=12 and job='Screenplay' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=13 and job='Art Direction' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=14 and job='Set Decoration' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=15 and job='Costume Design' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=16 and job='Supervising Sound Effects Editor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=17 and job='Sound Editor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=18 and job='Special Effects' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=19 and job='Special Effects' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=20 and job='Stunts' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=21 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=22 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=23 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=24 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=25 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=26 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=27 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=28 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=29 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=30 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=31 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=32 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=33 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=6 and person_id=34 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=153 and person_id=4 and job='Screenplay' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=157 and person_id=753 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=166 and person_id=891 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=206 and person_id=1443 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=223 and person_id=744 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=223 and person_id=1524 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=223 and person_id=1771 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=223 and person_id=1780 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=226 and person_id=1850 and job='Leadman' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=226 and person_id=1992 and job='Dialogue Editor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=235 and person_id=2222 and job='Author' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=235 and person_id=2223 and job='Author' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=238 and person_id=2315 and job='Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=238 and person_id=2335 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=253 and person_id=2893 and job='Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=256 and person_id=2953 and job='Makeup Artist' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=264 and person_id=894 and job='Music' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=287 and person_id=3282 and job='Art Direction' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=287 and person_id=3293 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=295 and person_id=3411 and job='Executive Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=313 and person_id=3668 and job='Casting' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=375 and person_id=4541 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=388 and person_id=4887 and job='Original Music Composer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=392 and person_id=4929 and job='Costume Design' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=396 and person_id=36 and job='Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=399 and person_id=36 and job='Director' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=406 and person_id=37 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=406 and person_id=4235 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=414 and person_id=5076 and job='Production Design' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=436 and person_id=5320 and job='Original Music Composer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=436 and person_id=5398 and job='Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=443 and person_id=1363 and job='Producer' limit 1
);

delete from movie_casts where id in (
443 1568 Producer
);

delete from movie_casts where id in (
450 889 Actor
);

delete from movie_casts where id in (
450 1341 Actor
);

delete from movie_casts where id in (
459 2182 Director of Photography
);

delete from movie_casts where id in (
463 4191 Actor
);

delete from movie_casts where id in (
474 5831 Executive Producer
);

delete from movie_casts where id in (
474 5834 Director of Photography
);

delete from movie_casts where id in (
476 5871 Screenplay
);

delete from movie_casts where id in (
478 5895 Editor
);

delete from movie_casts where id in (
482 5956 Executive Producer
);

delete from movie_casts where id in (
496 1159 Actor
);

delete from movie_casts where id in (
496 6117 Actor
);

delete from movie_casts where id in (
504 6275 Actor
);

delete from movie_casts where id in (
507 6331 Actor
);

delete from movie_casts where id in (
522 5683 Director of Photography
);

delete from movie_casts where id in (
549 6829 Actor
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=640 and person_id=7878 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=661 and person_id=8084 and job='Costume Design' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=668 and person_id=5506 and job='Author' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=734 and person_id=5944 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=799 and person_id=9237 and job='Other' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=799 and person_id=9240 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=803 and person_id=3979 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19301 and person_id=8741 and job='Writer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19311 and person_id=43328 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19396 and person_id=99737 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19485 and person_id=80612 and job='Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19485 and person_id=91871 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19509 and person_id=20100 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19528 and person_id=100352 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19576 and person_id=77729 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19580 and person_id=100668 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19647 and person_id=100951 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19683 and person_id=48921 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19683 and person_id=48922 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19694 and person_id=101074 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19744 and person_id=90826 and job='Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19805 and person_id=63587 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19806 and person_id=18100 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19917 and person_id=102223 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19917 and person_id=102225 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19918 and person_id=17913 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19940 and person_id=8741 and job='Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=19997 and person_id=102601 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20049 and person_id=76428 and job='Executive Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20049 and person_id=89636 and job='Director of Photography' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20083 and person_id=17566 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20100 and person_id=70985 and job='Producer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20125 and person_id=8300 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20156 and person_id=1795 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20255 and person_id=19323 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20255 and person_id=88990 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20284 and person_id=88842 and job='Editor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20285 and person_id=76582 and job='Editor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20297 and person_id=98520 and job='Music' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20298 and person_id=31411 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20306 and person_id=8741 and job='Writer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20320 and person_id=98736 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20503 and person_id=19504 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20527 and person_id=19580 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20529 and person_id=16887 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20529 and person_id=19580 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20529 and person_id=19594 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20532 and person_id=19609 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20547 and person_id=30709 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20593 and person_id=31501 and job='Editor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20632 and person_id=57880 and job='Original Music Composer' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20777 and person_id=86111 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20889 and person_id=106198 and job='Art Direction' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20934 and person_id=48918 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20934 and person_id=80855 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20934 and person_id=85465 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20934 and person_id=85515 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20934 and person_id=106282 and job='Actor' limit 1
);

delete from movie_casts where id in (
  select id from movie_casts where movie_id=20941 and person_id=3 and job='Art Direction' limit 1
);