Movielogr

Home

Movies by Source

jenerator has logged 594 movies with No source listed. Back to Sources by Popularity.

Movies logged with No source listed
TitleDirector(s)Year ReleasedViewed On
Attack the BlockJoe Cornish201111/02/2011
Green LanternMartin Campbell201112/04/2011
Adventures of Tintin, TheSteven Spielberg201112/29/2011
Innkeepers, TheTi West201101/06/2012
BellflowerEvan Glodell201109/10/2011
DriveNicolas Winding Refn201109/17/2011
Your HighnessDavid Gordon Green201108/06/2011
Take Me Home TonightMichael Dowse201106/16/2011
Skin I Live In, ThePedro Almodóvar201109/25/2011
Martha Marcy May MarleneSean Durkin201112/26/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Members / Movies By Source )  0.0278
Total Execution Time  0.0290
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,800 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/source/200/year/asc/500
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0216 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c4de79acbfdcfb65415e3739f30ea69998b192b7'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('961af985231a86675f538ea7216b7ad6', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c4de79acbfdcfb65415e3739f30ea69998b192b7'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 ?>
0.0060  
SELECT `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 `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id` ?>
0.0145  
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 `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 500, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)