SQL: SELECT SQL_CACHE text.id AS id, text.id_parent AS id_parent, COALESCE(text_lang.title, text_lang_alt.title) AS title, COALESCE(text_lang.page_title, text_lang_alt.page_title) AS page_title, COALESCE(text_lang.text, text_lang_alt.text) AS text, COALESCE(text_lang.perex, text_lang_alt.perex) AS perex, COALESCE(text_lang.keywords, text_lang_alt.keywords) AS keywords, COALESCE(text_lang.description, text_lang_alt.description) AS description, COALESCE(text_lang.menu_name, text_lang_alt.menu_name) AS menu_name, text_lang.rewrite_title FROM text LEFT JOIN text_lang ON text_lang.id_text = text.id AND text_lang.id_lang = 1 LEFT JOIN text_lang AS text_lang_alt ON text_lang.id_lang IS NULL AND text_lang_alt.id_text = text.id AND text_lang_alt.id_lang = 1 WHERE text.id = AND text.id_domain = 1 LIMIT 1