Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- zonemap.AreaName_Lang_enUS as Zone
- ,COUNT(guid) as Count
- ,sum( case when ca.spell in (8326, 20584) then 1 else 0 end)
- from andorhal_char.characters c
- join andorhal_world.db_areatable_12340 zonemap on zonemap.id = c.zone
- join character_aura ca on c.guid = ca.guid
- where name <> "" and zone <> 0 and UNIX_TIMESTAMP(DATE_ADD(CURDATE(),INTERVAL -14 DAY)) > logout_time
- group by zone
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement