ขอบคุณครับ

มันขึ้นแบบนี้ครับ


select concat(ward,':',name) as name from ward
 select o.*,concat(p.pname,p.fname,'  ',p.lname) as ptname,  o.request_queue as oqueue,d.name as doctor_name,w.name as ward_name    from ipt_admit_queue  o    left outer join patient p on p.hn=o.hn    left outer join doctor d on d.code=o.doctor  left outer join ward w on w.ward=o.request_ward  where o.admited = 'N'   order by o.request_queue
 select o.*,concat(p.pname,p.fname,'  ',p.lname) as ptname,  o.request_queue as oqueue,d.name as doctor_name,w.name as ward_name    from ipt_admit_queue  o    left outer join patient p on p.hn=o.hn    left outer join doctor d on d.code=o.doctor  left outer join ward w on w.ward=o.request_ward  where o.admited = 'N'   order by o.request_queue
 delete from vn_lock where lock_computer='SUPERVISOR3'
select concat(hosptype,' ',name) as name from hospcode where hospcode=''
select name from rfrcs where rfrcs=''
select count(hn) as cc from patient where hn='480040404'
select drugallergy from patient where hn='480040404'
SHOW KEYS FROM hos.patient
select rtrim(pname) as pname,rtrim(fname) as fname,rtrim(lname) as lname,midname from patient where hn='480040404'
select cardno from ptcardno where hn='480040404' and cardtype='01'
SHOW TABLES FROM hos LIKE 'ptcardno'
SHOW COLUMNS FROM hos.ptcardno LIKE '%'
SHOW KEYS FROM hos.ptcardno
select image,width,height from patient_image where hn='480040404' and image_name='OPD'
SHOW TABLES FROM hos LIKE 'patient_image'
SHOW COLUMNS FROM hos.patient_image LIKE '%'
SHOW KEYS FROM hos.patient_image
select count(*) as cc from ptnote where hn='480040404'  and (noteflag like '%[OPDCARD]%'  or note_staff = 'kan' )
SHOW TABLES FROM hos LIKE 'ptnote'
SHOW COLUMNS FROM hos.ptnote LIKE '%'
select count(*) as cc from ptnote where hn='480040404'  and groupname like '%[Admin]%'  and groupname is not null and groupname<>''
select informname from patient where hn = '480040404'
select informaddr from patient where hn = '480040404'
select vn,hn,vstdate,vsttime from ovst where hn='480040404' and vstdate between '2008-10-07' and '2008-10-08' order by vn desc
SHOW KEYS FROM hos.ovst
select bw from opdscreen where vn='511008125200'
SHOW TABLES FROM hos LIKE 'opdscreen'
SHOW COLUMNS FROM hos.opdscreen LIKE '%'
SHOW KEYS FROM hos.opdscreen
select count(*) as cc from referin where vn='511008125200'
SHOW TABLES FROM hos LIKE 'referin'
SHOW COLUMNS FROM hos.referin LIKE '%'
select count(hn) as cc from patient where hn='480040404'
select pttype from ovst where vn = '511008125200'
select count(pttype) as cc from pttype where pttype='34'
SHOW TABLES FROM hos LIKE 'pttype'
SHOW COLUMNS FROM hos.pttype LIKE '%'
select name from pttype where pttype='34'
SHOW KEYS FROM hos.pttype
select count(*) as cc from ipt_pttype where an = '         ' and pttype_number = 1
SHOW TABLES FROM hos LIKE 'ipt_pttype'
SHOW COLUMNS FROM hos.ipt_pttype LIKE '%'
select pttypeno from ipt_pttype where an = '         ' and pttype_number = 1
SHOW KEYS FROM hos.ipt_pttype
select use_contract_id from pttype where pttype='34'
select contract from pttype where pttype='34'
select c.contract_name from ipt_pttype o, contract_partner c where o.an = '         ' and o.pttype = '34' and o.contract_id = c.contract_id
SHOW TABLES FROM hos LIKE 'contract_partner'
SHOW COLUMNS FROM hos.contract_partner LIKE '%'
select requirecode from pttype where pttype='34'
select claim_code from ipt_pttype  where an = '         ' and pttype='34'
select addrpart,road,moopart,tmbpart,amppart,chwpart from patient where hn='480040404'
select count(tmbpart) as cc from thaiaddress where tmbpart='09' and amppart='04' and chwpart='32' and codetype='3'
SHOW TABLES FROM hos LIKE 'thaiaddress'
SHOW COLUMNS FROM hos.thaiaddress LIKE '%'
select name from thaiaddress where tmbpart='09' and amppart='04' and chwpart='32' and codetype='3'
SHOW KEYS FROM hos.thaiaddress
select count(amppart) as cc from thaiaddress where amppart='04' and chwpart='32' and codetype='2'
select name from thaiaddress where amppart='04' and chwpart='32' and codetype='2'
select count(chwpart) as cc from thaiaddress where chwpart='32' and codetype='1'
select name from thaiaddress where chwpart='32' and codetype='1'
select birthday from patient where hn='480040404'
select count(*) as cc from ipt where hn='480040404' and regdate<='2008-10-08'  and dchdate is null 
SHOW TABLES FROM hos LIKE 'ipt'
SHOW COLUMNS FROM hos.ipt LIKE '%'
select count(*) as cc from ipt_admit_queue where hn='480040404' and admited='N'
select * from ipt_admit_queue where hn='480040404' and admited='N'
SHOW KEYS FROM hos.ipt_admit_queue
select name from doctor where code='0197'
select name from doctor where code='0197'
select name from ward where ward='000'
 delete from vn_lock where lock_computer='SUPERVISOR3'
select count(*) as cc from ovst where vn='511008125200'
select count(*) as cc from vn_lock where vn='511008125200' and lock_computer<>'SUPERVISOR3'  and lock_date_time >='2008-10-08 17:17:44'
SHOW TABLES FROM hos LIKE 'vn_lock'
SHOW COLUMNS FROM hos.vn_lock LIKE '%'
 delete from vn_lock where vn='511008125200'
select * from vn_lock where vn='511008125200'
SHOW KEYS FROM hos.vn_lock
select * from vn_lock where vn='511008125200'
INSERT INTO vn_lock (vn,lock_date_time,lock_computer) VALUES ('511008125200','2008-10-08 17:20:44','SUPERVISOR3')
delete from anlock  where onlineid='SUPERVISOR3'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'SUPERVISOR3','delete from anlock  where onlineid=\'SUPERVISOR3\'')
select count(*) as cc from sys_var where sys_name='NEW_AN_IGNORE_WARD'
select sys_value from sys_var where sys_name='NEW_AN_IGNORE_WARD'
select count(ward) as cc from ward where ward='000'
select request_an from ipt_admit_queue where  vn='511008125200'
select request_an from ipt_admit_queue  where admited='N' order by request_an
select count(*) as cc from sys_var where sys_name='NEW_AN_IGNORE_WARD'
select sys_value from sys_var where sys_name='NEW_AN_IGNORE_WARD'
delete from anlock  where onlineid='SUPERVISOR3'
insert into replicate_log (`event_time`,`client`,`sql`) values (current_timestamp,'SUPERVISOR3','delete from anlock  where onlineid=\'SUPERVISOR3\'')
select * from serial where name='AN'
SHOW KEYS FROM hos.serial
select '510000004' as i
select an as i from anlock where optype in ('Insert','Modify')   order by an desc limit 1
SHOW TABLES FROM hos LIKE 'anlock'
SHOW COLUMNS FROM hos.anlock LIKE '%'
select an from ipt order by an desc limit 20
SHOW KEYS FROM hos.ipt
select count(*) as cc from ipt where an = '510013453'
select count(*) as cc from ipt where an = '510013452'
select count(*) as cc from ipt where an = '510013451'
select count(*) as cc from ipt where an = '510013450'
select count(*) as cc from ipt where an = '510013449'
select count(*) as cc from ipt where an = '510013448'
select count(*) as cc from ipt where an = '510013447'
select count(*) as cc from ipt where an = '510013446'
select count(*) as cc from ipt where an = '510013445'
select count(*) as cc from ipt where an = '510013444'
select count(*) as cc from ipt where an = '510013443'
select count(*) as cc from ipt where an = '510013442'
select count(*) as cc from ipt where an = '510013441'
select count(*) as cc from ipt where an = '510013440'
select count(*) as cc from ipt where an = '510013439'
select count(*) as cc from ipt where an = '510013438'
select count(*) as cc from ipt where an = '510013437'
select count(*) as cc from ipt where an = '510013436'
select count(*) as cc from ipt where an = '510013435'
select count(*) as cc from ipt where an = '510013434'
select '' as skip_list
select count(*) as cc from ipt where an = '510000005'
select count(*) as cc from ipt where an = '510000006'
select count(*) as cc from ipt where an = '510000007'
select count(*) as cc from ipt where an = '510000008'
select count(*) as cc from ipt where an = '510000009'
select count(*) as cc from ipt where an = '510000010'
select count(*) as cc from ipt where an = '510000011'
select count(*) as cc from ipt where an = '510000012'
select count(*) as cc from ipt where an = '510000013'
select count(*) as cc from ipt where an = '510000014'
select count(*) as cc from ipt where an = '510000015'
select count(*) as cc from ipt where an = '510000016'
select count(*) as cc from ipt where an = '510000017'
select count(*) as cc from ipt where an = '510000018'
select count(*) as cc from ipt where an = '510000019'
select count(*) as cc from ipt where an = '510000020'
select count(*) as cc from ipt where an = '510000021'
select count(*) as cc from ipt where an = '510000022'
select count(*) as cc from ipt where an = '510000023'
select count(*) as cc from ipt where an = '510000024'
select count(*) as cc from ipt where an = '510000025'
select count(*) as cc from ipt where an = '510000026'
select count(*) as cc from ipt where an = '510000027'
select count(*) as cc from ipt where an = '510000028'
select count(*) as cc from ipt where an = '510000029'
select count(*) as cc from ipt where an = '510000030'
select count(*) as cc from ipt where an = '510000031'
select count(*) as cc from ipt where an = '510000032'
select count(*) as cc from ipt where an = '510000033'
select count(*) as cc from ipt where an = '510000034'
select count(*) as cc from ipt where an = '510000035'
select count(*) as cc from ipt where an = '510000036'
select count(*) as cc from ipt where an = '510000037'
select count(*) as cc from ipt where an = '510000038'
select count(*) as cc from ipt where an = '510000039'
select count(*) as cc from ipt where an = '510000040'
select count(*) as cc from ipt where an = '510000041'
select count(*) as cc from ipt where an = '510000042'
select count(*) as cc from ipt where an = '510000043'
select count(*) as cc from ipt where an = '510000044'
select count(*) as cc from ipt where an = '510000045'
select count(*) as cc from ipt where an = '510000046'
select count(*) as cc from ipt where an = '510000047'
select count(*) as cc from ipt where an = '510000048'
select count(*) as cc from ipt where an = '510000049'
select count(*) as cc from ipt where an = '510000050'
select count(*) as cc from ipt where an = '510000051'
select count(*) as cc from ipt where an = '510000052'
select count(*) as cc from ipt where an = '510000053'
select count(*) as cc from ipt where an = '510000054'
select count(*) as cc from ipt where an = '510000055'
select count(*) as cc from ipt where an = '510000056'
select count(*) as cc from ipt where an = '510000057'
select count(*) as cc from ipt where an = '510000058'
select count(*) as cc from ipt where an = '510000059'
select count(*) as cc from ipt where an = '510000060'
select count(*) as cc from ipt where an = '510000061'
select count(*) as cc from ipt where an = '510000062'
select count(*) as cc from ipt where an = '510000063'
select count(*) as cc from ipt where an = '510000064'
select count(*) as cc from ipt where an = '510000065'
select count(*) as cc from ipt where an = '510000066'
select count(*) as cc from ipt where an = '510000067'
select count(*) as cc from ipt where an = '510000068'
select count(*) as cc from ipt where an = '510000069'
select count(*) as cc from ipt where an = '510000070'
select count(*) as cc from ipt where an = '510000071'
select count(*) as cc from ipt where an = '510000072'
select count(*) as cc from ipt where an = '510000073'
select count(*) as cc from ipt where an = '510000074'
select count(*) as cc from ipt where an = '510000075'
select count(*) as cc from ipt where an = '510000076'
select count(*) as cc from ipt where an = '510000077'
select count(*) as cc from ipt where an = '510000078'
select count(*) as cc from ipt where an = '510000079'
select count(*) as cc from ipt where an = '510000080'
select count(*) as cc from ipt where an = '510000081'
select count(*) as cc from ipt where an = '510000082'
select count(*) as cc from ipt where an = '510000083'
select count(*) as cc from ipt where an = '510000084'
select count(*) as cc from ipt where an = '510000085'
select count(*) as cc from ipt where an = '510000086'
select count(*) as cc from ipt where an = '510000087'
select count(*) as cc from ipt where an = '510000088'
select count(*) as cc from ipt where an = '510000089'
select count(*) as cc from ipt where an = '510000090'
select count(*) as cc from ipt where an = '510000091'
select count(*) as cc from ipt where an = '510000092'
select count(*) as cc from ipt where an = '510000093'
select count(*) as cc from ipt where an = '510000094'
select count(*) as cc from ipt where an = '510000095'
select count(*) as cc from ipt where an = '510000096'
select count(*) as cc from ipt where an = '510000097'
select count(*) as cc from ipt where an = '510000098'
select count(*) as cc from ipt where an = '510000099'
select count(*) as cc from ipt where an = '510000100'
select count(*) as cc from ipt where an = '510000101'
select count(*) as cc from ipt where an = '510000102'
select count(*) as cc from ipt where an = '510000103'
select count(*) as cc from ipt where an = '510000104'
select count(*) as cc from ipt where an = '510000105'
select count(*) as cc from ipt where an = '510000106'
select count(*) as cc from ipt where an = '510000107'
select count(*) as cc from ipt where an = '510000108'
select count(*) as cc from ipt where an = '510000109'
select count(*) as cc from ipt where an = '510000110'
select count(*) as cc from ipt where an = '510000111'
select count(*) as cc from ipt where an = '510000112'
select count(*) as cc from ipt where an = '510000113'
select count(*) as cc from ipt where an = '510000114'
select count(*) as cc from ipt where an = '510000115'
select count(*) as cc from ipt where an = '510000116'
select count(*) as cc from ipt where an = '510000117'
select count(*) as cc from ipt where an = '510000118'
select count(*) as cc from ipt where an = '510000119'
select count(*) as cc from ipt where an = '510000120'
select count(*) as cc from ipt where an = '510000121'
select count(*) as cc from ipt where an = '510000122'
select count(*) as cc from ipt where an = '510000123'
select count(*) as cc from ipt where an = '510000124'
select count(*) as cc from ipt where an = '510000125'
select count(*) as cc from ipt where an = '510000126'
select count(*) as cc from ipt where an = '510000127'
select count(*) as cc from ipt where an = '510000128'
select count(*) as cc from ipt where an = '510000129'
select count(*) as cc from ipt where an = '510000130'
select count(*) as cc from ipt where an = '510000131'
select count(*) as cc from ipt where an = '510000132'
select count(*) as cc from ipt where an = '510000133'
select count(*) as cc from ipt where an = '510000134'
select count(*) as cc from ipt where an = '510000135'
select count(*) as cc from ipt where an = '510000136'
select count(*) as cc from ipt where an = '510000137'
select count(*) as cc from ipt where an = '510000138'
select count(*) as cc from ipt where an = '510000139'
select count(*) as cc from ipt where an = '510000140'
select count(*) as cc from ipt where an = '510000141'
select count(*) as cc from ipt where an = '510000142'
select count(*) as cc from ipt where an = '510000143'
select count(*) as cc from ipt where an = '510000144'
select count(*) as cc from ipt where an = '510000145'
select count(*) as cc from ipt where an = '510000146'
select count(*) as cc from ipt where an = '510000147'
select count(*) as cc from ipt where an = '510000148'
select count(*) as cc from ipt where an = '510000149'
select count(*) as cc from ipt where an = '510000150'
select count(*) as cc from ipt where an = '510000151'
select count(*) as cc from ipt where an = '510000152'
select count(*) as cc from ipt where an = '510000153'
select count(*) as cc from ipt where an = '510000154'
select count(*) as cc from ipt where an = '510000155'
select count(*) as cc from ipt where an = '510000156'
select count(*) as cc from ipt where an = '510000157'
select count(*) as cc from ipt where an = '510000158'
select count(*) as cc from ipt where an = '510000159'
select count(*) as cc from ipt where an = '510000160'
select count(*) as cc from ipt where an = '510000161'
select count(*) as cc from ipt where an = '510000162'
select count(*) as cc from ipt where an = '510000163'
select count(*) as cc from ipt where an = '510000164'
select count(*) as cc from ipt where an = '510000165'
select count(*) as cc from ipt where an = '510000166'
select count(*) as cc from ipt where an = '510000167'
select count(*) as cc from ipt where an = '510000168'
select count(*) as cc from ipt where an = '510000169'
select count(*) as cc from ipt where an = '510000170'
select count(*) as cc from ipt where an = '510000171'
select count(*) as cc from ipt where an = '510000172'
select count(*) as cc from ipt where an = '510000173'
select count(*) as cc from ipt where an = '510000174'
select count(*) as cc from ipt where an = '510000175'
select count(*) as cc from ipt where an = '510000176'
select count(*) as cc from ipt where an = '510000177'
select count(*) as cc from ipt where an = '510000178'
select count(*) as cc from ipt where an = '510000179'
select count(*) as cc from ipt where an = '510000180'
select count(*) as cc from ipt where an = '510000181'
select count(*) as cc from ipt where an = '510000182'
select count(*) as cc from ipt where an = '510000183'
select count(*) as cc from ipt where an = '510000184'
select count(*) as cc from ipt where an = '510000185'
select count(*) as cc from ipt where an = '510000186'
select count(*) as cc from ipt where an = '510000187'
select count(*) as cc from ipt where an = '510000188'
select count(*) as cc from ipt where an = '510000189'
select count(*) as cc from ipt where an = '510000190'
select count(*) as cc from ipt where an = '510000191'
select count(*) as cc from ipt where an = '510000192'
select count(*) as cc from ipt where an = '510000193'
select count(*) as cc from ipt where an = '510000194'
select count(*) as cc from ipt where an = '510000195'
select count(*) as cc from ipt where an = '510000196'
select count(*) as cc from ipt where an = '510000197'
select count(*) as cc from ipt where an = '510000198'
select count(*) as cc from ipt where an = '510000199'
select count(*) as cc from ipt where an = '510000200'
select count(*) as cc from ipt where an = '510000201'
select count(*) as cc from ipt where an = '510000202'
select count(*) as cc from ipt where an = '510000203'
select count(*) as cc from ipt where an = '510000204'
select count(*) as cc from ipt where an = '510000205'
select count(*) as cc from ipt where an = '510000206'
select count(*) as cc from ipt where an = '510000207'
select count(*) as cc from ipt where an = '510000208'
select count(*) as cc from ipt where an = '510000209'
select count(*) as cc from ipt where an = '510000210'
select count(*) as cc from ipt where an = '510000211'
select count(*) as cc from ipt where an = '510000212'
select count(*) as cc from ipt where an = '510000213'
select count(*) as cc from ipt where an = '510000214'
select count(*) as cc from ipt where an = '510000215'
select count(*) as cc from ipt where an = '510000216'
select count(*) as cc from ipt where an = '510000217'
select count(*) as cc from ipt where an = '510000218'
select count(*) as cc from ipt where an = '510000219'
select count(*) as cc from ipt where an = '510000220'
select count(*) as cc from ipt where an = '510000221'
select count(*) as cc from ipt where an = '510000222'
select count(*) as cc from ipt where an = '510000223'
select count(*) as cc from ipt where an = '510000224'
select count(*) as cc from ipt where an = '510000225'
select count(*) as cc from ipt where an = '510000226'
select count(*) as cc from ipt where an = '510000227'
select count(*) as cc from ipt where an = '510000228'
select count(*) as cc from ipt where an = '510000229'
select count(*) as cc from ipt where an = '510000230'
select count(*) as cc from ipt where an = '510000231'
select count(*) as cc from ipt where an = '510000232'
select count(*) as cc from ipt where an = '510000233'
select count(*) as cc from ipt where an = '510000234'
select count(*) as cc from ipt where an = '510000235'
select count(*) as cc from ipt where an = '510000236'
select count(*) as cc from ipt where an = '510000237'
select count(*) as cc from ipt where an = '510000238'
select count(*) as cc from ipt where an = '510000239'
select count(*) as cc from ipt where an = '510000240'
select count(*) as cc from ipt where an = '510000241'
select count(*) as cc from ipt where an = '510000242'
select count(*) as cc from ipt where an = '510000243'
select count(*) as cc from ipt where an = '510000244'
select count(*) as cc from ipt where an = '510000245'
select count(*) as cc from ipt where an = '510000246'
select count(*) as cc from ipt where an = '510000247'
select count(*) as cc from ipt where an = '510000248'
select count(*) as cc from ipt where an = '510000249'
select count(*) as cc from ipt where an = '510000250'
select count(*) as cc from ipt where an = '510000251'
select count(*) as cc from ipt where an = '510000252'
select count(*) as cc from ipt where an = '510000253'
select count(*) as cc from ipt where an = '510000254'
select count(*) as cc from ipt where an = '510000255'
select count(*) as cc from ipt where an = '510000256'
select count(*) as cc from ipt where an = '510000257'
select count(*) as cc from ipt where an = '510000258'
select count(*) as cc from ipt where an = '510000259'
select count(*) as cc from ipt where an = '510000260'
select count(*) as cc from ipt where an = '510000261'
select count(*) as cc from ipt where an = '510000262'
select count(*) as cc from ipt where an = '510000263'
select count(*) as cc from ipt where an = '510000264'
select count(*) as cc from ipt where an = '510000265'
select count(*) as cc from ipt where an = '510000266'
select count(*) as cc from ipt where an = '510000267'
select count(*) as cc from ipt where an = '510000268'
select count(*) as cc from ipt where an = '510000269'
select count(*) as cc from ipt where an = '510000270'
select count(*) as cc from ipt where an = '510000271'
select count(*) as cc from ipt where an = '510000272'
select count(*) as cc from ipt where an = '510000273'
select count(*) as cc from ipt where an = '510000274'
select count(*) as cc from ipt where an = '510000275'
select count(*) as cc from ipt where an = '510000276'
select count(*) as cc from ipt where an = '510000277'
select count(*) as cc from ipt where an = '510000278'
select count(*) as cc from ipt where an = '510000279'
select count(*) as cc from ipt where an = '510000280'
select count(*) as cc from ipt where an = '510000281'
select count(*) as cc from ipt where an = '510000282'
select count(*) as cc from ipt where an = '510000283'
select count(*) as cc from ipt where an = '510000284'
select count(*) as cc from ipt where an = '510000285'
select count(*) as cc from ipt where an = '510000286'
select count(*) as cc from ipt where an = '510000287'
select count(*) as cc from ipt where an = '510000288'
select count(*) as cc from ipt where an = '510000289'
select count(*) as cc from ipt where an = '510000290'
select count(*) as cc from ipt where an = '510000291'
select count(*) as cc from ipt where an = '510000292'
select count(*) as cc from ipt where an = '510000293'
select count(*) as cc from ipt where an = '510000294'
select count(*) as cc from ipt where an = '510000295'
select count(*) as cc from ipt where an = '510000296'
select count(*) as cc from ipt where an = '510000297'
select count(*) as cc from ipt where an = '510000298'
select count(*) as cc from ipt where an = '510000299'
select count(*) as cc from ipt where an = '510000300'
select count(*) as cc from ipt where an = '510000301'
select count(*) as cc from ipt where an = '510000302'
select count(*) as cc from ipt where an = '510000303'
select count(*) as cc from ipt where an = '510000304'
select count(*) as cc from ipt where an = '510000305'
select count(*) as cc from ipt where an = '510000306'
select count(*) as cc from ipt where an = '510000307'
select count(*) as cc from ipt where an = '510000308'
select count(*) as cc from ipt where an = '510000309'
select count(*) as cc from ipt where an = '510000310'
select count(*) as cc from ipt where an = '510000311'
select count(*) as cc from ipt where an = '510000312'
select count(*) as cc from ipt where an = '510000313'
select count(*) as cc from ipt where an = '510000314'
select count(*) as cc from ipt where an = '510000315'
select count(*) as cc from ipt where an = '510000316'
select count(*) as cc from ipt where an = '510000317'
select count(*) as cc from ipt where an = '510000318'
select count(*) as cc from ipt where an = '510000319'
select count(*) as cc from ipt where an = '510000320'
select count(*) as cc from ipt where an = '510000321'
select count(*) as cc from ipt where an = '510000322'
select count(*) as cc from ipt where an = '510000323'
select count(*) as cc from ipt where an = '510000324'
select count(*) as cc from ipt where an = '510000325'
select count(*) as cc from ipt where an = '510000326'
select count(*) as cc from ipt where an = '510000327'
select count(*) as cc from ipt where an = '510000328'
select count(*) as cc from ipt where an = '510000329'
select count(*) as cc from ipt where an = '510000330'
select count(*) as cc from ipt where an = '510000331'
select count(*) as cc from ipt where an = '510000332'
select count(*) as cc from ipt where an = '510000333'
select count(*) as cc from ipt where an = '510000334'
select count(*) as cc from ipt where an = '510000335'
select count(*) as cc from ipt where an = '510000336'
select count(*) as cc from ipt where an = '510000337'
select count(*) as cc from ipt where an = '510000338'
select count(*) as cc from ipt where an = '510000339'
select count(*) as cc from ipt where an = '510000340'
select count(*) as cc from ipt where an = '510000341'
select count(*) as cc from ipt where an = '510000342'
select count(*) as cc from ipt where an = '510000343'
select count(*) as cc from ipt where an = '510000344'
select count(*) as cc from ipt where an = '510000345'
select count(*) as cc from ipt where an = '510000346'
select count(*) as cc from ipt where an = '510000347'
select count(*) as cc from ipt where an = '510000348'
select count(*) as cc from ipt where an = '510000349'
select count(*) as cc from ipt where an = '510000350'
select count(*) as cc from ipt where an = '510000351'
select count(*) as cc from ipt where an = '510000352'
select count(*) as cc from ipt where an = '510000353'
select count(*) as cc from ipt where an = '510000354'
select count(*) as cc from ipt where an = '510000355'
select count(*) as cc from ipt where an = '510000356'
select count(*) as cc from ipt where an = '510000357'
select count(*) as cc from ipt where an = '510000358'
select count(*) as cc from ipt where an = '510000359'
select count(*) as cc from ipt where an = '510000360'
select count(*) as cc from ipt where an = '510000361'
select count(*) as cc from ipt where an = '510000362'
select count(*) as cc from ipt where an = '510000363'
select count(*) as cc from ipt where an = '510000364'
select count(*) as cc from ipt where an = '510000365'
select count(*) as cc from ipt where an = '510000366'
select count(*) as cc from ipt where an = '510000367'
select count(*) as cc from ipt where an = '510000368'
select count(*) as cc from ipt where an = '510000369'
select count(*) as cc from ipt where an = '510000370'
select count(*) as cc from ipt where an = '510000371'
select count(*) as cc from ipt where an = '510000372'
select count(*) as cc from ipt where an = '510000373'
select count(*) as cc from ipt where an = '510000374'
select count(*) as cc from ipt where an = '510000375'
select count(*) as cc from ipt where an = '510000376'
select count(*) as cc from ipt where an = '510000377'
select count(*) as cc from ipt where an = '510000378'
select count(*) as cc from ipt where an = '510000379'
select count(*) as cc from ipt where an = '510000380'
select count(*) as cc from ipt where an = '510000381'
select count(*) as cc from ipt where an = '510000382'
select count(*) as cc from ipt where an = '510000383'
select count(*) as cc from ipt where an = '510000384'
select count(*) as cc from ipt where an = '510000385'
select count(*) as cc from ipt where an = '510000386'
select count(*) as cc from ipt where an = '510000387'
select count(*) as cc from ipt where an = '510000388'
select count(*) as cc from ipt where an = '510000389'
select count(*) as cc from ipt where an = '510000390'
select count(*) as cc from ipt where an = '510000391'
select count(*) as cc from ipt where an = '510000392'
select count(*) as cc from ipt where an = '510000393'
select count(*) as cc from ipt where an = '510000394'
select count(*) as cc from ipt where an = '510000395'
select count(*) as cc from ipt where an = '510000396'
select count(*) as cc from ipt where an = '510000397'
select count(*) as cc from ipt where an = '510000398'
select count(*) as cc from ipt where an = '510000399'
select count(*) as cc from ipt where an = '510000400'
select count(*) as cc from ipt where an = '510000401'
select count(*) as cc from ipt where an = '510000402'
select count(*) as cc from ipt where an = '510000403'
select count(*) as cc from ipt where an = '510000404'
select count(*) as cc from ipt where an = '510000405'
select count(*) as cc from ipt where an = '510000406'
select count(*) as cc from ipt where an = '510000407'
select count(*) as cc from ipt where an = '510000408'
select count(*) as cc from ipt where an = '510000409'
select count(*) as cc from ipt where an = '510000410'
select count(*) as cc from ipt where an = '510000411'
select count(*) as cc from ipt where an = '510000412'
select count(*) as cc from ipt where an = '510000413'
select count(*) as cc from ipt where an = '510000414'
select count(*) as cc from ipt where an = '510000415'
select count(*) as cc from ipt where an = '510000416'
select count(*) as cc from ipt where an = '510000417'
select count(*) as cc from ipt where an = '510000418'
select count(*) as cc from ipt where an = '510000419'
select count(*) as cc from ipt where an = '510000420'
select count(*) as cc from ipt where an = '510000421'
select count(*) as cc from ipt where an = '510000422'
select count(*) as cc from ipt where an = '510000423'
select count(*) as cc from ipt where an = '510000424'
select count(*) as cc from ipt where an = '510000425'
select count(*) as cc from ipt where an = '510000426'
select count(*) as cc from ipt where an = '510000427'
select count(*) as cc from ipt where an = '510000428'
select count(*) as cc from ipt where an = '510000429'
select count(*) as cc from ipt where an = '510000430'
select count(*) as cc from ipt where an = '510000431'
select count(*) as cc from ipt where an = '510000432'
select count(*) as cc from ipt where an = '510000433'
select count(*) as cc from ipt where an = '510000434'
select count(*) as cc from ipt where an = '510000435'
select count(*) as cc from ipt where an = '510000436'
select count(*) as cc from ipt where an = '510000437'
select count(*) as cc from ipt where an = '510000438'
select count(*) as cc from ipt where an = '510000439'
select count(*) as cc from ipt where an = '510000440'
select count(*) as cc from ipt where an = '510000441'
select count(*) as cc from ipt where an = '510000442'
select count(*) as cc from ipt where an = '510000443'
select count(*) as cc from ipt where an = '510000444'
select count(*) as cc from ipt where an = '510000445'
select count(*) as cc from ipt where an = '510000446'
select count(*) as cc from ipt where an = '510000447'
select count(*) as cc from ipt where an = '510000448'
select count(*) as cc from ipt where an = '510000449'
select count(*) as cc from ipt where an = '510000450'
select count(*) as cc from ipt where an = '510000451'
select count(*) as cc from ipt where an = '510000452'
select count(*) as cc from ipt where an = '510000453'
select count(*) as cc from ipt where an = '510000454'
select count(*) as cc from ipt where an = '510000455'
select count(*) as cc from ipt where an = '510000456'
select count(*) as cc from ipt where an = '510000457'
select count(*) as cc from ipt where an = '510000458'
select count(*) as cc from ipt where an = '510000459'
select count(*) as cc from ipt where an = '510000460'
select count(*) as cc from ipt where an = '510000461'
select count(*) as cc from ipt where an = '510000462'
select count(*) as cc from ipt where an = '510000463'
select count(*) as cc from ipt where an = '510000464'
select count(*) as cc from ipt where an = '510000465'
select count(*) as cc from ipt where an = '510000466'
select count(*) as cc from ipt where an = '510000467'
select count(*) as cc from ipt where an = '510000468'
select count(*) as cc from ipt where an = '510000469'
select count(*) as cc from ipt where an = '510000470'
select count(*) as cc from ipt where an = '510000471'
select count(*) as cc from ipt where an = '510000472'
select count(*) as cc from ipt where an = '510000473'
select count(*) as cc from ipt where an = '510000474'
select count(*) as cc from ipt where an = '510000475'
select count(*) as cc from ipt where an = '510000476'
select count(*) as cc from ipt where an = '510000477'
select count(*) as cc from ipt where an = '510000478'
select count(*) as cc from ipt where an = '510000479'
select count(*) as cc from ipt where an = '510000480'
select count(*) as cc from ipt where an = '510000481'
select count(*) as cc from ipt where an = '510000482'
select count(*) as cc from ipt where an = '510000483'
select count(*) as cc from ipt where an = '510000484'
select count(*) as cc from ipt where an = '510000485'
select count(*) as cc from ipt where an = '510000486'
select count(*) as cc from ipt where an = '510000487'
select count(*) as cc from ipt where an = '510000488'
select count(*) as cc from ipt where an = '510000489'
select count(*) as cc from ipt where an = '510000490'
select count(*) as cc from ipt where an = '510000491'
select count(*) as cc from ipt where an = '510000492'
select count(*) as cc from ipt where an = '510000493'
select count(*) as cc from ipt where an = '510000494'
select count(*) as cc from ipt where an = '510000495'
select count(*) as cc from ipt where an = '510000496'
select count(*) as cc from ipt where an = '510000497'
select count(*) as cc from ipt where an = '510000498'
select count(*) as cc from ipt where an = '510000499'
select count(*) as cc from ipt where an = '510000500'
select count(*) as cc from ipt where an = '510000501'
select count(*) as cc from ipt where an = '510000502'
select count(*) as cc from ipt where an = '510000503'
select count(*) as cc from ipt where an = '510000504'
select count(*) as cc from ipt where an = '510000505'
select count(*) as cc from ipt where an = '510000506'
select count(*) as cc from ipt where an = '510000507'
select count(*) as cc from ipt where an = '510000508'
select count(*) as cc from ipt where an = '510000509'
select count(*) as cc from ipt where an = '510000510'
select count(*) as cc from ipt where an = '510000511'
select count(*) as cc from ipt where an = '510000512'
select count(*) as cc from ipt where an = '510000513'
select count(*) as cc from ipt where an = '510000514'
select count(*) as cc from ipt where an = '510000515'
select count(*) as cc from ipt where an = '510000516'
select count(*) as cc from ipt where an = '510000517'
select count(*) as cc from ipt where an = '510000518'
select count(*) as cc from ipt where an = '510000519'
select count(*) as cc from ipt where an = '510000520'
select count(*) as cc from ipt where an = '510000521'
select count(*) as cc from ipt where an = '510000522'
select count(*) as cc from ipt where an = '510000523'
select count(*) as cc from ipt where an = '510000524'
select count(*) as cc from ipt where an = '510000525'
select count(*) as cc from ipt where an = '510000526'
select count(*) as cc from ipt where an = '510000527'
select count(*) as cc from ipt where an = '510000528'
select count(*) as cc from ipt where an = '510000529'
select count(*) as cc from ipt where an = '510000530'
select count(*) as cc from ipt where an = '510000531'
select count(*) as cc from ipt where an = '510000532'
select count(*) as cc from ipt where an = '510000533'
select count(*) as cc from ipt where an = '510000534'
select count(*) as cc from ipt where an = '510000535'
select count(*) as cc from ipt where an = '510000536'
select count(*) as cc from ipt where an = '510000537'
select count(*) as cc from ipt where an = '510000538'
select count(*) as cc from ipt where an = '510000539'
select count(*) as cc from ipt where an = '510000540'
select count(*) as cc from ipt where an = '510000541'
select count(*) as cc from ipt where an = '510000542'
select count(*) as cc from ipt where an = '510000543'
select count(*) as cc from ipt where an = '510000544'
select count(*) as cc from ipt where an = '510000545'
select count(*) as cc from ipt where an = '510000546'
select count(*) as cc from ipt where an = '510000547'
select count(*) as cc from ipt where an = '510000548'
select count(*) as cc from ipt where an = '510000549'
select count(*) as cc from ipt where an = '510000550'
select count(*) as cc from ipt where an = '510000551'
select count(*) as cc from ipt where an = '510000552'
select count(*) as cc from ipt where an = '510000553'
select count(*) as cc from ipt where an = '510000554'
select count(*) as cc from ipt where an = '510000555'
select count(*) as cc from ipt where an = '510000556'
select count(*) as cc from ipt where an = '510000557'
select count(*) as cc from ipt where an = '510000558'
select count(*) as cc from ipt where an = '510000559'
select count(*) as cc from ipt where an = '510000560'
select count(*) as cc from ipt where an = '510000561'
select count(*) as cc from ipt where an = '510000562'
select count(*) as cc from ipt where an = '510000563'
select count(*) as cc from ipt where an = '510000564'
select count(*) as cc from ipt where an = '510000565'
select count(*) as cc from ipt where an = '510000566'
select count(*) as cc from ipt where an = '510000567'
select count(*) as cc from ipt where an = '510000568'
select count(*) as cc from ipt where an = '510000569'
select count(*) as cc from ipt where an = '510000570'
select count(*) as cc from ipt where an = '510000571'
select count(*) as cc from ipt where an = '510000572'
select count(*) as cc from ipt where an = '510000573'
select count(*) as cc from ipt where an = '510000574'
select count(*) as cc from ipt where an = '510000575'
select count(*) as cc from ipt where an = '510000576'
select count(*) as cc from ipt where an = '510000577'
select count(*) as cc from ipt where an = '510000578'
select count(*) as cc from ipt where an = '510000579'
select count(*) as cc from ipt where an = '510000580'
select count(*) as cc from ipt where an = '510000581'
select count(*) as cc from ipt where an = '510000582'
select count(*) as cc from ipt where an = '510000583'
select count(*) as cc from ipt where an = '510000584'
select count(*) as cc from ipt where an = '510000585'
select count(*) as cc from ipt where an = '510000586'
select count(*) as cc from ipt where an = '510000587'
select count(*) as cc from ipt where an = '510000588'
select count(*) as cc from ipt where an = '510000589'
select count(*) as cc from ipt where an = '510000590'
select count(*) as cc from ipt where an = '510000591'
select count(*) as cc from ipt where an = '510000592'
select count(*) as cc from ipt where an = '510000593'
select count(*) as cc from ipt where an = '510000594'
select count(*) as cc from ipt where an = '510000595'
select count(*) as cc from ipt where an = '510000596'
select count(*) as cc from ipt where an = '510000597'
select count(*) as cc from ipt where an = '510000598'
select count(*) as cc from ipt where an = '510000599'
select count(*) as cc from ipt where an = '510000600'
select count(*) as cc from ipt where an = '510000601'
select count(*) as cc from ipt where an = '510000602'
select count(*) as cc from ipt where an = '510000603'
select count(*) as cc from ipt where an = '510000604'
select count(*) as cc from ipt where an = '510000605'
select count(*) as cc from ipt where an = '510000606'
select count(*) as cc from ipt where an = '510000607'
select count(*) as cc from ipt where an = '510000608'
select count(*) as cc from ipt where an = '510000609'
select count(*) as cc from ipt where an = '510000610'
select count(*) as cc from ipt where an = '510000611'
select count(*) as cc from ipt where an = '510000612'
select count(*) as cc from ipt where an = '510000613'
select count(*) as cc from ipt where an = '510000614'
select count(*) as cc from ipt where an = '510000615'
select count(*) as cc from ipt where an = '510000616'
select count(*) as cc from ipt where an = '510000617'
select count(*) as cc from ipt where an = '510000618'
select count(*) as cc from ipt where an = '510000619'
select count(*) as cc from ipt where an = '510000620'
select count(*) as cc from ipt where an = '510000621'
select count(*) as cc from ipt where an = '510000622'
select count(*) as cc from ipt where an = '510000623'
select count(*) as cc from ipt where an = '510000624'
select count(*) as cc from ipt where an = '510000625'
select count(*) as cc from ipt where an = '510000626'
select count(*) as cc from ipt where an = '510000627'
select count(*) as cc from ipt where an = '510000628'
select count(*) as cc from ipt where an = '510000629'
select count(*) as cc from ipt where an = '510000630'
select count(*) as cc from ipt where an = '510000631'
select count(*) as cc from ipt where an = '510000632'
select count(*) as cc from ipt where an = '510000633'
select count(*) as cc from ipt where an = '510000634'
select count(*) as cc from ipt where an = '510000635'
select count(*) as cc from ipt where an = '510000636'
select count(*) as cc from ipt where an = '510000637'
select count(*) as cc from ipt where an = '510000638'
select count(*) as cc from ipt where an = '510000639'
select count(*) as cc from ipt where an = '510000640'
select count(*) as cc from ipt where an = '510000641'
select count(*) as cc from ipt where an = '510000642'
select count(*) as cc from ipt where an = '510000643'
select count(*) as cc from ipt where an = '510000644'
select count(*) as cc from ipt where an = '510000645'
select count(*) as cc from ipt where an = '510000646'
select count(*) as cc from ipt where an = '510000647'
select count(*) as cc from ipt where an = '510000648'
select count(*) as cc from ipt where an = '510000649'
select count(*) as cc from ipt where an = '510000650'
select count(*) as cc from ipt where an = '510000651'
select count(*) as cc from ipt where an = '510000652'
select count(*) as cc from ipt where an = '510000653'
select count(*) as cc from ipt where an = '510000654'
select count(*) as cc from ipt where an = '510000655'
select count(*) as cc from ipt where an = '510000656'
select count(*) as cc from ipt where an = '510000657'
select count(*) as cc from ipt where an = '510000658'
select count(*) as cc from ipt where an = '510000659'
select count(*) as cc from ipt where an = '510000660'
select count(*) as cc from ipt where an = '510000661'
select count(*) as cc from ipt where an = '510000662'
select count(*) as cc from ipt where an = '510000663'
select count(*) as cc from ipt where an = '510000664'
select count(*) as cc from ipt where an = '510000665'
select count(*) as cc from ipt where an = '510000666'
select count(*) as cc from ipt where an = '510000667'
select count(*) as cc from ipt where an = '510000668'
select count(*) as cc from ipt where an = '510000669'
select count(*) as cc from ipt where an = '510000670'
select count(*) as cc from ipt where an = '510000671'
select count(*) as cc from ipt where an = '510000672'
select count(*) as cc from ipt where an = '510000673'
select count(*) as cc from ipt where an = '510000674'
select count(*) as cc from ipt where an = '510000675'
select count(*) as cc from ipt where an = '510000676'
select count(*) as cc from ipt where an = '510000677'
select count(*) as cc from ipt where an = '510000678'
select count(*) as cc from ipt where an = '510000679'
select count(*) as cc from ipt where an = '510000680'
select count(*) as cc from ipt where an = '510000681'
select count(*) as cc from ipt where an = '510000682'
select count(*) as cc from ipt where an = '510000683'
select count(*) as cc from ipt where an = '510000684'
select count(*) as cc from ipt where an = '510000685'
select count(*) as cc from ipt where an = '510000686'
select count(*) as cc from ipt where an = '510000687'
select count(*) as cc from ipt where an = '510000688'
select count(*) as cc from ipt where an = '510000689'
select count(*) as cc from ipt where an = '510000690'
select count(*) as cc from ipt where an = '510000691'
select count(*) as cc from ipt where an = '510000692'
select count(*) as cc from ipt where an = '510000693'
select count(*) as cc from ipt where an = '510000694'
select count(*) as cc from ipt where an = '510000695'
select count(*) as cc from ipt where an = '510000696'
select count(*) as cc from ipt where an = '510000697'
select count(*) as cc from ipt where an = '510000698'
select count(*) as cc from ipt where an = '510000699'
select count(*) as cc from ipt where an = '510000700'
select count(*) as cc from ipt where an = '510000701'
select count(*) as cc from ipt where an = '510000702'
select count(*) as cc from ipt where an = '510000703'
select count(*) as cc from ipt where an = '510000704'
select count(*) as cc from ipt where an = '510000705'
select count(*) as cc from ipt where an = '510000706'
select count(*) as cc from ipt where an = '510000707'
select count(*) as cc from ipt where an = '510000708'
select count(*) as cc from ipt where an = '510000709'
select count(*) as cc from ipt where an = '510000710'
select count(*) as cc from ipt where an = '510000711'
select count(*) as cc from ipt where an = '510000712'
select count(*) as cc from ipt where an = '510000713'
select count(*) as cc from ipt where an = '510000714'
select count(*) as cc from ipt where an = '510000715'
select count(*) as cc from ipt where an = '510000716'
select count(*) as cc from ipt where an = '510000717'
select count(*) as cc from ipt where an = '510000718'
select count(*) as cc from ipt where an = '510000719'
select count(*) as cc from ipt where an = '510000720'
select count(*) as cc from ipt where an = '510000721'
select count(*) as cc from ipt where an = '510000722'
select count(*) as cc from ipt where an = '510000723'
select count(*) as cc from ipt where an = '510000724'
select count(*) as cc from ipt where an = '510000725'
select count(*) as cc from ipt where an = '510000726'
select count(*) as cc from ipt where an = '510000727'
select count(*) as cc from ipt where an = '510000728'
select count(*) as cc from ipt where an = '510000729'
select count(*) as cc from ipt where an = '510000730'
select count(*) as cc from ipt where an = '510000731'
select count(*) as cc from ipt where an = '510000732'
select count(*) as cc from ipt where an = '510000733'
select count(*) as cc from ipt where an = '510000734'
select count(*) as cc from ipt where an = '510000735'
select count(*) as cc from ipt where an = '510000736'
select count(*) as cc from ipt where an = '510000737'
select count(*) as cc from ipt where an = '510000738'
select count(*) as cc from ipt where an = '510000739'
select count(*) as cc from ipt where an = '510000740'
select count(*) as cc from ipt where an = '510000741'
select count(*) as cc from ipt where an = '510000742'
select count(*) as cc from ipt where an = '510000743'
select count(*) as cc from ipt where an = '510000744'
select count(*) as cc from ipt where an = '510000745'
select count(*) as cc from ipt where an = '510000746'
select count(*) as cc from ipt where an = '510000747'
select count(*) as cc from ipt where an = '510000748'
select count(*) as cc from ipt where an = '510000749'
select count(*) as cc from ipt where an = '510000750'
select count(*) as cc from ipt where an = '510000751'
select count(*) as cc from ipt where an = '510000752'
select count(*) as cc from ipt where an = '510000753'
select count(*) as cc from ipt where an = '510000754'
select count(*) as cc from ipt where an = '510000755'
select count(*) as cc from ipt where an = '510000756'
select count(*) as cc from ipt where an = '510000757'
select count(*) as cc from ipt where an = '510000758'
select count(*) as cc from ipt where an = '510000759'
select count(*) as cc from ipt where an = '510000760'
select count(*) as cc from ipt where an = '510000761'
select count(*) as cc from ipt where an = '510000762'
select count(*) as cc from ipt where an = '510000763'
select count(*) as cc from ipt where an = '510000764'
select count(*) as cc from ipt where an = '510000765'
select count(*) as cc from ipt where an = '510000766'
select count(*) as cc from ipt where an = '510000767'
select count(*) as cc from ipt where an = '510000768'
select count(*) as cc from ipt where an = '510000769'
select count(*) as cc from ipt where an = '510000770'
select count(*) as cc from ipt where an = '510000771'
select count(*) as cc from ipt where an = '510000772'
select count(*) as cc from ipt where an = '510000773'
select count(*) as cc from ipt where an = '510000774'
select count(*) as cc from ipt where an = '510000775'
select count(*) as cc from ipt where an = '510000776'
select count(*) as cc from ipt where an = '510000777'
select count(*) as cc from ipt where an = '510000778'
select count(*) as cc from ipt where an = '510000779'
select count(*) as cc from ipt where an = '510000780'
select count(*) as cc from ipt where an = '510000781'
select count(*) as cc from ipt where an = '510000782'
select count(*) as cc from ipt where an = '510000783'
select count(*) as cc from ipt where an = '510000784'
select count(*) as cc from ipt where an = '510000785'
select count(*) as cc from ipt where an = '510000786'
select count(*) as cc from ipt where an = '510000787'
select count(*) as cc from ipt where an = '510000788'
select count(*) as cc from ipt where an = '510000789'
select count(*) as cc from ipt where an = '510000790'
select count(*) as cc from ipt where an = '510000791'
select count(*) as cc from ipt where an = '510000792'
select count(*) as cc from ipt where an = '510000793'
select count(*) as cc from ipt where an = '510000794'
select count(*) as cc from ipt where an = '510000795'
select count(*) as cc from ipt where an = '510000796'
select count(*) as cc from ipt where an = '510000797'
select count(*) as cc from ipt where an = '510000798'
select count(*) as cc from ipt where an = '510000799'
select count(*) as cc from ipt where an = '510000800'
select count(*) as cc from ipt where an = '510000801'
select count(*) as cc from ipt where an = '510000802'
select count(*) as cc from ipt where an = '510000803'
select count(*) as cc from ipt where an = '510000804'
select count(*) as cc from ipt where an = '510000805'
select count(*) as cc from ipt where an = '510000806'
select count(*) as cc from ipt where an = '510000807'
select count(*) as cc from ipt where an = '510000808'
select count(*) as cc from ipt where an = '510000809'
se

ปัญหาอาจจะอยู่ที่ตัว Print server  ก็ได้ครับ ตอนนี้ใช้ print server ในตัวโปรแกรม หรือ Print server แยกเฉพาะครับ

ตอนนี้ใช้ PTV_PrintServer อยู่ครับ

ถัดมาเรื่อง การกำหนดระบบเลือกพิมพ์ Sticker อัตโนมัติ ตามห้องที่ส่งต่อ แต่เดิมกำหนดได้แค่ 1 ห้อง คือห้องจ่ายยาที่กำหนดไว้ใน System setting ผมได้แก้ปัญหาให้โดยเพิ่ม field print_sticker_check ในตาราง kskdepartment ดังนั้นสามารถกำหนดค่าใน field นี้ให้มีค่าเป็น Y ในห้องที่เปิด Print Server เอาไว้  หากห้องที่แพทย์ส่งต่อไม่ได้กำหนดให้มีค่าเป็น Y ระบบจะไม่สั่งพิมพ์ Sticker ครับ  (ปัญหาที่เหลือ ขึ้นอยู่กับแพทย์แล้วว่าจะเลือกห้องถูกหรือไม่ เพราะมันจะเหมือนกับปัญหาเดิมที่แพทย์ ไม่ได้มาเลือกพิมพ์หรือไม่พิมพ์ Sticker ในห้องตรวจที่สอง)

