Procedure of creating the subset of DBpedia 3.9 within the mobile phone domain

* Download dumps from http://dbpedia.org (Release 3.9):

article_categories_en.nt
category_labels_en.nt
disambiguations_en.nt
external_links_en.nt
homepages_en.nt
instance_types_en.nt
labels_en.nt
long_abstracts_en.nt
mappingbased_properties_en.nt
page_ids_en.nt
persondata_en.nt
raw_infobox_properties_en.nt
redirects_en.nt
revision_ids_en.nt
short_abstracts_en.nt
skos_categories_en.nt
specific_mappingbased_properties_en.nt

* Load into TripleStore.

* Take Category:Mobile_phones with all direct subcategories and subcategories of these subcategories (2 recursion steps). From these categories take all articles which are categorized in these categories (made unique).

------------------------------------------------
Subcategories of Category:Mobile_phones Level 1:
------------------------------------------------
SPARQL-Query:

SELECT ?s
FROM <http://dbpedia39.org>
WHERE {
 ?s <http://www.w3.org/2004/02/skos/core#broader> <http://dbpedia.org/resource/Category:Mobile_phones> .
}

Result set:

"http://dbpedia.org/resource/Category:History_of_mobile_phones"
"http://dbpedia.org/resource/Category:Videotelephony"
"http://dbpedia.org/resource/Category:Mobile_phone_culture"
"http://dbpedia.org/resource/Category:Mobile_phone_standards"
"http://dbpedia.org/resource/Category:QWERTY_mobile_phones"
"http://dbpedia.org/resource/Category:Mobile_phone_companies"
"http://dbpedia.org/resource/Category:Mobile_phones_by_company"
"http://dbpedia.org/resource/Category:Satellite_telephony"
"http://dbpedia.org/resource/Category:Mobile_software"
"http://dbpedia.org/resource/Category:Open-source_mobile_phones"
"http://dbpedia.org/resource/Category:Mobile_phone_recycling"
"http://dbpedia.org/resource/Category:Smartphones"
"http://dbpedia.org/resource/Category:Touchscreen_mobile_phones"
"http://dbpedia.org/resource/Category:Watch_phones"
"http://dbpedia.org/resource/Category:Mobile_device_management"
"http://dbpedia.org/resource/Category:Mobile_phones_with_stereo_camera"
"http://dbpedia.org/resource/Category:Mobile_phone_industry_by_country"
"http://dbpedia.org/resource/Category:Solar_powered_mobile_phones"


------------------------------------------------
Subcategories of Category:Mobile_phones Level 2:
------------------------------------------------
SPARQL-Query:

SELECT ?s
FROM <http://dbpedia39.org>
WHERE {
 ?s <http://www.w3.org/2004/02/skos/core#broader> ?o.
FILTER (regex(str(?o), "http://dbpedia.org/resource/Category:History_of_mobile_phones")  || regex(str(?o), "http://dbpedia.org/resource/Category:Videotelephony")  || regex(str(?o), "http://dbpedia.org/resource/Category:Mobile_phone_culture")  || regex(str(?o), "http://dbpedia.org/resource/Category:Mobile_phone_standards")  || regex(str(?o), "http://dbpedia.org/resource/Category:QWERTY_mobile_phones")  || regex(str(?o), "http://dbpedia.org/resource/Category:Mobile_phone_companies")  || regex(str(?o), "http://dbpedia.org/resource/Category:Mobile_phones_by_company")  || regex(str(?o), "http://dbpedia.org/resource/Category:Satellite_telephony")  || regex(str(?o), "http://dbpedia.org/resource/Category:Mobile_software")  || regex(str(?o), "http://dbpedia.org/resource/Category:Open-source_mobile_phones")  || regex(str(?o), "http://dbpedia.org/resource/Category:Mobile_phone_recycling")  || regex(str(?o), "http://dbpedia.org/resource/Category:Smartphones")  || regex(str(?o), "http://dbpedia.org/resource/Category:Touchscreen_mobile_phones")  || regex(str(?o), "http://dbpedia.org/resource/Category:Watch_phones")  || regex(str(?o), "http://dbpedia.org/resource/Category:Mobile_device_management")  || regex(str(?o), "http://dbpedia.org/resource/Category:Mobile_phones_with_stereo_camera")  || regex(str(?o), "http://dbpedia.org/resource/Category:Mobile_phone_industry_by_country")  || regex(str(?o), "http://dbpedia.org/resource/Category:Solar_powered_mobile_phones"))
}

