Getting the SQL query of a collection

This short piece of code returns the SQL query behind a Magento collection.

$select = $collection->getSelect()->__toString();

1	$select = $collection->getSelect()->__toString();

Need help implementing this solution, or still looking for a fix to your Magento problem? Get in touch and I will be happy to help with your project.

Tags: collection SQL

The Magento Expert