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`;