SELECT items.id AS item_id, name_english AS name, type, subtype, price_buy, weight/10 AS weight, defense, `range`, slots, refineable, cost, cp_itemshop.id AS shop_item_id, IFNULL(price_sell, FLOOR(price_buy/2)) AS price_sell, view, attack, location_head_low, location_right_hand, location_garment, location_right_accessory, location_armor, location_left_hand, location_shoes, location_left_accessory, location_head_top, location_head_mid, location_costume_head_top, location_costume_head_mid, location_costume_head_low, location_costume_garment, location_ammo, location_shadow_armor, location_shadow_weapon, location_shadow_shield, location_shadow_shoes, location_shadow_right_accessory, location_shadow_left_accessory, origin_table FROM osro.items LEFT OUTER JOIN osro.cp_itemshop ON cp_itemshop.nameid = items.id WHERE 1=1 GROUP BY items.id, cp_itemshop.id ORDER BY `item_id` DESC, (CASE WHEN `subtype` IS NULL THEN 1 ELSE 0 END) ASC, `subtype` ASC LIMIT 20,20
Всего обнаружено 6173 записей на 309 странице. Отображение результата 21-40.
Item ID ▼ | Name | Type | SubType ▲ | Equip Locations | NPC Buy | NPC Sell | Weight | Attack | Defense | Range | Slots | Refineable | For Sale | Custom | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18503 | Small Devil Horns | Броня | None | Middle Headgear | 20 | 10 | 10 | 0 | 2 | 0 | 0 | No | No | No | |
18502 | Cheer Scarf10 | Броня | None | Lower Headgear | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | No | No | |
18501 | Cheer Scarf8 | Броня | None | Lower Headgear | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | No | No | |
18500 | Cheer Scarf6 | Броня | None | Lower Headgear | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No | No | No | |
18102 | Rudra Bow | Оружие | Лук | Two-Handed | 2 | 1 | 0 | 185 | 0 | 5 | 0 | No | No | No | |
18101 | Rudra Bow | Оружие | Лук | Two-Handed | 2 | 1 | 0 | 185 | 0 | 5 | 0 | No | No | No | |
18100 | Shooting Star | Оружие | Лук | Two-Handed | 20 | 10 | 0 | 190 | 0 | 5 | 0 | Yes | No | No | |
18004 | Iron Cannon Ball | Боеприпасы | Пушечное ядро | Ammo | 500 | 250 | 1 | 250 | 0 | 0 | 0 | No | No | No | |
18003 | Soul Cannon Ball | Боеприпасы | Пушечное ядро | Ammo | 200 | 100 | 1 | 120 | 0 | 0 | 0 | No | No | No | |
18002 | Dark Cannon Ball | Боеприпасы | Пушечное ядро | Ammo | 200 | 100 | 1 | 120 | 0 | 0 | 0 | No | No | No | |
18001 | Holy Cannon Ball | Боеприпасы | Пушечное ядро | Ammo | 200 | 100 | 1 | 120 | 0 | 0 | 0 | No | No | No | |
18000 | Cannon Ball | Боеприпасы | Пушечное ядро | Ammo | 100 | 50 | 1 | 100 | 0 | 0 | 0 | No | No | No | |
17105 | HD Elunium 50 Box | Используемые (ящик стрел) | None | None | 20 | 10 | 1 | 0 | 0 | 0 | 0 | No | No | No | |
17104 | HD Oridecon 50 Box | Используемые (ящик стрел) | None | None | 20 | 10 | 1 | 0 | 0 | 0 | 0 | No | No | No | |
16777 | Universal Catalog Gold 50 Box | Используемые (ящик стрел) | None | None | 0 | 0 | 1 | 0 | 0 | 0 | 0 | No | No | No | |
16776 | Universal Catalog Gold 10 Box | Используемые (ящик стрел) | None | None | 0 | 0 | 1 | 0 | 0 | 0 | 0 | No | No | No | |
16680 | Universal Catalog Gold 50 Box | Используемые (ящик стрел) | None | None | 0 | 0 | 1 | 0 | 0 | 0 | 0 | No | No | No | |
16679 | Universal Catalog Gold 10 Box | Используемые (ящик стрел) | None | None | 0 | 0 | 1 | 0 | 0 | 0 | 0 | No | No | No | |
16678 | Universal Catalog Gold 50 Box | Используемые (ящик стрел) | None | None | 0 | 0 | 1 | 0 | 0 | 0 | 0 | No | No | No | |
16677 | Universal Catalog Gold 10 Box | Используемые (ящик стрел) | None | None | 0 | 0 | 1 | 0 | 0 | 0 | 0 | No | No | No |