问PostgreSQL -按左连一对多字段排序查询结果

EN

SELECT
    series.id as series.id,
    series."name",
    series."overview",
    series."firstAired",
    CAST(CASE WHEN posters."seriesId" IS NULL THEN false ELSE true END AS BOOLEAN) AS poster,
    FROM series
    LEFT JOIN "posters" ON posters."seriesId" = series.id
    LEFT JOIN "aliases" ON aliases."seriesId" = series.id
    WHERE (series.document @@to_tsquery(:query))
    OR (aliases.document @@to_tsquery(:query))
    GROUP BY series.id, posters."seriesId"
    ORDER BY
        GREATEST(
            ts_rank(series.document, to_tsquery(:query), 8),
            MAX(ts_rank(aliases.document, to_tsquery(:query), 8)),
            similarity(series."name", quote_literal(:query)),
            similarity(aliases."alias", quote_literal(:query))
        )
        DESC
        NULLS LAST;