SELECT
        postdate AS Date,
        i.invoice_id AS Invoice,
        concat(
                c.lastname,
                ", ",
                c.firstname,
                " ",
                c.middlename
        ) AS Customer,
        c.CUSTOMER_TYPE AS Type,
        v.VENDOR_NAME AS Vendor,
        p.Description AS Product,
        ii.quantity AS Qty,
        concat(discount_percent100, '%') AS Discount,
        CONVERT (
                UNDISCOUNTED_PRICE,
                DECIMAL (10, 2)
        ) AS Normally,
        CONVERT (Price, DECIMAL(10, 2)) AS Discounted
FROM
        invoice_items ii
JOIN invoices i ON ii.invoice_id = i.invoice_id
JOIN customers c ON i.customer_id = c.customer_id
JOIN products p ON ii.product_id = p.product_id
JOIN vendors v ON p.VENDOR_ID = v.vendor_id
WHERE
        ii.discount_percent100 > 0
AND i.voidedinvoice = 0
AND i.postdate >= '{STARTDATE}'
AND i.postdate <= '{ENDDATE}'
ORDER BY
        i.postdate;