<dtml-comment>
title:
connection_id:erp5_sql_connection
max_rows:1000
max_cache:100
cache_time:0
class_name:ZSQLBrain
class_file:zsqlbrain.py
</dtml-comment>
<params></params>
SELECT
	item.uid, item.Id, item.path, item.Description
FROM
	catalog AS item, category
WHERE
	item.portal_type = "Piece Tissu"
AND
	category.category_uid = item.uid
AND
	category.base_category_uid = <dtml-var "portal_categories.aggregate.uid">

