AND #TransType = P");