Author: Bryan Boullette

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

Author: Bryan Boullette

Featured Posts

Recent Comments

Upcoming Games