[Interlude] Query Para Top Item

[{ADM}REIS]

Galera Pedi o PayTaly Para Fazer Uma Query para mim ele fez E Pediu para Postrar Para todos !

SELECT
characters.char_name AS charName,
armor.`name` AS armorName,
etcitem.`name` AS etcName,
weapon.`name` AS weaponName,
items.count AS itemCount
FROM
characters
INNER JOIN items ON characters.obj_Id = items.owner_id
LEFT JOIN armor ON items.item_id = armor.item_id
LEFT JOIN etcitem ON items.item_id = etcitem.item_id
LEFT JOIN weapon ON items.item_id = weapon.item_id
WHERE
items.item_id = 57 AND
items.count > 0 AND
characters.accesslevel = 0
ORDER BY
itemCount DESC
LIMIT 100