Movielogr

Home

Movies by Certification (MPAA Rating)

suspectk has logged 66 movies that were certified R by the MPAA.

Movies certified R
TitleDirector(s)Year ReleasedViewed On
Guide to Recognizing Your Saints, ADito Montiel200603/19/2010
Pan's LabyrinthGuillermo del Toro200603/04/2007
Paris Je T'aimeIsabel Coixet, Tom Tykwer, Joel Coen, Ethan Coen, Christopher Doyle, Richard LaGravenese, Wes Craven, Gus Van Sant, Vincenzo Natali, Gurinder Chadha, Walter Salles, Alfonso Cuarón, Alexander Payne, Gérard Depardieu, Frédéric Auburtin, Olivier Assayas, Nobuhiro Suwa, Oliver Schmitz, Sylvain Chomet, Bruno Podalydès, Daniela Thomas200602/21/2010
12 and HoldingMichael Cuesta200605/28/2012
Nines, TheJohn August200707/18/2009
HounddogDeborah Kampmeier200703/08/2010
JoshuaGeorge Ratliff200706/26/2007
American GangsterRidley Scott200711/04/2007
Charlie Wilson's WarMike Nichols200712/25/2007
Confessions of a SuperheroMatthew Ogens200707/24/2009
  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Members / Movies By Cert )  0.0147
Total Execution Time  0.0160
  GET DATA  
No GET data exists
  MEMORY USAGE  
539,680 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/suspectk/cert/R/year/asc/20
  CLASS/METHOD  
members/movies_by_cert
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0080 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'cc2996a77340109138f1d65e87f8096dd02d2f71'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('4bf821ab212536a699e2e4656dbc6b6c', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'cc2996a77340109138f1d65e87f8096dd02d2f71'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'suspectk'
 LIMIT 1 
0.0036   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` = 68
AND `MT`.`certification` = 'R'
GROUP BY `MT`.`title_id` 
0.0033   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` = 68
AND `MT`.`certification` = 'R'
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 20, 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)