SQL to find wordpress post count using custom meta fields

SELECT 
    u.ID AS user_id,
    u.display_name AS user_name,
    u.user_email,
    COUNT(DISTINCT p.ID) AS post_count
FROM wp_posts p
INNER JOIN wp_postmeta pm 
    ON p.ID = pm.post_id
INNER JOIN wp_users u 
    ON u.ID = pm.meta_value
WHERE 
    p.post_status = 'publish'
    AND p.post_type = 'post'
    AND pm.meta_key = 'reported_by'
    AND pm.meta_value != ''
    AND p.post_date BETWEEN '2026-03-01 00:00:00' 
                         AND '2026-03-28 23:59:59'
GROUP BY u.ID
ORDER BY post_count DESC;