select COUNT(*) from ALLERGY where PID in (select PID from tmp_42cfr_distinct)
select COUNT(*) from DIRECTIV where PID in (select PID from tmp_42cfr_distinct)
select COUNT(*) from FLAG where CONTEXTID1 in (select PID from tmp_42cfr_distinct)
select COUNT(*) from MEDICATE where PID in (select PID from tmp_42cfr_distinct)
select COUNT(*) from OBS where PID in (select PID from tmp_42cfr_distinct)
select COUNT(*) from PROBLEM where PID in (select PID from tmp_42cfr_distinct)
select COUNT(*) from IMMUNIZATION where PID in (select PID from tmp_42cfr_distinct)
select COUNT(*) from ORDERS where PID in (select PID from tmp_42cfr_distinct)
select COUNT(*) from DOCUMENT where PID in (select PID from tmp_42cfr_distinct)
select distinct pstatus from PatientProfile where PID in (select PID from tmp_42cfr_distinct)