mysql - Omitting Wikipedia maintenance categories from sql query -
i retrieving list of categories given page_title, results include categories such as:
"all_articles_to_be_split"
"articles_with_unsourced_statements_from_july_2008"
"all_articles_with_specifically-marked_weasel-worded_phrases"
...etc...i wish omit these types of categories maintenance.
here example sql call making:
select categorylinks.cl_to categorylinks join page on categorylinks.cl_from = page.page_id , page.page_namespace = 0 , page.page_title = "ice_hockey";
what missing in query omit maintenance categories? or have manually parse these out of results? thanks.
i did manually this:
select categorylinks.cl_to categorylinks join page on categorylinks.cl_from = page.page_id , page.page_namespace = 0 , cl_to not '%article%' , cl_to not '%article%' , cl_to not '%wikipedia%' , cl_to not '%redirect%' , cl_to not '%page%' , cl_to not '%redirect%' , page.page_title = "ice_hockey";
Comments
Post a Comment