title:
connection_id:MySQL
max_rows:1000
max_cache:100
cache_time:0
class_name:ZSQLBrain
class_file:zsqlbrain.py
correspondance_id=""
forme_id_list=""
mesure_vetement_list=""
taille_list=""
description=""
etat=""
id_list=""
SELECT DISTINCT vetement.id, vetement.relative_url, vetement.path, vetement.Description, vetement.forme_state
FROM catalog AS vetement
, catalog AS catal1 JOIN category AS cat1 ON catal1.uid=cat1.category_uid
, catalog AS catal2 JOIN category AS cat2 ON catal2.uid=cat2.category_uid
, category AS cat3
, category AS cat4
WHERE vetement.portal_type = "Vetement"
AND ( vetement.id LIKE ""
OR vetement.id LIKE ""
)
AND cat1.uid=vetement.uid
AND cat1.base_category_uid=
AND catal1.portal_type = "Correspondance mesures"
AND ( (catal1.id LIKE "")
OR (catal1.id LIKE "")
)
AND cat2.uid=vetement.uid
AND cat2.base_category_uid=
AND catal2.portal_type = "Forme"
AND ( (catal2.id LIKE "")
OR (catal2.id LIKE "")
)
AND cat3.uid=vetement.uid
AND ( cat3.category_uid=
OR cat3.category_uid=
)
AND cat3.base_category_uid=
AND cat4.uid=vetement.uid
AND ( cat4.category_uid=
OR cat4.category_uid=
)
AND cat4.base_category_uid=
AND vetement.vetement_state LIKE ""
AND vetement.Description LIKE ""