SELECT COUNT(*) --37088
FROM ind_area_tst1.vers_44_contract c
LEFT JOIN ind_area_tst1.vers_organization org ON org.org_id = c.customer_id AND sysdate BETWEEN nvl(org.sys_from_date,DATE'1900-01-01') AND nvl(org.sys_to_date,DATE'2900-01-01')
WHERE sysdate BETWEEN nvl(c.sys_from_date,DATE'1900-01-01') AND nvl(c.sys_to_date,DATE'2900-01-01') --AND c.reestr_number_807pp <>'-'  AND c.reestr_number_807pp IS NOT NULL --prv 20190514 убрал фильтр по пустому reestr_number_807pp
AND org.org_id IS NOT NULL
AND org.is_customer IS NULL
AND org.is_grbs = 0
AND REESTR_NUMBER_807PP = '3773305647015000005';