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 (CASE WHEN `item_id` IS NULL THEN 1 ELSE 0 END) ASC, `item_id` ASC, (CASE WHEN `name` IS NULL THEN 1 ELSE 0 END) ASC, `name` ASC, (CASE WHEN `slots` IS NULL THEN 1 ELSE 0 END) ASC, `slots` ASC LIMIT 140,20
Всего обнаружено 6173 записей на 309 странице. Отображение результата 141-160.
Item ID ▲ | Name ▲ | Type | SubType | Equip Locations | NPC Buy | NPC Sell | Weight | Attack | Defense | Range | Slots ▲ | Refineable | For Sale | Custom | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
656 | Awakening Potion | Используемые (ящик стрел) | None | None | 1,500 | 750 | 15 | 0 | 0 | 0 | 0 | No | No | No | |
657 | Berserk Potion | Используемые (ящик стрел) | None | None | 3,000 | 1,500 | 20 | 0 | 0 | 0 | 0 | No | No | No | |
658 | Union of Tribe | Используемые (ящик стрел) | None | None | 2 | 1 | 50 | 0 | 0 | 0 | 0 | No | No | No | |
659 | Her Heart | Используемые (ящик стрел) | None | None | 500 | 250 | 5 | 0 | 0 | 0 | 0 | No | No | No | |
660 | Forbidden Red Candle | Используемые (ящик стрел) | None | None | 20,000 | 10,000 | 5 | 0 | 0 | 0 | 0 | No | No | No | |
661 | Soft Apron | Используемые (ящик стрел) | None | None | 20,000 | 10,000 | 5 | 0 | 0 | 0 | 0 | No | No | No | |
662 | Authoritative Badge | Используемые (ящик стрел) | None | None | 1,450 | 725 | 3 | 0 | 0 | 0 | 0 | No | No | No | |
663 | Korean Rice Cake | Лечение | None | None | 1 | 0 | 1 | 0 | 0 | 0 | 0 | No | No | No | |
664 | Gift Box | Используемые (ящик стрел) | None | None | 1,000 | 500 | 20 | 0 | 0 | 0 | 0 | No | No | No | |
665 | Gift Box | Используемые (ящик стрел) | None | None | 1,000 | 500 | 20 | 0 | 0 | 0 | 0 | No | No | No | |
666 | Gift Box | Используемые (ящик стрел) | None | None | 1,000 | 500 | 20 | 0 | 0 | 0 | 0 | No | No | No | |
667 | Gift Box | Используемые (ящик стрел) | None | None | 1,000 | 500 | 20 | 0 | 0 | 0 | 0 | No | No | No | |
668 | Red Envelope | Используемые (ящик стрел) | None | None | 0 | 0 | 2 | 0 | 0 | 0 | 0 | No | No | No | |
669 | Tempting Rice-Cake Soup | Лечение | None | None | 500 | 250 | 10 | 0 | 0 | 0 | 0 | No | No | No | |
670 | Bag of Gold Coins | Прочее | None | None | 100,000 | 50,000 | 40 | 0 | 0 | 0 | 0 | No | No | No | |
671 | Gold Coin | Прочее | None | None | 10,000 | 5,000 | 4 | 0 | 0 | 0 | 0 | No | No | No | |
672 | Bag of Bronze Coins | Прочее | None | None | 1,000 | 500 | 40 | 0 | 0 | 0 | 0 | No | No | No | |
673 | Bronze Coin | Прочее | None | None | 100 | 50 | 4 | 0 | 0 | 0 | 0 | No | No | No | |
674 | Mithril Coin | Прочее | None | None | 5,000 | 2,500 | 4 | 0 | 0 | 0 | 0 | No | No | No | |
675 | Silver Coin | Прочее | None | None | 5,000 | 2,500 | 4 | 0 | 0 | 0 | 0 | No | No | No |