TFS 0.X SQL Query to get item count in backpacks of id

[GhostWD]

Hi OTLanders,

I've got problem with making query that returns items count for backpacks of id

what i need is getting pid of container, itemCount and correct itemtype

I've used

SELECT pid,  COUNT(*)
FROM player_items
GROUP BY pid
HAVING pid in (SELECT DISTINCT pid FROM player_items WHERE player_id = 2 AND itemtype IN (1987,1988))

But it's not doing what i trully wan't
Thanks for help!

 

[GhostWD]

oh... maybe i have it

SELECT pid, sid, COUNT(*)
FROM player_items
GROUP BY pid
HAVING pid in (SELECT DISTINCT sid FROM player_items WHERE player_id = 2 AND itemtype IN (1987)) and pid > 99

but i will appreciate better attempt

 

[GhostWD]

Bump