Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

change the sql query in caterogies items select
 
princesimon
Jr. Member
 
Total Posts:  16
Joined:  2009-03-26
 

Hi,

Can someone point me in the right direction in where I can modify the sql query for the categories item select?
or for that matter is it posible to display the actual sql query in the screen/webpage?

Thanks again for the help

 
Magento Community Magento Community
Magento Community
Magento Community
 
back2007
Member
 
Total Posts:  59
Joined:  2009-03-30
 

hi, you can modify SQL in app\code\core\Mage\Catalog\Model\Resource\Eav\Mysql4\Category\ for example.  But magento team does not use plain SQL.  Instead they prepare it using Zend_Db (http://framework.zend.com/manual/en/zend.db.select.html)

 
Magento Community Magento Community
Magento Community
Magento Community
 
back2007
Member
 
Total Posts:  59
Joined:  2009-03-30
 

Hi, as far as I understand you need smth like this
http://www.magentocommerce.com/boards/viewthread/5670/P15
and some code like
http://www.magentocommerce.com/boards/viewthread/5500/

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top