Ris

<?php
 
class onYourcontrollerContentListFilter extends cmsAction {
 
    public function run($model){
 
	if(strpos($_SERVER['REQUEST_URI'], 'yuor_dataset') !== false){
 
	$model[1]->filterGt('date_pub', date('Y-m-d', time()));
 
	}
 
     return $model;   
 
    }
 
}

SELECT i.*, u.nickname AS `user_nickname`, u.avatar AS `user_avatar`, u.groups AS `user_groups`, f.title AS `folder_title`
FROM cms_con_news i
FORCE INDEX FOR ORDER BY (dataset_curdate)
FORCE INDEX (date_pub)
INNER JOIN cms_users AS u ON u.id = i.user_id
LEFT JOIN cms_content_folders AS f ON f.id = i.folder_id
WHERE (i.date_pub > 'CURDATE()') AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1') AND (i.is_parent_hidden IS NULL)
ORDER BY i.date_pub DESC
LIMIT 0, 15