Planner — IMDB — JOB-15C

SELECT MIN(mi.info) AS release_date,
       MIN(t.title) AS modern_american_internet_movie
FROM job.aka_title AS aka_t,
     job.company_name AS cn,
     job.company_type AS ct,
     job.info_type AS it1,
     job.keyword AS k,
     job.movie_companies AS mc,
     job.movie_info AS mi,
     job.movie_keyword AS mk,
     job.title AS t
WHERE cn.country_code = '[us]'
  AND it1.info = 'release dates'
  AND mi.note LIKE '%internet%'
  AND mi.info IS NOT NULL
  AND (mi.info LIKE 'USA:% 199%'
       OR mi.info LIKE 'USA:% 200%')
  AND t.production_year > 1990
  AND t.id = aka_t.movie_id
  AND t.id = mi.movie_id
  AND t.id = mk.movie_id
  AND t.id = mc.movie_id
  AND mk.movie_id = mi.movie_id
  AND mk.movie_id = mc.movie_id
  AND mk.movie_id = aka_t.movie_id
  AND mi.movie_id = mc.movie_id
  AND mi.movie_id = aka_t.movie_id
  AND mc.movie_id = aka_t.movie_id
  AND k.id = mk.keyword_id
  AND it1.id = mi.info_type_id
  AND cn.id = mc.company_id
  AND ct.id = mc.company_type_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 4,689,840 4.7M Rank		Estimation Error Est Err 4,560,818 4.6M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 151,068 151K Rank	Estimation Error Est Err 2,271 2.3K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 9,379,428 9.4M 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 9,446,718 9.4M Rank		Estimation Error Est Err 13,528,802 14M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 4,974,430 5M Rank	Estimation Error Est Err 2,272 2.3K Rank	Estimation Error Est Err 585,112 585K Rank
