Getting the SQL of a collection | The Magento Expert

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

$sql = (string)$collection->getSelect();

1	$sql = (string)$collection->getSelect();

Getting the SQL of a collection

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