Tags: Bravely Default IIFinal Fantasy VII RemakeNier ReplicantShadows of AdamThe Elder Scrolls Online
You may also like…
6 Responses
Leave a Reply
You must be logged in to post a comment.
RPGamer has been covering RPGs since 1998, with the current version of the site launched in 2018. Due to the wholesale change in our back-end and systems only certain content created from 2018 onwards has been carried over to our new site. However, all of our older content can still be found at archive.rpgamer.com.
Find us on:
Upcoming Games
DISTINCT
t.ID, `game_name_rd`.`name` AS upcoming_game_name,
`game_name_rd`.`term_id` AS upcoming_game_id,
`release_date`.`meta_value` AS upcoming_rel_date,
`game_region`.`post_title` AS upcoming_game_region_name,
COUNT(`platforms`.`slug`) AS upcoming_plat_cnt,
MAX(`platforms`.`slug`) as upcoming_plat_slug,
MAX(`platforms_platform_icon`.`guid`) AS upcoming_plat_icon
FROM `wp_posts` AS `t`
LEFT JOIN `wp_podsrel` AS `rel_game_name_rd` ON
`rel_game_name_rd`.`field_id` = 1012
AND `rel_game_name_rd`.`item_id` = `t`.`ID`
LEFT JOIN `wp_terms` AS `game_name_rd` ON
`game_name_rd`.`term_id` = `rel_game_name_rd`.`related_item_id`
LEFT JOIN `wp_postmeta` AS `release_date` ON
`release_date`.`meta_key` = ‘release_date’
AND `release_date`.`post_id` = `t`.`ID`
LEFT JOIN `wp_podsrel` AS `rel_game_region` ON
`rel_game_region`.`field_id` = 985
AND `rel_game_region`.`item_id` = `t`.`ID`
LEFT JOIN `wp_posts` AS `game_region` ON
`game_region`.`ID` = `rel_game_region`.`related_item_id`
LEFT JOIN `wp_podsrel` AS `rel_platforms` ON
`rel_platforms`.`field_id` = 984
AND `rel_platforms`.`item_id` = `t`.`ID`
LEFT JOIN `wp_terms` AS `platforms` ON
`platforms`.`term_id` = `rel_platforms`.`related_item_id`
LEFT JOIN `wp_postmeta` AS `fuzzy_date_-_month` ON
`fuzzy_date_-_month`.`meta_key` = ‘fuzzy_date_-_month’
AND `fuzzy_date_-_month`.`post_id` = `t`.`ID`
LEFT JOIN `wp_postmeta` AS `fuzzy_date_-_year` ON
`fuzzy_date_-_year`.`meta_key` = ‘fuzzy_date_-_year’
AND `fuzzy_date_-_year`.`post_id` = `t`.`ID`
WHERE ( ( `game_name_rd`.`name` IS NOT NULL AND `release_date`.`meta_value` > CURDATE() AND `game_region`.`post_title` = “US” ) AND ( `t`.`post_type` = ‘release_dates’ ) AND ( `t`.`post_status` IN ( ‘publish’ ) ) )
GROUP BY `game_name_rd`.`name`, `release_date`.`meta_value`, CONCAT(`fuzzy_date_-_month`.`meta_value`, `fuzzy_date_-_year`.`meta_value`)
ORDER BY `release_date`.`meta_value` ASC, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date`
LIMIT 0, 10; Response: Unknown column ‘platforms_platform_icon.guid’ in ‘field list’
Grand opening is Monster Hunter Stories 2, and grand closing is NEO: The World Ends With You. Depending on when they get in I’m also looking at getting in some Nocturne HD.
QOTW: For JRPG July, I’ll definitely be playing, and live streaming (at twitch.tv/featherhoof) (PLUG! 😁), Monster Hunter Stories 2! Maybe get in some of that upcoming Scarlet Nexus for myself, while I’m at it. Y’know, between gear and mount grinding and job leveling sessions in FFXIV.
I think this JRPG July might be when this Sega kid finally plays through FFVI. I got a couple of hours through the iOS port once, but found the graphics (and to a lesser extent the inputs) so offputting that I stopped playing. Pixels all the way…
The plan for JRPG July is to keep playing the JRPGs I’ve been playing in June: Trails to Azure and Xenogears. These should keep me busy until September or thereabouts.
I will be finishing up Trails of Cold steel 4 and starting Shin Megami Tensei III HD.