title:
connection_id:erp5_sql_connection
max_rows:1000
max_cache:100
cache_time:0
class_name:ZSQLBrain
class_file:zsqlbrain.py
supplier_title_list=""
SELECT DISTINCT resource.id, resource.title, resource.relative_url, resource.path
FROM catalog AS resource, catalog as organisation, category
WHERE resource.uid = category.uid
AND organisation.uid = category.category_uid
AND category.base_category_uid=
AND ( resource.portal_type = 'Tissu'
OR resource.portal_type = 'Composant')
AND ( organisation.title = ""
OR organisation.title = ""
)