Planner — IMDB — JOB-29B

SELECT MIN(chn.name) AS voiced_char,
       MIN(n.name) AS voicing_actress,
       MIN(t.title) AS voiced_animation
FROM job.aka_name AS an,
     job.complete_cast AS cc,
     job.comp_cast_type AS cct1,
     job.comp_cast_type AS cct2,
     job.char_name AS chn,
     job.cast_info AS ci,
     job.company_name AS cn,
     job.info_type AS it,
     job.info_type AS it3,
     job.keyword AS k,
     job.movie_companies AS mc,
     job.movie_info AS mi,
     job.movie_keyword AS mk,
     job.name AS n,
     job.person_info AS pi,
     job.role_type AS rt,
     job.title AS t
WHERE cct1.kind ='cast'
  AND cct2.kind ='complete+verified'
  AND chn.name = 'Queen'
  AND ci.note IN ('(voice)',
                  '(voice) (uncredited)',
                  '(voice: English version)')
  AND cn.country_code ='[us]'
  AND it.info = 'release dates'
  AND it3.info = 'height'
  AND k.keyword = 'computer-animation'
  AND mi.info LIKE 'USA:%200%'
  AND n.gender ='f'
  AND n.name LIKE '%An%'
  AND rt.role ='actress'
  AND t.title = 'Shrek 2'
  AND t.production_year BETWEEN 2000 AND 2005
  AND t.id = mi.movie_id
  AND t.id = mc.movie_id
  AND t.id = ci.movie_id
  AND t.id = mk.movie_id
  AND t.id = cc.movie_id
  AND mc.movie_id = ci.movie_id
  AND mc.movie_id = mi.movie_id
  AND mc.movie_id = mk.movie_id
  AND mc.movie_id = cc.movie_id
  AND mi.movie_id = ci.movie_id
  AND mi.movie_id = mk.movie_id
  AND mi.movie_id = cc.movie_id
  AND ci.movie_id = mk.movie_id
  AND ci.movie_id = cc.movie_id
  AND mk.movie_id = cc.movie_id
  AND cn.id = mc.company_id
  AND it.id = mi.info_type_id
  AND n.id = ci.person_id
  AND rt.id = ci.role_id
  AND n.id = an.person_id
  AND ci.person_id = an.person_id
  AND chn.id = ci.person_role_id
  AND n.id = pi.person_id
  AND ci.person_id = pi.person_id
  AND it3.id = pi.info_type_id
  AND k.id = mk.keyword_id
  AND cct1.id = cc.subject_id
  AND cct2.id = cc.status_id;

Engine Compare

