Movielogr

Home

Movies by Certification (MPAA Rating)

BTSjunkie has logged 22 movies that were certified NR by the MPAA.

Movies certified NR
TitleDirector(s)Year ReleasedViewed On
House on the Edge of the ParkRuggero Deodato198002/11/2010
Indie Game: The MovieLisanne Pajot, James Swirsky201201/21/2012
Kill ListBen Wheatley201102/09/2012
Man from Earth, TheRichard Schenkman200701/10/2010
NinotchkaErnst Lubitsch193901/31/2010
Point BlankJohn Boorman196701/07/2012
Room 237Rodney Ascher201201/26/2012
Salò, or the 120 Days of SodomPier Paolo Pasolini197601/08/2012
Shut Up and Play the HitsWill Lovelace, Dylan Southern201201/25/2012
Simon KillerAntonio Campos201201/21/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Cert )  0.0135
Total Execution Time  0.0152
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,480 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/BTSjunkie/cert/NR/title/asc/10
  CLASS/METHOD  
members/movies_by_cert
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0064 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '325d8aa847c5c9239a7e7f5033b0fbd5f9c48ad6'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('ddd12f61dc3cf20fcfe45069c4b8f82a', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '325d8aa847c5c9239a7e7f5033b0fbd5f9c48ad6'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'BTSjunkie'
 LIMIT 1 ?>
0.0033  
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` = 48
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id` ?>
0.0020  
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` = 48
AND `MT`.`certification` = 'NR'
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 10, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)