Advertisement
Guest User

Number of Grabs by Indexer

a guest
Nov 7th, 2015
801
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. SELECT
  2.     SUBSTR(DATA, INSTR(DATA, '"indexer": ') + 12, INSTR(SUBSTR(DATA, INSTR(DATA, '"indexer": ') + 12), '",') - 1) AS IndexerName,
  3.     COUNT(*) AS GrabCount
  4. FROM History
  5. WHERE DATA LIKE '%indexer%'
  6. GROUP BY IndexerName
  7. ORDER BY GrabCount DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement