มันขึ้นแบบนี้ครับ
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
หัวข้อ: หน้าลงทะเบียนผู้ป่วยในช้ามากครับ(เป็นบางครั้ง)ครับ (อ่าน 2708 ครั้ง)