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
American Werewolf in London, AnJohn Landis198109/24/2011
Angels & DemonsRon Howard200906/12/2011
Arctic BlastBrian Trenchard-Smith201012/18/2011
Army of DarknessSam Raimi199206/24/2010
ArthurJason Winer201109/10/2011
Astro BoyDavid Bowers200907/11/2010
At the CircusEdward Buzzell193909/08/2011
Attack the BlockJoe Cornish201111/02/2011
Austin Powers in GoldmemberJay Roach200206/24/2011
BackdraftRon Howard199109/15/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0027
Controller Execution Time ( Members / Movies By Source )  0.0603
Total Execution Time  0.0631
  GET DATA  
No GET data exists
  MEMORY USAGE  
524,472 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/source/200/title/asc/20
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0256 seconds)  (Hide)
0.0039  
SELECT GET_LOCK('da67ce0b33e03f2af24852215e91d439', 300) AS ci_session_lock ?>
0.0006  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '32df37940ecc4387c11e526f2a522236a648fad1'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 ?>
0.0050  
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.0157  
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 `title` ASC
 LIMIT 20, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)