Result set:

"http://dbpedia.org/resource/Category:Defunct_mobile_phone_companies"
"http://dbpedia.org/resource/Category:Bankrupt_mobile_phone_companies"
"http://dbpedia.org/resource/Category:Fictional_televisual_devices"
"http://dbpedia.org/resource/Category:Mobile_phones"
"http://dbpedia.org/resource/Category:Telepresence"
"http://dbpedia.org/resource/Category:Webcams"
"http://dbpedia.org/resource/Category:Palm_OS_devices"
"http://dbpedia.org/resource/Category:Motorola_mobile_phones"
"http://dbpedia.org/resource/Category:Samsung_mobile_phones"
"http://dbpedia.org/resource/Category:Sharp_Corporation_mobile_phones"
"http://dbpedia.org/resource/Category:NEC_mobile_phones"
"http://dbpedia.org/resource/Category:Handspring_mobile_phones"
"http://dbpedia.org/resource/Category:Kyocera_mobile_phones"
"http://dbpedia.org/resource/Category:Siemens_mobile_phones"
"http://dbpedia.org/resource/Category:Sendo_mobile_phones"
"http://dbpedia.org/resource/Category:First_International_Computer_mobile_phones"
"http://dbpedia.org/resource/Category:Sierra_Wireless_mobile_phones"
"http://dbpedia.org/resource/Category:Intel_Corporation_mobile_phones"
"http://dbpedia.org/resource/Category:Sony_Ericsson_mobile_phones"
"http://dbpedia.org/resource/Category:INQ_mobile_phones"
"http://dbpedia.org/resource/Category:BlackBerry_(company)_mobile_phones"
"http://dbpedia.org/resource/Category:Alcatel_mobile_phones"
"http://dbpedia.org/resource/Category:Group_Sense_PDA_mobile_phones"
"http://dbpedia.org/resource/Category:Sanyo_mobile_phones"
"http://dbpedia.org/resource/Category:Dell_mobile_phones"
"http://dbpedia.org/resource/Category:Toshiba_mobile_phones"
"http://dbpedia.org/resource/Category:Asus_mobile_phones"
"http://dbpedia.org/resource/Category:Haier_mobile_phones"
"http://dbpedia.org/resource/Category:Hyundai_mobile_phones"
"http://dbpedia.org/resource/Category:Acer_mobile_phones"
"http://dbpedia.org/resource/Category:Orange_mobile_phones"
"http://dbpedia.org/resource/Category:ZTE_mobile_phones"
"http://dbpedia.org/resource/Category:Nokia_mobile_phones"
"http://dbpedia.org/resource/Category:Apple_Inc._mobile_phones"
"http://dbpedia.org/resource/Category:IBM_mobile_phones"
"http://dbpedia.org/resource/Category:Safran_mobile_phones"
"http://dbpedia.org/resource/Category:HTC_Corporation_mobile_phones"
"http://dbpedia.org/resource/Category:Palm_mobile_phones"
"http://dbpedia.org/resource/Category:Hitachi_mobile_phones"
"http://dbpedia.org/resource/Category:Garmin_mobile_phones"
"http://dbpedia.org/resource/Category:BenQ_mobile_phones"
"http://dbpedia.org/resource/Category:LG_Electronics_mobile_phones"
"http://dbpedia.org/resource/Category:Amoi_mobile_phones"
"http://dbpedia.org/resource/Category:Casio_mobile_phones"
"http://dbpedia.org/resource/Category:Mobile_phone_manufacturers"
"http://dbpedia.org/resource/Category:Mobile_virtual_network_operators"
"http://dbpedia.org/resource/Category:Defunct_mobile_phone_companies"
"http://dbpedia.org/resource/Category:Bankrupt_mobile_phone_companies"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_by_country"
"http://dbpedia.org/resource/Category:Mobile_phone_company_logos"
"http://dbpedia.org/resource/Category:VimpelCom_Ltd."
"http://dbpedia.org/resource/Category:Defunct_mobile_phone_companies_of_the_United_States"
"http://dbpedia.org/resource/Category:Android_(operating_system)_software"
"http://dbpedia.org/resource/Category:Bada_software"
"http://dbpedia.org/resource/Category:BlackBerry_software"
"http://dbpedia.org/resource/Category:IOS_software"
"http://dbpedia.org/resource/Category:Mobile_games"
"http://dbpedia.org/resource/Category:Mobile_device_management_software"
"http://dbpedia.org/resource/Category:Windows_Phone_software"
"http://dbpedia.org/resource/Category:Windows_Mobile_software"
"http://dbpedia.org/resource/Category:Mobile_operating_systems"
"http://dbpedia.org/resource/Category:Mobile_business_software"
"http://dbpedia.org/resource/Category:Symbian_software"
"http://dbpedia.org/resource/Category:Free_mobile_software"
"http://dbpedia.org/resource/Category:Mobile_social_software"
"http://dbpedia.org/resource/Category:Mobile_instant_messaging_clients"
"http://dbpedia.org/resource/Category:Cross-platform_mobile_software"
"http://dbpedia.org/resource/Category:MeeGo_software"
"http://dbpedia.org/resource/Category:Mobile_software_programming_tools"
"http://dbpedia.org/resource/Category:Mobile_web_browsers"
"http://dbpedia.org/resource/Category:Nokia_mobile_software"
"http://dbpedia.org/resource/Category:Mobile_route-planning_software"
"http://dbpedia.org/resource/Category:Mobile_software_development"
"http://dbpedia.org/resource/Category:Mobile_software_distribution_platforms"
"http://dbpedia.org/resource/Category:China_Mobile"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Hong_Kong"
"http://dbpedia.org/resource/Category:Ufone"
"http://dbpedia.org/resource/Category:Telkom_Indonesia"
"http://dbpedia.org/resource/Category:IPhone"
"http://dbpedia.org/resource/Category:Multi-touch_mobile_phones"
"http://dbpedia.org/resource/Category:Capacitive_touchscreen_mobile_phones"
"http://dbpedia.org/resource/Category:S60_(software_platform)"
"http://dbpedia.org/resource/Category:Windows_Mobile_Standard_devices"
"http://dbpedia.org/resource/Category:UIQ_3_Phones"
"http://dbpedia.org/resource/Category:N-Gage_(service)_compatible_devices"
"http://dbpedia.org/resource/Category:IPhone"
"http://dbpedia.org/resource/Category:Huawei_Ascend"
"http://dbpedia.org/resource/Category:Windows_Phone_devices"
"http://dbpedia.org/resource/Category:Symbian_OS"
"http://dbpedia.org/resource/Category:Windows_Mobile_Professional_devices"
"http://dbpedia.org/resource/Category:Android_(operating_system)"
"http://dbpedia.org/resource/Category:MyTouch"
"http://dbpedia.org/resource/Category:HP_WebOS"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Trinidad_and_Tobago"
"http://dbpedia.org/resource/Category:Belgacom_Group"
"http://dbpedia.org/resource/Category:Android_(operating_system)_development_software"
"http://dbpedia.org/resource/Category:BlackBerry_development_software"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Isle_of_Man"
"http://dbpedia.org/resource/Category:Mobile_device_management_software"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Finland"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_New_Zealand"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Mexico"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Belarus"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Israel"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Russia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Spain"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Turkey"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Ukraine"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Morocco"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_United_States"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Australia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Denmark"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Sweden"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Canada"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_China"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Japan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Thailand"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Egypt"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Pakistan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_South_Korea"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_United_Arab_Emirates"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_India"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Indonesia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Serbia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Brunei"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Isle_of_Man"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Uzbekistan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_France"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Norway"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_El_Salvador"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Trinidad_and_Tobago"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Singapore"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Afghanistan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Netherlands"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Caribbean"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Colombia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Guatemala"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Croatia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Namibia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Albania"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Belgium"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Poland"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_North_Korea"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Portugal"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Austria"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Germany"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Montenegro"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Romania"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_United_Kingdom"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Italy"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Taiwan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Saudi_Arabia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Iran"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Abkhazia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Brazil"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Malaysia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Philippines"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Moldova"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_South_Africa"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Yemen"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Greece"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Bangladesh"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Ecuador"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Democratic_Republic_of_the_Congo"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Bulgaria"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Luxembourg"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Iraq"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Slovenia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Republic_of_Macedonia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Estonia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Libya"
"http://dbpedia.org/resource/Category:Celcom"
"http://dbpedia.org/resource/Category:Mobile_software_programming_tools"
"http://dbpedia.org/resource/Category:Mobile_software_distribution_platforms"
"http://dbpedia.org/resource/Category:Belgacom_Group"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_by_country"

