SELECT
a.*,
DATE_FORMAT(a.publish,"%d.%m.%Y %H:%i") as publish,
IF (a.tag IS NULL,0,1) as custom,
am.*,
a.ID,
CONCAT("original",".",a.extension) as image,
CONCAT("thumb",".",a.extension) as thumb,
(SELECT
language_id FROM bn_articles_meta
WHERE
ArticleID = 77405
AND language_id != 2
AND enabled = 1) as otherEnabledLanguage
FROM bn_articles a
LEFT JOIN bn_articles_meta am
ON am.ArticleID = a.ID
WHERE am.language_id = 2
AND a.ID = 77405 LIMIT 1