select a1.* from(
SELECT
t4.name, t3.postype, t3.solpos, t3.solid, t3.kind, t3.solname,
case
when t1.postype = 1 and itempos <= 14 then 'equipped'
when t1.postype = 1 and itempos between 15 and 24 then 'inventory'
when t1.postype = 2 then 'extraslots'
when t1.postype = 3 then 'bookmount'
when t1.postype = 5 then 'bookhats'
when t1.postype = 6 then 'bookclothes'
when t1.postype = 9 then 'bookkeys'
else ''
end as posname,
t1.itempos, t1.itemunique, t2.itemname, t1.rank - 5 as itemrank, t1.itemnum
FROM [AT_GameDB01].[dbo].[tbl_SolItem] t1
inner join [AT_GameDB01].[dbo].[tbl_Item] t2 on t1.itemunique = t2.itemunique
inner join [AT_GameDB01].[dbo].[tbl_solmain] t3 on t1.solid = t3.solid
inner join [AT_GameDB01].[dbo].[tbl_Person] t4 on t3.personid = t4.personid
where t4.name = 'nickofplayer' and t2.serverid = 100 and t2.itemname is not null
) a1
order by a1.name, a1.postype, a1.solpos, a1.posname
solo utiliza el script que te entregue úsalo dentro de la base de datos y obtendrás todos los detalles que quieras saber sobre el jugador que buscas,
no existe otra forma, ya que la base de datos de la v3 esta faltante y nadie tiene una base de datos completa.
solo realiza eso que te menciono y evítate dolores de cabeza
