How to print sql query in Magento - Magento Source24

 Hello Magento friends today's i'm share with you to How to print sql query in Magento 

if you want to print your query when you get collection on database to add this bellow line code in file where you get collection.

try this example : 

<?php

$collection = Mage::getModel(‘catalog/category’)->load($categoryId)

->getProductCollection()

->addAttributeToSort(‘name’, ‘ASC’);

echo $collection->printlogquery(‘true’)