ROLAS LOUCAS

SELECT
    red.store_key 'Loja',
    red.pos_number 'Nº PDV',
    red.ecf_serial 'Nº de Série',
    MIN(red.quantity_left_z) 'Quant Reduções Restantes',
    ecf.ecf_number,
    ecf.ecf_status
FROM
    fiscal_status red, ecf ecf
WHERE
    red.fiscal_date < date_sub(now(), INTERVAL 1 DAY)
        AND red.quantity_left_z <= 500
        AND red.quantity_left_z IS NOT NULL
        AND red.quantity_left_z != 0

        AND red.ecf_serial = ecf.ecf_serial
        AND ecf.ecf_status = 0

GROUP BY red.store_key , red.pos_number , red.ecf_serial
ORDER BY red.store_key;