SELECT p.product_name, SUM(ol.quantity) AS total_quantity_sold FROM products p INNER JOIN orderlines ol ON p.product_id = ol.product_id GROUP BY p.product_name ORDER BY total_quantity_sold DESC LIMIT 10;