SELECT 
	"translation_memories"."text_seg", 
	"translation_memories"."translation_memory_parent_id", 
	"dest_translation_memories".text_seg as translation_memory_target_seg, 
	"dest_translation_memories".language as language_target, 
	(length(text_to_search_vector)::float / translation_memories.tsv_seg_count * 0.04) + 0.95 AS rank 
FROM "translation_memories" 
INNER JOIN "translation_memories" "dest_translation_memories" ON 
	"dest_translation_memories"."translation_memory_parent_id" = "translation_memories"."translation_memory_parent_id" AND
	"dest_translation_memories"."id" != "translation_memories"."id"
INNER JOIN to_tsvector('pg_catalog.french', 'fièvre') text_to_search_vector ON 1=1 
INNER JOIN phraseto_tsquery('pg_catalog.french', 'fièvre') query ON 
	translation_memories.tsv_seg @@ query 
WHERE translation_memories.language = 'fr' AND
	dest_translation_memories.language = 'en'
ORDER BY 
	dest_translation_memories.tsv_seg_count asc, rank desc;