banners - banner_locais - banner_canais - banner_tipos - banners_banner_canais

BannersController.php

<?php 
		$banners = $this->Banner->find('all', array(
			'conditions' => array(
				'and' => array(
					'BannerLocal.alias' => 'pifb',
					'Banner.BannerCanal.canal' => '*',
					'Banner.ativo' => true,
					'Banner.excluido' => false
				),
				'or' => array(
					'BannerLocal.alias' => 'pifb',
					'BannerCanal.canal' => 'home',
					'Banner.ativo' => true,
					'Banner.excluido' => false
				)
			),
			'order' => 'rand()',
			'limit' => 7
		));
		debug($banners);
?>