gistfile1.php

    public function fetchByCountryBrand($countryBrandId, $providerName = 'mpx')
    {
        $select = $this->select(true)
        ->join('album', 'album_id = video_album_id', array())
        ->join('serie', 'serie_id = album_serie_id', array())
        ->where('video_status = 1')
        ->where('video_provider_name = ?', $providerName)
        ->where('video_uploaded = 0')
        ->where('video_brand_id = ?', $countryBrandId);

        return $select->query()->fetchAll();
    }

public function fetchByCountryBrand($countryBrandId, $providerName = 'mpx')
{
    $select = $this->select()
        ->setIntegrityCheck(false)
        ->from(array('v' => $this->_name))
        ->joinLeft(
           array('a' => 'album'),
           'album_id = video_album_id'
        )
        ->joinLeft(
           array('s' => 'serie'),
           'serie_id = album_serie_id'
        )
    ->where('video_status = 1')
    ->where('video_provider_name = ?', $providerName)
    ->where('video_uploaded = 0')
    ->where('video_brand_id = ?', $countryBrandId);

    return $select->query()->fetchAll();
}