Giant Robo: The Blu-Ray - Ships/In stores Today!

  • 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 Thu, 10/25/2012 - 17:33.
in
Image: 
GR-BD_set.jpg
The wait is finally over! Well, some of us will have to wait a bit longer being outside of Japan. In celebration of this exciting event, here's a collection of pics:

1-3: Box pics...too bad there aren't any of it open
4: The Double-sided pre-order bonus poster
5-6: Pics of the HUGE ad poster seen in stations...oh, to be able to get that poster...
Alt Image(s): 
Experts on the front
Another angle
Big Fire on the back
Double sided poster - pre-order bonus
HUGE GR poster in station
Straight on shot