|
1 1 AGGREGATE min, min, min
1 1410 INNER JOIN HASH ON company_type_id = id
1 1 │└TABLE SCAN company_type WHERE kind = production companies
1 1505 INNER JOIN HASH ON company_id = id61
2 3124 │└INNER JOIN HASH ON movie_id54 = movie_id31
1 517 │ │└INNER JOIN HASH ON movie_id31 = id38
1 684 │ │ │└INNER JOIN HASH ON movie_id = movie_id31
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
101416 40 │ │ │ TABLE SCAN movie_info WHERE info BETWEEN Denish AND Swedish AND info IN(Denish,Denmark,German,Germany,Norway,Norwegian,Sweden,Swedish)
886390 8 │ │ TABLE SCAN title WHERE production_year BETWEEN 1950 AND 2000
1203251 38 │ TABLE SCAN movie_companies WHERE note IS NULL
51405 8 TABLE SCAN company_name WHERE name LIKE '%Film%' OR name LIKE '%Warner%' AND country_code <> pl
|
|
- ∞ 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_2132.__lhs_const = PROJECTION_2129.__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_2138.__lhs_const = PROJECTION_2135.__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_2144.__lhs_const = PROJECTION_2141.__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_2150.__lhs_const = PROJECTION_2147.__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_2156.__lhs_const = PROJECTION_2153.__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_2162.__lhs_const = PROJECTION_2159.__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 1410 PROJECT name, link, title
0 1410 INNER JOIN HASH ON movie_id = movie_id
0 310 │└INNER JOIN HASH ON id = company_type_id
0 330 │ │└INNER JOIN HASH ON id = company_id
0 705 │ │ │└INNER JOIN HASH ON movie_id = movie_id
0 152 │ │ │ │└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 30 │ │ │ │ FILTER id BETWEEN 2 AND 186175
505662 31 │ │ │ │ TABLE SCAN title WHERE production_year >= 1950 AND production_year <= 2000
521825 76 │ │ │ FILTER movie_id <= 186175
521825 76 │ │ │ TABLE SCAN movie_companies WHERE note IS NULL
46999 11 │ │ 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 31 FILTER movie_id BETWEEN 2 AND 186175
2967144 31 FILTER IN ...
14835720 217 INNER JOIN HASH ON info = #0
0 8 │└SCAN MATERIALISED
14835720 217 TABLE SCAN movie_info WHERE info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German')
|
|
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 1410 INNER JOIN HASH ON movie_id = id AND movie_id = id AND movie_id = id AND movie_id = id
6313 1816 │└DISTRIBUTE GATHER
6313 1816 │ PROJECT name, movie_id, movie_id, movie_id, movie_id, link
6313 1816 │ 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 1816 │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = movie_id
26834 952 │ │└DISTRIBUTE GATHER
26834 952 │ │ 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 446140 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id
61285 61621 │ │ │└DISTRIBUTE GATHER
61285 61621 │ │ │ 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 153897 │ │ │ FILTER info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German')
14835720 9042947 │ │ │ TABLE SCAN movie_info WHERE info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German') AND (((movie_id >= 50) AND (movie_id <= 2525744)) AND TRUE)
4523930 4523930 │ │ TABLE SCAN movie_keyword WHERE ((((movie_id >= 870) AND (movie_id <= 2525727)) AND ((movie_id >= 870) AND (movie_id <= 2525727))) 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))
921028 736454 FILTER (production_year >= 1950) AND (production_year <= 2000)
2528312 2036792 TABLE SCAN title WHERE ((production_year >= 1950) AND (production_year <= 2000)) 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 1410 INNER JOIN HASH ON mk.movie_id = mc.movie_id
886 152 │└DISTRIBUTE GATHER
886 152 │ 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 196 │ INNER JOIN HASH ON mk.movie_id = ml.movie_id
199 5541 │ │└DISTRIBUTE GATHER
75 5541 │ │ 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 906840 │ │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year >= 1950L) AND (t.production_year <= 2000L)
134000 25902 │ TABLE SCAN movie_link
886 61621 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 155016 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 155016 INNER JOIN HASH ON mc.movie_id = mi.movie_id
192 153897 │└DISTRIBUTE GATHER
30000 153897 │ TABLE SCAN movie_info WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German')
4 1190475 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
1 1410 FILTER (name as name LIKE '%Film%' OR name as name LIKE '%Warner%') AND country_code as country_code <> 'pl'
2 3029 INNER JOIN LOOP ON Bmk1000 = Bmk1000
1 3029 │└TABLE SEEK company_name AS cn
2 3029 INNER JOIN LOOP ON mc.company_id = cn.id
1 3029 │└TABLE SEEK company_name AS cn
2 3029 FILTER kind as kind = 'production companies'
4 3124 INNER JOIN LOOP ON Bmk1002 = Bmk1002
1 3124 │└TABLE SEEK company_type AS ct
4 3124 INNER JOIN LOOP ON mc.company_type_id = ct.id
1 3124 │└TABLE SEEK company_type AS ct
4 3124 FILTER note as note IS NULL
9 3732 INNER JOIN LOOP ON Bmk1008 = Bmk1008
1 3732 │└TABLE SEEK movie_companies AS mc
9 3732 PROJECT BmkToPage Bmk1008 AS Expr1073
9 3732 INNER JOIN LOOP ON t.id = mc.movie_id
9 3732 │└TABLE SEEK movie_companies AS mc
1 517 INNER JOIN LOOP ON Bmk1016 = Bmk1016
1 517 │└TABLE SEEK title AS t WHERE production_year as production_year >= 1950 AND production_year as production_year <= 2000
1 684 PROJECT BmkToPage Bmk1016 AS Expr1072
1 684 INNER JOIN LOOP ON ml.movie_id = t.id
1 684 │└TABLE SEEK title AS t
1 684 INNER JOIN LOOP ON ml.movie_id = mi.movie_id
1 684 │└TABLE SEEK movie_info AS mi WHERE info as info = 'Denish' OR info as info = 'Denmark' 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
- 1410 INNER JOIN HASH ON movie_id = id_32
883532 910581 │└DISTRIBUTE HASH ON id_32
883532 910581 │ PROJECT id AS id_32, title
883532 910581 │ FILTER production_year BETWEEN 1950 AND 2000
883532 910581 │ TABLE SCAN title
- 1816 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
- 1816 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
- 100 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
- 100 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
- 100 INNER JOIN HASH ON movie_id = movie_id_17
13352148 40 │└DISTRIBUTE HASH ON movie_id_17
13352148 40 │ PROJECT movie_id AS movie_id_17
13352148 40 │ FILTER info IN('Denish','Denmark','German','Germany','Norway','Norwegian','Sweden','Swedish')
13352148 40 │ TABLE SCAN movie_info
- 23 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
- 23 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 23 FILTER note IS NULL
1271989 23 TABLE SCAN movie_companies
|
|
1 1 AGGREGATE MIN(name), MIN(link), MIN(title)
1 1410 INNER JOIN LOOP ON id = movie_id AND movie_id = id AND (movie_id = id)
1 1816 │└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'
402 1817 │ TABLE SEEK movie_info AS mi WHERE mi.info IN('Sweden','Norway','Germany','Denmark','Swedish','Denish','Norwegian','German')
1816 1816 TABLE SEEK title AS t WHERE (t.production_year >= 1950) AND (t.production_year <= 2000)
|
