SELECT
	count(*) as Pocet_registratorov,
	sum(pocet) as Pocet_zaplatenych_domen,
	sum(cena) as Revenue_summary
FROM (
	SELECT
		count(id_reg) AS pocet,
		IF (count(id_reg)>1000, count(id_reg)*13.28,
			IF (count(id_reg)>100, count(id_reg)*16.6,
				count(id_reg)*19.92)) AS cena
	FROM sknic_domains
	WHERE status in('DOM_OK','DOM_WARN','DOM_LNOT','DOM_TRAN')
	GROUP BY id_reg
	ORDER BY pocet DESC
) AS x;