A contact's display name: a contact_field_values row under its type's "Name" field, not a
column. LIMIT 1 because contact_field_values has no unique index on (contact_id, field_id),
so a contact can carry two and a join would duplicate the owning row.
A contact's display name: a
contact_field_valuesrow under its type's"Name"field, not a column.LIMIT 1becausecontact_field_valueshas no unique index on(contact_id, field_id), so a contact can carry two and a join would duplicate the owning row.