select r.EQUCODE, r.POSITIONSTATUS, r.AddressType, r.RENTINGSTATUS, r.POSITIONSTATUS, r.notes, r.effectivedate, r.createtime, r.AB_TEST_TYPE from SCM_HX01_EquStatusRecord r left join SCM_HX00_EQUCARDHEAD h on r.EQUID = h.billid where h.equno in ('THX-PH00006MOBA-10457H', 'THX-PH00010MOBA-10457H', 'THX-PH00011MOBA-10457H', 'THX-PH00055MOBA-10457H', 'SHX-JG00616GS2646', 'SHX-WG00012AMWP 11.5-8100', 'SHX-JG21500JCPT1212HD', 'SHX-JG21501JCPT1212HD', 'SHX-JG21502JCPT1412HD', 'SHX-JG21503JCPT1008HD', 'SHX-JG21504JCPT1008HD', 'SHX-WG00014AMWP 11.5-8100', '苏ET6X38', 'SHX-S023', 'SHX-S062', 'SHX-SG00105S60X', 'SHX-SG00120660SJ', 'SHX-SG00128660SJ', 'SHX-SG00129660SJ', 'SHX-SG00175660SJ', 'SHX-SG00182660SJ', 'SHX-SG00189660SJ', 'SHX-SG00208860SJ', 'SHX-SG00224660SJ', 'SHX-SG00245S65', 'SHX-SG00324860SJ', 'SHX-SG00457660SJ', 'GHX-DJ00049PCF-450', 'GHX-DJ00046PCF-350', 'GHX-DJ00048PCF-450') and r.RENTINGSTATUS=9110 order by r.effectivedate desc, r.billid desc;