ผมจะลองทดสอบดูครับ
แต่ว่าต้องเป็น version ใหม่หรือเปล่าครับ
ห้องแพทย์และห้องยาต้องใช้ version ไหนครับ

ส่วนปัญหาการพิมพ์ Sticker ซ้ำซ้อน ผมคิดว่าน่าจะเกิดจากใช้ Print Server ตัวเก่า (PTV_PrintServer) แต่ถ้าใช้ตัวที่มากับ HOSxP แล้วยัง Print ซ้ำ อาจจะต้องตรวจสอบระบบดูอีกครั้ง และที่ผมแนะนำคือใช้ RTC Print Server แทน จะสามารถออกแบบฟอร์มและแก้ไขปัญหาได้ง่ายกว่า  แต่ถ้าเปลี่ยนไม่ได้อาจจะต้องทำการแก้ไข PTV_PrintServer ให้ใหม่ครับ

RTC Print Server สามารถจำกัดสิทธิ การออกแบบฟอร์มและแก้ไข ได้หรือเปล่าครับ
คือไม่อยากให้ผู้ใช้แก้ไขเองได้ครับ
แต่ถ้าไม่ได้ก็ไม่เป็นไรครับ
ผมจะลองทดสอบ print server ตัวใหม่ (RTC Print Server) ดูครับ

