Movielogr

Home

Movies by Source

noahphex has logged 457 movies with No source listed. Back to Sources by Popularity.

Movies logged with No source listed
TitleDirector(s)Year ReleasedViewed On
Funhouse, TheTobe Hooper198110/30/2011
Bloody BirthdayEd Hunt198112/15/2010
Deadly BlessingWes Craven198101/30/2011
Galaxy of TerrorBruce D. Clark198101/23/2010
Mystery on Monster IslandJuan Piquer Simón198101/23/2011
Dark Night of the ScarecrowFrank De Felitta198101/01/2012
Escape from New YorkJohn Carpenter198104/09/2011
Decline of Western Civilization, ThePenelope Spheeris198101/26/2011
Alone in the DarkJack Sholder198205/01/2010
National Lampoon's Movie MadnessBob Giraldi, Henry Jaglom198212/29/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0027
Controller Execution Time ( Members / Movies By Source )  0.0316
Total Execution Time  0.0343
  GET DATA  
No GET data exists
  MEMORY USAGE  
538,912 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/200/year/asc/70
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0218 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c072e2040411243a2ef69aebf5fff565c0ddebaf'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('3ad8fa13affca82d0f1979ba99507feb', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c072e2040411243a2ef69aebf5fff565c0ddebaf'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 
0.0081   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` = 8
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id` 
0.0125   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` = 8
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 70, 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)