Movielogr

Home

movie poster

Rating: 7.5 stars

Tags

China

Seen 1 time

Seen on: 02/28/2009

View on: IMDb | TMDb

Red Cliff (2008)

Directed by John Woo

History | War | Drama

Most recently watched by jakeneff, sleestakk

Overview

In 208 A.D., in the final days of the Han Dynasty, shrewd Prime Minster Cao convinced the fickle Emperor Han the only way to unite all of China was to declare war on the kingdoms of Xu in the west and East Wu in the south. Thus began a military campaign of unprecedented scale. Left with no other hope for survival, the kingdoms of Xu and East Wu formed an unlikely alliance.

Rated R | Length 145 minutes

Actors

Tony Leung Chiu-Wai | Chang Chen | Takeshi Kaneshiro | Zhang Fengyi | Nakamura Shidō II | Zhao Wei | Song Jia | Hu Jun | You Yong | Lin Chi-Ling | Yong Hou | Tong Dawei | Zhang Shan | Ba Sen Zha Bu | Jinsheng Zang | Shi Xiao-Hong | Qingxiang Wang | Hu Xiaoguang | Ma Jingjing | Eric Zhang | Xie Gang | Wang Hui | Xu Feng-Nian | Guo Chao | Cui Yu-Gui | Jiang Tong | Yi Zhen | Jia Hong-Wei | Zhao Cheng-Shun

Viewing Notes

Watched part 1 of John Woo’s ambitious and bloody period piece of one of the greatest wars in Chinese history; the north’s attempt at taking over the south. Part 1 came out in 2008 and leads up to right before the Han assault on Red Cliff. The half builds up the characters and it’s in the second half of part 1 that things really get interesting and intense. It’s a strange move for Woo but I always appreciate the subtlety of Tony Leung’s performance. Great to see Vicki Zhao in a strong role. The Guqin (seven-stringed zither) scene alone is worth the watch.

Comments

No comments yet. Log in and be the first!

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Movie Detail )  0.1677
Total Execution Time  0.1691
  GET DATA  
No GET data exists
  MEMORY USAGE  
532,848 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/movie_detail/8266
  CLASS/METHOD  
members/movie_detail
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 17 (0.1440 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '2b234b949208e9d1127cf0ed55f3e543b8270848'
AND `ip_address` = '216.73.216.6' ?>
0.1362  
SELECT GET_LOCK('716c793ca808ad580d8ba5457f3f7052', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '2b234b949208e9d1127cf0ed55f3e543b8270848'
AND `ip_address` = '216.73.216.6' ?>
0.0008  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0004  
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` = 8266
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.0026  
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` = 8266
AND `MV`.`user_id` = 9
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` = 8266 ?>
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` = 8266 ?>
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` = 8266
 LIMIT 1 ?>
0.0010  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star` `MR`
WHERE `MR`.`rating_id` = '17'
 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` = 8266
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` = 8266 ?>
0.0003  
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` = 4849
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)