select * from Erp_Inventory where InventoryCode = 'S0016801' and CompanyId =12

select * from Erp_InventoryVariant where InventoryId =275106


select * from Erp_VariantCard where VariantCardName LIKE '%XXS%42%'


RENK EKLENMEZSE ÇİFT BEDEN GELM

select * from Erp_Inventory where InventoryCode = 'W0011201' and CompanyId =12

select * from Erp_InventoryVariant where InventoryId=276112 and Variant2Id=94006

delete from Erp_InventoryVariant where InventoryId =276112 and Variant2Id=95246


select * from Erp_InventoryVariant where InventoryId =254898

select * from Erp_VariantCard where RecId =793


select * from Erp_VariantItem where CardId =793


select * from Erp_VariantCard where VariantCardName LIKE '%XXS%XXL%'

select * from Erp_Inventory where InventoryCode='W0010762'

select * from Erp_InventoryVariant where InventoryId= 277014 Variant2Id = 94006

delete from Erp_InventoryVariant where RecId IN (1553203,1553204,1553205,1553206,1553207,1553208,1553209,1553210,1553211,1553212,1553213,1553214,1553215,1553216,1553217,1553218,1553219)


varyant 2 ama 3 gözüküyorsa



update Erp_InventoryVariant set Variant2Id= 72440 where RecId IN (1108866,1108902,1108920,1108938)