โรงพยาบาลจอมพระ

select p.house_regist_type_id,v.*
from vn_stat v
left join person p on p.patient_hn=v.hn

where ((pdx between ‘i60’ and ‘i69’ or pdx between ‘i10’ and ‘i15′ or pdx =’i64’ or pdx between ‘i20’ and ‘i25’ or pdx between ‘e10’ and ‘e14′ or pdx=’j449’ or pdx between ‘j45’ and ‘j46′ or pdx=’j43′ or pdx=’e66’
or pdx between ‘c00’ and ‘c97’ or pdx between ‘a15’ and ‘a19’ or pdx = ‘b20’ and ‘b24′ or pdx=’k70.3′ or pdx=’k71.7′ or pdx =’k74’ or pdx = ‘k73′ or pdx=’n18’ or pdx between ‘m15’ and ‘m19′ and pdx=’m47’ and
pdx between ‘m05’ and ‘m06’)
or
(dx0 between ‘i60’ and ‘i69’ or dx0 between ‘i10’ and ‘i15′ or dx0 =’i64’ or dx0 between ‘i20’ and ‘i25’ or dx0 between ‘e10’ and ‘e14′ or dx0=’j449’ or dx0 between ‘j45’ and ‘j46′ or dx0=’j43′ or dx0=’e66’
or dx0 between ‘c00’ and ‘c97’ or dx0 between ‘a15’ and ‘a19’ or dx0 = ‘b20’ and ‘b24′ or dx0=’k70.3′ or dx0=’k71.7′ or dx0 =’k74’ or dx0 = ‘k73′ or dx0=’n18’ or dx0 between ‘m15’ and ‘m19′ and dx0=’m47’ and
dx0 between ‘m05’ and ‘m06’)
or
(dx1 between ‘i60’ and ‘i69’ or dx1 between ‘i10’ and ‘i15′ or dx1 =’i64’ or dx1 between ‘i20’ and ‘i25’ or dx1 between ‘e10’ and ‘e14′ or dx1=’j449’ or dx1 between ‘j45’ and ‘j46′ or dx1=’j43′ or dx1=’e66’
or dx1 between ‘c00’ and ‘c97’ or dx1 between ‘a15’ and ‘a19’ or dx1 = ‘b20’ and ‘b24′ or dx1=’k70.3′ or dx1=’k71.7′ or dx1 =’k74’ or dx1 = ‘k73′ or dx1=’n18’ or dx1 between ‘m15’ and ‘m19′ and dx1=’m47’ and
dx1 between ‘m05’ and ‘m06’)
or
(dx2 between ‘i60’ and ‘i69’ or dx2 between ‘i10’ and ‘i15′ or dx2 =’i64’ or dx2 between ‘i20’ and ‘i25’ or dx2 between ‘e10’ and ‘e14′ or dx2=’j449’ or dx2 between ‘j45’ and ‘j46′ or dx2=’j43′ or dx2=’e66’
or dx2 between ‘c00’ and ‘c97’ or dx2 between ‘a15’ and ‘a19’ or dx2 = ‘b20’ and ‘b24′ or dx2=’k70.3′ or dx2=’k71.7′ or dx2 =’k74’ or dx2 = ‘k73′ or dx2=’n18’ or dx2 between ‘m15’ and ‘m19′ and dx2=’m47’ and
dx2 between ‘m05’ and ‘m06’)
or
(dx3 between ‘i60’ and ‘i69’ or dx3 between ‘i10’ and ‘i15′ or dx3 =’i64’ or dx3 between ‘i20’ and ‘i25’ or dx3 between ‘e10’ and ‘e14′ or dx3=’j449’ or dx3 between ‘j45’ and ‘j46′ or dx3=’j43′ or dx3=’e66’
or dx3 between ‘c00’ and ‘c97’ or dx3 between ‘a15’ and ‘a19’ or dx3 = ‘b20’ and ‘b24′ or dx3=’k70.3′ or dx3=’k71.7′ or dx3 =’k74’ or dx3 = ‘k73′ or dx3=’n18’ or dx3 between ‘m15’ and ‘m19′ and dx3=’m47’ and
dx3 between ‘m05’ and ‘m06’)
or
(dx4 between ‘i60’ and ‘i69’ or dx4 between ‘i10’ and ‘i15′ or dx4 =’i64’ or dx4 between ‘i20’ and ‘i25’ or dx4 between ‘e10’ and ‘e14′ or dx4=’j449’ or dx4 between ‘j45’ and ‘j46′ or dx4=’j43′ or dx4=’e66’
or dx4 between ‘c00’ and ‘c97’ or dx4 between ‘a15’ and ‘a19’ or dx4 = ‘b20’ and ‘b24′ or dx4=’k70.3′ or dx4=’k71.7′ or dx4 =’k74’ or dx4 = ‘k73′ or dx4=’n18’ or dx4 between ‘m15’ and ‘m19′ and dx4=’m47’ and
dx4 between ‘m05’ and ‘m06’)
or
(dx5 between ‘i60’ and ‘i69’ or dx5 between ‘i10’ and ‘i15′ or dx5 =’i64’ or dx5 between ‘i20’ and ‘i25’ or dx5 between ‘e10’ and ‘e14′ or dx5=’j449’ or dx5 between ‘j45’ and ‘j46′ or dx5=’j43′ or dx5=’e66’
or dx5 between ‘c00’ and ‘c97’ or dx5 between ‘a15’ and ‘a19’ or dx5 = ‘b20’ and ‘b24′ or dx5=’k70.3′ or dx5=’k71.7′ or dx5 =’k74’ or dx5 = ‘k73′ or dx5=’n18’ or dx5 between ‘m15’ and ‘m19′ and dx5=’m47’ and
dx5 between ‘m05’ and ‘m06’) )

group by v.hn

0

0