Index: ssts-expensivegoods/src/main/java/com/forgon/disinfectsystem/expensiveGoods/service/ExpensiveGoodsManagerImpl.java
===================================================================
diff -u -r22333 -r22336
--- ssts-expensivegoods/src/main/java/com/forgon/disinfectsystem/expensiveGoods/service/ExpensiveGoodsManagerImpl.java	(.../ExpensiveGoodsManagerImpl.java)	(revision 22333)
+++ ssts-expensivegoods/src/main/java/com/forgon/disinfectsystem/expensiveGoods/service/ExpensiveGoodsManagerImpl.java	(.../ExpensiveGoodsManagerImpl.java)	(revision 22336)
@@ -1924,7 +1924,7 @@
 	public JSONObject searchExpensiveGoodsByKeyword(String keyword, Long supplierId, int start, int limit) {
 		String whereSql = " where po.isApplicationMaterial='" + Constants.STR_CAN + "' ";
 		if(DatabaseUtil.isPoIdValid(supplierId)){
-			whereSql += String.format(" and po.registrationCertification.expensiveGoodsSupplier.id = %s ", supplierId);
+			whereSql += String.format(" and po.certificationId in(select id from RegistrationCertification where expensiveGoodsSupplier_id=%s) ", supplierId);
 		}
 		
 		if (StringUtils.isNotBlank(keyword)) {