$
sql
=
"SELECT `items`.`owner_id`, `items`.`item_type`, `items`.`amount`, `items`.`location`, `items`.`enchant`, `items_names`.`item_name` FROM `items` LEFT JOIN `items_names` ON `items`.`item_type` = `items_names`.`id` WHERE `owner_id` = '$objid' AND `location` = '$type'"
;