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
Troll HunterAndré Øvredal201002/11/2011
American, TheAnton Corbijn201002/05/2011
Shankar02/03/2011
My Soul to TakeWes Craven201002/03/2011
Blood and BoneBen Ramsey200902/03/2011
Critters 2Mick Garris198802/02/2011
Critters 4Rupert Harvey199202/02/2011
Decline of Western Civilization Part III, ThePenelope Spheeris199802/02/2011
Hole, TheJoe Dante200901/31/2011
CrittersStephen Herek198601/31/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Source )  0.0311
Total Execution Time  0.0328
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,712 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/200/date_viewed/desc/260
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0234 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'f9c60b5dd7c81b7cc6c064f3e2f72fd631c727af'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('ff3ccf072c5a74ba1ccf654ae5e349cd', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'f9c60b5dd7c81b7cc6c064f3e2f72fd631c727af'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0101  
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.0121  
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 260, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)