Re: [Phpwiki-talk] SQL brain teaser

[Reini U. <ru...@xa...>]

On Sat, 22 Sep 2001, Gary Benson wrote:
>    select topage from $WikiLinksStore
>             left join $WikiPageStore on topage=pagename
>     where frompage!='$RecentChanges'
>       and frompage!='$TextFormattingRules'
>       and pagename is NULL
>     group by topage
>     order by topage

Seems to be something like my http://xarch.tu-graz.ac.at/acadwiki/WantedPages
all pages where there are links to but the page itself is missing.

I have the OrphansPages counterpart also. Also MySql only.