Zau4man

public function getKino($date){
		$this->select('f.id', 'film_id');
		$this->select('f.image', 'film_image');
		$this->joinLeft('kino_films', 'f', 'f.code = i.code');		
		$this->filterEqual('date', $date);	
		return $this->get('kino_dates');	
	}

array(4) {
  [2]=>
  array(7) {
    ["date"]=>
    string(10) "2014-10-24"
    ["film"]=>
    string(38) "Прогулка среди могил"
    ["code"]=>
    string(6) "596274"
    ["place"]=>
    string(14) "Мелодия"
    ["time"]=>
    string(29) "09:00 13:30 15:40 20:10 20:30"
    ["id"]=>
    string(1) "2"
    ["image"]=>
    string(13) "kino/2014/10/"
  }
  [3]=>
  array(7) {
    ["date"]=>
    string(10) "2014-10-24"
    ["film"]=>
    string(10) "Судья"
    ["code"]=>
    string(6) "588672"
    ["place"]=>
    string(14) "Мелодия"
    ["time"]=>
    string(29) "09:00 11:10 15:40 17:50 22:20"
    ["id"]=>
    string(1) "3"
    ["image"]=>
    string(13) "kino/2014/10/"
  }
  [1]=>
  array(7) {
    ["date"]=>
    string(10) "2014-10-24"
    ["film"]=>
    string(14) "Дракула"
    ["code"]=>
    string(6) "395057"
    ["place"]=>
    string(14) "Мелодия"
    ["time"]=>
    string(17) "11:40 13:50 18:20"
    ["id"]=>
    string(1) "1"
    ["image"]=>
    string(13) "kino/2014/10/"
  }
  [5]=>
  array(7) {
    ["date"]=>
    string(10) "2014-10-24"
    ["film"]=>
    string(18) "Выпускной"
    ["code"]=>
    string(6) "839200"
    ["place"]=>
    string(16) "Меридиан"
    ["time"]=>
    string(5) "22:45"
    ["id"]=>
    string(1) "5"
    ["image"]=>
    string(13) "kino/2014/10/"
  }
}
 

SELECT d . * , f.id, f.image 
FROM cms_kino_dates d
LEFT JOIN cms_kino_films f ON d.code = f.code
WHERE d.date > '2014-10-23'

public function getKino($date){
		$this->filterEqual('date', $date);
		$this->join('kino_films', 'f', 'f.code = i.code');	
		$this->select('f.id, f.image');
		return $this->get('kino_dates');	
	}