SELECT DISTINCT
    person.name,
    'and ',
    person2.name AS name2,
    'are featured on page ',
    reference.page
FROM
    `story`.`person` AS `person`,
    `story`.`person` AS `person2`,
    `story`.`reference` as `reference`,
    `story`.`reference` as `reference2`
WHERE
    `person`.`name` LIKE 'Joe%'  AND `reference`.`idperson` = `person`.`idPerson` and
    `person2`.`name` LIKE 'Ze%' AND `reference2`.`idperson` = `person2`.`idPerson` and
    reference.page = reference2.`page`
ORDER BY 5
    ;