Histórico da Página

SELECT
BB2_CODIGO AS Codigo,
BB2_VERSAO AS VersaoProd,
ISNULL(BTU.BTU_CODTAB, BTQ.BTQ_CODTAB) AS CodTabela,
ISNULL(BTU.BTU_CDTERM, BTQ.BTQ_CDTERM) AS CodProcedimento,
BB2_BENUTL AS Ativo,
BB2_NIVEL AS NivelProced,
BB2_AUTORI AS TipoAutor,
BB2_CARENC AS Carencia,
BB2_UNCAR AS UnidadeCarencia,
BB2_NIVCAR AS NivelCarencia,
BB2_QTD AS Quantidade,
BB2_UNCA AS UnidadeQuantidade,
BB2_PERIOD AS Periodicidade,
BB2_UNPERI AS UnidadedPeriod,
BB2_QTDESP AS QtdPorEspecialidade,
BB2_QTDMED AS QtdPorRda,
BB2_QTDPAT AS QtdPorPatologia,
BB2_IDAMIN AS IdadeMinima,
BB2_IDAMAX AS IdadeMaxima,
BB2_PTRMED AS PeriodPorRda,
BB2_PTRESP AS PeriodPorEspec,
BB2_PTRPAT AS PeriodPorPatol,
BB2_SEXO AS Sexo,
BB2_CDNV01 AS ChaveProcedNv1,
BB2_CDNV02 AS ChaveProcedNv2,
BB2_CDNV03 AS ChaveProcedNv3,
BB2_CDNV04 AS ChaveProcedNv4,
BB2_CLACAR AS CodClassCarenc
FROM BB2010 BB2
LEFT JOIN BTU010 BTU ON (BTU.BTU_VLRBUS  -  BB2_CODPSA AND BTU.D_E_L_E_T_  -  ' ')
LEFT JOIN BTQ010 BTQ ON (BTQ.BTQ_CDTERM  -  BB2_CODPSA AND BTQ.D_E_L_E_T_  -  ' ')
WHERE BB2.S_T_A_M_P_ > (DATEADD(HOUR, -1, GETUTCDATE()))
AND BB2.D_E_L_E_T_  -  ' '
AND (BTQ_CODTAB IS NULL OR BTQ_CODTAB IN ('18', '19', '20', '22', '90', '98'))
AND (BTU_CODTAB IS NULL OR BTU_CODTAB IN ('18', '19', '20', '22', '90', '98'))
AND ((BTU_CODTAB IS NOT NULL AND BTU_CDTERM IS NOT NULL) OR (BTQ_CODTAB IS NOT NULL AND BTQ_CDTERM IS NOT NULL))