Skip to content

Instantly share code, notes, and snippets.

@ayn

ayn/Radarr.out

Last active December 4, 2019 18:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ayn/f0cc35366f341083c821f8bc856b2252 to your computer and use it in GitHub Desktop.
Save ayn/f0cc35366f341083c821f8bc856b2252 to your computer and use it in GitHub Desktop.
Download ZIP
indexers stats
Raw
indexer_query.sql
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
Raw
Radarr.out
Dognzb.cr|127
NZBgeek|79
Slug|59
Simplynzbs|16
fastNZB|9
NzbNoob|2
Raw
Sonarr v1.out
NZBgeek|531
Dognzb.cr|402
Slug|82
fastNZB|32
Simplynzbs|18
NzbNoob|6
Raw
Sonarr v2.out
DOGnzb|23
Slug|22
NZBgeek|16
NzbNoob|2
fastNZB|2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment