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

Popular posts from this blog

java - SNMP4J General Variable Binding Error -

windows - Python Service Installation - "Could not find PythonClass entry" -

Determine if a XmlNode is empty or null in C#? -