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
Dead Pit, TheBrett Leonard198910/13/2010
Lady TerminatorH. Tjut Djalil198911/09/2010
BannedRoberta Findlay198912/11/2010
No Holds BarredThomas J. Wright198904/02/2011
Urge to Kill, TheDerek Ford198912/18/2011
Snake EaterGeorge Erschbamer198902/19/2012
Critters 2Mick Garris198802/02/2011
Dead HeatMark Goldblatt198801/03/2010
Jungle HeatRatno Timoer198804/14/2010
DemonwarpEmmett Alston198804/21/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Source )  0.0296
Total Execution Time  0.0312
  GET DATA  
No GET data exists
  MEMORY USAGE  
533,808 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/200/year/desc/300
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 5 (0.0194 seconds)  (Hide)
0.0004  
SELECT GET_LOCK('ac9ae15bcadedfa071e450c5d34866d3', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c144db75e5c15e6275941ae19f3d8d3dfc2b02f0'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0068  
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.0116  
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 300, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)