Top Adena script

[relic]

Hi i have little problem with my top adena web script. My problem is that when someone have adena in inventory and in warehouse too, he is in top adena rank two times. One with adena in inventory and one time with adena in warehouse. I need help with command that will show only total amount of adena per user. If someone can help i will be glad :)

 

this is what i got in script:

 

WHERE builder = 0 AND account_id > 0 AND user_item.item_type = 57

ORDER BY adena DESC

 

dunno what command should have for warehouse column to count as one...

 

Thanks

[mcbigmac]

1. Look up and create complicated join\inner\union Queries.

Google instead of ask - this is SQL, not L2Off.

 

2. Write 2 queries, one with warehouse = 0 and warehouse = 1.

Add together result in php\html where matched char_id.