Secret Experience - [Interlude] Query Para Top Item

Secret Experience (https://secretexperience.net/index.php)

- [Lineage] Outros (https://secretexperience.net/forumdisplay.php?f=665)

- - [Interlude] Query Para Top Item (https://secretexperience.net/showthread.php?t=32825)

{ADM}REIS

06-09-2011 07:41 PM

Query Para Top Item

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

Citação:

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

Horários baseados na GMT -3. Agora são 12:30 AM.