SELECT URL, SUM(c) c
FROM (
 SELECT URL, COUNT(*) c FROM gw_topics GROUP BY URL
 UNION ALL
 SELECT Taxon AS URL, COUNT(*) c FROM gz_life_mammals GROUP BY URL
 UNION ALL
 SELECT Slug AS URL, COUNT(*) c FROM gz_life_mammals GROUP BY URL
 ) AS Combined
GROUP BY URL
HAVING c > 1