Planner — IMDB — JOB-7C

SELECT MIN(n.name) AS cast_member_name,
       MIN(pi.info) AS cast_member_info
FROM job.aka_name AS an,
     job.cast_info AS ci,
     job.info_type AS it,
     job.link_type AS lt,
     job.movie_link AS ml,
     job.name AS n,
     job.person_info AS pi,
     job.title AS t
WHERE an.name IS NOT NULL
  AND (an.name LIKE '%a%'
       OR an.name LIKE 'A%')
  AND it.info ='mini biography'
  AND lt.link IN ('references',
                  'referenced in',
                  'features',
                  'featured in')
  AND n.name_pcode_cf BETWEEN 'A' AND 'F'
  AND (n.gender='m'
       OR (n.gender = 'f'
           AND n.name LIKE 'A%'))
  AND pi.note IS NOT NULL
  AND t.production_year BETWEEN 1980 AND 2010
  AND n.id = an.person_id
  AND n.id = pi.person_id
  AND ci.person_id = n.id
  AND t.id = ci.movie_id
  AND ml.linked_movie_id = t.id
  AND lt.id = ml.link_type_id
  AND it.id = pi.info_type_id
  AND pi.person_id = an.person_id
  AND pi.person_id = ci.person_id
  AND an.person_id = ci.person_id
  AND ci.movie_id = ml.linked_movie_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 36,621,335 37M Rank		Estimation Error Est Err 37,654,185 38M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 1,318,713 1.3M Rank	Estimation Error Est Err 68,185 68K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 41,987,337 42M Rank		Estimation Error Est Err 0 Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 0 Rank	Estimation Error Est Err 0 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 39,163,628 39M Rank		Estimation Error Est Err 38,954,993 39M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 3,385,297 3.4M Rank	Estimation Error Est Err 152,370 152K Rank	Estimation Error Est Err 2,364,968 2.4M Rank
