inclusive wordpress query.sql

USE development;
SELECT wp_posts.ID FROM wp_posts
INNER JOIN
  wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id
INNER JOIN
  wp_term_taxonomy ON (wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id)
INNER JOIN
  wp_terms ON (wp_terms.term_id = wp_term_taxonomy.term_id)
	WHERE 1=1  AND (
		(
         (wp_posts.post_title LIKE '%redirect%') OR (wp_posts.post_excerpt LIKE '%redirect%') OR (wp_posts.post_content LIKE '%redirect%')
		)
	)  AND wp_posts.post_type = 'document_cpt' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private') OR
      (
        wp_term_taxonomy.taxonomy = 'document_tags'
        AND
        wp_terms.name LIKE '%redirect%'
      )  GROUP BY wp_posts.ID ORDER BY wp_posts.post_title LIKE '%redirect%' DESC, wp_posts.post_date DESC LIMIT 0, 20;