<commit_before>select Markup, 0 as Priority from PROPERTIES where 
  SingularPhrase = $queryEqual or
  PluralPhrase = $queryEqual or
  IndexType = $queryEqual or
  DirectObjectType = $queryEqual or
  ResultType = $queryEqual
union
select Markup, 1 as Priority from CASTS where 
  ArgType = $queryEqual or
  Phrase = $queryEqual or
  ResultType = $queryEqual
union
select Markup, 2 as Priority from PROPERTIES where 
  SingularPhrase like $queryLike or
  PluralPhrase like $queryLike or
  IndexType like $queryLike or
  DirectObjectType like $queryLike or
  ResultType like $queryLike
union
select Markup, 3 as Priority from CASTS where 
  ArgType like $queryLike or
  Phrase like $queryLike or
  ResultType like $queryLike
order by Priority<commit_msg>Favor matching the phrase over matching the types<commit_after>select Markup, 0 as Priority from PROPERTIES where 
  SingularPhrase = $queryEqual or
  PluralPhrase = $queryEqual
union
select Markup, 1 as Priority from CASTS where 
  Phrase = $queryEqual
union
select Markup, 2 as Priority from PROPERTIES where 
  IndexType = $queryEqual or
  DirectObjectType = $queryEqual or
  ResultType = $queryEqual
union
select Markup, 3 as Priority from CASTS where 
  ArgType = $queryEqual or
  ResultType = $queryEqual
union
select Markup, 4 as Priority from PROPERTIES where 
  SingularPhrase like $queryLike or
  PluralPhrase like $queryLike
union
select Markup, 5 as Priority from CASTS where 
  Phrase like $queryLike
union
select Markup, 6 as Priority from PROPERTIES where 
  IndexType like $queryLike or
  DirectObjectType like $queryLike or
  ResultType like $queryLike
union
select Markup, 7 as Priority from CASTS where 
  ArgType like $queryLike or
  ResultType like $queryLike
order by Priority
{'fraction_non_alphanumeric': 0.037714285714285714, 'fraction_numerical': 0.006857142857142857, 'mean_word_length': 4.648387096774194, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3268151', 'n_tokens_mistral': 549, 'n_tokens_neox': 496, 'n_words': 218}