Semantische Suche
Aus Aifbportal
SQLStore debug output
ASK Query
[[Kategorie:Aktivität]] [[Person::Christian Zirpins]] [[In Webseite anzeigen::wahr]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t10.o_hash
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_bool` AS t7 ON t2.s_id=t7.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_blob` AS t10 ON t0.smw_id=t10.s_id
WHERE
(t2.o_id='176085'
AND (t4.p_id='176301' AND t4.o_id='27230')
AND (
(t7.o_value='1') AND t7.p_id='176304')
)
AND (t10.p_id='176308')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t10.o_hash DESC
LIMIT
55
OFFSET
0
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t10.o_hash
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_fpt_inst` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_bool` AS t7 ON t2.s_id=t7.s_id) ON t0.smw_id=t2.s_id
INNER JOIN
`smw_di_blob` AS t10 ON t0.smw_id=t10.s_id
WHERE
(t2.o_id='176085'
AND (t4.p_id='176301' AND t4.o_id='27230')
AND (
(t7.o_value='1') AND t7.p_id='176304')
)
AND (t10.p_id='176308')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t10.o_hash DESC
LIMIT
55
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id_3 | 9 | const,const | 54 | Using temporary; Using filesort |
1 | SIMPLE | t2 | ref | s_id,o_id,s_id_2,o_id_2 | s_id_2 | 9 | kit_smw1.t4.s_id,const | 1 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | kit_smw1.t4.s_id | 1 | Using where |
1 | SIMPLE | t7 | ref | s_id,o_value | s_id | 8 | kit_smw1.t4.s_id,const | 1 | Using where |
1 | SIMPLE | t10 | ref | s_id,p_id,s_id_2 | s_id | 8 | kit_smw1.t4.s_id,const | 1 |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:5Query-Depth:1
Errors and Warnings
None- [PC member: 9th Int. Conference on Business Process Management (BPM 2011) Aktivitaet2259]
- [Pc member: 2nd Int. Work. on Empowering End-Users to Develop Service-based Applications (EUD4Services) Aktivitaet2275]
- [PC member: 5th Int. MCeTech Conf. on e-Technologies 2011 (MCeTech 2011) Aktivitaet2270]
- [PC member: 13th IEEE Conf. on Commerce and Enterprise Computing (CEC'11) Aktivitaet2265]
- [PC member: 12th Int. Conf. on Electronic Commerce and Web Technologies (EC-Web 11) Aktivitaet2260]
- [PC member: 8th Int. Conf. on Mobile Web Information Systems (MobiWIS) Aktivitaet2276]
- [PC member: 6th Int. Conf. on Internet and Web Applications and Services (ICIW 2010) Aktivitaet2271]
- [PC member: IEEE 9th International Conference on Web Services (ICWS 2011) Aktivitaet2261]
- [PC member: 4th Int. Conf. on Advances in Human-oriented and Personalized Mechanisms, Technologies, and Services (CENTRIC 2011) Aktivitaet2272]
- [Pc member: 1st Int. Work. on Flexible Workflows in Distributed Systems (WiVS 2011) Aktivitaet2273]
- [PC member: 5th Int. Conf. on Information Systems, Technology, and Management (ICISTM-2011) Aktivitaet2274]
- [PC member: 5th Int. Conf. on Internet and Web Applications and Services (ICIW 2010) Aktivitaet2058]
- [Co-Chair: 1st Int. Work. on Service Modelling and Representation Techniques (SMART 2010) Aktivitaet2269]
- [PC member: 12th IEEE Conf. on Commerce and Enterprise Computing (CEC'10) Aktivitaet2264]
- [PC member: 3rd Int. Conf. on Advances in Human-oriented and Personalized Mechanisms, Technologies, and Services (CENTRIC 2010) Aktivitaet2059]
- [Steering Committee Member: ACM/GI regional group Karlsruhe Aktivitaet2054]
- [PC member: 1st Int. Conf. on Pervasive Networked Services and Internet of Things (PNSIOT 2010) Aktivitaet2060]
- [Co-Chair: 6th Int. Work. on Engineering Service-Oriented Applications (WESOA 2010) Aktivitaet2266]
- [PC member: 11th Int. Conf. on Electronic Commerce and Web Technologies (EC-Web 10) Aktivitaet2061]
- [Demo Chair, Finance Chair: 8th Int. Conf. on Service Oriented Computing (ICSOC 2010) Aktivitaet2267]
- [PC member: Int. Work. on Petri Nets and Software Engineering (PNSE'10) Aktivitaet2262]
- [PC member: 8th Int. Conf. on Business Process Management (BPM2010) Aktivitaet2062]
- [Co-Chair: 4th Int. Work. on Web APIs and Services Mashups (Mashups'10) Aktivitaet2268]
- [PC member: Int. Conf. on Internet Technologies & Society (ITS 2010) Aktivitaet2263]
- [PC member: IEEE 8th International Conference on Web Services (ICWS 2010) Aktivitaet2063]
- [Co-Chair: WESOA 2009 - Fifth International Workshop on Engineering Service-Oriented Applications, Stockholm, Sweden, November 23rd 2009 Aktivitaet2044]
- [PC member MCeTech 2009: 4th International MCETECH Conference on e-Technologies, 4-6 May 2009, Ottawa, Canada Aktivitaet1230]
- [PC member: 5th Int. Work. on Modelling of Objects, Components, and Agents (MOCA09) Aktivitaet2055]
- [PC member: SOFSEM 2009 - Conference on Current Trends in Theory and Practice of Computer Science January 24-30, 2009, Spindleruv Mlyn, Czech Republic Aktivitaet1234]
- [PC member: EC-Web 09 - 10th International Conference on Electronic Commerce and Web Technologies, Linz, Austria 31 Aug - 4 Sep 2009 Aktivitaet1228]
- [PC member: 3rd Int. Work. on Web APIs and Services Mashups (Mashups09) Aktivitaet2056]
- [PC member: CENTRIC 2009 - Conf. on Advances in Human-oriented and Personalized Mechanisms, Technologies, and Services, Sep 2009, Porto, Portugal Aktivitaet1231]
- [PC member: ICIW 2009 - 4th International Conference on Internet and Web Applications and Services May 24-28, 2009 - Venice/Mestre, Italy Aktivitaet1232]
- [PC member: PESOS 2009 - Workshop on Principles of Engineering Service Oriented Systems, May 18-19 2009, Vancouver, Canada Aktivitaet1229]
- [PC member: PNSE'09 - International Workshop on Petri Nets and Software Engineering Paris, France, June 22/23, 2009 Aktivitaet1239]
- [PC member: 1st Int. Work. on Organizational Modeling (ORGMOD 2009) Aktivitaet2057]
- [Reviewer: Journal of Systems and Software Aktivitaet1246]
- [PC member: MCeTech 2008 - 3rd International MCETECH Conference on e-Technologies, January 23-25, 2008, Montreal, Canada Aktivitaet1238]
- [PC member: PNDS'08 - International Workshop on Petri Nets and Distributed Systems, Xi'an, China, June 23-24, 2008 Aktivitaet1236]
- [PC member: ICIW 2008 - The Third International Conference on Internet and Web Applications and Services, June 8-13, 2008 - Athens, Greece Aktivitaet1237]
- [Reviewer: Management Research News Aktivitaet1248]
- [Co-Chair & PC Member: WESOA 2008 - 4th Int. Workshop on Engineering Service Oriented Applications, Sydney, Australia, December 1st, 2008 Aktivitaet1235]
- [Reviewer: ACM Transactions on the Web Aktivitaet1242]
- [Reviewer: Service-Oriented Computing and Applications Aktivitaet1243]
- [Reviewer: Information & Software Technology Aktivitaet1245]
- [Reviewer: ACM Transactions on Internet Technology Aktivitaet1241]
- [Reviewer: Distributed and Parallel Databases (DPDB) Aktivitaet1244]
- [Reviewer: IEEE Transactions on Software Engineering Aktivitaet1240]
- [Reviewer: IBM Systems Journal Aktivitaet1247]
- [Member: Association for Computing Machinery (ACM) Aktivitaet1249]