id_, materials_id_, type_, stock_, transaction_date_, before_quantity_, after_quantity_, year_, month_, transactions_user_, quantity,remark_, is_dele_, create_by_, create_name_, create_org_name_, create_company_id_, create_company_name_, create_org_id_, create_time_, update_by_, update_name_, update_company_name_, update_company_id_, update_org_id_, update_org_name_, update_time_, last_time_, tenant_id_ SELECT t.* FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY materials_id_ ORDER BY transaction_date_ DESC, create_time_ DESC) AS rn FROM biz_materials_transactions WHERE transaction_date_ <= #{date} ) t WHERE materials_id_ IN #{id} AND t.rn = 1;