Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 7th, 2012  |  syntax: None  |  size: 0.23 KB  |  hits: 16  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SELECT a.name, m.account, k.name, count( * ) AS aantal
  2. FROM `mouselogs` m, accounts a, kingdoms k
  3. WHERE offset_x = screen_x
  4. AND offset_y = screen_y
  5. AND a.id = m.account
  6. AND a.kingdom = k.id
  7. GROUP BY account
  8. ORDER BY aantal DESC
create a new version of this paste RAW Paste Data