พอดีว่าคนไยอะมากถ้านให้ห้องยาพิมพ์ sticker เอง  คงไม่ทันแน่ๆ
อีกอย่างนึงคือว่าห้องยาของ รพ. ก็มี 2ห้องด้วย แต่ละห้องก็ทำงาน
คนละส่วน  อยากให้ทาง Hosxp ช่วยหาวิธีแก้ให้หน่อยนะครับเพราะ
มันเปลือง Sticker มากๆ ขอบคุณไว้ล่วงหน้าเลยนะครับ   

ตอนนี้ ร.พ. ผมติดปัญหาเรื่อง sticker เรื่องเดียวครับ
ทำเรื่องสรุปปัญหาส่งผู้บริหาร เพื่อให้อนุมัติเงินไปแล้ว
แต่ห้องยาคัดค้านครับ เลยสรุปปัญหาเพื่อให้อนุมัติไม่ได้ครับ

สรุปคือ ถ้าอาจารย์ แก้เรื่อง sticker ให้
ก็จะสรุปปัญหาทั้งหมดส่งผู้บริหารได้
โดยไม่มีแผนกใหนคัดค้านครับ

Dxtype ที่ให้เลือกมันมี 5 แต่ diagtype ในฐานข้อมูล มันมีแค่ 4 ครับ
ตารูปนะครับ ถ้าผมจะให้มันมี 5 เหมือนกัน
ผมต้องเอาประเภทที่ 5 ที่ใหนมาใส่ครับ

