How to find a links/contents by given a top level site from content table in Ektron database?

I need to produce a custom google sitemap by gievn language (1033) and top site name (www.mycompany.com), I can find the content record for the top site for that language, can someone shed some light on how can i find all pages recursively under this top site using SQL query?

Thank you so much!

John

#176400 Mar 17, 2017 17:50