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
House by the Cemetery, TheLucio Fulci198102/15/2011
Dark Night of the ScarecrowFrank De Felitta198101/01/2012
City of the Living DeadLucio Fulci198001/05/2010
Mardi Gras MassacreJack Weis197803/09/2011
Night TerrorE.W. Swackhamer197702/20/2011
El TopoAlejandro Jodorowsky197005/08/2010
Stereo (Tile 3B of a CAEE Educational Mosaic)David Cronenberg196901/17/2011
Eye of the DevilJ. Lee Thompson196605/13/2012
Faster, Pussycat! Kill! Kill!Russ Meyer196508/10/2010
Great Race, TheBlake Edwards196512/19/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Cert )  0.0352
Total Execution Time  0.0367
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,232 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/cert/NR/year/desc/90
  CLASS/METHOD  
members/movies_by_cert
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0262 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('3ff4d8e3611267af115594141a16196c', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'e8b989ac09672a2e136fb2bb9e6d9c22bbceae59'
AND `ip_address` = '216.73.216.6' ?>
0.0009  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0072  
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.0175  
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 `year` DESC
 LIMIT 90, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)