Movielogr

Home

Movies by Certification (MPAA Rating)

jenerator has logged 50 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
Myth of the American Sleepover, TheDavid Robert Mitchell201108/14/2011
MetropolisFritz Lang192703/30/2011
Love HappyDavid Miller194909/03/2011
Kings Go ForthDelmer Daves195801/03/2012
Julia X 3DP.J. Pettiette201109/25/2011
Juan of the DeadAlejandro Brugués201109/23/2011
Horse FeathersNorman Z. McLeod193208/18/2011
High SocietyCharles Walters195601/10/2012
Go WestEdward Buzzell194009/03/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Cert )  0.0202
Total Execution Time  0.0217
  GET DATA  
No GET data exists
  MEMORY USAGE  
524,136 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/cert/NR/title/desc/20
  CLASS/METHOD  
members/movies_by_cert
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0137 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('da2bd6320fa59954cf4d1f7f61adb6b9', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd129dc04880564b36091f9ba49507ee3fbc3c50f'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 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` = 61
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id` ?>
0.0059  
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` = 61
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id`
ORDER BY `title` DESC
 LIMIT 20, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)