Planner — IMDB — JOB-15A

SELECT MIN(mi.info) AS release_date,
       MIN(t.title) AS 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 mc.note LIKE '%(200%)%'
  AND mc.note LIKE '%(worldwide)%'
  AND mi.note LIKE '%internet%'
  AND mi.info LIKE 'USA:% 200%'
  AND t.production_year > 2000
  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,673,132 4.7M Rank		Estimation Error Est Err 4,673,520 4.7M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 8,668 8.7K Rank	Estimation Error Est Err 328 328 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 6,464,372 6.5M Rank		Estimation Error Est Err 361,647 362K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 6,103,065 6.1M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 6,549,198 6.5M Rank		Estimation Error Est Err 10,640,449 11M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 5,079,506 5.1M Rank	Estimation Error Est Err 337 337 Rank	Estimation Error Est Err 6,531,454 6.5M Rank
Estimation Error Est Err 13,604,673 14M Rank		Estimation Error Est Err 6,137,723 6.1M Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 475,137 475K Rank	Estimation Error Est Err 338 338 Rank	Estimation Error Est Err 656,914 657K Rank
Estimation Error Est Err 160,862 161K Rank		Estimation Error Est Err 79,437 79K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 143,233 143K Rank	Estimation Error Est Err 328 328 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 186,714 187K Rank	Estimation Error Est Err 125,050 125K Rank	Estimation Error Est Err 125,104 125K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 125,104 125K Rank	Estimation Error Est Err 332 332 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 69,557 70K Rank	Estimation Error Est Err 2,531 2.5K Rank	Estimation Error Est Err 90,148 90K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 64,195 64K Rank	Estimation Error Est Err 328 328 Rank	Estimation Error Est Err 0 Rank
Estimation Error Est Err 6,126,879 6.1M Rank		Estimation Error Est Err 1,789 1.8K Rank	Estimation Error Est Err 0 0 Rank	Estimation Error Est Err 6,126,966 6.1M Rank	Estimation Error Est Err 344 344 Rank	Estimation Error Est Err 6,126,849 6.1M Rank

Actual Query Plans

