title:
connection_id:erp5_sql_connection
max_rows:1000
max_cache:100
cache_time:0
class_name:ZSQLBrain
class_file:zsqlbrain.py
modele_id_list=""
forme_id_list=""
gamme_id_list=""
collection_list=""
eip_list=""
marque_list=""
modele_origine_list=""
SELECT DISTINCT modele.id, modele.relative_url, modele.path, modele.Description, modele.modele_state, modele.default_destination_title
FROM catalog AS modele
, category AS cat1
, category AS cat2
, category AS cat3
, category AS cat4
WHERE modele.portal_type = "Modele"
AND ( modele.id LIKE ""
OR modele.id LIKE ""
)
AND ( modele.forme_id LIKE ""
OR modele.forme_id LIKE ""
)
AND ( modele.gamme_id LIKE ""
OR modele.gamme_id LIKE ""
)
AND cat1.uid=modele.uid
AND ( cat1.category_uid=
OR cat1.category_uid=
)
AND cat1.base_category_uid=
AND cat2.uid=modele.uid
AND ( cat2.category_uid=
OR cat2.category_uid=
)
AND cat2.base_category_uid=
AND cat3.uid=modele.uid
AND ( cat3.category_uid=
OR cat3.category_uid=
)
AND cat3.base_category_uid=
AND cat4.uid=modele.uid
AND ( cat4.category_uid=
AND ( cat4.category_uid <> 0
OR cat4.category_uid=
)
AND cat4.base_category_uid=