title:
connection_id:MySQL
max_rows:1000
max_cache:100
cache_time:0
class_name:ZSQLBrain
class_file:zsqlbrain.py
collection_list=""
description=""
eip_list=""
etat=""
forme_id_list=""
id_list=""
option_forme_list=""
present_au_catalogue=""
referentiel_forme_list=""
SELECT DISTINCT forme.id, forme.relative_url, forme.path, forme.Description, forme.forme_state
FROM catalog AS forme
, category AS cat1
, category AS cat2
, category AS cat3
, category AS cat4
, category AS cat5
JOIN catalog ON catalog.uid=cat5.category_uid
WHERE forme.portal_type = "Forme"
AND ( forme.id LIKE ""
OR forme.id LIKE ""
)
AND cat1.uid=forme.uid
AND ( cat1.category_uid=
OR cat1.category_uid=
)
AND cat1.base_category_uid=
AND cat2.uid=forme.uid
AND ( cat2.category_uid=
OR cat2.category_uid=
)
AND cat2.base_category_uid=
AND cat3.uid=forme.uid
AND ( cat3.category_uid=
OR cat3.category_uid=
)
AND cat3.base_category_uid=
AND cat4.uid=forme.uid
AND ( cat4.category_uid=
OR cat4.category_uid=
)
AND cat4.base_category_uid=
AND cat5.uid=forme.uid
AND cat5.base_category_uid=
AND ( (catalog.id LIKE "")
OR (catalog.id LIKE "")
)
AND forme.forme_state LIKE ""
AND forme.Description LIKE ""