SELECT
    YEAR(so.created_at) AS year_ordered,
    product_type, sku, name, qty_ordered, price, row_total
    FROM `sales_order_grid` AS so
       INNER JOIN `sales_order_item` AS si ON si.order_id=so.entity_id
       AND (so.status != "canceled" ) AND YEAR(so.created_at) = 2018
    ORDER BY si.qty_ordered desc limit 5