Author: Adriaan den Ouden

Database 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_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'

Author: Adriaan den Ouden

Featured Posts

Recent Comments

Upcoming Games