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
Snake in the Eagle's ShadowYuen Woo-ping197810/02/2010
Highway to HellAte de Jong199109/15/2010
CenturionNeil Marshall201009/12/2010
Kick-AssMatthew Vaughn201009/10/2010
Deadbeat at DawnJim Van Bebber198809/10/2010
Losers, TheSylvain White201009/04/2010
Times SquareAllan Moyle198009/04/2010
Rolling ThunderJohn Flynn197709/04/2010
Exterminators of the Year 3000Giuliano Carnimeo198309/04/2010
Rawhead RexGeorge Pavlou198609/01/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Source )  0.0288
Total Execution Time  0.0303
  GET DATA  
No GET data exists
  MEMORY USAGE  
535,688 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/200/date_viewed/desc/360
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0213 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '5a72deb10148b87c5d6310525e5232eca9085f3e'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('28a8432473c789190b48715ac9d1b94b', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5a72deb10148b87c5d6310525e5232eca9085f3e'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0079  
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.0122  
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 360, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)