Query Plan per Engine ?
	Query Plan
	Estimate Actual Operator 1 1 AGGREGATE min, min 4633 328 INNER JOIN HASH ON movie_id20 = movie_id65 7259 1398 │└INNER JOIN HASH ON id58 = keyword_id 7570 1398 │ │└INNER JOIN HASH ON movie_id53 = movie_id20 391 659 │ │ │└INNER JOIN HASH ON id37 = movie_id20 255 668 │ │ │ │└INNER JOIN HASH ON id = company_type_id 4 4 │ │ │ │ │└TABLE SCAN company_type 222 668 │ │ │ │ INNER JOIN HASH ON id6 = info_type_id 1 1 │ │ │ │ │└TABLE SCAN info_type WHERE info = release dates 222 668 │ │ │ │ INNER JOIN HASH ON id27 = company_id 604 699 │ │ │ │ │└INNER JOIN HASH ON movie_id = movie_id20 5129 1771 │ │ │ │ │ │└TABLE SCAN movie_info WHERE info) USA : AND note LIKE '%internet%' AND info14 LIKE '% 200%' 59940 12429 │ │ │ │ │ TABLE SCAN movie_companies WHERE note23 LIKE '%(worldwide)%' AND note23 LIKE '%(200%)%' 90648 249 │ │ │ │ TABLE SCAN company_name WHERE country_code = us 1402423 559 │ │ │ TABLE SCAN title WHERE production_year >= 2001 4523930 4523930 │ │ TABLE SCAN movie_keyword 134170 134170 │ TABLE SCAN keyword 361379 19 TABLE SCAN aka_title
	Estimate Actual Operator - 1 PROJECT a1 AS release_date, a2 AS internet_movie - 1 AGGREGATE MIN(info) AS a1, MIN(title) AS a2 - 0 PROJECT info, title - 0 PROJECT info, title - 0 INNER JOIN HASH ON tuple(PROJECTION_819.movie_id,PROJECTION_819.movie_id,PROJECTION_819.movie_id,PROJECTION_819.movie_id) = tuple(PROJECTION_816.id,PROJECTION_816.id,PROJECTION_816.id,PROJECTION_816.id) - 1381453 │└PROJECT id, title - 1381453 │ PROJECT id, title - 1381453 │ TABLE SCAN title WHERE production_year > 2000 - 0 PROJECT movie_id, movie_id, movie_id, movie_id, info - 0 PROJECT movie_id, movie_id, info, movie_id, movie_id - 0 INNER JOIN HASH ON PROJECTION_825.keyword_id = PROJECTION_822.id - 134170 │└PROJECT id - 134170 │ PROJECT id - 134170 │ TABLE SCAN keyword - 0 PROJECT keyword_id, movie_id, movie_id, info, movie_id, movie_id - 0 PROJECT movie_id, movie_id, info, movie_id, movie_id, keyword_id - 0 INNER JOIN HASH ON tuple(PROJECTION_831.movie_id,PROJECTION_831.movie_id,PROJECTION_831.movie_id) = tuple(PROJECTION_828.movie_id,PROJECTION_828.movie_id,PROJECTION_828.movie_id) - 4523930 │└PROJECT movie_id AS movie_id_right, keyword_id - 4523930 │ PROJECT movie_id, keyword_id - 4523930 │ TABLE SCAN movie_keyword - 0 PROJECT movie_id_left, movie_id_left_2, movie_id AS movie_id_left_3, info - 0 PROJECT movie_id, movie_id, info, movie_id - 0 INNER JOIN HASH ON PROJECTION_837.info_type_id = PROJECTION_834.id - 1 │└PROJECT id - 1 │ PROJECT id - 1 │ TABLE SCAN info_type WHERE info = 'release dates' - 0 PROJECT info_type_id, movie_id, movie_id, info, movie_id - 0 PROJECT movie_id, movie_id, info, movie_id, info_type_id - 0 INNER JOIN HASH ON PROJECTION_843.company_id = PROJECTION_840.id - 0 │└PROJECT id - 0 │ PROJECT id - 0 │ TABLE SCAN company_name WHERE country_code = 'us' - 76 PROJECT company_id, movie_id, movie_id, info, movie_id, info_type_id - 76 PROJECT movie_id, movie_id, company_id, info, movie_id, info_type_id - 76 INNER JOIN HASH ON PROJECTION_849.company_type_id = PROJECTION_846.id - 4 │└PROJECT id - 4 │ PROJECT id - 4 │ TABLE SCAN company_type - 76 PROJECT company_type_id, movie_id, movie_id, company_id, info, movie_id, info_type_id - 76 PROJECT movie_id, movie_id, company_id, company_type_id, info, movie_id, info_type_id - 76 INNER JOIN HASH ON tuple(PROJECTION_855.movie_id,PROJECTION_855.movie_id) = tuple(PROJECTION_852.movie_id,PROJECTION_852.movie_id) - 61664 │└PROJECT movie_id AS movie_id_right, company_id, company_type_id - 61664 │ PROJECT movie_id, company_id, company_type_id - 61664 │ TABLE SCAN movie_companies WHERE note LIKE '%(200%)%' AND note LIKE '%(worldwide)%' - 116 PROJECT movie_id_left, movie_id AS movie_id_left_2, info, info_type_id - 116 PROJECT movie_id, info, movie_id, info_type_id - 116 INNER JOIN HASH ON PROJECTION_861.movie_id = PROJECTION_858.movie_id - 1771 │└PROJECT movie_id AS movie_id_right, info, info_type_id - 1771 │ PROJECT movie_id, info, info_type_id - 1771 │ TABLE SCAN movie_info WHERE note LIKE '%internet%' AND info LIKE 'USA:% 200%' - 361379 PROJECT movie_id AS movie_id_left - 361379 PROJECT movie_id - 361379 TABLE SCAN aka_title
	Estimate Actual Operator - 1 AGGREGATE MIN(#0), MIN(#1) 0 328 PROJECT info, title 0 328 INNER JOIN HASH ON id = keyword_id 0 328 │└INNER JOIN HASH ON movie_id = movie_id 0 57 │ │└INNER JOIN HASH ON id = company_type_id 0 57 │ │ │└INNER JOIN HASH ON id = movie_id 2 71 │ │ │ │└INNER JOIN HASH ON info_type_id = id 2 1 │ │ │ │ │└FILTER id <= 110 2 1 │ │ │ │ │ TABLE SCAN info_type WHERE info = 'release dates' 126 71 │ │ │ │ INNER JOIN HASH ON movie_id = movie_id 531 13699 │ │ │ │ │└INNER JOIN HASH ON movie_id = movie_id 3650 43836 │ │ │ │ │ │└INNER JOIN HASH ON company_id = id 1644 84843 │ │ │ │ │ │ │└TABLE SCAN company_name WHERE country_code = 'us' 521825 61663 │ │ │ │ │ │ FILTER movie_id BETWEEN 50 AND 2525672 521825 61664 │ │ │ │ │ │ TABLE SCAN movie_companies WHERE (note LIKE '%(200%)%') AND contains(note,'(worldwide)') 361379 10438 │ │ │ │ │ TABLE SCAN aka_title 2967144 34 │ │ │ │ FILTER (movie_id BETWEEN 50 AND 2525672) AND (info LIKE 'USA:% 200%') 2967144 39 │ │ │ │ TABLE SCAN movie_info WHERE contains(note,'internet') AND info >= 'USA:' AND info < 'USA;' 505662 781 │ │ │ FILTER id BETWEEN 50 AND 2525672 505662 781 │ │ │ TABLE SCAN title WHERE production_year > 2000 4 1 │ │ TABLE SCAN company_type WHERE id <= 2 4523930 2709 │ TABLE SCAN movie_keyword WHERE movie_id >= 50 AND movie_id <= 2525672 134170 386 TABLE SCAN keyword
	Estimate Actual Operator 1 1 PROJECT release_date, internet_movie 1 1 AGGREGATE MIN(info), MIN(title) 15112 10 DISTRIBUTE GATHER 15112 10 AGGREGATE MIN(info), MIN(title) 15112 328 INNER JOIN HASH ON movie_id = CAST(t.id AS Int64) AND movie_id = id AND movie_id = id AND movie_id = id 15112 482 │└DISTRIBUTE GATHER 15112 482 │ INNER JOIN HASH ON keyword_id = id 15112 482 │ │└DISTRIBUTE GATHER 15112 482 │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = movie_id AND movie_id = CAST(mk.movie_id AS Int64) 15112 71 │ │ │└DISTRIBUTE GATHER 15112 71 │ │ │ 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 71 │ │ │ INNER JOIN HASH ON movie_id = movie_id AND movie_id = CAST(mi.movie_id AS Int64) 72276 13699 │ │ │ │└DISTRIBUTE GATHER 72276 13699 │ │ │ │ INNER JOIN HASH ON id = company_type_id 4 4 │ │ │ │ │└TABLE SCAN company_type 72276 13699 │ │ │ │ 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 20965 │ │ │ │ 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 521826 61664 │ │ │ │ DISTRIBUTE HASH ON CAST(mc.movie_id AS Int64) 521826 61664 │ │ │ │ PROJECT movie_id, company_id, company_type_id, CAST(movie_id AS INT64) 521826 61664 │ │ │ │ FILTER note LIKE '%(200%)%' AND note LIKE '%(worldwide)%' 2609129 2609129 │ │ │ │ TABLE SCAN movie_companies WHERE (((note LIKE '%(200%)%' AND note LIKE '%(worldwide)%') AND 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 (((CA... 2967144 1771 │ │ │ PROJECT movie_id, info_type_id, info, CAST(movie_id AS INT64) 2967144 1771 │ │ │ FILTER note LIKE '%internet%' AND info LIKE 'USA:% 200%' 14835720 3212639 │ │ │ TABLE SCAN movie_info WHERE ((note LIKE '%internet%' AND info LIKE 'USA:% 200%') AND ((((movie_id >= 2281) AND (movie_id <= 2524814)) AND ((CAST(movie_id AS INT64) >= 2281) AND (CAST(movie_id AS INT64) <= 2524814))) 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 >= 84385) AND (movie_id <= 2518397)) AND ((movie_id >= 84385) AND (movie_id <= 2518397))) AND ((CAST(movie_id AS INT64) >= 84385) AND (CAST(movie_id AS INT64) <= 2518397))) 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 343129 1381453 PROJECT id, title, CAST(id AS INT64) 343129 1381453 FILTER production_year > 2000 2528312 2528312 TABLE SCAN title WHERE (production_year > 2000) AND ((((((CAST(id AS INT64) >= 133307) AND (CAST(id AS INT64) <= 2518397)) AND ((id >= 133307) AND (id <= 2518397))) AND ((id >= 133307) AND (id <= 2518397))) AND ((id >= 133307) 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 > ...
	Estimate Actual Operator 1 1 AGGREGATE MIN(mi.info), MIN(t.title) 1 9 DISTRIBUTE GATHER 1 9 AGGREGATE MIN(mi.info), MIN(t.title) 237000 328 INNER JOIN HASH ON aka_t.movie_id = mk.movie_id 237000 57 │└DISTRIBUTE GATHER 113000 57 │ INNER JOIN HASH ON aka_t.movie_id = mc.movie_id 113000 43837 │ │└DISTRIBUTE GATHER 452000 43837 │ │ INNER JOIN HASH ON mc.company_id = cn.id 452000 84843 │ │ │└DISTRIBUTE GATHER 4 84843 │ │ │ TABLE SCAN company_name WHERE (cn.country_code IS NOT NULL) AND (cn.country_code = 'us') 168000 61647 │ │ INNER JOIN HASH ON mc.company_type_id = ct.id 168000 4 │ │ │└DISTRIBUTE GATHER 4520000 4 │ │ │ TABLE SCAN company_type 134000 61647 │ │ TABLE SCAN movie_companies WHERE (mc.note IS NOT NULL) AND mc.note LIKE '%(200%)%' AND contains(mc.note,'(worldwide)') 108000 111 │ INNER JOIN HASH ON aka_t.movie_id = mi.movie_id 108000 1771 │ │└DISTRIBUTE HASH ON mi.movie_id 177000 1771 │ │ INNER JOIN HASH ON mi.info_type_id = it1.id 177000 1 │ │ │└DISTRIBUTE GATHER 361000 1 │ │ │ TABLE SCAN info_type WHERE it1.info = 'release dates' 235000 1771 │ │ TABLE SCAN movie_info WHERE (mi.note IS NOT NULL) AND contains(mi.note,'internet') AND mi.info LIKE 'USA:% 200%' 452000 85960 │ INNER JOIN HASH ON aka_t.movie_id = t.id 452000 361379 │ │└DISTRIBUTE GATHER 2530000 361379 │ │ TABLE SCAN aka_title WHERE aka_t.movie_id IS NOT NULL 452000 1381453 │ DISTRIBUTE HASH ON t.id 2610000 1381453 │ TABLE SCAN title WHERE (t.production_year IS NOT NULL) AND (t.production_year > 2000L) 237000 4523930 DISTRIBUTE HASH ON mk.movie_id 12100 4523930 INNER JOIN HASH ON mk.keyword_id = k.id 12100 134170 │└DISTRIBUTE GATHER 113 134170 │ TABLE SCAN keyword 14800000 4523930 TABLE SCAN movie_keyword
	Estimate Actual Operator 1 1 AGGREGATE MIN(info as info) AS Expr1018, MIN(title as title) AS Expr1019 19 328 INNER JOIN LOOP ON t.id = mk.movie_id 18 328 │└TABLE SEEK movie_keyword AS mk 1 57 INNER JOIN LOOP ON Bmk1016 = Bmk1016 0 57 │└TABLE SEEK title AS t WHERE production_year as production_year > 2000 1 71 PROJECT BmkToPage Bmk1016 AS Expr1046 1 71 INNER JOIN LOOP ON mi.movie_id = t.id 1 71 │└TABLE SEEK title AS t 1 71 INNER JOIN LOOP ON mi.movie_id = aka_t.movie_id 1 71 │└TABLE SEEK aka_title AS aka_t 1 668 FILTER info as info = 'release dates' 123 668 INNER JOIN LOOP ON Bmk1006 = Bmk1006 1 668 │└TABLE SEEK info_type AS it1 123 668 INNER JOIN LOOP ON mi.info_type_id = it1.id 1 668 │└TABLE SEEK info_type AS it1 123 668 INNER JOIN LOOP ON mc.movie_id = mi.movie_id 1 668 │└TABLE SEEK movie_info AS mi WHERE note as note LIKE '%internet%' AND info as info LIKE 'USA:% 200%' 21418 43837 INNER JOIN HASH ON cn.id = mc.company_id 59556 61664 │└TABLE SCAN movie_companies AS mc WHERE note as note LIKE '%(200%)%' AND note as note LIKE '%(worldwide)%' 84576 5362 TABLE SCAN company_name AS cn WHERE (PROBE(Bitmap1044,id as id,N'IN ROW')) AND (country_code as country_code = 'us')
	Estimate Actual Operator 1 ∞ PROJECT min AS release_date, min_50 AS 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 - 328 INNER JOIN HASH ON movie_id = id_36 335742 1381453 │└DISTRIBUTE HASH ON id_36 335742 1381453 │ PROJECT id AS id_36, title AS title_37 335742 1381453 │ FILTER production_year > 2000 335742 1381453 │ TABLE SCAN title - 482 INNER JOIN HASH ON keyword_id = id_13 134170 134170 │└DISTRIBUTE GATHER 134170 134170 │ PROJECT id AS id_13 134170 134170 │ TABLE SCAN keyword - 482 INNER JOIN HASH ON movie_id = 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 - 71 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 - 71 INNER JOIN HASH ON movie_id = movie_id_25 13352148 1771 │└DISTRIBUTE HASH ON movie_id_25 13352148 1771 │ PROJECT movie_id AS movie_id_25, info_type_id, info AS info_26 13352148 1771 │ FILTER (info >= 'USA:') AND (info < 'USA;') AND (note LIKE '%internet%') AND (info LIKE 'USA:% 200%') 13352148 1771 │ TABLE SCAN movie_info - 67 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 - 67 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 - 67 INNER JOIN HASH ON movie_id = movie_id_19 2348216 661 │└DISTRIBUTE HASH ON movie_id_19 2348216 661 │ PROJECT movie_id AS movie_id_19, company_id, company_type_id 2348216 661 │ FILTER (note LIKE '%(200%)%') AND (note LIKE '%(worldwide)%') 2348216 661 │ TABLE SCAN movie_companies 361379 46 TABLE SCAN aka_title
	Estimate Actual Operator 1 1 AGGREGATE MIN(info), MIN(title) 4 4 AGGREGATE PARTIAL MIN(info), PARTIAL MIN(title) 24 328 INNER JOIN LOOP ON id = keyword_id 24 328 │└INNER JOIN LOOP ON movie_id = id 4 57 │ │└INNER JOIN LOOP ON id = info_type_id 4 57 │ │ │└INNER JOIN LOOP ON id = company_type_id 4 57 │ │ │ │└INNER JOIN LOOP ON movie_id = id 4128 5134 │ │ │ │ │└INNER JOIN LOOP ON id = movie_id 7584 13699 │ │ │ │ │ │└INNER JOIN LOOP ON movie_id = movie_id 10760 43837 │ │ │ │ │ │ │└INNER JOIN LOOP ON id = company_id 29468 61664 │ │ │ │ │ │ │ │└TABLE SCAN movie_companies AS mc WHERE (mc.note LIKE '%(200%)%') AND (mc.note LIKE '%(worldwide)%') 61664 61664 │ │ │ │ │ │ │ TABLE SEEK company_name AS cn WHERE cn.country_code = 'us' 131511 43837 │ │ │ │ │ │ TABLE SEEK aka_title AS aka_t 13699 13699 │ │ │ │ │ TABLE SEEK title AS t WHERE t.production_year > 2000 5134 5134 │ │ │ │ TABLE SEEK movie_info AS mi WHERE (mi.note LIKE '%internet%') AND (mi.info LIKE 'USA:% 200%') 57 57 │ │ │ TABLE SEEK company_type AS ct 4 4 │ │ TABLE SEEK info_type AS it1 WHERE it1.info = 'release dates' 2565 327 │ TABLE SEEK movie_keyword AS mk 328 328 TABLE SEEK keyword AS k