Small Barnacled Clam

Item

General

Item model

Field Value
entry 5523
class Junk
display_id 8047
sell_price 15c
inventory_type 0: Cannot Equip
spellid_1 0

In-game view

Small Barnacled Clam

Item icon

Junk
Cannot Equip
Level 10

Buy price: 60c

Stackable: 1

Item dropped by (71)

3721 Mystlash Hydra 68.31% 1224 Young Threshadon 55.76% 2187 Elder Darkshore Thresher 47.45% 3943 Ruuzel 44.63% 830 Sand Crawler 44.47% 2185 Darkshore Thresher 43.65% 3812 Clattering Crawler 42.42% 3814 Spined Crawler 42.36% 3944 Wrathtail Priestess 42.21% 1216 Shore Crawler 41.6% 544 Murloc Nightcrawler 41.45% 3740 Saltspittle Muckdweller 41.22% 3742 Saltspittle Oracle 40.76% 3461 Mud Thresh 40.59% 831 Sea Crawler 40.58% 3711 Wrathtail Myrmidon 40.2% 3722 Mystlash Flayer 40% 2236 Raging Reef Crawler 39.94% 2182 Stormscale Sorceress 39.93% 545 Murloc Tidecaller 39.92% 3652 Trigore the Lasher 39.71% 3737 Saltspittle Puddlejumper 39.31% 3715 Wrathtail Sea Witch 39.17% 127 Murloc Tidehunter 39.04% 2233 Encrusted Tide Crawler 38.89% 578 Murloc Scout 38.7% 422 Murloc Flesheater 38.57% 2235 Reef Crawler 38.4% 2181 Stormscale Myrmidon 38.24% 3398 Gesharahan 38.22% 391 Old Murk-Eye 38.15% 2208 Greymist Tidehunter 38.11% 3717 Wrathtail Sorceress 37.92% 2183 Stormscale Warrior 37.81% 1909 Vile Fin Lakestalker 37.75% 3713 Wrathtail Wave Rider 37.67% 2207 Greymist Oracle 37.64% 548 Murloc Minor Tidecaller 37.52% 3712 Wrathtail Razortail 37.44% 3739 Saltspittle Warrior 37.34% 519 Slark 37.13% 517 Murloc Oracle 36.6% 2180 Stormscale Siren 36.55% 1958 Vile Fin Tidecaller 36.47% 2234 Young Reef Crawler 36.3% 458 Murloc Hunter 35.84% 1957 Vile Fin Shorecreeper 35.75% 2206 Greymist Hunter 35.52% 2179 Stormscale Wave Rider 35.41% 2205 Greymist Warrior 35.34% 2232 Tide Crawler 35.31% 1083 Murloc Shorestriker 35.31% 1908 Vile Fin Oracle 35.09% 2231 Pygmy Tide Crawler 34.73% 171 Murloc Warrior 34.68% 513 Murloc Netter 34.62% 3641 Deviate Lurker 34.6% 1910 Muad 34.48% 456 Murloc Minor Oracle 34.21% 2204 Greymist Netter 33.99% 2203 Greymist Seer 33.68% 126 Murloc Coastrunner 33.14% 1767 Vile Fin Shredder 32.72% 1768 Vile Fin Tidehunter 32.01% 1911 Deeb 32% 2201 Greymist Raider 31.77% 2202 Greymist Coastrunner 31.09% 515 Murloc Raider 30.6% 645 Cookie 30% 3653 Kresh 30% 520 Brack 28.93%

Item details

UPDATE `item_template` SET `field` = xxxx WHERE (`entry` = 5523);
Field Value
entry 5523
class Junk
subclass None
name Small Barnacled Clam
description
display_id 8047
quality 1
flags 0x4: Has Loot
buy_count 1
buy_price 60c
sell_price 15c
inventory_type 0: Cannot Equip
allowable_class -1
allowable_race -1
item_level 10
required_level 0
required_skill 0: None
required_skill_rank 0
required_spell 0
required_honor_rank 0
required_city_rank 0
required_reputation_faction 0
required_reputation_rank 0
max_count 0
stackable 1
container_slots 0
stat_type1 0
stat_value1 0
stat_type2 0
stat_value2 0
stat_type3 0
stat_value3 0
stat_type4 0
stat_value4 0
stat_type5 0
stat_value5 0
stat_type6 0
stat_value6 0
stat_type7 0
stat_value7 0
stat_type8 0
stat_value8 0
stat_type9 0
stat_value9 0
stat_type10 0
stat_value10 0
delay 0
range_mod 0
ammo_type 0
dmg_min1 0
dmg_max1 0
dmg_type1 0
dmg_min2 0
dmg_max2 0
dmg_type2 0
dmg_min3 0
dmg_max3 0
dmg_type3 0
dmg_min4 0
dmg_max4 0
dmg_type4 0
dmg_min5 0
dmg_max5 0
dmg_type5 0
block 0
armor 0
holy_res 0
fire_res 0
nature_res 0
frost_res 0
shadow_res 0
arcane_res 0
spellid_1 0
spelltrigger_1 0
spellcharges_1 0
spellppmrate_1 0
spellcooldown_1 -1
spellcategory_1 0
spellcategorycooldown_1 -1
spellid_2 0
spelltrigger_2 0
spellcharges_2 0
spellppmrate_2 0
spellcooldown_2 -1
spellcategory_2 0
spellcategorycooldown_2 -1
spellid_3 0
spelltrigger_3 0
spellcharges_3 0
spellppmrate_3 0
spellcooldown_3 -1
spellcategory_3 0
spellcategorycooldown_3 -1
spellid_4 0
spelltrigger_4 0
spellcharges_4 0
spellppmrate_4 0
spellcooldown_4 -1
spellcategory_4 0
spellcategorycooldown_4 -1
spellid_5 0
spelltrigger_5 0
spellcharges_5 0
spellppmrate_5 0
spellcooldown_5 0
spellcategory_5 0
spellcategorycooldown_5 0
bonding 0: No bind
page_text 0
page_language 0
page_material 0
start_quest -
lock_id 0
material 0
sheath 0
random_property 0
set_id 0
max_durability 0
area_bound 0
map_bound 0
duration 0
bag_family 0
disenchant_id 0
food_type 0
min_money_loot 0
max_money_loot 0
extra_flags 0
ignored 0