by RPGCast – Episode 373: “Banned from Punching”
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.
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’