<!-- Order Lines  -->
SELECT
 sales_order.increment_id AS "Order Number",
 e.item_id AS "Item Number",
 e.sku AS "Product Code",
 IF(e.qty_canceled > 0, 'cancelled', 'shippep') AS "Item Status",
 IF(e.qty_canceled > 0, e.updated_at, '') AS "Cancelled / Returned date",
 IF(e.qty_canceled > 0, '0', e.qty_ordered) AS "Number of Items sold",
 e.qty_canceled AS "Number of Items Returned / Cancelled",
 e.base_row_total AS "Net Value",
 e.base_tax_amount AS "VAT Value",
 e.discount_amount AS "Net Discount Value",
 ROUND((sales_order.base_shipping_amount/1.15),2) AS "NET P&P Value",
 sales_order.base_shipping_amount AS "P&P VAT"
FROM sales_flat_order_item  AS e
RIGHT JOIN sales_order ON sales_order.entity_id = e.order_id
ORDER BY sales_order.increment_id DESC