Accuracy chart, rows processed ?
Scan Scan	Seek Seek	Join Probe Join	Sort Sort	Hash Build Hash	Aggregate Agg	Distribute Dist
Estimation Error Est Err 10,998,084 11M Rank		Estimation Error Est Err 10,998,919 11M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 980 980 Rank	Estimation Error Est Err 15 15 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 47,815,199 48M Rank		Estimation Error Est Err 44,596,034 45M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 3,795,430 3.8M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 9,767,279 9.8M Rank		Estimation Error Est Err 10,735,733 11M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,054,690 1.1M Rank	Estimation Error Est Err 17 17 Rank	Estimation Error Est Err 85,667 86K Rank
Estimation Error Est Err 23,169,616 23M Rank		Estimation Error Est Err 9,021,279 9M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,072,568 1.1M Rank	Estimation Error Est Err 25 25 Rank	Estimation Error Est Err 1,947,284 1.9M Rank
Estimation Error Est Err 594 594 Rank		Estimation Error Est Err 3,329 3.3K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 6,445 6.4K Rank	Estimation Error Est Err 15 15 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 22,873 23K Rank	Estimation Error Est Err 22,873 23K Rank	Estimation Error Est Err 22,872 23K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 22,872 23K Rank	Estimation Error Est Err 15 15 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 4,680 4.7K Rank	Estimation Error Est Err 4,678 4.7K Rank	Estimation Error Est Err 7,395 7.4K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 4,693 4.7K Rank	Estimation Error Est Err 15 15 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 232,539 233K Rank		Estimation Error Est Err 180 180 Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 232,653 233K Rank	Estimation Error Est Err 31 31 Rank	Estimation Error Est Err 232,554 233K Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min, min 1 15 INNER JOIN HASH ON id = info_type_id 1 1 │└TABLE SCAN info_type WHERE info = release dates 1 15 INNER JOIN HASH ON id127 = company_id 1 66 │└INNER JOIN HASH ON movie_id120 = movie_id74 1 3 │ │└INNER JOIN HASH ON id6 = keyword_id 1 1 │ │ │└TABLE SCAN keyword WHERE keyword = computer - animation 19 324 │ │ INNER JOIN HASH ON movie_id74 = movie_id114 1 3 │ │ │└INNER JOIN HASH ON id12 = subject_id 1 1 │ │ │ │└TABLE SCAN comp_cast_type WHERE kind = cast 1 3 │ │ │ INNER JOIN HASH ON id17 = info_type_id107 1 1 │ │ │ │└TABLE SCAN info_type WHERE info = height 3 489 │ │ │ INNER JOIN HASH ON person_id106 = person_id95 1 3 │ │ │ │└INNER JOIN HASH ON id82 = person_id95 1 1 │ │ │ │ │└INNER JOIN HASH ON id22 = role_id 1 1 │ │ │ │ │ │└TABLE SCAN role_type WHERE role = actress 1 1 │ │ │ │ │ INNER JOIN HASH ON id82 = person_id 1 1 │ │ │ │ │ │└INNER JOIN HASH ON id27 = person_role_id 1 1 │ │ │ │ │ │ │└TABLE SCAN char_name WHERE name = Queen 1 1 │ │ │ │ │ │ INNER JOIN HASH ON movie_id65 = movie_id74 1 1 │ │ │ │ │ │ │└INNER JOIN HASH ON movie_id65 = movie_id 1 1 │ │ │ │ │ │ │ │└INNER JOIN HASH ON id37 = status_id 1 1 │ │ │ │ │ │ │ │ │└TABLE SCAN comp_cast_type WHERE kind = complete + verified 1 1 │ │ │ │ │ │ │ │ INNER JOIN HASH ON id42 = movie_id 1 2 │ │ │ │ │ │ │ │ │└TABLE SCAN title WHERE production_year BETWEEN 2000 AND 2005 AND title = Shrek 2 89517 1 │ │ │ │ │ │ │ │ TABLE SCAN complete_cast 318736 1 │ │ │ │ │ │ │ TABLE SCAN movie_info WHERE info) USA : AND info67 LIKE '%200%' 390989 1 │ │ │ │ │ │ TABLE SCAN cast_info WHERE note76 IN(voice,voice uncredited,(voice : English version)) 61047 1 │ │ │ │ │ TABLE SCAN name WHERE gender = f AND name83 LIKE '%An%' 901343 901343 │ │ │ │ TABLE SCAN aka_name 2963664 2963664 │ │ │ TABLE SCAN person_info 4523930 4523930 │ │ TABLE SCAN movie_keyword 2609129 2609129 │ TABLE SCAN movie_companies 90648 5 TABLE SCAN company_name WHERE country_code = us
	Estimate Actual Operator - 1 PROJECT a1 AS voiced_char, a2 AS voicing_actress, a3 AS voiced_animation - 1 AGGREGATE MIN(name_left) AS a1, MIN(name_right) AS a2, MIN(title) AS a3 - 0 PROJECT name, name, title - 0 PROJECT name, name, title - 0 INNER JOIN HASH ON tuple(PROJECTION_3868.person_id,PROJECTION_3868.person_id,PROJECTION_3868.person_id) = tuple(PROJECTION_3853.id,PROJECTION_3853.id,PROJECTION_3853.person_id) - 2448 │└PROJECT id, person_id AS person_id_right, name AS name_right - 2448 │ PROJECT name, id, person_id - 2448 │ INNER JOIN HASH ON PROJECTION_3859.info_type_id = PROJECTION_3856.id - 1 │ │└PROJECT id AS id_right - 1 │ │ PROJECT id - 1 │ │ TABLE SCAN info_type WHERE info = 'height' - 46248 │ PROJECT info_type_id, name, id AS id_left, person_id - 46248 │ PROJECT name, id, person_id, info_type_id - 46248 │ INNER JOIN HASH ON PROJECTION_3865.id = PROJECTION_3862.person_id - 2963664 │ │└PROJECT person_id, info_type_id - 2963664 │ │ PROJECT person_id, info_type_id - 2963664 │ │ TABLE SCAN person_info - 50011 │ PROJECT id, name - 50011 │ PROJECT id, name - 50011 │ TABLE SCAN name WHERE (gender = 'f') AND name LIKE '%An%' - 0 PROJECT person_id_left, person_id_right AS person_id_left_2, name AS name_left, title - 0 PROJECT person_id_left, person_id_right, name, title - 0 INNER JOIN HASH ON tuple(PROJECTION_3886.movie_id,PROJECTION_3886.movie_id,PROJECTION_3886.movie_id,PROJECTION_3886.movie_id,PROJECTION_3886.movie_id,PROJECTION_3886.movie_id,PROJECTION_3886.movie_id,PROJECTION_3886.movie_id) = tuple(PROJECTION_3871.movie_id,PROJECTION_3871.movie_id,PROJECTION_3871.movie_id,PROJECTION_3871.movie_id,PROJECTION_3871.id,PROJECTION_3871.id,PROJECTION_3871.id,PROJECTION_3871.id) - 1 │└PROJECT movie_id AS movie_id_right, id, title - 1 │ PROJECT movie_id, title, id - 1 │ INNER JOIN HASH ON PROJECTION_3883.id = PROJECTION_3874.movie_id - 414 │ │└PROJECT movie_id - 414 │ │ PROJECT movie_id - 414 │ │ INNER JOIN HASH ON PROJECTION_3880.keyword_id = PROJECTION_3877.id - 1 │ │ │└PROJECT id - 1 │ │ │ PROJECT id - 1 │ │ │ TABLE SCAN keyword WHERE keyword = 'computer-animation' - 4523930 │ │ PROJECT keyword_id, movie_id - 4523930 │ │ PROJECT movie_id, keyword_id - 4523930 │ │ TABLE SCAN movie_keyword - 2 │ PROJECT id, title - 2 │ PROJECT id, title - 2 │ TABLE SCAN title WHERE (production_year >= 2000) AND (production_year <= 2005) AND (title = 'Shrek 2') - 0 PROJECT movie_id_left, movie_id_left_2, movie_id_left_3, movie_id AS movie_id_left_4, person_id, person_id, name - 0 PROJECT person_id, person_id, movie_id, movie_id, name, movie_id, movie_id - 0 INNER JOIN HASH ON PROJECTION_3892.role_id = PROJECTION_3889.id - 1 │└PROJECT id - 1 │ PROJECT id - 1 │ TABLE SCAN role_type WHERE role = 'actress' - 0 PROJECT role_id, person_id, person_id, movie_id, movie_id, name, movie_id, movie_id - 0 PROJECT person_id, person_id, movie_id, role_id, movie_id, name, movie_id, movie_id - 0 INNER JOIN HASH ON PROJECTION_3898.info_type_id = PROJECTION_3895.id - 1 │└PROJECT id - 1 │ PROJECT id - 1 │ TABLE SCAN info_type WHERE info = 'release dates' - 0 PROJECT info_type_id, person_id, person_id, movie_id, role_id, movie_id, name, movie_id, movie_id - 0 PROJECT person_id, person_id, movie_id, role_id, movie_id, name, movie_id, movie_id, info_type_id - 0 INNER JOIN HASH ON tuple(PROJECTION_3904.movie_id,PROJECTION_3904.movie_id,PROJECTION_3904.movie_id) = tuple(PROJECTION_3901.movie_id,PROJECTION_3901.movie_id,PROJECTION_3901.movie_id) - 387683 │└PROJECT movie_id AS movie_id_right, info_type_id - 387683 │ PROJECT movie_id, info_type_id - 387683 │ TABLE SCAN movie_info WHERE info LIKE 'USA:%200%' - 0 PROJECT movie_id AS movie_id_left, movie_id AS movie_id_left_2, movie_id AS movie_id_left_3, person_id, person_id, role_id, name - 0 PROJECT person_id, person_id, movie_id, role_id, movie_id, name, movie_id - 0 INNER JOIN HASH ON tuple(PROJECTION_3922.movie_id,PROJECTION_3922.movie_id) = tuple(PROJECTION_3907.movie_id,PROJECTION_3907.movie_id) - 498 │└PROJECT movie_id AS movie_id_right, person_id, person_id, role_id, name - 498 │ PROJECT person_id, person_id, movie_id, role_id, name - 498 │ INNER JOIN HASH ON PROJECTION_3919.person_id = PROJECTION_3910.person_id - 513 │ │└PROJECT person_id AS person_id_right, movie_id, role_id, name - 513 │ │ PROJECT person_id, movie_id, role_id, name - 513 │ │ INNER JOIN HASH ON PROJECTION_3916.person_role_id = PROJECTION_3913.id - 1 │ │ │└PROJECT id, name - 1 │ │ │ PROJECT id, name - 1 │ │ │ TABLE SCAN char_name WHERE name = 'Queen' - 36244344 │ │ PROJECT person_role_id, person_id, movie_id, role_id - 36244344 │ │ PROJECT person_id, movie_id, person_role_id, role_id - 36244344 │ │ TABLE SCAN cast_info WHERE TRUE - 901343 │ PROJECT person_id AS person_id_left - 901343 │ PROJECT person_id - 901343 │ TABLE SCAN aka_name - 0 PROJECT movie_id AS movie_id_left, movie_id AS movie_id_left_2 - 0 PROJECT movie_id, movie_id - 0 INNER JOIN HASH ON PROJECTION_3946.id = PROJECTION_3925.company_id - 166506 │└PROJECT company_id, movie_id, movie_id - 166506 │ PROJECT movie_id, movie_id, company_id - 166506 │ INNER JOIN HASH ON PROJECTION_3943.movie_id = PROJECTION_3928.movie_id - 17879 │ │└PROJECT movie_id AS movie_id_right - 17879 │ │ PROJECT movie_id - 17879 │ │ INNER JOIN HASH ON PROJECTION_3934.status_id = PROJECTION_3931.id - 1 │ │ │└PROJECT id - 1 │ │ │ PROJECT id - 1 │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'complete+verified' - 85941 │ │ PROJECT status_id, movie_id - 85941 │ │ PROJECT movie_id, status_id - 85941 │ │ INNER JOIN HASH ON PROJECTION_3940.subject_id = PROJECTION_3937.id - 1 │ │ │└PROJECT id - 1 │ │ │ PROJECT id - 1 │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' - 135086 │ │ PROJECT subject_id, movie_id, status_id - 135086 │ │ PROJECT movie_id, subject_id, status_id - 135086 │ │ TABLE SCAN complete_cast - 2609129 │ PROJECT movie_id AS movie_id_left, company_id - 2609129 │ PROJECT movie_id, company_id - 2609129 │ TABLE SCAN movie_companies - 0 PROJECT id - 0 PROJECT id - 0 TABLE SCAN company_name WHERE country_code = 'us'
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1), MIN(#2) 0 15 PROJECT name, name, title 0 15 INNER JOIN HASH ON id = role_id 0 15 │└INNER JOIN HASH ON id = info_type_id 0 2445 │ │└INNER JOIN HASH ON person_id = id 0 15 │ │ │└INNER JOIN HASH ON id = person_id 0 15 │ │ │ │└INNER JOIN HASH ON person_id = person_id 0 5 │ │ │ │ │└INNER JOIN HASH ON id = person_role_id 0 190 │ │ │ │ │ │└INNER JOIN HASH ON movie_id = id 0 5 │ │ │ │ │ │ │└INNER JOIN HASH ON id = keyword_id 0 540 │ │ │ │ │ │ │ │└INNER JOIN HASH ON movie_id = id 0 5 │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = company_id 0 22 │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON movie_id = id 0 1 │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = status_id 0 1 │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = subject_id 0 1 │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = info_type_id 0 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = id 0 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN HASH ON id = id 3 2 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │└FILTER id BETWEEN 285 AND 2525745 3 2 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN title WHERE title = 'Shrek 2' AND production_year >= 2000 AND production_year <= 2005 135086 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ FILTER id <= 2525745 135086 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN complete_cast WHERE movie_id <= 2526430 593428 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ FILTER id BETWEEN 285 AND 2525745 593428 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ FILTER info LIKE 'USA:%200%' 2967144 2 │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN movie_info WHERE info >= 'USA:' AND info < 'USA;' 2 1 │ │ │ │ │ │ │ │ │ │ │ │ │ FILTER id <= 110 2 1 │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 1 1 │ │ │ │ │ │ │ │ │ │ │ │ FILTER id <= 2 1 1 │ │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' 1 1 │ │ │ │ │ │ │ │ │ │ │ FILTER id >= 3 1 1 │ │ │ │ │ │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'complete+verified' 2609129 22 │ │ │ │ │ │ │ │ │ │ TABLE SCAN movie_companies WHERE movie_id >= 285 1644 57 │ │ │ │ │ │ │ │ │ TABLE SCAN company_name WHERE country_code = 'us' 4523930 108 │ │ │ │ │ │ │ │ TABLE SCAN movie_keyword WHERE movie_id >= 285 AND movie_id <= 2525745 2 1 │ │ │ │ │ │ │ TABLE SCAN keyword WHERE keyword = 'computer-animation' 7248868 38 │ │ │ │ │ │ FILTER (person_id >= 4) AND (movie_id BETWEEN 285 AND 2525745) 7248868 38 │ │ │ │ │ │ FILTER (note = '(voice)') OR (note = '(voice) (uncredited)') OR (note = '(voice: English version)') 36244344 228 │ │ │ │ │ │ TABLE SCAN cast_info WHERE note IN('(voice)','(voice) (uncredited)','(voice: English version)') 1 1 │ │ │ │ │ TABLE SCAN char_name WHERE name = 'Queen' 901343 3 │ │ │ │ TABLE SCAN aka_name WHERE person_id <= 4061926 2083746 1 │ │ │ FILTER id BETWEEN 4 AND 4061926 2083746 1 │ │ │ TABLE SCAN "name" WHERE gender = 'f' AND contains(name,'An') 2963664 163 │ │ TABLE SCAN person_info WHERE person_id <= 4061926 2 1 │ FILTER id BETWEEN 15 AND 39 2 1 │ TABLE SCAN info_type WHERE info = 'height' 1 1 FILTER id <= 11 1 1 TABLE SCAN role_type WHERE role = 'actress'
	Estimate Actual Operator 1 1 PROJECT voiced_char, voicing_actress, voiced_animation 1 1 AGGREGATE MIN(name), MIN(name), MIN(title) 3849 10 DISTRIBUTE GATHER 3849 10 AGGREGATE MIN(name), MIN(name), MIN(title) 3849 15 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id 3849 15 │└DISTRIBUTE GATHER 3849 15 │ INNER JOIN HASH ON id = role_id 3 1 │ │└DISTRIBUTE GATHER 3 1 │ │ FILTER role = 'actress' 12 12 │ │ DISTRIBUTE ROUND ROBIN 12 12 │ │ TABLE SCAN role_type WHERE role = 'actress' 14113 15 │ INNER JOIN HASH ON id = info_type_id 23 1 │ │└DISTRIBUTE GATHER 23 1 │ │ FILTER info = 'height' 113 113 │ │ DISTRIBUTE ROUND ROBIN 113 113 │ │ TABLE SCAN info_type WHERE info = 'height' 15341 2445 │ INNER JOIN HASH ON id = person_id AND person_id = person_id 15341 15 │ │└DISTRIBUTE GATHER 15341 15 │ │ INNER JOIN HASH ON person_id = id AND person_id = id 15341 15 │ │ │└DISTRIBUTE GATHER 15341 15 │ │ │ INNER JOIN HASH ON keyword_id = id 15341 9396 │ │ │ │└DISTRIBUTE GATHER 15341 9396 │ │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 8566 87 │ │ │ │ │└DISTRIBUTE GATHER 8566 87 │ │ │ │ │ INNER JOIN HASH ON id = info_type_id 23 1 │ │ │ │ │ │└DISTRIBUTE GATHER 23 1 │ │ │ │ │ │ FILTER info = 'release dates' 113 113 │ │ │ │ │ │ DISTRIBUTE ROUND ROBIN 113 113 │ │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 40970 87 │ │ │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id 34885 142 │ │ │ │ │ │└DISTRIBUTE GATHER 34885 142 │ │ │ │ │ │ INNER JOIN HASH ON company_id = id 34885 469 │ │ │ │ │ │ │└DISTRIBUTE GATHER 34885 469 │ │ │ │ │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id 33771 17 │ │ │ │ │ │ │ │└DISTRIBUTE GATHER 33771 17 │ │ │ │ │ │ │ │ INNER JOIN HASH ON person_role_id = id 33771 2737 │ │ │ │ │ │ │ │ │└DISTRIBUTE GATHER 33771 2737 │ │ │ │ │ │ │ │ │ INNER JOIN HASH ON id = status_id 1 1 │ │ │ │ │ │ │ │ │ │└DISTRIBUTE GATHER 1 1 │ │ │ │ │ │ │ │ │ │ FILTER kind = 'complete+verified' 4 4 │ │ │ │ │ │ │ │ │ │ DISTRIBUTE ROUND ROBIN 4 4 │ │ │ │ │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'complete+verified' 67543 20407 │ │ │ │ │ │ │ │ │ INNER JOIN HASH ON id = subject_id 1 1 │ │ │ │ │ │ │ │ │ │└DISTRIBUTE GATHER 1 1 │ │ │ │ │ │ │ │ │ │ FILTER kind = 'cast' 4 4 │ │ │ │ │ │ │ │ │ │ DISTRIBUTE ROUND ROBIN 4 4 │ │ │ │ │ │ │ │ │ │ TABLE SCAN comp_cast_type WHERE kind = 'cast' 135086 28513 │ │ │ │ │ │ │ │ │ PROJECT person_id, person_id, movie_id, person_role_id, role_id, movie_id, subject_id, status_id 135086 28513 │ │ │ │ │ │ │ │ │ INNER JOIN HASH ON movie_id = movie_id 135086 122880 │ │ │ │ │ │ │ │ │ │└DISTRIBUTE HASH ON movie_id 135086 122880 │ │ │ │ │ │ │ │ │ │ TABLE SCAN complete_cast WHERE (((subject_id >= 1) AND (subject_id <= 1)) AND subject_id IN 1) AND (((status_id >= 4) AND (status_id <= 4)) AND status_id IN 4) 1608526 507695 │ │ │ │ │ │ │ │ │ DISTRIBUTE HASH ON movie_id 1608526 507695 │ │ │ │ │ │ │ │ │ INNER JOIN HASH ON person_id = person_id 901343 901343 │ │ │ │ │ │ │ │ │ │└DISTRIBUTE HASH ON person_id 901343 901343 │ │ │ │ │ │ │ │ │ │ TABLE SCAN aka_name 7248869 268042 │ │ │ │ │ │ │ │ │ DISTRIBUTE HASH ON person_id 7248869 268042 │ │ │ │ │ │ │ │ │ FILTER ((note = '(voice)') OR (note = '(voice) (uncredited)')) OR (note = '(voice: English version)') 36244344 7656546 │ │ │ │ │ │ │ │ │ TABLE SCAN cast_info WHERE (((((note = '(voice)') OR (note = '(voice) (uncredited)')) OR (note = '(voice: English version)')) AND CASE MOD(HASH_REPARTITION person_id,10) WHEN 0 THEN (((person_id >= 5) AND (person_id <= 4167489)) AND TRUE) WHEN 1 THEN (((person_id >= 15) AND (person_id <= 4167473)) AND TRUE) WHEN 2 THEN (((person_id >= 69) AND (person_id <= 4167478)) AND TRUE) WHEN 3 THEN (((person_id >= 161) AND (person_id <= 4167352)) A... 628068 1 │ │ │ │ │ │ │ │ FILTER name = 'Queen' 3140339 3140339 │ │ │ │ │ │ │ │ TABLE SCAN char_name WHERE (name = 'Queen') AND (((id >= 21) AND (id <= 3129993)) AND TRUE) 2609129 2240489 │ │ │ │ │ │ │ TABLE SCAN movie_companies WHERE (((movie_id >= 1645050) AND (movie_id <= 2296721)) AND ((movie_id >= 1645050) AND (movie_id <= 2296721))) AND struct(movie_id,movie_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > ) 47000 44844 │ │ │ │ │ │ FILTER country_code = 'us' 234997 122880 │ │ │ │ │ │ TABLE SCAN company_name WHERE (country_code = 'us') AND (((id >= 19) AND (id <= 95261)) AND id IN(22956,22956,22956,5894,5894,5894,95261,95261,95261,4626,4626,4626,4626,4626,4626,21911,21911,21911,4616,4616,4616,22956,22956,22956,22956,22956,5894,5894,5894,5894,5894,95261,95261,95261,95261,95261,160,160,160,1394,1394,1394,1394,1394,1394,1394,1394,1394,6071,6071,6071,11916,11916,11916,11777,11777,11777,11778,11778,11778,698,698,698,1431,1431,1431,117... 2967144 387620 │ │ │ │ │ FILTER info LIKE 'USA:%200%' 14835720 3212639 │ │ │ │ │ TABLE SCAN movie_info WHERE (info LIKE 'USA:%200%' AND (((((movie_id >= 1645050) AND (movie_id <= 2296721)) AND ((movie_id >= 1645050) AND (movie_id <= 2296721))) AND ((movie_id >= 1645050) AND (movie_id <= 2296721))) AND struct(movie_id,movie_id,movie_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > ... 4523930 2305780 │ │ │ │ TABLE SCAN movie_keyword WHERE (((((movie_id >= 2285018) AND (movie_id <= 2296721)) AND ((movie_id >= 2285018) AND (movie_id <= 2296721))) AND ((movie_id >= 2285018) AND (movie_id <= 2296721))) AND ((movie_id >= 2285018) AND (movie_id <= 2296721))) AND TRUE 26834 1 │ │ │ FILTER keyword = 'computer-animation' 134170 134170 │ │ │ DISTRIBUTE ROUND ROBIN 134170 134170 │ │ │ TABLE SCAN keyword WHERE (keyword = 'computer-animation') AND (((id >= 1) AND (id <= 121817)) AND TRUE) 833499 11978 │ │ FILTER (gender = 'f') AND name LIKE '%An%' 4167491 122880 │ │ TABLE SCAN name WHERE ((gender = 'f') AND name LIKE '%An%') AND ((((id >= 1763943) AND (id <= 1763943)) AND ((id >= 1763943) AND (id <= 1763943))) AND struct(id,id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > )) 2963664 2963664 │ TABLE SCAN person_info WHERE ((((person_id >= 1763943) AND (person_id <= 1763943)) AND ((person_id >= 1763943) AND (person_id <= 1763943))) AND struct(person_id,person_id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > )) AND (((info_type_id >= 22) AND (info_type_id <= 22)) AND info_type_id IN 22) 505663 2 FILTER ((title = 'Shrek 2') AND (production_year >= 2000)) AND (production_year <= 2005) 2528312 245760 TABLE SCAN title WHERE (((title = 'Shrek 2') AND (production_year >= 2000)) AND (production_year <= 2005)) AND (((((((id >= 2285018) AND (id <= 2285018)) AND ((id >= 2285018) AND (id <= 2285018))) AND ((id >= 2285018) AND (id <= 2285018))) AND ((id >= 2285018) AND (id <= 2285018))) AND ((id >= 2285018) AND (id <= 2285018))) AND TRUE)
	Estimate Actual Operator 1 1 AGGREGATE MIN(chn.name), MIN(n.name), MIN(t.title) 1 2 DISTRIBUTE GATHER 1 2 AGGREGATE MIN(chn.name), MIN(n.name), MIN(t.title) 2150 15 INNER JOIN HASH ON mi.movie_id = t.id 2150 2 │└DISTRIBUTE GATHER 901000 2 │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.title = 'Shrek 2') AND (t.production_year >= 2000L) AND (t.production_year <= 2005L) 2150 15 INNER JOIN HASH ON n.id = pi.person_id 2150 15 │└DISTRIBUTE GATHER 404 15 │ INNER JOIN HASH ON ci.person_id = n.id 404 15 │ │└DISTRIBUTE GATHER 404 15 │ │ INNER JOIN HASH ON mc.movie_id = mk.movie_id 404 414 │ │ │└DISTRIBUTE GATHER 404 414 │ │ │ INNER JOIN HASH ON mk.keyword_id = k.id 404 1 │ │ │ │└DISTRIBUTE GATHER 2610000 1 │ │ │ │ TABLE SCAN keyword WHERE k.keyword = 'computer-animation' 4 4503451 │ │ │ TABLE SCAN movie_keyword 404 87 │ │ INNER JOIN HASH ON mc.movie_id = mi.movie_id 404 142 │ │ │└DISTRIBUTE GATHER 64 142 │ │ │ INNER JOIN HASH ON ci.movie_id = mc.movie_id 64 17 │ │ │ │└DISTRIBUTE GATHER 250 17 │ │ │ │ INNER JOIN HASH ON cc.status_id = cct2.id 250 1 │ │ │ │ │└DISTRIBUTE GATHER 4520000 1 │ │ │ │ │ TABLE SCAN comp_cast_type WHERE cct2.kind = 'complete+verified' 250 30 │ │ │ │ INNER JOIN HASH ON cc.subject_id = cct1.id 250 1 │ │ │ │ │└DISTRIBUTE GATHER 4170000 1 │ │ │ │ │ TABLE SCAN comp_cast_type WHERE cct1.kind = 'cast' 170 35 │ │ │ │ INNER JOIN HASH ON ci.movie_id = cc.movie_id 170 137 │ │ │ │ │└DISTRIBUTE GATHER 12100 137 │ │ │ │ │ INNER JOIN HASH ON an.person_id = ci.person_id 12100 73 │ │ │ │ │ │└DISTRIBUTE GATHER 71 73 │ │ │ │ │ │ INNER JOIN HASH ON ci.role_id = rt.id 71 1 │ │ │ │ │ │ │└DISTRIBUTE GATHER 113 1 │ │ │ │ │ │ │ TABLE SCAN role_type WHERE rt.role = 'actress' 135000 73 │ │ │ │ │ │ INNER JOIN HASH ON ci.person_role_id = chn.id 135000 1 │ │ │ │ │ │ │└DISTRIBUTE GATHER 12 1 │ │ │ │ │ │ │ TABLE SCAN char_name WHERE chn.name = 'Queen' 2530000 239490 │ │ │ │ │ │ TABLE SCAN cast_info WHERE (ci.note IN('(voice)','(voice) (uncredited)','(voice: English version)')) AND (ci.person_role_id IS NOT NULL) 2960000 880864 │ │ │ │ │ TABLE SCAN aka_name 134000 130992 │ │ │ │ TABLE SCAN complete_cast WHERE cc.movie_id IS NOT NULL 250 926065 │ │ │ INNER JOIN HASH ON mc.company_id = cn.id 250 84843 │ │ │ │└DISTRIBUTE GATHER 113 84843 │ │ │ │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us') 235000 2183148 │ │ │ TABLE SCAN movie_companies 25 48535 │ │ INNER JOIN HASH ON mi.info_type_id = it.id 25 1 │ │ │└DISTRIBUTE GATHER 14800000 1 │ │ │ TABLE SCAN info_type WHERE it.info = 'release dates' 3140000 48535 │ │ TABLE SCAN movie_info WHERE mi.info LIKE 'USA:%200%' 135000 39153 │ TABLE SCAN name WHERE (n.gender IS NOT NULL) AND (n.gender = 'f') AND contains(n.name,'An') 2150 78466 INNER JOIN HASH ON pi.info_type_id = it3.id 2150 1 │└DISTRIBUTE GATHER 4 1 │ TABLE SCAN info_type WHERE it3.info = 'height' 36200000 1656794 TABLE SCAN person_info
	Estimate Actual Operator 1 1 AGGREGATE MIN(name as name) AS Expr1034, MIN(name as name) AS Expr1035, MIN(title as title) AS Expr1036 1 15 INNER JOIN HASH ON pi.info_type_id = it3.id 1 1 │└TABLE SCAN info_type AS it3 WHERE info as info = 'height' 80 15 INNER JOIN LOOP ON Bmk1028 = Bmk1028 1 15 │└TABLE SEEK person_info AS pi WHERE BLOOM(info_type_id as info_type_id) 804 2445 PROJECT BmkToPage Bmk1028 AS Expr1130 804 2445 INNER JOIN LOOP ON n.id = pi.person_id 46 2445 │└TABLE SEEK person_info AS pi 17 15 FILTER country_code as country_code = 'us' 48 66 INNER JOIN LOOP ON Bmk1012 = Bmk1012 1 66 │└TABLE SEEK company_name AS cn 48 66 INNER JOIN LOOP ON mc.company_id = cn.id 1 66 │└TABLE SEEK company_name AS cn 48 66 INNER JOIN LOOP ON Bmk1020 = Bmk1020 1 66 │└TABLE SEEK movie_companies AS mc 48 66 PROJECT BmkToPage Bmk1020 AS Expr1126 48 66 INNER JOIN LOOP ON t.id = mc.movie_id 9 66 │└TABLE SEEK movie_companies AS mc 4 3 INNER JOIN LOOP ON n.id = an.person_id 4 3 │└TABLE SEEK aka_name AS an 1 1 FILTER name as name LIKE '%An%' AND gender as gender = 'f' 1 1 INNER JOIN LOOP ON Bmk1026 = Bmk1026 1 1 │└TABLE SEEK name AS n 1 1 PROJECT BmkToPage Bmk1026 AS Expr1125 1 1 INNER JOIN LOOP ON ci.person_id = n.id 1 1 │└TABLE SEEK name AS n 1 1 FILTER name as name = 'Queen' 1 11 INNER JOIN LOOP ON Bmk1008 = Bmk1008 1 11 │└TABLE SEEK char_name AS chn 1 11 PROJECT BmkToPage Bmk1008 AS Expr1124 1 11 INNER JOIN LOOP ON ci.person_role_id = chn.id 1 11 │└TABLE SEEK char_name AS chn 1 11 FILTER role as role = 'actress' 1 38 INNER JOIN LOOP ON Bmk1030 = Bmk1030 1 38 │└TABLE SEEK role_type AS rt 1 38 INNER JOIN LOOP ON ci.role_id = rt.id 1 38 │└TABLE SEEK role_type AS rt 1 38 FILTER note as note = '(voice)' OR note as note = '(voice) (uncredited)' OR note as note = '(voice: English version)' 30 229 INNER JOIN LOOP ON Bmk1010 = Bmk1010 1 229 │└TABLE SEEK cast_info AS ci 30 229 PROJECT BmkToPage Bmk1010 AS Expr1122 30 229 INNER JOIN LOOP ON t.id = ci.movie_id 30 229 │└TABLE SEEK cast_info AS ci 1 1 FILTER info as info = 'release dates' 1 1 INNER JOIN LOOP ON Bmk1014 = Bmk1014 1 1 │└TABLE SEEK info_type AS it 1 1 INNER JOIN LOOP ON mi.info_type_id = it.id 1 1 │└TABLE SEEK info_type AS it 1 1 INNER JOIN LOOP ON t.id = mi.movie_id 1 1 │└TABLE SEEK movie_info AS mi WHERE info as info LIKE 'USA:%200%' 1 1 FILTER kind as kind = 'cast' 1 1 INNER JOIN LOOP ON Bmk1004 = Bmk1004 1 1 │└TABLE SEEK comp_cast_type AS cct1 1 1 INNER JOIN LOOP ON cc.subject_id = cct1.id 1 1 │└TABLE SEEK comp_cast_type AS cct1 1 1 FILTER kind as kind = 'complete+verified' 1 1 INNER JOIN LOOP ON Bmk1006 = Bmk1006 1 1 │└TABLE SEEK comp_cast_type AS cct2 1 1 INNER JOIN LOOP ON cc.status_id = cct2.id 1 1 │└TABLE SEEK comp_cast_type AS cct2 1 1 INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 1 │└TABLE SEEK complete_cast AS cc 1 1 INNER JOIN LOOP ON t.id = cc.movie_id 1 1 │└TABLE SEEK complete_cast AS cc 1 1 FILTER title as title = 'Shrek 2' 1 142 INNER JOIN LOOP ON Bmk1032 = Bmk1032 0 142 │└TABLE SEEK title AS t WHERE production_year as production_year >= 2000 AND production_year as production_year <= 2005 90 414 PROJECT BmkToPage Bmk1032 AS Expr1120 90 414 INNER JOIN LOOP ON mk.movie_id = t.id 1 414 │└TABLE SEEK title AS t 90 414 INNER JOIN LOOP ON Bmk1024 = Bmk1024 1 414 │└TABLE SEEK movie_keyword AS mk 90 414 INNER JOIN LOOP ON k.id = mk.keyword_id 90 414 │└TABLE SEEK movie_keyword AS mk 1 1 TABLE SCAN keyword AS k WHERE keyword as keyword = 'computer-animation'
	Estimate Actual Operator 1 ∞ PROJECT min AS voiced_char, min_98 AS voicing_actress, min_99 AS voiced_animation 1 1 AGGREGATE MIN(min_100) AS min, MIN(min_101) AS min_98, MIN(min_102) AS min_99 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(name_14) AS min_100, MIN(name_68) AS min_101, MIN(title) AS min_102 - 15 INNER JOIN HASH ON movie_id_24 = id_90 79518 2 │└DISTRIBUTE HASH ON id_90 79518 2 │ PROJECT id AS id_90, title 79518 2 │ FILTER (production_year BETWEEN 2000 AND 2005) AND (title = 'Shrek 2') 79518 2 │ TABLE SCAN title - 15 INNER JOIN HASH ON role_id = id_86 12 1 │└DISTRIBUTE GATHER 12 1 │ PROJECT id AS id_86 12 1 │ FILTER role = 'actress' 12 1 │ TABLE SCAN role_type - 15 INNER JOIN HASH ON info_type_id_80 = id_40 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_40 113 1 │ FILTER info = 'height' 113 1 │ TABLE SCAN info_type - 15 INNER JOIN HASH ON person_id_23 = person_id_79 2963664 142345 │└DISTRIBUTE HASH ON person_id_79 2963664 142345 │ PROJECT person_id AS person_id_79, info_type_id AS info_type_id_80 2963664 142345 │ TABLE SCAN person_info - 15 INNER JOIN HASH ON person_id_23 = id_67 3750742 2448 │└DISTRIBUTE HASH ON id_67 3750742 2448 │ PROJECT id AS id_67, name AS name_68 3750742 2448 │ FILTER (gender = 'f') AND (name LIKE '%An%') 3750742 2448 │ TABLE SCAN name - 15 INNER JOIN HASH ON keyword_id = id_45 134170 1 │└DISTRIBUTE GATHER 134170 1 │ PROJECT id AS id_45 134170 1 │ FILTER keyword = 'computer-animation' 134170 1 │ TABLE SCAN keyword - 15 INNER JOIN HASH ON movie_id_24 = movie_id_63 4523930 1 │└DISTRIBUTE HASH ON movie_id_63 4523930 1 │ PROJECT movie_id AS movie_id_63, keyword_id 4523930 1 │ TABLE SCAN movie_keyword - 15 INNER JOIN HASH ON info_type_id = id_36 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_36 113 1 │ FILTER info = 'release dates' 113 1 │ TABLE SCAN info_type - 15 INNER JOIN HASH ON movie_id_24 = movie_id_56 13352148 1 │└DISTRIBUTE HASH ON movie_id_56 13352148 1 │ PROJECT movie_id AS movie_id_56, info_type_id 13352148 1 │ FILTER (info >= 'USA:') AND (info < 'USA;') AND (info LIKE 'USA:%200%') 13352148 1 │ TABLE SCAN movie_info - 15 INNER JOIN HASH ON company_id = id_28 234997 84843 │└DISTRIBUTE GATHER 234997 84843 │ PROJECT id AS id_28 234997 84843 │ FILTER country_code = 'us' 234997 84843 │ TABLE SCAN company_name - 15 INNER JOIN HASH ON movie_id_24 = movie_id_50 2609129 5 │└DISTRIBUTE HASH ON movie_id_50 2609129 5 │ PROJECT movie_id AS movie_id_50, company_id 2609129 5 │ TABLE SCAN movie_companies - 3 INNER JOIN HASH ON person_role_id = id_13 3140339 1 │└DISTRIBUTE HASH ON id_13 3140339 1 │ PROJECT id AS id_13, name AS name_14 3140339 1 │ FILTER name = 'Queen' 3140339 1 │ TABLE SCAN char_name - 3 INNER JOIN HASH ON status_id = id_8 4 1 │└DISTRIBUTE GATHER 4 1 │ PROJECT id AS id_8 4 1 │ FILTER kind = 'complete+verified' 4 1 │ TABLE SCAN comp_cast_type - 3 INNER JOIN HASH ON subject_id = id_4 4 1 │└DISTRIBUTE GATHER 4 1 │ PROJECT id AS id_4 4 1 │ FILTER kind = 'cast' 4 1 │ TABLE SCAN comp_cast_type - 3 INNER JOIN HASH ON movie_id_24 = movie_id 135086 1 │└DISTRIBUTE GATHER 135086 1 │ TABLE SCAN complete_cast - 3 INNER JOIN HASH ON person_id_23 = person_id 901343 2885 │└DISTRIBUTE GATHER 901343 2885 │ TABLE SCAN aka_name 32619910 1 PROJECT person_id AS person_id_23, movie_id AS movie_id_24, person_role_id, role_id 32619910 1 FILTER note IN('(voice)','(voice) (uncredited)','(voice: English version)') 32619910 1 TABLE SCAN cast_info
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(name), MIN(title) 1 15 INNER JOIN LOOP ON id = company_id 1 66 │└INNER JOIN LOOP ON id = status_id 1 66 │ │└INNER JOIN LOOP ON id = info_type_id 1 10758 │ │ │└INNER JOIN LOOP ON person_id = person_id AND id = person_id AND (id = person_id) 1 66 │ │ │ │└INNER JOIN LOOP ON id = subject_id 1 66 │ │ │ │ │└INNER JOIN LOOP ON id = person_role_id 1 66 │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 66 │ │ │ │ │ │ │└INNER JOIN LOOP ON person_id = person_id AND person_id = id AND (person_id = id) 1 22 │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = info_type_id 1 22 │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 1 │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 1 │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = person_id 1 11 │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = role_id 1 38 │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = id AND (movie_id = id) 1 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON id = movie_id 34 414 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │└INNER JOIN LOOP ON keyword_id = id 1 1 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │└TABLE SEEK keyword AS k 305 414 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK movie_keyword AS mk 414 414 │ │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK title AS t WHERE (t.production_year >= 2000) AND (t.production_year <= 2005) AND (t.title = 'Shrek 2') 1 38 │ │ │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK cast_info AS ci WHERE ci.note IN('(voice)','(voice) (uncredited)','(voice: English version)') 38 38 │ │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK role_type AS rt WHERE rt.role = 'actress' 11 11 │ │ │ │ │ │ │ │ │ │ │ TABLE SEEK name AS n WHERE (n.name LIKE '%An%') AND (n.gender = 'f') 1 1 │ │ │ │ │ │ │ │ │ │ TABLE SEEK movie_info AS mi WHERE mi.info LIKE 'USA:%200%' 5 22 │ │ │ │ │ │ │ │ │ TABLE SEEK movie_companies AS mc 22 22 │ │ │ │ │ │ │ │ TABLE SEEK info_type AS it WHERE it.info = 'release dates' 44 66 │ │ │ │ │ │ │ TABLE SEEK aka_name AS an 132 66 │ │ │ │ │ │ TABLE SEEK complete_cast AS cc 66 66 │ │ │ │ │ TABLE SEEK char_name AS chn WHERE chn.name = 'Queen' 66 66 │ │ │ │ TABLE SEEK comp_cast_type AS cct1 WHERE cct1.kind = 'cast' 1650 10758 │ │ │ TABLE SEEK person_info AS pi 10758 10758 │ │ TABLE SEEK info_type AS it3 WHERE it3.info = 'height' 66 66 │ TABLE SEEK comp_cast_type AS cct2 WHERE cct2.kind = 'complete+verified' 66 66 TABLE SEEK company_name AS cn WHERE cn.country_code = 'us'