//filter url
public static function url($orm, $url) {
        return $orm->where_raw('( `url_rewrite` = ? ) OR ( `url_rewrite_en` = ? )', array($url, $url));
}

//filter visible
public static function visibles($orm) {
        return $orm->where('trash', 0)->where('activ', 1)
        ->where_raw('(( DATE(`start_date`) <= ? ) AND ((`end_date` != ? AND DATE(`end_date`) >= ?) OR (`end_date` = ? OR `end_date` = \'\')))', array(date("Y-m-d"), '0000-00-00', date("Y-m-d"), '0000-00-00'));
 }

$spot = Model::factory('Spots')->filter('url', $this->principal_arguments)->filter('visibles')->find_one();