* Store all collected categories in dbp_exc_cat_L0-L2.txt

Content of file:

"http://dbpedia.org/resource/Category:Mobile_phones"
"http://dbpedia.org/resource/Category:Defunct_mobile_phone_companies"
"http://dbpedia.org/resource/Category:Bankrupt_mobile_phone_companies"
"http://dbpedia.org/resource/Category:Fictional_televisual_devices"
"http://dbpedia.org/resource/Category:Mobile_phones"
"http://dbpedia.org/resource/Category:Telepresence"
"http://dbpedia.org/resource/Category:Webcams"
"http://dbpedia.org/resource/Category:Palm_OS_devices"
"http://dbpedia.org/resource/Category:Motorola_mobile_phones"
"http://dbpedia.org/resource/Category:Samsung_mobile_phones"
"http://dbpedia.org/resource/Category:Sharp_Corporation_mobile_phones"
"http://dbpedia.org/resource/Category:NEC_mobile_phones"
"http://dbpedia.org/resource/Category:Handspring_mobile_phones"
"http://dbpedia.org/resource/Category:Kyocera_mobile_phones"
"http://dbpedia.org/resource/Category:Siemens_mobile_phones"
"http://dbpedia.org/resource/Category:Sendo_mobile_phones"
"http://dbpedia.org/resource/Category:First_International_Computer_mobile_phones"
"http://dbpedia.org/resource/Category:Sierra_Wireless_mobile_phones"
"http://dbpedia.org/resource/Category:Intel_Corporation_mobile_phones"
"http://dbpedia.org/resource/Category:Sony_Ericsson_mobile_phones"
"http://dbpedia.org/resource/Category:INQ_mobile_phones"
"http://dbpedia.org/resource/Category:BlackBerry_(company)_mobile_phones"
"http://dbpedia.org/resource/Category:Alcatel_mobile_phones"
"http://dbpedia.org/resource/Category:Group_Sense_PDA_mobile_phones"
"http://dbpedia.org/resource/Category:Sanyo_mobile_phones"
"http://dbpedia.org/resource/Category:Dell_mobile_phones"
"http://dbpedia.org/resource/Category:Toshiba_mobile_phones"
"http://dbpedia.org/resource/Category:Asus_mobile_phones"
"http://dbpedia.org/resource/Category:Haier_mobile_phones"
"http://dbpedia.org/resource/Category:Hyundai_mobile_phones"
"http://dbpedia.org/resource/Category:Acer_mobile_phones"
"http://dbpedia.org/resource/Category:Orange_mobile_phones"
"http://dbpedia.org/resource/Category:ZTE_mobile_phones"
"http://dbpedia.org/resource/Category:Nokia_mobile_phones"
"http://dbpedia.org/resource/Category:Apple_Inc._mobile_phones"
"http://dbpedia.org/resource/Category:IBM_mobile_phones"
"http://dbpedia.org/resource/Category:Safran_mobile_phones"
"http://dbpedia.org/resource/Category:HTC_Corporation_mobile_phones"
"http://dbpedia.org/resource/Category:Palm_mobile_phones"
"http://dbpedia.org/resource/Category:Hitachi_mobile_phones"
"http://dbpedia.org/resource/Category:Garmin_mobile_phones"
"http://dbpedia.org/resource/Category:BenQ_mobile_phones"
"http://dbpedia.org/resource/Category:LG_Electronics_mobile_phones"
"http://dbpedia.org/resource/Category:Amoi_mobile_phones"
"http://dbpedia.org/resource/Category:Casio_mobile_phones"
"http://dbpedia.org/resource/Category:Mobile_phone_manufacturers"
"http://dbpedia.org/resource/Category:Mobile_virtual_network_operators"
"http://dbpedia.org/resource/Category:Defunct_mobile_phone_companies"
"http://dbpedia.org/resource/Category:Bankrupt_mobile_phone_companies"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_by_country"
"http://dbpedia.org/resource/Category:Mobile_phone_company_logos"
"http://dbpedia.org/resource/Category:VimpelCom_Ltd."
"http://dbpedia.org/resource/Category:Defunct_mobile_phone_companies_of_the_United_States"
"http://dbpedia.org/resource/Category:Android_(operating_system)_software"
"http://dbpedia.org/resource/Category:Bada_software"
"http://dbpedia.org/resource/Category:BlackBerry_software"
"http://dbpedia.org/resource/Category:IOS_software"
"http://dbpedia.org/resource/Category:Mobile_games"
"http://dbpedia.org/resource/Category:Mobile_device_management_software"
"http://dbpedia.org/resource/Category:Windows_Phone_software"
"http://dbpedia.org/resource/Category:Windows_Mobile_software"
"http://dbpedia.org/resource/Category:Mobile_operating_systems"
"http://dbpedia.org/resource/Category:Mobile_business_software"
"http://dbpedia.org/resource/Category:Symbian_software"
"http://dbpedia.org/resource/Category:Free_mobile_software"
"http://dbpedia.org/resource/Category:Mobile_social_software"
"http://dbpedia.org/resource/Category:Mobile_instant_messaging_clients"
"http://dbpedia.org/resource/Category:Cross-platform_mobile_software"
"http://dbpedia.org/resource/Category:MeeGo_software"
"http://dbpedia.org/resource/Category:Mobile_software_programming_tools"
"http://dbpedia.org/resource/Category:Mobile_web_browsers"
"http://dbpedia.org/resource/Category:Nokia_mobile_software"
"http://dbpedia.org/resource/Category:Mobile_route-planning_software"
"http://dbpedia.org/resource/Category:Mobile_software_development"
"http://dbpedia.org/resource/Category:Mobile_software_distribution_platforms"
"http://dbpedia.org/resource/Category:China_Mobile"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Hong_Kong"
"http://dbpedia.org/resource/Category:Ufone"
"http://dbpedia.org/resource/Category:Telkom_Indonesia"
"http://dbpedia.org/resource/Category:IPhone"
"http://dbpedia.org/resource/Category:Multi-touch_mobile_phones"
"http://dbpedia.org/resource/Category:Capacitive_touchscreen_mobile_phones"
"http://dbpedia.org/resource/Category:S60_(software_platform)"
"http://dbpedia.org/resource/Category:Windows_Mobile_Standard_devices"
"http://dbpedia.org/resource/Category:UIQ_3_Phones"
"http://dbpedia.org/resource/Category:N-Gage_(service)_compatible_devices"
"http://dbpedia.org/resource/Category:IPhone"
"http://dbpedia.org/resource/Category:Huawei_Ascend"
"http://dbpedia.org/resource/Category:Windows_Phone_devices"
"http://dbpedia.org/resource/Category:Symbian_OS"
"http://dbpedia.org/resource/Category:Windows_Mobile_Professional_devices"
"http://dbpedia.org/resource/Category:Android_(operating_system)"
"http://dbpedia.org/resource/Category:MyTouch"
"http://dbpedia.org/resource/Category:HP_WebOS"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Trinidad_and_Tobago"
"http://dbpedia.org/resource/Category:Belgacom_Group"
"http://dbpedia.org/resource/Category:Android_(operating_system)_development_software"
"http://dbpedia.org/resource/Category:BlackBerry_development_software"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Isle_of_Man"
"http://dbpedia.org/resource/Category:Mobile_device_management_software"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Finland"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_New_Zealand"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Mexico"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Belarus"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Israel"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Russia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Spain"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Turkey"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Ukraine"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Morocco"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_United_States"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Australia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Denmark"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Sweden"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Canada"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_China"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Japan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Thailand"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Egypt"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Pakistan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_South_Korea"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_United_Arab_Emirates"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_India"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Indonesia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Serbia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Brunei"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Isle_of_Man"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Uzbekistan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_France"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Norway"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_El_Salvador"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Trinidad_and_Tobago"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Singapore"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Afghanistan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Netherlands"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Caribbean"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Colombia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Guatemala"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Croatia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Namibia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Albania"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Belgium"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Poland"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_North_Korea"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Portugal"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Austria"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Germany"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Montenegro"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Romania"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_United_Kingdom"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Italy"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Taiwan"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Saudi_Arabia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Iran"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Abkhazia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Brazil"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Malaysia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Philippines"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Moldova"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_South_Africa"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Yemen"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Greece"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Bangladesh"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Ecuador"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Democratic_Republic_of_the_Congo"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Bulgaria"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Luxembourg"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Iraq"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Slovenia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_the_Republic_of_Macedonia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Estonia"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_of_Libya"
"http://dbpedia.org/resource/Category:Celcom"
"http://dbpedia.org/resource/Category:Mobile_software_programming_tools"
"http://dbpedia.org/resource/Category:Mobile_software_distribution_platforms"
"http://dbpedia.org/resource/Category:Belgacom_Group"
"http://dbpedia.org/resource/Category:Mobile_phone_companies_by_country"
"http://dbpedia.org/resource/Category:History_of_mobile_phones"
"http://dbpedia.org/resource/Category:Videotelephony"
"http://dbpedia.org/resource/Category:Mobile_phone_culture"
"http://dbpedia.org/resource/Category:Mobile_phone_standards"
"http://dbpedia.org/resource/Category:QWERTY_mobile_phones"
"http://dbpedia.org/resource/Category:Mobile_phone_companies"
"http://dbpedia.org/resource/Category:Mobile_phones_by_company"
"http://dbpedia.org/resource/Category:Satellite_telephony"
"http://dbpedia.org/resource/Category:Mobile_software"
"http://dbpedia.org/resource/Category:Open-source_mobile_phones"
"http://dbpedia.org/resource/Category:Mobile_phone_recycling"
"http://dbpedia.org/resource/Category:Smartphones"
"http://dbpedia.org/resource/Category:Touchscreen_mobile_phones"
"http://dbpedia.org/resource/Category:Watch_phones"
"http://dbpedia.org/resource/Category:Mobile_device_management"
"http://dbpedia.org/resource/Category:Mobile_phones_with_stereo_camera"
"http://dbpedia.org/resource/Category:Mobile_phone_industry_by_country"
"http://dbpedia.org/resource/Category:Solar_powered_mobile_phones"

