Select en 3 tablas

[Neldor]

Otra opción sin subqueries:

Código MySQL:

SELECT * FROM Categories AS c CROSS JOIN Languages AS l 
LEFT OUTER JOIN Categories_lang AS cl ON cl.Id_category=c.Id AND cl.Id_lang=l.Id 
WHERE c.Id = '8';