+------------+     +--------------------+     +-------------------+   
| PERSON     |     | PHONE_REACHABILITY |     | PHONE             |  
|------------|     |--------------------|     |-------------------+ 
| last_name  |     | phone_id           |     | phone_id          |  
| person_id  |     | person_id          |     | phone_prefix      |  
| ....       |     +--------------------+     | phone_number      | 
+------------+                                | phone_number_type | 
                                              | ....              | 
                                              +-------------------+

SELECT
	p.person_lastname,
	t1.phone_number business,
	t2.phone_number mobile
FROM
	person p
LEFT JOIN
	phone_reachability r1 ON p.person_id = r1.person_id 
LEFT JOIN
	phone_reachability r2 ON p.person_id = r2.person_id 
LEFT JOIN
	phone t1 ON r1.phone_id = t1.phone_id
LEFT JOIN
	phone t2 ON r2.phone_id = t2.phone_id
WHERE
	t1.phone_number_type = 1 
AND
	t2.phone_number_type = 3
AND
	p.person_id = $pid";

SELECT
   p.person_lastname,
   t1.phone_number business,
   t2.phone_number mobile
FROM
   person p
LEFT JOIN
   phone_reachability r1 ON p.person_id = r1.person_id
LEFT JOIN
   phone_reachability r2 ON p.person_id = r2.person_id
LEFT JOIN
   phone t1 ON r1.phone_id = t1.phone_id
AND
   t2.phone_number_type = 3
LEFT JOIN
   phone t2 ON r2.phone_id = t2.phone_id
AND
   t1.phone_number_type = 1
WHERE
   p.person_id = $pid";

person_lastname	business	mobile
xxxxx				 NULL		 NULL
xxxxx				 NULL 		NULL
xxxxx				 NULL 		611 52 20
xxxxx				 624 22 96  NULL
xxxxx				 624 22 96  NULL
xxxxx				 624 22 96  611 52 20
xxxxx				 NULL 		NULL
xxxxx				 NULL 		NULL
xxxxx				 NULL 		611 52 20

person_lastname	business	mobile
xxxxx				 624 22 96  611 52 20

SELECT
	p.person_lastname,
	(
		SELECT 
			t1.phone_number
		FROM
			phone_reachability r1
		LEFT JOIN 
			phone t1 ON r1.phone_id = t1.phone_id
		WHERE
			p.person_id = r1.person_id
		AND
			t1.phone_number_type = 1
	) business,
	(
		SELECT 
			t2.phone_number
		FROM
			phone_reachability r2
		LEFT JOIN 
			phone t2 ON r2.phone_id = t2.phone_id
		WHERE
			p.person_id = r2.person_id
		AND
			t2.phone_number_type = 3
	) mobile
FROM
	person p
WHERE
	p.person_id = $pid;