Core query for "the blue"

SELECT  * -- bib search: #CD_documentLength #CD_meanHarmonic #CD_uniqueWords core_limit(10000) limit(1000) estimation_strategy(inclusion)  keyword: title:"the blue" depth(0)
        FROM  search.query_parser_fts(
                  1::INT,
                  0::INT,
                 $core_query_11957$
WITH x92c3c28_title_xq AS (SELECT
   to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_11957$the$_11957$)),E'(?:\\s+|:)','&','g'),'&|')  || ')', '()'), ''))&&
   to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_11957$blue$_11957$)),E'(?:\\s+|:)','&','g'),'&|')  || ')', '()'), '')) AS tsq,
    to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_11957$the$_11957$)),E'(?:\\s+|:)','&','g'),'&|')  || ')', '()'), '')) ||
   to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_11957$blue$_11957$)),E'(?:\\s+|:)','&','g'),'&|')  || ')', '()'), '')) AS tsq_rank ),lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND code = $_11957$eng$_11957$)
 SELECT  m.source AS id,
     ARRAY[m.source] AS records,
     1.0/((AVG(
        (1)
       + (COALESCE(ts_rank_cd('{0.1, 0.2, 0.4, 1.0}', x92c3c28_title.index_vector, x92c3c28_title.tsq_rank, 0) * x92c3c28_title.weight, 0.0))
     )+1 * COALESCE( NULLIF( FIRST(mrv.vlist @> ARRAY[lang_with.id]), FALSE )::INT * 5, 1)))::NUMERIC AS rel,
     1.0/((AVG(
       (1)
       + (COALESCE(ts_rank_cd('{0.1, 0.2, 0.4, 1.0}', x92c3c28_title.index_vector, x92c3c28_title.tsq_rank, 0) * x92c3c28_title.weight, 0.0))
      )+1 * COALESCE( NULLIF( FIRST(mrv.vlist @> ARRAY[lang_with.id]), FALSE )::INT * 5, 1)))::NUMERIC AS rank,
      FIRST(pubdate_t.value) AS tie_break
  FROM  metabib.metarecord_source_map m

     LEFT JOIN (
       SELECT fe.*, fe_weight.weight, x92c3c28_title_xq.tsq, x92c3c28_title_xq.tsq_rank /* search */
         FROM  metabib.title_field_entry AS fe
            JOIN config.metabib_field AS fe_weight ON (fe_weight.id = fe.field)
         JOIN x92c3c28_title_xq ON (fe.index_vector @@ x92c3c28_title_xq.tsq)
     ) AS x92c3c28_title ON (m.source = x92c3c28_title.source)
      LEFT JOIN metabib.record_sorter pubdate_t ON m.source = pubdate_t.source AND attr = 'pubdate'

      INNER JOIN metabib.record_attr_vector_list mrv ON m.source = mrv.source

      ,lang_with
  WHERE 1=1
     AND (
        TRUE
      AND (
         (x92c3c28_title.id IS NOT NULL AND x92c3c28_title.value ~* $_11957$[[:<:]]the\ blue[[:>:]]$_11957$)
        )
     )
  GROUP BY 1
  ORDER BY 4 ASC NULLS LAST, 5 DESC NULLS LAST, 3 DESC
  LIMIT 10000
 $core_query_11957$::TEXT,
                 $${}$$::INT[],
                  $${}$$::INT[],
                  NULL::INT,
                  1000::INT,
                  10000::INT,
                 'f'::BOOL,
                 'f'::BOOL,
                'f'::BOOL,
                 NULL::INT
            );