Difference between revisions of "Workdocumentation 2020-08-26"
Heike.Rohde (talk | contribs) (→Betroffene Events) |
Heike.Rohde (talk | contribs) (→Betroffene Events) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 61: | Line 61: | ||
| [[ICRE 2017]] ||{{#ask:[[Acronym::ICRE 2017]]}} ||2 ||(Nicht löschbare doppelte Einträge) | | [[ICRE 2017]] ||{{#ask:[[Acronym::ICRE 2017]]}} ||2 ||(Nicht löschbare doppelte Einträge) | ||
|- | |- | ||
| − | | [[ICSC 2018]] ||{{#ask:[[Acronym::ICSC 2018]]}} ||2 || | + | | [[ICSC 2018]] ||{{#ask:[[Acronym::ICSC 2018]]}} ||2 ||v,(sind zwei verschied. Veranstaltungen) |
|- | |- | ||
| [[IEEE SCPA 2012]] ||{{#ask:[[Acronym::IEEE SCPA 2012]]}} ||2 ||v, heißt jetzt SCPA 2012 | | [[IEEE SCPA 2012]] ||{{#ask:[[Acronym::IEEE SCPA 2012]]}} ||2 ||v, heißt jetzt SCPA 2012 | ||
| Line 85: | Line 85: | ||
| [[NASSUE 2009]] ||{{#ask:[[Acronym::NASSUE 2009]]}} ||2 ||v | | [[NASSUE 2009]] ||{{#ask:[[Acronym::NASSUE 2009]]}} ||2 ||v | ||
|- | |- | ||
| − | | [[OpenSuCo @ SC 2017]] ||{{#ask:[[Acronym::OpenSuCo @ SC 2017]]}} ||2 || | + | | [[OpenSuCo @ SC 2017]] ||{{#ask:[[Acronym::OpenSuCo @ SC 2017]]}} ||2 || (Nicht löschbare doppelte Einträge) |
|- | |- | ||
| [[PSATS 2012]] ||{{#ask:[[Acronym::PSATS 2012]]}} ||2 ||v | | [[PSATS 2012]] ||{{#ask:[[Acronym::PSATS 2012]]}} ||2 ||v | ||
Latest revision as of 17:53, 15 October 2020
Contents
Acronyme, die für mehrere Events verwendet wurden
Beispiel:
{{#ask:[[Acronym::WWW 2011]]}}
SQL-Query
sqlite3 Datenbank von http://ptp.bitplan.com verwendet ...
select '|-n| [[' || acronym || ']]' as acronym, '||{{#ask:[[Acronym::' || acronym || ']]}}' as events, '||' || count(*) as anzahl
from event_or
group by acronym
having(count(*)>1)
order by acronym
-n muss noch mit editor auf "\n" geändert werden damit die Tabelle unten gefüllt werden kann:
Betroffene Events
Sehr lange Acronyme
SQL Query
select '|-n| [[' || acronym || ']]' as acronym, '||[[:' || title || ']]' as event, '||' || length(acronym) as acronymLen from event_or order by length(acronym) desc limit 150
