[Mediawiki-l] Database query for finding all articles in wiki

Tue Apr 11 15:22:51 UTC 2006

Hello,

I implemented a fulltext search in wiki by using the Lucene classes to index
and search the wiki SQL Tables. At the moment I simply use the following
query to select the articles I want to search in:

"SELECT * FROM cur WHERE cur_namespace=0"

To prevent finding already deleted articles I compare the results with the
results I get using the following query:

"SELECT * FROM archive WHERE ar_title='searchterm'"

where "searchterm" is replaced once by every result I get with the first
query. I use a Java-Application to throw out all results that appear in both
tables.

But for some reason a few articles are not contained in the cur table, but
they are appearing as articles in wiki. These articles can be found in a
third table called "searchindex". I cannot use this table for searching
because its not possible to filter it by namespaces like it is in the cur
table.

To get to the point: My problem is, that I cannot figure out a query that
selects not only all articles with a zero namespace in the cur table, but
also those which are only appearing in the searchindex table. I already
tried the query recommended by the mediawiki database documentation of the
searchindex table, but it cant find these few articles with this query
either.

Greetings
Marcel