mysql> SELECT fpn FROM metric_oscar_data1 JOIN external_facility USING (fpn) LEFT JOIN facility ON (external_facility.fpn = facility.fprovidernumber AND facility.facilityid NOT IN (1000,1001,1002)) WHERE metric_oscar_data1.metricdate BETWEEN '2002-02-28' AND '2004-02-29' AND metric_oscar_data1.fpn='f182760b' LIMIT 1;
+----------+
| fpn      |
+----------+
| f182760b | 
+----------+
1 row in set (0.00 sec)


mysql> SELECT facilityid, fprovidernumber FROM facility WHERE facilityid=1000;
+------------+-----------------+
| facilityid | fprovidernumber |
+------------+-----------------+
|       1000 | f182760b        | 
+------------+-----------------+
1 row in set (0.00 sec)