Couldn't get ind (SELECT game_aka.game_id, game_aka.aka_name as game_name, game_publisher.pub_dev_id as 'publisher_id', pd1.pub_dev_name as 'publisher_name', game_developer.dev_pub_id as 'developer_id', pd2.pub_dev_name as 'developer_name', game_year.game_year_id, game_year.game_year AS 'year', COUNT(screenshot_game.screenshot_id) AS 'screenshot', COUNT(game_music.music_id) AS 'music', COUNT(game_boxscan.game_boxscan_id) as 'boxscan', COUNT(game_download.game_download_id) AS 'download', game_ste_enhan.ste_enhanced, game_ste_only.ste_only FROM game_aka LEFT JOIN game_year ON (game_year.game_id = game_aka.game_id) LEFT JOIN game_boxscan ON (game_boxscan.game_id = game_aka.game_id) LEFT JOIN screenshot_game ON (screenshot_game.game_id = game_aka.game_id) LEFT JOIN game_music ON (game_music.game_id = game_aka.game_id) LEFT JOIN game_download ON (game_download.game_id = game_aka.game_id) LEFT JOIN game_falcon_only ON (game_aka.game_id = game_falcon_only.game_id) LEFT JOIN game_development ON (game_aka.game_id = game_development.game_id) LEFT JOIN game_wanted ON (game_aka.game_id = game_wanted.game_id) LEFT JOIN game_ste_enhan ON (game_aka.game_id = game_ste_enhan.game_id) LEFT JOIN game_ste_only ON (game_aka.game_id = game_ste_only.game_id) LEFT JOIN game_publisher ON (game_publisher.game_id = game_aka.game_id) LEFT JOIN pub_dev pd1 ON (pd1.pub_dev_id = game_publisher.pub_dev_id) LEFT JOIN game_developer ON (game_developer.game_id = game_aka.game_id) LEFT JOIN pub_dev pd2 on (pd2.pub_dev_id = game_developer.dev_pub_id) LEFT JOIN game_author on (game_author.game_id = game_aka.game_id) WHERE game_author.ind_id = '599' AND game_falcon_only.falcon_only IS NULL AND game_development.development IS NULL AND game_wanted.game_id IS NULL GROUP BY game_aka.aka_name)