SELECT s.SPACENAME, s.SPACEKEY, s.SPACEID, c.TITLE, c.CONTENTID
FROM   CONTENT c,
       SPACES s
WHERE  c.CONTENTTYPE = 'PAGE'
       AND ( ( c.PREVVER IS NULL )
             AND ( c.CONTENT_STATUS = 'current' )
             AND ( Lower(s.SPACEKEY) IN (SELECT Lower(SPACEKEY) FROM SPACES)
                   AND c.SPACEID = s.SPACEID )
             AND ( ( s.HOMEPAGE != c.CONTENTID
                     AND c.SPACEID = s.SPACEID )
                    OR ( s.HOMEPAGE IS NULL
                         AND c.SPACEID = s.SPACEID ) )
             AND ( c.PARENTID IS NULL )
             AND ( NOT EXISTS(SELECT l.LINKID
                              FROM   LINKS l,
                                     SPACES s2,
                                     CONTENT c2
                              WHERE  (
                             l.DESTSPACEKEY = s2.SPACEKEY
                             AND
                             c.SPACEID = s2.SPACEID )
                                     AND
                             ( Lower(l.DESTPAGETITLE) =
                               Lower(c.TITLE) )
                                     AND ( Lower(c2.TITLE) !=
                                           Lower(c.TITLE)
                                           AND l.CONTENTID =
                                               c2.CONTENTID )) ) );