User talk:Kippersnax

Can anyone help? I have downloaded en 1.5 database tables page, pagelinks and categorylinks. Given a category (e.g. Category:Mathematics) how can I get: 1. The list of 'Subcategories' titles (e.g. Algebra), currently there are 65 according to the math category web page? 2. The list of 'Pages in category "Mathematics"' (e.g. Additional logarithm topics), currently there are 71 according to the math category web page? I am looking for the way to link the tables together via SQL. Thanks very much!Kippersnax 15:58, 4 May 2006 (UTC)