SELECT COUNT(1) as TOTAL_REGISTROS FROM blog p
inner join blog_txt txt on txt.id_blog = p.id_blog
where p.borrado='n' and txt.id_idioma = '10' and p.estado = '1' and (p.id_tema = '33' or p.id_tema in (select id_blog_tema FROM blog_temas where id_padre = '33')) and txt.titulo != ''
TTOAL;11