title: connection_id:erp5_sql_connection max_rows:1000 max_cache:100 cache_time:0 class_name:ZSQLBrain class_file:zsqlbrain.py tissu1 tissu2 SELECT DISTINCT catalog.id, catalog.uid, catalog.path, catalog.relative_url, catalog.parent_uid, catalog.Description FROM catalog, catalog AS vgamme, catalog AS vtissu, category WHERE vgamme.parent_uid=catalog.uid AND vtissu.uid=category.category_uid AND vtissu.relative_url LIKE "%%" AND vgamme.uid=category.uid AND catalog.portal_type="Gamme"