Untitled

SELECT 
    factura.fecha, factura.numero, timbrado.numero as timbrado, persona.ruc, persona.nombre_completo,
    CAST(factura.iva_cinco AS INT), CAST(factura.iva_diez AS INT), CAST(factura.exentas AS INT),
    CAST(factura.total AS INT), factura.origen, factura.libro, transaccion.asiento,
    factura.momento
FROM 
    factura 
JOIN 
    persona ON persona.id = factura.emisor_id
JOIN 
    timbrado ON timbrado.id = factura.timbrado_id
LEFT JOIN 
    transaccion ON transaccion.id = factura.transaccion_id
WHERE 
    factura.fecha BETWEEN '2024-02-01' AND '2024-02-29'
    AND factura.libro = 'C'
    AND factura.anulado != True
    AND timbrado.numero != '11111111'
    AND (factura.origen = 'V' OR factura.origen = 'E')
ORDER BY 
    factura.fecha ASC;