SELECT
SUM(movement.quantity) AS inventory,
SUM(movement.quantity) AS total_quantity,
SUM(movement.price * movement.quantity) AS total_price,
AVG(movement.price) AS average_price
FROM
AS ,
WHERE
1=1
AND
AND movement.has_cell_content = 0
AND catalog.portal_type <> "Container"
AND catalog.portal_type <> "Simulation Movement"
ORDER BY