On Fri, Sep 16, 2011 at 1:33 AM, priyank bagrecha <[email protected]> wrote: > Hi > > I am trying to pull up a list of pageids from the snapshot, which belong to > a specific category. Basically I am trying to pull up pages which are on > book portal pages. I looked at the snapshot mysql db to see which tables i > can use. but the fields of tables category and category_links didnt make any > sense to me in regard to what they stand for. so i was wondering if somebody > could help me with the sql. > categorylinks is fairly simple.
cl_to is the name of a category cl_from is the ID of a page. This refers to page_id in the page table, where you can find the page name (by combining page_namespace and page_title) The other fields are various things you probably don't need Roan Kattouw (Catrope) _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
