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
Black DeathChristopher Smith201001/07/2011
Make-Out with ViolenceDeagol Brothers200801/06/2011
Bitter FeastJoe Maggio201001/04/2011
MilfScott Wheeler201001/03/2011
TwelveJoel Schumacher201001/02/2011
And Soon the DarknessMarcos Efron201001/02/2011
Date NightShawn Levy201001/01/2011
CyrusJay Duplass, Mark Duplass201012/30/2010
Waking Sleeping BeautyDon Hahn200912/30/2010
Standing OvationStewart Raffill201012/30/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Source )  0.0280
Total Execution Time  0.0296
  GET DATA  
No GET data exists
  MEMORY USAGE  
535,656 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/200/date_viewed/desc/300
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0204 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '6e714fe42a2361c54f166861f8d28a56a13a7bab'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('d47ce84d24b76c52636e7df227f753d2', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '6e714fe42a2361c54f166861f8d28a56a13a7bab'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0080  
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.0113  
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 `date_viewed` DESC
 LIMIT 300, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)