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
Fast and the Furious: Tokyo Drift, TheJustin Lin200604/24/2011
Employee of the MonthGreg Coolidge200605/14/2011
Fox Family, TheLee Hyung-gon200608/13/2011
Day WatchTimur Bekmambetov200610/07/2011
City of Violence, TheRyoo Seung-wan200602/04/2012
Phat GirlzNnegest Likké200603/24/2012
Riding the Bus with My SisterAnjelica Huston200502/26/2011
Oh! My Zombie MermaidTerry Ito, Naoki Kudo200404/02/2011
Girl Next Door, TheLuke Greenfield200405/01/2011
Night WatchTimur Bekmambetov200410/07/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0023
Controller Execution Time ( Members / Movies By Source )  0.0319
Total Execution Time  0.0342
  GET DATA  
No GET data exists
  MEMORY USAGE  
535,768 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/200/year/desc/230
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0211 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '66d92fd5d68a6c4938dc1925c3f18104c5824f09'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('81d0eeb69d9c67df62d1db7059f2691d', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '66d92fd5d68a6c4938dc1925c3f18104c5824f09'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0075  
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.0124  
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 230, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)