|
- ∞ PROJECT a1 AS alternative_name, a2 AS character_name, a3 AS movie
- ∞ AGGREGATE MIN(name_right) AS a1, MIN(name_left) AS a2, MIN(title) AS a3
- ∞ PROJECT name, name, title
- ∞ PROJECT name, name, title
- ∞ INNER JOIN HASH ON tuple(PROJECTION_5659.id,PROJECTION_5659.id) = tuple(PROJECTION_5620.movie_id,PROJECTION_5620.movie_id)
- ∞ │└PROJECT movie_id, movie_id, name, name
- ∞ │ PROJECT name, movie_id, name, movie_id
- ∞ │ INNER JOIN HASH ON PROJECTION_5656.id = PROJECTION_5623.person_role_id
- ∞ │ │└PROJECT person_role_id, name AS name_right, movie_id, movie_id
- ∞ │ │ PROJECT name, person_role_id, movie_id, movie_id
- ∞ │ │ INNER JOIN HASH ON tuple(PROJECTION_5653.person_id,PROJECTION_5653.person_id) = tuple(PROJECTION_5626.person_id,PROJECTION_5626.id)
- ∞ │ │ │└PROJECT person_id AS person_id_right, id, person_role_id, movie_id, movie_id
- ∞ │ │ │ PROJECT person_id, person_role_id, movie_id, movie_id, id
- ∞ │ │ │ INNER JOIN HASH ON PROJECTION_5650.id = PROJECTION_5629.company_id
- ∞ │ │ │ │└PROJECT company_id, person_id, person_role_id, movie_id, movie_id, id AS id_right
- ∞ │ │ │ │ PROJECT person_id, person_role_id, movie_id, movie_id, company_id, id
- ∞ │ │ │ │ INNER JOIN HASH ON PROJECTION_5647.movie_id = PROJECTION_5632.movie_id
- ∞ │ │ │ │ │└PROJECT movie_id AS movie_id_right, person_id, person_role_id, id
- ∞ │ │ │ │ │ PROJECT person_id, person_role_id, movie_id, id
- ∞ │ │ │ │ │ INNER JOIN HASH ON PROJECTION_5644.id = PROJECTION_5635.person_id
- ∞ │ │ │ │ │ │└PROJECT person_id, person_role_id, movie_id
- ∞ │ │ │ │ │ │ PROJECT person_id, person_role_id, movie_id
- ∞ │ │ │ │ │ │ INNER JOIN HASH ON PROJECTION_5641.role_id = PROJECTION_5638.id
- 1 │ │ │ │ │ │ │└PROJECT id
- 1 │ │ │ │ │ │ │ FILTER (1 AND role = 'actress'_String) AS a48
- 1 │ │ │ │ │ │ │ TABLE SCAN role_type WHERE role = 'actress'
- ∞ │ │ │ │ │ │ PROJECT role_id, person_id, person_role_id, movie_id
- ∞ │ │ │ │ │ │ FILTER (in(note,__set_String_6680244196204786103_17565861716447275384) AND 1) AS a44
- 36244344 │ │ │ │ │ │ TABLE SCAN cast_info WHERE TRUE
- ∞ │ │ │ │ │ PROJECT id
- ∞ │ │ │ │ │ FILTER (1 AND LIKE (name,'%Ang%'_String) AND gender = 'f'_String) AS a35
- 6768 │ │ │ │ │ TABLE SCAN name WHERE (gender = 'f') AND name LIKE '%Ang%'
- ∞ │ │ │ │ PROJECT movie_id AS movie_id_left, company_id
- ∞ │ │ │ │ FILTER (1 AND OR ( LIKE (note,'%(USA)%'_String), LIKE (note,'%(worldwide)%'_String))) AS a26
- 590994 │ │ │ │ TABLE SCAN movie_companies WHERE note LIKE '%(USA)%' OR note LIKE '%(worldwide)%'
- 0 │ │ │ PROJECT id AS id_left
- 0 │ │ │ FILTER (1 AND country_code = 'us'_String) AS a21
- 0 │ │ │ TABLE SCAN company_name WHERE country_code = 'us'
- 901343 │ │ PROJECT person_id AS person_id_left, name
- 901343 │ │ PROJECT name, person_id
- 901343 │ │ TABLE SCAN aka_name
- 3140339 │ PROJECT id, name AS name_left
- 3140339 │ PROJECT name, id
- 3140339 │ TABLE SCAN char_name
- 1107888 PROJECT id, title
- 1107888 FILTER (1 AND production_year >= 2005_UInt16 AND production_year <= 2015_UInt16) AS a8
- 1107888 TABLE SCAN title WHERE (production_year >= 2005) AND (production_year <= 2015)
|
|
- 1 AGGREGATE MIN(#0), MIN(#1), MIN(#2)
26 121 PROJECT name, name, title
26 121 INNER JOIN HASH ON id = person_role_id
26 127 │└INNER JOIN HASH ON id = person_id
45 69895 │ │└INNER JOIN HASH ON person_id = person_id
180 30619 │ │ │└INNER JOIN HASH ON role_id = id
1 1 │ │ │ │└FILTER id <= 11
1 1 │ │ │ │ TABLE SCAN role_type WHERE role = 'actress'
2168 30619 │ │ │ INNER JOIN HASH ON movie_id = id
743 144120 │ │ │ │└INNER JOIN HASH ON id = movie_id
3650 542096 │ │ │ │ │└INNER JOIN HASH ON company_id = id
1644 84843 │ │ │ │ │ │└TABLE SCAN company_name WHERE country_code = 'us'
521825 590994 │ │ │ │ │ TABLE SCAN movie_companies WHERE (note IS NOT NULL) AND (contains(note,'(USA)') OR contains(note,'(worldwide)'))
505662 1107586 │ │ │ │ FILTER id BETWEEN 2 AND 2525745
505662 1107888 │ │ │ │ TABLE SCAN title WHERE production_year >= 2005 AND production_year <= 2015
7248868 22360 │ │ │ FILTER (person_id >= 4) AND (movie_id BETWEEN 2 AND 2525745)
7248868 22360 │ │ │ FILTER (note = '(voice)') OR (note = '(voice: Japanese version)') OR (note = '(voice) (uncredited)') OR (note = '(voice: English version)')
36244344 614535 │ │ │ TABLE SCAN cast_info WHERE note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)')
901343 4879 │ │ TABLE SCAN aka_name WHERE person_id <= 4061926
2083746 17 │ FILTER id BETWEEN 4 AND 4061926
2083746 17 │ TABLE SCAN "name" WHERE gender = 'f' AND contains(name,'Ang')
3140339 417 TABLE SCAN char_name
|
|
1 1 PROJECT alternative_name, character_name, movie
1 1 AGGREGATE MIN(name), MIN(name), MIN(title)
28463 10 DISTRIBUTE GATHER
28463 10 AGGREGATE MIN(name), MIN(name), MIN(title)
28463 121 INNER JOIN HASH ON movie_id = id AND movie_id = id
28463 341 │└DISTRIBUTE GATHER
28463 341 │ 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'
104366 341 │ INNER JOIN HASH ON person_id = id AND person_id = id
104366 168007 │ │└DISTRIBUTE GATHER
104366 168007 │ │ INNER JOIN HASH ON id = company_id
47000 84843 │ │ │└DISTRIBUTE GATHER
47000 84843 │ │ │ FILTER country_code = 'us'
234997 234997 │ │ │ TABLE SCAN company_name WHERE country_code = 'us'
521826 175314 │ │ PROJECT person_id, name, person_id, movie_id, role_id, name, movie_id, company_id
521826 175314 │ │ INNER JOIN HASH ON movie_id = movie_id
521826 590994 │ │ │└DISTRIBUTE HASH ON movie_id
521826 590994 │ │ │ FILTER note IS NOT NULL AND (note LIKE '%(USA)%' OR note LIKE '%(worldwide)%')
2609129 2609129 │ │ │ TABLE SCAN movie_companies WHERE (note IS NOT NULL AND (note LIKE '%(USA)%' OR note LIKE '%(worldwide)%')) AND (((company_id >= 1) AND (company_id <= 234997)) AND TRUE)
1608526 497319 │ │ DISTRIBUTE HASH ON movie_id
1608526 497319 │ │ INNER JOIN HASH ON person_role_id = id
1608526 517803 │ │ │└DISTRIBUTE HASH ON person_role_id
1608526 517803 │ │ │ INNER JOIN HASH ON person_id = person_id
901343 901343 │ │ │ │└DISTRIBUTE HASH ON person_id
901343 901343 │ │ │ │ TABLE SCAN aka_name
7248869 280995 │ │ │ DISTRIBUTE HASH ON person_id
7248869 280995 │ │ │ FILTER note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)')
36244344 7656546 │ │ │ TABLE SCAN cast_info WHERE ((note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(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)) AND TRUE) WHEN 4 THEN (((...
3140339 3140339 │ │ DISTRIBUTE HASH ON id
3140339 3140339 │ │ TABLE SCAN char_name WHERE CASE MOD(HASH_REPARTITION id,10) WHEN 0 THEN (((id >= 119) AND (id <= 3139884)) AND TRUE) WHEN 1 THEN (((id >= 63) AND (id <= 3139863)) AND TRUE) WHEN 2 THEN (((id >= 53) AND (id <= 3139889)) AND TRUE) WHEN 3 THEN (((id >= 1) AND (id <= 3139888)) AND TRUE) WHEN 4 THEN (((id >= 21) AND (id <= 3139890)) AND TRUE) WHEN 5 THEN (((id >= 57) AND (id <= 3139914)) AND TRUE) WHEN 6 THEN (((id >= 142) AND (id <= 3139883)) AND TRUE) WHEN 7 THEN (((i...
833499 6768 │ FILTER (gender = 'f') AND name LIKE '%Ang%'
4167491 983636 │ TABLE SCAN name WHERE ((gender = 'f') AND name LIKE '%Ang%') AND ((((id >= 293010) AND (id <= 2700464)) AND ((id >= 293010) AND (id <= 2700464))) AND TRUE)
198654 1107888 FILTER (production_year >= 2005) AND (production_year <= 2015)
2528312 2528312 TABLE SCAN title WHERE ((production_year >= 2005) AND (production_year <= 2015)) AND ((((id >= 72717) AND (id <= 2499211)) AND ((id >= 72717) AND (id <= 2499211))) AND struct(id,id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < exp...
|
|
1 1 AGGREGATE MIN(an.name), MIN(chn.name), MIN(t.title)
1 1 DISTRIBUTE GATHER
1 1 AGGREGATE MIN(an.name), MIN(chn.name), MIN(t.title)
630 121 INNER JOIN HASH ON ci.person_id = an.person_id
630 115 │└DISTRIBUTE GATHER
397 115 │ INNER JOIN HASH ON mc.company_id = cn.id
397 84843 │ │└DISTRIBUTE GATHER
4170000 84843 │ │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us')
384 124 │ INNER JOIN HASH ON ci.movie_id = mc.movie_id
384 249 │ │└DISTRIBUTE GATHER
150 249 │ │ INNER JOIN HASH ON ci.movie_id = t.id
150 630 │ │ │└DISTRIBUTE GATHER
142 630 │ │ │ INNER JOIN HASH ON ci.person_role_id = chn.id
142 630 │ │ │ │└DISTRIBUTE GATHER
142 630 │ │ │ │ INNER JOIN HASH ON ci.role_id = rt.id
142 1 │ │ │ │ │└DISTRIBUTE GATHER
2610000 1 │ │ │ │ │ TABLE SCAN role_type WHERE rt.role = 'actress'
142 630 │ │ │ │ INNER JOIN HASH ON ci.person_id = n.id
142 801259 │ │ │ │ │└DISTRIBUTE GATHER
901000 801259 │ │ │ │ │ TABLE SCAN cast_info WHERE (ci.note IN('(voice)','(voice: Japanese version)','(voice) (uncredited)','(voice: English version)')) AND (ci.person_role_id IS NOT NULL)
235000 6557 │ │ │ │ TABLE SCAN name WHERE (n.gender IS NOT NULL) AND (n.gender = 'f') AND contains(n.name,'Ang')
2530000 3128054 │ │ │ TABLE SCAN char_name
3140000 1097880 │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year >= 2005L) AND (t.production_year <= 2015L)
12 581325 │ TABLE SCAN movie_companies WHERE (mc.note IS NOT NULL) AND (contains(mc.note,'(USA)') OR contains(mc.note,'(worldwide)'))
36200000 880864 TABLE SCAN aka_name
|
|
1 1 AGGREGATE MIN(partialagg1049) AS Expr1016, MIN(partialagg1050) AS Expr1017, MIN(partialagg1051) AS Expr1018
134 28 FILTER name as name LIKE '%Ang%' AND gender as gender = 'f'
304 2203 INNER JOIN LOOP ON Bmk1010 = Bmk1010
1 2203 │└TABLE SEEK name AS n
304 2203 PROJECT BmkToPage Bmk1010 AS Expr1074
304 2203 INNER JOIN LOOP ON ci.person_id = n.id
1 2203 │└TABLE SEEK name AS n
304 2203 AGGREGATE MIN(name as name) AS partialagg1049, MIN(name as name) AS partialagg1050, MIN(title as title) AS partialagg1051 GROUP BY SORT person_id
19895 66735 INNER JOIN LOOP ON Bmk1000 = Bmk1000
1 66735 │└TABLE SEEK aka_name AS an
19895 66735 INNER JOIN LOOP ON ci.person_id = an.person_id
4 66735 │└TABLE SEEK aka_name AS an
4100 28401 INNER JOIN LOOP ON Bmk1002 = Bmk1002
1 28401 │└TABLE SEEK char_name AS chn
4100 28401 SORT person_id
4100 28401 INNER JOIN LOOP ON ci.person_role_id = chn.id
1 28401 │└TABLE SEEK char_name AS chn
9114 30652 INNER JOIN LOOP ON Bmk1014 = Bmk1014
0 30652 │└TABLE SEEK title AS t WHERE production_year as production_year >= 2005 AND production_year as production_year <= 2015
9922 79721 PROJECT BmkToPage Bmk1014 AS Expr1067
9922 79721 INNER JOIN LOOP ON mc.movie_id = t.id
1 79721 │└TABLE SEEK title AS t
9922 79721 INNER JOIN HASH ON cn.id = mc.company_id
27590 86119 │└INNER JOIN HASH ON mc.movie_id = ci.movie_id
78870 276269 │ │└INNER JOIN HASH ON ci.role_id = rt.id
1 1 │ │ │└FILTER role as role = 'actress'
12 12 │ │ │ TABLE SCAN role_type AS rt
867572 276269 │ │ TABLE SCAN cast_info AS ci WHERE (PROBE(Bitmap1063,role_id as role_id,N'IN ROW')) AND (note as note = '(voice)' OR note as note = '(voice) (uncredited)' OR note as note = '(voice: English version)' OR note as note = '(voice: Japanese version)')
419570 25339 │ TABLE SCAN movie_companies AS mc WHERE (PROBE(Bitmap1064,movie_id as movie_id,N'IN ROW')) AND ((note as note LIKE '%(USA)%' OR note as note LIKE '%(worldwide)%') AND note as note IS NOT NULL)
84576 2291 TABLE SCAN company_name AS cn WHERE (PROBE(Bitmap1065,id as id,N'IN ROW')) AND (country_code as country_code = 'us')
|
|
1 ∞ PROJECT min AS alternative_name, min_50 AS character_name, min_51 AS movie
1 1 AGGREGATE MIN(min_52) AS min, MIN(min_53) AS min_50, MIN(min_54) AS min_51
- 16 DISTRIBUTE GATHER
- 16 AGGREGATE MIN(name) AS min_52, MIN(name_1) AS min_53, MIN(title) AS min_54
- 121 INNER JOIN HASH ON movie_id = id_43
176706 1107888 │└DISTRIBUTE HASH ON id_43
176706 1107888 │ PROJECT id AS id_43, title
176706 1107888 │ FILTER production_year BETWEEN 2005 AND 2015
176706 1107888 │ TABLE SCAN title
- 341 INNER JOIN HASH ON role_id = id_39
12 1 │└DISTRIBUTE GATHER
12 1 │ PROJECT id AS id_39
12 1 │ FILTER role = 'actress'
12 1 │ TABLE SCAN role_type
- 341 INNER JOIN HASH ON person_id_10 = id_28
4167491 6768 │└DISTRIBUTE HASH ON id_28
4167491 6768 │ PROJECT id AS id_28
4167491 6768 │ FILTER (gender = 'f') AND (name LIKE '%Ang%')
4167491 6768 │ TABLE SCAN name
- 341 INNER JOIN HASH ON company_id = id_14
234997 84843 │└DISTRIBUTE GATHER
234997 84843 │ PROJECT id AS id_14
234997 84843 │ FILTER country_code = 'us'
234997 84843 │ TABLE SCAN company_name
- 341 INNER JOIN HASH ON movie_id = movie_id_23
1203426 542096 │└DISTRIBUTE HASH ON movie_id_23
1203426 542096 │ PROJECT movie_id AS movie_id_23, company_id
1203426 542096 │ FILTER NOT (note IS NULL) AND ((note LIKE '%(USA)%') OR (note LIKE '%(worldwide)%'))
1203426 542096 │ TABLE SCAN movie_companies
- 387 INNER JOIN HASH ON person_role_id = id_0
3140339 3140339 │└DISTRIBUTE HASH ON id_0
3140339 3140339 │ PROJECT id AS id_0, name AS name_1
3140339 3140339 │ TABLE SCAN char_name
- 425 INNER JOIN HASH ON person_id_10 = person_id
901343 1558 │└DISTRIBUTE GATHER
901343 1558 │ TABLE SCAN aka_name
32619910 228 PROJECT person_id AS person_id_10, movie_id, person_role_id, role_id
32619910 228 FILTER note IN('(voice)','(voice) (uncredited)','(voice: English version)','(voice: Japanese version)')
32619910 228 TABLE SCAN cast_info
|
