Movielogr

Home

Movies by Source

sensoria has logged 140 movies with No source listed. Back to Sources by Popularity.

Movies logged with No source listed
TitleDirector(s)Year ReleasedViewed On
13 AssassinsTakashi Miike201007/08/2011
1990: The Bronx WarriorsEnzo G. Castellari198210/05/2011
30 Minutes or LessRuben Fleischer201112/04/2011
A-Team, TheJoe Carnahan201012/23/2011
Adjustment Bureau, TheGeorge Nolfi201107/29/2011
AlienRidley Scott197901/03/2012
AltitudeKaare Andrews201012/05/2011
AnzioEdward Dmytryk, Duilio Coletti196807/20/2011
Attack of the Blind DeadAmando de Ossorio197310/09/2011
Attack the BlockJoe Cornish201110/29/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Source )  0.0202
Total Execution Time  0.0218
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,256 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/source/200
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0137 seconds)  (Hide)
0.0009  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '662e76ac72baf9d959128b6a19ff8285529a82c4'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('ded1a7168bed062697d1cd651c5465ca', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '662e76ac72baf9d959128b6a19ff8285529a82c4'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0046  
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` = 1
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id` ?>
0.0073  
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` = 1
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)