SELECT
BR8_BENUTL AS Ativo, 
BR8_AUTORI AS Autorizacao, 
BR8_CARENC AS Carencia, 
BR8_CLACAR AS ClasseCarencia, 
ISNULL(BTU.BTU_CODTAB, BTQ.BTQ_CODTAB) AS CodTabela,
ISNULL(BTU.BTU_CDTERM, BTQ.BTQ_CDTERM) AS CodProcedimento,
REPLACE(REPLACE(BR8_DESCRI,CHAR(13) + Char(10) ,' '), CHAR(10), ' ') AS DescricaoTabelaPadrao,
BR8_CLASSE AS ClasseProced, 
BR8_SEXO AS Genero, 
BR8_IDAMAX AS IdadeMaxima, 
BR8_IDAMIN AS IdadeMinima, 
BR8_NIVEL AS Nivel, 
BR8_PERIOD AS Periodo, 
BR8_PTRESP AS PeriodoPorEspecialidade, 
BR8_PTRPAT AS PeriodoPorPatologia, 
BR8_PTRMED AS PeriodoPorPrestador, 
BR8_QTD AS QuantidadePermitida, 
BR8_QTDESP AS QuantidadePorEspecialidade, 
BR8_QTDPAT AS QuantidadePorPatologia, 
BR8_QTDMED AS QuantidadePorPrestador, 
BR8_TPPROC AS TipoProcedimento, 
BR8_UNCAR AS UnidadeCarencia, 
BR8_UNPERI AS UnidadePeriodo, 
BR8_UNCA AS UnidadeQuantidade,
BR8_TPCONS AS ProcedConsulta,
BR8_ODONTO AS Odontologico,
BR8_TRRGSL AS TratRegraSol
FROM BR8010 BR8 
LEFT JOIN BTU010 BTU ON (BTU.BTU_VLRBUS = BR8_CODPSA AND BTU.D_E_L_E_T_ = ' ')
LEFT JOIN BTQ010 BTQ ON (BTQ.BTQ_CDTERM = BR8_CODPSA AND BTQ.D_E_L_E_T_ = ' ')
WHERE 
BR8.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))
AND BR8.S_T_A_M_P_ > (DATEADD(HOUR, -1, GETUTCDATE()))