Encontrando todas as paginas de um web content

Encontrando todas as paginas em que um determinado web content é exibido
Find all pages where an specified web content is showed

select pp.portletid, l.groupid, l.friendlyurl, l.typesettings 
from portletpreferences pp join layout l 
using (plid) 
where pp.portletid like '56_INSTANCE%' 
and xmltype(pp.preferences).extract('/portlet-preferences/preference[name="articleId"]/value/text()').getStringVal() = YOUR_WEBCONTENT_ID  
and l.typesettings like '%' || pp.portletid || '%' 
order by l.groupid

(SQL for Oracle)