SELECT RELATED_ITEM.NAME AS RELATED_ITEM
FROM ITEM_SITE_CATEGORIES
JOIN ITEMS ON ITEMS.NAME = SUBSTR(ITEM_SITE_CATEGORIES.FULL_NAME,19,99999)
JOIN ITEMS AS RELATED_ITEM ON ITEM_SITE_CATEGORIES.ITEM_ID = RELATED_ITEM.ITEM_ID
WHERE CATEGORY_TYPE = 'REL' AND ITEMS.ITEM_ID = xxxx