Movielogr

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Land of the Dead (2005)

Directed by George A. Romero

Most recently watched by sleestakk, sensoria

Overview

The world is full of zombies and the survivors have barricaded themselves inside a walled city to keep out the living dead. As the wealthy hide out in skyscrapers and chaos rules the streets, the rest of the survivors must find a way to stop the evolving zombies from breaking into the city.

Rated R | Length 93 minutes

Actors

Dennis Hopper | John Leguizamo | Tony Munch | Sasha Roiz | Christopher Allen Nelson | Shane Cardwell | Edgar Wright | Simon Pegg | Tom Savini | Phil Fondacaro | Peter Outerbridge | George A. Romero | Nick Alachiotis | Jonathan Whittaker | Asia Argento | Robert Joy | Boyd Banks | Earl Pastko | Robin Ward | David Sparrow | Ted Ludzik | Krista Bridges | James Binkley | Maxwell McCabe-Lokos | Heidi von Palleske | Ron Payne | Gregory Nicotero | Eugene Clark | Matt Birman | Tony Nappo | Bryan Renfro | Shawn Roberts | Bruce McFee | Devon Bostick | Joey Luthman | Joanne Boland | Jennifer Baxter | Alan van Sprang | Donna Croce | Pedro Miguel Arce | Gary Ugarek | Christopher Russell | Scott Wickware | Gene Mack | Dwayne McLean | Richard Clarkin | Jasmin Geljo | Jake McKinnon | Gino Crognale | Colm Magner | Darrin Brown | Lara Amersey | Kevin Rushton | Simon Baker | John Migliore | Ermes Blarasin | Sandy Kellerman | David Stinson | Trevor Bain | Eldridge Hyndman | Erica Olsen | Dawne Furey | Chad Camilleri | Liise Keeling | Tina Romero | Michael Belisario | Debra Felstead | Wilbert Headley | Ross Sferrazza | Sonia Belley | James Canton | Susan Wloszczyna | David Campbell

  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Overview / Movie Detail )  0.0222
Total Execution Time  0.0235
  GET DATA  
No GET data exists
  MEMORY USAGE  
521,072 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4462
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0048 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('01ca37e9d2f753d88b3e751725b82248'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4462
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len 12288 
0.0023   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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_movie_posters` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 4462
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0004   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 4462
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4462 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)