SELECT `mangos`.`item_template`.`name`
FROM `mangos`.`item_template`
WHERE `mangos`.`item_template`.`entry`
IN (

SELECT `characters`.`character_inventory`.`item_template`
FROM `characters`.`character_inventory`
WHERE `characters`.`character_inventory`.`guid` =1039986
)