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
Knight's Tale, ABrian Helgeland200111/10/2011
Kull the ConquerorJohn Nicolella199709/20/2011
Last Action HeroJohn McTiernan199310/19/2011
Last Airbender, TheM. Night Shyamalan201011/28/2010
Law Abiding CitizenF. Gary Gray200903/20/2010
League of Extraordinary Gentlemen, TheStephen Norrington200309/12/2011
LegendRidley Scott198501/01/2012
Legend of the Fist: The Return of Chen ZhenAndrew Lau201009/25/2010
Legend of the Guardians: The Owls of Ga'HooleZack Snyder201001/22/2011
LegionScott Stewart201005/14/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Source )  0.0280
Total Execution Time  0.0295
  GET DATA  
No GET data exists
  MEMORY USAGE  
538,952 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/source/200/title/asc/310
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0215 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '45b2393a1925af880b825619f3b3ce8374d34cb6'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('03f5e9f968d01f8364ec49c07843d943', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '45b2393a1925af880b825619f3b3ce8374d34cb6'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 
0.0059   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.0146   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 310, 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)