daily pastebin goal
48%
SHARE
TWEET

Untitled

a guest Aug 15th, 2018 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Time: 120523 14:37:48
  2. # User@Host: c9hlstatsxce[c9hlstatsxce] @ localhost []
  3. # Query_time: 4.820014  Lock_time: 0.000107 Rows_sent: 13  Rows_examined: 389369
  4. SET timestamp=1337801868;
  5. SELECT
  6.                         code,
  7.                         hlstats_Actions.description,
  8.                         COUNT(hlstats_Events_PlayerPlayerActions.id) AS obj_count,
  9.                         SUM(hlstats_Events_PlayerPlayerActions.bonus) * -1 AS obj_bonus
  10.                 FROM
  11.                         hlstats_Actions
  12.                 LEFT JOIN hlstats_Events_PlayerPlayerActions ON
  13.                         hlstats_Events_PlayerPlayerActions.actionId = hlstats_Actions.id
  14.                 LEFT JOIN hlstats_Players ON
  15.                         hlstats_Players.playerId=hlstats_Events_PlayerPlayerActions.victimId
  16.                 WHERE
  17.                         clan=12346
  18.                 GROUP BY
  19.                         hlstats_Actions.id
  20.                 ORDER BY
  21.                         obj_count asc,
  22.                         description asc;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top