Workdocumentation 2020-08-26

From Openresearch
Revision as of 08:19, 28 August 2020 by Wf (talk | contribs) (SQL-Query)
Jump to: navigation, search

Acronyme, die für mehrere Events verwendet wurden

Beispiel:

{{#ask:[[Acronym::WWW 2011]]}}

WWW 2011, WWW 2013, WWW 2014

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

acronym events anzahl (null) (null) ||809
ACAH 2013 ACAH 2013 2
ACERP 2013 ACERP 2013 2
ACP 2013 ACP 2013 2
BIOSIGNALS 2009 BIOSIGNALS 2009 2
BIOSIGNALS 2012 BIOSIGNALS 2012 2
CAADRIA 2019 CAADRIA 2019 2
CADE 2017 CADE 2017 2
CAiSE 2017 CAiSE 2017 2
EDBT 2008 EDBT 2008, EDBTW PhD 2008 2
ESWC 2016 ESWC 2016 2
Gift-ACLA 2017 Gift-ACLA 2017, Gift-ACLA 2017 : The Gift in Literature: ACLA Seminar 2
HFR 2017 HFR 2017, HFR 2017 : 10th International Workshop on Human-Friendy Robotics (Springer SPAR Proceedings) 2
ICADL 2018 ICADL 2018 2
ICBSB 2017 ICBSB 2017, ICBSB 2017 : 2017 2nd International Conference on Biomedical Signal and Bioinformatics (ICBSB 2017)--Ei Compendex and Scopus 2
ICC 2009 ICC 2009 2
ICEDEG 2017 ICEDEG 2017 2
ICIAR 2011 SS ICIAR 2011 SS 2
ICIS 2016 ICIS 2016, ICIS 20162 2
ICRE 2017 ICRE 2017, ICRE 2017 : 2017 3rd International Conference on Reliability Engineering (ICRE 2017)--SCOPUS, Ei Compendex 2
ICSC 2018 ICSC 2018, ICSC 2018 : 12th IEEE International Conference on Semantic Computing (ICSC 2018) 2
IEEE SCPA 2012 2
IJCSI-March-2011 Call-For-Papers-IJCSI-May-2011, Call-For-Papers-IJCSI-November-2011, IJCSI-March-2011 3
IJCSIS 2009 IJCSIS 2009, IJCSIS 20092 2
IMECS 2012 IMECS 2012 2
ISEC 2013 ISEC 2013 2
ISUVR 2009 ISUVR 2009 2
ISWC 2017 ISWC 2017 2
JIST 2017 JIST 2017, JIST 2017 : 7th Joint International Semantic Technology Conference 2
KES AMSTA 2010 KES AMSTA 2010 2
KMIS 2
NASSUE 2009 NASSUE 2009 2
OpenSuCo @ SC 2017 OpenSuCo @ SC 2017 : 2017 Workshop on Open Source Supercomputing (OpenSuCo-2017), OpenSuCo2 2017 2
PSATS 2012 PSATS 2012 2
RTAS 2020 RTAS 2020 2
SCIPCV 2010 SCIPCV 2010 2
SCIPCV 2011 SCIPCV 2011 3
SETN 2010 SETN 2010 2
STIDS 2016 STIDS 2016 2
Science in Society Conference 2011 2
VC 2009 VC 2009 3
WACV 2017 WACV 2017, WACV 2017 : IEEE Winter Conference on Applications of Computer Vision 2
WCE 2011 WCE 2011, WCE 20112 2
WCE 2012 WCE 2012 2
WCECS 2012 WCECS 2012 2
WISE 2013 WISE 2013 2
WWW 2011 WWW 2011, WWW 2013, WWW 2014 4
AcronymWWW 2011 + and ' +