Movielogr

Home

movie poster

Rating: 4.5 stars

Tags

BNAT BNAT 4 elves dwarves hobbits wizards kings

Seen 1 time

Seen on: 12/15/2002

Related Events

View on: IMDb | TMDb

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

Directed by Peter Jackson

Epic | Fantasy

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

It gets stuck with “middle child” syndrome a lot, but it’s still incredible and the Helm’s Deep battle is probably the beat action sequence in the entire trilogy.

Comments

No comments yet. Log in and be the first!

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movie Detail )  0.0286
Total Execution Time  0.0301
  GET DATA  
No GET data exists
  MEMORY USAGE  
551,504 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/pknail/movie_detail/2625
  CLASS/METHOD  
members/movie_detail
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 17 (0.0069 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '16d020e6af93b15953e1354732bfe1ffe1fee4d9'
AND `ip_address` = '216.73.216.57' 
0.0002   SELECT GET_LOCK('130723efacd70510afe39448ad5fd604', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '16d020e6af93b15953e1354732bfe1ffe1fee4d9'
AND `ip_address` = '216.73.216.57' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'pknail'
 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` = 2625
AND `MV`.`user_id` = 54
 LIMIT 1 
0.0003   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 54
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0031   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_five_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` = 2625
AND `MV`.`user_id` = 54
ORDER BY `date_viewed` DESC 
0.0001   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` = 2625 
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` = 2625 
0.0001   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 54
 LIMIT 1 
0.0001   SELECT `rating_id`
FROM `ml_movies` `MV`
WHERE `MV`.`user_id` = 54
AND `MV`.`movie_id` = 2625
 LIMIT 1 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_five_star` `MR`
WHERE `MR`.`rating_id` = '20'
 LIMIT 1 
0.0004   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` = 54
AND `MV`.`movie_id` = 2625
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` = 2625 
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)