แก้ไขให้แล้วครับ

ขอบคุณครับ
แต่ว่าผมจะ Load ตัวที่แก้ไขแล้วได้จากที่ไหนครับ

อย่างนี้ต้องร้องขอ อ.ชัยพร ช่วยพิจารณาแก้ไขโปรแกรมให้ดีกว่าครับ

-ที่ทำไปถูกต้องแล้ว
-ต่อไปเพียงแค่ Upgrade Version ใหม่เท่านั้น ส่วนตัว Setup ไม่ต้องใช้แล้ว

ปัจจุบันเท่าที่พอจะทราบคือ
-เข้าโปรแกรม "ระบบผู้ป่วยนอก, บันทึกผลวินิจฉัย
-คลิ๊กขวาตรงชื่อคนไข้ที่ต้องการ แล้วเลือก "พิมพ์, เลือกเครื่องพิมพ์, แล้วเลือกใบตรวจรักษา (แฟ้มเวชระเบียน)" ข้อมูลที่ต้องการก็จะพิมพ์ออกมาให้ดู (ไม่ทราบว่าคำตอบตรงใจหรือเปล่า)

ที่ว่าจะ "ลบ" หมายถึงลบข้อความแต่ละช่องใช่หรือไม่
-ถ้าใช่ ก็เพียงแต่ลบข้อความออก แล้วเลือกปุ่ม "บันทึก" ด้านล่าง ก็น่าจะเรียบร้อยแล้ว
-ถ้าไม่ใช่ ขอรายละเอียดมากกว่านี้หน่อย (เผื่อจะพอช่วยได้)

ปัจจุบันแก้ปัญหาโดยบันทึกเลขที่บัตร ปชช. ของผู้ป่วยทุกคนที่ Load เข้ามาจากระบบเก่า ที่ไม่มีเลขที่บัตร ปชช ให้ใช้เลขที่ 1-1111-11111-111 ทั้งหมด

เท่าที่ดูจากภาพที่ส่งมา ความกว้าง, ความยาว ของกระดาษยังไม่ได้เปลี่ยนขนาดเลย
น่าจะลองเปลี่ยนให้ตรงกับขนาด Sticker ก่อนนะ

Set ที่ฟอร์มก่อน (ลองดูนะ)

25. "โปรแกรมห้องตรวจแพทย์"
- คนไข้มารับการรักษาเมื่อเวลา 23.30 น. แพทย์ส่งตรวจ LAB และ X-Ray ระหว่างรอผล LAB กับผลอ่านฟิล์ม เวลาเลย 24.00 น. จนกระทั่งเปลี่ยนวันใหม่ ชื่อคนไข้ที่รออยู่ห้องตรวจแพทย์ หายไป ต้องขอให้เวชระเบียนส่งชื่อตรวจใหม่ และต้องทำการส่งตรวจ LAB และ X-Ray ใหม่อีกรอบ
   ปัญหาคือ   
   1. ยอดคนไข้ที่ลงทะเบียนตรวจมีจำนวนมากกว่าความเป็นจริง
   2. แพทย์ต้องเสียเวลาคีย์ส่งตรวจ LAB และ X-Ray ใหม่อีกรอบ
   3. X-Ray มียอดการใช้ฟิล์มเพิ่มขึ้น
   4. แพทย์อ่านฟิล์ม ต้องคีย์ผลอ่านฟิล์มใหม่
   5. LAB ต้องลงผลตรวจใหม่
   6. LAB คิดค่าใช้จ่ายกับโรงพยาบาล 2 ครั้ง (ถ้าลืมลบรายการครั้งแรกออก)
   7. ข้อมูลเวลาที่คนไข้เข้ารับการรักษา จนสิ้นสุดกระบวนการ ไม่ตรงตามความเป็นจริง
     หมายเหตุ    
   ถ้าเปิดให้แพทย์สามารถคีย์ข้อมูลย้อนหลังในหน้าตรวจของโปรแกรมบันทึกผลวินิจฉัย
                ก็จะเกิดปัญหาแพทย์คีย์ค่าใช้จ่ายคนไข้รายอื่นย้อนหลัง และยอดคนไข้ที่เข้ารับการตรวจ
   แต่ละห้องจะมีจำนวนเพิ่มขึ้นจากความจริง อีกทั้งรายงานที่พิมพ์ออกไปแล้วจะไม่ตรงกัน
   เมื่อมีการร้องขอให้พิมพ์รายงานใหม่ ซึ่งผู้ใช้มักจะแจ้งว่าเป็นความผิดพลาดของโปรแกรม
   ในการบันทึกข้อมูล และทำให้เจ้าหน้าที่คอมพิวเตอร์ต้องเสียเวลาในการค้นหาปัญหาที่เกิดขึ้น

