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_postmeta` AS `release_date` ON
`release_date`.`meta_key` = ‘release_date’
AND `release_date`.`post_id` = `t`.`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 ‘game_name_rd.name’ in ‘field list’
