SELECT
e.record_id, e.index_entry, v.field_content

FROM
sierra_view.phrase_entry	as e

JOIN
sierra_view.varfield		as v
ON
  (v.record_id = e.record_id) AND (v.varfield_type_code = 'c')

WHERE
e.index_tag = 'c'

limit 10000