Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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_4790$
- WITH x9dfa5e8_title_xq AS (SELECT
- to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_4790$the$_4790$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), ''))&&
- to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_4790$blue$_4790$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), '')) AS tsq,
- to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_4790$the$_4790$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), '')) ||
- to_tsquery('simple', COALESCE(NULLIF( '(' || btrim(regexp_replace(search_normalize(split_date_range($_4790$blue$_4790$)),E'(?:\\s+|:)','&','g'),'&|') || ')', '()'), '')) AS tsq_rank ),lang_with AS (SELECT id FROM config.coded_value_map WHERE ctype = 'item_lang' AND code = $_4790$eng$_4790$)
- SELECT m.source AS id,
- ARRAY[m.source] AS records,
- 1.0/((AVG(
- (COALESCE(ts_rank_cd('{0.1, 0.2, 0.4, 1.0}', x9dfa5e8_title.index_vector, x9dfa5e8_title.tsq_rank, 14) * x9dfa5e8_title.weight, 0.0))
- )+1 * COALESCE( NULLIF( FIRST(mrv.vlist @> ARRAY[lang_with.id]), FALSE )::INT * 5, 1)))::NUMERIC AS rel,
- 1.0/((AVG(
- (COALESCE(ts_rank_cd('{0.1, 0.2, 0.4, 1.0}', x9dfa5e8_title.index_vector, x9dfa5e8_title.tsq_rank, 14) * x9dfa5e8_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, x9dfa5e8_title_xq.tsq, x9dfa5e8_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 x9dfa5e8_title_xq ON (fe.index_vector @@ x9dfa5e8_title_xq.tsq)
- ) AS x9dfa5e8_title ON (m.source = x9dfa5e8_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 (
- (x9dfa5e8_title.id IS NOT NULL)
- )
- GROUP BY 1
- ORDER BY 4 ASC NULLS LAST, 5 DESC NULLS LAST, 3 DESC
- LIMIT 10000
- $core_query_4790$::TEXT,
- $${}$$::INT[],
- $${}$$::INT[],
- NULL::INT,
- 1000::INT,
- 10000::INT,
- 'f'::BOOL,
- 'f'::BOOL,
- 'f'::BOOL,
- NULL::INT
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement