select REQUISITION_ID TXM000,inspection_id JYYWID,test_order_name ZLXMJC,inspection_date SQRQ00,inspection_date SJRQ00,outpatient_id brid00  ,'' SectionNo,'' ItemNo,'' Prec,'' TestTypeNo,'' SerialNo, convert(varchar(20), check_time,20) BGRQ00,convert(varchar(20), sampling_time,20) BBCJSJ,case  when group_id='G023' then '2' else  '1' end as type, patient_name BRXM00, case when patient_type='1' then '住院' when patient_type='2' then '门诊' when patient_type='3' then '住院' when patient_type='4' then '门诊' when patient_type='5' then '体检' else '其他' end as MZZYBZ, sample_class_name BBMC00 from view_inspection_sample where REQUISITION_ID in ('2300766151','2700341602','3564300669','3664175901','3664175901','3664175901','5100078419','3564300669','5300057815','5300057815','5300057815','3800115696','3800115696','3800115696','3800115696','2481010418','3664175901','5200004823','1100849706','5100078372','3664175863','3664175863','5100067542','3564297353','5300057465','5300057465','5300057465','5200004832','2481010283','5100078394','5200004861','3664176009','3664176009','5300057537','5300057537','5300057537','3564297233','5100078387','3564300692','5100078391','5200004852','1200683763','5100078326','5200004857','3664175911','3564297145','5300057676','5300057676','5300057676','5200004817','5300057452','5300057452','5300057452','5100097378','3664203056','3564297125','3664145223','3664145223','3564259568','5100037804','2300762034','2700345589','3564259496','5300042913','5300042913','3564259496','3564259496','3564259496','3564259496','1200651405','2700346399','2700347305','5100037904','3664143887','3664143887','3664193388','5300042618','5300042618','1200631491','2700347530','3664196810','3664196810','1200680197','2700348517','7700070802','7700070814','3664200618','5100116269','3664200577','3564323228','5200019527','5300086471','5300086471','5300086471','5100116429','3664200423','3664200423','7700009872','7700025390','1200646294','1200666308','5100115048','2300827825','2700356131','3564312039','3664198928','5300097739','3664198928','5300097739','3664198928','1300291841','3664198750','3564328869','5200008444','5100142096','1300291839','7700055612','2300808756','5100142146','3664198646','3664198646','5300097970','5300097970','3664198641','3664198641','3664235463','3564341183','3664235463','2900017824','-2900017826-','-2900017825-','3664230898','3664230898','5100159947','3664235463','5200019838','2300840023','5300080378','5300080378','5300080378','1100876334','1300279673','1300279665','1300279681','5100154539','3664260075','5200018721','3664260075','3564340951','5300101332','5300101332','5300101332','3664260075','3664260012','3664260012','2300820135','7700083138','3800128992','3800128992','3800128992','3564348482','3564352251','5200022087','3800125567','5900025349','3564348482','3564348482','3664253502','5100108144','3664256977','3664256977','3664256977','5300082749','5300082749','3664256977','5300082749','1200550460','3664250390','3664250390','1200550387','1200550388','1200550382','2700369619','7700071808','3564348482','1200550529','3764034826','3764035118','1200550206','2900019496','2900019495','2900019494','2300806841','2700363101','3564348482','3800128992','2900019937','2900019936','2700366048','2700367078','2700367425','2700367424','1200552366','2900020142','2900020143','2900020144','2300833463','1200552320','1200552319','2700367518','-061526564700-','5100160388','3664258799','3664258799','5300111415','5300111415','3664258788','2700365414','2300809684','2700372956','2700372001','2900020738','1200550297','2700372401','2900020797','2900020795','2900020796','5100153777','3664250962','5300108925','5300108925','3664251062','3664251062','2300805159','1200552081','2900020823','2900020824','2900020825','2300810776','1200551787','2300812256','2700372730','5100164410','3664262022','3664262253','3664262253','5300097031','2700371118','2900021352','2900021351','2900021409','1200551772','1200551773','2300833027','2700378484','2900021508','2900021507','2900021506','2300833337','1200551957','2300832895','2700377490','5100164482','3664246808','3664246808','5300097049','3664246779','3664246779','5300097049','2700376458','2300832647','1200552011','1200551913','3664245841','3664246816','2300832361','1200548043','2700382409','2900022269','2900022267','2900022268','2700384503','7100029670','2300813860','5100180500','3664245841','3564349176','3564349224','3564349222','2481014782','2481014811','2300814462','2700383922','2700382598','2300832967','2700389098','2700386130','2700387868','7100029255','7100029224','2900023154','2900023155','2900023156','2700390774','2700388719','2700386591','7100029961','2300829047','5100180491','3664238908','3664238908','3664238896','1200548024','2700390047','2900023416','2300830150','2900023415','2900023417','2700392338','2700391554','2700394554','2700395249','2700393224','2700396489','1100645676','2300828934','5100191868','3664240836','3664240836','3664240850','2700399557','2700404811','2700406017','2300838537','2700408057','2700409500','5100160234','3664231226','3564332363','3564332363','3664231226','5200019414','5100154368','3664260028','5200019197','3664260028','3564341031','3664260028','3664260052','3664260052','2900018323','1400203391','2900018324','2300838271','2300821296','1100876340','7700083153','5100155234','3664260151','5200019423','7700071695','3664260151','3564351662','3664260151','3664260066','3664260066','5300101210','5300101210','5300101210','2300827631','1200550347','1200550308','2700363939','2700363209','1200550383','-061523158900-','2900019911','2900019912','2900019913','1200550254','1200550253','1200550257','1200550258','1200550376','2300808349','5100108258','3664256954','3664256741','3664256741','2300820014','1200550213','1200550272','1200550269','1200550271','1200550270','1200550219','1200550220','1200550221','2700364449','5100155067','3664256997','3664256889','3664256889','3664256997','5300096119','5300096119','2700365392','-061523159600-','2700365388','2700365389','2700368653','1200553785','2900020327','3664272967','2900020479','2900020480','2900020481','2300835907','1200553733','2700368991','2700370113','5100153817','3664272961','3664272961','5300108618','5300108618','2700369699','-2700369762-','3664273172','3664273172','5300111675','5300111675','3664273073','5100160393','3564350370','2900020273','3564350557','2700370309','2700368446','3564350345','1200553786','2900020561','2900020560','2900020559','1200553744','3664273144','3664273144','5300111686','5300111686','1200553750','2700369251','2300811278','2700374276','2700374834','2700374835','2900020935','2900020937','2900020936','2300811374','2300812208','2700377352','1200551905','1200551805','1200551806','1200551801','2900021105','2900021104','2900021103','2700375067','2700374054','1200551894','1200551880','1200551879','1100860077','5300122562','5300122562','5100180452','3664241314','3664241314','3664241231','2300814764','2700380110','2700379048','2900022122','2900022121','2900022120','1200551851','2300832279','2700379243','2900021685','2900021684','2900021683','1200551846','1200551845','2300832399','2700381359','2700381161','2900022157','2900022156','2900022155','1200548016','2300812968','5100180669','1200548034','1200548034','1200548033','2300838657','5100188918','3664246924','3664246924','3664247006','2700385288','3664239536','3664239536','5100194914','2700385701','7100029620','2300833423','2700386895','5100188567','3664246778','3664246535','3664246778','7100029348','2900022381','2900022382','2900022383','7100029562','2300829487','7100029542','2300837787','2900022657','2900022658','2900022659','2700400919','2700398430','2700403451','2700402280','2700396887','2700400439','2700410953','2700407039','2700412045','5100233321','3664278984','5300128577','5300128577','2700415107','2700413652','2700416786','-3764030947-','5100222361','3664280928','3664280893','3664281011','5300090492','3664281011','3664280893','1100645694','2300805973','5100200087','3564379765','3664266401','5200018902','5100233066','3664278780','5300090562','3664278990','5300090562','3664278990','3664278990','3800141544','7100026157','3764030886','3800141800','5100222284','3664280742','3664280742','5300090510','5300090510','5300090510','3664281021','3664281021','3664281021','3664281021','7100026201','7100026198','7100026200','7100026199','2300819229','7100026197','2900026197','2900026198','7100026194','7100026193','7100026195','7100026196','5100222535','3664280708','3664280708','3664280768','5300090259','3664280768','3664280768','3664266435','2900026049','5100233235','3664279102','5300128361','3664279065','5300128361','3664279065','2300821810','2900026333','2900026334','3664278708','5100233556','3664278748','5300128449','3564383453','5300128449','3664278712','3664279376','3564365809','7100026171','7100026172','7100026170','7100026169','2700418012','3664278976','7100026135','7100026132','7100026131','7100026134','7100026133','3664279102','2700419234','2900026371','2900026372','3800141897','5100233364','5300128861','5300128861','3664265479','3664265479','2900027043','2900027044','2700422307','5100232543','2300825142','2900026806','2900026807','7100026120','5100233184','3664265579','3664265579','5300128581','5300128581','3664265496','3664265496','3764030953','7100026127','5100233233','3664265492','5300128485','3664265466','5300128485','3664265466','3664265466','3664270095','3764031093','7700215236','5100232326','5300128623','5300128623','3664265451','3664265451','2700420572','2900027084','2900027085','2700424992','2700423214','5100232391','5300127624','5300127624','3664270080','3664270080','2700423099','5100232553','5300127848','5300127848','3664270144','3664270201','3664270201','5100232617','5300127588','5300127588','3664269981','3664269981','3664269978','3664269978','2900027270','2900027271','2900027269','2900026925','2900026926','2700420889','5100233228','5300128450','5300128450','3664265325','3664265325','5100232450','5300127676','3664303447','3664303447','5100232426','5300127804','3664303307','3664303307','2700427545','3764030925','7100026336','5100199889','5300127816','3664303335','3664303335','5100200234','3664303446','3664303339','5100232424','5300127668','3664303339','2700426460','5100199623','5300119731','3664267217','3664267217','3564383474','5100199596','5300119871','5300119871','3664267446','3664267446','3664267274','3664267274','2900027975','2900027976','2900027974','2700429207','2700430862','5100199896','5300119862','3664267659','3664267659','3664267190','2900028121','2900028120','2900028122','2300821780','7100026338','5100204593','3664306019','3664306019','3800147964','3800147964','3800147964','3800147964','5100199607','3664296216','3664296216','3664296219','3664296219','2700432618','2900028727','2900028726','2900028728','2310006184','7100026039','5100204641','3664296512','3664296512','3664296509','3664296509','3564383326','2700433990','2700435768','3664306195','5100204699','3664306164','3664306164','3664306022','5300120390','3664306195','5100204619','5300133128','3664306009','3664306009','3664306195','5900064891','2900029069','2900029070','2900029068','5100208097','3664313793','3664313793','5300133281','2700437470','2700440584','2700438920','5100207843','3664310216','5100204640','3664312720','3664312720','5300138557','5100207800','3664314797','3664314797','5300138421','7100026096','2700445652','2700444869','3664319077','5300134381','5100223463','3664319077','2700443823','2900030085','7100025913','2900030084','2700446985','2700448535','2900030433','2900030434','2900030437','2900030438','2900030435','2900030436','5100225598','3664315499','5300137114','5300137114','3664326913','3664326913','3664326913','3664315499','2310001820','2700451469','2700449671','5100225732','3664320426','5300137191','5300137191','3664322787','3664322787','3664322787','3664320426','2310020594','5100271796','3664309662','5300140641','5300140641','3664309526','3664309526','3664309526','3664309662','2900031392','2900031393','2900031396','2900031399','2900031394','2900031395','2700454612','2700453016','5100271910','3664309330','5300140484','5300140484','3664309314','3664309314','3664309314','3664309330','5100273010','3664311966','5300148991','5300148991','3664311997','3664311997','3664311966','2700457681','2700456278','2700460344','2700459126','2310020547','5100249378','3664313921','5300148815','5300148815','3664313879','3664313879','3664313921','2700462027','2700463665','2900032247','2900032249','2900032248','2900032251','2900032246','2900032250','2700466437','2700465129','5100252570','3664339262','5300146911','5300146911','3664339264','3664339264','3664339262','2900033164','2900033165','2900033163','2900033166','2700467936','2700469308','2700470502','2700471899','2700474724','2700473458','2700476013','2700477276','5100268429','3664329816','5300170055','5300170055','3664330055','3664330055','3664329816','2900034631','2900034632','2900034629','2900034740','2900034627','2900034628','2700479200','2700480383','2700478383','5300153420','5300153420','3664298734','3664298734','3664301289','5100280994','3664301289','2700481886','2700484510','2700483116','5100280850','3664301652','3664301496','3664301496','3664301652','2700487637','2700486114','2700488882','2700492732','2700494324','2700493481','2700491925','2700496742','2700495180','5100289355','3664291323','5300151305','5300151305','3664291173','3664291173','3664291323','2700490582','5100275892','3664304140','5300154700','5300154700','3664304139','3664304139','3664304140','2700498517','5100289321','3664352745','5300151278','5300151278','3664352741','3664352741','3664352745','2700501592','2700500101','2310048324','7700217069','2310048308','7700217051','2700505010','2700503016','-2900037773-','7700217096','7700217095','7700217098','5100308383','3664356170','5300180018','5300180018','3664355957','3664355957','2310048337','3664356170','-2900037774-','2900037772','3664352155','3664352169','5100302148','3664355356','2900038017','2900038018','5900066986','3564419465','5100301889','5100293245','3664355619','3664355619','5300176265','5300176265','5300176265','5300176265','3664355403','3664355403','3664355403','3664355403','7100007929','7100007907','7100007894','7100007939','2310022612','7100007829','2900037917','2900037918','3664351802','3664355265','3664355265','5300176222','5300176222','3664351929','5300175983','2700512391','2900037945','2900037944','5300159291','3664352169','3664352169','2700508014','-061668186400-','3664352155','2900038421','2900038419','2900038420','2700513547','2900038058','2900038060','2900038059','2700510098','2700514816','3664351916','5100293308','3664352344','3664352344','3664351776','3664351776','5300159406','3664351776','2900038244','2900038242','2900038243','3664351929','2900038498','2900038497','5100301897','3664355388','3664355388','3664355288','7100007979','7100007940','7100007906','7100007948','3664355288','3664355288','2900037976','2900037975','2310022611','7100007826','3764067966','7100007712','2700510709','5100293285','3664355624','3664355624','3664355139','7100007980','7100007967','7100007954','7100007968','3664355139','3664355139','2900037923','2900037924','2310022610','2900037922','5100301865','2300820095','7100007702','5100293134','3664352176','3664352176','5300159255','5100301973','5100302103','3664352164','3664352164','5300176102','3664352203','2300823363','7100007711','3664352203','5100293154','3664369611','3664369611','3664369613','3664369613','5300159352','3664369613','2300823817','7100007692','2700520396','2700523645','2900039107','2700518612','7100006677','2700517245','2700521833','5100293156','3664369608','3664369608','5300159684','3664369413','5100293320','3664369413','5300159301','2300824052','7100007637','3664369658','3764067754','7100007695','2700522698','3664368012','2700524364','7100006604','2900038935','2900038936','5100253751','3664355690','3664355690','5300146755','2900039106','2900039105','3664368012','5100253563','3664368062','3664368062','2700519176','2700525136','2700516178','3664355892','3664355892','3664355892','2700521165','5100253597','3664357196','3664357196','5300146794','5100253743','3664367901','3664367901','2900038537','2900038536','2700515267','2700519775','2700526749','2700525980','2700528304','5300154646','5300154646','5300154646','2700530259','2700534060','5100302597','3664364773','3664364773','3664365050','3664365050','2700527461','5100302886','3664384558','3664384558','2300823221','2310022571','5100302729','3664384657','3664384657','5300186466','3664384749','3664384749','2700531226','2300821306','7100006712','2700535149','2700529326','2700532334','2300823618','7100006824','2310022643','5100302855','3664368121','3664368121','2700533244','2700536258','-061702082000-','5100305068','-061702081300-','-061702081300-','-061702081300-','5300154496','3664363073','2310079369','-061702081900-','3800177891','-061702081500-','-061702081500-','-061702081500-','-061702081500-','-061702081200-','-061702081600-','-061702081600-','-061702081200-','-061702081500-','3664362826','3664385812','3664385721','2700538544','2700542767','3664363014','3664363014','3664363014','2310022627','7100007019','2700539765','5100305136','3664385812','3664385812','3664385812','3664385721','3564423379','5300154401','3664385721','2700540726','2700542663','3564396630','3564423380','3564423380','3564396630','3800178106','3800178106','3800177628','3564396630','3564396630','2700543908','2700541612','3564396630','2700537407','2700546193','2700548345','5100321118','3664385046','3664385046','3664385046','5300185826','3664385049','2700545057','2700547358','2700549250','3800177915','3564396631','3564396409','3564396409','3564396631','3800136067','3800136067','3800135358','3564396631','3564396631','3564396631','2700551401','3764068049','7100006931','2310079217','7100006932','3664384794','2700550312','5100321215','2900041116','2900041117','2900041118','2700554079','5100321141','3664366781','3664366781','3664366781','5300184174','3664366760','2700552833','5100304470','2700557643','5100304466','3664366845','3664366845','3664366845','3664367254','2310077066','2700557482','2700558787','2700556460','2700555352','5300184329','3664360092','5100304442','3664360090','3664360092','2310077103','2700562645','3664360090','2700560295','2700561572','2700563712','5100304348','3664360196','2700566229','2700564617','3564396795','-2700000179-','5100250009','3664388095','3664388095','5300173209','3664388086','3664388086','3664388086','2481000860','2310079434','3564397090','2700565342','3664360182','5300184062','3664360368','5100304438','3664360182','3664360368','3664360182','7900141155','2700567001','7960009829','5300194442','5300194442','3664383241','2700000691','2310077096','7100050773','2900042937','2900042936','3564396386','3564396386','3564396386','3564396386','5100331908','3664383378','3664383378','3664383241','5100250160','3664388356','3664388356','5300173139','3664388345','5100249998','3664382949','3664382949','5300173175','3664383174','3664383174','7700145418','7700145420','7700145419','7700145421','7700275709','5100352498','3664391597','3664391597','7700145416','5300179224','3664391222','3664391222','3564477682','7960004652','2700002236','2700001850','5100337096','3664395054','7100080227','7100080247','7100080240','7100080246','7100003788','7100003787','7100003786','7100003789','5100352356','3664398877','3664398877','5300168292','5100349398','3664419869','3664419869','5300168259','3664405590','3664405590','2700003000','5100361175','5100349159','3664413005','3664413153','5300179258','5300179258','3664413153','3664413005','3664413005','7700145286','7700145285','7700145288','7700145287','5100361179','3664419494','3664420060','5300179340','5300179340','3664419494','3664420060','5100361151','3664419320','5100361173','3664419273','3664419273','5300168401','5300168401','3664419320','3664419273','7700332420','7700332417','7700332419','7700332421','7700145268','2900047405','2900047404','2900047539','2900047538','2900047966','2900047965','7960013740','7700332507','7700145273','7700332505','7700332504','5100352487','3664419634','3664419287','3664419287','2700004380','5100338658','3664409893','3664419285','3664409893','-3664410029-','-061736659800-','-061736659800-','-5100352461-','5100338693','3564465204','3564465204','3664410116','3564477698','5100338726','3664420172','3664410130','3664410130','3664420172','2900048608','2900048609','5100352226','3664419612','3664419626','3664419626','3664419612','5100399422','3664430014','3664429835','3664429835','3664430014','3664430014','5300180427','5300180427','3664430014','3664420046','2900049786','3664417277','5100404163','3664417261','3664417261','3664417277','3664417277','5300180267','5300180267','5300180267','3664417277','5300180267','3664398563','3664398563','5100338598','5300189204','5300189204','3664429688','3800143360','3800143360','3800143360','3800143360','5300180422','7100000954','7100000957','7100000956','7100000955','2310044022','7100000854','3664419934','3664419934','5100338554','3664419846','3664419846','2900049123','2900049124','5100401186','3664437040','3664437142','3664437142','3664437040','3664437040','5300217271','5300217271','3664437040') and inspection_date>='20221229' and inspection_date<='20230224' and check_person is not null and REQUISITION_ID is not null and inspection_state in('audited','finished','reported','sent') order by check_time desc