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
Family Guy Presents: It's a TrapPeter Shin201012/19/2010
Video Nasties: Moral Panic, Censorship & VideotapeJake West201012/22/2010
Easy AWill Gluck201012/24/2010
Knight and DayJames Mangold201012/24/2010
13Géla Babluani201012/25/2010
SaltPhillip Noyce201012/26/2010
FrozenAdam Green201008/07/2010
KillersRobert Luketic201012/28/2010
Virginity Hit, TheHuck Botko, Andrew Gurland201001/08/2011
MilfScott Wheeler201001/03/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Members / Movies By Source )  0.0638
Total Execution Time  0.0651
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,656 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/200/year/desc/90
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0562 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '7413dabb6a2d6d66ac21f663c68df16b76d63d8f'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('78124691e81cd43e290453d13f1c2b93', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '7413dabb6a2d6d66ac21f663c68df16b76d63d8f'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0105  
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.0444  
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` DESC
 LIMIT 90, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)