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
Virginity Hit, TheHuck Botko, Andrew Gurland201001/08/2011
MegamindTom McGrath201001/15/2011
Social Network, TheDavid Fincher201001/15/2011
Stereo (Tile 3B of a CAEE Educational Mosaic)David Cronenberg196901/17/2011
Dead of NightCharles Crichton, Basil Dearden, Robert Hamer, Alberto Cavalcanti194501/17/2011
EvilspeakEric Weston198101/18/2011
Sect, TheMichele Soavi199101/18/2011
Lisa and the DevilMario Bava197301/18/2011
I Spit on Your GraveSteven R. Monroe201001/22/2011
Mr. NobodyJaco Van Dormael200901/22/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Source )  0.0278
Total Execution Time  0.0293
  GET DATA  
No GET data exists
  MEMORY USAGE  
539,064 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/200/date_viewed/asc/160
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0211 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '7ce90f4c618d88586b0195a2eb5f8d80aff6d1ce'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('9b911956b45697e7e779d2edda819966', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '7ce90f4c618d88586b0195a2eb5f8d80aff6d1ce'
AND `ip_address` = '216.73.216.111' 
0.0003   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.0119   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` ASC
 LIMIT 160, 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)