Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.41 KB | None | 0 0
  1. select
  2.     zonemap.AreaName_Lang_enUS as Zone
  3.   ,COUNT(guid) as Count
  4.   ,sum( case when ca.spell in (8326, 20584) then 1 else 0 end)
  5. from andorhal_char.characters c
  6.     join andorhal_world.db_areatable_12340 zonemap on zonemap.id = c.zone
  7.     join character_aura ca on c.guid = ca.guid
  8.     where name <> "" and zone <> 0 and UNIX_TIMESTAMP(DATE_ADD(CURDATE(),INTERVAL -14 DAY)) > logout_time
  9.     group by zone
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement