Movielogr

Home

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

This Film Is Not Yet Rated (2006)

Directed by Kirby Dick

Most recently watched by sensoria

Overview

Kirby Dick’s provocative documentary investigates the secretive and inconsistent process by which the Motion Picture Association of America rates films, revealing the organization’s underhanded efforts to control culture. Dick questions whether certain studios get preferential treatment and exposes the discrepancies in how the MPAA views sex and violence.

Rated NR | Length 98 minutes

Actors

Maria Bello | Kimberly Peirce | Allison Anders | Darren Aronofsky | John Waters | Mary Harron | Wayne Kramer | Kevin Smith | Richard Nixon | Matt Stone | Rachel Blanchard | Atom Egoyan | Jamie Babbit | Walter Cronkite | Lawrence Lessig | Dan Rather | Javorn Drummond | Michael Tucker | Kirby Dick | Tom Brokaw | Kirsten Johnson | Jack Valenti | Ann Curry | Will H. Hays | Eddie Schmidt | Jon Lewis | David Ansen | Martin Garbus | Paul Dergarabedian | Richard Heffner | Bingham Ray | Joel Federman | Jay Rosenzweig | Paul Huebl | Clark Baker | Becky Altringer | Cheryl Howell | Cookie Schwartz | Lindsey Howell | Jay Landers | Stephen Farber | Dottie Hamilton | Mark Urman | Joan Graves | Joann Yatabe | Theresa Webb | David L. Robb | Anthony 'Tony' Hey | Barry Freeman | Arleen Bates | Matt Ioakimedes | Jane Worden | Scott Young | Howard Fridkin | Michael McClellan | James Wall | Eric Johnston | J. Parnell Thomas

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0209
Total Execution Time  0.0226
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,112 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4156
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0041 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'cc9a0e365aef4ead9867fea5e6a1f3a75245754e'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('edfd47a5cb67737440e3f983b6c59307', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'cc9a0e365aef4ead9867fea5e6a1f3a75245754e'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4156
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0017   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filename, GROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directors, GROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_ids, GROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actors, GROUP_CONCAT(DISTINCT(ACT.tmdb_actor_id) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actor_ids
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movie_posters` `MP` ON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMD` ON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DR` ON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMA` ON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 4156
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0004   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 4156
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4156 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)