Sql consulta buscador wordpress

[gerazmv]

SELECT SQL_CALC_FOUND_ROWS wp_posts . * FROM wp_posts WHERE 1 =1 AND (((wp_posts.post_title LIKE '%pelicula%') OR (wp_posts.post_content LIKE 'pelicula'))) AND (wp_posts.post_status = 'publish' OR wp_posts.post_author =4 AND wp_posts.post_status = 'private' ) ORDER BY wp_posts.post_date DESC LIMIT 0 , 10

ya pude encontrar la consulta gracias