|
1 1 AGGREGATE min, min, min
1 1874 INNER JOIN HASH ON movie_id46 = movie_id64
1 402 │└INNER JOIN HASH ON company_type_id = id
1 1 │ │└TABLE SCAN company_type WHERE kind = production companies
1 422 │ INNER JOIN HASH ON company_id = id53
1 1021 │ │└INNER JOIN HASH ON id30 = movie_id46
1 199 │ │ │└INNER JOIN HASH ON id30 = movie_id
1 199 │ │ │ │└INNER JOIN HASH ON id6 = link_type_id
2 2 │ │ │ │ │└TABLE SCAN link_type WHERE link LIKE '%follow%'
2 251 │ │ │ │ INNER JOIN HASH ON movie_id24 = movie_id
32 10544 │ │ │ │ │└INNER JOIN HASH ON keyword_id = id11
1 1 │ │ │ │ │ │└TABLE SCAN keyword WHERE keyword = sequel
4523930 4523930 │ │ │ │ │ TABLE SCAN movie_keyword
29997 29997 │ │ │ │ TABLE SCAN movie_link
1923393 29 │ │ │ TABLE SCAN title WHERE production_year BETWEEN 1950 AND 2010
1203251 91 │ │ TABLE SCAN movie_companies WHERE note IS NULL
51405 13 │ TABLE SCAN company_name WHERE name LIKE '%Film%' OR name LIKE '%Warner%' AND country_code <> pl
898256 43 TABLE SCAN movie_info WHERE info BETWEEN Denish AND Swedish AND info IN(Denish,Denmark,English,German,Germany,Norway,Norwegian,Sweden,Swedish)
|
|
- ∞ PROJECT a1 AS company_name, a2 AS link_type, a3 AS western_follow_up
- ∞ AGGREGATE MIN(name) AS a1, MIN(link) AS a2, MIN(title) AS a3
- ∞ PROJECT name, link, title
- ∞ FILTER 0
- ∞ PROJECT name, link, title
- ∞ INNER JOIN HASH ON TRUE
- 0 │└PROJECT title
- 0 │ FILTER 0
- 2528312 │ PROJECT title
- 2528312 │ TABLE SCAN title
- ∞ PROJECT name, link
- ∞ FILTER 0
- ∞ PROJECT name, link
- ∞ INNER JOIN HASH ON PROJECTION_2244.__lhs_const = PROJECTION_2241.__rhs_const
- ∞ │└PROJECT __rhs_const, id
- 29997 │ PROJECT id
- 29997 │ TABLE SCAN movie_link
- ∞ PROJECT __lhs_const, name, link
- ∞ PROJECT name, link
- ∞ INNER JOIN HASH ON PROJECTION_2250.__lhs_const = PROJECTION_2247.__rhs_const
- ∞ │└PROJECT __rhs_const, movie_id
- 4523930 │ PROJECT movie_id
- 4523930 │ TABLE SCAN movie_keyword
- ∞ PROJECT __lhs_const, name, link
- ∞ PROJECT name, link
- ∞ INNER JOIN HASH ON PROJECTION_2256.__lhs_const = PROJECTION_2253.__rhs_const
- ∞ │└PROJECT __rhs_const, info_type_id
- 14835720 │ PROJECT info_type_id
- 14835720 │ TABLE SCAN movie_info
- ∞ PROJECT __lhs_const, name, link
- ∞ PROJECT name, link
- ∞ INNER JOIN HASH ON PROJECTION_2262.__lhs_const = PROJECTION_2259.__rhs_const
- ∞ │└PROJECT __rhs_const, company_type_id
- 2609129 │ PROJECT company_type_id
- 2609129 │ TABLE SCAN movie_companies
- ∞ PROJECT __lhs_const, name, link
- ∞ PROJECT name, link
- ∞ INNER JOIN HASH ON PROJECTION_2268.__lhs_const = PROJECTION_2265.__rhs_const
- ∞ │└PROJECT __rhs_const, link
- 18 │ PROJECT link
- 18 │ TABLE SCAN link_type
- ∞ PROJECT __lhs_const, name
- ∞ PROJECT name
- ∞ INNER JOIN HASH ON PROJECTION_2274.__lhs_const = PROJECTION_2271.__rhs_const
- ∞ │└PROJECT __rhs_const, id
- 134170 │ PROJECT id
- 134170 │ TABLE SCAN keyword
- ∞ PROJECT __lhs_const, name
- 939988 PROJECT name
- 939988 INNER JOIN HASH ON TRUE
- 4 │└PROJECT id
- 4 │ PROJECT id
- 4 │ TABLE SCAN company_type
- 234997 PROJECT name
- 234997 PROJECT name
- 234997 TABLE SCAN company_name
|
|
- 1 AGGREGATE MIN(#0), MIN(#1), MIN(#2)
0 1874 PROJECT name, link, title
0 1874 INNER JOIN HASH ON movie_id = movie_id
0 402 │└INNER JOIN HASH ON id = company_type_id
0 422 │ │└INNER JOIN HASH ON id = company_id
0 1021 │ │ │└INNER JOIN HASH ON movie_id = movie_id
0 199 │ │ │ │└INNER JOIN HASH ON id = movie_id
0 199 │ │ │ │ │└INNER JOIN HASH ON id = link_type_id
0 251 │ │ │ │ │ │└INNER JOIN HASH ON movie_id = movie_id
69 46 │ │ │ │ │ │ │└INNER JOIN HASH ON keyword_id = id
2 1 │ │ │ │ │ │ │ │└TABLE SCAN keyword WHERE keyword = 'sequel'
4523930 46 │ │ │ │ │ │ │ TABLE SCAN movie_keyword WHERE movie_id <= 186175
29997 286 │ │ │ │ │ │ TABLE SCAN movie_link
3 2 │ │ │ │ │ FILTER id <= 17
3 2 │ │ │ │ │ TABLE SCAN link_type WHERE contains(link,'follow')
505662 37 │ │ │ │ FILTER id BETWEEN 2 AND 186175
505662 38 │ │ │ │ TABLE SCAN title WHERE production_year >= 1950 AND production_year <= 2010
521825 94 │ │ │ FILTER movie_id <= 186175
521825 94 │ │ │ TABLE SCAN movie_companies WHERE note IS NULL
46999 13 │ │ TABLE SCAN company_name WHERE country_code != 'pl' AND (contains(name,'Film') OR contains(name,'Warner'))
1 1 │ FILTER id <= 2
1 1 │ TABLE SCAN company_type WHERE kind = 'production companies'
2967144 43 FILTER movie_id BETWEEN 2 AND 186175
2967144 43 FILTER IN ...
14835720 263 INNER JOIN HASH ON info = #0
0 9 │└SCAN MATERIALISED
14835720 263 TABLE SCAN movie_info WHERE info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English')
|
|
1 1 PROJECT company_name, link_type, western_follow_up
1 1 AGGREGATE MIN(name), MIN(link), MIN(title)
6313 10 DISTRIBUTE GATHER
6313 10 AGGREGATE MIN(name), MIN(link), MIN(title)
6313 1874 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id
6313 1874 │└DISTRIBUTE GATHER
6313 1874 │ PROJECT name, movie_id, movie_id, movie_id, movie_id, link
6313 1874 │ INNER JOIN HASH ON id = link_type_id
4 2 │ │└DISTRIBUTE GATHER
4 2 │ │ FILTER link LIKE '%follow%'
18 18 │ │ DISTRIBUTE ROUND ROBIN
18 18 │ │ TABLE SCAN link_type WHERE link LIKE '%follow%'
26834 1894 │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id
26834 2227 │ │└DISTRIBUTE GATHER
26834 2227 │ │ INNER JOIN HASH ON id = keyword_id
26834 1 │ │ │└DISTRIBUTE GATHER
26834 1 │ │ │ FILTER keyword = 'sequel'
134170 134170 │ │ │ DISTRIBUTE ROUND ROBIN
134170 134170 │ │ │ TABLE SCAN keyword WHERE keyword = 'sequel'
109759 1463641 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id
61285 158021 │ │ │└DISTRIBUTE GATHER
61285 158021 │ │ │ INNER JOIN HASH ON movie_id = movie_id
52183 224256 │ │ │ │└DISTRIBUTE GATHER
52183 224256 │ │ │ │ INNER JOIN HASH ON id = company_type_id
1 1 │ │ │ │ │└DISTRIBUTE GATHER
1 1 │ │ │ │ │ FILTER kind = 'production companies'
4 4 │ │ │ │ │ DISTRIBUTE ROUND ROBIN
4 4 │ │ │ │ │ TABLE SCAN company_type WHERE kind = 'production companies'
104366 225118 │ │ │ │ INNER JOIN HASH ON id = company_id
47000 48302 │ │ │ │ │└DISTRIBUTE GATHER
47000 48302 │ │ │ │ │ FILTER (country_code <> 'pl') AND (name LIKE '%Film%' OR name LIKE '%Warner%')
234997 234997 │ │ │ │ │ TABLE SCAN company_name WHERE (country_code <> 'pl') AND (name LIKE '%Film%' OR name LIKE '%Warner%')
521826 1197292 │ │ │ │ FILTER note IS NULL
2609129 1376261 │ │ │ │ TABLE SCAN movie_companies WHERE (note IS NULL AND (((company_id >= 9) AND (company_id <= 234994)) AND TRUE)) AND (((company_type_id >= 2) AND (company_type_id <= 2)) AND company_type_id IN 2)
2967144 936223 │ │ │ FILTER info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English')
14835720 9042947 │ │ │ TABLE SCAN movie_info WHERE info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English') AND (((movie_id >= 50) AND (movie_id <= 2525744)) AND TRUE)
4523930 4523930 │ │ TABLE SCAN movie_keyword WHERE ((((movie_id >= 50) AND (movie_id <= 2525744)) AND ((movie_id >= 50) AND (movie_id <= 2525744))) AND TRUE) AND (((keyword_id >= 398) AND (keyword_id <= 398)) AND keyword_id IN 398)
29997 29997 │ DISTRIBUTE ROUND ROBIN
29997 29997 │ TABLE SCAN movie_link WHERE (((((movie_id >= 31741) AND (movie_id <= 2525069)) AND ((movie_id >= 31741) AND (movie_id <= 2525069))) AND ((movie_id >= 31741) AND (movie_id <= 2525069))) AND TRUE) AND (((link_type_id >= 1) AND (link_type_id <= 2)) AND link_type_id IN(1,2))
1101622 1531729 FILTER (production_year >= 1950) AND (production_year <= 2010)
2528312 2036792 TABLE SCAN title WHERE ((production_year >= 1950) AND (production_year <= 2010)) AND ((((((id >= 31741) AND (id <= 138935)) AND ((id >= 31741) AND (id <= 138935))) AND ((id >= 31741) AND (id <= 138935))) AND ((id >= 31741) AND (id <= 138935))) AND struct(id,id,id,id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr ...
|
|
1 1 AGGREGATE MIN(cn.name), MIN(lt.link), MIN(t.title)
1 1 DISTRIBUTE GATHER
1 1 AGGREGATE MIN(cn.name), MIN(lt.link), MIN(t.title)
886 1874 INNER JOIN HASH ON mk.movie_id = mc.movie_id
886 199 │└DISTRIBUTE GATHER
886 199 │ INNER JOIN HASH ON ml.link_type_id = lt.id
886 2 │ │└DISTRIBUTE GATHER
4520000 2 │ │ TABLE SCAN link_type WHERE contains(lt.link,'follow')
199 248 │ INNER JOIN HASH ON mk.movie_id = ml.movie_id
199 8370 │ │└DISTRIBUTE GATHER
75 8370 │ │ INNER JOIN HASH ON mk.movie_id = t.id
75 10544 │ │ │└DISTRIBUTE GATHER
71 10544 │ │ │ INNER JOIN HASH ON mk.keyword_id = k.id
71 1 │ │ │ │└DISTRIBUTE GATHER
14800000 1 │ │ │ │ TABLE SCAN keyword WHERE k.keyword = 'sequel'
18 4519836 │ │ │ TABLE SCAN movie_keyword
235000 1894760 │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year >= 1950L) AND (t.production_year <= 2010L)
134000 25911 │ TABLE SCAN movie_link
886 158021 INNER JOIN HASH ON mc.company_id = cn.id
886 48302 │└DISTRIBUTE GATHER
2530000 48302 │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND ( NOT (cn.country_code = 'pl')) AND (contains(cn.name,'Film') OR contains(cn.name,'Warner'))
192 788965 INNER JOIN HASH ON mc.company_type_id = ct.id
192 1 │└DISTRIBUTE GATHER
2610000 1 │ TABLE SCAN company_type WHERE ct.kind = 'production companies'
192 788965 INNER JOIN HASH ON mc.movie_id = mi.movie_id
192 936223 │└DISTRIBUTE GATHER
30000 936223 │ TABLE SCAN movie_info WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English')
4 1190608 TABLE SCAN movie_companies WHERE mc.note IS NULL
|
|
1 1 AGGREGATE MIN(name as name) AS Expr1018, MIN(link as link) AS Expr1019, MIN(title as title) AS Expr1020
5 1874 INNER JOIN LOOP ON Bmk1016 = Bmk1016
0 1874 │└TABLE SEEK title AS t WHERE production_year as production_year >= 1950 AND production_year as production_year <= 2010
7 1874 PROJECT BmkToPage Bmk1016 AS Expr1071
7 1874 INNER JOIN LOOP ON ml.movie_id = t.id
1 1874 │└TABLE SEEK title AS t
7 1874 FILTER (name as name LIKE '%Film%' OR name as name LIKE '%Warner%') AND country_code as country_code <> 'pl'
7 4395 INNER JOIN LOOP ON Bmk1000 = Bmk1000
1 4395 │└TABLE SEEK company_name AS cn
7 4395 INNER JOIN LOOP ON mc.company_id = cn.id
1 4395 │└TABLE SEEK company_name AS cn
7 4395 FILTER kind as kind = 'production companies'
15 4602 INNER JOIN LOOP ON Bmk1002 = Bmk1002
1 4602 │└TABLE SEEK company_type AS ct
15 4602 INNER JOIN LOOP ON mc.company_type_id = ct.id
1 4602 │└TABLE SEEK company_type AS ct
15 4602 FILTER note as note IS NULL
32 6100 INNER JOIN LOOP ON Bmk1008 = Bmk1008
1 6100 │└TABLE SEEK movie_companies AS mc
32 6100 PROJECT BmkToPage Bmk1008 AS Expr1069
32 6100 INNER JOIN LOOP ON ml.movie_id = mc.movie_id
9 6100 │└TABLE SEEK movie_companies AS mc
3 746 INNER JOIN LOOP ON ml.movie_id = mi.movie_id
3 746 │└TABLE SEEK movie_info AS mi WHERE info as info = 'Denish' OR info as info = 'Denmark' OR info as info = 'English' OR info as info = 'German' OR info as info = 'Germany' OR info as info = 'Norway' OR info as info = 'Norwegian' OR info as info = 'Sweden' OR info as info = 'Swedish'
1 199 FILTER link as link LIKE '%follow%'
7 251 INNER JOIN LOOP ON Bmk1006 = Bmk1006
1 251 │└TABLE SEEK link_type AS lt
7 251 INNER JOIN LOOP ON ml.link_type_id = lt.id
1 251 │└TABLE SEEK link_type AS lt
7 251 INNER JOIN HASH ON ml.movie_id = mk.movie_id
90 10544 │└INNER JOIN LOOP ON Bmk1012 = Bmk1012
1 10544 │ │└TABLE SEEK movie_keyword AS mk
90 10544 │ INNER JOIN LOOP ON k.id = mk.keyword_id
90 10544 │ │└TABLE SEEK movie_keyword AS mk
1 1 │ TABLE SCAN keyword AS k WHERE keyword as keyword = 'sequel'
2 250 TABLE SEEK movie_link AS ml WHERE BLOOM(movie_id as movie_id)
|
|
1 ∞ PROJECT min AS company_name, min_39 AS link_type, min_40 AS western_follow_up
1 1 AGGREGATE MIN(min_41) AS min, MIN(min_42) AS min_39, MIN(min_43) AS min_40
- 16 DISTRIBUTE GATHER
- 16 AGGREGATE MIN(name) AS min_41, MIN(link) AS min_42, MIN(title) AS min_43
- 1874 INNER JOIN HASH ON movie_id = id_32
1060238 1900368 │└DISTRIBUTE HASH ON id_32
1060238 1900368 │ PROJECT id AS id_32, title
1060238 1900368 │ FILTER production_year BETWEEN 1950 AND 2010
1060238 1900368 │ TABLE SCAN title
- 1874 INNER JOIN HASH ON link_type_id = id_8
18 2 │└DISTRIBUTE GATHER
18 2 │ PROJECT id AS id_8, link
18 2 │ FILTER link LIKE '%follow%'
18 2 │ TABLE SCAN link_type
- 1874 INNER JOIN HASH ON movie_id = movie_id_28
29997 2315 │└DISTRIBUTE GATHER
29997 2315 │ PROJECT movie_id AS movie_id_28, link_type_id
29997 2315 │ TABLE SCAN movie_link
- 106 INNER JOIN HASH ON keyword_id = id_4
134170 1 │└DISTRIBUTE GATHER
134170 1 │ PROJECT id AS id_4
134170 1 │ FILTER keyword = 'sequel'
134170 1 │ TABLE SCAN keyword
- 106 INNER JOIN HASH ON movie_id = movie_id_23
4523930 30 │└DISTRIBUTE HASH ON movie_id_23
4523930 30 │ PROJECT movie_id AS movie_id_23, keyword_id
4523930 30 │ TABLE SCAN movie_keyword
- 106 INNER JOIN HASH ON movie_id = movie_id_17
13352148 57 │└DISTRIBUTE HASH ON movie_id_17
13352148 57 │ PROJECT movie_id AS movie_id_17
13352148 57 │ FILTER info IN('Denish','Denmark','English','German','Germany','Norway','Norwegian','Sweden','Swedish')
13352148 57 │ TABLE SCAN movie_info
- 26 INNER JOIN HASH ON company_type_id = id_0
4 1 │└DISTRIBUTE GATHER
4 1 │ PROJECT id AS id_0
4 1 │ FILTER kind = 'production companies'
4 1 │ TABLE SCAN company_type
- 26 INNER JOIN HASH ON company_id = id
94983 48302 │└DISTRIBUTE GATHER
94983 48302 │ FILTER (country_code <> 'pl') AND ((name LIKE '%Film%') OR (name LIKE '%Warner%'))
94983 48302 │ TABLE SCAN company_name
1271989 26 FILTER note IS NULL
1271989 26 TABLE SCAN movie_companies
|
|
1 1 AGGREGATE MIN(name), MIN(link), MIN(title)
1 1874 INNER JOIN LOOP ON id = movie_id AND movie_id = id AND (movie_id = id)
1 1874 │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = movie_id AND (movie_id = movie_id)
1 402 │ │└INNER JOIN LOOP ON id = company_type_id
1 422 │ │ │└INNER JOIN LOOP ON id = company_id
1 1021 │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id AND movie_id = movie_id AND (movie_id = movie_id)
1 199 │ │ │ │ │└INNER JOIN LOOP ON keyword = 'sequel' AND id = link_type_id AND (id = link_type_id)
1 2 │ │ │ │ │ │└TABLE SCAN link_type AS lt WHERE lt.link LIKE '%follow%'
20 502 │ │ │ │ │ INNER JOIN LOOP ON movie_id = movie_id
68 21088 │ │ │ │ │ │└INNER JOIN LOOP ON keyword_id = id
2 2 │ │ │ │ │ │ │└TABLE SEEK keyword AS k
610 21088 │ │ │ │ │ │ TABLE SEEK movie_keyword AS mk
105440 21088 │ │ │ │ │ TABLE SEEK movie_link AS ml
398 1020 │ │ │ │ TABLE SEEK movie_companies AS mc WHERE mc.note IS NULL
1021 1021 │ │ │ TABLE SEEK company_name AS cn WHERE (cn.country_code <> 'pl') AND ((cn.name LIKE '%Film%') OR (cn.name LIKE '%Warner%'))
422 422 │ │ TABLE SEEK company_type AS ct WHERE ct.kind = 'production companies'
1206 1873 │ TABLE SEEK movie_info AS mi WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German','English')
1874 1874 TABLE SEEK title AS t WHERE (t.production_year >= 1950) AND (t.production_year <= 2010)
|
