select
    left(title,40) as "page or file",
    version,
    content.creationdate,
    content.lastmoddate,
    pageid,
    spaces.spacename
from
    content,
    spaces
where
    content.spaceid = spaces.spaceid and 
    content.spaceid is not null and 
    spaces.spacename != 'Arne Schirmacher' and 
    spaces.spacename != 'Trash' and 
    spaces.spacename != 'Archiv' and 
    (
        spaces.spacename = 'Confluence' or
        spaces.spacename = 'JIRA' or
    )
order by 
    lastmoddate,
    version;

  • No labels