RPGCast – Episode 656 : “He Fought a Bridge!”

by
Kelley Ryan

·

Published November 20, 2022
· Updated February 4, 2023

Tags: Hyrule WarriorsPokémon Scarlet / VioletPoker QuestRune Factory 5Shop TitansSoul Hackers 2World of Warcraft: Dragonflight

Kelley Ryan

Kelley’s three favorite things in this world are cats, heavy metal music, and RPGs. They are happily married to their best friend, and enjoys other hobbies like drawing, painting miniatures, and reading.

You may also like…

4 Responses

Comments4
Pingbacks0

Firstly… Go Team Violet ✊ Go Team Quaxly! I hope to play, too, someday in the future.

Secondly, QOTW: I’m resisting the allure of Black Friday this year super hard, because I have a 5 year old i7-8700k/GTX 1080 PC that I’ve been abusing with constant recording, editing, rendering, streaming, and VR playing it can barely handle that I desperately am trying to save up for rebuilding 😅 And I don’t even have enough saved up to look at Black Friday prices for PC parts this year, yet. Especially as GPUs have skyrocketed in price *again*.

For my Black Friday pickups I got Star Ocean: The Divine Force for $47, Soul Hackers 2 for $30, and upgraded to PS+ extra with the 25% off deal that PlayStation had which was $75. Probably will not get to these games till next year because I have my next set of games planned out that will take the rest of the year going into next year but they will be a top priority after that.

My black friday pick ups were a black ps5 controller, sonic frontiers, tmnt cowabunga collection and 13 sentinels on the switch since you guys praise it so much. non gaming related I got a pair of running shoes.

My only pick up was Persona 5 Royal on the PC. Been happy to replay it once more.

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:

Featured Posts

Upcoming GamesDatabase Error; SQL: SELECT

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’