SELECT * FROM object LEFT JOIN object_ru ON object.objectID = object_ru.objectID WHERE object.objectID = black_corals;

Неправильный запрос