gistfile1.txt

SELECT type, SUM(created) AS created, SUM(destroyed) AS destroyed FROM (
	(SELECT type, count(type) AS created, 0 AS destroyed FROM `lb-world` INNER JOIN `lb-players` USING (playerid) WHERE playername = 'DOKDOR' AND type > 0 AND type != replaced $dateClause GROUP BY type) 
		UNION 
	(SELECT replaced AS type, 0 AS created, count(replaced) AS destroyed FROM `lb-world` INNER JOIN `lb-players` USING (playerid) WHERE playername = 'DOKDOR' AND replaced > 0 AND type != replaced $dateClause GROUP BY replaced)
) AS t GROUP BY type ORDER BY SUM(created) + SUM(destroyed) DESC