Re: How to make this query faster? UNION + Inner Join

[Rick James]

Yes INNER JOIN exists.

Suggest adding parens to clarify, perhaps thus:

( SELECT
        id,
        titel,
        skaparnamn,
        datumtid,
        private
    FROM  titlar
)
UNION  ALL 
( SELECT
        trad.titelid AS id,
        titlar.titel,
        trad.skaparnamn,
        trad.datumtid,
        trad.private
    FROM  trad
    INNER JOIN  titlar ON titlar.id = trad.titelid
)
ORDER BY  `datumtid` DESC
LIMIT  1