ITLive Web Services

Table names and table prefixes

If you are looking for setJoinCategories(true) then no need to search because it is not written anywhere. Just go below of page and look for following function
protected function _preparePage()
{
if(!$this->getJoinCategories()) {
return parent::_preparePage();
}

$this->getCollection()->getSelect()->reset(Zend_Db_Select::GROUP);

parent::_preparePage();

$collection = $this->getCollection();
$collection
->joinField(‘category_id’,
‘catalog/category_product’,
‘category_id’,
‘product_id=entity_id’,
null,
‘left’);
$category_name_attribute_id = Mage::getModel(‘eav/entity_attribute’)->loadByCode(‘catalog_category’, ‘name’)->getId();

//@nelkaake -m 13/11/10: Added support for tables with prefixes
$ccev_t = Mage::getConfig()->getTablePrefix(). ‘catalog_category_entity_varchar’;
$collection
->joinField(‘categories’,
$ccev_t,
‘GROUP_CONCAT(_table_categories.value)’,
‘entity_id=category_id’,
“_table_categories.attribute_id={$category_name_attribute_id}”,
‘left’);
$collection
->joinField(‘category’,
$ccev_t,
‘value’,
‘entity_id=category_id’,
“_table_category.attribute_id={$category_name_attribute_id}”,
‘left’);
$collection->groupByAttribute(‘entity_id’);

}

You can find everything here.

Mage::getConfig()->getTablePrefix() you can use this value to get table prefixes

For example Mage::getConfig()->getTablePrefix(). ‘catalog_category_entity_varchar’;

also you can use below code to write custom query

$write = Mage::getSingleton(‘core/resource’)->getConnection(‘core_write’);