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
Trotsky, TheJacob Tierney201007/25/2011
Book of Eli, TheAlbert Hughes, Allen Hughes201007/18/2010
Rammbock: Berlin UndeadMarvin Kren201009/25/2010
Legend of the Fist: The Return of Chen ZhenAndrew Lau201009/25/2010
Resident Evil: AfterlifePaul W.S. Anderson201009/01/2010
Step Up 3DJon M. Chu201007/21/2011
Scott Pilgrim vs. the WorldEdgar Wright201006/18/2011
Twilight Saga: Eclipse, TheDavid Slade201007/25/2011
Cop OutKevin Smith201008/02/2010
Hatchet IIAdam Green201010/31/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Source )  0.0262
Total Execution Time  0.0278
  GET DATA  
No GET data exists
  MEMORY USAGE  
533,040 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/source/200/year/desc/210
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0198 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('bfd2bccfec186778a7e16bfe1e9c86ef', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '70cf2ee9114d411a77f04a69649facc81cf39f49'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 ?>
0.0061  
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.0129  
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` DESC
 LIMIT 210, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)