Find unpublished categories in Mautic that have published campaigns under them. Because these categories are unpublished all campaigns under them will be paused.

campaigns_unpublished_by_category.sql

SELECT cat.id as category_id, cat.title as category_name, COUNT(camp.id) as campaigns
FROM campaigns camp
LEFT JOIN categories cat
	ON camp.category_id = cat.id
WHERE
	cat.is_published = 0
	AND camp.is_published = 1
GROUP BY cat.id;