Movielogr

Home

movie poster

Rating: 8.5 stars

Seen 1 time

Seen on: 12/25/2002

View on: IMDb | TMDb

The Lord of the Rings: The Two Towers (2002)

Directed by Peter Jackson

Adventure | Fantasy | Action

Most recently watched by sleestakk, pknail

Overview

Frodo and Sam are trekking to Mordor to destroy the One Ring of Power while Gimli, Legolas and Aragorn search for the orc-captured Merry and Pippin. All along, nefarious wizard Saruman awaits the Fellowship members at the Orthanc Tower in Isengard.

Rated PG-13 | Length 179 minutes

Actors

Sean Bean | Peter Jackson | Elijah Wood | Viggo Mortensen | Cate Blanchett | Christopher Lee | Orlando Bloom | Barrie M. Osborne | Miranda Otto | John Rhys-Davies | Liv Tyler | Alan Lee | Ian McKellen | Sean Astin | Billy Boyd | Dominic Monaghan | Hugo Weaving | Craig Parker | Andy Serkis | Sala Baker | Bernard Hill | Brad Dourif | David Wenham | Karl Urban | Dan Hennah | John Noble | Paul Norell | Bruce Phillips | John Bach | Nathaniel Lees | Richard Knowles | Robbie Magasiva | John Leigh | Robert Young | Robyn Malcolm | Robert Pollock | Aron Eastwood | Allan Poppleton | Raymond Trickitt | Bruce Allpress | Jed Brophy | Owen Black | Alistair Browning | Tim Wong | Gareth Reeves | Piripi Waretini | Karlos Drinkwater | Alix Bushnell | Olivia Tennet | Miranda Rivers | Frank Edwards | Augie Davis | John Wraight | Siaosi Fonua | Victoria Beynon-Cole | Billy Jackson | Joseph Mika-Hunt | Bruce Hopkins | Lucas Hayward | Jason Hood | Matthew Saville | Dra McKay | Calum Gittins | Campbell Rousselle | Shane Dawson | Ben Fransham | Stephen Ure | Sean Button | Alexia Fairbrother | Allan Smith | Phil Grieve | Brent McIntyre | Rodney Cook | Ben Barrington | Sandro Kopp | Francis Mountjoy | Mana Hira Davis | Lani Jackson | Sam Comery | Dean Morganty | Kelley Kerr Young | Ryan Carey | Kester Fordham | Paris Howe Strewe | Lee Hartley | Katie Jackson | Ben Britton | Gareth Jensen | Jørn Benzon | Sam Kelly | Riley Brophy | Jarl Benzon | Dorothy Anne Bonner | Daniel Falconer | Frank Goldingham | Henry Mortensen | Samuel E. Shore | Greg Tozer | Jonathan Harding | Sam La Hood | Jono Manks | Clint Elvy | Frazer Anderson | Winham Hammond | Michael Lawrence | Don Langridge | Michael Fowler

Viewing Notes

My Xmas movie this year! Really excellent follow up to the Fellowship. Epic and excellent on the big screen.

Comments

No comments yet. Log in and be the first!

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movie Detail )  0.0245
Total Execution Time  0.0261
  GET DATA  
No GET data exists
  MEMORY USAGE  
546,848 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/movie_detail/7841
  CLASS/METHOD  
members/movie_detail
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 17 (0.0066 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '0373c2569400a2e62e17d08d9b877852dd12fb14'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('9252e41929a126a2dcd270eafc7e926c', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '0373c2569400a2e62e17d08d9b877852dd12fb14'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 
0.0003   SELECT `MV`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`movie_id` = 7841
AND `MV`.`user_id` = 9
 LIMIT 1 
0.0004   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 9
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0028   SELECT `MV`.`title_id`, `MV`.`movie_id`, COUNT(DISTINCT MV.title_id) AS mv_count, `title`, `prefix`, `year`, `imdb_link`, `MT`.`imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, `genre_id_01`, `genre_id_02`, `genre_id_03`, MAX(MP.filename) AS filename, `G1`.`genre_name` AS `genre_name_01`, `G2`.`genre_name` AS `genre_name_02`, `G3`.`genre_name` AS `genre_name_03`, `date_viewed`, `notes`, `MV`.`format_id`, `FMT`.`format_name`, `MV`.`source_id`, `SRC`.`source_name`, `MV`.`device_id`, `DVC`.`device_name`, `MV`.`rating_id`, `STR`.`star_rating`, `rewatch`, 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, GROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actors, GROUP_CONCAT(DISTINCT(ACT.tmdb_actor_id) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actor_ids
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
LEFT JOIN `ml_movie_posters` `MP` ON `MV`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_lookup_genres` `G1` ON `MV`.`genre_id_01` = `G1`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G2` ON `MV`.`genre_id_02` = `G2`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G3` ON `MV`.`genre_id_03` = `G3`.`genre_id`
LEFT JOIN `ml_lookup_formats` `FMT` ON `MV`.`format_id` = `FMT`.`format_id`
LEFT JOIN `ml_lookup_sources` `SRC` ON `MV`.`source_id` = `SRC`.`source_id`
LEFT JOIN `ml_lookup_devices` `DVC` ON `MV`.`device_id` = `DVC`.`device_id`
LEFT JOIN `ml_movie_ratings_ten_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_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`
LEFT JOIN `ml_junction_movies_actors` `JMA` ON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MV`.`movie_id` = 7841
AND `MV`.`user_id` = 9
ORDER BY `date_viewed` DESC 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0002   SELECT `event_title`, `JME`.`event_id`
FROM `ml_junction_movies_events` `JME`
LEFT JOIN `ml_movie_events` `EV` ON `JME`.`event_id` = `EV`.`event_id`
WHERE `JME`.`movie_id` = 7841 
0.0002   SELECT `tag`, `JMT`.`tag_id`
FROM `ml_junction_movies_tags` `JMT`
LEFT JOIN `ml_tags` `MT` ON `JMT`.`tag_id` = `MT`.`tag_id`
WHERE `JMT`.`movie_id` = 7841 
0.0002   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 9
 LIMIT 1 
0.0002   SELECT `rating_id`
FROM `ml_movies` `MV`
WHERE `MV`.`user_id` = 9
AND `MV`.`movie_id` = 7841
 LIMIT 1 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star` `MR`
WHERE `MR`.`rating_id` = '19'
 LIMIT 1 
0.0003   SELECT `MV2`.`date_viewed`, `MV2`.`movie_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_movies` `MV2` ON `MV`.`title_id` = `MV2`.`title_id` AND `MV`.`user_id` = `MV2`.`user_id`
WHERE `MV`.`user_id` = 9
AND `MV`.`movie_id` = 7841
GROUP BY `MV2`.`movie_id`
ORDER BY `MV2`.`date_viewed` DESC 
0.0002   SELECT `comment_id`, `comment`, `commenter_id`, `timestamp`, `username`, `email_address`
FROM `ml_comments` `MC`
JOIN `ml_users` `MU` ON `MU`.`user_id` = `MC`.`commenter_id`
WHERE `movie_id` = 7841 
0.0002   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 2398
ORDER BY `date_viewed` DESC
 LIMIT 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)