Ver originalSELECT L.cod_pais, P.tituloFROM lang L LEFT JOIN posts P ON P.id_lang = L.id AND P.group_post = 1WHERE L.id NOT IN (SELECT 3 FROM lang)
Ver originalSELECT L.cod_pais, IF(ISNULL(P.titulo), '', P.titulo) AS tituloFROM lang L LEFT JOIN posts P ON P.id_lang = L.id AND P.group_post = 1WHERE L.id NOT IN (SELECT 1 FROM lang);