ปัญหานี้ได้มีการจำกัดสิทธิการใช้งานแล้ว ก็ยังสามารถเข้าเมนูนี้ได้

ปัญหาคือ  เลขที่บัตรประชาชนที่คีย์ในหน้าลงทะเบียนส่งตรวจ ตรงกับเลขที่บัตรรับรองสิทธิในตาราง HIPDATA ทำไมโปรแกรมไม่แสดงเตือนว่า "มีสิทธิประกันสังคม เหมือน Case อื่น ๆ"
และจะต้องแก้ไขอย่างไร ? เพื่อไม่ให้เกิดปัญหาลักษณะเช่นนี้อีก

24. "ลงทะเบียนการส่งตรวจ"   
- ผู้ป่วย  เป็นชาวต่างชาติ และถือบัตรรับรองสิทธิเลขที่บัตร "6-0141-02595-54-6"
(มีข้อมูลอยู่ใน table Hipdata ชื่อ "ZHAO DENENG" ) เมื่อลงทะเบียนส่งตรวจรักษา โปรแกรมไม่แสดงข้อมูลใน Hipdata ที่หน้าจอส่งตรวจ แม้จะใส่เลขที่บัตรประชาชน ให้ตรงกับเลขที่บัตรรับรองสิทธิแล้ว ก็ยังไม่แสดงข้อมูลให้ทราบว่าผู้ป่วยมีสิทธิประกันสังคม
(ก่อนที่จะบันทึกข้อมูลผู้ป่วย ที่หน้าลงทะเบียนผู้ป่วย เลขที่บัตรประชาชนเป็นสีแดง
เมื่อบันทึกเสร็จแล้ว เลขที่บัตรประชาชนไม่เข้าไปเก็บในตาราง patient )