Use the following code to get the underlying SQL of a Magento collection:

Getting the SQL of a collection
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!