SELECT COUNT(*) FROM dbo.PL_TRADEDETAIL WHERE GOODS_ID IN (SELECT GD_ID FROM dbo.CM_GOODS WHERE GD_TYPE_ID='CP') AND RECORD_STATUS=1 AND APPROVE_DT ='2020-11-04 00:00:00.000'