| 1 | const int IMDB_QUERIES_COUNT = 114; |
|---|---|
| 2 | const char *IMDB_QUERIES[] = { |
| 3 | /* 01a.sql */ "SELECT MIN(mc.note) AS production_note,\n MIN(t.title) AS movie_title,\n MIN(t.production_year) AS movie_year\nFROM company_type AS ct,\n info_type AS it,\n movie_companies AS mc,\n movie_info_idx AS mi_idx,\n title AS t\nWHERE ct.kind = 'production companies'\n AND it.info = 'top 250 rank'\n AND mc.note NOT LIKE '%(as Metro-Goldwyn-Mayer Pictures)%'\n AND (mc.note LIKE '%(co-production)%'\n OR mc.note LIKE '%(presents)%')\n AND ct.id = mc.company_type_id\n AND t.id = mc.movie_id\n AND t.id = mi_idx.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND it.id = mi_idx.info_type_id;\n\n", |
| 4 | /* 01b.sql */ "SELECT MIN(mc.note) AS production_note,\n MIN(t.title) AS movie_title,\n MIN(t.production_year) AS movie_year\nFROM company_type AS ct,\n info_type AS it,\n movie_companies AS mc,\n movie_info_idx AS mi_idx,\n title AS t\nWHERE ct.kind = 'production companies'\n AND it.info = 'bottom 10 rank'\n AND mc.note NOT LIKE '%(as Metro-Goldwyn-Mayer Pictures)%'\n AND t.production_year BETWEEN 2005 AND 2010\n AND ct.id = mc.company_type_id\n AND t.id = mc.movie_id\n AND t.id = mi_idx.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND it.id = mi_idx.info_type_id;\n\n", |
| 5 | /* 01c.sql */ "SELECT MIN(mc.note) AS production_note,\n MIN(t.title) AS movie_title,\n MIN(t.production_year) AS movie_year\nFROM company_type AS ct,\n info_type AS it,\n movie_companies AS mc,\n movie_info_idx AS mi_idx,\n title AS t\nWHERE ct.kind = 'production companies'\n AND it.info = 'top 250 rank'\n AND mc.note NOT LIKE '%(as Metro-Goldwyn-Mayer Pictures)%'\n AND (mc.note LIKE '%(co-production)%')\n AND t.production_year >2010\n AND ct.id = mc.company_type_id\n AND t.id = mc.movie_id\n AND t.id = mi_idx.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND it.id = mi_idx.info_type_id;\n\n", |
| 6 | /* 01d.sql */ "SELECT MIN(mc.note) AS production_note,\n MIN(t.title) AS movie_title,\n MIN(t.production_year) AS movie_year\nFROM company_type AS ct,\n info_type AS it,\n movie_companies AS mc,\n movie_info_idx AS mi_idx,\n title AS t\nWHERE ct.kind = 'production companies'\n AND it.info = 'bottom 10 rank'\n AND mc.note NOT LIKE '%(as Metro-Goldwyn-Mayer Pictures)%'\n AND t.production_year >2000\n AND ct.id = mc.company_type_id\n AND t.id = mc.movie_id\n AND t.id = mi_idx.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND it.id = mi_idx.info_type_id;\n\n", |
| 7 | /* 02a.sql */ "SELECT MIN(t.title) AS movie_title\nFROM company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code ='[de]'\n AND k.keyword ='character-name-in-title'\n AND cn.id = mc.company_id\n AND mc.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 8 | /* 02b.sql */ "SELECT MIN(t.title) AS movie_title\nFROM company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code ='[nl]'\n AND k.keyword ='character-name-in-title'\n AND cn.id = mc.company_id\n AND mc.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 9 | /* 02c.sql */ "SELECT MIN(t.title) AS movie_title\nFROM company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code ='[sm]'\n AND k.keyword ='character-name-in-title'\n AND cn.id = mc.company_id\n AND mc.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 10 | /* 02d.sql */ "SELECT MIN(t.title) AS movie_title\nFROM company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code ='[us]'\n AND k.keyword ='character-name-in-title'\n AND cn.id = mc.company_id\n AND mc.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 11 | /* 03a.sql */ "SELECT MIN(t.title) AS movie_title\nFROM keyword AS k,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE k.keyword LIKE '%sequel%'\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Denish',\n 'Norwegian',\n 'German')\n AND t.production_year > 2005\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND mk.movie_id = mi.movie_id\n AND k.id = mk.keyword_id;\n\n", |
| 12 | /* 03b.sql */ "SELECT MIN(t.title) AS movie_title\nFROM keyword AS k,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE k.keyword LIKE '%sequel%'\n AND mi.info IN ('Bulgaria')\n AND t.production_year > 2010\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND mk.movie_id = mi.movie_id\n AND k.id = mk.keyword_id;\n\n", |
| 13 | /* 03c.sql */ "SELECT MIN(t.title) AS movie_title\nFROM keyword AS k,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE k.keyword LIKE '%sequel%'\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Denish',\n 'Norwegian',\n 'German',\n 'USA',\n 'American')\n AND t.production_year > 1990\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND mk.movie_id = mi.movie_id\n AND k.id = mk.keyword_id;\n\n", |
| 14 | /* 04a.sql */ "SELECT MIN(mi_idx.info) AS rating,\n MIN(t.title) AS movie_title\nFROM info_type AS it,\n keyword AS k,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE it.info ='rating'\n AND k.keyword LIKE '%sequel%'\n AND mi_idx.info > '5.0'\n AND t.production_year > 2005\n AND t.id = mi_idx.movie_id\n AND t.id = mk.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it.id = mi_idx.info_type_id;\n\n", |
| 15 | /* 04b.sql */ "SELECT MIN(mi_idx.info) AS rating,\n MIN(t.title) AS movie_title\nFROM info_type AS it,\n keyword AS k,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE it.info ='rating'\n AND k.keyword LIKE '%sequel%'\n AND mi_idx.info > '9.0'\n AND t.production_year > 2010\n AND t.id = mi_idx.movie_id\n AND t.id = mk.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it.id = mi_idx.info_type_id;\n\n", |
| 16 | /* 04c.sql */ "SELECT MIN(mi_idx.info) AS rating,\n MIN(t.title) AS movie_title\nFROM info_type AS it,\n keyword AS k,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE it.info ='rating'\n AND k.keyword LIKE '%sequel%'\n AND mi_idx.info > '2.0'\n AND t.production_year > 1990\n AND t.id = mi_idx.movie_id\n AND t.id = mk.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it.id = mi_idx.info_type_id;\n\n", |
| 17 | /* 05a.sql */ "SELECT MIN(t.title) AS typical_european_movie\nFROM company_type AS ct,\n info_type AS it,\n movie_companies AS mc,\n movie_info AS mi,\n title AS t\nWHERE ct.kind = 'production companies'\n AND mc.note LIKE '%(theatrical)%'\n AND mc.note LIKE '%(France)%'\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Denish',\n 'Norwegian',\n 'German')\n AND t.production_year > 2005\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND mc.movie_id = mi.movie_id\n AND ct.id = mc.company_type_id\n AND it.id = mi.info_type_id;\n\n", |
| 18 | /* 05b.sql */ "SELECT MIN(t.title) AS american_vhs_movie\nFROM company_type AS ct,\n info_type AS it,\n movie_companies AS mc,\n movie_info AS mi,\n title AS t\nWHERE ct.kind = 'production companies'\n AND mc.note LIKE '%(VHS)%'\n AND mc.note LIKE '%(USA)%'\n AND mc.note LIKE '%(1994)%'\n AND mi.info IN ('USA',\n 'America')\n AND t.production_year > 2010\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND mc.movie_id = mi.movie_id\n AND ct.id = mc.company_type_id\n AND it.id = mi.info_type_id;\n\n", |
| 19 | /* 05c.sql */ "SELECT MIN(t.title) AS american_movie\nFROM company_type AS ct,\n info_type AS it,\n movie_companies AS mc,\n movie_info AS mi,\n title AS t\nWHERE ct.kind = 'production companies'\n AND mc.note NOT LIKE '%(TV)%'\n AND mc.note LIKE '%(USA)%'\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Denish',\n 'Norwegian',\n 'German',\n 'USA',\n 'American')\n AND t.production_year > 1990\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND mc.movie_id = mi.movie_id\n AND ct.id = mc.company_type_id\n AND it.id = mi.info_type_id;\n\n", |
| 20 | /* 06a.sql */ "SELECT MIN(k.keyword) AS movie_keyword,\n MIN(n.name) AS actor_name,\n MIN(t.title) AS marvel_movie\nFROM cast_info AS ci,\n keyword AS k,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword = 'marvel-cinematic-universe'\n AND n.name LIKE '%Downey%Robert%'\n AND t.production_year > 2010\n AND k.id = mk.keyword_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mk.movie_id\n AND n.id = ci.person_id;\n\n", |
| 21 | /* 06b.sql */ "SELECT MIN(k.keyword) AS movie_keyword,\n MIN(n.name) AS actor_name,\n MIN(t.title) AS hero_movie\nFROM cast_info AS ci,\n keyword AS k,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword IN ('superhero',\n 'sequel',\n 'second-part',\n 'marvel-comics',\n 'based-on-comic',\n 'tv-special',\n 'fight',\n 'violence')\n AND n.name LIKE '%Downey%Robert%'\n AND t.production_year > 2014\n AND k.id = mk.keyword_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mk.movie_id\n AND n.id = ci.person_id;\n\n", |
| 22 | /* 06c.sql */ "SELECT MIN(k.keyword) AS movie_keyword,\n MIN(n.name) AS actor_name,\n MIN(t.title) AS marvel_movie\nFROM cast_info AS ci,\n keyword AS k,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword = 'marvel-cinematic-universe'\n AND n.name LIKE '%Downey%Robert%'\n AND t.production_year > 2014\n AND k.id = mk.keyword_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mk.movie_id\n AND n.id = ci.person_id;\n\n", |
| 23 | /* 06d.sql */ "SELECT MIN(k.keyword) AS movie_keyword,\n MIN(n.name) AS actor_name,\n MIN(t.title) AS hero_movie\nFROM cast_info AS ci,\n keyword AS k,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword IN ('superhero',\n 'sequel',\n 'second-part',\n 'marvel-comics',\n 'based-on-comic',\n 'tv-special',\n 'fight',\n 'violence')\n AND n.name LIKE '%Downey%Robert%'\n AND t.production_year > 2000\n AND k.id = mk.keyword_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mk.movie_id\n AND n.id = ci.person_id;\n\n", |
| 24 | /* 06e.sql */ "SELECT MIN(k.keyword) AS movie_keyword,\n MIN(n.name) AS actor_name,\n MIN(t.title) AS marvel_movie\nFROM cast_info AS ci,\n keyword AS k,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword = 'marvel-cinematic-universe'\n AND n.name LIKE '%Downey%Robert%'\n AND t.production_year > 2000\n AND k.id = mk.keyword_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mk.movie_id\n AND n.id = ci.person_id;\n\n", |
| 25 | /* 06f.sql */ "SELECT MIN(k.keyword) AS movie_keyword,\n MIN(n.name) AS actor_name,\n MIN(t.title) AS hero_movie\nFROM cast_info AS ci,\n keyword AS k,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword IN ('superhero',\n 'sequel',\n 'second-part',\n 'marvel-comics',\n 'based-on-comic',\n 'tv-special',\n 'fight',\n 'violence')\n AND t.production_year > 2000\n AND k.id = mk.keyword_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mk.movie_id\n AND n.id = ci.person_id;\n\n", |
| 26 | /* 07a.sql */ "SELECT MIN(n.name) AS of_person,\n MIN(t.title) AS biography_movie\nFROM aka_name AS an,\n cast_info AS ci,\n info_type AS it,\n link_type AS lt,\n movie_link AS ml,\n name AS n,\n person_info AS pi,\n title AS t\nWHERE an.name LIKE '%a%'\n AND it.info ='mini biography'\n AND lt.link ='features'\n AND n.name_pcode_cf BETWEEN 'A' AND 'F'\n AND (n.gender='m'\n OR (n.gender = 'f'\n AND n.name LIKE 'B%'))\n AND pi.note ='Volker Boehm'\n AND t.production_year BETWEEN 1980 AND 1995\n AND n.id = an.person_id\n AND n.id = pi.person_id\n AND ci.person_id = n.id\n AND t.id = ci.movie_id\n AND ml.linked_movie_id = t.id\n AND lt.id = ml.link_type_id\n AND it.id = pi.info_type_id\n AND pi.person_id = an.person_id\n AND pi.person_id = ci.person_id\n AND an.person_id = ci.person_id\n AND ci.movie_id = ml.linked_movie_id;\n\n", |
| 27 | /* 07b.sql */ "SELECT MIN(n.name) AS of_person,\n MIN(t.title) AS biography_movie\nFROM aka_name AS an,\n cast_info AS ci,\n info_type AS it,\n link_type AS lt,\n movie_link AS ml,\n name AS n,\n person_info AS pi,\n title AS t\nWHERE an.name LIKE '%a%'\n AND it.info ='mini biography'\n AND lt.link ='features'\n AND n.name_pcode_cf LIKE 'D%'\n AND n.gender='m'\n AND pi.note ='Volker Boehm'\n AND t.production_year BETWEEN 1980 AND 1984\n AND n.id = an.person_id\n AND n.id = pi.person_id\n AND ci.person_id = n.id\n AND t.id = ci.movie_id\n AND ml.linked_movie_id = t.id\n AND lt.id = ml.link_type_id\n AND it.id = pi.info_type_id\n AND pi.person_id = an.person_id\n AND pi.person_id = ci.person_id\n AND an.person_id = ci.person_id\n AND ci.movie_id = ml.linked_movie_id;\n\n", |
| 28 | /* 07c.sql */ "SELECT MIN(n.name) AS cast_member_name,\n MIN(pi.info) AS cast_member_info\nFROM aka_name AS an,\n cast_info AS ci,\n info_type AS it,\n link_type AS lt,\n movie_link AS ml,\n name AS n,\n person_info AS pi,\n title AS t\nWHERE an.name IS NOT NULL\n AND (an.name LIKE '%a%'\n OR an.name LIKE 'A%')\n AND it.info ='mini biography'\n AND lt.link IN ('references',\n 'referenced in',\n 'features',\n 'featured in')\n AND n.name_pcode_cf BETWEEN 'A' AND 'F'\n AND (n.gender='m'\n OR (n.gender = 'f'\n AND n.name LIKE 'A%'))\n AND pi.note IS NOT NULL\n AND t.production_year BETWEEN 1980 AND 2010\n AND n.id = an.person_id\n AND n.id = pi.person_id\n AND ci.person_id = n.id\n AND t.id = ci.movie_id\n AND ml.linked_movie_id = t.id\n AND lt.id = ml.link_type_id\n AND it.id = pi.info_type_id\n AND pi.person_id = an.person_id\n AND pi.person_id = ci.person_id\n AND an.person_id = ci.person_id\n AND ci.movie_id = ml.linked_movie_id;\n\n", |
| 29 | /* 08a.sql */ "SELECT MIN(an1.name) AS actress_pseudonym,\n MIN(t.title) AS japanese_movie_dubbed\nFROM aka_name AS an1,\n cast_info AS ci,\n company_name AS cn,\n movie_companies AS mc,\n name AS n1,\n role_type AS rt,\n title AS t\nWHERE ci.note ='(voice: English version)'\n AND cn.country_code ='[jp]'\n AND mc.note LIKE '%(Japan)%'\n AND mc.note NOT LIKE '%(USA)%'\n AND n1.name LIKE '%Yo%'\n AND n1.name NOT LIKE '%Yu%'\n AND rt.role ='actress'\n AND an1.person_id = n1.id\n AND n1.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.role_id = rt.id\n AND an1.person_id = ci.person_id\n AND ci.movie_id = mc.movie_id;\n\n", |
| 30 | /* 08b.sql */ "SELECT MIN(an.name) AS acress_pseudonym,\n MIN(t.title) AS japanese_anime_movie\nFROM aka_name AS an,\n cast_info AS ci,\n company_name AS cn,\n movie_companies AS mc,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note ='(voice: English version)'\n AND cn.country_code ='[jp]'\n AND mc.note LIKE '%(Japan)%'\n AND mc.note NOT LIKE '%(USA)%'\n AND (mc.note LIKE '%(2006)%'\n OR mc.note LIKE '%(2007)%')\n AND n.name LIKE '%Yo%'\n AND n.name NOT LIKE '%Yu%'\n AND rt.role ='actress'\n AND t.production_year BETWEEN 2006 AND 2007\n AND (t.title LIKE 'One Piece%'\n OR t.title LIKE 'Dragon Ball Z%')\n AND an.person_id = n.id\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.role_id = rt.id\n AND an.person_id = ci.person_id\n AND ci.movie_id = mc.movie_id;\n\n", |
| 31 | /* 08c.sql */ "SELECT MIN(a1.name) AS writer_pseudo_name,\n MIN(t.title) AS movie_title\nFROM aka_name AS a1,\n cast_info AS ci,\n company_name AS cn,\n movie_companies AS mc,\n name AS n1,\n role_type AS rt,\n title AS t\nWHERE cn.country_code ='[us]'\n AND rt.role ='writer'\n AND a1.person_id = n1.id\n AND n1.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.role_id = rt.id\n AND a1.person_id = ci.person_id\n AND ci.movie_id = mc.movie_id;\n\n", |
| 32 | /* 08d.sql */ "SELECT MIN(an1.name) AS costume_designer_pseudo,\n MIN(t.title) AS movie_with_costumes\nFROM aka_name AS an1,\n cast_info AS ci,\n company_name AS cn,\n movie_companies AS mc,\n name AS n1,\n role_type AS rt,\n title AS t\nWHERE cn.country_code ='[us]'\n AND rt.role ='costume designer'\n AND an1.person_id = n1.id\n AND n1.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.role_id = rt.id\n AND an1.person_id = ci.person_id\n AND ci.movie_id = mc.movie_id;\n\n", |
| 33 | /* 09a.sql */ "SELECT MIN(an.name) AS alternative_name,\n MIN(chn.name) AS character_name,\n MIN(t.title) AS movie\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n movie_companies AS mc,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note IN ('(voice)',\n '(voice: Japanese version)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND mc.note IS NOT NULL\n AND (mc.note LIKE '%(USA)%'\n OR mc.note LIKE '%(worldwide)%')\n AND n.gender ='f'\n AND n.name LIKE '%Ang%'\n AND rt.role ='actress'\n AND t.production_year BETWEEN 2005 AND 2015\n AND ci.movie_id = t.id\n AND t.id = mc.movie_id\n AND ci.movie_id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.role_id = rt.id\n AND n.id = ci.person_id\n AND chn.id = ci.person_role_id\n AND an.person_id = n.id\n AND an.person_id = ci.person_id;\n\n", |
| 34 | /* 09b.sql */ "SELECT MIN(an.name) AS alternative_name,\n MIN(chn.name) AS voiced_character,\n MIN(n.name) AS voicing_actress,\n MIN(t.title) AS american_movie\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n movie_companies AS mc,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note = '(voice)'\n AND cn.country_code ='[us]'\n AND mc.note LIKE '%(200%)%'\n AND (mc.note LIKE '%(USA)%'\n OR mc.note LIKE '%(worldwide)%')\n AND n.gender ='f'\n AND n.name LIKE '%Angel%'\n AND rt.role ='actress'\n AND t.production_year BETWEEN 2007 AND 2010\n AND ci.movie_id = t.id\n AND t.id = mc.movie_id\n AND ci.movie_id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.role_id = rt.id\n AND n.id = ci.person_id\n AND chn.id = ci.person_role_id\n AND an.person_id = n.id\n AND an.person_id = ci.person_id;\n\n", |
| 35 | /* 09c.sql */ "SELECT MIN(an.name) AS alternative_name,\n MIN(chn.name) AS voiced_character_name,\n MIN(n.name) AS voicing_actress,\n MIN(t.title) AS american_movie\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n movie_companies AS mc,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note IN ('(voice)',\n '(voice: Japanese version)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND n.gender ='f'\n AND n.name LIKE '%An%'\n AND rt.role ='actress'\n AND ci.movie_id = t.id\n AND t.id = mc.movie_id\n AND ci.movie_id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.role_id = rt.id\n AND n.id = ci.person_id\n AND chn.id = ci.person_role_id\n AND an.person_id = n.id\n AND an.person_id = ci.person_id;\n\n", |
| 36 | /* 09d.sql */ "SELECT MIN(an.name) AS alternative_name,\n MIN(chn.name) AS voiced_char_name,\n MIN(n.name) AS voicing_actress,\n MIN(t.title) AS american_movie\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n movie_companies AS mc,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note IN ('(voice)',\n '(voice: Japanese version)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND n.gender ='f'\n AND rt.role ='actress'\n AND ci.movie_id = t.id\n AND t.id = mc.movie_id\n AND ci.movie_id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.role_id = rt.id\n AND n.id = ci.person_id\n AND chn.id = ci.person_role_id\n AND an.person_id = n.id\n AND an.person_id = ci.person_id;\n\n", |
| 37 | /* 10a.sql */ "SELECT MIN(chn.name) AS uncredited_voiced_character,\n MIN(t.title) AS russian_movie\nFROM char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n company_type AS ct,\n movie_companies AS mc,\n role_type AS rt,\n title AS t\nWHERE ci.note LIKE '%(voice)%'\n AND ci.note LIKE '%(uncredited)%'\n AND cn.country_code = '[ru]'\n AND rt.role = 'actor'\n AND t.production_year > 2005\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mc.movie_id\n AND chn.id = ci.person_role_id\n AND rt.id = ci.role_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id;\n\n", |
| 38 | /* 10b.sql */ "SELECT MIN(chn.name) AS character,\n MIN(t.title) AS russian_mov_with_actor_producer\nFROM char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n company_type AS ct,\n movie_companies AS mc,\n role_type AS rt,\n title AS t\nWHERE ci.note LIKE '%(producer)%'\n AND cn.country_code = '[ru]'\n AND rt.role = 'actor'\n AND t.production_year > 2010\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mc.movie_id\n AND chn.id = ci.person_role_id\n AND rt.id = ci.role_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id;\n\n", |
| 39 | /* 10c.sql */ "SELECT MIN(chn.name) AS character,\n MIN(t.title) AS movie_with_american_producer\nFROM char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n company_type AS ct,\n movie_companies AS mc,\n role_type AS rt,\n title AS t\nWHERE ci.note LIKE '%(producer)%'\n AND cn.country_code = '[us]'\n AND t.production_year > 1990\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mc.movie_id\n AND chn.id = ci.person_role_id\n AND rt.id = ci.role_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id;\n", |
| 40 | /* 11a.sql */ "SELECT MIN(cn.name) AS from_company,\n MIN(lt.link) AS movie_link_type,\n MIN(t.title) AS non_polish_sequel_movie\nFROM company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cn.country_code !='[pl]'\n AND (cn.name LIKE '%Film%'\n OR cn.name LIKE '%Warner%')\n AND ct.kind ='production companies'\n AND k.keyword ='sequel'\n AND lt.link LIKE '%follow%'\n AND mc.note IS NULL\n AND t.production_year BETWEEN 1950 AND 2000\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id;\n\n", |
| 41 | /* 11b.sql */ "SELECT MIN(cn.name) AS from_company,\n MIN(lt.link) AS movie_link_type,\n MIN(t.title) AS sequel_movie\nFROM company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cn.country_code !='[pl]'\n AND (cn.name LIKE '%Film%'\n OR cn.name LIKE '%Warner%')\n AND ct.kind ='production companies'\n AND k.keyword ='sequel'\n AND lt.link LIKE '%follows%'\n AND mc.note IS NULL\n AND t.production_year = 1998\n AND t.title LIKE '%Money%'\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id;\n\n", |
| 42 | /* 11c.sql */ "SELECT MIN(cn.name) AS from_company,\n MIN(mc.note) AS production_note,\n MIN(t.title) AS movie_based_on_book\nFROM company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cn.country_code !='[pl]'\n AND (cn.name LIKE '20th Century Fox%'\n OR cn.name LIKE 'Twentieth Century Fox%')\n AND ct.kind != 'production companies'\n AND ct.kind IS NOT NULL\n AND k.keyword IN ('sequel',\n 'revenge',\n 'based-on-novel')\n AND mc.note IS NOT NULL\n AND t.production_year > 1950\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id;\n\n", |
| 43 | /* 11d.sql */ "SELECT MIN(cn.name) AS from_company,\n MIN(mc.note) AS production_note,\n MIN(t.title) AS movie_based_on_book\nFROM company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cn.country_code !='[pl]'\n AND ct.kind != 'production companies'\n AND ct.kind IS NOT NULL\n AND k.keyword IN ('sequel',\n 'revenge',\n 'based-on-novel')\n AND mc.note IS NOT NULL\n AND t.production_year > 1950\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id;\n\n", |
| 44 | /* 12a.sql */ "SELECT MIN(cn.name) AS movie_company,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS drama_horror_movie\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n title AS t\nWHERE cn.country_code = '[us]'\n AND ct.kind = 'production companies'\n AND it1.info = 'genres'\n AND it2.info = 'rating'\n AND mi.info IN ('Drama',\n 'Horror')\n AND mi_idx.info > '8.0'\n AND t.production_year BETWEEN 2005 AND 2008\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND mi.info_type_id = it1.id\n AND mi_idx.info_type_id = it2.id\n AND t.id = mc.movie_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id\n AND mc.movie_id = mi.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND mi.movie_id = mi_idx.movie_id;\n\n", |
| 45 | /* 12b.sql */ "SELECT MIN(mi.info) AS budget,\n MIN(t.title) AS unsuccsessful_movie\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n title AS t\nWHERE cn.country_code ='[us]'\n AND ct.kind IS NOT NULL\n AND (ct.kind ='production companies'\n OR ct.kind = 'distributors')\n AND it1.info ='budget'\n AND it2.info ='bottom 10 rank'\n AND t.production_year >2000\n AND (t.title LIKE 'Birdemic%'\n OR t.title LIKE '%Movie%')\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND mi.info_type_id = it1.id\n AND mi_idx.info_type_id = it2.id\n AND t.id = mc.movie_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id\n AND mc.movie_id = mi.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND mi.movie_id = mi_idx.movie_id;\n\n", |
| 46 | /* 12c.sql */ "SELECT MIN(cn.name) AS movie_company,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS mainstream_movie\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n title AS t\nWHERE cn.country_code = '[us]'\n AND ct.kind = 'production companies'\n AND it1.info = 'genres'\n AND it2.info = 'rating'\n AND mi.info IN ('Drama',\n 'Horror',\n 'Western',\n 'Family')\n AND mi_idx.info > '7.0'\n AND t.production_year BETWEEN 2000 AND 2010\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND mi.info_type_id = it1.id\n AND mi_idx.info_type_id = it2.id\n AND t.id = mc.movie_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id\n AND mc.movie_id = mi.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND mi.movie_id = mi_idx.movie_id;\n\n", |
| 47 | /* 13a.sql */ "SELECT MIN(mi.info) AS release_date,\n MIN(miidx.info) AS rating,\n MIN(t.title) AS german_movie\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it,\n info_type AS it2,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS miidx,\n title AS t\nWHERE cn.country_code ='[de]'\n AND ct.kind ='production companies'\n AND it.info ='rating'\n AND it2.info ='release dates'\n AND kt.kind ='movie'\n AND mi.movie_id = t.id\n AND it2.id = mi.info_type_id\n AND kt.id = t.kind_id\n AND mc.movie_id = t.id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id\n AND miidx.movie_id = t.id\n AND it.id = miidx.info_type_id\n AND mi.movie_id = miidx.movie_id\n AND mi.movie_id = mc.movie_id\n AND miidx.movie_id = mc.movie_id;\n\n", |
| 48 | /* 13b.sql */ "SELECT MIN(cn.name) AS producing_company,\n MIN(miidx.info) AS rating,\n MIN(t.title) AS movie_about_winning\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it,\n info_type AS it2,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS miidx,\n title AS t\nWHERE cn.country_code ='[us]'\n AND ct.kind ='production companies'\n AND it.info ='rating'\n AND it2.info ='release dates'\n AND kt.kind ='movie'\n AND t.title != ''\n AND (t.title LIKE '%Champion%'\n OR t.title LIKE '%Loser%')\n AND mi.movie_id = t.id\n AND it2.id = mi.info_type_id\n AND kt.id = t.kind_id\n AND mc.movie_id = t.id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id\n AND miidx.movie_id = t.id\n AND it.id = miidx.info_type_id\n AND mi.movie_id = miidx.movie_id\n AND mi.movie_id = mc.movie_id\n AND miidx.movie_id = mc.movie_id;\n\n", |
| 49 | /* 13c.sql */ "SELECT MIN(cn.name) AS producing_company,\n MIN(miidx.info) AS rating,\n MIN(t.title) AS movie_about_winning\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it,\n info_type AS it2,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS miidx,\n title AS t\nWHERE cn.country_code ='[us]'\n AND ct.kind ='production companies'\n AND it.info ='rating'\n AND it2.info ='release dates'\n AND kt.kind ='movie'\n AND t.title != ''\n AND (t.title LIKE 'Champion%'\n OR t.title LIKE 'Loser%')\n AND mi.movie_id = t.id\n AND it2.id = mi.info_type_id\n AND kt.id = t.kind_id\n AND mc.movie_id = t.id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id\n AND miidx.movie_id = t.id\n AND it.id = miidx.info_type_id\n AND mi.movie_id = miidx.movie_id\n AND mi.movie_id = mc.movie_id\n AND miidx.movie_id = mc.movie_id;\n\n", |
| 50 | /* 13d.sql */ "SELECT MIN(cn.name) AS producing_company,\n MIN(miidx.info) AS rating,\n MIN(t.title) AS movie\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it,\n info_type AS it2,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS miidx,\n title AS t\nWHERE cn.country_code ='[us]'\n AND ct.kind ='production companies'\n AND it.info ='rating'\n AND it2.info ='release dates'\n AND kt.kind ='movie'\n AND mi.movie_id = t.id\n AND it2.id = mi.info_type_id\n AND kt.id = t.kind_id\n AND mc.movie_id = t.id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id\n AND miidx.movie_id = t.id\n AND it.id = miidx.info_type_id\n AND mi.movie_id = miidx.movie_id\n AND mi.movie_id = mc.movie_id\n AND miidx.movie_id = mc.movie_id;\n\n", |
| 51 | /* 14a.sql */ "SELECT MIN(mi_idx.info) AS rating,\n MIN(t.title) AS northern_dark_movie\nFROM info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IN ('murder',\n 'murder-in-title',\n 'blood',\n 'violence')\n AND kt.kind = 'movie'\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Denish',\n 'Norwegian',\n 'German',\n 'USA',\n 'American')\n AND mi_idx.info < '8.5'\n AND t.production_year > 2010\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id;\n\n", |
| 52 | /* 14b.sql */ "SELECT MIN(mi_idx.info) AS rating,\n MIN(t.title) AS western_dark_production\nFROM info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IN ('murder',\n 'murder-in-title')\n AND kt.kind = 'movie'\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Denish',\n 'Norwegian',\n 'German',\n 'USA',\n 'American')\n AND mi_idx.info > '6.0'\n AND t.production_year > 2010\n AND (t.title LIKE '%murder%'\n OR t.title LIKE '%Murder%'\n OR t.title LIKE '%Mord%')\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id;\n\n", |
| 53 | /* 14c.sql */ "SELECT MIN(mi_idx.info) AS rating,\n MIN(t.title) AS north_european_dark_production\nFROM info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IS NOT NULL\n AND k.keyword IN ('murder',\n 'murder-in-title',\n 'blood',\n 'violence')\n AND kt.kind IN ('movie',\n 'episode')\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Danish',\n 'Norwegian',\n 'German',\n 'USA',\n 'American')\n AND mi_idx.info < '8.5'\n AND t.production_year > 2005\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id;\n\n", |
| 54 | /* 15a.sql */ "SELECT MIN(mi.info) AS release_date,\n MIN(t.title) AS internet_movie\nFROM aka_title AS at,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code = '[us]'\n AND it1.info = 'release dates'\n AND mc.note LIKE '%(200%)%'\n AND mc.note LIKE '%(worldwide)%'\n AND mi.note LIKE '%internet%'\n AND mi.info LIKE 'USA:% 200%'\n AND t.production_year > 2000\n AND t.id = at.movie_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = at.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = at.movie_id\n AND mc.movie_id = at.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id;\n\n", |
| 55 | /* 15b.sql */ "SELECT MIN(mi.info) AS release_date,\n MIN(t.title) AS youtube_movie\nFROM aka_title AS at,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code = '[us]'\n AND cn.name = 'YouTube'\n AND it1.info = 'release dates'\n AND mc.note LIKE '%(200%)%'\n AND mc.note LIKE '%(worldwide)%'\n AND mi.note LIKE '%internet%'\n AND mi.info LIKE 'USA:% 200%'\n AND t.production_year BETWEEN 2005 AND 2010\n AND t.id = at.movie_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = at.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = at.movie_id\n AND mc.movie_id = at.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id;\n\n", |
| 56 | /* 15c.sql */ "SELECT MIN(mi.info) AS release_date,\n MIN(t.title) AS modern_american_internet_movie\nFROM aka_title AS at,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code = '[us]'\n AND it1.info = 'release dates'\n AND mi.note LIKE '%internet%'\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'USA:% 199%'\n OR mi.info LIKE 'USA:% 200%')\n AND t.production_year > 1990\n AND t.id = at.movie_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = at.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = at.movie_id\n AND mc.movie_id = at.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id;\n\n", |
| 57 | /* 15d.sql */ "SELECT MIN(at.title) AS aka_title,\n MIN(t.title) AS internet_movie_title\nFROM aka_title AS at,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code = '[us]'\n AND it1.info = 'release dates'\n AND mi.note LIKE '%internet%'\n AND t.production_year > 1990\n AND t.id = at.movie_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = at.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = at.movie_id\n AND mc.movie_id = at.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id;\n\n", |
| 58 | /* 16a.sql */ "SELECT MIN(an.name) AS cool_actor_pseudonym,\n MIN(t.title) AS series_named_after_char\nFROM aka_name AS an,\n cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cn.country_code ='[us]'\n AND k.keyword ='character-name-in-title'\n AND t.episode_nr >= 50\n AND t.episode_nr < 100\n AND an.person_id = n.id\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND an.person_id = ci.person_id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 59 | /* 16b.sql */ "SELECT MIN(an.name) AS cool_actor_pseudonym,\n MIN(t.title) AS series_named_after_char\nFROM aka_name AS an,\n cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cn.country_code ='[us]'\n AND k.keyword ='character-name-in-title'\n AND an.person_id = n.id\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND an.person_id = ci.person_id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 60 | /* 16c.sql */ "SELECT MIN(an.name) AS cool_actor_pseudonym,\n MIN(t.title) AS series_named_after_char\nFROM aka_name AS an,\n cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cn.country_code ='[us]'\n AND k.keyword ='character-name-in-title'\n AND t.episode_nr < 100\n AND an.person_id = n.id\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND an.person_id = ci.person_id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 61 | /* 16d.sql */ "SELECT MIN(an.name) AS cool_actor_pseudonym,\n MIN(t.title) AS series_named_after_char\nFROM aka_name AS an,\n cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cn.country_code ='[us]'\n AND k.keyword ='character-name-in-title'\n AND t.episode_nr >= 5\n AND t.episode_nr < 100\n AND an.person_id = n.id\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND an.person_id = ci.person_id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 62 | /* 17a.sql */ "SELECT MIN(n.name) AS member_in_charnamed_american_movie,\n MIN(n.name) AS a1\nFROM cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cn.country_code ='[us]'\n AND k.keyword ='character-name-in-title'\n AND n.name LIKE 'B%'\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 63 | /* 17b.sql */ "SELECT MIN(n.name) AS member_in_charnamed_movie,\n MIN(n.name) AS a1\nFROM cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword ='character-name-in-title'\n AND n.name LIKE 'Z%'\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 64 | /* 17c.sql */ "SELECT MIN(n.name) AS member_in_charnamed_movie,\n MIN(n.name) AS a1\nFROM cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword ='character-name-in-title'\n AND n.name LIKE 'X%'\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 65 | /* 17d.sql */ "SELECT MIN(n.name) AS member_in_charnamed_movie\nFROM cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword ='character-name-in-title'\n AND n.name LIKE '%Bert%'\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 66 | /* 17e.sql */ "SELECT MIN(n.name) AS member_in_charnamed_movie\nFROM cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cn.country_code ='[us]'\n AND k.keyword ='character-name-in-title'\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 67 | /* 17f.sql */ "SELECT MIN(n.name) AS member_in_charnamed_movie\nFROM cast_info AS ci,\n company_name AS cn,\n keyword AS k,\n movie_companies AS mc,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE k.keyword ='character-name-in-title'\n AND n.name LIKE '%B%'\n AND n.id = ci.person_id\n AND ci.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_id = cn.id\n AND ci.movie_id = mc.movie_id\n AND ci.movie_id = mk.movie_id\n AND mc.movie_id = mk.movie_id;\n\n", |
| 68 | /* 18a.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(t.title) AS movie_title\nFROM cast_info AS ci,\n info_type AS it1,\n info_type AS it2,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n name AS n,\n title AS t\nWHERE ci.note IN ('(producer)',\n '(executive producer)')\n AND it1.info = 'budget'\n AND it2.info = 'votes'\n AND n.gender = 'm'\n AND n.name LIKE '%Tim%'\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id;\n\n", |
| 69 | /* 18b.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(t.title) AS movie_title\nFROM cast_info AS ci,\n info_type AS it1,\n info_type AS it2,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n name AS n,\n title AS t\nWHERE ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND it1.info = 'genres'\n AND it2.info = 'rating'\n AND mi.info IN ('Horror',\n 'Thriller')\n AND mi.note IS NULL\n AND mi_idx.info > '8.0'\n AND n.gender IS NOT NULL\n AND n.gender = 'f'\n AND t.production_year BETWEEN 2008 AND 2014\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id;\n\n", |
| 70 | /* 18c.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(t.title) AS movie_title\nFROM cast_info AS ci,\n info_type AS it1,\n info_type AS it2,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n name AS n,\n title AS t\nWHERE ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND mi.info IN ('Horror',\n 'Action',\n 'Sci-Fi',\n 'Thriller',\n 'Crime',\n 'War')\n AND n.gender = 'm'\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id;\n\n", |
| 71 | /* 19a.sql */ "SELECT MIN(n.name) AS voicing_actress,\n MIN(t.title) AS voiced_movie\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n info_type AS it,\n movie_companies AS mc,\n movie_info AS mi,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note IN ('(voice)',\n '(voice: Japanese version)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND it.info = 'release dates'\n AND mc.note IS NOT NULL\n AND (mc.note LIKE '%(USA)%'\n OR mc.note LIKE '%(worldwide)%')\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'Japan:%200%'\n OR mi.info LIKE 'USA:%200%')\n AND n.gender ='f'\n AND n.name LIKE '%Ang%'\n AND rt.role ='actress'\n AND t.production_year BETWEEN 2005 AND 2009\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND mc.movie_id = ci.movie_id\n AND mc.movie_id = mi.movie_id\n AND mi.movie_id = ci.movie_id\n AND cn.id = mc.company_id\n AND it.id = mi.info_type_id\n AND n.id = ci.person_id\n AND rt.id = ci.role_id\n AND n.id = an.person_id\n AND ci.person_id = an.person_id\n AND chn.id = ci.person_role_id;\n\n", |
| 72 | /* 19b.sql */ "SELECT MIN(n.name) AS voicing_actress,\n MIN(t.title) AS kung_fu_panda\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n info_type AS it,\n movie_companies AS mc,\n movie_info AS mi,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note = '(voice)'\n AND cn.country_code ='[us]'\n AND it.info = 'release dates'\n AND mc.note LIKE '%(200%)%'\n AND (mc.note LIKE '%(USA)%'\n OR mc.note LIKE '%(worldwide)%')\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'Japan:%2007%'\n OR mi.info LIKE 'USA:%2008%')\n AND n.gender ='f'\n AND n.name LIKE '%Angel%'\n AND rt.role ='actress'\n AND t.production_year BETWEEN 2007 AND 2008\n AND t.title LIKE '%Kung%Fu%Panda%'\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND mc.movie_id = ci.movie_id\n AND mc.movie_id = mi.movie_id\n AND mi.movie_id = ci.movie_id\n AND cn.id = mc.company_id\n AND it.id = mi.info_type_id\n AND n.id = ci.person_id\n AND rt.id = ci.role_id\n AND n.id = an.person_id\n AND ci.person_id = an.person_id\n AND chn.id = ci.person_role_id;\n\n", |
| 73 | /* 19c.sql */ "SELECT MIN(n.name) AS voicing_actress,\n MIN(t.title) AS jap_engl_voiced_movie\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n info_type AS it,\n movie_companies AS mc,\n movie_info AS mi,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note IN ('(voice)',\n '(voice: Japanese version)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND it.info = 'release dates'\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'Japan:%200%'\n OR mi.info LIKE 'USA:%200%')\n AND n.gender ='f'\n AND n.name LIKE '%An%'\n AND rt.role ='actress'\n AND t.production_year > 2000\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND mc.movie_id = ci.movie_id\n AND mc.movie_id = mi.movie_id\n AND mi.movie_id = ci.movie_id\n AND cn.id = mc.company_id\n AND it.id = mi.info_type_id\n AND n.id = ci.person_id\n AND rt.id = ci.role_id\n AND n.id = an.person_id\n AND ci.person_id = an.person_id\n AND chn.id = ci.person_role_id;\n\n", |
| 74 | /* 19d.sql */ "SELECT MIN(n.name) AS voicing_actress,\n MIN(t.title) AS jap_engl_voiced_movie\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n info_type AS it,\n movie_companies AS mc,\n movie_info AS mi,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note IN ('(voice)',\n '(voice: Japanese version)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND it.info = 'release dates'\n AND n.gender ='f'\n AND rt.role ='actress'\n AND t.production_year > 2000\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND mc.movie_id = ci.movie_id\n AND mc.movie_id = mi.movie_id\n AND mi.movie_id = ci.movie_id\n AND cn.id = mc.company_id\n AND it.id = mi.info_type_id\n AND n.id = ci.person_id\n AND rt.id = ci.role_id\n AND n.id = an.person_id\n AND ci.person_id = an.person_id\n AND chn.id = ci.person_role_id;\n\n", |
| 75 | /* 20a.sql */ "SELECT MIN(t.title) AS complete_downey_ironman_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n char_name AS chn,\n cast_info AS ci,\n keyword AS k,\n kind_type AS kt,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cct1.kind = 'cast'\n AND cct2.kind LIKE '%complete%'\n AND chn.name NOT LIKE '%Sherlock%'\n AND (chn.name LIKE '%Tony%Stark%'\n OR chn.name LIKE '%Iron%Man%')\n AND k.keyword IN ('superhero',\n 'sequel',\n 'second-part',\n 'marvel-comics',\n 'based-on-comic',\n 'tv-special',\n 'fight',\n 'violence')\n AND kt.kind = 'movie'\n AND t.production_year > 1950\n AND kt.id = t.kind_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND t.id = cc.movie_id\n AND mk.movie_id = ci.movie_id\n AND mk.movie_id = cc.movie_id\n AND ci.movie_id = cc.movie_id\n AND chn.id = ci.person_role_id\n AND n.id = ci.person_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 76 | /* 20b.sql */ "SELECT MIN(t.title) AS complete_downey_ironman_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n char_name AS chn,\n cast_info AS ci,\n keyword AS k,\n kind_type AS kt,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cct1.kind = 'cast'\n AND cct2.kind LIKE '%complete%'\n AND chn.name NOT LIKE '%Sherlock%'\n AND (chn.name LIKE '%Tony%Stark%'\n OR chn.name LIKE '%Iron%Man%')\n AND k.keyword IN ('superhero',\n 'sequel',\n 'second-part',\n 'marvel-comics',\n 'based-on-comic',\n 'tv-special',\n 'fight',\n 'violence')\n AND kt.kind = 'movie'\n AND n.name LIKE '%Downey%Robert%'\n AND t.production_year > 2000\n AND kt.id = t.kind_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND t.id = cc.movie_id\n AND mk.movie_id = ci.movie_id\n AND mk.movie_id = cc.movie_id\n AND ci.movie_id = cc.movie_id\n AND chn.id = ci.person_role_id\n AND n.id = ci.person_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 77 | /* 20c.sql */ "SELECT MIN(n.name) AS cast_member,\n MIN(t.title) AS complete_dynamic_hero_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n char_name AS chn,\n cast_info AS ci,\n keyword AS k,\n kind_type AS kt,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cct1.kind = 'cast'\n AND cct2.kind LIKE '%complete%'\n AND chn.name IS NOT NULL\n AND (chn.name LIKE '%man%'\n OR chn.name LIKE '%Man%')\n AND k.keyword IN ('superhero',\n 'marvel-comics',\n 'based-on-comic',\n 'tv-special',\n 'fight',\n 'violence',\n 'magnet',\n 'web',\n 'claw',\n 'laser')\n AND kt.kind = 'movie'\n AND t.production_year > 2000\n AND kt.id = t.kind_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND t.id = cc.movie_id\n AND mk.movie_id = ci.movie_id\n AND mk.movie_id = cc.movie_id\n AND ci.movie_id = cc.movie_id\n AND chn.id = ci.person_role_id\n AND n.id = ci.person_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 78 | /* 21a.sql */ "SELECT MIN(cn.name) AS company_name,\n MIN(lt.link) AS link_type,\n MIN(t.title) AS western_follow_up\nFROM company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cn.country_code !='[pl]'\n AND (cn.name LIKE '%Film%'\n OR cn.name LIKE '%Warner%')\n AND ct.kind ='production companies'\n AND k.keyword ='sequel'\n AND lt.link LIKE '%follow%'\n AND mc.note IS NULL\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Denish',\n 'Norwegian',\n 'German')\n AND t.production_year BETWEEN 1950 AND 2000\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND mi.movie_id = t.id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id\n AND ml.movie_id = mi.movie_id\n AND mk.movie_id = mi.movie_id\n AND mc.movie_id = mi.movie_id;\n\n", |
| 79 | /* 21b.sql */ "SELECT MIN(cn.name) AS company_name,\n MIN(lt.link) AS link_type,\n MIN(t.title) AS german_follow_up\nFROM company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cn.country_code !='[pl]'\n AND (cn.name LIKE '%Film%'\n OR cn.name LIKE '%Warner%')\n AND ct.kind ='production companies'\n AND k.keyword ='sequel'\n AND lt.link LIKE '%follow%'\n AND mc.note IS NULL\n AND mi.info IN ('Germany',\n 'German')\n AND t.production_year BETWEEN 2000 AND 2010\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND mi.movie_id = t.id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id\n AND ml.movie_id = mi.movie_id\n AND mk.movie_id = mi.movie_id\n AND mc.movie_id = mi.movie_id;\n\n", |
| 80 | /* 21c.sql */ "SELECT MIN(cn.name) AS company_name,\n MIN(lt.link) AS link_type,\n MIN(t.title) AS western_follow_up\nFROM company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cn.country_code !='[pl]'\n AND (cn.name LIKE '%Film%'\n OR cn.name LIKE '%Warner%')\n AND ct.kind ='production companies'\n AND k.keyword ='sequel'\n AND lt.link LIKE '%follow%'\n AND mc.note IS NULL\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Denish',\n 'Norwegian',\n 'German',\n 'English')\n AND t.production_year BETWEEN 1950 AND 2010\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND mi.movie_id = t.id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id\n AND ml.movie_id = mi.movie_id\n AND mk.movie_id = mi.movie_id\n AND mc.movie_id = mi.movie_id;\n\n", |
| 81 | /* 22a.sql */ "SELECT MIN(cn.name) AS movie_company,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS western_violent_movie\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code != '[us]'\n AND it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IN ('murder',\n 'murder-in-title',\n 'blood',\n 'violence')\n AND kt.kind IN ('movie',\n 'episode')\n AND mc.note NOT LIKE '%(USA)%'\n AND mc.note LIKE '%(200%)%'\n AND mi.info IN ('Germany',\n 'German',\n 'USA',\n 'American')\n AND mi_idx.info < '7.0'\n AND t.production_year > 2008\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = mc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mk.movie_id = mc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mc.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id;\n\n", |
| 82 | /* 22b.sql */ "SELECT MIN(cn.name) AS movie_company,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS western_violent_movie\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code != '[us]'\n AND it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IN ('murder',\n 'murder-in-title',\n 'blood',\n 'violence')\n AND kt.kind IN ('movie',\n 'episode')\n AND mc.note NOT LIKE '%(USA)%'\n AND mc.note LIKE '%(200%)%'\n AND mi.info IN ('Germany',\n 'German',\n 'USA',\n 'American')\n AND mi_idx.info < '7.0'\n AND t.production_year > 2009\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = mc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mk.movie_id = mc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mc.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id;\n\n", |
| 83 | /* 22c.sql */ "SELECT MIN(cn.name) AS movie_company,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS western_violent_movie\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code != '[us]'\n AND it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IN ('murder',\n 'murder-in-title',\n 'blood',\n 'violence')\n AND kt.kind IN ('movie',\n 'episode')\n AND mc.note NOT LIKE '%(USA)%'\n AND mc.note LIKE '%(200%)%'\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Danish',\n 'Norwegian',\n 'German',\n 'USA',\n 'American')\n AND mi_idx.info < '8.5'\n AND t.production_year > 2005\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = mc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mk.movie_id = mc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mc.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id;\n\n", |
| 84 | /* 22d.sql */ "SELECT MIN(cn.name) AS movie_company,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS western_violent_movie\nFROM company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE cn.country_code != '[us]'\n AND it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IN ('murder',\n 'murder-in-title',\n 'blood',\n 'violence')\n AND kt.kind IN ('movie',\n 'episode')\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Danish',\n 'Norwegian',\n 'German',\n 'USA',\n 'American')\n AND mi_idx.info < '8.5'\n AND t.production_year > 2005\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = mc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mk.movie_id = mc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mc.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id;\n\n", |
| 85 | /* 23a.sql */ "SELECT MIN(kt.kind) AS movie_kind,\n MIN(t.title) AS complete_us_internet_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE cct1.kind = 'complete+verified'\n AND cn.country_code = '[us]'\n AND it1.info = 'release dates'\n AND kt.kind IN ('movie')\n AND mi.note LIKE '%internet%'\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'USA:% 199%'\n OR mi.info LIKE 'USA:% 200%')\n AND t.production_year > 2000\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND t.id = cc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = cc.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = cc.movie_id\n AND mc.movie_id = cc.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id\n AND cct1.id = cc.status_id;\n\n", |
| 86 | /* 23b.sql */ "SELECT MIN(kt.kind) AS movie_kind,\n MIN(t.title) AS complete_nerdy_internet_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE cct1.kind = 'complete+verified'\n AND cn.country_code = '[us]'\n AND it1.info = 'release dates'\n AND k.keyword IN ('nerd',\n 'loner',\n 'alienation',\n 'dignity')\n AND kt.kind IN ('movie')\n AND mi.note LIKE '%internet%'\n AND mi.info LIKE 'USA:% 200%'\n AND t.production_year > 2000\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND t.id = cc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = cc.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = cc.movie_id\n AND mc.movie_id = cc.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id\n AND cct1.id = cc.status_id;\n\n", |
| 87 | /* 23c.sql */ "SELECT MIN(kt.kind) AS movie_kind,\n MIN(t.title) AS complete_us_internet_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n title AS t\nWHERE cct1.kind = 'complete+verified'\n AND cn.country_code = '[us]'\n AND it1.info = 'release dates'\n AND kt.kind IN ('movie',\n 'tv movie',\n 'video movie',\n 'video game')\n AND mi.note LIKE '%internet%'\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'USA:% 199%'\n OR mi.info LIKE 'USA:% 200%')\n AND t.production_year > 1990\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND t.id = cc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = cc.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = cc.movie_id\n AND mc.movie_id = cc.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND cn.id = mc.company_id\n AND ct.id = mc.company_type_id\n AND cct1.id = cc.status_id;\n\n", |
| 88 | /* 24a.sql */ "SELECT MIN(chn.name) AS voiced_char_name,\n MIN(n.name) AS voicing_actress_name,\n MIN(t.title) AS voiced_action_movie_jap_eng\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n info_type AS it,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note IN ('(voice)',\n '(voice: Japanese version)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND it.info = 'release dates'\n AND k.keyword IN ('hero',\n 'martial-arts',\n 'hand-to-hand-combat')\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'Japan:%201%'\n OR mi.info LIKE 'USA:%201%')\n AND n.gender ='f'\n AND n.name LIKE '%An%'\n AND rt.role ='actress'\n AND t.production_year > 2010\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND mc.movie_id = ci.movie_id\n AND mc.movie_id = mi.movie_id\n AND mc.movie_id = mk.movie_id\n AND mi.movie_id = ci.movie_id\n AND mi.movie_id = mk.movie_id\n AND ci.movie_id = mk.movie_id\n AND cn.id = mc.company_id\n AND it.id = mi.info_type_id\n AND n.id = ci.person_id\n AND rt.id = ci.role_id\n AND n.id = an.person_id\n AND ci.person_id = an.person_id\n AND chn.id = ci.person_role_id\n AND k.id = mk.keyword_id;\n\n", |
| 89 | /* 24b.sql */ "SELECT MIN(chn.name) AS voiced_char_name,\n MIN(n.name) AS voicing_actress_name,\n MIN(t.title) AS kung_fu_panda\nFROM aka_name AS an,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n info_type AS it,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n name AS n,\n role_type AS rt,\n title AS t\nWHERE ci.note IN ('(voice)',\n '(voice: Japanese version)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND cn.name = 'DreamWorks Animation'\n AND it.info = 'release dates'\n AND k.keyword IN ('hero',\n 'martial-arts',\n 'hand-to-hand-combat',\n 'computer-animated-movie')\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'Japan:%201%'\n OR mi.info LIKE 'USA:%201%')\n AND n.gender ='f'\n AND n.name LIKE '%An%'\n AND rt.role ='actress'\n AND t.production_year > 2010\n AND t.title LIKE 'Kung Fu Panda%'\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND mc.movie_id = ci.movie_id\n AND mc.movie_id = mi.movie_id\n AND mc.movie_id = mk.movie_id\n AND mi.movie_id = ci.movie_id\n AND mi.movie_id = mk.movie_id\n AND ci.movie_id = mk.movie_id\n AND cn.id = mc.company_id\n AND it.id = mi.info_type_id\n AND n.id = ci.person_id\n AND rt.id = ci.role_id\n AND n.id = an.person_id\n AND ci.person_id = an.person_id\n AND chn.id = ci.person_role_id\n AND k.id = mk.keyword_id;\n\n", |
| 90 | /* 25a.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(n.name) AS male_writer,\n MIN(t.title) AS violent_movie_title\nFROM cast_info AS ci,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND k.keyword IN ('murder',\n 'blood',\n 'gore',\n 'death',\n 'female-nudity')\n AND mi.info = 'Horror'\n AND n.gender = 'm'\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND ci.movie_id = mk.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi_idx.movie_id = mk.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND k.id = mk.keyword_id;\n\n", |
| 91 | /* 25b.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(n.name) AS male_writer,\n MIN(t.title) AS violent_movie_title\nFROM cast_info AS ci,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND k.keyword IN ('murder',\n 'blood',\n 'gore',\n 'death',\n 'female-nudity')\n AND mi.info = 'Horror'\n AND n.gender = 'm'\n AND t.production_year > 2010\n AND t.title LIKE 'Vampire%'\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND ci.movie_id = mk.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi_idx.movie_id = mk.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND k.id = mk.keyword_id;\n\n", |
| 92 | /* 25c.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(n.name) AS male_writer,\n MIN(t.title) AS violent_movie_title\nFROM cast_info AS ci,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND k.keyword IN ('murder',\n 'violence',\n 'blood',\n 'gore',\n 'death',\n 'female-nudity',\n 'hospital')\n AND mi.info IN ('Horror',\n 'Action',\n 'Sci-Fi',\n 'Thriller',\n 'Crime',\n 'War')\n AND n.gender = 'm'\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND ci.movie_id = mk.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi_idx.movie_id = mk.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND k.id = mk.keyword_id;\n\n", |
| 93 | /* 26a.sql */ "SELECT MIN(chn.name) AS character_name,\n MIN(mi_idx.info) AS rating,\n MIN(n.name) AS playing_actor,\n MIN(t.title) AS complete_hero_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n char_name AS chn,\n cast_info AS ci,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cct1.kind = 'cast'\n AND cct2.kind LIKE '%complete%'\n AND chn.name IS NOT NULL\n AND (chn.name LIKE '%man%'\n OR chn.name LIKE '%Man%')\n AND it2.info = 'rating'\n AND k.keyword IN ('superhero',\n 'marvel-comics',\n 'based-on-comic',\n 'tv-special',\n 'fight',\n 'violence',\n 'magnet',\n 'web',\n 'claw',\n 'laser')\n AND kt.kind = 'movie'\n AND mi_idx.info > '7.0'\n AND t.production_year > 2000\n AND kt.id = t.kind_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND t.id = cc.movie_id\n AND t.id = mi_idx.movie_id\n AND mk.movie_id = ci.movie_id\n AND mk.movie_id = cc.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND ci.movie_id = cc.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND cc.movie_id = mi_idx.movie_id\n AND chn.id = ci.person_role_id\n AND n.id = ci.person_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id\n AND it2.id = mi_idx.info_type_id;\n\n", |
| 94 | /* 26b.sql */ "SELECT MIN(chn.name) AS character_name,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS complete_hero_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n char_name AS chn,\n cast_info AS ci,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cct1.kind = 'cast'\n AND cct2.kind LIKE '%complete%'\n AND chn.name IS NOT NULL\n AND (chn.name LIKE '%man%'\n OR chn.name LIKE '%Man%')\n AND it2.info = 'rating'\n AND k.keyword IN ('superhero',\n 'marvel-comics',\n 'based-on-comic',\n 'fight')\n AND kt.kind = 'movie'\n AND mi_idx.info > '8.0'\n AND t.production_year > 2005\n AND kt.id = t.kind_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND t.id = cc.movie_id\n AND t.id = mi_idx.movie_id\n AND mk.movie_id = ci.movie_id\n AND mk.movie_id = cc.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND ci.movie_id = cc.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND cc.movie_id = mi_idx.movie_id\n AND chn.id = ci.person_role_id\n AND n.id = ci.person_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id\n AND it2.id = mi_idx.info_type_id;\n\n", |
| 95 | /* 26c.sql */ "SELECT MIN(chn.name) AS character_name,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS complete_hero_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n char_name AS chn,\n cast_info AS ci,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cct1.kind = 'cast'\n AND cct2.kind LIKE '%complete%'\n AND chn.name IS NOT NULL\n AND (chn.name LIKE '%man%'\n OR chn.name LIKE '%Man%')\n AND it2.info = 'rating'\n AND k.keyword IN ('superhero',\n 'marvel-comics',\n 'based-on-comic',\n 'tv-special',\n 'fight',\n 'violence',\n 'magnet',\n 'web',\n 'claw',\n 'laser')\n AND kt.kind = 'movie'\n AND t.production_year > 2000\n AND kt.id = t.kind_id\n AND t.id = mk.movie_id\n AND t.id = ci.movie_id\n AND t.id = cc.movie_id\n AND t.id = mi_idx.movie_id\n AND mk.movie_id = ci.movie_id\n AND mk.movie_id = cc.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND ci.movie_id = cc.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND cc.movie_id = mi_idx.movie_id\n AND chn.id = ci.person_role_id\n AND n.id = ci.person_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id\n AND it2.id = mi_idx.info_type_id;\n\n", |
| 96 | /* 27a.sql */ "SELECT MIN(cn.name) AS producing_company,\n MIN(lt.link) AS link_type,\n MIN(t.title) AS complete_western_sequel\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cct1.kind IN ('cast',\n 'crew')\n AND cct2.kind = 'complete'\n AND cn.country_code !='[pl]'\n AND (cn.name LIKE '%Film%'\n OR cn.name LIKE '%Warner%')\n AND ct.kind ='production companies'\n AND k.keyword ='sequel'\n AND lt.link LIKE '%follow%'\n AND mc.note IS NULL\n AND mi.info IN ('Sweden',\n 'Germany',\n 'Swedish',\n 'German')\n AND t.production_year BETWEEN 1950 AND 2000\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND mi.movie_id = t.id\n AND t.id = cc.movie_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id\n AND ml.movie_id = mi.movie_id\n AND mk.movie_id = mi.movie_id\n AND mc.movie_id = mi.movie_id\n AND ml.movie_id = cc.movie_id\n AND mk.movie_id = cc.movie_id\n AND mc.movie_id = cc.movie_id\n AND mi.movie_id = cc.movie_id;\n\n", |
| 97 | /* 27b.sql */ "SELECT MIN(cn.name) AS producing_company,\n MIN(lt.link) AS link_type,\n MIN(t.title) AS complete_western_sequel\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cct1.kind IN ('cast',\n 'crew')\n AND cct2.kind = 'complete'\n AND cn.country_code !='[pl]'\n AND (cn.name LIKE '%Film%'\n OR cn.name LIKE '%Warner%')\n AND ct.kind ='production companies'\n AND k.keyword ='sequel'\n AND lt.link LIKE '%follow%'\n AND mc.note IS NULL\n AND mi.info IN ('Sweden',\n 'Germany',\n 'Swedish',\n 'German')\n AND t.production_year = 1998\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND mi.movie_id = t.id\n AND t.id = cc.movie_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id\n AND ml.movie_id = mi.movie_id\n AND mk.movie_id = mi.movie_id\n AND mc.movie_id = mi.movie_id\n AND ml.movie_id = cc.movie_id\n AND mk.movie_id = cc.movie_id\n AND mc.movie_id = cc.movie_id\n AND mi.movie_id = cc.movie_id;\n\n", |
| 98 | /* 27c.sql */ "SELECT MIN(cn.name) AS producing_company,\n MIN(lt.link) AS link_type,\n MIN(t.title) AS complete_western_sequel\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n company_name AS cn,\n company_type AS ct,\n keyword AS k,\n link_type AS lt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t\nWHERE cct1.kind = 'cast'\n AND cct2.kind LIKE 'complete%'\n AND cn.country_code !='[pl]'\n AND (cn.name LIKE '%Film%'\n OR cn.name LIKE '%Warner%')\n AND ct.kind ='production companies'\n AND k.keyword ='sequel'\n AND lt.link LIKE '%follow%'\n AND mc.note IS NULL\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Denish',\n 'Norwegian',\n 'German',\n 'English')\n AND t.production_year BETWEEN 1950 AND 2010\n AND lt.id = ml.link_type_id\n AND ml.movie_id = t.id\n AND t.id = mk.movie_id\n AND mk.keyword_id = k.id\n AND t.id = mc.movie_id\n AND mc.company_type_id = ct.id\n AND mc.company_id = cn.id\n AND mi.movie_id = t.id\n AND t.id = cc.movie_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id\n AND ml.movie_id = mk.movie_id\n AND ml.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id\n AND ml.movie_id = mi.movie_id\n AND mk.movie_id = mi.movie_id\n AND mc.movie_id = mi.movie_id\n AND ml.movie_id = cc.movie_id\n AND mk.movie_id = cc.movie_id\n AND mc.movie_id = cc.movie_id\n AND mi.movie_id = cc.movie_id;\n\n", |
| 99 | /* 28a.sql */ "SELECT MIN(cn.name) AS movie_company,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS complete_euro_dark_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE cct1.kind = 'crew'\n AND cct2.kind != 'complete+verified'\n AND cn.country_code != '[us]'\n AND it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IN ('murder',\n 'murder-in-title',\n 'blood',\n 'violence')\n AND kt.kind IN ('movie',\n 'episode')\n AND mc.note NOT LIKE '%(USA)%'\n AND mc.note LIKE '%(200%)%'\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Danish',\n 'Norwegian',\n 'German',\n 'USA',\n 'American')\n AND mi_idx.info < '8.5'\n AND t.production_year > 2000\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = mc.movie_id\n AND t.id = cc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = cc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = cc.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND mc.movie_id = cc.movie_id\n AND mi_idx.movie_id = cc.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 100 | /* 28b.sql */ "SELECT MIN(cn.name) AS movie_company,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS complete_euro_dark_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE cct1.kind = 'crew'\n AND cct2.kind != 'complete+verified'\n AND cn.country_code != '[us]'\n AND it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IN ('murder',\n 'murder-in-title',\n 'blood',\n 'violence')\n AND kt.kind IN ('movie',\n 'episode')\n AND mc.note NOT LIKE '%(USA)%'\n AND mc.note LIKE '%(200%)%'\n AND mi.info IN ('Sweden',\n 'Germany',\n 'Swedish',\n 'German')\n AND mi_idx.info > '6.5'\n AND t.production_year > 2005\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = mc.movie_id\n AND t.id = cc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = cc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = cc.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND mc.movie_id = cc.movie_id\n AND mi_idx.movie_id = cc.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 101 | /* 28c.sql */ "SELECT MIN(cn.name) AS movie_company,\n MIN(mi_idx.info) AS rating,\n MIN(t.title) AS complete_euro_dark_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n company_name AS cn,\n company_type AS ct,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n kind_type AS kt,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n title AS t\nWHERE cct1.kind = 'cast'\n AND cct2.kind = 'complete'\n AND cn.country_code != '[us]'\n AND it1.info = 'countries'\n AND it2.info = 'rating'\n AND k.keyword IN ('murder',\n 'murder-in-title',\n 'blood',\n 'violence')\n AND kt.kind IN ('movie',\n 'episode')\n AND mc.note NOT LIKE '%(USA)%'\n AND mc.note LIKE '%(200%)%'\n AND mi.info IN ('Sweden',\n 'Norway',\n 'Germany',\n 'Denmark',\n 'Swedish',\n 'Danish',\n 'Norwegian',\n 'German',\n 'USA',\n 'American')\n AND mi_idx.info < '8.5'\n AND t.production_year > 2005\n AND kt.id = t.kind_id\n AND t.id = mi.movie_id\n AND t.id = mk.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = mc.movie_id\n AND t.id = cc.movie_id\n AND mk.movie_id = mi.movie_id\n AND mk.movie_id = mi_idx.movie_id\n AND mk.movie_id = mc.movie_id\n AND mk.movie_id = cc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi.movie_id = cc.movie_id\n AND mc.movie_id = mi_idx.movie_id\n AND mc.movie_id = cc.movie_id\n AND mi_idx.movie_id = cc.movie_id\n AND k.id = mk.keyword_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND ct.id = mc.company_type_id\n AND cn.id = mc.company_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 102 | /* 29a.sql */ "SELECT MIN(chn.name) AS voiced_char,\n MIN(n.name) AS voicing_actress,\n MIN(t.title) AS voiced_animation\nFROM aka_name AS an,\n complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n info_type AS it,\n info_type AS it3,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n name AS n,\n person_info AS pi,\n role_type AS rt,\n title AS t\nWHERE cct1.kind ='cast'\n AND cct2.kind ='complete+verified'\n AND chn.name = 'Queen'\n AND ci.note IN ('(voice)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND it.info = 'release dates'\n AND it3.info = 'trivia'\n AND k.keyword = 'computer-animation'\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'Japan:%200%'\n OR mi.info LIKE 'USA:%200%')\n AND n.gender ='f'\n AND n.name LIKE '%An%'\n AND rt.role ='actress'\n AND t.title = 'Shrek 2'\n AND t.production_year BETWEEN 2000 AND 2010\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND t.id = cc.movie_id\n AND mc.movie_id = ci.movie_id\n AND mc.movie_id = mi.movie_id\n AND mc.movie_id = mk.movie_id\n AND mc.movie_id = cc.movie_id\n AND mi.movie_id = ci.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi.movie_id = cc.movie_id\n AND ci.movie_id = mk.movie_id\n AND ci.movie_id = cc.movie_id\n AND mk.movie_id = cc.movie_id\n AND cn.id = mc.company_id\n AND it.id = mi.info_type_id\n AND n.id = ci.person_id\n AND rt.id = ci.role_id\n AND n.id = an.person_id\n AND ci.person_id = an.person_id\n AND chn.id = ci.person_role_id\n AND n.id = pi.person_id\n AND ci.person_id = pi.person_id\n AND it3.id = pi.info_type_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 103 | /* 29b.sql */ "SELECT MIN(chn.name) AS voiced_char,\n MIN(n.name) AS voicing_actress,\n MIN(t.title) AS voiced_animation\nFROM aka_name AS an,\n complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n info_type AS it,\n info_type AS it3,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n name AS n,\n person_info AS pi,\n role_type AS rt,\n title AS t\nWHERE cct1.kind ='cast'\n AND cct2.kind ='complete+verified'\n AND chn.name = 'Queen'\n AND ci.note IN ('(voice)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND it.info = 'release dates'\n AND it3.info = 'height'\n AND k.keyword = 'computer-animation'\n AND mi.info LIKE 'USA:%200%'\n AND n.gender ='f'\n AND n.name LIKE '%An%'\n AND rt.role ='actress'\n AND t.title = 'Shrek 2'\n AND t.production_year BETWEEN 2000 AND 2005\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND t.id = cc.movie_id\n AND mc.movie_id = ci.movie_id\n AND mc.movie_id = mi.movie_id\n AND mc.movie_id = mk.movie_id\n AND mc.movie_id = cc.movie_id\n AND mi.movie_id = ci.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi.movie_id = cc.movie_id\n AND ci.movie_id = mk.movie_id\n AND ci.movie_id = cc.movie_id\n AND mk.movie_id = cc.movie_id\n AND cn.id = mc.company_id\n AND it.id = mi.info_type_id\n AND n.id = ci.person_id\n AND rt.id = ci.role_id\n AND n.id = an.person_id\n AND ci.person_id = an.person_id\n AND chn.id = ci.person_role_id\n AND n.id = pi.person_id\n AND ci.person_id = pi.person_id\n AND it3.id = pi.info_type_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 104 | /* 29c.sql */ "SELECT MIN(chn.name) AS voiced_char,\n MIN(n.name) AS voicing_actress,\n MIN(t.title) AS voiced_animation\nFROM aka_name AS an,\n complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n char_name AS chn,\n cast_info AS ci,\n company_name AS cn,\n info_type AS it,\n info_type AS it3,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_keyword AS mk,\n name AS n,\n person_info AS pi,\n role_type AS rt,\n title AS t\nWHERE cct1.kind ='cast'\n AND cct2.kind ='complete+verified'\n AND ci.note IN ('(voice)',\n '(voice: Japanese version)',\n '(voice) (uncredited)',\n '(voice: English version)')\n AND cn.country_code ='[us]'\n AND it.info = 'release dates'\n AND it3.info = 'trivia'\n AND k.keyword = 'computer-animation'\n AND mi.info IS NOT NULL\n AND (mi.info LIKE 'Japan:%200%'\n OR mi.info LIKE 'USA:%200%')\n AND n.gender ='f'\n AND n.name LIKE '%An%'\n AND rt.role ='actress'\n AND t.production_year BETWEEN 2000 AND 2010\n AND t.id = mi.movie_id\n AND t.id = mc.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND t.id = cc.movie_id\n AND mc.movie_id = ci.movie_id\n AND mc.movie_id = mi.movie_id\n AND mc.movie_id = mk.movie_id\n AND mc.movie_id = cc.movie_id\n AND mi.movie_id = ci.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi.movie_id = cc.movie_id\n AND ci.movie_id = mk.movie_id\n AND ci.movie_id = cc.movie_id\n AND mk.movie_id = cc.movie_id\n AND cn.id = mc.company_id\n AND it.id = mi.info_type_id\n AND n.id = ci.person_id\n AND rt.id = ci.role_id\n AND n.id = an.person_id\n AND ci.person_id = an.person_id\n AND chn.id = ci.person_role_id\n AND n.id = pi.person_id\n AND ci.person_id = pi.person_id\n AND it3.id = pi.info_type_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 105 | /* 30a.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(n.name) AS writer,\n MIN(t.title) AS complete_violent_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n cast_info AS ci,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cct1.kind IN ('cast',\n 'crew')\n AND cct2.kind ='complete+verified'\n AND ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND k.keyword IN ('murder',\n 'violence',\n 'blood',\n 'gore',\n 'death',\n 'female-nudity',\n 'hospital')\n AND mi.info IN ('Horror',\n 'Thriller')\n AND n.gender = 'm'\n AND t.production_year > 2000\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND t.id = cc.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND ci.movie_id = mk.movie_id\n AND ci.movie_id = cc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi.movie_id = cc.movie_id\n AND mi_idx.movie_id = mk.movie_id\n AND mi_idx.movie_id = cc.movie_id\n AND mk.movie_id = cc.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 106 | /* 30b.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(n.name) AS writer,\n MIN(t.title) AS complete_gore_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n cast_info AS ci,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cct1.kind IN ('cast',\n 'crew')\n AND cct2.kind ='complete+verified'\n AND ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND k.keyword IN ('murder',\n 'violence',\n 'blood',\n 'gore',\n 'death',\n 'female-nudity',\n 'hospital')\n AND mi.info IN ('Horror',\n 'Thriller')\n AND n.gender = 'm'\n AND t.production_year > 2000\n AND (t.title LIKE '%Freddy%'\n OR t.title LIKE '%Jason%'\n OR t.title LIKE 'Saw%')\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND t.id = cc.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND ci.movie_id = mk.movie_id\n AND ci.movie_id = cc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi.movie_id = cc.movie_id\n AND mi_idx.movie_id = mk.movie_id\n AND mi_idx.movie_id = cc.movie_id\n AND mk.movie_id = cc.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 107 | /* 30c.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(n.name) AS writer,\n MIN(t.title) AS complete_violent_movie\nFROM complete_cast AS cc,\n comp_cast_type AS cct1,\n comp_cast_type AS cct2,\n cast_info AS ci,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE cct1.kind = 'cast'\n AND cct2.kind ='complete+verified'\n AND ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND k.keyword IN ('murder',\n 'violence',\n 'blood',\n 'gore',\n 'death',\n 'female-nudity',\n 'hospital')\n AND mi.info IN ('Horror',\n 'Action',\n 'Sci-Fi',\n 'Thriller',\n 'Crime',\n 'War')\n AND n.gender = 'm'\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND t.id = cc.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND ci.movie_id = mk.movie_id\n AND ci.movie_id = cc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi.movie_id = cc.movie_id\n AND mi_idx.movie_id = mk.movie_id\n AND mi_idx.movie_id = cc.movie_id\n AND mk.movie_id = cc.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND k.id = mk.keyword_id\n AND cct1.id = cc.subject_id\n AND cct2.id = cc.status_id;\n\n", |
| 108 | /* 31a.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(n.name) AS writer,\n MIN(t.title) AS violent_liongate_movie\nFROM cast_info AS ci,\n company_name AS cn,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND cn.name LIKE 'Lionsgate%'\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND k.keyword IN ('murder',\n 'violence',\n 'blood',\n 'gore',\n 'death',\n 'female-nudity',\n 'hospital')\n AND mi.info IN ('Horror',\n 'Thriller')\n AND n.gender = 'm'\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND ci.movie_id = mk.movie_id\n AND ci.movie_id = mc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi_idx.movie_id = mk.movie_id\n AND mi_idx.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND k.id = mk.keyword_id\n AND cn.id = mc.company_id;\n\n", |
| 109 | /* 31b.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(n.name) AS writer,\n MIN(t.title) AS violent_liongate_movie\nFROM cast_info AS ci,\n company_name AS cn,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND cn.name LIKE 'Lionsgate%'\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND k.keyword IN ('murder',\n 'violence',\n 'blood',\n 'gore',\n 'death',\n 'female-nudity',\n 'hospital')\n AND mc.note LIKE '%(Blu-ray)%'\n AND mi.info IN ('Horror',\n 'Thriller')\n AND n.gender = 'm'\n AND t.production_year > 2000\n AND (t.title LIKE '%Freddy%'\n OR t.title LIKE '%Jason%'\n OR t.title LIKE 'Saw%')\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND ci.movie_id = mk.movie_id\n AND ci.movie_id = mc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi_idx.movie_id = mk.movie_id\n AND mi_idx.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND k.id = mk.keyword_id\n AND cn.id = mc.company_id;\n\n", |
| 110 | /* 31c.sql */ "SELECT MIN(mi.info) AS movie_budget,\n MIN(mi_idx.info) AS movie_votes,\n MIN(n.name) AS writer,\n MIN(t.title) AS violent_liongate_movie\nFROM cast_info AS ci,\n company_name AS cn,\n info_type AS it1,\n info_type AS it2,\n keyword AS k,\n movie_companies AS mc,\n movie_info AS mi,\n movie_info_idx AS mi_idx,\n movie_keyword AS mk,\n name AS n,\n title AS t\nWHERE ci.note IN ('(writer)',\n '(head writer)',\n '(written by)',\n '(story)',\n '(story editor)')\n AND cn.name LIKE 'Lionsgate%'\n AND it1.info = 'genres'\n AND it2.info = 'votes'\n AND k.keyword IN ('murder',\n 'violence',\n 'blood',\n 'gore',\n 'death',\n 'female-nudity',\n 'hospital')\n AND mi.info IN ('Horror',\n 'Action',\n 'Sci-Fi',\n 'Thriller',\n 'Crime',\n 'War')\n AND t.id = mi.movie_id\n AND t.id = mi_idx.movie_id\n AND t.id = ci.movie_id\n AND t.id = mk.movie_id\n AND t.id = mc.movie_id\n AND ci.movie_id = mi.movie_id\n AND ci.movie_id = mi_idx.movie_id\n AND ci.movie_id = mk.movie_id\n AND ci.movie_id = mc.movie_id\n AND mi.movie_id = mi_idx.movie_id\n AND mi.movie_id = mk.movie_id\n AND mi.movie_id = mc.movie_id\n AND mi_idx.movie_id = mk.movie_id\n AND mi_idx.movie_id = mc.movie_id\n AND mk.movie_id = mc.movie_id\n AND n.id = ci.person_id\n AND it1.id = mi.info_type_id\n AND it2.id = mi_idx.info_type_id\n AND k.id = mk.keyword_id\n AND cn.id = mc.company_id;\n\n", |
| 111 | /* 32a.sql */ "SELECT MIN(lt.link) AS link_type,\n MIN(t1.title) AS first_movie,\n MIN(t2.title) AS second_movie\nFROM keyword AS k,\n link_type AS lt,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t1,\n title AS t2\nWHERE k.keyword ='10,000-mile-club'\n AND mk.keyword_id = k.id\n AND t1.id = mk.movie_id\n AND ml.movie_id = t1.id\n AND ml.linked_movie_id = t2.id\n AND lt.id = ml.link_type_id\n AND mk.movie_id = t1.id;\n\n", |
| 112 | /* 32b.sql */ "SELECT MIN(lt.link) AS link_type,\n MIN(t1.title) AS first_movie,\n MIN(t2.title) AS second_movie\nFROM keyword AS k,\n link_type AS lt,\n movie_keyword AS mk,\n movie_link AS ml,\n title AS t1,\n title AS t2\nWHERE k.keyword ='character-name-in-title'\n AND mk.keyword_id = k.id\n AND t1.id = mk.movie_id\n AND ml.movie_id = t1.id\n AND ml.linked_movie_id = t2.id\n AND lt.id = ml.link_type_id\n AND mk.movie_id = t1.id;\n\n", |
| 113 | /* 33a.sql */ "SELECT MIN(cn1.name) AS first_company,\n MIN(cn2.name) AS second_company,\n MIN(mi_idx1.info) AS first_rating,\n MIN(mi_idx2.info) AS second_rating,\n MIN(t1.title) AS first_movie,\n MIN(t2.title) AS second_movie\nFROM company_name AS cn1,\n company_name AS cn2,\n info_type AS it1,\n info_type AS it2,\n kind_type AS kt1,\n kind_type AS kt2,\n link_type AS lt,\n movie_companies AS mc1,\n movie_companies AS mc2,\n movie_info_idx AS mi_idx1,\n movie_info_idx AS mi_idx2,\n movie_link AS ml,\n title AS t1,\n title AS t2\nWHERE cn1.country_code = '[us]'\n AND it1.info = 'rating'\n AND it2.info = 'rating'\n AND kt1.kind IN ('tv series')\n AND kt2.kind IN ('tv series')\n AND lt.link IN ('sequel',\n 'follows',\n 'followed by')\n AND mi_idx2.info < '3.0'\n AND t2.production_year BETWEEN 2005 AND 2008\n AND lt.id = ml.link_type_id\n AND t1.id = ml.movie_id\n AND t2.id = ml.linked_movie_id\n AND it1.id = mi_idx1.info_type_id\n AND t1.id = mi_idx1.movie_id\n AND kt1.id = t1.kind_id\n AND cn1.id = mc1.company_id\n AND t1.id = mc1.movie_id\n AND ml.movie_id = mi_idx1.movie_id\n AND ml.movie_id = mc1.movie_id\n AND mi_idx1.movie_id = mc1.movie_id\n AND it2.id = mi_idx2.info_type_id\n AND t2.id = mi_idx2.movie_id\n AND kt2.id = t2.kind_id\n AND cn2.id = mc2.company_id\n AND t2.id = mc2.movie_id\n AND ml.linked_movie_id = mi_idx2.movie_id\n AND ml.linked_movie_id = mc2.movie_id\n AND mi_idx2.movie_id = mc2.movie_id;\n\n", |
| 114 | /* 33b.sql */ "SELECT MIN(cn1.name) AS first_company,\n MIN(cn2.name) AS second_company,\n MIN(mi_idx1.info) AS first_rating,\n MIN(mi_idx2.info) AS second_rating,\n MIN(t1.title) AS first_movie,\n MIN(t2.title) AS second_movie\nFROM company_name AS cn1,\n company_name AS cn2,\n info_type AS it1,\n info_type AS it2,\n kind_type AS kt1,\n kind_type AS kt2,\n link_type AS lt,\n movie_companies AS mc1,\n movie_companies AS mc2,\n movie_info_idx AS mi_idx1,\n movie_info_idx AS mi_idx2,\n movie_link AS ml,\n title AS t1,\n title AS t2\nWHERE cn1.country_code = '[nl]'\n AND it1.info = 'rating'\n AND it2.info = 'rating'\n AND kt1.kind IN ('tv series')\n AND kt2.kind IN ('tv series')\n AND lt.link LIKE '%follow%'\n AND mi_idx2.info < '3.0'\n AND t2.production_year = 2007\n AND lt.id = ml.link_type_id\n AND t1.id = ml.movie_id\n AND t2.id = ml.linked_movie_id\n AND it1.id = mi_idx1.info_type_id\n AND t1.id = mi_idx1.movie_id\n AND kt1.id = t1.kind_id\n AND cn1.id = mc1.company_id\n AND t1.id = mc1.movie_id\n AND ml.movie_id = mi_idx1.movie_id\n AND ml.movie_id = mc1.movie_id\n AND mi_idx1.movie_id = mc1.movie_id\n AND it2.id = mi_idx2.info_type_id\n AND t2.id = mi_idx2.movie_id\n AND kt2.id = t2.kind_id\n AND cn2.id = mc2.company_id\n AND t2.id = mc2.movie_id\n AND ml.linked_movie_id = mi_idx2.movie_id\n AND ml.linked_movie_id = mc2.movie_id\n AND mi_idx2.movie_id = mc2.movie_id;\n\n", |
| 115 | /* 33c.sql */ "SELECT MIN(cn1.name) AS first_company,\n MIN(cn2.name) AS second_company,\n MIN(mi_idx1.info) AS first_rating,\n MIN(mi_idx2.info) AS second_rating,\n MIN(t1.title) AS first_movie,\n MIN(t2.title) AS second_movie\nFROM company_name AS cn1,\n company_name AS cn2,\n info_type AS it1,\n info_type AS it2,\n kind_type AS kt1,\n kind_type AS kt2,\n link_type AS lt,\n movie_companies AS mc1,\n movie_companies AS mc2,\n movie_info_idx AS mi_idx1,\n movie_info_idx AS mi_idx2,\n movie_link AS ml,\n title AS t1,\n title AS t2\nWHERE cn1.country_code != '[us]'\n AND it1.info = 'rating'\n AND it2.info = 'rating'\n AND kt1.kind IN ('tv series',\n 'episode')\n AND kt2.kind IN ('tv series',\n 'episode')\n AND lt.link IN ('sequel',\n 'follows',\n 'followed by')\n AND mi_idx2.info < '3.5'\n AND t2.production_year BETWEEN 2000 AND 2010\n AND lt.id = ml.link_type_id\n AND t1.id = ml.movie_id\n AND t2.id = ml.linked_movie_id\n AND it1.id = mi_idx1.info_type_id\n AND t1.id = mi_idx1.movie_id\n AND kt1.id = t1.kind_id\n AND cn1.id = mc1.company_id\n AND t1.id = mc1.movie_id\n AND ml.movie_id = mi_idx1.movie_id\n AND ml.movie_id = mc1.movie_id\n AND mi_idx1.movie_id = mc1.movie_id\n AND it2.id = mi_idx2.info_type_id\n AND t2.id = mi_idx2.movie_id\n AND kt2.id = t2.kind_id\n AND cn2.id = mc2.company_id\n AND t2.id = mc2.movie_id\n AND ml.linked_movie_id = mi_idx2.movie_id\n AND ml.linked_movie_id = mc2.movie_id\n AND mi_idx2.movie_id = mc2.movie_id;\n\n", |
| 116 | /* Moerkotte Special */ "select '(29a.sql (joincard (relset cc ci mc)', sum(cc.cnt * ci.cnt * mc.cnt), '))'\nfrom\n (select movie_id, count(*) as cnt from complete_cast group by movie_id) as cc,\n (select movie_id, count(*) as cnt from cast_info group by movie_id) as ci,\n (select movie_id, count(*) as cnt from movie_companies group by movie_id) as mc\nwhere mc.movie_id = ci.movie_id and\n mc.movie_id = cc.movie_id and\n ci.movie_id = cc.movie_id;\n" |
| 117 | }; |
| 118 | |
| 119 | |
| 120 | |
| 121 | const int IMDB_TABLE_COUNT = 21; |
| 122 | |
| 123 | const char *IMDB_TABLE_NAMES[] = { |
| 124 | "aka_name", "aka_title", "cast_info", "char_name", "comp_cast_type", "company_name", "company_type", "complete_cast", "info_type", "keyword", "kind_type", "link_type", "movie_companies", "movie_info", "movie_info_idx", "movie_keyword", "movie_link", "name", "person_info", "role_type", "title" |
| 125 | }; |
| 126 | |
| 127 | const char *IMDB_TABLE_DDL[] = { |
| 128 | "CREATE TABLE aka_name ( id integer NOT NULL PRIMARY KEY, person_id integer NOT NULL, name text NOT NULL, imdb_index character varying(12), name_pcode_cf character varying(5), name_pcode_nf character varying(5), surname_pcode character varying(5), md5sum character varying(32) );", |
| 129 | "CREATE TABLE aka_title ( id integer NOT NULL PRIMARY KEY, movie_id integer NOT NULL, title text NOT NULL, imdb_index character varying(12), kind_id integer NOT NULL, production_year integer, phonetic_code character varying(5), episode_of_id integer, season_nr integer, episode_nr integer, note text, md5sum character varying(32) );", |
| 130 | "CREATE TABLE cast_info ( id integer NOT NULL PRIMARY KEY, person_id integer NOT NULL, movie_id integer NOT NULL, person_role_id integer, note text, nr_order integer, role_id integer NOT NULL );", |
| 131 | "CREATE TABLE char_name ( id integer NOT NULL PRIMARY KEY, name text NOT NULL, imdb_index character varying(12), imdb_id integer, name_pcode_nf character varying(5), surname_pcode character varying(5), md5sum character varying(32) );", |
| 132 | "CREATE TABLE comp_cast_type ( id integer NOT NULL PRIMARY KEY, kind character varying(32) NOT NULL );", |
| 133 | "CREATE TABLE company_name ( id integer NOT NULL PRIMARY KEY, name text NOT NULL, country_code character varying(255), imdb_id integer, name_pcode_nf character varying(5), name_pcode_sf character varying(5), md5sum character varying(32) );", |
| 134 | "CREATE TABLE company_type ( id integer NOT NULL PRIMARY KEY, kind character varying(32) NOT NULL );", |
| 135 | "CREATE TABLE complete_cast ( id integer NOT NULL PRIMARY KEY, movie_id integer, subject_id integer NOT NULL, status_id integer NOT NULL );", |
| 136 | "CREATE TABLE info_type ( id integer NOT NULL PRIMARY KEY, info character varying(32) NOT NULL );", |
| 137 | "CREATE TABLE keyword ( id integer NOT NULL PRIMARY KEY, keyword text NOT NULL, phonetic_code character varying(5) );", |
| 138 | "CREATE TABLE kind_type ( id integer NOT NULL PRIMARY KEY, kind character varying(15) NOT NULL );", |
| 139 | "CREATE TABLE link_type ( id integer NOT NULL PRIMARY KEY, link character varying(32) NOT NULL );", |
| 140 | "CREATE TABLE movie_companies ( id integer NOT NULL PRIMARY KEY, movie_id integer NOT NULL, company_id integer NOT NULL, company_type_id integer NOT NULL, note text );", |
| 141 | "CREATE TABLE movie_info ( id integer NOT NULL PRIMARY KEY, movie_id integer NOT NULL, info_type_id integer NOT NULL, info text NOT NULL, note text );", |
| 142 | "CREATE TABLE movie_info_idx ( id integer NOT NULL PRIMARY KEY, movie_id integer NOT NULL, info_type_id integer NOT NULL, info text NOT NULL, note text );", |
| 143 | "CREATE TABLE movie_keyword ( id integer NOT NULL PRIMARY KEY, movie_id integer NOT NULL, keyword_id integer NOT NULL );", |
| 144 | "CREATE TABLE movie_link ( id integer NOT NULL PRIMARY KEY, movie_id integer NOT NULL, linked_movie_id integer NOT NULL, link_type_id integer NOT NULL );", |
| 145 | "CREATE TABLE name ( id integer NOT NULL PRIMARY KEY, name text NOT NULL, imdb_index character varying(12), imdb_id integer, gender character varying(1), name_pcode_cf character varying(5), name_pcode_nf character varying(5), surname_pcode character varying(5), md5sum character varying(32) );", |
| 146 | "CREATE TABLE person_info ( id integer NOT NULL PRIMARY KEY, person_id integer NOT NULL, info_type_id integer NOT NULL, info text NOT NULL, note text );", |
| 147 | "CREATE TABLE role_type ( id integer NOT NULL PRIMARY KEY, role character varying(32) NOT NULL );", |
| 148 | "CREATE TABLE title ( id integer NOT NULL PRIMARY KEY, title text NOT NULL, imdb_index character varying(12), kind_id integer NOT NULL, production_year integer, imdb_id integer, phonetic_code character varying(5), episode_of_id integer, season_nr integer, episode_nr integer, series_years character varying(49), md5sum character varying(32) );" |
| 149 | }; |
| 150 |
Generated while processing DuckDB/third_party/imdb/imdb.cpp
Generated on 2020-Jun-02 from project DuckDB revision 2020
Powered by 
Code Browser 2.1
Generator usage only permitted with license.