ETC接口的测试的调查 sql

根据订单的vin查询log

SELECT * from  log_car_driving_license where xbx_order_id IN (SELECT   xbx_order_id  from order_info_car_person_etc where vin in (

    'LKCAA1AB6CH003049',
'LKCAA1AB2EC035089',
'LKCAA1ABXEC055638',
'LKCAA1AB2DH701322',
'LKCAA1AB0CH112820',
'LKCAA1AB2EC034847',
'LKCAA1AB3EC033111',
'LKCAA1AB5FC016067',
'LKCAA1AB7FC019570',
'LKCAA1AB7CH014917',
'LKCAA1AB0EC046141',
'LKCAA1AB1EC058525',
'LKCAA1AB4FC012169',
'LKCAA1AB3EC055609',
'LKCAA1AB6DH708726',
'LKCAA1AB9EC054688',
'LKCAA1AB5DH702285',
'LKCAA1AB0EC011387',
'LKCAA1AB5BH002568',
'LKCAA1AB6DH710797',
'LKCAA1AB9CH016426'

))

查询成功的，，调用行驶证的，指定的channel   的log    body信息

、

SELECT body from  log_car_driving_license where xbx_order_id IN (SELECT   xbx_order_id  from order_info_car_person_etc where apikey='3cbd1e8e7c9945d9f8446ab626850268' AND xbx_order_status=0 AND operator_source=5);

//查询log日志

SELECT * from  log_car_driving_license where xbx_order_id IN (SELECT   xbx_order_id  from order_info_car_person_etc where vin in (
'LKCAA1ABB5H058413'
))
;




SELECT * from  log_car_renewal where xbx_order_id IN (SELECT   xbx_order_id  from order_info_car_person_etc where vin in (
'LKCAA1ABB5H058413'
));