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

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!

Keywords: collection SQL

★★★ The Magento Expert ★★★

Magento Professional with 27040 hours project experience

Getting the SQL of a collection (Magento 1)