dewiki: query page_ids for given page_titles (in main namespace)

This query is marked as a draft This query has been published by MisterSynergy.
SQL

USE dewiki_p;

SELECT
	page_id,
    page_title
FROM
	page
WHERE
	page_namespace=0 AND
    page_title IN (
      	"Urotropin", "Nonylphenolethoxylate", "Petroleum", "Lithiumhydrid", "Γ-Butyrolacton", "Cyclobutan", "Cyclopropan", "Maltose", "Trinitrotoluol", "1-Hexanol", "2-Hexanol", "Lithiumiodid", "Chloroform", "Quecksilber(I)-bromid", "1-Pentanol", "2-Methyl-1-propanol", "Trimethylphosphit", "(Benzothiazol-2-ylthio)methylthiocyanat", "(Chlormethyl)methylether", "(Dichlormethyl)methylether", "(Methylcyclopentadienyl)mangantricarbonyl", "Aluminiumiodid", "Formaldehyd", "Ameisensäure", "Zinkiodid", "Zinknitrat", "Ammoniumcarbonat", "Zinkphosphid", "2-Methyl-2-butanol", "2-Methylbuttersäure", "2-Methylfuran", "2-Methyl-4,6-dinitrophenol", "2-Methylundecanal", "2-Methyltetrahydrofuran", "2-Methylpentan", "2-Naphthylamin", "3-Hexanol", "Adiponitril", "Cyclooctan", "Calciumperoxid", "Natriumhydroxid", "Asbest", "Milchsäure", "1,1,1,2-Tetrachlorethan", "Zinkselenid", "Zinkstearat", "Zinksulfat", "Zinksulfid", "Cyclopentan", "Cellulose", "Senfgas", "Bismutsubsalicylat", "Bromcyclohexan", "Styphninsäure", "Triacetin", "Salpetersäure", "Citronensäure", "Phenylalanin", "Schwefelwasserstoff", "1,2-Naphthochinon", "Wasserstoffperoxid", "Zimtsäuremethylester", "Zimtsäureethylester", "Zineb", "Zink-Pyrithion", "Zinkacetat", "Zinkbromid", "Zinkchromat", "Zinkchlorid", "Zinkcyanid", "Zinkhydroxid", "Kupfersulfat", "1,1,1-Trifluorethan", "1,1,1-Trimethylolpropan", "1,1,2,2-Tetrabromethan", "1,1,1-Trichlorethan", "1,1,2,2-Tetrachlorethan", "1,1,2-Trichlor-1,2,2-trifluorethan", "1,1,2-Trichlorethan", "Quecksilber(II)-bromid", "Quecksilber(I)-chlorid", "Arginin", "Gold(III)-chlorid", "Königswasser", "Zinn(II)-fluorid", "Zinn(II)-chlorid", "Zinn(II)-oxid", "Zinn(II)-sulfat", "Zinn(II)-sulfid", "2-Nitropropan", "2-Phenylethanol", "2-Pentanon", "2-Phenylphenol", "Stearinsäure", "Palmitinsäure", "Pyridin", "Bleiazid", "Cumarin", "1-Heptanol", "1,1-Dichlorethan", "1,1-Difluorethen", "1,1-Dichlorethen", "1,1-Difluorethan", "1,1-Dimethylhydrazin", "1,2,4-Triazol", "1,2,3-Trichlorpropan", "1,2-Butandiol", "1,2-Diaminopropan", "1,2-Dibrom-3-chlorpropan", "1,2-Dibromethan", "1,2-Dibrompropan", "1,2-Dichlorethen", "1,2-Dibromtetrafluorethan", "Quecksilber(II)-oxid", "Anisaldehyd", "Di-tert-butyldicarbonat", "2-Chlorphenol", "Aluminiumoxid", "Paraffin", "Zinn(IV)-chlorid", "Zinn(IV)-sulfid", "Ammoniumfluorid", "Natriumperoxid", "Ziram", "2-Pentanol", "Chlorwasserstoff", "Cyclohexan", "Glucono-1,5-lacton", "Kongorot", "Triphenylphosphan", "Disilan", "Siliciumdioxid", "Cyclododecan", "Kaliumiodid", "1,2-Dichlorpropan", "1,2-Dichlorethan", "1,2-Dimethylhydrazin", "1,2-Propandiol", "1,3-Diaminopropan", "1,3-Butandiol", "1,3-Butadien", "1,3-Propandiol", "1,4-Butandiol", "1,4-Dichlorbutan", "Kaliumnitrat", "Agar", "Asparaginsäure", "Zirconium(IV)-chlorid", "Bariumchromat", "Schweflige_Säure", "Theobromin", "Silbernitrat", "Ölsäure", "Natriumsulfat", "Salpetrige_Säure", "Ferrocen", "Xylit", "Melamin", "Cobalt(III)-oxid", "2-Butoxyethylacetat", "Tebuthiuron", "Thiophanat-methyl", "Nitroguanidin", "Folsäure", "Trypsine", "Lactose", "1,4-Dichlorbenzol", "1,4-Dioxan", "1,4-Naphthochinon", "1,5-Cyclooctadien", "1,5-Hexadien", "1,5-Diaminopentan", "1,5-Pentandiol", "1,6-Hexandiol", "1,8-Cineol", "1-Aminopropan-2-ol", "1-Brompropan", "2,3,3,3-Tetrafluorpropen", "Gelatine", "Amphetamin", "Quecksilbersulfid", "Cadmiumsulfid", "Mononatriumglutamat", "Pyrimidin", "Stickstoffmonoxid", "Monophosphan", "Stickstoffdioxid", "Aflatoxine", "Bernsteinsäure", "Brenztraubensäure", "Magnesiumoxid", "Zirconylchlorid", "Zinn(IV)-oxid", "Phenol", "Riboflavin", "1-Butin", "1-Chlor-2-propanol", "1-Chlor-1,1-difluorethan", "1-Chlornaphthalin", "1-Chlorpentan", "1-Chlorbutan", "1-Chlorpropan", "1-Dodecanol", "1-Dodecen", "1-Hexadecanol", "1-Hexen", "1-Iodpropan", "1-Hydroxybenzotriazol", "1-Naphthylamin", "1-Methylnaphthalin", "Naphthalin", "Natriumhydrogencarbonat", "Mangan(II)-acetat", "Tryptophan", "Xylole", "Calciumchlorid", "2,2,3-Trimethylbutan", "2,2,4-Trimethylpentan", "2,2-Dimethylbutan", "2,2′-Bipyridin", "Eisen(II)-sulfat", "Blei(II)-nitrat", "Silberchlorid", "Alanin", "Adrenalin", "Ethin", "Dichlordiphenyltrichlorethan", "Phoxim", "Zimtsäure", "Methacrylsäure", "Propargit", "Fentinacetat", "Guanin", "Metronidazol", "Calciumhydroxid", "Serin", "2-Methylhexan", "Natriumnitrat", "2,5-Dimethylfuran", "2,5-Hexandion", "2,6-Dimethyl-4-tridecylmorpholin", "2,6-Lutidin", "2-(4-tert-Butylbenzyl)propionaldehyd", "2-(2-Aminoethylamino)ethanol", "2-Acrylamido-2-methylpropansulfonsäure", "2-Brombutan", "2-Brompropan", "2-Butin-1,4-diol", "Butylhydroxytoluol", "Triphenylphosphit", "Acetoncyanhydrin", "3,3′-Dimethoxybenzidin", "3,3-Dimethyl-2-butanon", "3,3′-Dichlorbenzidin", "3,5-Dinitrosalicylsäure", "Propan", "Naturkautschuk", "Acesulfam", "Kaliumhydroxid", "Strontiumhydroxid", "Glycerin", "1-Nonanol", "1-Naphthylessigsäure", "1-Octanol", "1-Octen-3-ol", "1-Octen", "1-Propanthiol", "1-Tetradecanol", "1-Undecanol", "1-Tridecanol", "Diisobutylphthalat", "Nitroglycerin", "Campher", "Glutamin", "Ammoniumnitrat", "2,3-Butandiol", "2,3-Dimethylbutan", "2,4,6-Tribromphenol", "2,4,5-Trichlorphenoxyessigsäure", "2,4,6-Trichlorphenol", "2,4-Diaminotoluol", "2,4-Dihydroxybenzoesäure", "2,4-Dichlorphenol", "2,4-Dinitrochlorbenzol", "2,4-Dichlorphenoxyessigsäure", "2,4-Dinitrophenol", "2,4-Dinitrophenylhydrazin", "Ephedrin", "Benzotriazol", "Calciumformiat", "Essigsäureisopentylester", "N-Butan", "N-Butan", "Talk_(Mineral)", "Nicotinsäure", "Cis-9-Tricosen", "Aluminiumhydroxychlorid", "N-Methylformamid", "Chlorsäure", "Triethylamin", "Ergocalciferol", "Kaliumchlorid", "Phosphorsäure", "Oxalsäure", "Calciumoxid", "2-Butanol", "2-Butin", "2-Chlor-2-methylpropan", "2-Chlorbutan", "2-Chloracetamid", "2-Chlorethanol", "3-Aminobenzoesäure", "3-Brompropen", "3-Chlor-1,2-propandiol", "3-Chlorpropionsäure", "3-Ethylpentan", "3-Hexanon", "3-Hydroxy-2-butanon", "3-Hydroxybutanal", "3-Hydroxybutansäure", "3-Methylcholanthren", "3-Methylhexan", "3-Methyl-1-butanol", "3-Methylpentan", "3-Pentanon", "Tetrachlormethan", "Aluminiumbromid", "Hydroxylamin", "Quecksilber(II)-sulfat", "Natriumgluconat", "Berylliumchlorid", "Magnesiumchlorid", "Tetraethylblei", "Alizarin", "Polymethylmethacrylat", "Polystyrol", "Polyvinylalkohol", "Polyvinylchlorid", "Bentazon", "Anilin", "Cystein", "Threonin", "Tetraethylzinn", "2-Diethylaminoethanol", "2-Ethoxyethylacetat", "2-Ethylhexylacrylat", "2-Ethoxyethanol", "2-Ethylhexansäure", "2-Ethylhexanol", "2-Fluorethanol", "2-Hexanon", "2-Iodpropan", "2-Methyl-3-butin-2-ol", "2-Methyl-1-butanol", "5-Fluoruracil", "5-Sulfosalicylsäure", "Kaliumdichromat", "Phosphorpentabromid", "Dimethylaminoethanol", "Ursodesoxycholsäure", "Pyrrol", "Schwefeltrioxid", "Calciumphosphat", "Limonen", "Schwefelhexafluorid", "Natriumperiodat", "Lindan", "Brenzcatechin", "Kupferphthalocyanin", "Pyrethrine", "Cholecalciferol", "Fumarsäure", "Quecksilber(II)-chlorid", "Polytetrafluorethylen‎", "Tabun", "Chloropren-Kautschuk", "Polyacrylnitril", "Polyethylenterephthalat", "Phenoplast", "Lackmus", "Indanthron", "Actinomycin_D", "Noradrenalin", "Kupfer(II)-hydroxid", "2-Chlorethylphosphonsäure", "2-Chlorbenzylidenmalonsäuredinitril", "2-Chlorpropan", "2-Chlorpropionsäure", "2-Cyanacrylsäureethylester", "2-Cyanacrylsäuremethylester", "2-Chlorpyridin", "2-Cyclohexen-1-on", "4,4′-Diaminodiphenylmethan", "4-(2,4-Dichlorphenoxy)buttersäure", "4-Aminobiphenyl", "4-Aminosalicylsäure", "4-Hydroxybenzoesäure", "4-Hydroxybenzoesäureethylester", "4-Hydroxybenzoesäuremethylester", "4-Methyl-1-penten", "4-Nitropyridin-N-oxid", "4-Methylimidazol", "Adamsit", "8-Hydroxychinolin", "Isopren", "Bisphenol_A", "Chloramphenicol", "Tetrahydrofuran", "N-Nonan", "N-Decan", "N-Undecan", "N-Dodecan", "Tridecan", "Tetradecan", "Natriumamid", "Linalylacetat", "Ammoniumchlorid", "Phosgen", "Pikrinsäure", "Pikrinsäure", "Nitropenta", "Chinin", "Sulfanilsäure", "Ε-Aminocapronsäure", "Α-Linolensäure", "Tert-Butylbromid", "Quecksilber(II)-cyanid", "Benzylpenicillin", "Para-Toluolsulfonsäurechlorid", "Γ-Butyrolactam", "Essigsäure-tert-butylester", "Tert-Butanol", "P-Toluolsulfonsäure", "Kalium-tert-butanolat", "G-Strophanthin", "Kupfer(II)-nitrat", "Tert-Butylhydroperoxid", "N-Bromsuccinimid", "Cholsäure", "Pirimicarb", "Wolfram(IV)-sulfid", "Benzothiophen", "Cadmiumacetat", "Berylliumsulfat", "Calciumchlorat", "Dichlorprop", "MCPA", "Mecoprop", "N-Pentan", "N-Hexan", "N-Octan", "Borsäure", "7,12-Dimethylbenzo(a)anthracen", "Sarin", "Phenolphthalein", "Tyrosin", "Kohlenstoffdisulfid", "Furan", "Sorbit", "Dischwefeldecafluorid", "Carbonylfluorid", "Methyldiethanolamin", "Bismut(III)-oxid", "Phosphorpentachlorid", "Pikraminsäure", "Formamid", "P-Cymol", "Cyclopentanol", "Ω-Chloracetophenon", "Natriumdisulfit", "P-Aminobenzoesäure", "Meta-Chlorperbenzoesäure", "Tebufenpyrad", "Diallyldisulfid", "Essigsäurephenylester", "Chrom(III)-fluorid", "Cadmiumnitrat", "Nonanal", "Vanillinsäure", "Chlorameisensäuremethylester", "Ammoniumheptamolybdat", "Nickel(II)-bromid", "Blei(II)-fluorid", "Kupfer(I)-cyanid", "Chlorpentafluorethan", "Eisen(III)-fluorid", "Ethen", "Propen", "Butene", "Hexogen", "Zinkoxid", "Äpfelsäure", "Natriumcarbonat", "Kaliumpermanganat", "Ε-Caprolacton", "Tert-Butylamin", "Sec-Butylamin", "Magnesiumsulfat", "Chlorameisensäureethylester", "N-Propylbenzol"
    );
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
