Query - MySQL - WordPress | Total Posts by No Category and Permalinks

query_mysql_total_posts_by_no_category_permalinks_WP.sql

SELECT 
    p.ID, 
    p.post_title, 
    CONCAT(o.option_value, '/', p.post_name, '/') AS permalink
FROM 
    wp_posts p
JOIN 
    wp_options o ON o.option_name = 'siteurl'
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 
    AND tt.taxonomy = 'category'
JOIN 
    wp_terms t ON tt.term_id = t.term_id
WHERE 
    p.post_type = 'post' 
    AND p.post_status = 'publish'
    AND t.slug = 'sin-categoria'
GROUP BY 
    p.ID, p.post_title, p.post_name, o.option_value;