<dtml-comment>
title:
connection_id:erp5_sql_connection
max_rows:1000
max_cache:100
cache_time:10
class_name:
class_file:
</dtml-comment>
<params>uid</params>
SELECT
  SUM(movement.quantity) AS quantity,
  SUM(movement.target_quantity) AS target_quantity
FROM
  category, movement
WHERE
  category.category_uid = <dtml-sqlvar uid type="int">
AND
  category.uid = movement.uid
AND
  category.base_category_uid = <dtml-sqlvar expr="portal_categories.delivery.getUid()" type="int">