Giant Robo: The Blu-Ray Box set - Promo Poster

  • user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p222r372_grcms.n.nid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT n.nid AS nid, COUNT(DISTINCT(n.nid)) AS count, term_data.tid AS term_data_tid, term_data.name AS term_data_name FROM node AS n INNER JOIN taxonomy_facets_term_node AS term_node ON n.nid = term_node.nid INNER JOIN term_hierarchy AS term_hierarchy ON term_node.tid = term_hierarchy.tid INNER JOIN term_data AS term_data ON term_node.tid = term_data.tid WHERE ((n.status = 1) AND (n.type IN ('image')) AND (term_hierarchy.parent = 0) AND (term_data.vid = 12) AND (n.type IN ('image'))) AND n.nid IN (SELECT node.nid FROM node node LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN content_field_comic_page node_data_field_comic_page ON node.vid = node_data_field_comic_page.vid ) GROUP BY term_data_tid ASC ORDER BY count DESC, term_data.weight ASC, term_data.name ASC LIMIT 0, 11 in /home/p222r372/public_html/includes/database.mysql.inc on line 172.
  • user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p222r372_grcms.n.nid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT n.nid AS nid, COUNT(DISTINCT(n.nid)) AS count, term_data.tid AS term_data_tid, term_data.name AS term_data_name FROM node AS n INNER JOIN taxonomy_facets_term_node AS term_node ON n.nid = term_node.nid INNER JOIN term_hierarchy AS term_hierarchy ON term_node.tid = term_hierarchy.tid INNER JOIN term_data AS term_data ON term_node.tid = term_data.tid WHERE ((n.status = 1) AND (n.type IN ('image')) AND (term_hierarchy.parent = 0) AND (term_data.vid = 11) AND (n.type IN ('image'))) AND n.nid IN (SELECT node.nid FROM node node LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN content_field_comic_page node_data_field_comic_page ON node.vid = node_data_field_comic_page.vid ) GROUP BY term_data_tid ASC ORDER BY count DESC, term_data.weight ASC, term_data.name ASC LIMIT 0, 11 in /home/p222r372/public_html/includes/database.mysql.inc on line 172.
  • user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p222r372_grcms.n.nid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT n.nid AS nid, COUNT(DISTINCT(n.nid)) AS count, term_data.tid AS term_data_tid, term_data.name AS term_data_name FROM node AS n INNER JOIN taxonomy_facets_term_node AS term_node ON n.nid = term_node.nid INNER JOIN term_hierarchy AS term_hierarchy ON term_node.tid = term_hierarchy.tid INNER JOIN term_data AS term_data ON term_node.tid = term_data.tid WHERE ((n.status = 1) AND (n.type IN ('image')) AND (term_hierarchy.parent = 0) AND (term_data.vid = 1) AND (n.type IN ('image'))) AND n.nid IN (SELECT node.nid FROM node node LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN content_field_comic_page node_data_field_comic_page ON node.vid = node_data_field_comic_page.vid ) GROUP BY term_data_tid ASC ORDER BY count DESC, term_data.weight ASC, term_data.name ASC LIMIT 0, 26 in /home/p222r372/public_html/includes/database.mysql.inc on line 172.
  • user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p222r372_grcms.n.nid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT n.nid AS nid, COUNT(DISTINCT(n.nid)) AS count, term_data.tid AS term_data_tid, term_data.name AS term_data_name FROM node AS n INNER JOIN taxonomy_facets_term_node AS term_node ON n.nid = term_node.nid INNER JOIN term_hierarchy AS term_hierarchy ON term_node.tid = term_hierarchy.tid INNER JOIN term_data AS term_data ON term_node.tid = term_data.tid WHERE ((n.status = 1) AND (n.type IN ('image')) AND (term_hierarchy.parent = 0) AND (term_data.vid = 13) AND (n.type IN ('image'))) AND n.nid IN (SELECT node.nid FROM node node LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN content_field_comic_page node_data_field_comic_page ON node.vid = node_data_field_comic_page.vid ) GROUP BY term_data_tid ASC ORDER BY count DESC, term_data.weight ASC, term_data.name ASC LIMIT 0, 11 in /home/p222r372/public_html/includes/database.mysql.inc on line 172.
  • user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p222r372_grcms.n.nid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT n.nid AS nid, COUNT(DISTINCT(n.nid)) AS count, term_data.tid AS term_data_tid, term_data.name AS term_data_name FROM node AS n INNER JOIN taxonomy_facets_term_node AS term_node ON n.nid = term_node.nid INNER JOIN term_hierarchy AS term_hierarchy ON term_node.tid = term_hierarchy.tid INNER JOIN term_data AS term_data ON term_node.tid = term_data.tid WHERE ((n.status = 1) AND (n.type IN ('image')) AND (term_hierarchy.parent = 0) AND (term_data.vid = 8) AND (n.type IN ('image'))) AND n.nid IN (SELECT node.nid FROM node node LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN content_field_comic_page node_data_field_comic_page ON node.vid = node_data_field_comic_page.vid ) GROUP BY term_data_tid ASC ORDER BY count DESC, term_data.weight ASC, term_data.name ASC LIMIT 0, 11 in /home/p222r372/public_html/includes/database.mysql.inc on line 172.
  • user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p222r372_grcms.n.nid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT n.nid AS nid, COUNT(DISTINCT(n.nid)) AS count, term_data.tid AS term_data_tid, term_data.name AS term_data_name FROM node AS n INNER JOIN taxonomy_facets_term_node AS term_node ON n.nid = term_node.nid INNER JOIN term_hierarchy AS term_hierarchy ON term_node.tid = term_hierarchy.tid INNER JOIN term_data AS term_data ON term_node.tid = term_data.tid WHERE ((n.status = 1) AND (n.type IN ('image')) AND (term_hierarchy.parent = 0) AND (term_data.vid = 10) AND (n.type IN ('image'))) AND n.nid IN (SELECT node.nid FROM node node LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN content_field_comic_page node_data_field_comic_page ON node.vid = node_data_field_comic_page.vid ) GROUP BY term_data_tid ASC ORDER BY count DESC, term_data.weight ASC, term_data.name ASC LIMIT 0, 11 in /home/p222r372/public_html/includes/database.mysql.inc on line 172.
  • user warning: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p222r372_grcms.n.nid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT n.nid AS nid, COUNT(DISTINCT(n.nid)) AS count, term_data.tid AS term_data_tid, term_data.name AS term_data_name FROM node AS n INNER JOIN taxonomy_facets_term_node AS term_node ON n.nid = term_node.nid INNER JOIN term_hierarchy AS term_hierarchy ON term_node.tid = term_hierarchy.tid INNER JOIN term_data AS term_data ON term_node.tid = term_data.tid WHERE ((n.status = 1) AND (n.type IN ('image')) AND (term_hierarchy.parent = 0) AND (term_data.vid = 9) AND (n.type IN ('image'))) AND n.nid IN (SELECT node.nid FROM node node LEFT JOIN content_field_image node_data_field_image ON node.vid = node_data_field_image.vid LEFT JOIN content_field_comic_page node_data_field_comic_page ON node.vid = node_data_field_comic_page.vid ) GROUP BY term_data_tid ASC ORDER BY count DESC, term_data.weight ASC, term_data.name ASC LIMIT 0, 11 in /home/p222r372/public_html/includes/database.mysql.inc on line 172.
Submitted by Big Fire on Sat, 01/12/2013 - 22:46.
in
Image: 
GR_BD_PO_Cel9.jpg
A poster so EPIC, it needed 2 sides!

This is the pre-order privilege item available through certain retailers. The only thing typical about this poster is it is B2 size.

First, the poster has a heavier paper stock than usual. It is also printed on both sides with amazing illustrations by Akihiko Yamashita (one of the two original character designers from the OVA - who is currently an Animation Director at Studio Ghibli); one side features the IPO and the Celestial 9 while the other represents BF and the Magnificent 10. The iconic GR title (found on both sides) is printed in a red foil which was a pleasant surprise!

The only downside (if you can call it that) to this double sided poster is that in order to display this awesome poster to the fullest, you'll probably want to pick up two...
Alt Image(s): 
IPO Foil Logo
BF Foil Logo
DS poster
Back: 
BF Side