https://bugzilla.wikimedia.org/show_bug.cgi?id=59351
--- Comment #6 from Bugzilla Bug Importer (valhallasw)
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: ACNiklas <w...@bietenbeck.net>
Date: Sat, 28 Aug 2010 09:26:58
-------------------------------------------------------------------------------
Ok, so I have now the following queries:
SELECT page_title,page_len,rev_timestamp FROM page JOIN revision ON
page_latest=rev_id WHERE page_namespace=0 AND page_title IN (art1, art2..)
LIMIT 1;
SELECT page_title,page_len,rev_timestamp FROM page JOIN revision ON
page_latest=rev_id WHERE page_namespace=1 AND page_title IN (art1, art2..)
LIMIT 1;
SELECT page_title,COUNT AS number FROM (SELECT DISTINCT
page_title,rev_user_text FROM page JOIN revision ON page_id=rev_page WHERE
page_namespace=0 AND page_title = IN (art1, art2..)) AS dummy;
(art1, art2 ...) is
("Vagina", "Vulva", "Borderline-Persönlichkeitsstörung", "Penis",
"Lyme-Borreliose", "Multiple_Sklerose", "Analverkehr", "Klitoris",
"Schamhaarentfernung", "Schwangerschaft", "Burnout-Syndrom",
"Konfektionsgröße", "Hämorrhoiden", "Depression", "Schamlippe", "Orgasmus",
"Schizophrenie", "Pfeiffer-Drüsenfieber", "Penis_des_Menschen",
"Diabetes_mellitus", "Fisting", "Ejakulation", "Herz", "Weibliche_Ejakulation",
"Lupus_erythematodes", "Thrombose", "Ethanol", "Autismus", "Herpes_Zoster",
"Morbus_Crohn", "AIDS", "Syphilis", "Magnetresonanztomographie", "Erektion",
"Warze", "Gicht", "Gold", "Bandscheibenvorfall", "Amphetamin",
"Asperger-Syndrom", "Arthrose", "Body-Mass-Index", "Tuberkulose", "Schuhgröße",
"Narzissmus", "Windpocken", "Kokain", "Bipolare_Störung",
"Parkinson-Krankheit", "Homöopathie", "Epilepsie", "Büstenhalter",
"Blutgruppe", "Hitzeschaden", "Demenz", "Kondom", "Hand-Fuß-Mund-Krankheit",
"Empathie", "Gonorrhoe", "Herpes_simplex", "Lorenzos_Öl", "Schilddrüse",
"Down-Syndrom", "Vaginalverkehr", "Blutdruck", "Leukämie", "Chlamydien",
"Staphylococcus_aureus", "Anus", "Atopisches_Ekzem", "Bettwanze",
"Lungenentzündung", "PH-Wert", "Fibromyalgie", "Suizid", "Meningitis",
"Ibuprofen", "Hepatitis_B", "Nesselsucht", "Menstruationszyklus", "Adipositas",
"Amyotrophe_Lateralsklerose", "Sperma", "Lungenembolie", "Geschlechtsorgan",
"Hashimoto-Thyreoiditis", "Alkoholkrankheit",
"Gesetzliche_Krankenversicherung", "Weibliche_Brust", "Malaria",
"Schlaganfall", "Marihuana", "Leistenbruch", "Zirkumzision", "Prostata",
"Glucose", "Anämie", "Fersensporn", "Laktoseintoleranz",
"Klitorisvorhautpiercing")
What else do I have to do to get these queries executed?
Thanks,
Andreas
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
