Index: ssts-web/src/main/webapp/dataUpdater/sqls/5.0.42_5.0.43.sql =================================================================== diff -u -r40417 -r40503 --- ssts-web/src/main/webapp/dataUpdater/sqls/5.0.42_5.0.43.sql (.../5.0.42_5.0.43.sql) (revision 40417) +++ ssts-web/src/main/webapp/dataUpdater/sqls/5.0.42_5.0.43.sql (.../5.0.42_5.0.43.sql) (revision 40503) @@ -2,16 +2,14 @@ where exists ( select 1 from TousseItem ti join ClassifiedItem ci on - (ci.toussedefinition_id=ti.tousseDefinitionId - or ci.tousseDefinitionID=ti.tousseDefinitionId) and ti.recyclingApplication_ID=ci.invoicePlanID + (ci.tousseDefinitionID=ti.tousseDefinitionId) and ti.recyclingApplication_ID=ci.invoicePlanID where ClassifyBasket.id=ci.classifybasket_id ) and not exists ( select 1 from TousseItem ti join ClassifiedItem ci on -(ci.toussedefinition_id=ti.tousseDefinitionId -or ci.tousseDefinitionID=ti.tousseDefinitionId) -and ti.recyclingApplication_ID=ci.invoicePlanID + (ci.tousseDefinitionID=ti.tousseDefinitionId) + and ti.recyclingApplication_ID=ci.invoicePlanID where ClassifyBasket.id=ci.classifybasket_id and (ti.isTerminated is null or ti.isTerminated=0) ) and (classifyBasketStatus is null or classifyBasketStatus=0); \ No newline at end of file