SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='0')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='71')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='59')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='63')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='60')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='68')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='67')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='70')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='66')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='64')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='69')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='1')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='61')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='74')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='12')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='13')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='20')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='26')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='22')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='14')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='28')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='32')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='30')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='16')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='37')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='36')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='34')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='17')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='18')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='38')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='39')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='40')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='19')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='47')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='46')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='45')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='21')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='49')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='50')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='48')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='58')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='62')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='56')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='57')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='23')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='24')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='51')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='43')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='53')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='25')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='65')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='35')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='33')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='27')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='41')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='42')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='54')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='73')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='72')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='55')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='7')
ORDER BY p.ordering, c.title
SELECT p.*, c.*
FROM bones_pages AS p
LEFT JOIN ( SELECT pageId, title, navTitle FROM bones_page_contents WHERE language='en' AND active>0 AND deleted<1 ) AS c ON c.pageId = p.id
WHERE p.active>0 AND p.deleted<1 AND (p.parentId='8')
ORDER BY p.ordering, c.title