Yes, this is an old post, but here goes.
I think this post hasn't gotten a response because it will require a large amount of base development knowledge that is out of scope for a forum post.
If the following is unfamiliar a dev partner could help you out with this pretty easily.
- how to connect to a database
- how to use sql server management studio
- how to modify a SQL stored procedure.
- how to write SQL.
That being said, to filter products that have a ProductType of "blog", you would update the aspdnsf_RecentAdditions sproc with something like this:
WHERE p.ProductTypeID <> (SELECT ProductTypeID FROM ProductType WHERE ProductType.Name = 'blog')