The following MySQL query returns all Magento orders that have at least one item with attribute set id 9.

Getting orders with items that have a certain attribute set
You want or need help implementing this solution? Maybe you did not find what you were looking for? Contact me and I will assist you with whatever Magento problem troubles you!