I guess you need something like [code]SELECT parent.* FROM [mgnl:contentNode] AS parent INNER JOIN [mgnl:resource] AS child ON ISCHILDNODE(child,parent) WHERE child.[fileName] LIKE '%_EN'[/code]
-- Context is everything: http://forum.magnolia-cms.com/forum/thread.html?threadId=a0afe0e3-555e-4b7b-8dc4-dd14588046c7 ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
