SELECT *, pages.pageID as pageID from pagesContent, pages LEFT JOIN pageParentXref ON pages.pageID = pageParentXref.pageID WHERE pages.pageID = 125 AND pages.pageID = pagesContent.pageID AND pagesContent.liveStatus = 'live' LIMIT 1
Number of Records: 1
SELECT * from pageParentXref, pages WHERE pageParentXref.parentID > 0 AND pageParentXref.parentID <= 5 AND pages.pageID != pageParentXref.parentID AND pageParentXref.pageID = pages.pageID AND pages.pageID IN (SELECT pageID FROM pagesContent WHERE liveStatus = 'live') ORDER BY pageParentXref.parentID, pageParentXref.sequence
Number of Records: 21