Estimation Error Est Err 13,604,673 14M Rank		Estimation Error Est Err 11,592,594 12M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 3,837,255 3.8M Rank	Estimation Error Est Err 2,281 2.3K Rank	Estimation Error Est Err 3,822,417 3.8M Rank
Estimation Error Est Err 4,806,426 4.8M Rank		Estimation Error Est Err 4,990,648 5M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 3,158,839 3.2M Rank	Estimation Error Est Err 2,271 2.3K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 33,235 33K Rank	Estimation Error Est Err 33,235 33K Rank	Estimation Error Est Err 36,116 36K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 36,110 36K Rank	Estimation Error Est Err 2,271 2.3K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 14,057 14K Rank	Estimation Error Est Err 13,944 14K Rank	Estimation Error Est Err 15,606 16K Rank	Estimation Error Est Err 5,280 5.3K Rank	Estimation Error Est Err 13,944 14K Rank	Estimation Error Est Err 3,589 3.6K Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 6,494,057 6.5M Rank		Estimation Error Est Err 8,200 8.2K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 6,494,588 6.5M Rank	Estimation Error Est Err 2,287 2.3K Rank	Estimation Error Est Err 6,493,894 6.5M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min 127215 2271 INNER JOIN HASH ON id = keyword_id 134170 134170 │└TABLE SCAN keyword 132655 2271 INNER JOIN HASH ON movie_id74 = movie_id41 8720 284 │└INNER JOIN HASH ON movie_id41 = movie_id59 6740 2647 │ │└INNER JOIN HASH ON id7 = company_type_id 4 4 │ │ │└TABLE SCAN company_type 1318 2647 │ │ INNER JOIN HASH ON id48 = company_id 3590 2884 │ │ │└INNER JOIN HASH ON id25 = movie_id41 4190 1782 │ │ │ │└INNER JOIN HASH ON id12 = info_type_id 1 1 │ │ │ │ │└TABLE SCAN info_type WHERE info = release dates 4190 1782 │ │ │ │ INNER JOIN HASH ON id25 = movie_id 5154 1783 │ │ │ │ │└TABLE SCAN movie_info WHERE info) USA : AND note LIKE '%internet%' AND info20 LIKE '% 199%' OR info20 LIKE '% 200%' 1757966 1766 │ │ │ │ TABLE SCAN title WHERE production_year >= 1991 2076277 2842 │ │ │ TABLE SCAN movie_companies 90648 25238 │ │ TABLE SCAN company_name WHERE country_code = us 361379 106 │ TABLE SCAN aka_title 4523930 4523930 TABLE SCAN movie_keyword
	Estimate Actual Operator - ∞ PROJECT a1 AS release_date, a2 AS modern_american_internet_movie - ∞ AGGREGATE MIN(info) AS a1, MIN(title) AS a2 - ∞ PROJECT info, title - ∞ PROJECT info, title - ∞ INNER JOIN HASH ON PROJECTION_967.id = PROJECTION_922.keyword_id - ∞ │└PROJECT keyword_id, info, title - ∞ │ PROJECT info, keyword_id, title - ∞ │ INNER JOIN HASH ON tuple(PROJECTION_964.movie_id,PROJECTION_964.movie_id,PROJECTION_964.movie_id,PROJECTION_964.movie_id) = tuple(PROJECTION_925.movie_id,PROJECTION_925.movie_id,PROJECTION_925.movie_id,PROJECTION_925.id) - ∞ │ │└PROJECT movie_id_right, movie_id_right_2, movie_id AS movie_id_right_3, id, info, title - ∞ │ │ PROJECT movie_id, movie_id, info, movie_id, title, id - ∞ │ │ INNER JOIN HASH ON tuple(PROJECTION_961.id,PROJECTION_961.id,PROJECTION_961.id) = tuple(PROJECTION_928.movie_id,PROJECTION_928.movie_id,PROJECTION_928.movie_id) - ∞ │ │ │└PROJECT movie_id, movie_id, movie_id, info - ∞ │ │ │ PROJECT movie_id, movie_id, info, movie_id - ∞ │ │ │ INNER JOIN HASH ON PROJECTION_958.id = PROJECTION_931.company_id - ∞ │ │ │ │└PROJECT company_id, movie_id, movie_id, info, movie_id - ∞ │ │ │ │ PROJECT movie_id, movie_id, company_id, info, movie_id - ∞ │ │ │ │ INNER JOIN HASH ON PROJECTION_955.id = PROJECTION_934.company_type_id - ∞ │ │ │ │ │└PROJECT company_type_id, movie_id, movie_id, company_id, info, movie_id - ∞ │ │ │ │ │ PROJECT movie_id, movie_id, company_id, company_type_id, info, movie_id - ∞ │ │ │ │ │ INNER JOIN HASH ON tuple(PROJECTION_952.movie_id,PROJECTION_952.movie_id) = tuple(PROJECTION_937.movie_id,PROJECTION_937.movie_id) - ∞ │ │ │ │ │ │└PROJECT movie_id_right, movie_id AS movie_id_right_2, info - ∞ │ │ │ │ │ │ PROJECT movie_id, info, movie_id - ∞ │ │ │ │ │ │ INNER JOIN HASH ON PROJECTION_949.movie_id = PROJECTION_940.movie_id - ∞ │ │ │ │ │ │ │└PROJECT movie_id AS movie_id_right, info - ∞ │ │ │ │ │ │ │ PROJECT info, movie_id - ∞ │ │ │ │ │ │ │ INNER JOIN HASH ON PROJECTION_946.info_type_id = PROJECTION_943.id - 1 │ │ │ │ │ │ │ │└PROJECT id - 1 │ │ │ │ │ │ │ │ FILTER (1 AND info = 'release dates'_String) AS a40 - 1 │ │ │ │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' - ∞ │ │ │ │ │ │ │ PROJECT info_type_id, info, movie_id - ∞ │ │ │ │ │ │ │ FILTER ( LIKE (note,'%internet%'_String) AND 1 AND OR ( LIKE (info,'USA:% 199%'_String), LIKE (info,'USA:% 200%'_String))) AS a26 - 1783 │ │ │ │ │ │ │ TABLE SCAN movie_info WHERE note LIKE '%internet%' AND (info LIKE 'USA:% 199%' OR info LIKE 'USA:% 200%') - 361379 │ │ │ │ │ │ PROJECT movie_id AS movie_id_left - 361379 │ │ │ │ │ │ PROJECT movie_id - 361379 │ │ │ │ │ │ TABLE SCAN aka_title - 2609129 │ │ │ │ │ PROJECT movie_id AS movie_id_left, company_id, company_type_id - 2609129 │ │ │ │ │ PROJECT movie_id, company_id, company_type_id - 2609129 │ │ │ │ │ TABLE SCAN movie_companies - 4 │ │ │ │ PROJECT id - 4 │ │ │ │ PROJECT id - 4 │ │ │ │ TABLE SCAN company_type - 0 │ │ │ PROJECT id - 0 │ │ │ FILTER (1 AND country_code = 'us'_String) AS a16 - 0 │ │ │ TABLE SCAN company_name WHERE country_code = 'us' - 1749032 │ │ PROJECT id, title - 1749032 │ │ FILTER (1 AND production_year > 1990_UInt16) AS a11 - 1749032 │ │ TABLE SCAN title WHERE production_year > 1990 - 4523930 │ PROJECT movie_id AS movie_id_left, keyword_id - 4523930 │ PROJECT movie_id, keyword_id - 4523930 │ TABLE SCAN movie_keyword - 134170 PROJECT id - 134170 PROJECT id - 134170 TABLE SCAN keyword
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1) 21 2271 PROJECT info, title 21 2271 INNER JOIN HASH ON id = keyword_id 20 2271 │└INNER JOIN HASH ON movie_id = movie_id 11 284 │ │└INNER JOIN HASH ON company_type_id = id 4 2 │ │ │└TABLE SCAN company_type WHERE id <= 2 11 284 │ │ INNER JOIN HASH ON info_type_id = id 2 1 │ │ │└FILTER id <= 110 2 1 │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 645 284 │ │ INNER JOIN HASH ON movie_id = movie_id 540 218489 │ │ │└INNER JOIN HASH ON id = movie_id 2655 627946 │ │ │ │└INNER JOIN HASH ON movie_id = movie_id 18253 1153647 │ │ │ │ │└INNER JOIN HASH ON company_id = id 1644 84843 │ │ │ │ │ │└TABLE SCAN company_name WHERE country_code = 'us' 2609129 2608947 │ │ │ │ │ TABLE SCAN movie_companies WHERE movie_id >= 50 AND movie_id <= 2525672 361379 361379 │ │ │ │ TABLE SCAN aka_title 505662 1748361 │ │ │ FILTER id BETWEEN 50 AND 2525672 505662 1748997 │ │ │ TABLE SCAN title WHERE production_year > 1990 2967144 77 │ │ FILTER movie_id BETWEEN 50 AND 2525672 2967144 77 │ │ TABLE SCAN movie_info WHERE contains(note,'internet') AND (info IS NOT NULL) AND ((info LIKE 'USA:% 199%') OR (info LIKE 'USA:% 200%')) 4523930 1535 │ TABLE SCAN movie_keyword WHERE movie_id >= 50 AND movie_id <= 2525672 134170 645 TABLE SCAN keyword
	Estimate Actual Operator 1 1 PROJECT release_date, modern_american_internet_movie 1 1 AGGREGATE MIN(info), MIN(title) 15112 10 DISTRIBUTE GATHER 15112 10 AGGREGATE MIN(info), MIN(title) 15112 2271 INNER JOIN HASH ON movie_id = CAST(t.id AS Int64) AND movie_id = id AND movie_id = id AND movie_id = id 15112 2271 │└DISTRIBUTE GATHER 15112 2271 │ INNER JOIN HASH ON keyword_id = id 15112 2271 │ │└DISTRIBUTE GATHER 15112 2271 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = CAST(mk.movie_id AS Int64) 15112 284 │ │ │└DISTRIBUTE GATHER 15112 284 │ │ │ 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' 72276 284 │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = CAST(mi.movie_id AS Int64) 72276 627946 │ │ │ │└DISTRIBUTE GATHER 72276 627946 │ │ │ │ INNER JOIN HASH ON id = company_type_id 4 4 │ │ │ │ │└TABLE SCAN company_type 72276 627946 │ │ │ │ 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' 361379 1946320 │ │ │ │ INNER JOIN HASH ON movie_id = CAST(mc.movie_id AS Int64) 361379 361379 │ │ │ │ │└DISTRIBUTE HASH ON movie_id 361379 361379 │ │ │ │ │ TABLE SCAN aka_title 2609129 2609129 │ │ │ │ DISTRIBUTE HASH ON CAST(mc.movie_id AS Int64) 2609129 2609129 │ │ │ │ TABLE SCAN movie_companies WHERE (CASE MOD(HASH_REPARTITION(CAST(movie_id AS INT64)),10) WHEN 0 THEN (((CAST(movie_id AS INT64) >= 826) AND (CAST(movie_id AS INT64) <= 2525588)) AND TRUE) WHEN 1 THEN (((CAST(movie_id AS INT64) >= 596) AND (CAST(movie_id AS INT64) <= 2525544)) AND TRUE) WHEN 2 THEN (((CAST(movie_id AS INT64) >= 902) AND (CAST(movie_id AS INT64) <= 2525574)) AND TRUE) WHEN 3 THEN (((CAST(movie_id AS INT64) >= 2255) AND (CAST(movie_id AS INT64... 2967144 1783 │ │ │ PROJECT movie_id, info_type_id, info, CAST(movie_id AS INT64) 2967144 1783 │ │ │ FILTER (note LIKE '%internet%' AND info IS NOT NULL) AND (info LIKE 'USA:% 199%' OR info LIKE 'USA:% 200%') 14835720 3212639 │ │ │ TABLE SCAN movie_info WHERE (((note LIKE '%internet%' AND info IS NOT NULL) AND (info LIKE 'USA:% 199%' OR info LIKE 'USA:% 200%')) AND ((((movie_id >= 50) AND (movie_id <= 2525593)) AND ((CAST(movie_id AS INT64) >= 50) AND (CAST(movie_id AS INT64) <= 2525593))) AND TRUE)) AND (((info_type_id >= 16) AND (info_type_id <= 16)) AND info_type_id IN 16) 4523930 4523930 │ │ TABLE SCAN movie_keyword WHERE ((((movie_id >= 9133) AND (movie_id <= 2522473)) AND ((movie_id >= 9133) AND (movie_id <= 2522473))) AND ((CAST(movie_id AS INT64) >= 9133) AND (CAST(movie_id AS INT64) <= 2522473))) AND struct(movie_id,movie_id,CAST(movie_id AS INT64)) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > ,... 134170 134170 │ DISTRIBUTE ROUND ROBIN 134170 134170 │ TABLE SCAN keyword WHERE ((id >= 1) AND (id <= 133880)) AND TRUE 523722 1749032 PROJECT id, title, CAST(id AS INT64) 523722 1749032 FILTER production_year > 1990 2528312 2528312 TABLE SCAN title WHERE (production_year > 1990) AND ((((((CAST(id AS INT64) >= 9133) AND (CAST(id AS INT64) <= 2518397)) AND ((id >= 9133) AND (id <= 2518397))) AND ((id >= 9133) AND (id <= 2518397))) AND ((id >= 9133) AND (id <= 2518397))) AND struct(CAST(id AS INT64),id,id,id) IN( < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr > , < expr...
	Estimate Actual Operator 1 1 AGGREGATE MIN(mi.info), MIN(t.title) 1 1 DISTRIBUTE GATHER 1 1 AGGREGATE MIN(mi.info), MIN(t.title) 237000 2271 INNER JOIN HASH ON aka_t.movie_id = mk.movie_id 237000 284 │└DISTRIBUTE GATHER 113000 284 │ INNER JOIN HASH ON mc.movie_id = aka_t.movie_id 113000 2647 │ │└DISTRIBUTE GATHER 516000 2647 │ │ INNER JOIN HASH ON mc.company_id = cn.id 516000 84843 │ │ │└DISTRIBUTE GATHER 4 84843 │ │ │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us') 516000 2884 │ │ INNER JOIN HASH ON mc.company_type_id = ct.id 516000 4 │ │ │└DISTRIBUTE GATHER 235000 4 │ │ │ TABLE SCAN company_type 202000 2884 │ │ INNER JOIN HASH ON mi.movie_id = mc.movie_id 202000 1783 │ │ │└DISTRIBUTE GATHER 192000 1783 │ │ │ INNER JOIN HASH ON mi.info_type_id = it1.id 192000 1 │ │ │ │└DISTRIBUTE GATHER 361000 1 │ │ │ │ TABLE SCAN info_type WHERE it1.info = 'release dates' 134000 1783 │ │ │ TABLE SCAN movie_info WHERE (mi.note IS NOT NULL) AND contains(mi.note,'internet') AND (mi.info LIKE 'USA:% 199%' OR mi.info LIKE 'USA:% 200%') 4520000 2605035 │ │ TABLE SCAN movie_companies 12100 140974 │ INNER JOIN HASH ON aka_t.movie_id = t.id 12100 361379 │ │└DISTRIBUTE GATHER 2530000 361379 │ │ TABLE SCAN aka_title WHERE aka_t.movie_id IS NOT NULL 2610000 1743764 │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 1990L) 108000 4515739 INNER JOIN HASH ON mk.keyword_id = k.id 108000 134170 │└DISTRIBUTE GATHER 113 134170 │ TABLE SCAN keyword 14800000 4515739 TABLE SCAN movie_keyword
	Estimate Actual Operator 1 1 AGGREGATE MIN(partialagg1040) AS Expr1018, MIN(partialagg1041) AS Expr1019 1 95 FILTER country_code as country_code = 'us' 1 140 INNER JOIN LOOP ON Bmk1002 = Bmk1002 1 140 │└TABLE SEEK company_name AS cn 1 140 INNER JOIN LOOP ON mc.company_id = cn.id 1 140 │└TABLE SEEK company_name AS cn 1 140 AGGREGATE MIN(info as info) AS partialagg1040, MIN(title as title) AS partialagg1041 GROUP BY SORT company_id 3333 3494 SORT company_id 3333 3494 INNER JOIN LOOP ON Bmk1010 = Bmk1010 1 3494 │└TABLE SEEK movie_companies AS mc 3333 3494 PROJECT BmkToPage Bmk1010 AS Expr1049 3333 3494 INNER JOIN LOOP ON t.id = mc.movie_id 9 3494 │└TABLE SEEK movie_companies AS mc 336 1199 INNER JOIN LOOP ON t.id = mk.movie_id 18 1199 │└TABLE SEEK movie_keyword AS mk 18 123 INNER JOIN LOOP ON t.id = aka_t.movie_id 1 123 │└TABLE SEEK aka_title AS aka_t 16 1784 INNER JOIN LOOP ON Bmk1016 = Bmk1016 0 1784 │└TABLE SEEK title AS t WHERE production_year as production_year > 1990 24 1785 PROJECT BmkToPage Bmk1016 AS Expr1047 24 1785 INNER JOIN LOOP ON mi.movie_id = t.id 1 1785 │└TABLE SEEK title AS t 24 1785 INNER JOIN MERGE ON id as id = info_type_id as info_type_id 1 1 │└SORT id 1 1 │ FILTER info as info = 'release dates' 113 113 │ TABLE SCAN info_type AS it1 1690 1785 SORT info_type_id 1690 1785 TABLE SEEK movie_info AS mi WHERE note as note LIKE '%internet%' AND (info as info LIKE 'USA:% 199%' OR info as info LIKE 'USA:% 200%')
	Estimate Actual Operator 1 ∞ PROJECT min AS release_date, min_50 AS modern_american_internet_movie 1 1 AGGREGATE MIN(min_51) AS min, MIN(min_52) AS min_50 - 16 DISTRIBUTE GATHER - 16 AGGREGATE MIN(info_26) AS min_51, MIN(title_37) AS min_52 - 2271 INNER JOIN HASH ON movie_id_19 = id_36 512448 1749032 │└DISTRIBUTE HASH ON id_36 512448 1749032 │ PROJECT id AS id_36, title AS title_37 512448 1749032 │ FILTER production_year > 1990 512448 1749032 │ TABLE SCAN title - 2271 INNER JOIN HASH ON keyword_id = id_13 134170 134170 │└DISTRIBUTE GATHER 134170 134170 │ PROJECT id AS id_13 134170 134170 │ TABLE SCAN keyword - 2271 INNER JOIN HASH ON movie_id_19 = movie_id_32 4523930 4523930 │└DISTRIBUTE HASH ON movie_id_32 4523930 4523930 │ PROJECT movie_id AS movie_id_32, keyword_id 4523930 4523930 │ TABLE SCAN movie_keyword - 284 INNER JOIN HASH ON info_type_id = id_9 113 1 │└DISTRIBUTE GATHER 113 1 │ PROJECT id AS id_9 113 1 │ FILTER info = 'release dates' 113 1 │ TABLE SCAN info_type - 284 INNER JOIN HASH ON movie_id_19 = movie_id_25 13352148 1783 │└DISTRIBUTE HASH ON movie_id_25 13352148 1783 │ PROJECT movie_id AS movie_id_25, info_type_id, info AS info_26 13352148 1783 │ FILTER (info >= 'USA:') AND (info < 'USA;') AND (note LIKE '%internet%') AND ((info LIKE 'USA:% 199%') OR (info LIKE 'USA:% 200%')) 13352148 1783 │ TABLE SCAN movie_info - 273 INNER JOIN HASH ON company_type_id = id_5 4 4 │└DISTRIBUTE GATHER 4 4 │ PROJECT id AS id_5 4 4 │ TABLE SCAN company_type - 273 INNER JOIN HASH ON company_id = id_0 234997 84843 │└DISTRIBUTE GATHER 234997 84843 │ PROJECT id AS id_0 234997 84843 │ FILTER country_code = 'us' 234997 84843 │ TABLE SCAN company_name - 273 INNER JOIN HASH ON movie_id_19 = movie_id 361379 115 │└DISTRIBUTE GATHER 361379 115 │ TABLE SCAN aka_title 2609129 179 PROJECT movie_id AS movie_id_19, company_id, company_type_id 2609129 179 TABLE SCAN movie_companies
	Estimate Actual Operator 1 1 AGGREGATE MIN(info), MIN(title) 158 2271 INNER JOIN LOOP ON movie_id = id 58 7964 │└INNER JOIN LOOP ON id = keyword_id 58 7964 │ │└INNER JOIN LOOP ON movie_id = id 5 2647 │ │ │└INNER JOIN LOOP ON id = company_id 13 2884 │ │ │ │└INNER JOIN LOOP ON id = company_type_id 14 2884 │ │ │ │ │└INNER JOIN LOOP ON movie_id = id 3 1782 │ │ │ │ │ │└INNER JOIN LOOP ON id = movie_id 4 1783 │ │ │ │ │ │ │└INNER JOIN LOOP ON info_type_id = id 1 1 │ │ │ │ │ │ │ │└TABLE SEEK info_type AS it1 6 1783 │ │ │ │ │ │ │ TABLE SEEK movie_info AS mi WHERE (mi.note LIKE '%internet%') AND ((mi.info LIKE 'USA:% 199%') OR (mi.info LIKE 'USA:% 200%')) 1783 1783 │ │ │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 1990 8910 2886 │ │ │ │ │ TABLE SEEK movie_companies AS mc 2 2 │ │ │ │ TABLE SEEK company_type AS ct 2884 2884 │ │ │ TABLE SEEK company_name AS cn WHERE cn.country_code = 'us' 119115 7967 │ │ TABLE SEEK movie_keyword AS mk 7964 7964 │ TABLE SEEK keyword AS k 23892 7964 TABLE SEEK aka_title AS aka_t