select  p.pid as PID, k.fam as F, k.im1 as IM, k.im2 as OT, d.doct_tn,n.razd_isl,z.name as r,o.name as n,s.num as pp,d.dat_p as POST,n.razd_isl as raz,d.prizn as priz,d.status as st
from pp_next n, pp_table p, pal_doct d, palata t, people k ,sp_palat s
join dict z on z.code =n.razd_isl and z.type_s=4
join dict o on o.code =d.status and o.type_s=312

where
 d.palat_id=t.id_palata
 and t.pazient=n.id_next
 and n.pp_table=p.id_table
 and n.p_prizn=0 and n.dat_v is null
  and t.pr=0 and p.pid=k.pid
and s.id_sppal=t.n_palat

select  p.pid as PID, k.fam as F, k.im1 as IM, k.im2 as OT, d.doct_tn,n.razd_isl,z.name as r,o.name as n,s.num as pp,d.dat_p as POST,n.razd_isl as raz,d.prizn as priz,d.status as st
from pp_next n, pp_table p, pal_doct d, palata t, people k ,sp_palat s
join dict z on z.code =n.razd_isl and z.type_s=4
join dict o on o.code =d.status and o.type_s=312

where d.date_p=datetostr(date)
 and d.palat_id=t.id_palata
 and t.pazient=n.id_next
 and n.pp_table=p.id_table
 and n.p_prizn=0 and n.dat_v is null
 and t.pr=0 and p.pid=k.pid
 and s.id_sppal=t.n_palat