Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- SUBSTR(DATA, INSTR(DATA, '"indexer": ') + 12, INSTR(SUBSTR(DATA, INSTR(DATA, '"indexer": ') + 12), '",') - 1) AS IndexerName,
- COUNT(*) AS GrabCount
- FROM History
- WHERE DATA LIKE '%indexer%'
- GROUP BY IndexerName
- ORDER BY GrabCount DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement