Created
April 26, 2011 03:32
-
-
Save lucascaton/941744 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=5 and person_id=64 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=443 and person_id=1568 and job='Producer' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=450 and person_id=889 and job='Actor' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=450 and person_id=1341 and job='Actor' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=459 and person_id=2182 and job='Director of Photography' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=463 and person_id=4191 and job='Actor' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=474 and person_id=5831 and job='Executive Producer' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=474 and person_id=5834 and job='Director of Photography' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=476 and person_id=5871 and job='Screenplay' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=478 and person_id=5895 and job='Editor' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=482 and person_id=5956 and job='Executive Producer' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=496 and person_id=1159 and job='Actor' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=496 and person_id=6117 and job='Actor' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=504 and person_id=6275 and job='Actor' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=507 and person_id=6331 and job='Actor' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=522 and person_id=5683 and job='Director of Photography' limit 1 | |
); | |
delete from movie_casts where id in ( | |
select id from movie_casts where movie_id=549 and person_id=6829 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=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=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=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=20527 and person_id=19580 and job='Actor' limit 1 | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment