SELECT object_category.objectCategoryID, object_category_ru.objectCategoryName FROM object_category LEFT JOIN object_category_ru ON object_category.objectCategoryID = object_category_ru.objectCategoryID WHERE object_category.objectCategoryID = resorts;

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