SELECT
(s.docref).SEQUENCE AS fabric_sequence,
(a.docref).SEQUENCE AS article_sequence,
(a.docref).title AS article_title,
s.mat_no_supplier AS mat_no_supplier,
s.mat_description_supplier AS mat_description_supplier,
(a.stakeholder_stakeholders_supplier_docref).title AS supplier,
s.bestand_unit AS stock_quantity,
s.beschaffung AS automatic_purchase,
s.sicherheitsbestand_unit AS safety_stock,
(
      SELECT SUM(unit*1.8)
      FROM c13340_orderrecords  AS o
      WHERE CURRENT AND NOT deleted
      AND (s.article_articles_docref).SEQUENCE = (o.article_articles_docref).SEQUENCE
      AND (order_orders_docref).SEQUENCE IN (
          SELECT (docref).SEQUENCE FROM c13340_orders
          WHERE CURRENT AND NOT deleted
          AND DATE >= '2017-07-19' AND DATE <= '2017-10-19')
      GROUP BY (o.article_articles_docref).SEQUENCE,(o.article_articles_docref).title
) AS material_used
FROM purchase_stocks_13340 AS s
INNER JOIN purchase_articles AS a
ON (s.purchase_articles_docref).SEQUENCE = (a.docref).SEQUENCE
WHERE a.CURRENT AND NOT a.deleted
AND s.CURRENT AND NOT s.deleted
ORDER BY material_used DESC