Сроки регистрации

SELECT
a.NO "КУВД"
,cj.S_DATE "ДатаВыдачи"
,a.R_DATE "ДатаЗаяв"
,(cj.S_DATE-a.R_DATE) "ДнейРег"
,r.REG_NO "регно"
,(SELECT apv.NAME FROM APP_REGPERIOD_VOC apv WHERE code=a.reg_period)  "Период"
FROM
CRT_CERTIFICATES cc
,RT_RIGHTS r
,APP_RT apr
,APP_APPLICATIONS a
,CRT_JOURNAL cj

WHERE
cc.RT_ID=r.ID
AND cc.CRT_JNL_ID=cj.ID
AND apr.RT_ID=r.ID
AND apr.APP_ID=a.ID
AND cj.S_DATE-a.R_DATE <6
AND a.R_DATE >'01.01.2010'
AND a.REG_PERIOD<>1005