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
Pineapple ExpressDavid Gordon Green200807/05/2010
Princess and the Frog, TheRon Clements, John Musker200907/05/2010
She's Out of My LeagueJim Field Smith201007/03/2010
CluelessAmy Heckerling199507/02/2010
Independence DayRoland Emmerich199607/02/2010
Drunken MasterYuen Woo-ping197807/02/2010
Psycho IIRichard Franklin198306/29/2010
Army of DarknessSam Raimi199206/24/2010
Prophecy II, TheGreg Spence199806/19/2010
Dead HeatMark Goldblatt198806/15/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Source )  0.0245
Total Execution Time  0.0260
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,864 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/source/200/date_viewed/desc/530
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0176 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '4222e2889a8868143a505acb1a5dc8fd4ea99f5b'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('4e49c92d239d1668a6a06a129a59398b', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '4222e2889a8868143a505acb1a5dc8fd4ea99f5b'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 ?>
0.0044  
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.0120  
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 `date_viewed` DESC
 LIMIT 530, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)