SELECT c.*, (SELECT COUNT(0) FROM publicacoes WHERE id_assunto = 47 and id_municipio = 1) as qtd FROM `assuntos` c WHERE `id_assunto` = 47