Estimation Error Est Err 44,266,804 44M Rank		Estimation Error Est Err 67,791,832 68M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 32,538,163 33M Rank	Estimation Error Est Err 68,195 68K Rank	Estimation Error Est Err 2,458,881 2.5M Rank
Estimation Error Est Err 2,452,624 2.5M Rank		Estimation Error Est Err 2,454,162 2.5M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 4,144,404 4.1M Rank	Estimation Error Est Err 68,185 68K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 3,527,911 3.5M Rank	Estimation Error Est Err 3,527,907 3.5M Rank	Estimation Error Est Err 3,654,933 3.7M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 3,637,721 3.6M Rank	Estimation Error Est Err 68,185 68K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 1,842,861 1.8M Rank	Estimation Error Est Err 1,753,643 1.8M Rank	Estimation Error Est Err 2,992,755 3M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 2,078,329 2.1M Rank	Estimation Error Est Err 70,831 71K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 1,715,433 1.7M Rank		Estimation Error Est Err 706,526 707K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 2,137,018 2.1M Rank	Estimation Error Est Err 68,201 68K Rank	Estimation Error Est Err 1,694,186 1.7M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min 2768 68185 INNER JOIN HASH ON person_id65 = id14 19149 12595 │└INNER JOIN HASH ON id14 = person_id27 11062 13063 │ │└INNER JOIN HASH ON id = info_type_id 1 1 │ │ │└TABLE SCAN info_type WHERE info = mini biography 11062 13063 │ │ INNER JOIN HASH ON id14 = person_id 78143 84183 │ │ │└TABLE SCAN person_info 533145 242783 │ │ TABLE SCAN name WHERE name_pcode_cf BETWEEN A AND F AND gender = m OR gender = f 700653 12016 │ TABLE SCAN aka_name WHERE name28 LIKE '%a%' 470379 1097209 INNER JOIN HASH ON id49 = movie_id66 31449 14194 │└INNER JOIN HASH ON linked_movie_id = id49 11575 21505 │ │└INNER JOIN HASH ON id37 = link_type_id 4 4 │ │ │└TABLE SCAN link_type WHERE link IN(featured in,features,referenced in,references) 29997 29997 │ │ TABLE SCAN movie_link 1604885 8007 │ TABLE SCAN title WHERE production_year BETWEEN 1980 AND 2010 36244344 36244344 TABLE SCAN cast_info
	Estimate Actual Operator - ∞ PROJECT a1 AS cast_member_name, a2 AS cast_member_info - ∞ AGGREGATE MIN(name) AS a1, MIN(info) AS a2 - ∞ PROJECT name, info - ∞ PROJECT name, info - ∞ INNER JOIN HASH ON tuple(PROJECTION_5424.person_id,PROJECTION_5424.person_id,PROJECTION_5424.person_id,PROJECTION_5424.person_id) = tuple(PROJECTION_5409.id,PROJECTION_5409.id,PROJECTION_5409.person_id,PROJECTION_5409.person_id) - ∞ │└PROJECT id, person_id AS person_id_right, name, info - ∞ │ PROJECT name, id, info, person_id - ∞ │ INNER JOIN HASH ON PROJECTION_5415.info_type_id = PROJECTION_5412.id - 1 │ │└PROJECT id AS id_right - 1 │ │ FILTER (1 AND info = 'mini biography'_String) AS a59 - 1 │ │ TABLE SCAN info_type WHERE info = 'mini biography' - ∞ │ PROJECT info_type_id, name, id AS id_left, info, person_id - ∞ │ PROJECT name, id, info, person_id, info_type_id - ∞ │ INNER JOIN HASH ON PROJECTION_5421.id = PROJECTION_5418.person_id - 2963664 │ │└PROJECT person_id, info, info_type_id - 2963664 │ │ PROJECT info, person_id, info_type_id - 2963664 │ │ TABLE SCAN person_info - ∞ │ PROJECT id, name - ∞ │ FILTER (1 AND name_pcode_cf >= 'A'_String AND name_pcode_cf <= 'F'_String AND OR ((gender = 'm'_String), AND ((gender = 'f'_String),startsWith(name,'A'_String)))) AS a35 - 507621 │ TABLE SCAN name WHERE (name_pcode_cf >= 'A') AND (name_pcode_cf <= 'F') AND ((gender = 'm') OR ((gender = 'f') AND startsWith(name,'A'))) - ∞ PROJECT person_id_left, person_id AS person_id_left_2 - ∞ PROJECT person_id, person_id - ∞ INNER JOIN HASH ON tuple(PROJECTION_5430.movie_id,PROJECTION_5430.linked_movie_id) = tuple(PROJECTION_5427.id,PROJECTION_5427.id) - 1555597 │└PROJECT id - 1555597 │ FILTER (1 AND production_year >= 1980_UInt16 AND production_year <= 2010_UInt16) AS a25 - 1555597 │ TABLE SCAN title WHERE (production_year >= 1980) AND (production_year <= 2010) - ∞ PROJECT movie_id, linked_movie_id, person_id, person_id - ∞ PROJECT person_id, person_id, movie_id, linked_movie_id - ∞ INNER JOIN HASH ON PROJECTION_5436.link_type_id = PROJECTION_5433.id - ∞ │└PROJECT id - ∞ │ FILTER (1 AND in(link,__set_String_14540212701686248675_11522973403227204873)) AS a21 - 18 │ TABLE SCAN link_type WHERE TRUE - ∞ PROJECT link_type_id, person_id, person_id, movie_id, linked_movie_id - ∞ PROJECT person_id, person_id, movie_id, linked_movie_id, link_type_id - ∞ INNER JOIN HASH ON PROJECTION_5442.movie_id = PROJECTION_5439.linked_movie_id - 29997 │└PROJECT linked_movie_id, link_type_id - 29997 │ PROJECT linked_movie_id, link_type_id - 29997 │ TABLE SCAN movie_link - ∞ PROJECT movie_id, person_id, person_id - ∞ PROJECT person_id, person_id, movie_id - ∞ INNER JOIN HASH ON PROJECTION_5448.person_id = PROJECTION_5445.person_id - 36244344 │└PROJECT person_id AS person_id_right, movie_id - 36244344 │ PROJECT person_id, movie_id - 36244344 │ TABLE SCAN cast_info - ∞ PROJECT person_id AS person_id_left - ∞ FILTER (1 AND OR ( LIKE (name,'%a%'_String),startsWith(name,'A'_String))) AS a13 - 686095 TABLE SCAN aka_name WHERE name LIKE '%a%' OR startsWith(name,'A')
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1) 0 68185 PROJECT name, info 0 68185 INNER JOIN HASH ON id = movie_id 0 109842 │└INNER JOIN HASH ON link_type_id = id 3 4 │ │└FILTER id <= 17 3 4 │ │ FILTER (link = 'references') OR (link = 'referenced in') OR (link = 'features') OR (link = 'featured in') 18 18 │ │ TABLE SCAN link_type WHERE link IN('references','referenced in','features','featured in') 2 117543 │ INNER JOIN HASH ON linked_movie_id = movie_id 246 1618081 │ │└INNER JOIN HASH ON person_id = person_id 24 12595 │ │ │└INNER JOIN HASH ON info_type_id = id 2 1 │ │ │ │└FILTER id BETWEEN 15 AND 39 2 1 │ │ │ │ TABLE SCAN info_type WHERE info = 'mini biography' 689 12595 │ │ │ INNER JOIN HASH ON person_id = person_id 8361 87695 │ │ │ │└INNER JOIN HASH ON id = person_id 180268 588268 │ │ │ │ │└FILTER person_id <= 4061926 180268 686095 │ │ │ │ │ TABLE SCAN aka_name WHERE (name IS NOT NULL) AND (contains(name,'a') OR prefix(name,'A')) 166699 507620 │ │ │ │ FILTER id BETWEEN 4 AND 4061926 166699 507620 │ │ │ │ FILTER (gender = 'm') OR ((gender = 'f') AND prefix(name,'A')) 833498 1098010 │ │ │ │ TABLE SCAN "name" WHERE name_pcode_cf >= 'A' AND name_pcode_cf <= 'F' 592732 6769 │ │ │ FILTER person_id <= 4061926 592732 6769 │ │ │ TABLE SCAN person_info WHERE note IS NOT NULL 36244344 634618 │ │ FILTER movie_id BETWEEN 284 AND 2524994 36244344 634741 │ │ TABLE SCAN cast_info WHERE person_id >= 4 29997 22911 │ TABLE SCAN movie_link 505662 4079 FILTER id BETWEEN 284 AND 2524994 505662 4079 TABLE SCAN title WHERE production_year >= 1980 AND production_year <= 2010
	Estimate Actual Operator 1 1 PROJECT cast_member_name, cast_member_info 1 1 AGGREGATE MIN(name), MIN(info) 6493 10 DISTRIBUTE GATHER 6493 10 AGGREGATE MIN(name), MIN(info) 6493 68185 INNER JOIN HASH ON movie_id = id AND linked_movie_id = id 6493 109842 │└DISTRIBUTE GATHER 6493 109842 │ INNER JOIN HASH ON id = info_type_id 23 1 │ │└DISTRIBUTE GATHER 23 1 │ │ FILTER info = 'mini biography' 113 113 │ │ DISTRIBUTE ROUND ROBIN 113 113 │ │ TABLE SCAN info_type WHERE info = 'mini biography' 7058 109842 │ INNER JOIN HASH ON id = person_id AND person_id = person_id AND person_id = person_id 7058 271703 │ │└DISTRIBUTE GATHER 7058 271703 │ │ INNER JOIN HASH ON person_id = id AND person_id = id 7058 1391095 │ │ │└DISTRIBUTE GATHER 7058 1391095 │ │ │ INNER JOIN HASH ON id = link_type_id 4 4 │ │ │ │└DISTRIBUTE GATHER 4 4 │ │ │ │ FILTER link IN('references','referenced in','features','featured in') 18 18 │ │ │ │ DISTRIBUTE ROUND ROBIN 18 18 │ │ │ │ TABLE SCAN link_type WHERE link IN('references','referenced in','features','featured in') 29997 1668423 │ │ │ PROJECT person_id, person_id, movie_id, linked_movie_id, link_type_id 29997 1668423 │ │ │ INNER JOIN HASH ON linked_movie_id = movie_id 29997 29997 │ │ │ │└TABLE SCAN movie_link WHERE ((link_type_id >= 5) AND (link_type_id <= 10)) AND link_type_id IN(5,6,9,10) 1608530 27596163 │ │ │ INNER JOIN HASH ON person_id = person_id 180269 686095 │ │ │ │└DISTRIBUTE GATHER 180269 686095 │ │ │ │ FILTER name IS NOT NULL AND (name LIKE '%a%' OR name LIKE 'A%') 901343 901343 │ │ │ │ TABLE SCAN aka_name WHERE name IS NOT NULL AND (name LIKE '%a%' OR name LIKE 'A%') 36244344 36244344 │ │ │ TABLE SCAN cast_info WHERE (((person_id >= 5) AND (person_id <= 4167489)) AND TRUE) AND (((movie_id >= 284) AND (movie_id <= 2524994)) AND TRUE) 833499 507621 │ │ FILTER ((name_pcode_cf >= 'A') AND (name_pcode_cf <= 'F')) AND ((gender = 'm') OR ((gender = 'f') AND name LIKE 'A%')) 4167491 1599013 │ │ TABLE SCAN name WHERE (((name_pcode_cf >= 'A') AND (name_pcode_cf <= 'F')) AND ((gender = 'm') OR ((gender = 'f') AND name LIKE 'A%'))) AND ((((id >= 56) AND (id <= 4061868)) AND ((id >= 56) AND (id <= 4061868))) AND TRUE) 592733 84183 │ FILTER note IS NOT NULL 2963664 2963664 │ TABLE SCAN person_info WHERE (note IS NOT NULL AND (((((person_id >= 207) AND (person_id <= 1782027)) AND ((person_id >= 207) AND (person_id <= 1782027))) AND ((person_id >= 207) AND (person_id <= 1782027))) AND TRUE)) AND (((info_type_id >= 19) AND (info_type_id <= 19)) AND info_type_id IN 19) 559841 1555597 FILTER (production_year >= 1980) AND (production_year <= 2010) 2528312 2528312 TABLE SCAN title WHERE ((production_year >= 1980) AND (production_year <= 2010)) AND ((((id >= 2032) AND (id <= 2524994)) AND ((id >= 2032) AND (id <= 2524994))) AND TRUE)
	Estimate Actual Operator 4 0 SEQUENCE 1 1 ├─AGGREGATE MIN(n.name), MIN(pi.info) 1 2 │ DISTRIBUTE GATHER 1 2 │ AGGREGATE MIN(n.name), MIN(pi.info) 206000 68185 │ INNER JOIN HASH ON an.person_id = n.id 206000 979503 │ │└DISTRIBUTE GATHER 130000 979503 │ │ INNER JOIN HASH ON ci.person_id = an.person_id 130000 1097209 │ │ │└DISTRIBUTE GATHER 7500 1097209 │ │ │ INNER JOIN HASH ON ml.linked_movie_id = ci.movie_id 7500 14194 │ │ │ │└DISTRIBUTE GATHER 84200 14194 │ │ │ │ INNER JOIN HASH ON ml.linked_movie_id = t.id 84200 21505 │ │ │ │ │└DISTRIBUTE GATHER 84200 21505 │ │ │ │ │ INNER JOIN HASH ON ml.link_type_id = lt.id 84200 4 │ │ │ │ │ │└DISTRIBUTE GATHER - 4 │ │ │ │ │ │ TABLE SCAN link_type WHERE lt.link IN('references','referenced in','features','featured in') 4170000 29252 │ │ │ │ │ TABLE SCAN movie_link 113 1550851 │ │ │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year >= 1980L) AND (t.production_year <= 2010L) 36200000 36228372 │ │ │ TABLE SCAN cast_info 18 682875 │ │ TABLE SCAN aka_name WHERE contains(an.name,'a') OR startswith(an.name,'A') 206000 13063 │ INNER JOIN HASH ON pi.person_id = n.id 206000 84183 │ │└DISTRIBUTE GATHER 7890 84183 │ │ INNER JOIN HASH ON pi.info_type_id = it.id 7890 1 │ │ │└DISTRIBUTE GATHER 2960000 1 │ │ │ TABLE SCAN info_type WHERE it.info = 'mini biography' 901000 84183 │ │ TABLE SCAN person_info WHERE pi.note IS NOT NULL 546000 14647 │ FILTER 2530000 503907 │ TABLE SCAN name WHERE (n.name_pcode_cf IS NOT NULL) AND (n.name_pcode_cf >= 'A') AND (n.name_pcode_cf <= 'F') AND ((n.gender = 'm') OR ((n.gender = 'f') AND startswith(n.name,'A'))) 4 0 └─FILTER 130000 1 DISTRIBUTE HASH 130000 1 AGGREGATE bloom_filter_agg(bloom_expr(pi.person_id,pi.person_id),84183L,1048576L) 30000 84183 DISTRIBUTE HASH 30000 84183 DISTRIBUTE HASH 30000 84183 TABLE SCAN person_info WHERE pi.note IS NOT NULL
	Estimate Actual Operator 1 1 AGGREGATE MIN(partialagg1041) AS Expr1016, MIN(partialagg1042) AS Expr1017 1 1 FILTER info as info = 'mini biography' 1 1 INNER JOIN LOOP ON Bmk1004 = Bmk1004 1 1 │└TABLE SEEK info_type AS it 1 1 INNER JOIN LOOP ON pi.info_type_id = it.id 1 1 │└TABLE SEEK info_type AS it 1 1 AGGREGATE MIN(name as name) AS partialagg1041, MIN(info as info) AS partialagg1042 GROUP BY HASH info_type_id 143130 70830 INNER JOIN HASH ON ml.link_type_id = lt.id 4 4 │└FILTER link as link = 'featured in' OR link as link = 'features' OR link as link = 'referenced in' OR link as link = 'references' 18 18 │ INNER JOIN LOOP ON Bmk1006 = Bmk1006 1 18 │ │└TABLE SEEK link_type AS lt 18 18 │ TABLE SEEK link_type AS lt 57252 70830 INNER JOIN HASH ON an.person_id = pi.person_id 15260 40157 │└FILTER (gender as gender = 'm' OR gender as gender = 'f' AND name as name LIKE 'A%') AND name_pcode_cf as name_pcode_cf >= 'A' AND name_pcode_cf as name_pcode_cf <= 'F' 83788 204549 │ INNER JOIN LOOP ON Bmk1010 = Bmk1010 1 204549 │ │└TABLE SEEK name AS n 83788 204549 │ PROJECT BmkToPage Bmk1010 AS Expr2256 83788 204549 │ INNER JOIN LOOP ON pi.person_id = n.id 1 204549 │ │└TABLE SEEK name AS n 83788 204549 │ INNER JOIN HASH ON ci.person_id = pi.person_id 96047 84183 │ │└TABLE SCAN person_info AS pi WHERE note as note IS NOT NULL 55610 190094 │ INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 190094 │ │└TABLE SEEK cast_info AS ci WHERE BLOOM(person_id as person_id) 55610 1097209 │ PROJECT BmkToPage Bmk1002 AS Expr2253 55610 1097209 │ INNER JOIN LOOP ON t.id = ci.movie_id 14 1097209 │ │└TABLE SEEK cast_info AS ci 1840 14194 │ INNER JOIN LOOP ON Bmk1014 = Bmk1014 0 14194 │ │└TABLE SEEK title AS t WHERE production_year as production_year >= 1980 AND production_year as production_year <= 2010 2999 21505 │ PROJECT BmkToPage Bmk1014 AS Expr2250 2999 21505 │ INNER JOIN LOOP ON ml.linked_movie_id = t.id 1 21505 │ │└TABLE SEEK title AS t 2999 21505 │ TABLE SEEK movie_link AS ml WHERE BLOOM(link_type_id as link_type_id) 697 5035 TABLE SCAN aka_name AS an WHERE (name as name LIKE '%a%' OR name as name LIKE 'A%') AND BLOOM(person_id as person_id)
	Estimate Actual Operator 1 ∞ PROJECT min AS cast_member_name, min_42 AS cast_member_info 1 1 AGGREGATE MIN(min_43) AS min, MIN(min_44) AS min_42 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(name_19) AS min_43, MIN(info_30) AS min_44 - 68185 INNER JOIN HASH ON movie_id = id_35 530119 1555597 │└DISTRIBUTE HASH ON id_35 530119 1555597 │ PROJECT id AS id_35 530119 1555597 │ FILTER production_year BETWEEN 1980 AND 2010 530119 1555597 │ TABLE SCAN title - 109842 INNER JOIN HASH ON info_type_id = id_5 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_5 113 1 │ FILTER info = 'mini biography' 113 1 │ TABLE SCAN info_type - 109842 INNER JOIN HASH ON person_id_1 = person_id_29 84183 84183 │└DISTRIBUTE HASH ON person_id_29 84183 84183 │ PROJECT person_id AS person_id_29, info_type_id, info AS info_30 84183 84183 │ FILTER NOT (note IS NULL) 84183 84183 │ TABLE SCAN person_info - 98911 INNER JOIN HASH ON person_id_1 = id_18 3750742 12733 │└DISTRIBUTE HASH ON id_18 3750742 12733 │ PROJECT id AS id_18, name AS name_19 3750742 12733 │ FILTER (gender IN('f','m')) AND (name_pcode_cf BETWEEN 'A' AND 'F') AND ((gender = 'm') OR ((gender = 'f') AND (name LIKE 'A%'))) 3750742 12733 │ TABLE SCAN name - 98911 INNER JOIN HASH ON link_type_id = id_9 18 4 │└DISTRIBUTE GATHER 18 4 │ PROJECT id AS id_9 18 4 │ FILTER link IN('featured in','features','referenced in','references') 18 4 │ TABLE SCAN link_type - 114174 INNER JOIN HASH ON movie_id = linked_movie_id 29997 29636 │└DISTRIBUTE GATHER 29997 29636 │ TABLE SCAN movie_link - 49741 INNER JOIN HASH ON person_id_1 = person_id 811209 12016 │└DISTRIBUTE GATHER 811209 12016 │ FILTER NOT (name IS NULL) AND ((name LIKE '%a%') OR (name LIKE 'A%')) 811209 12016 │ TABLE SCAN aka_name 36244344 21263 PROJECT person_id AS person_id_1, movie_id 36244344 21263 TABLE SCAN cast_info
	Estimate Actual Operator 1 1 AGGREGATE MIN(name), MIN(info) 5 68185 INNER JOIN LOOP ON id = movie_id 8 109842 │└INNER JOIN HASH ON link_type_id = id 4 4 │ │└TABLE SCAN link_type AS lt WHERE lt.link IN('references','referenced in','features','featured in') 37 127027 │ INNER JOIN LOOP ON linked_movie_id = movie_id 1139 1618304 │ │└INNER JOIN LOOP ON person_id = id 12 12595 │ │ │└INNER JOIN LOOP ON person_id = id 81 13063 │ │ │ │└INNER JOIN LOOP ON id = person_id 714 84183 │ │ │ │ │└INNER JOIN LOOP ON info_type_id = id 1 1 │ │ │ │ │ │└TABLE SEEK info_type AS it 3669 84183 │ │ │ │ │ TABLE SEEK person_info AS pi WHERE pi.note IS NOT NULL 84183 84183 │ │ │ │ TABLE SEEK name AS n WHERE (n.name_pcode_cf >= 'A') AND (n.name_pcode_cf <= 'F') AND ((n.gender = 'm') OR ((n.gender = 'f') AND (n.name LIKE 'A%'))) 26126 13063 │ │ │ TABLE SEEK aka_name AS an WHERE (an.name LIKE '%a%') OR (an.name LIKE 'A%') 6360475 1618331 │ │ TABLE SEEK cast_info AS ci 3236608 1618304 │ TABLE SEEK movie_link AS ml 109842 109842 TABLE SEEK title AS t WHERE (t.production_year >= 1980) AND (t.production_year <= 2010)