<?php

abstract class App_Sponsor_Abstract_Obj extends Qs_Db_Obj
{
    protected $_fileFields = array('image');
    protected $_tableAlias = 'Sponsor';
    protected $_urlParseFields = array('url');

    public function getListSelect()
    {
        if (null === $this->_select) {
            parent::getListSelect();

            $this->_select->joinLeft(
                $this->_getPair($this->_tableAlias . 'Category' , 'sc'),
                "`sc`.`id` = `{$this->_tableAlias}`.`categoryId`",
                array('category' => 'title')
            );
        }
        return $this->_select;
    }
}