Skip to content

Instantly share code, notes, and snippets.

@lucascaton
Created April 26, 2011 03:32
Show Gist options
  • Save lucascaton/941744 to your computer and use it in GitHub Desktop.
Save lucascaton/941744 to your computer and use it in GitHub Desktop.
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