SELECT
dom.id AS "Domain ID",
dom.domain AS "Domain",
(SELECT COUNT(DISTINCT p.post_id) FROM p_posts_spam_domains AS p WHERE p.spam_domain_id = dom.id) AS "Post Count",
(SELECT COUNT(DISTINCT t.domain_tag_id) FROM p_domain_tags_spam_domains AS t WHERE t.spam_domain_id = dom.id) AS "Tag Count"
FROM p_spam_domains AS dom;