Thread: Miscellaneous: Foraging - Sludge water
View Single Post
  #2  
Old 10-07-2012, 08:59 AM
nilbog nilbog is offline
Project Manager

nilbog's Avatar

Join Date: Oct 2009
Posts: 14,724
Default

gtg, thanks.

select f.itemid, z.short_name from forage f left join zone z on (z.zoneidnumber=f.zoneid) where z.zoneidnumber in (110,111,112,113,114,115,116,118,119,120,121,123,1 25,128,129) and f.itemid = '19130'

19130 iceclad
19130 frozenshadow
19130 velketor
19130 kael
19130 skyshrine
19130 thurgadina
19130 eastwastes
19130 greatdivide
19130 wakening
19130 westwastes
19130 crystal
19130 necropolis
19130 sirens
19130 sleeper
19130 thurgadinb