SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1  AND (((wp_posts.post_title LIKE '%rebel%') OR (wp_posts.post_content LIKE '%rebel%')))  AND (wp_posts.post_password = '')  AND wp_posts.post_type IN ('news_article', 'perf_task', 'lesson_plan', 'diff_perf_task', 'diff_lesson_plan') AND ((wp_posts.post_status = 'publish')) OR (
  (
    ( wp_postmeta.meta_key = 'pt_assessment' AND CAST(wp_postmeta.meta_value AS CHAR) LIKE '%rebel%' )
  )
) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title LIKE '%rebel%' DESC, wp_posts.post_date DESC LIMIT 0, 10