ayn/Radarr.out

## 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

## Radarr.out
Dognzb.cr|127
NZBgeek|79
Slug|59
Simplynzbs|16
fastNZB|9
NzbNoob|2

## Sonarr v1.out
NZBgeek|531
Dognzb.cr|402
Slug|82
fastNZB|32
Simplynzbs|18
NzbNoob|6

## Sonarr v2.out
DOGnzb|23
Slug|22
NZBgeek|16
NzbNoob|2
fastNZB|2
	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
	Dognzb.cr\|127
	NZBgeek\|79
	Slug\|59
	Simplynzbs\|16
	fastNZB\|9
	NzbNoob\|2
	NZBgeek\|531
	Dognzb.cr\|402
	Slug\|82
	fastNZB\|32
	Simplynzbs\|18
	NzbNoob\|6