Difference between revisions of "Workdocumentation 2020-08-26"
(→Acronyme, die für mehrere Events verwendet wurden) |
|||
| Line 1: | Line 1: | ||
= Acronyme, die für mehrere Events verwendet wurden = | = Acronyme, die für mehrere Events verwendet wurden = | ||
| − | + | Beispiel: | |
| − | |||
| − | |||
<pre> | <pre> | ||
| − | select '[[' || acronym || ']]' as acronym, count(*) as anzahl | + | {{#ask:[[Acronym::WWW 2011]]}} |
| + | </pre> | ||
| + | {{#ask:[[Acronym::WWW 2011]]}} | ||
| + | == SQL-Query == | ||
| + | sqlite3 Datenbank von http://ptp.bitplan.com verwendet ... | ||
| + | <pre> | ||
| + | select '|-n| [[' || acronym || ']]' as acronym, '||{{#ask:[[Acronym::' || acronym || ']]}}' as events, '||' || count(*) as anzahl | ||
from event_or | from event_or | ||
group by acronym | group by acronym | ||
having(count(*)>1) | having(count(*)>1) | ||
| − | order by | + | order by acronym |
| − | |||
</pre> | </pre> | ||
| + | == Betroffene Events == | ||
{|- class='wikitable sortable' | {|- class='wikitable sortable' | ||
acronym events anzahl | acronym events anzahl | ||
Revision as of 08:18, 28 August 2020
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
