Запросы у меня создаются примерно такие WHERE (
( modResource
.deleted
= 0 AND modResource
.hidemenu
= 0 AND modResource
.published
= 1 )
AND modResource
.parent
IN (156,178,179,180,181,182,183,184,185,186,187,188,189,190,191)
AND (
( TemplateVar
.name
= 'shape' AND TVResources
.value
= 'rectangle' ) AND ( TemplateVar
.name
= 'processing_edge' AND TVResources
.value
= '10' )
)
) или WHERE (
( modResource
.deleted
= 0 AND modResource
.hidemenu
= 0 AND modResource
.published
= 1 )
AND modResource
.parent
IN (156,178,179,180,181,182,183,184,185,186,187,188,189,190,191)
AND ( TemplateVar
.name
= 'shape' AND TVResources
.value
= 'rectangle' ) AND ( TemplateVar
.name
= 'processing_edge' AND TVResources
.value
= '10' )
) Каждое поле по отдельности, но не как не вместе