SELECT
    SB1.B1_FILIAL, SB1.B1_COD, SB1.B1_DESC, SB1.B1_TIPO, SB1.B1_UM, SB1.B1_SEGUM, SB1.B1_GRUPO, SB1.B1_CONV, SB1.B1_TIPCONV, SB1.B1_PRV1,
    SB1.B1_PESO, SB1.B1_CODBAR, SB1.B1_QE, SB1.B1_MSBLQL, SB1.D_E_L_E_T_, SB1.R_E_C_N_O_, SB1.MD5, SB1.DATA_UPDATE,
        (SELECT BM_DESC FROM PADRAO.PORTAL_SBM001 WHERE BM_GRUPO = SB1.B1_GRUPO   LIMIT 0,1) as B1_GRUPO_DESCRICAO,
    (SUM(IFNULL(SB2.B2_QATU, 0)) - SUM(IFNULL(SB2.B2_RESERVA, 0)) - SUM(IFNULL(SB2.B2_QPEDVEN, 0))) - SUM(IFNULL(SC6.C6_QTDVEN, 0)) AS B2_ESTOQUE
    FROM PADRAO.PORTAL_SB1001 SB1
    LEFT JOIN PADRAO.PORTAL_SB2001 SB2
    ON SB1.B1_COD = SB2.B2_COD
    LEFT JOIN PADRAO.PORTAL_SC6001_NEW SC6
    ON SB1.B1_COD = SC6.C6_PRODUTO
AND (SC6.C6_NUM IS NULL OR SC6.C6_NUM = '')
    AND SB2.B2_LOCAL IN ('07','08')
    WHERE (SB1.D_E_L_E_T_ IS NULL OR SB1.D_E_L_E_T_ = '')
    AND (SB2.D_E_L_E_T_ IS NULL OR SB2.D_E_L_E_T_ = '')
    AND (SC6.D_E_L_E_T_ IS NULL OR SC6.D_E_L_E_T_ = '')
    AND (SB1.B1_MSBLQL IS NULL OR SB1.B1_MSBLQL <> '1')
    GROUP BY SB1.B1_COD;