SELECT UNIQUE pid FROM
  (SELECT UNIQUE hobbyref.personid AS pid FROM hobby, hobbyref
    WHERE hobbyref.hobbyid = hobby.id AND hobby.type = 'tv')
  UNION
  (SELECT UNIQUE petref.personid AS pid FROM pet, petref
    WHERE petref.petid = pet.id AND pet.type = 'cat'
  )