Movielogr

Home

Movies by Source

jenerator has logged 594 movies with No source listed. Back to Sources by Popularity.

Movies logged with No source listed
TitleDirector(s)Year ReleasedViewed On
Sex DriveSean Anders200807/30/2011
ShameSteve McQueen201101/01/2012
Shaun of the DeadEdgar Wright200410/15/2011
She's Out of My LeagueJim Field Smith201007/03/2010
Sherlock HolmesGuy Ritchie200904/10/2011
Sherlock Holmes: A Game of ShadowsGuy Ritchie201112/26/2011
Shining, TheStanley Kubrick198010/09/2011
Shrek Forever AfterMike Mitchell201006/30/2011
SilmidoKang Woo-Suk200301/03/2012
Sin CityQuentin Tarantino, Frank Miller, Robert Rodriguez200506/29/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Source )  0.0303
Total Execution Time  0.0319
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,752 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/source/200/title/asc/470
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0224 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '5e5189eb171781d14ef3afda54f5cef61049c264'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('0a3c24abdbaed7378e48a3ba564c886c', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5e5189eb171781d14ef3afda54f5cef61049c264'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 ?>
0.0058  
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` = 61
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id` ?>
0.0152  
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` = 61
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 470, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)