MySql:
SEECT
d.DETAIL_ID,
d.WARE_ID,
d.WARE_NAME,
d.`STATUS`,
d.material_id,
d.material_info,
d.conversion_rate,
m.assign_purorg_id
FROM
`order_detail` d
LEFT JOIN mall_order m ON d.ORDER_ID = m.ORDER_ID
WHERE
(d.WARE_ID,m.assign_purorg_id) in(('1','1910260249874688'),('54','1910264272376064'),('54','1910260249874688'))
AND d.dr =0
and m.dr= 0
AND d.`STATUS` NOT IN (
"SAVED",
"COMMITEN",
"REJECTED"
)
Mapper: