SELECT count(*) c FROM #Request.prefix_db_agency#.pAssessments an LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients p on an.Patient_Id = p.Patient_Id LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit pa on an.Patient_Id = pa.Patient_Id LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee e on e.Emp_ID = pa.Case_Manager LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ph on e.Emp_ID = ph.Emp_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pCMS4857 pcm on ph.Emp_ID = pcm.Render_Phys_ID WHERE e.Emp_Type = 'Physician' AND ph.Phys_ID = '#docId#' AND ph.loc_id = '#agencyId#' AND an.status = 0 AND p.Status < 2 AND pa.Status = 0 AND ph.Status = 0 AND pcm.Status = 0 AND pcm.Date_Received BETWEEN DATE_SUB(NOW(), INTERVAL 90 DAY) AND NOW() SELECT DateDiff(pcm.Date_Received, pcm.date_sent) d FROM #Request.prefix_db_agency#.pAssessments an LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients p on an.Patient_Id = p.Patient_Id LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit pa on an.Patient_Id = pa.Patient_Id LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee e on e.Emp_ID = pa.Case_Manager LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ph on e.Emp_ID = ph.Emp_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pCMS4857 pcm on ph.Emp_ID = pcm.Render_Phys_ID WHERE ph.Phys_ID = '#docId#' AND e.emp_type = 'Physician' AND ph.loc_id = '#agencyId#' AND pcm.Date_Received BETWEEN DATE_SUB(NOW(), INTERVAL 90 DAY) AND NOW() AND an.status = 0 AND p.Status < 2 AND pa.Status = 0 AND ph.Status = 0 SELECT count(*) c FROM #Request.prefix_db_agency#.pAssessments an LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients p on an.Patient_Id = p.Patient_Id LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit pa on an.Patient_Id = pa.Patient_Id LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee e on e.Emp_ID = pa.Case_Manager LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ph on e.Emp_ID = ph.Emp_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pCMS4857 pcm on ph.Emp_ID = pcm.Render_Phys_ID WHERE ph.Phys_ID = '#docId#' AND e.emp_type = 'Physician' AND ph.loc_id = '#agencyId#' AND pcm.Date_Received BETWEEN DATE_SUB(NOW(), INTERVAL 90 DAY) AND NOW() AND an.status = 0 AND p.Status < 2 AND pa.Status = 0 AND ph.Status = 0 SELECT DateDiff(pcm.Date_Received, pcm.date_sent) d FROM #Request.prefix_db_agency#.pAssessments an LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients p on an.Patient_Id = p.Patient_Id LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit pa on an.Patient_Id = pa.Patient_Id LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee e on e.Emp_ID = pa.Case_Manager LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ph on e.Emp_ID = ph.Emp_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pCMS4857 pcm on ph.Emp_ID = pcm.Render_Phys_ID WHERE ph.Phys_ID = '#docId#' AND e.emp_type = 'Physician' AND ph.loc_id = '#agencyId#' AND pcm.Date_Received BETWEEN DATE_SUB(NOW(), INTERVAL 90 DAY) AND NOW() AND an.status = 0 AND p.Status < 2 AND pa.Status = 0 AND ph.Status = 0 SELECT DateDiff(pcm.Date_Received, pcm.date_sent) d FROM #Request.prefix_db_agency#.pAssessments an LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients p on an.Patient_Id = p.Patient_Id LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit pa on an.Patient_Id = pa.Patient_Id LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee e on e.Emp_ID = pa.Case_Manager LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ph on e.Emp_ID = ph.Emp_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pCMS4857 pcm on ph.Emp_ID = pcm.Render_Phys_ID WHERE ph.Phys_ID = '#docId#' AND e.emp_type = 'Physician' AND ph.loc_id = '#agencyId#' AND pcm.Date_Received BETWEEN DATE_SUB(NOW(), INTERVAL 90 DAY) AND NOW() AND an.status = 0 AND p.Status < 2 AND pa.Status = 0 AND ph.Status = 0