{sql-query:dataSource=ConfluenceDS|output=wiki}
select concat("[",title,"|http://www.schirmacher.de/pages/viewpage.action?pageId=",contentid,"]") as Page,contentid,contenttype,version,content_status,spaceid  from CONTENT where spaceid is not null and contenttype='PAGE' order by contentid
{sql-query}

x