Movielogr

Home

Movies by Certification (MPAA Rating)

noahphex has logged 116 movies that were certified NR by the MPAA.

Movies certified NR
TitleDirector(s)Year ReleasedViewed On
Nail Gun Massacre, TheBill Leslie, Terry Lofton198509/20/2011
Neon FleshPaco Cabezas201004/23/2011
Never Too Young to DieGil Bettman198612/11/2010
New York Ripper, TheLucio Fulci198202/09/2011
Night and the CityJules Dassin195004/02/2011
Night of the DemonJacques Tourneur195704/20/2011
Night TerrorE.W. Swackhamer197702/20/2011
Night to Dismember, ADoris Wishman198304/25/2012
ObjectifiedGary Hustwit200908/08/2010
One Nation Under DogEllen Goosenberg Kent, Amanda Micheli, Jenny Carchman201207/07/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Cert )  0.0271
Total Execution Time  0.0287
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,576 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/cert/NR/title/asc/70
  CLASS/METHOD  
members/movies_by_cert
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0201 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '9c71f2f65e8310976e9e1e0a562abed6a9997a6e'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT GET_LOCK('8af4ea6b40251c1096b229f687378343', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9c71f2f65e8310976e9e1e0a562abed6a9997a6e'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0069  
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` = 8
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id` ?>
0.0118  
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` = 8
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 70, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)