* Sort and make unique
* Search for all articles of these categories (Level0 + Level 1 + Level 2):
while read line; do curl -H "Accept:text/csv" --data-urlencode "query=SELECT DISTINCT ?s FROM <http://dbpedia39.org> WHERE {?s <http://purl.org/dc/terms/subject> <$line>.}" http://141.52.219.233:8890/sparql >>all_pages_of_cat_L1+L2.csv; done < dbp_exc_cat_L0-L2_uniq.txt

* Take only triples where the articles are subjects:

Pseudocode:

CONSTRUCT { <$line_from_articletextfile> ?p ?o }
FROM <http://dbpedia39.org>
WHERE  { <$line_from_articletextfile> ?p ?o. }

"UNION"

CONSTRUCT {<$line_from_categoriestextfile> ?y ?z}
FROM <http://dbpedia39.org>
WHERE { <$line_from_categoriestextfile> ?y ?z.}


* In practice:
while read line; do curl -H "Accept:text/rdf+nt" --data-urlencode "query=CONSTRUCT { <$line> ?p ?o } FROM <http://dbpedia39.org> WHERE { <$line> ?p ?o. }" http://141.52.219.233:8890/sparql >>dbp_exc_all_triples_of_pages.nt; done < all_pages_of_cat_L1+L2_uniq.txt
&&
while read line; do curl -H "Accept:text/rdf+nt" --data-urlencode "query=CONSTRUCT { <$line> ?p ?o } FROM <http://dbpedia39.org> WHERE { <$line> ?p ?o. }" http://141.52.219.233:8890/sparql >>dbp_exc_all_triples_of_cat_L0-L2.nt; done < dbp_exc_cat_L0-L2_uniq.txt

* Import both nt-files into the triple store, correct possible syntactic errors (lines 39396 in pages.nt, 118339 in pages.nt).