Created
October 10, 2016 21:40
-
-
Save jamii/c36a0036503be18834a2127ba4e2e02c 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
SELECT MIN(chn.name) AS voiced_char, | |
MIN(n.name) AS voicing_actress, | |
MIN(t.title) AS voiced_animation | |
FROM aka_name AS an, | |
complete_cast AS cc, | |
comp_cast_type AS cct1, | |
comp_cast_type AS cct2, | |
char_name AS chn, | |
cast_info AS ci, | |
company_name AS cn, | |
info_type AS it, | |
info_type AS it3, | |
keyword AS k, | |
movie_companies AS mc, | |
movie_info AS mi, | |
movie_keyword AS mk, | |
name AS n, | |
person_info AS pi, | |
role_type AS rt, | |
title AS t | |
WHERE cct1.kind ='cast' | |
AND cct2.kind ='complete+verified' | |
AND chn.name = 'Queen' | |
AND ci.note in ('(voice)', | |
'(voice) (uncredited)', | |
'(voice: English version)') | |
AND cn.country_code ='[us]' | |
AND it.info = 'release dates' | |
AND it3.info = 'trivia' | |
AND k.keyword = 'computer-animation' | |
AND mi.info is not null | |
and (mi.info like 'Japan:%200%' | |
or mi.info like 'USA:%200%') | |
AND n.gender ='f' | |
and n.name like '%An%' | |
AND rt.role ='actress' | |
AND t.title = 'Shrek 2' | |
AND t.production_year between 2000 and 2010 | |
AND t.id = mi.movie_id | |
AND t.id = mc.movie_id | |
AND t.id = ci.movie_id | |
AND t.id = mk.movie_id | |
AND t.id = cc.movie_id | |
AND mc.movie_id = ci.movie_id | |
AND mc.movie_id = mi.movie_id | |
AND mc.movie_id = mk.movie_id | |
AND mc.movie_id = cc.movie_id | |
AND mi.movie_id = ci.movie_id | |
AND mi.movie_id = mk.movie_id | |
AND mi.movie_id = cc.movie_id | |
AND ci.movie_id = mk.movie_id | |
AND ci.movie_id = cc.movie_id | |
AND mk.movie_id = cc.movie_id | |
AND cn.id = mc.company_id | |
AND it.id = mi.info_type_id | |
AND n.id = ci.person_id | |
AND rt.id = ci.role_id | |
AND n.id = an.person_id | |
AND ci.person_id = an.person_id | |
AND chn.id = ci.person_role_id | |
AND n.id = pi.person_id | |
AND ci.person_id = pi.person_id | |
AND it3.id = pi.info_type_id | |
AND k.id = mk.keyword_id | |
AND cct1.id = cc.subject_id | |
AND cct2.id = cc.status_id; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment