Semantische Suche
Aus Aifbportal
SQLStore debug output
ASK Query
[[Kategorie:Veranstaltung||News]]
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, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='176110')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
70
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, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.o_id='176110')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
70
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id,o_id,s_id_2,o_id_2 | o_id_2 | 5 | const | 216 | Using index; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | kit_smw1.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:0
Errors and Warnings
None- F. Allerding
- F.H. Rios
- Fabian Flöck2
- Felix Keppmann - Decentralized Control in Distributed Applications via Web and Semantic Web Technologies
- Frank Dengler2
- Grad-Vortrag
- Grad.-Vortrag Hans-Jörg Happel
- Grad.-Vortrag Heiko Haller
- Grad.Koll.
- Grad.Vortrag Holger Lewen
- Grad.Vortrag Markus Krötzsch
- Graduiertenkolloquium Mischa Ahrens
- Graduiertenkolloquium Tarek Saier
- Gravitation and Fitness in Ontology Dynamics
- Ignacio Traverso
- Informationsarchitekturen für integrierte kundenorientierte Anreizsysteme im Energiesystem
- Instance Matching for Heterogeneous Structured Data
- Integration von multidimensionalen Datensätzen aus dem Web für analytische Abfragen
- Integriertes Gebäude-Energiemanagement
- Intelligent algorithms based on Fish School for optimization in complex domains
- Internet of Everything
- Jan Müller2
- Joachim Kleb
- Julia Hoxha2
- Julia Hoxha3
- Jürgen Bock
- K.A.
- K.A.2
- K.A.3
- K.a.
- Karlsruhe Service Summer 2010
- Kollaborative Softwareentwicklung auf Basis serviceorientierter Architekturen
- Kolloquium DHerzig
- Kolloquium Verabschiedung Professor Dr. Thomas Wolf
- Kompetenzorientiertes E-Assessment für die grafische Modellierung in der Hochschullehre
- Kontextsensitive Ausnahmebehandlung in Geschäftsprozessen
- Large-Scale Pattern-Based Information Extraction from the World Wide Web
- Lastoptimierte Prüfstandsplanung in der Automobilindustrie
- Lei Zhang2
- Leveraging Literals for Knowledge Graph Embeddings
- Linked Data supported Information Retrieval
- Lukas König Grad.Kolloquium
- M.Decker
- MSc. Nugroho Fredivianus
- Machine Learning Techniques for Knowledge Graphs and Natural Language Processing
- Maik Herfurth2
- Marc Mültin2
- Marc Mültin3
- Maribel Acosta2
- Marlon Braun2