okay, code formatting removed everything after the colon (:), so again

SELECT parent.* 
FROM [mgnl:contentNode] AS parent
INNER JOIN [mgnl:resource] AS child ON ISCHILDNODE(child,parent)
WHERE child.[fileName] LIKE '%_EN'

-- 
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]>
----------------------------------------------------------------

Reply via email to