Something

SELECT`character_inventory`.`guid`,`character_inventory`.`item_template`,`item_template`.`name`,`character`.`name`FROM`character_inventory` ,`item_template` ,`character`WHERE`character_inventory`.`item` =  '6370048' AND`character_inventory`.`item_template` =  `item_template`.`entry` AND`character_inventory`.`guid` =  `character`.`guid`;