Quote:
Originally Posted by girth
[You must be logged in to view images. Log in or Register.]
Who has it?
|
SELECT `charid` , `character_`.`name`
FROM `inventory`
INNER JOIN `character_` ON `inventory`.`charid` = `character_`.`id`
WHERE `itemid` = '6631'
charid name
82164 Perun
75364 Katous
105219 Ivaarkavol