Query - MySQL - WordPress | Total Posts by category

query_mysql_total_posts_by_category_WP.sql

SELECT 
    COUNT(p.ID) AS total_contenidos
FROM 
    wp_posts p
JOIN 
    wp_term_relationships tr ON p.ID = tr.object_id
JOIN 
    wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN 
    wp_terms t ON tt.term_id = t.term_id
WHERE 
    p.post_status = 'publish' 
    AND p.post_type = 'post'
    AND tt.taxonomy = 'category'
    AND t.slug = 'leer-es-mi-cuento';