On Apr 9, 2005 9:09 AM, FxParlant <f-x.p(a)laposte.net> wrote: François, I'm not certain I fully understand what you want to do. However, I'll give some information that I hope will help. If you need more, please let me know. In the categoryLinks table: cl_from is the id of the article where the [[category:foo]] entry appears. cl_to is the _title_ of the category page (in this example, "foo". The "category:" prefix is assumed). Note that since there can be multiple category entries on any page, the cl_from field is not unique. Note that cl_to is stored as a title instead of as an id because it is possible to add [[category:bar]] to a page when there is no category page named "bar". The combination of (cl_from, cl_to) should be unique. Multiple instances of the same category entry in an article are only entered into categoryLinks once. I hope this helps! --Rich Holton [[W:en:User:Rholton]]

Ok. First you'll need to create the new table. Something like: CREATE TABLE foo ( foo_from int unsigned NOT NULL default 0, foo_to int unsigned NOT NULL default 0, UNIQUE KEY foo_from (foo_from ,foo_to), KEY (foo_to) ); Then, fill in the new table from what already exists in CategoryLinks and Cur INSERT INTO foo (foo_from, foo_to) SELECT cl_from, cur_id FROM categoryLinks, cur WHERE cur_namespace=14 AND cur_title = cl_to This (in effect) takes each record in the categoryLinks table and finds the matching record in cur based on a match between cur_title and cl_to. If the resulting record in cur is also from namespace 14, then it takes the cl_from in categoryLinks and the cur_id from cur and writes those as a record to the new "foo" database.

Hi, The problem I'm facing, is that I must have in a first query, the pages with their different namespaces(0 or 14) and titles, and in a second one, the links between them. As you all know, some links are in the "links" table, and some other are in the "categgorylinks" (or am I mistaken). The problem is that I MUST NOT (unless I want my engine to die) have links from pages who are not mentioned in the first query. Unfortunately most of the links in "categorylinks", as mentioned by Richard, are not yet created in the cur table. Furthermore, it is also very difficult to restrict the pair of links from the "links" table, to be BOTH with namespace=0 or namespace=14. Nevertheless here is the "result" I could manage, only with the category pages of my site. http://www.fxparlant.net/Special:Touchgraph (there must be a mistake in the html because the applet fails in Firefox... but works in IE)...just move the first node Thanks to Jamie and Richard, for their support ... I'm off to bed :D See you all tomorrow François Jamie Bliss wrote: _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l