# 1. все слоты
select
es.*,
it.name item_type_name
from equipmentslot es
join itemtype it on it.id = es.item_type_id

# 2. все слоты всех игроков персонажа
select pes.* from PlayerEquipmentSlot pes
join CharacterPlayer cp on cp.player_id = pes.player_id
where cp.character_id = 1;

# 3. все предметы всех игроков персонажа
select ci.id character_item_id, i.*, ci.durability_spend
from characteritem ci
join item i on i.id = ci.item_id
where ci.character_id = 1