Query Pada Wordpress

SELECT
wp_posts.ID,
wp_posts.post_author,
wp_posts.post_date,
wp_posts.post_date_gmt,
wp_posts.post_content,
wp_posts.post_title,
wp_posts.post_excerpt,
wp_posts.post_status,
wp_posts.comment_status,
wp_posts.ping_status,
wp_posts.post_password,
wp_posts.post_name,
wp_posts.to_ping,
wp_posts.pinged,
wp_posts.post_modified,
wp_posts.post_modified_gmt,
wp_posts.post_content_filtered,
wp_posts.post_parent,
wp_posts.guid,
wp_posts.menu_order,
wp_posts.post_type,
wp_posts.post_mime_type,
wp_posts.comment_count,
event_yys.nama
FROM
wp_posts
left JOIN event_yys ON wp_posts.ID = event_yys.ID_RELASI
WHERE post_status = 'publish' and wp_posts.ID in (select object_id from wp_term_relationships where term_taxonomy_id in (SELECT term_taxonomy_id FROM wp_term_taxonomy where taxonomy='category' and term_id in(SELECT term_id FROM wp_terms where `name` in ('news'))))