mysql - 没有字符的 SQL SELECT 项

Question

我有以下 SQL:

SELECT 
    M.* 
FROM 
    (
   SELECT MAX(counter) AS FirstUserDate, imdb_id, language, season, aufloesung, episode
   FROM autofehlerserie
    GROUP BY imdb_id, language
    ) foo 
    JOIN
    autofehlerserie M ON foo.imdb_id = M.imdb_id AND foo.language = M.language
ORDER BY
    foo.FirstUserDate DESC, M.imdb_id, M.aufloesung, cast(M.season as int), cast(M.episode as int)

但我只想要SELECT items WHERE marker not = "D"

我必须在这个 select 查询的什么地方添加它？

Answer 1

像下面这样使用它:

SELECT 
    M.* 
FROM 
    (
   SELECT MAX(counter) AS FirstUserDate, imdb_id, language, season, aufloesung, episode
   FROM autofehlerserie 
   WHERE marker <> 'D'
    GROUP BY imdb_id, language, season, aufloesung, episode
    ) foo 
    JOIN
    autofehlerserie M ON foo.imdb_id = M.imdb_id AND foo.language = M.language and M.marker <> 'D'
ORDER BY
    foo.FirstUserDate DESC, M.imdb_id, M.aufloesung, cast(M.season as int), cast(M.episode as int)