WP Query

SELECT DISTINCT SQL_CALC_FOUND_ROWS wpql_posts.*
FROM   wpql_posts
       INNER JOIN wpql_postmeta
               ON ( wpql_posts.id = wpql_postmeta.post_id )
       INNER JOIN wpql_postmeta AS a
               ON ( a.post_id = wpql_posts.id )
       INNER JOIN wpql_postmeta AS b
               ON ( ( b.meta_id = a.meta_id + @@auto_increment_increment )
                    AND ( b.post_id = wpql_posts.id ) )
       INNER JOIN wpql_posts AS c
               ON ( ( c.post_type = 'acf-field' )
                    AND ( ( c.post_content LIKE '%:"text"%' )
                           OR ( c.post_content LIKE '%:"textarea"%' )
                           OR ( c.post_content LIKE '%:"number"%' )
                           OR ( c.post_content LIKE '%:"email"%' )
                           OR ( c.post_content LIKE '%:"url"%' )
                           OR ( c.post_content LIKE '%:"file"%' )
                           OR ( c.post_content LIKE '%:"wysiwyg"%' )
                           OR ( c.post_content LIKE '%:"select"%' )
                           OR ( c.post_content LIKE '%:"checkbox"%' )
                           OR ( c.post_content LIKE '%:"radio"%' ) ) )
       LEFT JOIN wpql_posts AS d
              ON ( d.id = a.meta_value )
WHERE  1 = 1
       AND ( ( ( c.post_name = b.meta_value )
               AND ( a.meta_value LIKE '%Zubarev%' ) )
              OR ( ( wpql_posts.post_title LIKE '%Zubarev%' )
                    OR ( wpql_posts.post_content LIKE '%Zubarev%' )
                    OR ( wpql_posts.post_excerpt LIKE '%Zubarev%' ) )
              OR ( d.post_title LIKE '%Zubarev%' ) )
       AND ( wpql_postmeta.meta_key = 'date' )
       AND wpql_posts.post_type = 'research_paper'
       AND ( wpql_posts.post_status = 'publish'
              OR wpql_posts.post_status = 'acf-disabled'
              OR wpql_posts.post_status = 'private' )
GROUP  BY wpql_posts.id
ORDER  BY wpql_postmeta.meta_value + 0 DESC
LIMIT  0, 8