Movielogr

Home

Movies by Certification (MPAA Rating)

sensoria has logged 120 movies that were certified NR by the MPAA.

Movies certified NR
TitleDirector(s)Year ReleasedViewed On
Postman Always Rings Twice, TheTay Garnett194606/28/2012
Paths of GloryStanley Kubrick195706/27/2012
Purple Plain, TheRobert Parrish195406/26/2012
Guns of Navarone, TheJ. Lee Thompson196106/26/2012
Rope of SandWilliam Dieterle194906/21/2012
ScarfaceHoward Hawks193206/20/2012
39 Steps, TheAlfred Hitchcock193506/15/2012
Kiss Before Dying, AGerd Oswald195606/15/2012
House by the RiverFritz Lang195006/11/2012
Crime of PassionGerd Oswald195606/10/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0036
Controller Execution Time ( Members / Movies By Cert )  0.0241
Total Execution Time  0.0277
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,304 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/cert/NR/date_viewed/desc/20
  CLASS/METHOD  
members/movies_by_cert
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0165 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c1461f05e7dca716b91b7794838d8d868064b092'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('f6e589571af4997307f95a199815de84', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c1461f05e7dca716b91b7794838d8d868064b092'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0061  
SELECT DISTINCT(MT.title_id)
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 1
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id` ?>
0.0092  
SELECT `MT`.`title_id`, `title`, `prefix`, `year`, MAX(date_viewed) AS date_viewed, `imdb_link`, MAX(movie_id) AS movie_id, 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
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`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`
WHERE `MV`.`user_id` = 1
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` DESC
 LIMIT 20, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)