fixed query so getting customers only returns the non deleted ones