execute a request personalized

select count(*) from 
(SELECT distinct `idResource`,`workDate` FROM `work` WHERE `week`=201247) as ww

$Ressource=SqlList::getList('Resource');
foreach($Ressource as $keyresource => $valresource) 
{ 
$crit=array('week'=>$y.''.$week);
$obj=new Work();
$Jours=$obj->countSqlElementsFromCriteria($crit);
}

SELECT count(distinct `idResource`,`workDate`)FROM `work` WHERE `week`=201248

select count(*) as cpt from work where week='201248'