select
*
from priem
   inner join pocient on (priem.poc_id = pocient.poc_id)
   inner join podrazdelenij on (priem.podr_id = podrazdelenij.podr_id)
   inner join diagnoz_full on (priem.dia_id = diagnoz_full.dia_id)
   inner join diagnoz_mkb on (priem.diamkb_id = diagnoz_mkb.diamkb_id)
   inner join adr_city on (adr_city.adrc_id = pocient.adrc_id)
   inner join adr_street on (adr_street.adrs_id = pocient.adrs_id)
where
 (
   (
     priem.pr_date < :pr_date
     and
     adr_city.adrc_name like :adrc_name
     and
     diagnoz_full.dia_id like :dia_id
    )
  )

where
 (
   (
     priem.pr_date < :pr_date // выбрать если дата больше указанной
     and
     adr_city.adrc_name like :adrc_name // в указанном городе
     and
     diagnoz_full.dia_id like :dia_id // с конкретным диагнозом
    )
  )