Movielogr

Home

Movies by Certification (MPAA Rating)

sleestakk has logged 136 movies that were certified NR by the MPAA.

Movies certified NR
TitleDirector(s)Year ReleasedViewed On
Girl ShyFred C. Newmeyer, Sam Taylor192403/30/2009
Girl Who Dared, TheHoward Bretherton194406/07/2012
Godzilla vs. DestoroyahTakao Okawara199507/14/2012
Godzilla vs. King GhidorahKazuki Ōmori199109/12/2012
GorgoEugène Lourié196107/12/2012
Great Gatsby, TheElliott Nugent194908/22/2012
H-Man, TheIshirô Honda195810/27/2012
Hercules and the Captive WomenVittorio Cottafavi196103/21/2009
Holy MotorsLeos Carax201209/21/2012
Hound of the Baskervilles, TheTerence Fisher195910/27/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0026
Controller Execution Time ( Members / Movies By Cert )  0.0337
Total Execution Time  0.0364
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,560 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/cert/NR/title/asc/50
  CLASS/METHOD  
members/movies_by_cert
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0227 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c34cd162e2c3017e9204e0cbde8ed32f3babca39'
AND `ip_address` = '216.73.216.48' ?>
0.0001  
SELECT GET_LOCK('4d758a3af359ac7e89162f56655eb974', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c34cd162e2c3017e9204e0cbde8ed32f3babca39'
AND `ip_address` = '216.73.216.48' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0092  
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` = 9
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id` ?>
0.0126  
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` = 9
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 50, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)