sermon query for custom wordpress

gistfile1.sql

SELECT DISTINCT p.ID
FROM wp_posts p
    LEFT JOIN wp_term_relationships tr ON tr.object_id = p.ID
    LEFT JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_id
    LEFT JOIN wp_terms t ON tt.term_id = t.term_id
WHERE p.post_type = "sermon" 
    AND p.post_status = "publish"
ORDER BY p.ID ASC