        SELECT BR.IDObject AS IDObject,               B.imgName AS imgName,                BK.imgPath AS imgPath,               BR.imgType AS imgType        FROM ImageReferences BR        INNER JOIN BDB_WebImages B ON BR.IDWebImage = B.ID        INNER JOIN BDB_WebImageCategory BK ON BR.IDImageCategory = BK.ID        LEFT OUTER JOIN DB_IMAGES BDB ON BDB.IDImage = b.IDOriginalBild             LEFT OUTER JOIN Multilingual_Translation MLSignature1 ON MLSignature1.IDObject = BR.ID                          AND MLSignature1.IDObjectType = 36                         AND MLSignature1.IDMultilingualAttribute = (SELECT TOP 1 ID FROM Multilingual_Attribute WHERE Tablename = 'BDB_WebImageReference' AND Columnname = 'titel')                         AND MLSignature1.IDLanguage = 1        LEFT OUTER JOIN Multilingual_Translation MLSignature2                       ON MLSignature2.IDObject = BR.ID                          AND MLSignature2.IDObjectType = 36                         AND MLSignature2.IDMultilingualAttribute = (SELECT TOP 1 ID FROM Multilingual_Attribute WHERE Tablename = 'BDB_WebImageReference' AND Columnname = 'Description')                         AND MLSignature2.IDLanguage = 1        LEFT OUTER JOIN Multilingual_Translation MLSignature3                       ON MLSignature3.IDObject = BR.ID                          AND MLSignature3.IDObjectType = 36                         AND MLSignature3.IDMultilingualAttribute = (SELECT TOP 1 ID FROM Multilingual_Attribute WHERE Tablename = 'BDB_WebImageReference' AND Columnname = 'Signature3')                         AND MLSignature3.IDLanguage = 1         LEFT OUTER JOIN SEO_Permalink SEODataWebImage                ON SEODataWebImage.IDObjekt = BR.ID               AND SEODataWebImage.IDType = 36               AND SEODataWebImage.IDLanguage = 1       LEFT OUTER JOIN SEO_Permalink SEODataBild                ON SEODataBild.IDObjekt = BDB.IDImage               AND SEODataBild.IDType = 33               AND SEODataBild.IDLanguage = 1WHERE BR.IDObjekt IN (25,26,38,40,45)AND BR.IDObjectType = 36
Optimizing this seemingly slow Query
optimization;sql