SELECT DISTINCT
    `person`.`name`,
    'has personal relationship with ',
    `person2`.`name` AS `name2`,
    `Personal_relationship`.`precis` as `relationship`,
    `their_association`.`association` as `association`,
    `the_context`.`context`,
    `the_context_type`.`context_type`
 
FROM
    `story`.`person` AS `person`,
    `story`.`association` as `their_association`,
    `story`.`personal_relationship` as `Personal_relationship`,
    `story`.`person` AS `person2`,
    `story`.`pr_context` as `the_context`,
    `story`.`context_type` as `the_context_type`,
    `story`.`reference` as `reference`
WHERE
    `person`.`idPerson` = `Personal_relationship`.`idfirst_person` AND 
    `person2`.`idperson` = `Personal_relationship`.`idsecond_person` AND 
    `Personal_relationship`.`idassociation` = `their_association`.`idassociation` and 
    `Personal_relationship`.`idcontext` = `the_context`.`idpr_context` and 
    `the_context`.`idcontext_type` = `the_context_type`.`idcontext_type` and
    `reference`.`idperson` = `Personal_relationship`.`idfirst_person`
    ;